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

Critical thinking—consider what you have learned in this chapter reading. Students will complete the required assignment by following the instructions

Critical thinking—consider what you have learned in this chapter reading. Students will complete the required assignment by following the instructions below. SCENARIO: Your company, a growing firm in the financial services industry, is extremely sensitive to the issues surrounding business ethics. The company wants to be proactive in developing a

SWEE ATTACHED TCOB Graduate Studies Discussion RubricCriteria No Submission 0 pointsNovice (Criterion is missing or notin evidence) 1-13

SWEE ATTACHED  TCOB Graduate Studies Discussion Rubric Criteria No Submission 0 points Novice (Criterion is missing or not in evidence) 1-13 points Basic (works towards meeting expectations; performance needs improvement) 14-16 points Proficient (meets expectations; performance is satisfactory) 17-18 points Exemplary (exceeds expectations; performance is outstanding) 19-20 points Support of

Week 1 Discussion Post Take the survey,  Test your Cultural Intelligence . While

Week 1 Discussion Post Take the survey,  Test your Cultural Intelligence . While this survey offers interesting insights, it doesn’t adhere to scientific rigor. Use its findings accordingly. Explain if you think the results accurately describe you and why. Consider sharing your experiences that may have played into the results.