In: Finance
Intro It is the end of 2019. You (foolishly) played the lottery and won the following cash flows, to be paid at the end of each year:
Year 2020 2021 2022 2023 2024
Cash flow 1,300 1,600 1,800 2,000 2,200
The appropriate interest rate is 11%.
What is the sum of present values?
Now assume that the interest rate is 9%. What is the present value of all cash flows?
Now assume that the interest rate is 15%. What is the present value of all cash flows?
Present Value of the cash flows if the interest rate is 11%
Year |
Annual Cash Flow ($) |
Present Value factor at 11% |
Present Value of Cash Flow ($) |
2020 |
1,300 |
0.900901 |
1,171.17 |
2021 |
1,600 |
0.811622 |
1,298.60 |
2022 |
1,800 |
0.731191 |
1,316.14 |
2023 |
2,000 |
0.658731 |
1,317.46 |
2024 |
2,200 |
0.593451 |
1,305.59 |
TOTAL |
6,408.97 |
||
Present Value of the cash flows will be $6,408.97
Present Value of the cash flows if the interest rate is 9%
Year |
Annual Cash Flow ($) |
Present Value factor at 9% |
Present Value of Cash Flow ($) |
2020 |
1,300 |
0.917431 |
1,192.66 |
2021 |
1,600 |
0.841680 |
1,346.69 |
2022 |
1,800 |
0.772183 |
1,389.93 |
2023 |
2,000 |
0.708425 |
1,416.85 |
2024 |
2,200 |
0.649931 |
1,429.85 |
TOTAL |
6,775.98 |
||
Present Value of the cash flows will be $6,775.98.
Present Value of the cash flows if the interest rate is 15%
Year |
Annual Cash Flow ($) |
Present Value factor at 15% |
Present Value of Cash Flow ($) |
2020 |
1,300 |
0.869565 |
1,130.43 |
2021 |
1,600 |
0.756144 |
1,209.83 |
2022 |
1,800 |
0.657516 |
1,183.53 |
2023 |
2,000 |
0.571753 |
1,143.51 |
2024 |
2,200 |
0.497177 |
1,093.79 |
TOTAL |
5,761.09 |
||
Present Value of the cash flows will be $5,761.09.
NOTE
The Formula for calculating the Present Value Factor is [1/(1 + r)n], Where “r” is the Discount/Interest Rate and “n” is the number of years.