In: Finance
11. A corporation promises to pay you $8 a year for 20 years and $200 after 20 years. What is the maximum amount you would pay for the security if you wanted to earn 8 percent? (5 points)
We have to calculate the present value of all future cash flows promised by corporation in following manner –
Year (n) | Cash flow (CF) | PV of cash flow at 8% | Formula used |
1 | $8 | $7.41 | CF/(1+8%)^1 |
2 | $8 | $6.86 | CF/(1+8%)^2 |
3 | $8 | $6.35 | CF/(1+8%)^3 |
4 | $8 | $5.88 | CF/(1+8%)^4 |
5 | $8 | $5.44 | CF/(1+8%)^5 |
6 | $8 | $5.04 | CF/(1+8%)^6 |
7 | $8 | $4.67 | CF/(1+8%)^7 |
8 | $8 | $4.32 | CF/(1+8%)^8 |
9 | $8 | $4.00 | CF/(1+8%)^9 |
10 | $8 | $3.71 | CF/(1+8%)^10 |
11 | $8 | $3.43 | CF/(1+8%)^11 |
12 | $8 | $3.18 | CF/(1+8%)^12 |
13 | $8 | $2.94 | CF/(1+8%)^13 |
14 | $8 | $2.72 | CF/(1+8%)^14 |
15 | $8 | $2.52 | CF/(1+8%)^15 |
16 | $8 | $2.34 | CF/(1+8%)^16 |
17 | $8 | $2.16 | CF/(1+8%)^17 |
18 | $8 | $2.00 | CF/(1+8%)^18 |
19 | $8 | $1.85 | CF/(1+8%)^19 |
20 | $208 | $44.63 | CF/(1+8%)^20 |
Total ( Sum of PVs) | $121.45 |
Therefore the maximum amount you would pay is $121.45 for the security if you wanted to earn 8 percent.
Formulas used in excel calculation: