Solved by Expert Tutors
Solved by Expert Tutors
Question

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

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
GM 12/31/2000 $184,632 145,664 38,968 22,252 9,552 2,393 4,452 GM 12/31/2000 $10,284 135,002 10,945 208,920 33,977 303,100 63,156 272,925 30,175 GM 12/31/2000 $10,871 11,313 (890) rs for fiscal e tions, not just
Background image of page 2
Show entire document
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
Sign up to view the entire interaction

Step-by-step answer

ac, dictum vitae odio. Donec al

ce 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. Fusce dui lectu

PART 1 FORD MG ANALYSIS workings.docx
rem ipsum dolor sit amet, con at, ultrices ac magna. Fusce dui lectus , dictum vitae o risus ante, dapibus a ec aliquet. Lorem ipsum dolor sit a o. Donec aliquet. Lorem ipsum dol entesque dapibus ef

Subscribe to view the full answer

Subject: Accounting, Business

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Accounting tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes