preview

Essay on Assignment 2.2: Ratio Analysis

Satisfactory Essays

Assignment 2.2: Ratio Analysis

Name | |

Part 1:

Enter the information based on your computations.

| 2011 | 2010 | Benchmark | Favorable (F), Unfavorable (U), or Approximate (A)? 2011/2010 | 1. Current ratio | 3.52 | 2.59 | 2.00 | Favorable | 2. Days cash on hand | 27.64 | 18.10 | 15.00 | Favorable | 3. Days in A/R | 69.32 | 76.59 | 45.00 | Favorable | 4. Operating margin | 2.18% | 3.03% | 4% | Unfavorable | 5. Return on total assets | 5.08% | 7.13% | 4% | Unfavorable | 6. Return on net assets | 14.54% | 17.76% | 10% | Unfavorable | 7. Debt to capitalization | 61.21% | 53.69% | 50% | Unfavorable | 8. Times interest earned | 2.47 | 3.36 | 4.00 | Unfavorable | 9. Debt …show more content…

Return on net assets = Net Income in Statement of Operations / Net Assets in the Balance Sheet

2011 | 2010 | $7,860/$54,068 | $8,206/$46,208 | .1454 x 100 | .1776 x 100 | 14.54% | 17.76% |

7. Debt to capitalization = Long-term Debt in Balance Sheet / Long term debt + Net Assets in
Balance Sheet

2011 | 2010 | $85,322/($85,322 + $54,068) | $53,578/($53,578 + $46,208) | $85,322/$139,390 | $53,578/$99,786 | .6121 x 100 | .5369 x 100 | 61.21% | 53.69% |

8. Times interest earned = (Net Income + Interest) in Statement of Operations / Interest in
Statement of Operations

2011 | 2010 | ($7,860 + $5,329)/$5,329 | ($8,206 + $3,476)/$3,476 | $13,189/$5,329 | $11,682/$3,476 | 2.47 | 3.36 |

9. Debt service coverage = (Net Income + Interest + Depreciation) in Statement of Operations/ Interest + Principal Payments ($10 million assumed for this assignment)

2011 | 2010 | ($7,860 + $5,329 + $6.405)/$15,329 | ($8,206 + $3,476 + $5,795)/$13,476 | $19,594/$15,329 | $17,477/$13,476 | 1.28 | 1.30 |

10. Fixed asset turnover = Total Revenues in Statement of Operations / Net Property and
Equipment

2011 | 2010 | $171,979/$52,450 | $142,724/$49,549 | 3.28 | 2.88 |

11. Salary and benefits as a % of net patient revenue = Salaries and Benefits in Statement of
Operations / Net Patient Service Revenue in

Get Access