In: Economics
An arithmetic cash flow gradient series equals $650 in year 1, $750 in year 2, and amounts increasing by $100 per year through year 12. At i = 15% per year, determine the present worth of the cash flow series in year 0.
The present worth of the cash flow series in year 0 is $
please help me with this question
Starting year 3, Cash flow in year N = [Cash flow in year (N - 1)] + $100
Present worth is computed as follows.
| Year | Cash Flow ($) | PV Factor @15% | Discounted Cash Flow ($) |
| 1 | 650 | 0.8696 | 565.22 |
| 2 | 750 | 0.7561 | 567.11 |
| 3 | 850 | 0.6575 | 558.89 |
| 4 | 950 | 0.5718 | 543.17 |
| 5 | 1050 | 0.4972 | 522.04 |
| 6 | 1150 | 0.4323 | 497.18 |
| 7 | 1250 | 0.3759 | 469.92 |
| 8 | 1350 | 0.3269 | 441.32 |
| 9 | 1450 | 0.2843 | 412.18 |
| 10 | 1550 | 0.2472 | 383.14 |
| 11 | 1650 | 0.2149 | 354.66 |
| 12 | 1750 | 0.1869 | 327.09 |
| Present Worth ($) = | 5641.89 |
Excel screenshot:
