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:
