Please see attached; 2 problems in total. 8-1 and 8-7. 8-7 is attached in excel spread sheet. 8-1 in text below. Ahl Enterprise lists the following data for 2011 and 2010: 2011 2010 Net income $ 52,500 $ 40,000 Net sales 1,050,000 1,000,000 Average total assets 230,000 200,000 Average common equity 170,000 160,000 Required Calculate the net profit margin, return on assets, total asset turnover, and return on common equity for both years. Comment on the results. (For return on assets and total asset turnover, use end-of-year total assets; for return on common equity, use end-of-year common equity.)

Selected financial data for squid company are as follows; 2011 Summary of operations; Net Sales Cost of Products sold Selling, Administrative, and General expenses Nonoperating income Interest Expense Earnings before income taxes Provision for income taxes Net Earnings Finanical Information Working Capital Average property, plant and equipment Average total assets Average long-term debt Average Stockholders Equity A. Compute the following for 2011, 2010 and 2009; 1. Net profit Margin 2. Return on assets 3. Total asset turnover 4. DuPont Analysis 5. Return on investment 6. Return on total equity 7. Sales to fixed assets B. Dicsuss your findings in (A). 2010 2009 1,002,100 520,500 170,200 9,192 14,620 287,588 116,473 171,115 980,500 14,762 167,665 8,860 12,100 277,113 113,616 163,497 900,000 477,000 155,700 6,500 11,250 249,550 105,560 143,990 190,400 302,500 839,000 120,000 406,000 189,000 281,000 770,000 112,000 369,500 180,000 173,000 765,000 101,000 342,000