operating_budget_template.xlsx
Sheet1
| | | | | | ABC Health Care |
| | January | February | March | April | May | June | July | August | September | October | Novedmber | December | Total |
| Revenues |
| Fee-For-Service |
| Private Pay |
| Fundraiser |
| Grants |
| Total Revenues |
| Expenses |
| Salaries | $ 125,000 | $ 125,000 | $ 125,000 | $ 125,000 | $ 125,000 | $ 125,000 | $ 125,000 | $ 125,000 | $ 125,000 | $ 125,000 | $ 125,000 | $ 125,000 | $ 1,500,000 |
| Benefits | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 240,000 |
| Rent | $ 80,000 | $ 80,000 | $ 80,000 | $ 80,000 | $ 80,000 | $ 80,000 | $ 80,000 | $ 80,000 | $ 80,000 | $ 80,000 | $ 80,000 | $ 80,000 | $ 960,000 |
| Insurance | $ 3,750 | $ 3,750 | $ 3,750 | $ 3,750 | $ 3,750 | $ 3,750 | $ 3,750 | $ 3,750 | $ 3,750 | $ 3,750 | $ 3,750 | $ 3,750 | $ 45,000 |
| Overhead | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 180,000 |
| Supplies | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 60,000 |
| Depreciation | $ 83,333 | $ 83,333 | $ 83,333 | $ 83,333 | $ 83,333 | $ 83,333 | $ 83,333 | $ 83,333 | $ 83,333 | $ 83,333 | $ 83,333 | $ 83,333 | $ 780,000 |
| Total Expenses | $ 332,083 | $ 332,083 | $ 332,083 | $ 332,083 | $ 332,083 | $ 332,083 | $ 332,083 | $ 332,083 | $ 332,083 | $ 332,083 | $ 332,083 | $ 332,083 | $ 3,765,000 |
| Net Income (Loss) |
oigkw3cn1
