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