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

Scenario Wesley Enterprises is a long-term care facility. The organization was recently cited for deficiencies including infectious disease planning

Scenario Wesley Enterprises is a long-term care facility. The organization was recently cited for deficiencies including infectious disease planning and staffing deficiencies. The CEO has decided to hire a consulting firm to evaluate its current processes and make recommendations for improvement. Upon initial review, the consulting firm has determined that

Critical thinking—consider what you have learned in this chapter reading. Students will complete the required assignment by following the instructions

Critical thinking—consider what you have learned in this chapter reading. Students will complete the required assignment by following the instructions below. SCENARIO: Your company, a growing firm in the financial services industry, is extremely sensitive to the issues surrounding business ethics. The company wants to be proactive in developing a

SWEE ATTACHED  TCOB Graduate Studies Discussion Rubric Criteria No Submission 0 points Novice (Criterion is missing or not in evidence) 1-13

SWEE ATTACHED  TCOB Graduate Studies Discussion Rubric Criteria No Submission 0 points Novice (Criterion is missing or not in evidence) 1-13 points Basic (works towards meeting expectations; performance needs improvement) 14-16 points Proficient (meets expectations; performance is satisfactory) 17-18 points Exemplary (exceeds expectations; performance is outstanding) 19-20 points Support of

Week 1 Discussion Post Take the survey,  Test your Cultural Intelligence . While

Week 1 Discussion Post Take the survey,  Test your Cultural Intelligence . While this survey offers interesting insights, it doesn’t adhere to scientific rigor. Use its findings accordingly. Explain if you think the results accurately describe you and why. Consider sharing your experiences that may have played into the results.