In: Accounting
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 | |
| 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 | ||||||