Question

In: Finance

Use the following tables to complete the critical thinking assignment. Best Buy Co., Inc. Income Statement...

Use the following tables to complete the critical thinking assignment.

Best Buy Co., Inc.

Income Statement

2/3/2018 1/28/2017 1/30/2016 1/31/2015
Revenue
Total Revenue 42,151,000 39,403,000 39,528,000 40,339,000
Cost of Revenue 32,275,000 29,963,000 30,334,000 31,292,000
Gross Profit 9,876,000 9,440,000 9,194,000 9,047,000
Operating Expenses
Selling General and Administrative 7,911,000 7,493,000 7,612,000 7,550,000
Operating Income or Loss 1,965,000 1,947,000 1,582,000 1,497,000
Income from Continuing Operations
Add Total Other Income/Expenses Net -148,000 -131,000 -272,000 -110,000
Interest Expense 75,000 72,000 80,000 90,000
Income Before Tax 1,742,000 1,744,000 1,230,000 1,297,000
Income Tax Expense 818,000 609,000 503,000 141,000
Add Discontinued Operations 1,000 21,000 90,000 -13,000
Net Income 925,000 1,156,000 817,000 1,143,000

Best Buy Co., Inc.

Balance Sheet

2/3/2018 1/28/2017 1/30/2016 1/31/2015
Current Assets
Cash And Cash Equivalents 1,101,000 2,240,000 1,976,000 2,432,000
Short Term Investments 2,196,000 1,848,000 1,384,000 1,539,000
Net Receivables 1,049,000 1,347,000 1,162,000 1,280,000
Inventory 5,209,000 4,864,000 5,051,000 5,174,000
Other Current Assets 274,000 217,000 313,000 1,047,000
Total Current Assets 9,829,000 10,516,000 9,886,000 11,472,000
Long Term Investments 0 13,000 27,000 3,000
Property Plant and Equipment 2,421,000 2,293,000 2,346,000 2,295,000
Goodwill 425,000 425,000 425,000 425,000
Intangible Assets 18,000 18,000 18,000 57,000
Other Assets 356,000 591,000 817,000 993,000
Deferred Long Term Asset Charges 159,000 317,000 510,000 574,000
Total Assets 13,049,000 13,856,000 13,519,000 15,245,000
Current Liabilities
Accounts Payable 4,873,000 4,984,000 4,450,000 5,030,000
Short/Current Long Term Debt 499,000 0 350,000 0
Other Current Liabilities 1,043,000 944,000 975,000 1,609,000
Total Current Liabilities 7,817,000 7,122,000 6,925,000 7,777,000
Long Term Debt 648,000 1,158,000 1,168,000 1,492,000
Other Liabilities 805,000 704,000 877,000 901,000
Total Liabilities 9,437,000 9,147,000 9,141,000 10,250,000
Stockholders' Equity
Total Stockholder Equity 3,612,000 4,709,000 4,378,000 4,995,000

Using the attached financial statements for Best Buy Co., Inc. complete the financial statement analysis and ratio analysis by answering the questions below. a. Calculate average collection period, total asset turnover, inventory turnover, and days in inventory. b. Assess the activity of the firm, using your calculations in part a, over the four year period. c. Calculate the gross profit margin, operating margin, and net profit margin. d. Assess the profitability of the firm, using your calculations in part c, over the four year period.

Solutions

Expert Solution

a]

average collection period = (365 * net receivables) / revenue

2018 = (365 * 1,049,000) / 42,151,000 = 9.08 days

2017 = (365 * 1,347,000) / 39,403,000 = 12.48 days

2016 = (365 * 1,162,000) / 39,528,000 = 10.73 days

2015 = (365 * 1,280,000) / 40,339,000 = 11.58 days

total asset turnover = revenue / total assets

2018 = 42,151,000 / 13,049,000 = 3.23

2017 = 39,403,000 / 13,856,000 = 2.84

2016 = 39,528,000 / 13,519,000 = 2.92

2015 = 40,339,000 / 15,245,000 = 2.65

inventory turnover = COGS / inventory

2018 = 32,275,000 / 5,209,000 = 6.20 times

2017 = 29,963,000 / 4,864,000 = 6.16 times

2016 = 30,334,000 / 5,051,000 = 6.01 times

2015 = 31,292,000 / 5,174,000 = 6.05 times

days in inventory = 365 / inventory turnover

2018 = 365 / 6.20 = 59 days

2017 = 365 / 6.16 times = 59 days

2016 = 365 / 6.01 times = 61 days

2015 = 365 / 6.05 = 60 days

b]

The average collection period has decreased, the total asset turnover has increased, days in inventory has decreased and the inventory turnover has increased over the past years. These are all indicative of more activity.

c]

gross profit margin = gross profit / revenue

2018 = 9,876,000 / 42,151,000 = 23.43%

2017 = 9,440,000 / 39,403,000 = 23.96%

2016 = 9,194,000 / 39,528,000 = 23.26%

2015 = 9,047,000 / 40,339,000 = 22.43%

net profit margin = net income / revenue

2018 = 925,000 / 42,151,000 = 2.19%

2017 = 1,156,000 / 39,403,000 = 2.93%

2016 = 817,000 / 39,528,000 = 2.07%

2015 = 1,143,000 / 40,339,000 = 2.83%

d]

The gross profit margin has been increasing over the past years

However, the net profit margin has been decreasing over the past years


Related Solutions

Best Buy Co, Inc., is a leading retailer specializing in consumer electronics. A condensed income statement...
Best Buy Co, Inc., is a leading retailer specializing in consumer electronics. A condensed income statement and balance sheet for the fiscal year ended January 28, 2017, are shown below. Best Buy Co, Inc. Balance Sheet At January 28, 2017 ($ in millions) Assets Current assets: Cash and cash equivalents $ 2,240 Short-term investments 1,681 Accounts receivable (net) 1,347 Inventory 4,864 Other current assets 384 Total current assets 10,516 Long-term assets 3,340 Total assets $ 13,856 Liabilities and Shareholders’ Equity...
Best Buy Co Inc. reported the following financial information in a recent financial statement ($ millions)....
Best Buy Co Inc. reported the following financial information in a recent financial statement ($ millions). Based on the information below, compute the additional working capital financing period. Sales …………………………………$50,272 Cost of sales …………………………………37,611 Inventory …………………………………5,897 Accounts receivable …………………………………2,348 Accounts payable …………………………………4,894 La Verne Company reports the sales and collection information below. Assume La Verne Company collects 20 percent of its sales in the month of the sale, 50 percent the next month, 25 percent the following month, and 5...
Analysis and Interpretation of Profitability Balance sheets and income statements for Best Buy Co., Inc. follow....
Analysis and Interpretation of Profitability Balance sheets and income statements for Best Buy Co., Inc. follow. Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) February 27, 2010 February 28, 2009 March 1, 2008 Revenue $ 49,694 $ 45,015 $ 40,023 Cost of goods sold 37,534 34,017 30,477 Restructuring charges - cost of goods sold -- -- -- Gross Profit 12,160 10,998 9,546 Selling, general and administrative expenses 9,873 8,984 7,385 Restructuring charges 52 78 -- Goodwill and tradename...
Analysis and Interpretation of Profitability Balance sheets and income statements for Best Buy Co., Inc. follow....
Analysis and Interpretation of Profitability Balance sheets and income statements for Best Buy Co., Inc. follow. Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) February 26, 2011 February 27, 2010 February 28, 2009 Revenue $ 50,272 $ 49,694 $ 45,015 Cost of goods sold 37,611 37,534 34,017 Restructuring charges - cost of goods sold 24 -- -- Gross Profit 12,637 12,160 10,998 Selling, general and administrative expenses 10,325 9,873 8,984 Restructuring charges 198 52 78 Goodwill and tradename...
Analysis and Interpretation of Profitability Balance sheets and income statements for Best Buy Co., Inc. follow....
Analysis and Interpretation of Profitability Balance sheets and income statements for Best Buy Co., Inc. follow. Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) February 26, 2011 February 27, 2010 February 28, 2009 Revenue $ 50,272 $ 49,694 $ 45,015 Cost of goods sold 37,611 37,534 34,017 Restructuring charges - cost of goods sold 24 -- -- Gross Profit 12,637 12,160 10,998 Selling, general and administrative expenses 10,325 9,873 8,984 Restructuring charges 198 52 78 Goodwill and tradename...
Analysis and Interpretation of Profitability Balance sheets and income statements for Best Buy Co., Inc. follow....
Analysis and Interpretation of Profitability Balance sheets and income statements for Best Buy Co., Inc. follow. Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) February 26, 2011 February 27, 2010 February 28, 2009 Revenue $ 50,272 $ 49,694 $ 45,015 Cost of goods sold 37,611 37,534 34,017 Restructuring charges - cost of goods sold 24 -- -- Gross Profit 12,637 12,160 10,998 Selling, general and administrative expenses 10,325 9,873 8,984 Restructuring charges 198 52 78 Goodwill and tradename...
Answers go in the yellow boxes Use the following information to complete the income statement for...
Answers go in the yellow boxes Use the following information to complete the income statement for company A for the year ending December 31, 201X Revenue $      120,000,000 Gross margin 50.0% Selling General and Administrative (SG&A) 20.0% of revenue Research and Development (R&D) 15.00% of revenue Depreciation expense (D&A) $           5,000,000 Interest Expense $           5,000,000 Interest Income $           2,000,000 Tax Rate 35% Securities Information Weighted Average Shares (12/31/1X) $            10,000,000 A Warrants exercisable @ $2.00 $              2,200,000 B Warrants Exercisable...
The 2018 annual report of Best Buy Co., Inc., reported profitable operations for the
The 2018 annual report of Best Buy Co., Inc., reported profitable operations for the most recent six years. However, the company suffered a net loss in 2012. Best Buy reported the following for the twelve months ended March 3, 2012:  The calculation of diluted earnings per share assumes the conversion of the company’s previously outstanding convertible debentures due in 2027 into 8.8 million shares common stock . . . and adds back the related aftertax interest expense of $1.5. ....
Assignment Directions Answer the following critical thinking questions in this forum. Feel free to copy the...
Assignment Directions Answer the following critical thinking questions in this forum. Feel free to copy the questions and paste into your reply so that you cover each one. Use complete sentences and proper statistical terminology in all posts. Read the instructors response to the questions. Read the answers of some of your peers. Reply to your own post with any corrections you may have for your initial responses. Questions: When is it best to use the mode as a measure...
Use this Fact Set for Questions 2-7: Three retailing giants, Best Buy Co., Inc. (NYSE: BBY),...
Use this Fact Set for Questions 2-7: Three retailing giants, Best Buy Co., Inc. (NYSE: BBY), Amazon.com, Inc., (NASDAQ: AMZN), and Target Corporation (NYSE: TGT) each use a different inventory costing method. Best Buy uses weighted-average cost, Amazon uses FIFO, and Target uses LIFO. As you will see from the hypothetical example below, the use of a different inventory costing method will lead to differences in income statements and balance sheets. Best Buy, Amazon and Target sell a popular T-shirt...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT