Financial Statements
Income Statements				Pima Medical Center			Tucson Regional
		2019	2020	2021	2021
	Revenues	$51,336	$51,533	58,752	11,789
	Salaries and Benefits	23,560	23,874	26,779	5,411
	Supplies Expense	8,481	8,369	9,481	1,963
	Other Operating Expenses	9,481	9,307	9,961	2,857
	Depreciation/Amortization	2,596	2,721	2,853	458
	Interest Expense	1,824	1,584	1,566	1,031
	Total Operating Expenses	45,942	45,855	50,640	11,720
	Operating Income	5,394	5,678	8,112	69
	Income Taxes	1,099	1,043	2,112	14
	Net Income	4,295	4,635	6,000	55
Note: Amounts in 1,000s of dollars
Balance Sheets
		2019	2020	2021	2021
	Assets
	Cash	621	1,793	1,451	1,676
	Short-Term Investments	147	116	103	-
	Accounts Receivables, Net	7,333	7,159	8,095	1,927
	Supplies Inventory	1,849	2,025	1,986	335
	Other Current Assets	1,190	1,340	1,896	519
	Total Current Assets	11,140	12,433	13,531	4,457
	Net Property, Plant & Equipment	24,549	25,223	26,176	5,322
	Long-Term Note Receivable	37	31	44	59
	Intangible Assets	8,269	8,578	9,540	4,219
	Total Assets	43,995	46,265	49,291	14,057
	Liabilities & Shareholders' Equity
	Accounts Payable	2,357	2,581	2,842	383
	Short Term Debt	145	209	237	980
	Current Portion of Long Term Debt	4,905	5,535	6,111	533
	Other Current Liabilities	2,303	2,267	2,461	150
	Accrued Payroll	2,054	2,314	2,381	637
	Total Current Liabilities	11,764	12,906	14,032	2,683
	Long-Term Debt	23,107	20,301	23,765	11,033
	Total Liabilities	34,871	33,207	37,797	13,716
	Total Shareholders' Equity
		9,124	13,058	11,494	341
	Liabilities & Shareholders' Equity	43,995	46,265	49,291	14,057

Question 4: Prepare a Common Size Analysis Enter the relevant data for for each category. Categories shaded in yellow have been entered for you. Complete the Analysis column (column J) based on your calculations. Areas in which you are required to input data are shaded in blue. It is a good idea to use Excel cell references and formulas to reduce errors in calculations.

Students: In this section, the number gets highlighted in green

Financial Statements

if correct. If incorrect it returns to the original shade.

Analysis: What stands out; what should be investigated further

Income Statements

Pima Medical Center

Tucson Regional

(Be sure to comment on the trend and the comparison to Tucson.)

Common Size

2019

2020

2021

2021

Basis: Percent of Revenue

Revenues

100.0%

100.0%

100.0%

100.0%

Salaries and Benefits

Supplies Expense

Other Operating Expenses

Depreciation/Amortization

Interest Expense

Total Operating Expenses

Operating Income

Income Taxes

Net Income

Balance Sheets

Common Size

2019

2020

2021

2021

Basis: Percent of Total Assets

Assets

Cash

Short-Term Investments

Accounts Receivables, Net

Supplies Inventories

Other Current Assets

Total Current Assets

Net Property, Plant & Equipment

Long-Term Note Receivable

Intangible Assets

Total Assets

100.0%

100.0%

100.0%

100.0%

Liabilities & Shareholders' Equity

Accounts Payable

Short Term Debt

Current Portion of Long Term Debt

Other Current Liabilities

Accrued Payroll

Total Current Liabilities

Long-Term Debt

Total Liabilities

Total Shareholders' Equity

Liabilities & Shareholders' Equity

100.0%

100.0%

100.0%

100.0%