Order 1034594: HSA 403

profiletutorthammy
CaseratiosforAnalysis.xls

Sheet1

Lehman Health Care Consulting
Key Ratios MCMPC Project
Ratios Standard MCMPC IMG Riverside Good Sisters
Current Ratio 1.3 1.25 1.3 1.3 1.2
Quick Ratio 1.2 1.05 1.1 1.25 0.9
Days Cash on Hand 50 51 49 51 40
Days in Net Receiv 49 55 48 46 62
Debt Svce Cov Ratio >1 1.1 0.95 1 0.89
Liab to Fund Balance 0.2 NA NA 0.25 0.15
Operating Margin >.05 -0.0015 0.065 0.055 -0.02

Sheet2

Sheet3