This case presents you with financial ratios for eight pairs of unidentified companies and asks you to mate description of the company w the financial profile derived from the ratios. The primary objective is to introduce you to financial ratio analysis, in particular, the range of ratios and the insights each one affords.
The structured exploration of pairs of companies within an industry affords a number of important insights into strategy and financial performance. First the economics of individual industries account for significant variations in financial ratios because of differences in technology, product characteristics, or competitive structures. Second, financial performance results from managerial choices: within industries, the wide variation in financial ratios is often a result of the differences in corporate strategy in marketing, operations, and finance.
Dont report on all companies, select a company pair to report your findings on.
File Home Insert Page Layout Formulas Data Review View Tell me whut PROTECTED VIEW Be careful-files from the Internet can contain viruses Unless you need to edit, it's safer to stay in Protected View Enable Editing SUN MICROSYSTEMS IT Companies Financial Data Stock Shares Market Price Out Cap Debt Levered Bond Investments Sales EBIT EBITDA Earnings Cash & LTM LTM LTM LTM Ticker ) I (SMM (SMN Beta Rating (SMNM (SMM (SMM) (SMD (SMND 10 Primarily Hardware 11 Advanced Micro Devices AMD 3.56 609 2.168 4,988 2.19 B AAPL 123.42 89 109,713 DELL 11.06 1,944 21,5s 2.011 12 A2 EMC 12.81 2.04 26,142 3,404 1.39 HPQ 36.30 2.416 87,708 20,458 25 A2 10.140 118,697 10.354 14,175 8,050 INTC 15.60 2.562 39,967 1988 1.20 A 933 5,808 (1955) (732) (3,098) 24,490 37.096 7,984 8,739 ,728 9,546 61,101 3,190 3,959 2,478 6.446 14,876 1,569 2,626 1,346 14 EMC 15 Hewlett-Packard 8,840 37,586 8,954 13,570 5,292 17 International Business Machines IBM 101.27 1.343 136,052 33.925 0.93 A 12,907 103.630 16,715 22,165 12.334 116 286 101 3,061 13,438 (2,231) (1,757) n/a NTAP 17.59 330 5,808 1,26 1.80 JAVA 6.69 739 4,9411.257 1.73 Bal 3,464 Sun Microsystems 21 Primarily Software Adobe Systems ADBE 24.70 524 12.944 MSFT 19.20 8,896 170,795 2,000 0.99 A 31,447 61,981 22,128 24.485 17.232 NOVL 3.94 ORCL 19.06 5,046 96,180 i1.238 .27 A2 i2.624 23,630 s,40010.201 s, RHT 18.32 190 350 1.32- 3,476 961 1.231809 122 1.50 BI 10 55 (5) 26 Red Hat B Market data as of April 17, 2009 29 Data sources: Yahoo! Finance, Moody's Bloomberg, and company Slings Exhibit 3 Exhibit 4 Exhibit 5 Exhibit 6Exhibit 7 Exhibit 8 Exhibit 9 Exhibit 10 Exhibit 11 Exhibit 12 Exhibit 13 Exhibit 14 O Type here to 0 File Home Insert Page Layout Formulas Data Review View Tell me whut PROTECTED VIEW Be careful-files from the Internet can contain viruses Unless you need to edit, it's safer to stay in Protected View Enable Editing SUN MICROSYSTEMS IT Companies Financial Data Stock Shares Market Price Out Cap Debt Levered Bond Investments Sales EBIT EBITDA Earnings Cash & LTM LTM LTM LTM Ticker ) I (SMM (SMN Beta Rating (SMNM (SMM (SMM) (SMD (SMND 10 Primarily Hardware 11 Advanced Micro Devices AMD 3.56 609 2.168 4,988 2.19 B AAPL 123.42 89 109,713 DELL 11.06 1,944 21,5s 2.011 12 A2 EMC 12.81 2.04 26,142 3,404 1.39 HPQ 36.30 2.416 87,708 20,458 25 A2 10.140 118,697 10.354 14,175 8,050 INTC 15.60 2.562 39,967 1988 1.20 A 933 5,808 (1955) (732) (3,098) 24,490 37.096 7,984 8,739 ,728 9,546 61,101 3,190 3,959 2,478 6.446 14,876 1,569 2,626 1,346 14 EMC 15 Hewlett-Packard 8,840 37,586 8,954 13,570 5,292 17 International Business Machines IBM 101.27 1.343 136,052 33.925 0.93 A 12,907 103.630 16,715 22,165 12.334 116 286 101 3,061 13,438 (2,231) (1,757) n/a NTAP 17.59 330 5,808 1,26 1.80 JAVA 6.69 739 4,9411.257 1.73 Bal 3,464 Sun Microsystems 21 Primarily Software Adobe Systems ADBE 24.70 524 12.944 MSFT 19.20 8,896 170,795 2,000 0.99 A 31,447 61,981 22,128 24.485 17.232 NOVL 3.94 ORCL 19.06 5,046 96,180 i1.238 .27 A2 i2.624 23,630 s,40010.201 s, RHT 18.32 190 350 1.32- 3,476 961 1.231809 122 1.50 BI 10 55 (5) 26 Red Hat B Market data as of April 17, 2009 29 Data sources: Yahoo! Finance, Moody's Bloomberg, and company Slings Exhibit 3 Exhibit 4 Exhibit 5 Exhibit 6Exhibit 7 Exhibit 8 Exhibit 9 Exhibit 10 Exhibit 11 Exhibit 12 Exhibit 13 Exhibit 14 O Type here to 0