Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Just need the percents wasn't able to understand Horizontal Analysis of Comparative Financial Statements A comparative income statement and balance sheet of Miller Electronics Corporation
Just need the percents wasn't able to understand
Horizontal Analysis of Comparative Financial Statements A comparative income statement and balance sheet of Miller Electronics Corporation for the last two years are shown. 20-1 $420,600 258,668 $161,932 Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2 Net Sales (all on account) $650,220 Cost of goods sold 395,410 Gross profit $254,810 Administrative expenses $63,518 Selling expenses 65,992 Total operating expenses $129,510 Operating income $125,300 Interest expense 1,282 Income before income taxes $124,018 Income tax expense 31,005 Net income $93,013 $42,288 43,936 $86,224 $75,708 1,204 $74,504 13,630 $60,874 Miller Electronics Corporation Comparative Balance Sheet December 31, 20-2 and 20-1 20-2 20-1 Assets Current assets: Cash $42,900 Receivables (net) $22,006 47,510 50,396 1,158 73,642 92,060 3,788 $212,390 Merchandise inventory Supplies and prepayments Total current assets $121,070 Property, plant, and equipment: Office equipment (net) Factory equipment (net) $8,490 71,190 $12,150 105,360 $117,510 $329,900 Total property, plant, and equipment $79,680 $200,750 Total assets Liabilities Current liabilities Notes payable Accounts payable Accrued and withheld payroll taxes Total current liabilities $10,000 43,524 6,250 $59,774 $6,000 30,242 5,400 $41,642 Stockholders' Equity $84,000 Common stock ($10 par) Retained earnings $100,000 170,126 75,108 Total stockholders' equity $270,126 $329,900 $159,108 $200,750 Total liabilities and stockholders' equity Required: Prepare a horizontal analysis. Enter the amount of increase (decrease) and the percentage change. Round percentages to one decimal place. Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2 20-1 Increase Amount Amount (Decrease) Net sales (all on account) $650,220 $420,600 $ 229,620 Cost of goods sold 395,410 258,668 136,742 Percent Gross profit $254,810 $161,932 $ $63,518 $42,288 $ 65,992 43,936 92,878 21,230 Administrative expenses Selling expenses 22,056 Total operating expenses $129,510 $ 86,224 $ 43,286 Operating income $125,300 1,282 $75,708 $ 1,204 49,592 78 Interest expense Income before income taxes $124,018 Income tax expense 31,005 $74,504 $ 13,630 49,514 17,375 Net income $93,013 $60,874 $ 32,139 Miller Electronics Corporation Comparative Balance Sheet December 31, 20-2 and 20-1 Assets 20-2 20-1 Amount Amount Increase (Decrease) Percent Current assets: Cash $42,900 Receivables (net) 73,642 55 $22,006 $ 47,5101 50,396 1,158 20,894 26,132 41,664 2,630 Merchandise inventory 92,060 3,788 Supplies and prepayments $212,390 $121,070 $ 91,320 Total current assets Property, plant, and equipment: Office equipment (net) $12,150 $8,490 $ 3,660 Factory equipment (net) 105,360 71,190 34,170 Total prop., plant, and equip. $117,510 $79,680 $ 37,830 Total assets $329,900 $200,750 $ 129,150 Liabilities Current liabilities: Notes payable 4,000 $10,000 43,524 $6,000 $ 30,242 Accounts payable 13,282 Accrued and withheld payroll taxes 6,250 5,400 850 Total current liabilities $59,774 $41,642 $ 18,132 Stockholders' Equity. $100,000 $84,000 $ Common stock ($10 par) 16,000 Retained earnings 170,126 75,108 95,018 Total stockholders' equity $270,126 $159,108 111,018 | Total liab. and stockholders' equity $329,900 $200,750 129,150 Feedback Check My Work Calculate the increase or decrease from one year to the next. Percent = Increase(Decrease) column/earlier year columnStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started