Assignment 1 Spreadsheet(1) (2).xlsx

Assignment 1 Spreadsheet(1) (2).xlsx - The Mystery Company...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
The Mystery Company Ratio Analysis Perform a complete ratio analysis of this company, then try to guess what typ
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
pe of business it is.
Image of page 2
Income Statement [Abstract] 2016 2015 Net sales $ 215,639 $ 233,715 Cost of sales 131,376 140,089 Gross margin 84,263 93,626 Operating expenses: Research and development 10,045 8,067 Selling, general and administrative 14,194 14,329 Total operating expenses 24,239 22,396 Operating income (EBIT) 60,024 71,230 Other income/(expense), net 1,348 1,285 Interest income (expense) 0 0 Income before provision for income taxes 61,372 72,515 Provision for income taxes 15,685 19,121 Net income $ 45,687 $ 53,394 Earnings per share: Basic (in dollars per share) $ 8.35 $ 9.28 Diluted (in dollars per share) $ 8.31 $ 9.22 Shares used in computing earnings per share: Basic (in shares) 5,470,820 5,753,421 Diluted (in shares) 5,500,281 5,793,069 Cash dividends declared per share (in dollars per share) $ 2.18 $ 1.98 EBIT = Earnings Before Interest and Taxes Earnings Available to Shareholders = Net Income - Preferred Stock Dividends This company has no preferred stock. So Earnings Available to Shareholders = Net Income CONSOLIDATED STATEMENTS OF OPERATIONS USD ($) shares in Thousands, $ in Millions
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Common-size Income St 2014 2013 2012 2016 2015 2014 $ 182,795 $ 170,910 $ 156,508 112,258 106,606 87,846 70,537 64,304 68,662 6,041 4,475 3,381 11,993 10,830 10,040 18,034 15,305 13,421 52,503 48,999 55,241 980 1,156 522 0 0 0 53,483 50,155 55,763 13,973 13,118 14,030 $ 39,510 $ 37,037 $ 41,733 $ 6.49 $ 40.03 $ 44.64 List your points of interest here: $ 6.45 $ 39.75 $ 44.15 The Common-Size Income Statement com 6,085,572 925,331 934,818 6,122,663 931,662 945,355 $ 1.82 $ 11.40 $ 2.65
Image of page 4
tatement 2013 2012 mputes the Gross, Operating and Net Margins
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Consolidated Balance Sheets Current assets: Cash and cash equivalents Short-term marketable securities Accounts receivable, less allowances of $53 and $63, respectively Inventories Deferred tax assets Vendor non-trade receivables Other current assets Total current assets Long-term marketable securities Property, plant and equipment, net Goodwill Acquired intangible assets, net Other non-current assets Total assets Current liabilities: Accounts payable Accrued expenses Deferred revenue Commercial paper Current portion of long-term debt
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern