Question

In: Accounting

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 


20172016
Net sales   $598,000$500,000
Cost of goods sold  477,000420,000
Gross Profit  121,00080,000
Operating expenses  80,00044,000
Net 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 data for Delaney Corporation for both years. (Round percentages to 1 decimal place, e.g. 12.1%.) 

Solutions

Expert Solution

DELANEY CORPORATION
Condensed Income Statement
Horizontal analysis
Increase (Decrease) in current (versus Period)
2017 2016 Amount Percentage*
Net sales $        598,000 $        500,000 $            98,000 19.6%
Cost of goods sold $        477,000 $        420,000 $            57,000 13.6%
   Gross profit $        121,000 $           80,000 $            41,000 51.3%
Operating expense $           80,000 $           44,000 $            36,000 81.8%
Net Income $           41,000 $           36,000 $              5,000 13.9%

*Change in amount/ Base year amount..................Base year is 2016

.

DELANEY CORPORATION
Condenced Income Statement
Vertical analysis
                                              2,017                                       2,016
Amount Percent Amount Percent
Net sales $        598,000 100.0% $         500,000 100.0%
Cost of goods sold $        477,000 79.8% $         420,000 84.0%
   Gross profit $        121,000 20.2% $            80,000 16.0%
Operating expense $           80,000 13.4% $            44,000 8.8%
Net Income $           41,000 6.9% $            36,000 7.2%

All percentage as a percentage of sales for respective year


Related Solutions

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. 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%)
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...
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 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 following comparative income statement for the Buff Bodies Corporation. Round...
Prepare a horizontal analysis of the following comparative income statement for the Buff Bodies Corporation. Round percentage changes to the nearest one-tenth percent. Buff Bodies Corporation Comparative Income Statement For the Years Ended December 31, 2019 and 2018    2019                              2018 Total revenue                       $1,450,000                        $1,300,000 Expenses: Cost of goods sold       $   1,023,000                        $   930,000 Operating expenses             310,000                             275,000 Interest expense                    48,300                               38,000 Income tax expense            12,000                               10,000 Total expenses                      $1,393,300                        $1,253,000 Net income                          $    ...
Prepare a horizontal analysis on the income statement and Balance statement. (Please show the formula &...
Prepare a horizontal analysis on the income statement and Balance statement. (Please show the formula & your calculations balance Sheet December 31, 20X7 & 20X6 Assets 20X7 20X6 Cash $ 15,000   17,000 Marketable securities 10,000 10,000 Accounts receivable (net) 20,000 22,000 Inventory 30,000 27,000 Prepaid expenses 8,000 9,000 Property, plant, and equipment 117,000 117,000 Total assets $200,000 202,000 Liabilities and Stockholders' Equity Current liabilities $ 30,000 27,000 Long-term liabilities 61,000 56,000 Stockholders' equity 109,000 119,000 Total liabilities and stockholders' equity...
1. Using Walt Disney Inc. Annual Report income statement, prepare a horizontal and vertical analysis on...
1. Using Walt Disney Inc. Annual Report income statement, prepare a horizontal and vertical analysis on years 2017 and 2016. 2. Perform the following ratios, Current, Debt, Return on Equity on years 2017 and 2016 https://www.thewaltdisneycompany.com/wp-content/uploads/2017-Annual-Report.pdf Return on common stockholders’ equity ratio. Return on asset ratio. Profit margin rate. Earnings per share. Debt to total asset ratio. Current ratio Average collection period. Receivables turnover ratio. Asset turnover ratio.
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT