Assignment 2. 2: Ratio Analysis Identify| | Half 1: Enter the data primarily based in your computations. | 2011| 2010| Benchmark| Favorable (F), Unfavorable (U), or Approximate (A)? 2011/2010| 1. Present ratio | three. 52| 2. 59| 2. 00| Favorable| 2. Days money available| 27. 64| 18. 10| 15. 00| Favorable| three. Days in A/R| 69. 32| 76. 59| 45. 00| Favorable| four. Working margin | 2. 18%| three. 03%| four%| Unfavorable| 5. Return on whole property | 5. 08%| 7. 13%| four%| Unfavorable| 6. Return on web property | 14. 54%| 17. 76%| 10%| Unfavorable| 7. Debt to capitalization| 61. 21%| 53. 69%| 50%| Unfavorable| eight.
Occasions curiosity earned | 2. 47| three. 36| four. 00| Unfavorable| 9. Debt service protection | 1. 28| 1. 30| 2. 00| Approximate| 10. Fastened asset turnover | three. 28| 2. 88| three. 00| Favorable| 11. Wage and profit/NPSR| 84. 08%| 82. 82%| 55%| Unfavorable| 1. Present ratio = Complete Present Property in Steadiness Sheet / Complete Present Liabilities in Steadiness Sheet 2011| 2010| $54,306/$15,425| $39,715/$15,315| three. 52| 2. 59 | 2. Days Money on Hand = Money and Money Equivalents from Steadiness Sheet / [(Total Expenses – Depreciation – Provision for Bad Debts in Statement of Operations) / 365] zero11| 2010| $12,102/[($168,232 – $6,405 – $2,000)/365]| $6,486/[($138,394 – $5,798 – $1,800)/365]| $12,102/[$159,827/365]| $6,486/[$130. 796/365]| $12,102/437. 88| $6,486/358. 34| 27. 64| 18. 10| three. Days in A/R = Web Affected person Accounts Receivable in Steadiness Sheet / (Web Affected person Service Income in Assertion of Operations / 365) 2011| 2010| $28,509/($150,118/365)| $25,927/$123,565/365)| $28,509/411. 28| $25,927/338. 53| 69. 32| 76. 59| four. Working margin = Working Revenue from Assertion of Operations / Complete Revenues in Assertion of Operations 2011| 2010| three,747/$171,979| $four,330/$142,724| .0218 x 100| . 0303 X 100| 2. 18%| three. 03%| 5. Return on whole property = Web Revenue in Assertion of Operations / Complete Property in Steadiness Sheet 2011| 2010| $7,860/$154,815| $eight,206/$115,101| .0508 x 100| . 0713 x 100| 5. 08%| 7. 13%| 6. Return on web property = Web Revenue in Assertion of Operations / Web Property within the Steadiness Sheet 2011| 2010| $7,860/$54,068| $eight,206/$46,208| .1454 x 100| . 1776 x 100| 14. 54%| 17. 76%| 7. Debt to capitalization = Lengthy-term Debt in Steadiness Sheet / Long run debt + Web Property in Steadiness 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%| eight. Occasions curiosity earned = (Web Revenue + Curiosity) in Assertion of Operations / Curiosity in Assertion of Operations 2011| 2010| ($7,860 + $5,329)/$5,329| ($eight,206 + $three,476)/$three,476| $13,189/$5,329| $11,682/$three,476| 2. 47| three. 36| 9. Debt service protection = (Web Revenue + Curiosity + Depreciation) in Assertion of Operations/ Curiosity + Principal Funds ($10 million assumed for this project) 2011| 2010| ($7,860 + $5,329 + $6. 05)/$15,329| ($eight,206 + $three,476 + $5,795)/$13,476| $19,594/$15,329| $17,477/$13,476| 1. 28| 1. 30| 10. Fastened asset turnover = Complete Revenues in Assertion of Operations / Web Property and Tools 2011| 2010| $171,979/$52,450| $142,724/$49,549| three. 28| 2. 88| 11. Wage and advantages as a % of web affected person income = Salaries and Advantages in Assertion of Operations / Web Affected person Service Income in Assertion of Operations 2011| 2010| $126,223/$150,118| $102,334/$123,565| .8408 X 100| . 8282 x 100| 84. 08%| 82. 82%| Half 2: Kind your memo to senior administration under
