In: Finance
Problem 4-14
Uneven Cash Flow Stream
| Year | Cash Stream A | Cash Stream B | 
| 1 | $100 | $300 | 
| 2 | 400 | 400 | 
| 3 | 400 | 400 | 
| 4 | 400 | 400 | 
| 5 | 300 | 100 | 
| Calculation of present value of stream A: | |||
| Time | Cashflow | PVF @6% | PV | 
| 1.00 | 100 | 0.9434 | 94.34 | 
| 2.00 | 400 | 0.8900 | 356.00 | 
| 3.00 | 400 | 0.8396 | 335.85 | 
| 4.00 | 400 | 0.7921 | 316.84 | 
| 5.00 | 300 | 0.7473 | 224.18 | 
| 1,327.20 | |||
| Present value is $1327.20 | |||
| Calculation of present value of stream B: | |||
| Time | Cashflow | PVF @6% | PV | 
| 1.00 | 300 | 0.9434 | 283.02 | 
| 2.00 | 400 | 0.8900 | 356.00 | 
| 3.00 | 400 | 0.8396 | 335.85 | 
| 4.00 | 400 | 0.7921 | 316.84 | 
| 5.00 | 100 | 0.7473 | 74.73 | 
| 1,366.43 | |||
| Present value is $1366.43 | |||
| Calculation of present value of stream A: | |||
| Time | Cashflow | PVF @0% | PV | 
| 1.00 | 100 | 1.0000 | 100.00 | 
| 2.00 | 400 | 1.0000 | 400.00 | 
| 3.00 | 400 | 1.0000 | 400.00 | 
| 4.00 | 400 | 1.0000 | 400.00 | 
| 5.00 | 300 | 1.0000 | 300.00 | 
| 1,600.00 | |||
| Present value is $1600 | |||
| Calculation of present value of stream B: | |||
| Time | Cashflow | PVF @0% | PV | 
| 1.00 | 300 | 1.0000 | 300.00 | 
| 2.00 | 400 | 1.0000 | 400.00 | 
| 3.00 | 400 | 1.0000 | 400.00 | 
| 4.00 | 400 | 1.0000 | 400.00 | 
| 5.00 | 100 | 1.0000 | 100.00 | 
| 1,600.00 | |||
| Present value is $1600 | |||