Excel assignment
Company costco
1)Calculate ratios from the SIX focus areas (including market ratios) for three historical years.
2)Graph EBIT, EBITDA, NOPAT, Net Income, CFFO and FCF (levered) for the three historical years.
3)List what you believe to be the strongest focus area and briefly describe why (a few sentences will do)
4)List what you believe to be the weakest focus area and briefly describe why.
5) Do a DuPont Model Analysis for your chosen company (using the most recent fiscal year-end financials) and also for the company you consider to be it’s greatest competitor. Briefly explain the differences between the two competitors in terms of profitability, efficiency, leverage and return.