Question: Using a spreadsheet, prepare the following for the most recent two years of Best Buy Co., Inc. (years 2019 & 2018) located here: http://investors.bestbuy.com/investor-relations/financial-info/annual-reports-and-proxy-statements/default.aspx -Comparative
Using a spreadsheet, prepare the following for the most recent two years of Best Buy Co., Inc. (years 2019 & 2018) located here: http://investors.bestbuy.com/investor-relations/financial-info/annual-reports-and-proxy-statements/default.aspx
-Comparative Income Statement- Vertical Analysis
-Comparative Balance Sheet- Horizontal Analysis
Best Buy Co., Inc. (Ticker: BBY): Vertical Analysis- Income Statement
2019 2018
| Income Statement | Amount | Percent | Amount | Percent |
| Net sales |
|
|
|
|
| Cost of sales |
|
|
|
|
| Selling, general, & admin exp |
|
|
|
|
| Depreciation & amortization |
|
|
|
|
| Litigation, Impairment & other charges |
|
|
|
|
| Net interest exp |
|
|
|
|
| Other income |
|
|
|
|
| Income before income tax |
|
|
|
|
| Income tax ezp |
|
|
|
|
| Net income |
|
|
|
|
|
|
|
|
|
|
Best Buy Co., Inc. (Ticker: BBY): Horizontal Analysis- Balance Sheet
| Balance Sheet | 2019 | 2018 | Change | Change |
| ASSETS | Amount | Amount | Amount | Percent |
| Current Assets |
|
|
|
|
| Cash & Cash Equivalents |
|
|
|
|
| Merchandise Inventories |
|
|
|
|
| Other Current Assets |
|
|
|
|
| Total Current Assets |
|
|
|
|
| Property & Equipment, Net |
|
|
|
|
| Deferred Taxes |
|
|
|
|
| Goodwill |
|
|
|
|
| Other Intangible Assets, Net |
|
|
|
|
| Other Assets |
|
|
|
|
| TOTAL ASSETS |
|
|
|
|
|
|
|
|
|
|
| LIABILITIES & SHAREHOLDERS EQUITY |
|
|
|
|
| Current Liabilities |
|
|
|
|
| Accounts payable |
|
|
|
|
| Accrued and other liabilities |
|
|
|
|
| Current portion of capital lease obligations |
|
|
|
|
| Total Current Liabilities |
|
|
|
|
| Long-Term Debt Obligations Under Capital Leases |
|
|
|
|
| Other Liabilities |
|
|
|
|
| Total Liabilities |
|
|
|
|
| Shareholders Equity |
|
|
|
|
| TOTAL LIABILITIES AND SHAREHOLDERS EQUITY |
|
|
|
|
|
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
