Instructions Use the income statement and balance sheet information for Apple to
ID: 2814909 • Letter: I
Question
Instructions Use the income statement and balance sheet information for Apple to fill in the missing items in the calculation of Apple's ROIC and supporting ratios. Once filled in correctly, compare Apple's performance to that of Microsoft. Where does Apple have an advantage? Where does Microsoft have an advantage? Apple Inc FYE Sept, 27 2014 (000) 182,795,000 112,258,000 Microsoft Corporation FYE June 30 2015 (000) 93,580,000 33,038,000 Income Statement Net sales Cost of sales Gross margin Research & development expense Selling, general & admin expense 1,993,000 Total operating expenses Operating expenses Operating margin Interest & dividend income Interest expense Other Income / Expense Total Other income Earnings before taxes Provision for taxes 70,537,000 60,542,000 12,046,000 20,324,000 10,011,000 6,041,000 18,034,000 52,503,000 42,381,000 18,161,000 1,795,000 384,000 -431,000 766,000 781,000 361,000 980,000 53,483,000 346,000 18,507,000 13,973,000 6,314,000 Net income (loss) 39,510,000 12,193,000Explanation / Answer
ROIC=NET OPERATING PROFIT AFTER TAX/INVESTED CAPITAL
=53483000+384000/23313000+28987000
=53867000/52300000
=103%
Tax Rate = 13973000/53483000*100
=26.13%
Operating Margin = 52303000/182795000*100
= 28.61%
COGS/REVENUE = Cost Of Sales / Sales
= 112258000/182895000*100= 61.41%
R&D/REVENUE = R&D/Sales
=6041000/182795000*100=3.30%