405x 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.