Please see the file attachedSheet1 Current Ratio Total Current Assets Total Current Liability1

Please see the file attached

Sheet1

Current RatioTotal Current AssetsTotal Current Liability
1$4,207$1,5302.75
2Collection Period RatioNet ReceivablesNet Patient Service Revenue365
$3,717.00$7,643.00$20.94177.51
Days Cash on Hand, All Sources, RatioCashTemp InvestmentsUnrestricted Long Term InvestmentsTotal ExpensesDepreciation Expenses365
3$280$30$85$8,786$443
$395$8,343$22.8617.281
CashTemp InvestmentsTotal ExpensesDepreciation Expense365
4Days Cash on Hand, Short Term Sources, Ratio$280$30$8,786$443$22.8613.562
$310$8,343
5Average Payment RatioTotal Current LiabilitiesTotal ExpensesDepreciation Expense365
$1,530$8,786$443
$8,343$22.8666.936
6Operating MarginOperating IncomeTotal Operating Revenue100
-$696$8,090-8.603
-0.0860321384
7Total MarginExcess of Revenue Over ExpensesTotal Operating Revenue100
-$61.00$8,090.00-0.754
-0.0075401731
8Return on Net AssetsExcess of Revenue Over ExpensesTotal Net Assets100
-$611$5,196-11.759
-0.1175904542
9Total Asset TurnoverTotal Operating RevenueOther IncomeTotal Assets
$8,090$85$10,2660.796
$8,175
10Age Plant RatioAccumlated DepreciationDeprecation Expense
$1,660$4433.747
11Fixed Assest TurnoverTotal Operating RevenueOther IncomeNet Fixed Assets
$8,090$85$4,9201.662
$8,175
12Current Asset TurnoverTotal Operating RevenueOther IncomeTotal Current Assets
$8,090$85$4,2071.943
$8,175
13Inventory TurnoverTotal Operating RevenueOther IncomeInventory
$8,090$85$14058.393
$8,175
14Net Assets FinancingTotal Net AssetsTotal Assests100
$5,196$10,22650.812
0.5081165656
15Long-Term Debt to CapitalizationLong-Term DebtLong-Term DebtNet Assets100
$3,500$3,500$5,196
$8,6960.402483900640.248
16Debt Service CoverageExcess of Revenues over ExpensesInterest ExpenseDepreciationInterestPrincipal Payments
-$611$443$109$178$109
-$59$287-0.206
17Cash Flow to Debt RatioExcess of Revenues over ExpensesDepreciationCurrent LiabilitiesLong-Term Debt100
-$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

Recruitment and SelectionInstructionsOnboarding

Recruitment and Selection Instructions Onboarding Assignment (Job Description) You are the hiring manager at a major home improvement retailer, Home Improvement Center, and need to fill a position for an exempt-status night shift supervisor. The applicants should have retail business experience, preferably in housewares, and at least some supervisory experience.

Perspectives on Training and Development InstructionsBest and Worst Training

Perspectives on Training and Development  Instructions Best and Worst Training Experiences Essay This assignment is worth 20% of your final grade. It gives you an opportunity to apply concepts and theories from your studies to your real-life experiences in training programs. You must complete this assignment individually, without contacting other

Module 3 – CaseProject ManagementCase AssignmentFor this Case

Module 3 – Case Project Management Case Assignment For this Case Assignment, you will develop a project management plan based on the company you selected to create in Module 1. The basic processes of project planning are typically: 1. Identify the goal of the project. 2. Map out the scope.