Please see the file attached Sheet1 Current Ratio Total Current Assets Total Current Liability 1

Please see the file attached

Sheet1

Current Ratio Total Current Assets Total Current Liability
1 $4,207 $1,530 2.75
2 Collection Period Ratio Net Receivables Net Patient Service Revenue 365
$3,717.00 $7,643.00 $20.94 177.51
Days Cash on Hand, All Sources, Ratio Cash Temp Investments Unrestricted Long Term Investments Total Expenses Depreciation Expenses 365
3 $280 $30 $85 $8,786 $443
$395 $8,343 $22.86 17.281
Cash Temp Investments Total Expenses Depreciation Expense 365
4 Days Cash on Hand, Short Term Sources, Ratio $280 $30 $8,786 $443 $22.86 13.562
$310 $8,343
5 Average Payment Ratio Total Current Liabilities Total Expenses Depreciation Expense 365
$1,530 $8,786 $443
$8,343 $22.86 66.936
6 Operating Margin Operating Income Total Operating Revenue 100
-$696 $8,090 -8.603
-0.0860321384
7 Total Margin Excess of Revenue Over Expenses Total Operating Revenue 100
-$61.00 $8,090.00 -0.754
-0.0075401731
8 Return on Net Assets Excess of Revenue Over Expenses Total Net Assets 100
-$611 $5,196 -11.759
-0.1175904542
9 Total Asset Turnover Total Operating Revenue Other Income Total Assets
$8,090 $85 $10,266 0.796
$8,175
10 Age Plant Ratio Accumlated Depreciation Deprecation Expense
$1,660 $443 3.747
11 Fixed Assest Turnover Total Operating Revenue Other Income Net Fixed Assets
$8,090 $85 $4,920 1.662
$8,175
12 Current Asset Turnover Total Operating Revenue Other Income Total Current Assets
$8,090 $85 $4,207 1.943
$8,175
13 Inventory Turnover Total Operating Revenue Other Income Inventory
$8,090 $85 $140 58.393
$8,175
14 Net Assets Financing Total Net Assets Total Assests 100
$5,196 $10,226 50.812
0.5081165656
15 Long-Term Debt to Capitalization Long-Term Debt Long-Term Debt Net Assets 100
$3,500 $3,500 $5,196
$8,696 0.4024839006 40.248
16 Debt Service Coverage Excess of Revenues over Expenses Interest Expense Depreciation Interest Principal Payments
-$611 $443 $109 $178 $109
-$59 $287 -0.206
17 Cash Flow to Debt Ratio Excess of Revenues over Expenses Depreciation Current Liabilities Long-Term Debt 100
-$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

Your Input in the Core Hopefully, you’ll consider this questions a welcome break from our primary subject matter. As higher educational institutions,

Your Input in the Core Hopefully, you’ll consider this questions a welcome break from our primary subject matter. As higher educational institutions, universities produce well-qualified members of the workforce. There is discussion taking place at FSU about how to update our core curriculum (required general education courses). Provided they don’t

  Choose one of the following dilemmas and outline the argument for each of the opposing positions. Support your argument with reference(s) to current

  Choose one of the following dilemmas and outline the argument for each of the opposing positions. Support your argument with reference(s) to current articles from peer-reviewed journals. References to laws and legal journals are also acceptable, if properly cited. You may cite the text. Choose one: Retributive vs. restorative justice Hate