Project management assignment
joshna
paybackperiodchart.xlsSheet1
| Payback Period Chart for Project Name | ||||
| Created by: | Date: | |||
| Note: Enter the discounted costs and benefits for your project below. | ||||
| Add and delete rows as needed. | ||||
| Year | Costs | Benefits | Cum Costs | Cum Benefits |
| 0 | 140,000 | 0 | 140,000 | 0 |
| 1 | 37,200 | 186,000 | 177,200 | 186,000 |
| 2 | 34,400 | 172,000 | 211,600 | 358,000 |
| 3 | 31,600 | 158,000 | 243,200 | 516,000 |
Sheet1
Payback
cumulative costs
cumulative benefits
Year
$
Payback
