Healthcare Finance
kprnechhckincash_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 |