1-Complete vertical analysis by using the structure in the upper segment below and horizontal analysis in the lower segment below.
2-Briefly comment on the trend in the revenues and expenses below the horizontal analysis segment.
Comparative consolidated Income statement |
||||
For the year ended December 31, 2018 |
||||
12/31/2018 Amount |
Percent |
12/31/2017 Amount |
Percent |
|
Sales |
$ 32,76,800.00 |
100.00% |
$ 31,46,400.00 |
100.00% |
Cost of Goods sold |
$ 20,88,800.00 |
63.75% |
$ 20,08,400.00 |
63.83% |
Gross profit |
$ 11,88,000.00 |
36.25% |
$ 11,38,000.00 |
36.17% |
Operating Expenses |
||||
Selling expenses |
$ 4,76,800.00 |
14.55% |
$ 5,18,000.00 |
16.46% |
Administrative expenses |
$ 4,47,200.00 |
13.65% |
$ 4,23,200.00 |
13.45% |
Total Operating expenses |
$ 9,24,000.00 |
28.20% |
$ 9,41,200.00 |
29.91% |
Operating Income |
$ 2,64,000.00 |
8.06% |
$ 1,96,800.00 |
6.25% |
Interest expense |
$ 65,600.00 |
2.00% |
$ 39,200.00 |
1.25% |
Income before income tax |
$ 1,98,400.00 |
6.05% |
$ 1,57,600.00 |
5.01% |
Income tax expense |
$ 62,400.00 |
1.90% |
$ 56,800.00 |
1.81% |
Net income |
$ 1,36,000.00 |
4.15% |
$ 1,00,800.00 |
3.20% |
Comparative consolidated Income statement |
||||
For the year ended December 31, 2018 |
||||
Increase (Decrease) |
||||
12/31/2018 |
12/31/2017 |
Amount |
Percent |
|
Sales |
$ 32,76,800.00 |
$ 31,46,400.00 |
$ 1,30,400.00 |
4.14% |
Cost of Goods sold |
$ 20,88,800.00 |
$ 20,08,400.00 |
$ 80,400.00 |
4.00% |
Gross profit |
$ 11,88,000.00 |
$ 11,38,000.00 |
$ 50,000.00 |
4.39% |
Operating Expenses |
||||
Selling expenses |
$ 4,76,800.00 |
$ 5,18,000.00 |
$ (41,200.00) |
-7.95% |
Administrative expenses |
$ 4,47,200.00 |
$ 4,23,200.00 |
$ 24,000.00 |
5.67% |
Total Operating expenses |
$ 9,24,000.00 |
$ 9,41,200.00 |
$ (17,200.00) |
-1.83% |
Operating Income |
$ 2,64,000.00 |
$ 1,96,800.00 |
$ 67,200.00 |
34.15% |
Interest expense |
$ 65,600.00 |
$ 39,200.00 |
$ 26,400.00 |
67.35% |
Income before income tax |
$ 1,98,400.00 |
$ 1,57,600.00 |
$ 40,800.00 |
25.89% |
Income tax expense |
$ 62,400.00 |
$ 56,800.00 |
$ 5,600.00 |
9.86% |
Net income |
$ 1,36,000.00 |
$ 1,00,800.00 |
$ 35,200.00 |
34.92% |
Comment
The company has shown great results due to decrease in expenses in comparison to last year. Even though revenues have not increased that much but due to high reduction in expense net income has increased by 35% approx.
, Alternate answer with 1 decimal place in Percentages
Comparative consolidated Income statement |
||||
For the year ended December 31, 2018 |
||||
Increase (Decrease) |
||||
12/31/2018.. |
12/31/2017.. |
Amount |
Percent |
|
Sales |
$ 32,76,800.00 |
$ 31,46,400.00 |
$ 1,30,400.00 |
4.1% |
Cost of Good sold |
$ 20,88,800.00 |
$ 20,08,400.00 |
$ 80,400.00 |
4.0% |
Gross profit |
$ 11,88,000.00 |
$ 11,38,000.00 |
$ 50,000.00 |
4.4% |
Operating Expenses |
||||
Selling expenses |
$ 4,76,800.00 |
$ 5,18,000.00 |
$ (41,200.00) |
-8.0% |
Administative expenses |
$ 4,47,200.00 |
$ 4,23,200.00 |
$ 24,000.00 |
5.7% |
Total Operating expenses |
$ 9,24,000.00 |
$ 9,41,200.00 |
$ (17,200.00) |
-1.8% |
Operating Income |
$ 2,64,000.00 |
$ 1,96,800.00 |
$ 67,200.00 |
34.1% |
Interest expense |
$ 65,600.00 |
$ 39,200.00 |
$ 26,400.00 |
67.3% |
Income before income tax |
$ 1,98,400.00 |
$ 1,57,600.00 |
$ 40,800.00 |
25.9% |
Income tax expense |
$ 62,400.00 |
$ 56,800.00 |
$ 5,600.00 |
9.9% |
Net income |
$ 1,36,000.00 |
$ 1,00,800.00 |
$ 35,200.00 |
34.9% |
Comparative consolidated Income statement |
||||
For the year ended December 31, 2018 |
||||
12/31/2018 Amount |
Percent |
12/31/2017 Amount |
Percent |
|
Sales |
$ 32,76,800.00 |
100.0% |
$ 31,46,400.00 |
100.0% |
Cost of Good sold |
$ 20,88,800.00 |
63.7% |
$ 20,08,400.00 |
63.8% |
Gross profit |
$ 11,88,000.00 |
36.3% |
$ 11,38,000.00 |
36.2% |
Operating Expenses |
||||
Selling expenses |
$ 4,76,800.00 |
14.6% |
$ 5,18,000.00 |
16.5% |
Administative expenses |
$ 4,47,200.00 |
13.6% |
$ 4,23,200.00 |
13.5% |
Total Operating expenses |
$ 9,24,000.00 |
28.2% |
$ 9,41,200.00 |
29.9% |
Operating Income |
$ 2,64,000.00 |
8.1% |
$ 1,96,800.00 |
6.3% |
Interest expense |
$ 65,600.00 |
2.0% |
$ 39,200.00 |
1.2% |
Income before income tax |
$ 1,98,400.00 |
6.1% |
$ 1,57,600.00 |
5.0% |
Income tax expense |
$ 62,400.00 |
1.9% |
$ 56,800.00 |
1.8% |
Net income |
$ 1,36,000.00 |
4.2% |
$ 1,00,800.00 |
3.2% |
1-Complete vertical analysis by using the structure in the upper segment below and horizontal analysis in...
Answer question 2 and 3 ty (2. vertical analysis 3. simple
explaination)
Chapter 16 Homework Problem erkitch Company's condensed comparative income statements and comparative balance sheets for 2016 and 2015 follow Merkitch Company Comparative Income Statements For the Years Ended December 31, 2016 and 2015 2016 2015 Net sales Cost of goods sold Gross profit Operating expenses $3,276,800 2,088,800 $1,188,000 $3,146,400 2,008,400 $1,138,000 $518,000 423,200 $924,000$941,200 $196,800 39,200 $157,600 56,800 100,800 $2.52 $476,800 447,200 Selling expenses Administrative expenses Total operating...
Merkitch Company's condensed comparative income statements and comparative balance sheets for 2016 and 2015 follow. Merkitch Company Comparative Income Statements For the Years Ended December 31, 2016 and 2015 Increase (Decrease) 2016 2015 Amount of ChagePercentage $3,276,800 Net sales Cost of goods sold Gross profit Operating expenses $3,146,400 2,008,400 $1,138,000 $1,188,000 $476,800 447,200 5924,000 5264,000 55,600 $198,400 62,400 136,000 518,000 423,200 941,200 $196,800 39,200 157,600 56,800 100,800 Seling expenses Administrative expenses Total operating expenses Net operating income Interest expense Income...
1. Complete the "Amount" and "%" columns to be used in a horizontal analysis of the income statements for Anything Tennis. (Decreases should be indicated by a minus sign. Round your percentage answers to 1 decimal place.) Net sales Cost of goods sold Gross profit Operating expenses Operating income Other income (expense) Income before tax Income tax expense Net income Answer is complete but not entirely correct. ANYTHING TENNIS Income Statements For the Years Ended December 31 Increase (Decrease) 2021...
Complete a vertical and horizontal analysis for the balance
sheet.
Below is the summary operating statement
20x1
20x2
Variance (Horizontal)
#/$
%
Rooms available:
300.00
300.00
0.00%
Rooms sold:
79,388.00
81,140.00
2.21%
Occupancy:
72.50%
74.10%
2.21%
ADR:
183.62
191.33
7.71
4.20%
Rooms RevPar:
133.12
141.78
8.66
6.51%
Total RevPar:
176.20
185.65
9.45
5.36%
Operating revenue
Rooms
14,577,225.00
75.55%
15,524,516.00
76.37%
947,291.00
6.50%
Food and...
Using the tables (pictured) below, conduct a complete ratio
analysis of the Bartlett Company for the years 2018 and 2019. You
should assess the firm’s liquidity, activity, debt, and
profitability ratios. Highlight any particularly positive or
negative developments that you uncover when comparing ratios from
2018 to 2019.
Bartlett Company Income Statements ($000) For the Years Ended December 31 2019 2018 Sales revenue $3,080 $2,590 Less: Cost of goods sold 2,086 1,705 Gross profits $994 $885 Less: Operating expenses Selling...
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....
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%...
1) The image shows a completed schedule C using the cash method.
Complete schedule C using the ACCRUAL method.
2) Are there any differences between the 2018 and 2019
forms?
SCHEDULE C (Form 1040) Profit or Loss From Business (Sole Proprietorship) •Go to www.irs.gov/Schedulec for instructions and the latest information. OMB No. 1545-0074 2018 Department of the Treasury Internal Revenue Service (99) Name of proprietor RICK GRIME Attachment Attach to Form 1040, 1040NR, or 1041; partnerships generally must file Form...