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
