Calculation

ElaineL
Excel.xlsx

Ratio Template

Week 8 Assignment 1 Ratio Template
A B D E F G
(in '000)
12/31/22 12/31/23 2022 2023 2022 2023
Ratio[a] [D/E] [F/G] Numerator Denominator Numerator Denominator
Current Ratio
Quick Ratio
Acid Test Ratio
Days in Accounts Receivable
Days Cash on Hand
Average Payment Period (Days)
Operating Revenue per Adjusted Discharge
Operating Expense per Adjusted Discharge
Salary & Benefit Exp. as % of Operating Exp.
Operating Margin
Non-Operating Revenue
Return on Total Assets
Return on Net Assets
Total Asset Turnover Ratio
Fixed Asset Turnover Ratio
Age of Plant Ratio
Long-Term Debt to Net Assets
Net Assets to Total Assets