Please help. I am lost on these assignments.
For Part 1 (GM and Ford): Would like assistance with these problems on spreadsheet - Common Size Analysis, Liquidity, Solvency, and Dupont Model.
For Part 2 (Apple) Instructions:
(a) Make a 3-year trend analysis, using 2011 as the base year, of (1) net sales and (2) net
income. Comment on the significance of the trend results.
(b) Compute for 2013 and 2012 the (1) profit margin, (2) asset turnover, (3) return on assets,
and (4) return on common stockholders’ equity. How would you evaluate Apple’s
profitability? Total assets at September 24, 2011, were $116,371 and total stockholders’
equity at September 24, 2011, was $76,615.
(c) Compute for 2013 and 2012 the (1) debt to assets ratio and (2) times interest earned. How
would you evaluate Apple’s long-term solvency?
(d) What information outside the annual report may also be useful to your parents in making
a decision about Apple?