Question

In: Accounting

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 income statement.
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

Solutions

Expert Solution

Ans. 1 Nelman Corp.
Comparative Balance Sheet
For the Years Ended December 31
2019 2018 Amount change Percentage change
Assets
Current assets $360 $300 $60 20.0%
Plant assets $640 $500 $140 28.0%
Total assets $1,000 $800 $200 25.0%
Liabilities and Stockholder's Equity
Current liabilities $150 $120 $30 25.0%
Long term debt $240 $160 $80 50.0%
Common stock $350 $320 $30 9.4%
Retained eanings $260 $200 $60 30.0%
Total Liabilities and stockholder's equity $1,000 $800 $200 25.0%
Change in amount = Particular amount of current year 2019 - Particular amount of previous year 2018
Change in percentage = Change in amount / particular amount of base (2018) or previous year * 100
Ans. 2 Nelman Corp.
Comparative Balance Sheet
For the Years Ended December 31
2019 % 2018 %
Assets
Current assets $360 36.00% $300 37.50%
Plant assets $640 64.00% $500 62.50%
Total assets $1,000 100.00% $800 100.00%
Liabilities and Stockholder's Equity
Current liabilities $150 15.00% $120 15.00%
Long term debt $240 24.00% $160 20.00%
Common stock $350 35.00% $320 40.00%
Retained eanings $260 26.00% $200 25.00%
Total Liabilities and stockholder's equity $1,000 100.00% $800 100.00%
*Calculations for Vertical Balance Sheet:
Amount is percentage from assets side =   Particular amount from assets side / Total assets * 100
Amount is percentage from liabilities side =   Particular amount from liability side / Total liabilities and owner's equity * 100

Related Solutions

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 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).) THORNTON COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $16,700 $12,200 % Marketable securities 21,300 7,500 Accounts receivable (net) 54,100 46,500 Inventories 136,100 144,600 Prepaid items 26,300 10,400 Total current assets...
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 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 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...
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...
Prepare an income statement for 2018.
The following account balances were taken from the 2018 adjusted trial balance of the Bowler Corporation:sales revenue, $325,000cost of goods sold, $168,000salaries expense, $45,000 rent expense, $20,000depreciation expense, $30,000and miscellaneous expense, $12,000Prepare an income statement for 2018.
Q: Please review the Income Statement and Balance Sheet Prepare the following analysis: 1)   Calculate Horizontal...
Q: Please review the Income Statement and Balance Sheet Prepare the following analysis: 1)   Calculate Horizontal (Trend) Analysis of the Income Statement and Balance Sheet 2) Calculate Vertical (Common Size) Analysis of the Income Statement and Balance Sheet 3) Calculate the Liquidity Ratios only for COSTCO for the most recent (newest) year with a brief explanation of what each reveals to management COSTCO WHOLESALE CORPORATION CONSOLIDATED BALANCE SHEET (amounts in millions) ASSETS CURRENT ASSETS August 31, 2016 August 31, 2015...
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                          $    ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT