cash_flow.xlsx
Sheet1
| | | | Cash Revenue and Costs |
| | 0 | 1 | 2 | 3 | 4 | 5 |
| 1. System Cost | ($2,000,000) |
| 2. Installation Expenses | ($500,000) |
| 3. Total Cost | ($2,500,000) |
| 4. Net Revenues | | $1,012,500 | $1,012,500 | $1,012,500 | $1,012,500 | $1,012,500 |
| 5. Labor Costs | | ($140,000) | ($140,000) | ($140,000) | ($140,000) | ($140,000) |
| 6. Maintenance Cost | | ($125,000) | ($125,000) | ($125,000) | ($125,000) | ($125,000) |
| 7. Supplies | | ($54,000) | ($54,000) | ($54,000) | ($54,000) | ($54,000) |
| 8. Net Operating Income | | $693,500 | $693,500 | $693,500 | $693,500 | $693,500 |
| 9. Salvage Value | | | | | | $750,000 |
| 10. Net Cash Flow | ($2,500,000) | $693,500 | $693,500 | $693,500 | $693,500 | $1,443,500 |
kprnechhckin
