Revenue forecast
20XX Budget Template
| Do | |||||||||
| KRONA HOSPITAL | |||||||||
| OPERATING BUDGET FOR 20XX | |||||||||
| Current | Change % ( + or - ) | Next Yr Budget | Fornmula to use | ||||||
| Revenues | |||||||||
| Inpatient | $ 25,000,000 | 10% | $ 27,500,000 | =H7*(1+K7) | |||||
| Outpatient | 15,000,000 | ||||||||
| Emergency Room | 10,000,000 | ||||||||
| Laboratory | 5,000,000 | ||||||||
| Pharmacy | 1,500,000 | ||||||||
| Home Health and Hospice | 1,500,000 | ||||||||
| Ambulance Services | 950,000 | ||||||||
| Substance Abuse | 250,000 | ||||||||
| Other | 850,000 | ||||||||
| Subtotal | $ 60,050,000 | ||||||||
| Less Chartiy Care | 18,000,000 | ||||||||
| Net Revenues | $ 42,050,000 | ||||||||
| Expenses | |||||||||
| Payroll (including nursing salaries) | $ 12,500,000 | =H20*(1+K20) | |||||||
| Benefits | 3,000,000 | ||||||||
| Contract Labor | 100,000 | ||||||||
| Insurance | 300,000 | ||||||||
| General Services (laundary, security, etc) | 3,000,000 | ||||||||
| Depreciation | 1,500,000 | ||||||||
| Interest Expense | 300,000 | ||||||||
| Professional Services | 10,000,000 | ||||||||
| Total Operating Expenses | $ 30,700,000 | ||||||||
| Net Income | $ 11,350,000 | $ - | |||||||
1st
2nd