Question

In: Accounting

Prepare a horizontal analysis of the balance sheet data for Nike, using 2016 as a base.

Exercise 9-5 


Suppose the comparative balance sheets of Nike, Inc. are presented here. 

image.png

Prepare a horizontal analysis of the balance sheet data for Nike, using 2016 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.2%)

image.png


Solutions

Expert Solution


Related Solutions

Prepare a horizontal analysis of the balance sheet data for Nike, using 2019 as a base....
Prepare a horizontal analysis of the balance sheet data for Nike, using 2019 as a base. (Show the amount of increase or decrease as well.) b. Prepare a vertical analysis of the balance sheet data for Nike for 2020. Prepare horizontal and vertical analyses. E13.6 (LO 2) Here are the comparative income statements of Delaney Corporation. Delaney Corporation Comparative Income Statements For the Years Ended December 31      2020      2019 Net sales      $598,000      $500,000 Cost of goods...
Prepare a horizontal analysis of the income statement data for Delaney Corporation, using 2016 as a base.
*Exercise 9-6 Here are the comparative income statements of Delaney Corporation, DELANEY CORPORATION Comparative Income Statements For the Years Ended December 31 20172016Net sales   $598,000$500,000Cost of goods sold  477,000420,000Gross Profit  121,00080,000Operating expenses  80,00044,000Net income  $ 41,000$36,000   Prepare a horizontal analysis of the income statement data for Delaney Corporation, using 2016 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55, 000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.1%.) Prepare a vertical analysis of the income statement...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) ADAMS COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $16,700 $12,100 % Marketable securities 20,200 7,400 Accounts receivable (net) 54,900 47,600 Inventories 135,200 144,500 Prepaid items 25,000 10,500 Total current assets...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) BAIRD COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $17,600 $12,200 % Marketable securities 21,000 6,200 Accounts receivable (net) 54,700 46,800 Inventories 136,500 143,300 Prepaid items 26,500 11,800 Total current assets...
Prepare a horizontal analysis of the segment data using the prior year as the base year....
Prepare a horizontal analysis of the segment data using the prior year as the base year. Round all percents to one decimal place. Enter all amounts in millions. If required, use minus sign to indicate the decreasing values. Starbucks Corporation Horizontal Analysis Recent Year (in millions) Prior Year (in millions) Increase (Decrease) Amount Increase (Decrease) Percent Americas $8,887 $7,648 $ % China/Asia Pacific 2,396 1,130 Channel Development 1,731 1,546 EMEA 1,217 1,295 Other 1,924 1,606 Total revenues $16,155 $13,225 $...
Prepare a horizontal analysis of both the balance sheet and income statement.  Analysis Bal Sheet...
Prepare a horizontal analysis of both the balance sheet and income statement.  Analysis Bal Sheet Analysis Inc Stmt  Complete this question by entering your answers in the tabs below. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) Analysis Bal Sheet Analysis Inc Stmt $ $ $ $ $ $ $ $ STUART COMPANY Horizontal Analysis...
Perform a horizontal, common-size analysis of the balance sheet items, using 2017 as the base year...
Perform a horizontal, common-size analysis of the balance sheet items, using 2017 as the base year (meaning each line item for 2017 is 100%). Also include a horizontal analysis of sales and net income. Balance Sheet April 30 (in thousands of dollars) 2019 2018 2017 Assets:    Current assets $ 1,700 $1,120 $1,544    Plant and equipment (net) 8,110 7,830 5,404    Other assets   1,004    695    772    Total assets $10,814 $9,645 $7,720 Liabilities and Stockholders' Equity:    Current liabilities $   950 $  880 $  772    Long-term liabilities...
Prepare a balance sheet in report form as of December 31, 2016. * Balance sheet data:...
Prepare a balance sheet in report form as of December 31, 2016. * Balance sheet data: Accounts payable $ 194,300 Accounts receivable 545,000 Accumulated depreciation—office buildings and equipment 1,580,000 Accumulated depreciation—store buildings and equipment 4,126,000 Allowance for doubtful accounts 8,450 Available-for-sale investments (at cost) 260,130 Bonds payable, 5%, due 2024 500,000 Cash 246,000 Common stock, $20 par (400,000 shares authorized; 100,000 shares issued, 94,600 outstanding) 2,000,000 Dividends: Cash dividends for common stock 155,120 Cash dividends for preferred stock 100,000 Goodwill...
1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a...
1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a base. Neiman Corp. Comparative Balance Sheet For the years ended December 31 2019 2018 Assets Current Assets 360 300 Plant Assets 640 500 Total Assets 1,000 800 Liabilities & Stockholders' Equity Current liabilities 150 120 Long-term debt 240 160 Common stock 350 320 Retained earnings 260 200 Total liabilities & stockholders' equity 1,000 800 2 VERTICAL ANALYSIS INSTRUCTIONS: Prepare a vertical analysis of the...
Make a Horizontal and Vertical analysis of SBUX balance sheet with four years of camparative data...
Make a Horizontal and Vertical analysis of SBUX balance sheet with four years of camparative data from Yahoo Finance If you can only answer one then please answer the Verical analysis Starbucks Corporation (SBUX) Balance Sheet For the year ended Sept 30 Breakdown TTM    9/30/2019 9/30/2018 9/30/2017 Total Revenue 24061900 26508600 24719500 22386800 Cost of Revenue 18647800 19020500 17367700 15531500 Gross Profit 5414100 7488100 7351800 6855300 Operating Expense 3534000 3572400 3545300 2958500 Operating Income 1880100 3915700 3806500 3896800 Net...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT