Scribd
Upload
24 views2 pages

Microsoft Profitability Analysis 2011-2016

The document provides financial data for Microsoft Corporation from 2011 to 2016 including sales and net income. It asks to calculate the net profit margin for each year, compound annual growth rate for sales and net income, and complete a quiz on the topic.

Uploaded by

Lovepreet malhi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
24 views2 pages

Microsoft Profitability Analysis 2011-2016

The document provides financial data for Microsoft Corporation from 2011 to 2016 including sales and net income. It asks to calculate the net profit margin for each year, compound annual growth rate for sales and net income, and complete a quiz on the topic.

Uploaded by

Lovepreet malhi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Using Formuals Complete the Following

1. For each year calculate the net profit margin in%


2. Calculate the Compound Annual Growth Rate for both Sales Growth and Net Income Growth
3. Go into D2L and Complete Quiz Week 2
Microsoft Corporation Profitability Analysis
(Millions of Dollars)
2011 to 2016
2016 2015 2014 2013 2012 2011
Sales 85,320.00 93,580.00 86,833.00 77,849.00 73,723.00 69,943.00
Net Income 16,798.00 12,193.00 22,074.00 21,863.00 16,978.00 23,150.00
Net Profit Margin
Sales Growth (CAGR)
Net Income Growth (CAGR)

You might also like