The total stockholders’ equity case study

Please Submit both word and Excel Files. Please add references in Alphabetical order.

Info on Attached Files: Please follow the attached files

1)This attachment gives info what we need to do for the assignment

2) Sample Course Project Facebook excel-This attachment should be used for reference and need to do the same format for NIKE using their recent 10K(I also attached there recent 10k please use this 10k Only)

3)Sample Memo For Facebook-Use this for reference and Create the same Memo for NIKE

4)Nike Recent 10K 2022 may 31st-Please use this 10k Only for Analysis/calculations please don’t use any other Nike 10K’s year

Notes from 10K Nike 2022 May 31 as discussed with professor: We need to get the same values in excel

a)Nike’s revenues on their 2022 10K as of May 31, 2022 was $46,710 in millions and their total assets was $40,321 in millions.(You can see this from attached 10K)

b) times interest earned ratio is 33.44

c) liabilities to equity ratio is 163.96%

d) ROA is 15.49%. We always average the total assets

e) ROE is 43.11%. We always average .

f) PPE turnover is 9.64. We always average the property, plant, and equipment

g) AP turnover is 8.02. We always average the accounts payable.

h) inventory turnover is 3.30. We always average the inventory

I) the accounts receivable turnover is 10.23. We always average the accounts receivable. To calculate the average, you add the May 31, 2022 AR number plus the May 31, 2021 number and divide by 2.

j) the net profit margin was 12.94%

k) Net income was $6,046 and net sales $46,710

L) gross profit margin is 45.98%.

M) Nike current ratio should be 2.63 ($28,213 divided by $10,730)

All these values are correct as discussed with professor. We should also get the same values in excel. For formulas and how they are calculated you can check attached referencehelpfinal project attched document

5) Reference Help final project Document-This attached file is used for reference how to calculate(Attached example’s from text book-please analyze and calculate accordingly)How to calculate income statement, Balance sheets,ratio’s,Forecasting balance sheets, Forecasting income statement, .This document is very much useful for calculational attached examples are from text book i also provided the solutions. Please calculate accordingly

Notes From Professor:(Please kindly look the notes its very important while analyzing/preparing the assignment)

Q1) When is the due?

A1) Friday October 14, 2022 at 11: