Description
Assume you have just earned your master's degree in finance and are now employed by the Cosmo K Manufacturing Group. Your employment is contingent on your successful completion of several tasks over the next four weeks and the successful completion of a comprehensive exam to obtain company certification in finance. Each week, you will be assigned projects of interest to the company that will test your competence in finance.
Gerry has decided that you need some experience in evaluating other firms in the marketplace. Accordingly, he has asked you to select any company listed on the NYSE or the NASDAQ. For your selected company, identify and download the most recent financial statements for the last three to five years, to include the following:
- Balance sheet
- Income statement
- Per share data
Tasks:
Gerry would like you to complete the following tasks and submit your report by the end of the week:
- Identify the predominant industry in which your company operates. Find the industry averages for that industry for the following ratios:
- Current ratio
- Debt ratio
- Quick ratio
- Debt-equity ratio
- Total asset turnover
- Profit margin
- Inventory turnover
- Return on assets
- Receivables turnover
- Return on equity
- Calculate as many of the listed ratios for your selected company as possible using the financial statements you acquired.
- Conduct a trend analysis for the last three to five years. What trends can you identify? What do they indicate?
- Compare the ratios for the last common year to the industry averages. What conclusions can you draw regarding your company's performance? What are your company's strengths and weaknesses?
- Identify the changes that need to be made by the company to improve its performance, as compared to the industry, on the basis of the ratios.
- Conduct a DuPont analysis for your selected company. What conclusions can you draw for improving your company's performance on the basis of this analysis?
Submission Details:
- Present the numerical data and calculations in a Microsoft Excel sheet and write the analyses in a Microsoft Word document.
- Name your Microsoft Excel sheet MBA6010_W1_A3_LastName_
FirstName.xls and Microsoft Word document MBA6010_W1_A3_
LastName_FirstName.doc.
Explanation & Answer
Hey there! All set. Let me know if you need anything else :) If not, I would greatly appriciate a 5 star review.
NIKE Inc (NYS: NKE)
Exchange rate used is that of the
Year End reported date
As Reported Annual Balance Sheet
Report Date
Currency
Audit Status
Consolidated
Cash
Cash & equivalents
Short-term investments
Accounts receivable, gross
05/31/2015
USD
Not Qualified
Yes
3.852.000.000
2.072.000.000
3.436.000.000
05/31/2014
USD
Not Qualified
Yes
2.220.000.000
2.922.000.000
3.512.000.000
Less: allowance for uncollectible accounts receivable
43.000.000
Accounts receivable, net
3.241.000.000
Finished goods
4.838.000.000
Work-in-progress
Raw materials
Inventories
4.838.000.000
Income taxes receivable
Deferred income taxes
-
78.000.000
3.358.000.000
4.337.000.000
4.337.000.000
389.000.000
78.000.000
3.434.000.000
3.947.000.000
3.947.000.000
355.000.000
Prepaid expenses & other current assets 1.489.000.000
Prepaid expenses
Total current assets
15.025.000.000
Land
286.000.000
Buildings
1.467.000.000
Machinery & equipment
-
1.968.000.000
15.976.000.000
273.000.000
1.250.000.000
-
818.000.000
13.696.000.000
270.000.000
1.261.000.000
-
Machinery, equipment & internal-use software
3.510.000.000
Leasehold improvements
1.338.000.000
Construction in process
437.000.000
3.329.000.000
1.150.000.000
350.000.000
3.376.000.000
1.066.000.000
247.000.000
Total property, plant & equipment, gross 7.038.000.000
6.352.000.000
6.220.000.000
Less: accumulated depreciation
3.518.000.000
3.341.000.000
3.386.000.000
Property, plant & equipment, net
3.520.000.000
3.011.000.000
2.834.000.000
Identifiable intangible assets, net
Goodwill
281.000.000
131.000.000
281.000.000
131.000.000
282.000.000
131.000.000
-
-
-
2.439.000.000
21.396.000.000
2.201.000.000
21.600.000.000
1.651.000.000
18.594.000.000
Identifiable intangible assets & goodwill
Deferred income taxes & other assets
Total assets
05/31/2016
USD
Not Qualified
Yes
3.138.000.000
2.319.000.000
3.284.000.000
Current portion of long-term debt
Notes payable to bank
Notes payable
Accounts payable
44.000.000
1.000.000
2.191.000.000
107.000.000
74.000.000
2.131.000.000
7.000.000
167.000.000
1.930.000.000
Accrued compensation & benefits, excluding943.000.000
taxes
997.000.000
782.000.000
Accrued endorsement compensation
Accrued dividends payable
393.000.000
271.000.000
388.000.000
240.000.000
328.000.000
209.000.000
Accrued import & logistics costs
198.000.000
207.000.000
127.000.000
Accrued fair value of derivatives
162.000.000
162.000.000
85.000.000
Accrud taxes other than income taxes
159.000.000
174.000.000
204.000.000
Accrual collateral received from counterparties
105.000.000
to hedging instruments
968.000.000
-
Accrued advertising & marketing
119.000.000
117.000.000
133.000.000
Accrued restructuring charges
Accrued tax
Converse arbitration
Other accrued liabilities
Accrued liabilities
Income taxes payable
687.000.000
3.037.000.000
85.000.000
698.000.000
3.951.000.000
71.000.000
623.000.000
2.491.000.000
432.000.000
Liabilities of discontinued operations
Total current liabilities
Corporate bond payables
Promissory notes
Japanese Yen notes
Medium-term notes
Other long-term debt
Total long-term debt
Less: current maturities
Long-term debt
Deferred income taxes
5.358.000.000
1.989.000.000
38.000.000
27.000.000
2.054.000.000
44.000.000
2.010.000.000
-
6.334.000.000
1.099.000.000
58.000.000
29.000.000
1.186.000.000
107.000.000
1.079.000.000
-
5.027.000.000
1.106.000.000
58.000.000
42.000.000
1.206.000.000
7.000.000
1.199.000.000
-
Deferred income taxes & other liabilities
Redeemable preferred stock
1.770.000.000
-
1.480.000.000
-
1.544.000.000
-
-
-
-
3.000.000
3.000.000
3.000.000
7.786.000.000
6.773.000.000
5.865.000.000
Minority interest in unconsolidated subsidiaries
Other liabilities
Class A convertible common stock
Class B common stock
Capital in excess of stated value
Unearned stock compensation
Foreign currency translation adjustment
(207.000.000)
Cumulative translation adjustment & other comprehensive
- income (loss)
Cash flow hedges
463.000.000
Net investment hedges
115.000.000
Other accumulated other comprehensive income
(53.000.000)
(loss)
Accumulated other comprehensive income (loss)
318.000.000
Retained earnings
4.151.000.000
Total shareholders' equity
12.258.000.000
(11.000.000)
1.220.000.000
95.000.000
(58.000.000)
1.246.000.000
4.685.000.000
12.707.000.000
9.000.000
32.000.000
95.000.000
(51.000.000)
85.000.000
4.871.000.000
10.824.000.000
05/31/2013
USD
Not Qualified
Yes
3.337.000.000
2.628.000.000
3.221.000.000
05/31/2012
USD
Not Qualified
Yes
2.317.000.000
1.440.000.000
3.375.000.000
05/31/2011
USD
Not Qualified
Yes
1.955.000.000
2.583.000.000
3.262.000.000
104.000.000
3.117.000.000
3.434.000.000
3.434.000.000
308.000.000
95.000.000
3.280.000.000
3.350.000.000
3.350.000.000
274.000.000
124.000.000
3.138.000.000
2.715.000.000
2.715.000.000
312.000.000
802.000.000
13.626.000.000
268.000.000
1.174.000.000
-
870.000.000
11.531.000.000
252.000.000
1.158.000.000
-
594.000.000
11.297.000.000
237.000.000
1.124.000.000
2.487.000.000
2.985.000.000
945.000.000
128.000.000
2.755.000.000
968.000.000
111.000.000
931.000.000
127.000.000
5.500.000.000
5.244.000.000
4.906.000.000
3.048.000.000
2.965.000.000
2.791.000.000
2.452.000.000
2.279.000.000
2.115.000.000
382.000.000
131.000.000
535.000.000
201.000.000
487.000.000
205.000.000
-
-
-
993.000.000
17.584.000.000
919.000.000
15.465.000.000
894.000.000
14.998.000.000
Cash
Cash & equivalents
Short-term investments
Accounts receivable, gross
Less: allowance for
uncollectible accounts
receivable
Accounts receivable, net
Finished goods
Work-in-progress
Raw materials
Inventories
Income taxes receivable
Deferred income taxes
Prepaid expenses & other
current assets
Prepaid expenses
Total current assets
Land
Buildings
Machinery & equipment
Machinery, equipment &
internal-use software
Leasehold improvements
Construction in process
Total property, plant &
equipment, gross
Less: accumulated
depreciation
Property, plant & equipment,
net
Identifiable intangible assets,
net
Goodwill
Identifiable intangible assets &
goodwill
Deferred income taxes & other
assets
Total assets
57.000.000
121.000.000
1.646.000.000
49.000.000
108.000.000
1.588.000.000
200.000.000
187.000.000
1.469.000.000
713.000.000
711.000.000
628.000.000
264.000.000
188.000.000
294.000.000
165.000.000
284.000.000
145.000.000
111.000.000
133.000.000
98.000.000
34.000.000
55.000.000
186.000.000
192.000.000
179.000.000
214.000.000
-
-
-
77.000.000
132.000.000
139.000.000
407.000.000
1.986.000.000
98.000.000
384.000.000
2.053.000.000
67.000.000
291.000.000
1.985.000.000
117.000.000
18.000.000
3.926.000.000
1.159.000.000
59.000.000
49.000.000
1.267.000.000
57.000.000
1.210.000.000
-
3.865.000.000
205.000.000
72.000.000
277.000.000
49.000.000
228.000.000
-
3.958.000.000
206.000.000
270.000.000
476.000.000
200.000.000
276.000.000
-
1.292.000.000
-
991.000.000
-
921.000.000
-
-
-
-
3.000.000
3.000.000
3.000.000
5.184.000.000
4.641.000.000
3.944.000.000
Current portion of long-term
debt
Notes payable to bank
Notes payable
Accounts payable
Accrued compensation &
benefits, excluding taxes
Accrued endorsement
compensation
Accrued dividends payable
Accrued import & logistics
costs
Accrued fair value of
derivatives
Accrud taxes other than
income taxes
Accrual collateral received
from counterparties to hedging
instruments
Accrued advertising &
marketing
Accrued restructuring charges
Accrued tax
Converse arbitration
Othe...