Executive Solution Overview
see attachments – ## RatioAnalysisTemplatefortheWeek7Project-Nike.V2.xlsx – ## NikeAssignmentcopy.docx – NikeInc_2020_Annual_Report.pdf – NikeInc_2019_Annual_Report.pdf – NikeInc_2022_Annual_Report.pdf – NikeInc_2021_Annual_Report.pdf **## RatioAnalysisTemplatefortheWeek7Project-Nike.V2….
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
see attachments
– ## RatioAnalysisTemplatefortheWeek7Project-Nike.V2.xlsx
– ## NikeAssignmentcopy.docx
– NikeInc_2020_Annual_Report.pdf
– NikeInc_2019_Annual_Report.pdf
– NikeInc_2022_Annual_Report.pdf
– NikeInc_2021_Annual_Report.pdf
**## RatioAnalysisTemplatefortheWeek7Project-Nike.V2.xlsx**
## Ratio Analysis
| | | | | | | |
| — | — | — | — | — | — | — |
| | Ratio | Formula | 2019 | 2020 | 2021 | 2022 |
| | Current Ratio | CA/CL |
| | Inventory Turnover | COGS/Avg Inv |
| | Days Sales Outstanding (DSO) | (Avg AR/Revenue)*365 |
| | Days Inventory Outstanding (DIO) | (Avg Inv/COGS)*365 |
| | Days Payables Outstanding (DPO) | (AP/COGS)*365 |
| | Gross Profit Margin | (Revenue-COGS)/Revenue |
| | Net Profit Margin | Net Income/Revenue |
| | Return on Assets (ROA) | Net Income/Total Assets |
| | Return on Equity (ROE) | Net Income/Shareholder's Equity |
| | Free Cash Flow | | 2019 | 2020 | 2021 | 2022 |
| | Operating Cash Flow |
| | Capital Expenditures (CAPEX) |
| | FCF | | $ – 0 | $ – 0 | $ – 0 | $ – 0 |
**## NikeAssignmentcopy.docx**
**Project Background:** The 2020 pandemic was a significant event that had a broad-based impact on the global business environment. One of the more lingering issues that arose both during and even more so, after the pandemic, was the global supply chain disruption created by the shutdowns that were required during the pandemic. The focus of this project is to assess the impact of the supply chain disruption on a selected company and to evaluate the key financial impacts of the disruption, the company-specific risk factors that are present, and provide insight into how to potentially deal with these issues in the future.
**Company Selection:** The first step in this assignment is to choose on of the following companies as the focus of your analysis,
·
**Nike Inc.:** is an American multinational association that is involved in the design, development, manufacturing and worldwide marketing and sales of apparel, footwear, accessories, equipment and services.
**Overview of the Assignment:** You have been asked by the company Board of Directors (BoD) to complete an analysis of the impact of the global supply chain disruption on the chosen company. In order to complete this assignment, you will need to complete a ratio/FCF analysis of the company, assess the financial results, and use insight/commentary provided in the annual report to develop the narrative required to support the Board request. The final deliverables for the project include the completed Excel template and a PPT presentation, that should be structured in a way to support an in-person presentation to the BoD at the next quarterly meeting.
**Key Focal Points of the Assignment:**
1.
**Excel ratio/FCF analysis**: Develop an accurate ratio/FCF analysis using the template provided.
2.
**Assessment of the financial impact of the disruption**: Using the completed analysis as a guide, provide a comprehensive assessment of the financial impact of the disruption on the chose company. This assessment should not only be focused on the calculated metrics, but rather a broad-based analysis of the overall financial impact of the disruption.
3.
**Cash flow impact assessment**: In addition to the overall financial impact analysis, provide a targeted assessment of the impact on operational cash flows due to the disruption.
4.
**Risk Assessment**: Based on the results of the analysis, develop a risk assessment for the company which highlights the key factors that were impacted by the global pandemic supply chain disruption.
5.
**Strategic Recommendations**: Providing a comprehensive summary and at least three recommendations for how the company could avoid these impacts that could result from future supply chain disruptions.
**Task**
The final deliverable for the project should include the following:
· 12–15-slide PPT presentation
· At least 150-200 words of slide notes per slide
· Completion and submission of the Excel template (please include the calculation results table on one of the slides in the PPT deck)
· Be sure that the Excel template submission includes calculations in the cells (not hard-coded numbers)
**NikeInc_2020_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2020-annual-report-pdf)
**NikeInc_2019_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2019-annual-report-pdf)
**NikeInc_2022_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2022-annual-report-pdf)
**NikeInc_2021_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2021-annual-report-pdf)
**NikeInc_2021_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2021-annual-report-pdf)
**## RatioAnalysisTemplatefortheWeek7Project-Nike.V2.xlsx**
## Ratio Analysis
| | | | | | | |
| — | — | — | — | — | — | — |
| | Ratio | Formula | 2019 | 2020 | 2021 | 2022 |
| | Current Ratio | CA/CL |
| | Inventory Turnover | COGS/Avg Inv |
| | Days Sales Outstanding (DSO) | (Avg AR/Revenue)*365 |
| | Days Inventory Outstanding (DIO) | (Avg Inv/COGS)*365 |
| | Days Payables Outstanding (DPO) | (AP/COGS)*365 |
| | Gross Profit Margin | (Revenue-COGS)/Revenue |
| | Net Profit Margin | Net Income/Revenue |
| | Return on Assets (ROA) | Net Income/Total Assets |
| | Return on Equity (ROE) | Net Income/Shareholder's Equity |
| | Free Cash Flow | | 2019 | 2020 | 2021 | 2022 |
| | Operating Cash Flow |
| | Capital Expenditures (CAPEX) |
| | FCF | | $ – 0 | $ – 0 | $ – 0 | $ – 0 |
**## NikeAssignmentcopy.docx**
**Project Background:** The 2020 pandemic was a significant event that had a broad-based impact on the global business environment. One of the more lingering issues that arose both during and even more so, after the pandemic, was the global supply chain disruption created by the shutdowns that were required during the pandemic. The focus of this project is to assess the impact of the supply chain disruption on a selected company and to evaluate the key financial impacts of the disruption, the company-specific risk factors that are present, and provide insight into how to potentially deal with these issues in the future.
**Company Selection:** The first step in this assignment is to choose on of the following companies as the focus of your analysis,
·
**Nike Inc.:** is an American multinational association that is involved in the design, development, manufacturing and worldwide marketing and sales of apparel, footwear, accessories, equipment and services.
**Overview of the Assignment:** You have been asked by the company Board of Directors (BoD) to complete an analysis of the impact of the global supply chain disruption on the chosen company. In order to complete this assignment, you will need to complete a ratio/FCF analysis of the company, assess the financial results, and use insight/commentary provided in the annual report to develop the narrative required to support the Board request. The final deliverables for the project include the completed Excel template and a PPT presentation, that should be structured in a way to support an in-person presentation to the BoD at the next quarterly meeting.
**Key Focal Points of the Assignment:**
1.
**Excel ratio/FCF analysis**: Develop an accurate ratio/FCF analysis using the template provided.
2.
**Assessment of the financial impact of the disruption**: Using the completed analysis as a guide, provide a comprehensive assessment of the financial impact of the disruption on the chose company. This assessment should not only be focused on the calculated metrics, but rather a broad-based analysis of the overall financial impact of the disruption.
3.
**Cash flow impact assessment**: In addition to the overall financial impact analysis, provide a targeted assessment of the impact on operational cash flows due to the disruption.
4.
**Risk Assessment**: Based on the results of the analysis, develop a risk assessment for the company which highlights the key factors that were impacted by the global pandemic supply chain disruption.
5.
**Strategic Recommendations**: Providing a comprehensive summary and at least three recommendations for how the company could avoid these impacts that could result from future supply chain disruptions.
**Task**
The final deliverable for the project should include the following:
· 12–15-slide PPT presentation
· At least 150-200 words of slide notes per slide
· Completion and submission of the Excel template (please include the calculation results table on one of the slides in the PPT deck)
· Be sure that the Excel template submission includes calculations in the cells (not hard-coded numbers)
**NikeInc_2020_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2020-annual-report-pdf)
**NikeInc_2019_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2019-annual-report-pdf)
**NikeInc_2022_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2022-annual-report-pdf)
**NikeInc_2021_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2021-annual-report-pdf)
**## RatioAnalysisTemplatefortheWeek7Project-Nike.V2.xlsx**
## Ratio Analysis
| | | | | | | |
| — | — | — | — | — | — | — |
| | Ratio | Formula | 2019 | 2020 | 2021 | 2022 |
| | Current Ratio | CA/CL |
| | Inventory Turnover | COGS/Avg Inv |
| | Days Sales Outstanding (DSO) | (Avg AR/Revenue)*365 |
| | Days Inventory Outstanding (DIO) | (Avg Inv/COGS)*365 |
| | Days Payables Outstanding (DPO) | (AP/COGS)*365 |
| | Gross Profit Margin | (Revenue-COGS)/Revenue |
| | Net Profit Margin | Net Income/Revenue |
| | Return on Assets (ROA) | Net Income/Total Assets |
| | Return on Equity (ROE) | Net Income/Shareholder's Equity |
| | Free Cash Flow | | 2019 | 2020 | 2021 | 2022 |
| | Operating Cash Flow |
| | Capital Expenditures (CAPEX) |
| | FCF | | $ – 0 | $ – 0 | $ – 0 | $ – 0 |
**## NikeAssignmentcopy.docx**
**Project Background:** The 2020 pandemic was a significant event that had a broad-based impact on the global business environment. One of the more lingering issues that arose both during and even more so, after the pandemic, was the global supply chain disruption created by the shutdowns that were required during the pandemic. The focus of this project is to assess the impact of the supply chain disruption on a selected company and to evaluate the key financial impacts of the disruption, the company-specific risk factors that are present, and provide insight into how to potentially deal with these issues in the future.
**Company Selection:** The first step in this assignment is to choose on of the following companies as the focus of your analysis,
·
**Nike Inc.:** is an American multinational association that is involved in the design, development, manufacturing and worldwide marketing and sales of apparel, footwear, accessories, equipment and services.
**Overview of the Assignment:** You have been asked by the company Board of Directors (BoD) to complete an analysis of the impact of the global supply chain disruption on the chosen company. In order to complete this assignment, you will need to complete a ratio/FCF analysis of the company, assess the financial results, and use insight/commentary provided in the annual report to develop the narrative required to support the Board request. The final deliverables for the project include the completed Excel template and a PPT presentation, that should be structured in a way to support an in-person presentation to the BoD at the next quarterly meeting.
**Key Focal Points of the Assignment:**
1.
**Excel ratio/FCF analysis**: Develop an accurate ratio/FCF analysis using the template provided.
2.
**Assessment of the financial impact of the disruption**: Using the completed analysis as a guide, provide a comprehensive assessment of the financial impact of the disruption on the chose company. This assessment should not only be focused on the calculated metrics, but rather a broad-based analysis of the overall financial impact of the disruption.
3.
**Cash flow impact assessment**: In addition to the overall financial impact analysis, provide a targeted assessment of the impact on operational cash flows due to the disruption.
4.
**Risk Assessment**: Based on the results of the analysis, develop a risk assessment for the company which highlights the key factors that were impacted by the global pandemic supply chain disruption.
5.
**Strategic Recommendations**: Providing a comprehensive summary and at least three recommendations for how the company could avoid these impacts that could result from future supply chain disruptions.
**Task**
The final deliverable for the project should include the following:
· 12–15-slide PPT presentation
· At least 150-200 words of slide notes per slide
· Completion and submission of the Excel template (please include the calculation results table on one of the slides in the PPT deck)
· Be sure that the Excel template submission includes calculations in the cells (not hard-coded numbers)
**NikeInc_2020_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2020-annual-report-pdf)
**NikeInc_2019_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2019-annual-report-pdf)
**NikeInc_2022_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2022-annual-report-pdf)
**NikeInc_2021_Annual_Report.pdf**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/nikeinc-2021-annual-report-pdf)
– 1
– 2
– 3
– 4
– 5
– 6