Budgeting Select an organization; either Metropolis Health System from the Case Study or one of the organizations presented in either or one of the three Mini-Case Studies. Using the organization selected, create a budget for the next fiscal year. Set out the details of all assumptions you needed in order to build this budget. Use the Checklist for Building a Budget and critique your own budget. In short, you will submit an excel sheet for your budget and a word document with your list of assumptions.

Assignment Exercise 13-2 Trend Analysis
Metropolis Health System Statement of Revenue and Expenses For the Years Ended March 31, 20X3 and 20X2
	Year 2	Year 1	Difference	Percent
Revenue
Net patient service revenue	34,000,000	33,600,000	400,000	1.19%
Other revenue	1,100,000	1,000,000	100,000	10%
Total Operating Revenue	35,100,000	34,600,000	500,000	1.44%
Expenses
Nursing services	5,025,000	5,450,000	425,000	7.79%
Other professional services	13,100,000	12,950,000	150,000	1.15%
General services	3,200,000	3,220,000	20,000	0.62%
Support services	8,300,000	8,340,000	40,000	0.47%
Depreciation	1,900,000	1,800,000	100,000	5.55%
Amortization	50,000	50,000	0	0%
Interest	325,000	350,000	25,000	7.14%
Provision for doubtful accounts	1,500,000	1,600,000	100,000	6.25%
Total Expenses	33,400,000	33,760,000	360,000	1.06%
Income from Operations	1,700,000	840,000	860,000	101.19%
Nonoperating Gains (Losses)
Unrestricted gifts and memorials	20,000	70,000	50,000	71.42%
Interest income	80,000	40,000	40,000	100%
Nonoperating Gains Net	100,000	110,000	10,000	9.09%
Revenues and Gains in Excess of Expenses and Losses	1,800,000	950,000	850,000	89.48%

Answer rating: 100% (QA)

Metropolis Health System Statement of Revenue and Expenses For the Years Ended March 31 20X3 and 20X... View the full answer