Assume this is a partial list of financial highlights from a Best Buy annual report: 2023 2022 (dollars in millions) Net sales $ 48,080 Earnings before taxes 2,441 Net earnings 1,528 $ 41,475 1,388 996 Complete a horizontal and vertical analysis from the above information. Note: Enter your answers in millions. Round the "percent" answers to the nearest hundredth percent. Net sales Earnings before taxes Net earnings Horizontal analysis Vertical analysis 2023 2022 Increase Percent 2023 2022 % % % % % %

Assume this is a partial list of financial highlights from a Best Buy annual report: 2023 2022 (dollars in millions) Net sales $ 48,080 Earnings before taxes 2,441 Net earnings 1,528 $ 41,475 1,388 996 Complete a horizontal and vertical analysis from the above information. Note: Enter your answers in millions. Round the "percent" answers to the nearest hundredth percent. Net sales Earnings before taxes Net earnings Horizontal analysis Vertical analysis 2023 2022 Increase Percent 2023 2022 % % % % % %

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 51E: Juroe Company provided the following income statement for last year: Juroes balance sheet as of...

See similar textbooks

Similar questions

Assume this is a partial list of financial highlights from a Best Buy annual report: 2019 2020 (dollars in millions). $ 37,580 $ 33,075 1,283 891 2,231 1,318. Net sales Earnings before taxes Net earnings Complete a horizontal and vertical analysis from the above information. (Enter your answers in millions. Round the "percent" answers to the nearest hundredth percent.) Net sales Earnings before taxes Net earnings 2020 Horizontal analysis 2019 Increase Percent Vertical analysis 2020 % % % 2019 + % % %
For this question, calculate all values to 2 decimal places of £M (e.g. £123.45M) unless otherwise specified, and all ratios to 2 decimal places of percentage (e.g. 9.87%). You are given the following income statements and balance sheets for Freddie M Corporation for fiscal years 2045 and 2046 (all figures are in £ million), Income Statement Balance Sheet Sales Cost of goods sold Gross margin Wage & salaries expense Depreciation expense Earnings before interest and tax Interest expenses Taxes Net income Dividends Change in shareholder's equity Assets: Cash & equivalents Receivables Inventories Current Assets Property, plant & equipment Accumulated depreciation Net property, plant & equip Total Assets 2045 400.00 -200.00 200.00 -50.00 -25.00 125.00 -25.00 -60.00 40.00 -16.00 24.00 2045 2046 480.00 -240.00 240.00 -60.00 -25.00 155.00 -20.00 -70.00 65.00 -26.00 39.00 2046 Liabilities: 30.00 36.00 Payables 60.00 Short-term debt 50.00 50.00 60.00 Long-term debt 130.00 156.00 Total…
Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies to the questions displayed below] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 Sales Cost of goods sold $ 402,346 $ 308,230 242,212 $ 213,900 194,493 136,896 Gross profit 160,134 113,737 77,004 Selling expenses 57,133 42,536 28,235 Administrative expenses 36,211 27,124 17,754 Total expenses 93,344 69,660 45,989 Income before taxes Income tax expense 66,790 44,077 31,015 12,423 9,036 6,296 Net income $ 54,367 $ 35,041 $ 24,719 KORBIN COMPANY Comparative Balance Sheets December 31 Assets Current assets Long-term investments Plant assets, net Total assets Current liabilities Liabilities and Equity Common stock Other paid-in capital Retained earnings Total liabilities and equity $ 180,932 2021 $ 63,959 116,973 0 2020 $ 42,808 800 106,691 $ 180,932 $ 150,299 $…
Please help me
Use the following selected 2019 balance sheet and income statement information for Homer Glen Supply Co. (in millions) to compute the gross profit percentage to the nearest hundredth of a percent. Net income $104,940 Select one: C O O O A. 44.26% B. 4.42% C. 8.56% D. 28.76% Gross profit on sales $1,050,600 Average total assets $631,050 Sales $2,373,882 Tax rate on operating profit 35%
2. Complete the below table to calculate income statement data in common-size percents. (Round your percentage answers to 2 decimal places.) KORBIN COMPANY Common-Size Comparative Income Statements For Years Ended December 31, 2019, 2018, and 2017 2019 2018 2017 Sales % % % Cost of goods sold -1 -1 -1 Gross profit Selling expenses -1 -1 -1 Administrative expenses -1 -1 -1 Total expenses Income before taxes -1 -1 -1 Income tax expense -1 -1 -1 Net income % % % See picture
prepare a horizontal analysis of revenues and grossin dollar amounts and in 2019 and 2018. (Enter amounts in millions as provided to you in the problem statement. Round the percentages to one decimal place, X.X%. Use a minus sign or parentheses to indicate a decrease.) (In millions) 2019 2018 2017 Revenue $9,575 $9,300 $8,975 cost of goods sold $6,250 $6,000 $5,890 Increase (decrease) 2019 2018 Amount Percentage Amount Percentage Revenue Gross Profit
Calculate the Sales Growth of the most recent year. Enter answer as decimal (not percent. Example: .1234 is ok, 12.34% is not ok).
help me
A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $3 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows: Industry Average Ratios Current ratio Debt-to-capital ratio Times interest earned EBITDA coverage Inventory turnover Cash and equivalents Accounts receivables Inventories Total current assets 2x 17% 3 x 6 x 11 x Days sales outstandinga Calculation is based on a 365-day year. Balance Sheet as of December 31, 2021 (millions of dollars) $78 Accounts payable Other current liabilities 51 125 Notes payable $ 254 Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity Gross fixed assets Less depreciation Net fixed assets Total assets 15 days Fixed assets turnover Total assets turnover…
Following are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. Reported Forecast Horizon Period $ millions 2018 2019 2020 2021 2022 Sales $14,030 $14,871 $15,763 $16,710 $17,712 NOPAT NOA Terminal Period $18,066 2,711 2,880 3,053 3,236 3,430 8,989 9,527 10,099 10,705 11,347 3,499 11,574 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) 2% 7.35% Common shares outstanding 328.1 million Net nonoperating obligations (NNO) $5,894 million (a) Estimate the value of a share of ITW's common stock using the residual operating income model (ROPI) model as of December 31, 2018. Forecast Horizon ($ millions) Reported 2018 Terminal 2019 2020 2021 2022 Period ROPI…
Suppose McDonald's 2022 financial statements contain the following selected data (in millions). Current assets Total assets Current liabilities Total liabilities (a1) a. b. Compute the following values. C. $3,416.0 Interest expense 30,224.0 d. 2,988.0 16,191.0 Income taxes Net income $473.0 1,936.0 4,551.0 Current ratio. (Round to 2 decimal places, e.g. 6.25:1.) Working capital. (Round to 1 decimal place, e.g. 5,275.5) Debt to assets ratio. (Round to 0 decimal places, e.g. 62%.) Times interest earned. (Round to 2 decimal places, e.g. 6.25.) millions :1 % times