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