Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Exhibits 3.1 and 4.1 (ATTACHED), calculate the 11 ratios for both years: 2014 and 2015. For each calculation, compare your answer to the benchmarks

image text in transcribed

Using Exhibits 3.1 and 4.1 (ATTACHED), calculate the 11 ratios forbothyears: 2014 and 2015. For each calculation, compare your answer to the benchmarks provided in the linked template document below and determine whether your figures are favorable, unfavorable, or approximately the same. Note that the terms differ slightly between the lecture material and the Gapenski text, so I am providing the formulas to avoid confusion:

  1. Common Liquidity Ratios
    • Current ratio = Total Current Assets in Balance Sheet / Total Current Liabilities in Balance Sheet
    • Days Cash on Hand = Cash and Cash Equivalents from Balance Sheet / [(Total Expenses ? Depreciation ? Provision for Bad Debts in Statement of Operations) / 365]
    • Days in A/R = Net Patient Accounts Receivable in Balance Sheet / (Net Patient Service Revenue in Statement of Operations / 365)
  2. Common Profitability Ratios
    • Operating margin = Operating Income from Statement of Operations / Total Revenues in Statement of Operations
    • Return on total assets = Net Income in Statement of Operations / Total Assets in Balance Sheet
    • Return on net assets = Net Income in Statement of Operations / Net Assets (Equity) in the Balance Sheet
  3. Common Capital Structure Ratios
    • Debt to capitalization = Long-term Debt in Balance Sheet / Long term debt + Net Assets in Balance Sheet
    • Times interest earned = (Net Income + Interest) in Statement of Operations / Interest in Statement of Operations
    • Debt service coverage = (Net Income + Interest + Depreciation) in Statement of Operations / Interest + Principal Payments ($10 million assumed for this assignment)
  4. Common Activity/Productivity Ratios
    • Fixed asset turnover = Total Revenues in Statement of Operations / Net Property and Equipment
    • Salary and benefits as a % of net patient revenue = Salaries and Benefits in Statement of Operations / Net Patient Service Revenue in Statement of Operations

Download theRatio Analysis Worksheet(ATTACHED).

Each correct calculation will be worth 1 point.

Once you have completed the calculations, write a memo to the organization?s senior management and board of directors explaining the financial strengths and weaknesses based upon your analysis. The liquidity, profitability, and capital structure will be assessed and communicated to the leaders of the organization. Your memo should be no more than 250 words in length and should be written in plain English for a lay audience.

All sources, including course materials, must be cited in text in APA style.Remember that course materials need not be included in your references page, but all other references must be.

image text in transcribed Assignment 2.2: Ratio Analysis Name (Insert your name) Part 1: Enter the information based on your computations. 2014 2015 1. Current ratio 2. Days cash on hand 3. Days in A/R 4. Operating margin 5. Return on total assets 6. Return on net assets 7. Debt to capitalization 8. Times interest earned 9. Debt service coverage 10. Fixed asset turnover 11. Salary and benefit/NPSR Part 2: Type your memo to senior management below Benchmark 2.00 15.00 45.00 4% 4% 10% 50% 4.00 2.00 3.00 55% Favorable (F), Unfavorable (U), or Approximate (A)? 2015/2014

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Focus On Personal Finance

Authors: Jack R. Kapoor, Les R. Dlabay Professor, Robert J. Hughes, Melissa Hart

5th Edition

0077861744, 978-0077861742

More Books

Students also viewed these Finance questions

Question

Locate the centroid x of thearea. y = x 1 m y =x 1 m-

Answered: 1 week ago

Question

What moral Issues does tile Pinto case raise?

Answered: 1 week ago