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

Kristen When it comes to identifying the position of HRM strategic management in business strategy development, it can be observed that HRM ensures

Kristen When it comes to identifying the position of HRM strategic management in business strategy development, it can be observed that HRM ensures that human resources are channeled towards business objectives. Human resource practices, especially in small and medium enterprises (SMEs), may influence the business strategy through high-performance work practices

Recruitment and SelectionHRMD 630 Unit 4 Assignment This is an open

Recruitment and Selection HRMD 630 Unit 4 Assignment This is an open book assignment that must be completed as an individual assignment. There are 4 short-answer (10 points each = 40 points), and 2 essay questions (30 points each = 60 points.) Short Answer Questions Respond to all four of

See attachedEssay questions: Present facts and information from outside sources ON AMAZON. Cite 2 or more scholar references,

See attached Essay questions: Present facts and information from outside sources ON AMAZON. Cite 2 or more scholar references, including Mello, J. A. (2023). Strategic human resource management (6th ed.). Cengage Learning. Information and Literature Review. The literature review is a critical summary and synthesis of existing research on a particular topic. It provides