Trends in the Growth, Profitability and Financial Ratios for Target Corp
Financials
2015-01
Revenue USD Mil
Gross Margin %
Operating Income USD Mil
Operating Margin %
Net Income USD Mil
Earnings Per Share USD
Dividends USD
Working Capital USD Mil
Key Ratios -> Profitability
Profitability
Net Margin %
Asset Turnover (Average)
Return on Assets %
Financial Leverage (Average)
Return on Equity %
Return on Invested Capital %
Liquidity/Financial Health
Current Ratio
Quick Ratio
Financial Leverage
Debt/Equity
2015 Company Financials to the Industry Averages
Profitability
Net Margin %
Return on Assets %
Return on Equity %
Return on Invested Capital %
Liquidity/ Solvency ratios
Current Ratio
Quick Ratio
Debt/Equity
72,618
29.4
4,535
6.2
-1,636
-2.56
1.9
2,351
2015-01
-2.25
1.69
-3.81
2.96
-10.82
-5.76
2015-01
1.2
0.28
2.96
0.91
Target
-2.25
-3.81
-10.82
-5.76
Target
1.2
0.28
0.91
2016-01
2017-01
73,785
29.5
4,910
6.7
3,363
5.31
2.16
1,508
2016-01
69,495
29.7
4,969
7.2
2,737
4.7
2.32
-718
2017-01
4.56
1.8
8.24
3.11
24.95
12.81
2016-01
3.94
1.78
7.05
3.42
22.89
11.08
2017-01
1.12
0.38
3.11
0.92
Industrial Average
Difference
0.86
4.83
4.92
7.32
Industrial Average
1.31
0.57
81.2
0.94
0.26
3.42
1.01
3.11
8.64
15.74
13.08
-0.11
-0.29
-80.29
Plunkett Research Ltd. Copyright (C) All Rights Reserved
www.plunkettresearch.com
MICROSOFT CORPORATION (WWW.MICROSOFT.COM)
Ticker: MSFT
Exchange: NAS
Year Established: 1975
Employees: 118,000
Fiscal Year Ends in June
Phone: 425 882-8080
Fax: 425 936-7329
Address: One Microsoft Way
Redmond, WA 98052-6399 United States
Industry Ranks
Types Of Business
Industry NAICS code: 511210I
Computer Software, Operating Systems, Languages & Development
Tools
Enterprise Software
Game Consoles
Operating Systems
Software as a Service (SAAS)
Search Engine and Advertising
E-Mail Services
Instant Messaging
Contacts
Text
Satya Nadella
Amy Hood
John Thompson
Frank Brod
William Gates
Padmasree Warrior
Sandra Peterson
Charles Noski
Charles Scharf
G. Morfit
Helmut Panke
John Stanton
Teri List-Stoll
Margaret Johnson
Kathleen Hogan
Christopher Capossela
Jean-Philippe Courtois
Bradford Smith
Excel
CEO/Director
CFO/Executive VP
Chairman of the Board/Director
Chief Accounting Officer/Vice President,
Divisional
Co-Founder/Director/Other Corporate
Officer
Director
Director
Director
Director
Director
Director
Director
Director
Executive VP, Divisional
Executive VP, Divisional
Executive VP/Chief Marketing Officer
Executive VP/President, Divisional
Other Executive Officer/President
1. Microsoft Corporation
2. Quest Software Inc
3. Progress Software Corporation
4. Serena Software Inc
5. Access Co Ltd
6. IAR Systems Group AB
7. Wandisco PLC
85,320,000,000
920,000,000
405,341,000
210,000,000
73,767,850
34,552,140
10,994,000
Description
Microsoft Corporation develops, license and supports software
products, services and devices. It is a technology company that
builds best-in-class platforms and productivity services for a
mobile-first, cloud-first world. The firm’s products include
operating systems; cross-device productivity applications; server
applications; business solution applications; desktop and server
management tools; software development tools; video games; and
training and certification of computer system integrators and
developers. Microsoft also designs, manufactures and sells devices
such as personal computers (PCs), tablets, gaming and
entertainment consoles, phones, other intelligent devices and
related accessories that integrate with its cloud-based offerings.
The company operates its business in two segments: productivity
and business processes, which consists of products and services in
its portfolio of productivity, communication and information
services through its devices and platforms; and intelligent cloud,
which consists of the company’s public, private and hybrid server
products and cloud services that can power modern businesses.
Products offered through the productivity and business processes
segment include Office 365 and Dynamics. Products offered
through the intelligent cloud segment include SQL servers,
Windows servers, Visual Studio, system centers and Azure, as well
as enterprise and consulting services. In 2016, the firm sold its
entry-level phone business.
Auditor: DELOITTE & TOUCHE LLP
Legal Advisor:
-1-
Plunkett Research Ltd. Copyright (C) All Rights Reserved
Financials Financial Details
Compare to Industry Averages
$USD, In whole numbers,
except marked * or %
Financials
Revenue
Cost of Revenue
Gross Margin %
R&D Expense
Operating Income
Operating Margin %
SGA Expense
Net Income
Earnings Per Share
Dividends
Book Value Per Share
Operating Cash Flow
Capital Expenditure
Free Cash Flow
Profitability
EBITDA
Return on Assets %
Return on Equity %
Net Margin %
Assets Turnover
Financial Leverage
www.plunkettresearch.com
Build Custom Table
Compare Companies
2016
2015
2014
2013
2012
2011
85,320,000,000
32,780,000,000
61.58
11,988,000,000
20,182,000,000
23.65
19,260,000,000
16,798,000,000
2.12
1.39
9.10
33,325,000,000
8,343,000,000
24,982,000,000
93,580,000,000
33,038,000,000
64.70
12,046,000,000
18,161,000,000
19.41
20,324,000,000
12,193,000,000
1.49
1.21
9.77
29,080,000,000
5,944,000,000
23,136,000,000
86,833,000,000
26,934,000,000
68.98
11,381,000,000
27,759,000,000
31.97
20,632,000,000
22,074,000,000
2.66
1.07
10.97
32,231,000,000
5,485,000,000
26,746,000,000
77,849,000,000
20,249,000,000
73.99
10,411,000,000
26,764,000,000
34.38
20,425,000,000
21,863,000,000
2.61
0.89
9.84
28,833,000,000
4,257,000,000
24,576,000,000
73,723,000,000
17,530,000,000
76.22
9,811,000,000
21,763,000,000
29.52
18,426,000,000
16,978,000,000
2.02
0.76
8.67
31,626,000,000
2,305,000,000
29,321,000,000
69,943,000,000
15,577,000,000
77.73
9,043,000,000
27,161,000,000
38.83
18,162,000,000
23,150,000,000
2.73
0.61
7.09
26,994,000,000
2,355,000,000
24,639,000,000
27,616,000,000
9.08
22.09
19.69
0.46
2.69
25,245,000,000
7.00
14.36
13.03
0.54
2.20
33,629,000,000
14.02
26.17
25.42
0.55
1.92
31,236,000,000
16.58
30.09
28.08
0.59
1.80
25,614,000,000
14.77
27.51
23.03
0.64
1.83
31,132,000,000
23.77
44.84
33.10
0.72
1.90
Brands, Divisions and Affiliates
Office 365
Dynamics
SQL
Windows
Visual Studio
Azure
Other Thoughts
Apparent Female Officers or Directors:
Top Salaries
Name
Title
Satya Nadella
B. Turner
Amy Hood
Bradford
Smith
Margaret
Johnson
Director/CEO
COO
CFO/Executive VP
Other Executive
Officer/President
Executive VP, Divisional
Salary
Bonus
(US$)
(US$)
1,200,000 4,464,000
866,667
2,384,000
731,250
2,304,000
704,167
1,972,000
704,167
1,909,000
Corporate Culture
Microsoft offers its employees health, dental and vision coverage;
onsite health screenings; adoption assistance; childcare service
discounts; a 401(k) plan; an employee stock purchase plan; and
tuition assistance.
-2-
Plunkett Research Ltd. Copyright (C) All Rights Reserved
www.plunkettresearch.com
Income Statement
$USD, In whole numbers,
except marked * or %
Microsoft
Corporation
Industry Average of 5
Companies
Column Name
-
-
Total Revenue
93,580,001,280
19,158,518,085
Cost Of Revenue
33,038,000,128
8,343,922,534
Gross Profit
60,542,001,152
12,483,380,067
4,610,999,808
1,209,586,700
SGA Expense
20,323,999,744
5,352,566,301
R&D Expense
12,046,000,128
4,166,926,709
Other Operating Expenses
22,057,000,960
3,436,931,889
-
12,989,000
-
7,059,774
42,381,000,704
8,802,487,190
18,161,000,448
3,680,892,878
Misc Other Special Charges
355,000,000
355,000,000
Interest Expense
781,000,000
158,850,434
Gain On Sale Of Security
716,000,000
716,000,000
Other Income (expense)
361,000,000
122,501,333
18,506,999,808
3,750,610,133
6,313,999,872
1,282,305,760
Net Income from Continuous Operations
12,193,000,448
2,468,304,474
Net Income for Common Stockholders
12,193,000,448
2,468,304,474
Basic Earnings per Share
1.49
0.36
Diluted Earnings per Share
1.48
0.36
Basic Average Shares
8,176,999,936
1,688,820,594
Diluted Average Shares
8,254,000,128
1,704,764,034
1.21
0.83
Operating Expenses
General & Administrative Costs
Restructuring and Merger/Acquisition
Costs
Amortization
Total Operating Expenses
Operating Income
Pre-Tax Income
Income Taxes
Earnings per Share
Weighted Average Shares
Common Dividend
-1-
Plunkett Research Ltd. Copyright (C) All Rights Reserved
www.plunkettresearch.com
Balance Sheet
$USD, In whole numbers,
except marked * or %
Microsoft
Corporation
Industry Average of 5
Companies
Assets
Current Assets
Cash
-
186,240,992
5,594,999,808
1,373,463,377
90,931,003,392
30,391,719,131
96,526,003,200
31,951,423,500
17,908,000,768
6,147,493,587
2,902,000,128
1,451,282,733
Deferred Income Taxes
-
-
Prepaid Expenses
-
51,102,695
Other Current Assets
5,461,000,192
1,095,730,238
Total Current Assets
124,712,001,536
25,406,491,597
32,337,000,448
6,562,462,580
(17,606,000,640)
(3,570,797,114)
14,730,999,808
2,991,665,469
16,938,999,808
6,078,681,589
4,834,999,808
1,265,203,952
-
-
51,511,001,088
10,786,588,943
176,222,994,432
36,193,078,908
Short-Term Debt
7,484,000,256
3,746,687,628
Accounts Payable
6,591,000,064
1,326,866,829
23,222,999,040
8,147,780,349
6,766,000,128
1,353,729,616
49,857,998,848
10,282,268,206
27,808,000,000
9,552,800,661
Deferred Tax Liability
-
-
Minority Interest
-
-
Pensions & Other Benefits
-
-
Other Non Current Liabilities
13,543,999,488
2,721,229,485
Total Non Current Liabilities
46,281,998,336
9,524,483,154
96,140,001,280
19,806,752,205
Cash And Cash Equivalents
Short-Term Investments
Total Cash
Receivables
Inventory
Non-Current Assets
Gross Property, Plant &
Equipment
Accumulated Depreciation
Net Property, Plant &
Equipment
Goodwill
Intangible Assets
Other Long Term Assets
Total Non Current Assets
Total Assets
Liabilities and stockholders' equity
Liabilities
Current Liabilities
Deferred Revenues
Accrued Liabilities
Total Current Liabilities
Non-Current Liabilities
Long Term Debt
Total Liabilities
Stockholders' Equity
-2-
Plunkett Research Ltd. Copyright (C) All Rights Reserved
Common Stock
www.plunkettresearch.com
68,465,000,448
22,821,843,149
-
568,960,728
9,095,999,488
2,049,703,362
Preferred Stock
-
0
Treasury Stock
0
(1,515,288,064)
80,083,001,344
16,386,328,367
176,223,002,624
36,193,080,572
Additional Paid In Capital
Retained Earnings
Total Stockholders' Equity
Total Liabilities & Shareholders'
Equity
-3-
Plunkett Research Ltd. Copyright (C) All Rights Reserved
www.plunkettresearch.com
Cash Flow
$USD, In whole numbers,
except marked * or %
Operating Cash Flow
Microsoft
Corporation
Industry Average of 5
Companies
29,080,000,512
7,447,415,880
12,193,000,448
4,121,466,813
Depreciation And Amortization
5,957,000,192
1,521,203,298
Investment/Asset Impairment
7,497,999,872
3,751,480,936
224,000,000
81,890,667
-
-
1,456,000,000
334,621,500
-
-
(272,000,000)
(272,000,000)
(1,054,000,000)
(1,054,000,000)
-
(40,741,000)
(624,000,000)
(624,000,000)
-
2,481,000
Other Working Capital
1,512,999,936
437,926,236
Other Non CashItems
9,484,000,256
2,415,753,812
29,080,000,512
7,447,415,880
(23,000,999,936)
(4,719,315,600)
(5,944,000,000)
(1,199,409,787)
(12,867,999,744)
(4,288,648,248)
(3,723,000,064)
(1,420,298,688)
(98,729,000,960)
(33,107,243,312)
85,860,999,168
28,818,594,395
(466,000,000)
(90,926,413)
(23,000,999,936)
(4,719,315,600)
Financing Cash Flow
(9,080,000,512)
(1,758,868,722)
Issuance Of Debt
10,680,000,512
3,873,256,512
Repayment Of Debt
(1,500,000,000)
(552,744,000)
634,000,000
220,058,333
(9,882,000,384)
(4,944,503,072)
Other Financing Activities
950,000,000
182,648,132
Effect of Changes in Currency
Exchange Rates
(73,000,000)
(26,301,579)
(3,073,999,872)
(544,390,613)
Beginning Cash Position
8,668,999,680
1,917,828,367
End Cash Position
5,594,999,808
1,373,463,377
Operating Cash Flow
29,080,000,512
7,447,415,880
Capital Expenditure
(5,944,000,000)
(1,203,032,798)
Net Income
Deferred Income Taxes
Stock Based Compensation
Accounts Receivable
Cash From Discontinued Operating
Activities
Change In Inventory
Change In Account Payable
Prepaid Expenses
Accrued Liabilities
Income Tax Payable
Operating Cash Flow
Cash Flow from Investing
Purchase of Property, Plants &
Equipment
Net Investment Purchase & Sale
Acquisitions, net
Purchase Of Investments
Sales/Maturities of Investments
Net Other Investing Changes
Cash Flow from Investing
Common Stock Issued
Cash Dividends Paid
Net Change in Cash
Free Cash Flow
-4-
Plunkett Research Ltd. Copyright (C) All Rights Reserved
Free Cash Flow
www.plunkettresearch.com
23,136,000,000
-5-
4,757,087,993
Plunkett Research Ltd. Copyright (C) All Rights Reserved
www.plunkettresearch.com
Ratios
$USD,
Microsoft
Corporation
Industry Average of 5
Companies
Profitability Ratios
EBITDA Margin
0.27
-0.20
EBIT Margin
0.21
-0.43
Gross Margin %
64.70
85.15
Operating Margin %
19.41
-42.73
Tax Rate %
34.12
64.68
-
-
13.03
-46.18
Assets Turnover
0.54
0.56
Return on Assets (ROA) %
7.00
-20.94
14.36
-107.95
10.71
-109.36
Year over Year %
7.77
11.56
3-Year Average %
8.27
12.32
5-Year Average %
8.41
11.16
10-Year Average %
8.93
6.52
-34.58
-12.98
3-Year Average %
-5.85
0.51
5-Year Average %
-5.50
12.12
2.23
5.68
Year over Year %
-44.76
2.18
3-Year Average %
-10.45
22.08
5-Year Average %
-8.26
10.77
10-Year Average %
-0.05
5.26
-43.73
2.91
3-Year Average %
-9.55
22.19
5-Year Average %
-6.76
10.36
-
-
Year over Year %
-
-
3-Year Average %
-
-
5-Year Average %
-
-
10-Year Average %
-
-
Book Value PerShare
Net Margin %
Return on Equity (ROE) %
%
Return on Invested Capital (ROIC)
Growth Ratios
Revenue %
Operating Income %
Year over Year %
10-Year Average %
Net Income %
Diluted Earnings Per Share %
Year over Year %
10-Year Average %
Dividend %
Cash Flow Ratios
-6-
Plunkett Research Ltd. Copyright (C) All Rights Reserved
www.plunkettresearch.com
Operating Cash Flow
Year over Year %
-9.78
10.73
-13.50
31.36
Capital Expenditures to Sales
0.06
0.19
Free Cash Flow to Sales
0.25
0.27
Free Cash Flow to Net Income
1.90
2.11
Days in Sales
73.04
80.70
Days in Inventory
30.72
30.72
Days in Payment
77.46
131.22
793,051
306,810
26.30
26.30
5.00
5.04
11.88
11.88
Fixed Assets Turnover
6.75
20.22
Assets Turnover
0.54
0.56
Capital Expenditures to Sales
0.06
0.19
Current Ratio
2.50
1.68
Quick Ratio
2.30
1.49
Financial Leverage
2.20
2.29
Debt Equity Ratio
0.35
0.29
Free Cash Flow
Year over Year %
Efficiency
Sales per Employee $
Cash Conversion Cycle
Receivables Turnover
Inventory Turnover
Liquidity / Financial Health
-7-
Purchase answer to see full
attachment