Prepare a vertical analysis of the income statement and balance sheet. Show each item on the income statement as a percentage of the net sales for each year. On the balance sheet, show each asset item as a percentage of the total assets and each liability and equity item as a percentage of the total liabilities and stockholders' equity. Round percentages to one decimal place.
Homework Answers
| Miler Electronics Corporation | ||||
| Comparative Income Statement | ||||
| For Years Ended December 31, 20-2 and 20-1 | ||||
| 20-2 | 20-2 | 20-1 | 20-1 | |
| Amount | Percent | Amount | Percent | |
| Net sales (all on account) | $664820 | 100% | $425220 | 100% |
| Cost of goods sold | 394620 | (394620*100/664820)= 59.4% | 259980 | (259980*100/425220)= 61.1% |
| Gross profit | $270200 | (270200*100/664820)= 40.6% | $165240 | (165240*100/425220)= 38.9% |
| Administrative expenses | $65200 | (65200*100/664820)= 9.8% | $43371 | (43371*100/425220)= 10.2% |
| Selling expenses | 66375 | (66375*100/664820)= 10% | 44269 | (44269*100/425220)= 10.4% |
| Total operating expenses | $131575 | (131575*100/664820)= 19.8% | $87640 | (87640*100/425220)= 20.6% |
| Operating income | $138625 | (138625*100/664820)= 20.8% | $77600 | (77600*100/425220)= 18.2% |
| Interest expense | 1266 | (1266*100/664820)= 0.2% | 1178 | (1178*100/425220)= 0.3% |
| Income before income taxes | $137359 | (137359*100/664820)= 20.7% | $76422 | (76422*100/425220)= 17.9% |
| Income tax expense | 31488 | (31488*100/664820)= 4.7% | 13789 | (13789*100/425220)= 3.2% |
| Net income | $105871 | (105871*100/664820)= 15.9% | $62633 | (62633*100/425220)= 14.7% |
2)
| Miler Electronics Corporation | ||||
| Comparative Balance Sheet | ||||
| December 31, 20-2 and 20-1 | ||||
| 20-2 | 20-2 | 20-1 | 20-1 | |
| Amount | Percent | Amount | Percent | |
| Current assets: | ||||
| Cash | $43479 | (43479*100/329129)= 13.2% | $22996 | (22996*100/200894)= 11.4% |
| Receivables (net) | 73904 | (73904*100/329129)= 22.5% | 47460 | (47460*100/200894)= 23.6% |
| Merchandise inventory | 91429 | (91429*100/329129)= 27.8% | 50201 | (50201*100/200894)= 25% |
| Supplies and prepayments | 3767 | (3767*100/329129)= 1.1% | 1157 | (1157*100/200894)= 0.6% |
| Total current assets | $212579 | (212579*100/329129)= 64.6% | $121814 | (121814*100/200894)= 60.6% |
| Property, plant and equipment: | ||||
| Office equipment (net) | $12211 | (12211*100/329129)= 3.7% | $8640 | (8640*100/200894)= 4.3% |
| Factory equipment (net) | 104339 | (104339*100/329129)= 31.7% | 70440 | (70440*100/200894)= 35.1% |
| Total prop., plant and equip. | $116550 | (116550*100/329129)= 35.4% | $79080 | (79080*100/200894)= 39.4% |
| Total assets | $329129 | 100% | $200894 | 100% |
| Liabilities | ||||
| Current liabilities: | ||||
| Notes payable | $9930 | (9930*100/329129)= 3.0% | $5930 | (5930*100/200894)= 3% |
| Accounts payable | 43375 | (43375*100/329129)= 13.2% | 29999 | (29999*100/200894)= 14.9% |
| Accrued and withheld payroll taxes | 6288 | (6288*100/329129)= 1.9% | 5428 | (5428*100/200894)= 2.7% |
| Total current liabilities | $59593 | (59593*100/329129)= 18.1% | $41357 | (41357*100/200894)= 20.6% |
| Stockholders' Equity | ||||
| Common stock ($10 par) | $100000 | (100000*100/329129)= 30.4% | $84000 | (84000*100/200894)= 41.8% |
| Retained earnings | 169536 | (169536*100/329129)= 51.5% | 75537 | (75537*100/200894)= 37.6% |
| Total stockholders' equity | $269536 | (269536*100/329129)= 81.9% | $159537 | (159537*100/200894)= 79.4% |
| Total liab. and stockholders' equity | $329129 | 100% | $200894 | 100% |
Add Answer to:
Prepare a vertical analysis of the income statement and balance
sheet. Show each item on the...
Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2 20-1 Net S...
Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2 20-1 Net Sales (all on account) $428,000 $665,000 Cost of goods sold 399,800 261,150 Gross profit $265,200 $166,850 Administrative expenses $65,941 $42,631 Selling expenses 66,616 44,337 Total operating expenses $132,557 $86,968 Operating income $132,643 $79,882 Interest expense 1,255 1,177 Income before income taxes $131,388 $78,705 Income tax expense 30,865 13,151 Net income $100,523 $65,554 Miller Electronics Corporation Comparative Balance Sheet December 31, 20-2 and 20-1...
Problem 23.1A Horizontal and vertical analysis of income statement and balance sheet. LO 23-1, 23...
Problem 23.1A Horizontal and vertical analysis of income
statement and balance sheet. LO 23-1, 23-2
The EastTN Company sells computer parts through a retail store
that it operates. The firm’s comparative income statement and
balance sheet for the years 2016 and 2015 are shown below.
1-a.
Complete both a horizontal and a vertical analysis of
comparative income statement for the years 2016 and 2015.
(Round your percentage answers to 1 decimal place. i.e.,
0.123 should be entered as 12.3.)
1-b....
1. Prepare a vertical analysis for Ambrose for both its income statement and balance sheet. 2....
1. Prepare a vertical analysis for Ambrose for both its income statement and balance sheet. 2. Compare the company's profit performance and financial position with the average for the industry. Ambrose Department Stores, Inc. Income Statement Compared with Industry Average Year Ended December 31, 2018 Industry Ambrose Average Net Sales Revenue $780,000 100.0 % Cost of Goods Sold 524,940 65.8 Gross Profit 255,060 34.2 Operating Expenses 159,120 19.7 Operating Income 95,940 14.5 Other Expenses 7,020 0.4 Net Income $88,920 14.1...
A comparative balance sheet and income statement for Groton Company follow: Groton Company Comparative Balance Sheet...
A comparative balance sheet and income statement for Groton Company follow: Groton Company Comparative Balance Sheet December 31, 2011 and 2010 2011 2010 Assets Cash Accounts receivable Inventory Prepaid expenses $8 $ 19 344 255 184 235 32 34 Total current assets 570541 Property, plant, and equipment Less accumulated depreciation 535 (82) 68) 456 Net property, plant, and equipment 453 388 Long-term investments 40 46 Total assets $1,063 $ 975 Liabilities and Stockholders' equity Accounts payable Accrued liabilities Income taxes...
Shown below, is a Comparative Balance sheet using Horizontal analysis, please prepare an Income statement using...
Shown below, is a Comparative Balance sheet using Horizontal analysis, please prepare an Income statement using vertical Analysis Robust Robots, Inc. Comparative Balance Sheet- Horizontal Analysis December 31, 2019 and 2018 Assets 2019 2018 Differents Percentage Current Assets: Cash $65,000 $80,000 $ (15,000.00) -18.75% Accounts Receivable, net $150,000 $100,000 $ 50,000.00 50.00% Merchandise Inventory $135,000 $70,000 $ 65,000.00 92.86% Supplies $9,700 $500 $ 9,200.00 1840.00% Prepaid Insurance $30,000 $10,000 $ 20,000.00 200.00% Total Current Assets $389,700 $260,500 $ 129,200.00 49.60%...
Marbry Corporation's balance sheet and income statement appear below: Comparative Balance Sheet Ending Beginning Balance Balance...
Marbry Corporation's balance sheet and income statement appear below: Comparative Balance Sheet Ending Beginning Balance Balance $ 42 49 62 153 470 262 Assets: Current assets: Cash and cash equivalents Accounts receivable Inventory Total current assets Property, plant, and equipment Less accumulated depreciation Net property, plant, and equipment Total assets Liabilities and stockholders' equity: Current liabilities: Accounts payable Accrued liabilities Income taxes payable Total current liabilities Bonds payable $ 35 54 54 143 440 254 186 208 $361 $329 $...
You are to do a Vertical Analysis (on both the Balance Sheet and Income Statement) for EACH of th...
You are to do a Vertical Analysis (on both the Balance Sheet
and Income Statement) for EACH of the years presented. You must
show your result as a % (not a decimal number) and round your %
results to exactly 2 decimal places (ex: 2.07% ~ not 2% ~ not
2.0734566%).
For these analyses, you are to present the actual tables of
your Vertical Analysis. Each of these analyses MUST SHOW: statement
titles, the name of every single individual account...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company Comparative Balance Sheet (dollars in millions) Ending Beginning Balance Balance Assets Current assets: Cash and cash equivalents $ 52 $ 107 Accounts receivable 770 705 Inventory 715 662 Total current assets 1,537 1,474 Property, plant, and equipment 1,635 1,601 Less accumulated depreciation 848 690 Net property, plant, and 787 911 equipment Total assets $2,324 $2,385 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $...
Prepare a horizontal analysis of both the balance sheet and income statement. BENSON COMPANY Horizontal Analysis...
Prepare a horizontal analysis of both the balance sheet and income statement. BENSON COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $17,700 $13,300 not attempted % Marketable securities 20,600 6,800 not attempted Accounts receivable (net) 54,100 46,900 not attempted Inventories 136,900 143,000 not attempted Prepaid items 26,200 11,800 not attempted Total current assets 255,500 221,800 not attempted Investments 27,000 20,900 not attempted Plant (net) 271,200 256,300 not attempted Land 29,700 25,000 not attempted Total...
Marbry Corporation's balance sheet and income statement appear below: Comparative Balance Sheet Ending Beginning Balance Balance...
Marbry Corporation's balance sheet and income statement appear below: Comparative Balance Sheet Ending Beginning Balance Balance $ 60 48 80 188 540 276 264 $ 452 $ 44 63 63 170 530 263 267 $437 Assets: Current assets: Cash and cash equivalents Accounts receivable Inventory Total current assets Property, plant, and equipment Less accumulated depreciation Net property, plant, and equipment Total assets Liabilities and stockholders' equity: Current liabilities: Accounts payable Accrued liabilities Income taxes payable Total current liabilities Bonds payable...
Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2 20-1 Net Sales (all on account) $428,000 $665,000 Cost of goods sold 399,800 261,150 Gross profit $265,200 $166,850 Administrative expenses $65,941 $42,631 Selling expenses 66,616 44,337 Total operating expenses $132,557 $86,968 Operating income $132,643 $79,882 Interest expense 1,255 1,177 Income before income taxes $131,388 $78,705 Income tax expense 30,865 13,151 Net income $100,523 $65,554 Miller Electronics Corporation Comparative Balance Sheet December 31, 20-2 and 20-1...
Problem 23.1A Horizontal and vertical analysis of income
statement and balance sheet. LO 23-1, 23-2
The EastTN Company sells computer parts through a retail store
that it operates. The firm’s comparative income statement and
balance sheet for the years 2016 and 2015 are shown below.
1-a.
Complete both a horizontal and a vertical analysis of
comparative income statement for the years 2016 and 2015.
(Round your percentage answers to 1 decimal place. i.e.,
0.123 should be entered as 12.3.)
1-b....
A comparative balance sheet and income statement for Groton Company follow: Groton Company Comparative Balance Sheet December 31, 2011 and 2010 2011 2010 Assets Cash Accounts receivable Inventory Prepaid expenses $8 $ 19 344 255 184 235 32 34 Total current assets 570541 Property, plant, and equipment Less accumulated depreciation 535 (82) 68) 456 Net property, plant, and equipment 453 388 Long-term investments 40 46 Total assets $1,063 $ 975 Liabilities and Stockholders' equity Accounts payable Accrued liabilities Income taxes...
Marbry Corporation's balance sheet and income statement appear below: Comparative Balance Sheet Ending Beginning Balance Balance $ 42 49 62 153 470 262 Assets: Current assets: Cash and cash equivalents Accounts receivable Inventory Total current assets Property, plant, and equipment Less accumulated depreciation Net property, plant, and equipment Total assets Liabilities and stockholders' equity: Current liabilities: Accounts payable Accrued liabilities Income taxes payable Total current liabilities Bonds payable $ 35 54 54 143 440 254 186 208 $361 $329 $...
You are to do a Vertical Analysis (on both the Balance Sheet
and Income Statement) for EACH of the years presented. You must
show your result as a % (not a decimal number) and round your %
results to exactly 2 decimal places (ex: 2.07% ~ not 2% ~ not
2.0734566%).
For these analyses, you are to present the actual tables of
your Vertical Analysis. Each of these analyses MUST SHOW: statement
titles, the name of every single individual account...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company Comparative Balance Sheet (dollars in millions) Ending Beginning Balance Balance Assets Current assets: Cash and cash equivalents $ 52 $ 107 Accounts receivable 770 705 Inventory 715 662 Total current assets 1,537 1,474 Property, plant, and equipment 1,635 1,601 Less accumulated depreciation 848 690 Net property, plant, and 787 911 equipment Total assets $2,324 $2,385 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $...
Marbry Corporation's balance sheet and income statement appear below: Comparative Balance Sheet Ending Beginning Balance Balance $ 60 48 80 188 540 276 264 $ 452 $ 44 63 63 170 530 263 267 $437 Assets: Current assets: Cash and cash equivalents Accounts receivable Inventory Total current assets Property, plant, and equipment Less accumulated depreciation Net property, plant, and equipment Total assets Liabilities and stockholders' equity: Current liabilities: Accounts payable Accrued liabilities Income taxes payable Total current liabilities Bonds payable...
Most questions answered within 3 hours.
-
Industry: Telecommunications in India
Here, you need to discuss the sources of the growth pattern
and...
asked 1 hour ago -
Hydrobromic acid
dissolves solid iron according to the followiaung reaction:
Fe(s)+2HBr(aq)→
FeBr2(aq)+ H2(g)
Part A. What...
asked 2 hours ago -
Verify the following vector identity in SPHERICAL
COORDINATES.
div(curl(A)) = 0
asked 4 hours ago -
The work function (Φ) for a metal is 7.50×10-19 J.
What is the longest wavelength (nm)...
asked 5 hours ago -
1. Would the following procedural changes cause the
calculated mass percent Ni2+ ion in Ni(NH3)nCl2 to...
asked 6 hours ago -
1. Why does the voltage of the capacitor vary with frequency?
where does this missing voltage...
asked 7 hours ago -
p p please write each step out clearly
3. A manager of a company is considering...
asked 6 hours ago -
On October 1, Ebony Ernst organized Ernst Consulting; on October
3, the owner contributed $83,540 in...
asked 8 hours ago -
A.)As an electron moves through a region of space, its speed
decreases from 9.60 × 106...
asked 8 hours ago -
In java with the netbeans program do:
Through object programming
Create a class "ContadorP", which is...
asked 8 hours ago -
Pattern Corporation acquired all of Science
Company's outstanding stock on January 1, 2016 for $600,000 cash....
asked 8 hours ago -
Here are all accounts Tyler Co. maintains.
Tax expenses $4,750
Common stocks $48,840
SG&A expenses $2,500...
asked 8 hours ago