MBA 606 Final Project - Forecasting Your Company Here is the 10k for nike which is the company I am doing https://s1.q4cdn.com/806093406/files/doc_downloads/2022/399556(1)_27_Nike-Inc._NPS_Combo_Form- 10-K_WR.pdf Be sure to include a cover page and References page for this assignment. For the publicly-traded company you selected to evaluate for this course, download their most recent 10K. Include the link to the financial statements as a reference on your References page. I cannot verify your answers without a link to the financial statements. This assignment is worth 150 points due at the end of Module 8. - Do the following in Excel: Common-size your Income Statements and Balance Sheets In addition to common-sizing, calculate the following: Sales Growth % PP&E (Gross) Growth % AR Turnover (which is just the denominator in the Days to Collect AR metric) = Sales Revenue Accounts Receivable . Inventory Turnover (which is just the denominator in the Days to Move Inventory metric) = COGS / Inventory Accounts Payable Turnover (which is how fast they pay for their Inventory) = COGS/Accounts Payable . Depreciation Expense as a % of Gross PP&E = Depreciation Expense / Gross PP&E Go into the footnotes of your company's financial statements and find the following: Effective interest rate on Long-Term Debt . Plans to pay down Long Term Debt Effective tax rate (as a % of Pretax Income)