Managerial Finance, accounting homework help

User Generated

Eynebav

Business Finance

Managerial Finance

South University

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Really useful study material!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags