Create a Historical Financial Analysis of Nike for the past 3 years (2021 current) Use quarterly data
Question:
Create a Historical Financial Analysis of Nike for the past 3 years (2021 current)
Use quarterly data and create financial ratio analysis for Nike. Also, you must show how you calculated the valuation multiples. Below are sample tables of how the Valuation Multiples should displayed.
NOTE:
You must explain where you collected the data and how to calculate.
Example Charts:
Historical Financial Analysis:
Earnings | Equity Book Value | Sales | ... | Cash Flow | Debt | |
2020 | ||||||
2019 | ||||||
2018 |
______________________________________________________________
Valuation Multiples:
Types of Multiples | 2021 Quarter 3 | … | 2018 Quarter 4 |
P/E Ratio | |||
... | |||
… | |||
Other ratios |
________________________________________________________
Based on Industry (2021 Q3): | ||||
Type of Multiples | Industry | Your Company | ||
P/E Ratio | ||||
... | ||||
... | ||||
Other ratios | ||||
Average of Similar Multiples | ||||
__________________________________________________________ |
Free Cash Flow Analysis:
Projected Free Cash Flow | 2018 | 2019 | 2020 |
Profit after Taxes | |||
Add back depreciation | |||
Add back interest expenses, net of taxes | |||
Subtract interest costs, net of taxes | |||
Subtract increase in current assets, except cash | |||
Add back increase in current liabilities | |||
Subtract increase in property and equipment at cost | |||
Free Cash Flow |