Executive Solution Overview
Please see the file attached – 2 years ago **files (3)** – ## RatioAnalysisSpreadsheet.xlsx – IMG_2305.png – IMG_2306.png **## RatioAnalysisSpreadsheet.xlsx** ## Sheet1 | | | | | | | | | | | — | — | — | — | — | — | — | — | — | | | Current Ratio | Total Current Assets | Total Curr…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
Please see the file attached
– 2 years ago
**files (3)**
– ## RatioAnalysisSpreadsheet.xlsx
– IMG_2305.png
– IMG_2306.png
**## RatioAnalysisSpreadsheet.xlsx**
## 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
**IMG_2305.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-2305-png)
**IMG_2306.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-2306-png)
**IMG_2306.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-2306-png)
**## RatioAnalysisSpreadsheet.xlsx**
## 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
**IMG_2305.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-2305-png)
**IMG_2306.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-2306-png)
**## RatioAnalysisSpreadsheet.xlsx**
## 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
**IMG_2305.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-2305-png)
**IMG_2306.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-2306-png)
Leave a Reply