Calculations & Interpretation:

Using the Excel template provided, calculate

and explain what the results are saying

about the company's financial status for

each type of analysis $($one or more slides

per analysis$).$

Horizontal Analysis $($provide both the

$ and $\%$ change$)$

Cash and cash equivalents

Total Liabilities

Operating Revenues

Operating Expenses

Vertical Analysis for the Current and

Prior Year $($using Net Patient Service

Revenue as the base figure$)$

Salary and Benefits

Supplies

Purchase Services

Financial Ratios Analysis for Current

and Prior Year

Current ratio $($liquidity ratio$)$

Debt to assets ratio $($solvency

ratio$)$

Profit margin ratio $($profitability

ratio$)$