232x Filetype XLSX File size 0.14 MB Source: financeplusinsurance.com
Net Present Value © FinancePlusInsurance Calculator All About Finance & Insurance Investment Details Investment Summary Future Value (FV) $ 0 No. of EMI Payments 20 Systematic Contribution $ 5,000 Total Investment Amount $ 100,000 Investment Frequency Annual Discounted Cash Flow (DCF) $ 57,432 Years of Investment 20 Present Value (PV) $ 42,568 nflation/Discounted Rate 10.00% Present Value IFA (PVIFA) $ 42,568 Investment Start date 1/1/2022 Net Present Value (NPV) $ 42,568 12 12 10 10 8 8 6 6 4 4 2 2 2 - 3 4 5 6 7 8 9 0 1 - 2 2 2 2 2 2 2 2 3 3 0 0 0 0 0 0 0 0 0 0 2 2 2 2 2 2 2 2 2 2 Serial Investment Starting Regular Discounted Cash Flow Ending Balance No. Date Amount Contribution (DCF) 1 1/1/2022 $ 0 $ 5,000 $ 455 $ 4,545 2 1/1/2023 $ 4,545 $ 5,000 $ 868 $ 8,678 3 1/1/2024 $ 8,678 $ 5,000 $ 1,243 $ 12,434 4 1/1/2025 $ 12,434 $ 5,000 $ 1,585 $ 15,849 5 1/1/2026 $ 15,849 $ 5,000 $ 1,895 $ 18,954 6 1/1/2027 $ 18,954 $ 5,000 $ 2,178 $ 21,776 7 1/1/2028 $ 21,776 $ 5,000 $ 2,434 $ 24,342 8 1/1/2029 $ 24,342 $ 5,000 $ 2,667 $ 26,675 9 1/1/2030 $ 26,675 $ 5,000 $ 2,880 $ 28,795 10 1/1/2031 $ 28,795 $ 5,000 $ 3,072 $ 30,723 11 1/1/2032 $ 30,723 $ 5,000 $ 3,248 $ 32,475 12 1/1/2033 $ 32,475 $ 5,000 $ 3,407 $ 34,068 13 1/1/2034 $ 34,068 $ 5,000 $ 3,552 $ 35,517 14 1/1/2035 $ 35,517 $ 5,000 $ 3,683 $ 36,833 15 1/1/2036 $ 36,833 $ 5,000 $ 3,803 $ 38,030 16 1/1/2037 $ 38,030 $ 5,000 $ 3,912 $ 39,119 17 1/1/2038 $ 39,119 $ 5,000 $ 4,011 $ 40,108 18 1/1/2039 $ 40,108 $ 5,000 $ 4,101 $ 41,007 19 1/1/2040 $ 41,007 $ 5,000 $ 4,182 $ 41,825 20 1/1/2041 $ 41,825 $ 5,000 $ 4,257 $ 42,568 Serial Investment Starting Regular Discounted Cash Flow Ending Balance No. Date Amount Contribution (DCF) Serial Investment Starting Regular Discounted Cash Flow Ending Balance No. Date Amount Contribution (DCF) Serial Investment Starting Regular Discounted Cash Flow Ending Balance No. Date Amount Contribution (DCF)
no reviews yet
Please Login to review.