Question
Answered

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?


Thanks

2 Attachments
Name: Student ID: Income Statement (in millions) Ford Ford GM Fiscal Year 12/31/2001 12/31/2000 12/31/2001 Revenue $162,412 $170,064 $177,260 COGS 125,706 140,499 130,942 Gross Profit 36,706 29,565 46,318 SG & A 13,602 11,847 23,302 Interest Expense 10,848 10,902 8,590 Tax Expense (2,151) 2,705 768 Net Income (5,453) 3,467 601 Balance Sheet (in millions) Ford Ford GM Fiscal Year 12/31/2001 12/31/2000 12/31/2001 Cash & Marketable Securities $7,218 $4,851 $18,555 Receivables, Trade (Net) 3,152 6,272 141,394 Inventories 6,191 7,514 10,034 Total Current Assets 36,260 39,310 193,843 Total Fixed Assets 33,121 37,508 34,908 Total Assets 276,543 284,421 323,969 Total Current Liabilities 44,546 43,327 64,246 Total Liabilities 268,757 265,811 304,262 Total Equity 7,786 18,610 19,707 Cash Flow Statement (in millions) Ford Ford GM Fiscal Year 12/31/2001 12/31/2000 12/31/2001 Cash Flow from Operations $22,764 $33,764 $9,166 Cash Flow from Investing (17,169) (9,867) (23,171) Cash Flow from Financing (2,976) (8,521) 22,372 Summary income statements and balance sheets are presented for Ford and General Motors year 2001 (In millions). For additional information, their Web sites (and ticker symbols) are www.ford.com (F) and www.gm.com (GM). Note that these numbers are for over all operati automotive.
Background image of page 1
9 pages
Financial Reporting Problem: Apple Inc. Your parents are considering investing in Apple Inc. common stock. They ask you, as an accounting expert, to make an analysis of the company for them. Apple’s financial statements are provided. 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?
Background image of page 1
1 page
Answer & Explanation
Verified Solved by verified expert
Rated

ac, dictum vitae odio. Donec al

, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer
4 Attachments
PART 1 FORD MG ANALYSIS workings.docx
docx
Part 1 Project.xlsx
xlsx
PART 2 PROJECT APLE INC COMPANY workings.docx
docx
Part 2 project.xlsx
xlsx