Chapter 6 work
relic415
qct7_chapter_15_spreadsheet_1.xlsSheet1
| Salvator's chapter 15 spreadsheet problem 1 (p. 652) | |||||
| End of Year | Investment (Year 0) and Cost | Revenue | Net Revenue | Present Value Coefficient | Present Value of Net Revenue |
| 0 | 1000.00 | -1000.00 | 1.00 | -1000.00 | |
| 1 | 200.00 | 600.00 | 400.00 | 0.95 | 380.95 |
| 2 | 300.00 | 800.00 | |||
| 3 | 300.00 | 800.00 | |||
| 4 | 400.00 | 800.00 | |||
| 4 | 200.00 | ||||
| Total Present Value |
