Lancelot Company has provided the following comparative information:

You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: 2006??2010Rate earned on total assets.......... 15%Rate earned on stockholders?? equity....... 18%Number of times interest charges earned...... 3.5Ratio of liabilities to stockholders?? equity.... 1.4Instructions1. Prepare four line graphs with the ratio on the vertical axis and the years on the horizontal axis for the following four ratios (rounded to one decimal place):a. Rate earned on total assetsb. Rate earned on stockholders?? equityc. Number of times interest charges earnedd. Ratio of liabilities to stockholders?? equityDisplay both the company ratio and the industry benchmark on each graph.That is, each graph should have two lines.2. Prepare an analysis of the graphs in(1).

**Transcribed Image Text:**

## 2009 2008 2007 2006 2010 $ 1,930,500 $1,287,000 400,200 345,000 318,240 477,360 $ 975,000 Net income Interest expense Income tax expense Total assets (ending balance) Total stockholders'equity (ending balance) Average total assets Average stockholders' equity $ 650,000 $ 500,000 200,000 120,000 300,000 244,800 240,000 163,200 11,498,760 8,845,200 6,804,000 4,200,000 5,040,000 4,812,000 3,525,000 5,922,000 2,550,000 4,620,000 1,900,000 3,600,000 6,742,500 10,171,980 7,824,600 5,777,250 4,168,500 3,037,500 2,225,000 1,650,000