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

  Week 6 Discussion – Knowledge Management Systems Post a Response Both formal and informal knowledge management systems can emerge within an

  Week 6 Discussion – Knowledge Management Systems Post a Response Both formal and informal knowledge management systems can emerge within an organization; each system type has unique traits and may emerge from several sources including organizational priorities or culture-respectively. Please respond to the following: Identify the differences between formal

Response to discussion 3 PATRICIAManaging Multiple Generations, the

Response to discussion 3 PATRICIA Managing Multiple Generations, the Lindedln’s video, explores millennials’ talent development and qualities. “Millennials tend to share some defining characteristics, such as pragmatism, optimism, and an aversion to autocratic leadership styles” (Brown, 2017). This global generation is known to be tech-savvy. They are loyal to people