This assignment to analyze the financial statements from Nike. You must submit your spreadsheet online as an attachment to this Canvas assignment by 11:59 pm on Mon. May 3. You may discuss the assignment with your teammates, but you must complete your own assignment (you may not copy any part of another student's assignment).
I have published in Connect videos about analyzing financial statements and understanding ratios from chapter 13 of the textbook (available in the online version only).
The assignment to be completed is the MS Excel spreadsheet file linked below. You must download and save a copy, then read and follow the instructions on the "Instructions" worksheet. Note that this spreadsheet file contains 9 tabbed worksheets (including the instructions). You must complete entries on the blue "Questions" worksheet, the 2 green Inc Stmt sheets, and the 2 red Bal Sheet worksheets.
You must save your completed Excel spreadsheet and submit it as an attachment to this Canvas assignment by the due date and time to receive credit. We will grade the most recent submission BEFORE the due date and time. It is HIGHLY RECOMMENDED that, immediately after you submit the completed assignment, you reopen the Canvas assignment, use the [download] option to download the spreadsheet file you attached, then open it in Excel to make sure it appears to be properly formatted and completed. We CANNOT ACCEPT resubmission after the due date/time to correct technical issues since we will be publishing the solution.
DO NOT change the format of the Excel file. Do not insert or delete rows or columns on any worksheet. You should only enter formulas or values in the cells provided. This assignment is partially graded by automatic comparison with a key, so changes to the locations of answers will cause numerous errors.
Excel spreadsheet: [Proj 3 - Nike Fin Stmts.xlsx download] ... download, complete and submit via this Canvas assignmentExcerpts from Nike's XXXXXXXXXXK for reference (32 pgs): [Nike 10-K 2020 Excerpts.pdf download]