Best Buy BBY on the NYSE

1)Create a vertical analysis of the income statement and of the balance sheet using information from the most current year.

2)Prepare a trend analysis for the last five years of information for sales, gross profit, operating income, and net income. Comment on the trends.

3)Using Excel formulas create the ratios discussed in the text (pages 439 to 441 of the course text not ratio 12) for the most current year; classify the ratios into appropriate categories for liquidity, turnover, solvency, profitability etc Please show the amounts you are using for the numerator and the denominator in your calculations so that is visually easy for me to follow your logic.

4)Comment on the performance of the company in light of the findings for each specific ratio group - liquidity, turnover, solvency, profitability, etc Your evaluation should reference each ratio group.

Numbers must be in millions

https://finance.yahoo.com/quote/BBY/financials?p=BBY

Above is the link to the company's financials