Please see the file attachedSheet1 Current Ratio Total Current Assets Total Current Liability1

Please see the file attached

Sheet1

Current RatioTotal Current AssetsTotal Current Liability
1$4,207$1,5302.75
2Collection Period RatioNet ReceivablesNet Patient Service Revenue365
$3,717.00$7,643.00$20.94177.51
Days Cash on Hand, All Sources, RatioCashTemp InvestmentsUnrestricted Long Term InvestmentsTotal ExpensesDepreciation Expenses365
3$280$30$85$8,786$443
$395$8,343$22.8617.281
CashTemp InvestmentsTotal ExpensesDepreciation Expense365
4Days Cash on Hand, Short Term Sources, Ratio$280$30$8,786$443$22.8613.562
$310$8,343
5Average Payment RatioTotal Current LiabilitiesTotal ExpensesDepreciation Expense365
$1,530$8,786$443
$8,343$22.8666.936
6Operating MarginOperating IncomeTotal Operating Revenue100
-$696$8,090-8.603
-0.0860321384
7Total MarginExcess of Revenue Over ExpensesTotal Operating Revenue100
-$61.00$8,090.00-0.754
-0.0075401731
8Return on Net AssetsExcess of Revenue Over ExpensesTotal Net Assets100
-$611$5,196-11.759
-0.1175904542
9Total Asset TurnoverTotal Operating RevenueOther IncomeTotal Assets
$8,090$85$10,2660.796
$8,175
10Age Plant RatioAccumlated DepreciationDeprecation Expense
$1,660$4433.747
11Fixed Assest TurnoverTotal Operating RevenueOther IncomeNet Fixed Assets
$8,090$85$4,9201.662
$8,175
12Current Asset TurnoverTotal Operating RevenueOther IncomeTotal Current Assets
$8,090$85$4,2071.943
$8,175
13Inventory TurnoverTotal Operating RevenueOther IncomeInventory
$8,090$85$14058.393
$8,175
14Net Assets FinancingTotal Net AssetsTotal Assests100
$5,196$10,22650.812
0.5081165656
15Long-Term Debt to CapitalizationLong-Term DebtLong-Term DebtNet Assets100
$3,500$3,500$5,196
$8,6960.402483900640.248
16Debt Service CoverageExcess of Revenues over ExpensesInterest ExpenseDepreciationInterestPrincipal Payments
-$611$443$109$178$109
-$59$287-0.206
17Cash Flow to Debt RatioExcess of Revenues over ExpensesDepreciationCurrent LiabilitiesLong-Term Debt100
-$611$443$1,530$3,500-3.340
-$168$5,030-0.0333996024

FSCJ Health Care Organization Ratio Analysis
Worksheet

Page &P of &N

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions