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