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: