Question

In: Accounting

Problem H Use this balance sheet to do horizontal analysis of the MJH Company. 2019 2018...

Problem H

Use this balance sheet to do horizontal analysis of the MJH Company.
2019 2018 amount percent
Assets
Current Assets $6,500 $5,000
Plant Assets $22,000 $25,000
Total Assets $28,500 $30,000
======= =======
Liaiblities $5,500 $10,000
Stockholders’ Equity $23,000 $20,000
Total Liabilities and Equity $28,500 $30,000
======== =======
Use the information below to do a vertical analysis
2018
Net sales $200,000
Cost of goods sold 116,000
Gross Margin 84,000
Operating Expenses 46,000
Income before Taxes 38000
Income taxes 15200
Net Income $22,800
========

Solutions

Expert Solution

1)Horizontal Analysis

2019(A) 2018(B) Amount(A-B=C) Percent(C/B)
Assets:
Current Assets $6,500 $5,000 $1,500 30%
Plant Assets $22,000 $25,000 ($3,000) (12%)
Total Assets $28,500 $30,000 ($1,500) (5%)
Liabilities Liabilities $5,500 $10,000 ($4,500) (45%)
Equity Shareholder's equity $23,000 $20,000 $3,000 15%
Total $28,800 $30,000 ($1,500) (5%)

2)Vertical Analysis

To conduct a vertical analysis of income statement, sales figure is generally used as the base and all other components of income statement like cost of sales, gross profit, operating expenses, etc. are shown as a percentage of sales.
This Assumption Is Used Taking sales as base vertial Analysis is done

Formula Used is:percentage of base=(Amount of individual item/Amount of base) *100

2018 Percent
Net Sales $200,000 100%
Cost of Goods Sold $116,000 58%
Gross Margin $84,000 42%
Operating Expenses $46,000 23%
Income Before Taxes $38,000 19%
Income Taxes $15,200 7.6%
Net Income $22,800 11.40%

Related Solutions

Use this balance sheet to do horizontal analysis of the Howard Company. 2019 2018 amount percent...
Use this balance sheet to do horizontal analysis of the Howard Company. 2019 2018 amount percent Assets Current Assets $13,000 $10,000 Plant Assets $44,000 $50,000 Total Assets $57,000 $60,000 Liabilities $11,000 $20,000 Stockholders' Equity $46,000 $40,000 Total Liabilities and Equity $57,000 $60,000 Financially, do you think this company is stronger in 2018 or 2019? 2018 because there are more assets 2018 because there are fewer liabilities and more current assets to pay the bills. 2018 because the total liabilities and...
Balance Sheet Horizontal and Vertical Analysis 2018 2019 Horizontal Vertical Cash 28,421 1,274 -95.52% 0.13% AR...
Balance Sheet Horizontal and Vertical Analysis 2018 2019 Horizontal Vertical Cash 28,421 1,274 -95.52% 0.13% AR 225,019 333,558 48.24% 34.00% Inventory 319,887 321,006 0.35% 32.72% Prepaid Insurance 3,500 3,750 7.14% 0.38% Total Current Assets 576,827 659,588 14.35% 67.23% Equipment 385,000 385,000 0.00% 39.24% Less: Acc. Dep. 21,150 63,450 200.00% 6.47% Net Fixed Assets 363,850 321,550 -11.63% 32.77% Total Assets 940,677 981,138 4.30% 100.00% Accts Payable 331,822 401,693 21.06% 40.94% W&P Taxes Payable 25,889 26,145 0.99% 2.66% ST Portion MP 21,014...
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 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...
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...
Data Table Outdoor Adventure Company Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets...
Data Table Outdoor Adventure Company Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash $1,398,330 $14,790 Short-term Investments, net 29,000 0 Accounts Receivable, net 1,600 6,300 Merchandise Inventory 400 0 Office Supplies 70 300 Prepaid Rent 0 2,000 Property, Plant, and Equipment: Land 615,000 75,000 Building 944,000 94,000 Canoes 13,920 13,920 Office Furniture and Equipment 140,000 0 Accumulated Depreciation—PP&E (31,920) (1,740) Total Assets $3,110,400 $204,570 Liabilities Current Liabilities: Accounts Payable $6,420 $4,400 Utilities Payable 550...
3.  Problem 3-11 (Balance Sheet Analysis) Balance Sheet Analysis Complete the balance sheet and sales information in...
3.  Problem 3-11 (Balance Sheet Analysis) Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.7 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 30% Total liabilities-to-assets ratio: 40% Quick ratio: 0.90 Days' sales outstanding (based on 365-day year): 36.5 days Inventory turnover ratio: 3.25 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial...
BETHESDA MINING COMPANY Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019...
BETHESDA MINING COMPANY Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019 Assets Liabilities and Owners’ Equity   Current assets   Current liabilities     Cash $ 42,646 $ 54,402      Accounts payable $ 191,422 $ 199,111     Accounts receivable 60,781 81,139      Notes payable 86,520 138,088     Inventory 127,265 193,375             Total $ 277,942 $ 337,199       Total $ 230,692 $ 328,916   Long-term debt $ 240,000 $ 176,750   Owners’ equity      Common stock and paid-in surplus $ 215,000 $ 215,000      Accumulated retained earnings 155,597 189,495...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT