Question
In: Accounting
5. Horizontal Analysis 12/31/17 12/31/16 Dollar Change Percentage Change Sales $9,550,000 $6,582,000 Net Income $775,000 $620,000...
5.
|
Horizontal Analysis |
12/31/17 |
12/31/16 |
Dollar Change |
Percentage Change |
|
Sales |
$9,550,000 |
$6,582,000 |
||
|
Net Income |
$775,000 |
$620,000 |
Complete the variance and percentage change for items above. (Round % to one decimal place)
b. Interpret your findings:
Accy 306 Quiz #5, page 2 of 2
6.
Happy Days, Inc.
Comparative Balance Sheet
December 31, 2017 and 2016
|
Assets |
Increase (Decrease) |
|||
|
2017 |
2016 |
Amount |
Percent |
|
|
Current assets |
225,000 |
$180,000 |
||
|
Property, plant, and equipment |
450,000 |
410,000 |
||
|
Intangible assets |
20,700 |
30,000 |
||
|
Total Assets |
75,700 |
12.2% |
||
|
Liabilities |
||||
|
Current liabilities |
75,000 |
80,000 |
||
|
Long-term liabilities |
220,000 |
260,000 |
||
|
Total Liabilities |
(47,000) |
(13.8%) |
||
|
Stockholders’ Equity |
||||
|
Common stock |
275,000 |
210,000 |
||
|
Retained earnings |
125,700 |
70,000 |
||
|
Total Stockholders’ Equity |
120,700 |
43.1% |
||
|
Total Liabilities & Stockholders’ Equity |
75,700 |
12.2% |
||
Prepare a comparative balance sheet (horizontal analysis) for December 31, 2017 and 2016. (Round percentages to one decimal place.)
Interpret your findings: Focus on two accounts you find most interesting and explain why. What may have caused the accounts to change?
Vertical Analysis: In 2017: Current Assets are what % of Total Assets? _____________
Solutions
Expert Solution
| Ans.5(a) | Horizontal Analysis | 13/31/17 | 12/31/16 | Dollar Change | Percentage Change | ||
| Sales | $ 9,550,000 | $ 6,582,000 | $ 2,968,000 | 45.1% | |||
| Net Income | $ 775,000 | $ 620,000 | $ 155,000 | 25% | |||
| Ans.5(b) | Interpretation: | ||||||
| i) | Change in Sales (dollar) = $9,550,000 - $6,582,000 | ||||||
| = | $ 2,968,000 | ||||||
| ii) | Change in Net Income (dollar) = | $775,000 - $6,20,000 | |||||
| = | $ 155,000 | ||||||
| iii) | Percentage change in: | ||||||
| Sales = | Change in sale / Previous year sale | ||||||
| = | $2,968,000 / $6,582,000 | ||||||
| = | 45.1% | ||||||
| iv) | Net Income= | Change in sale / Previous year sale | |||||
| = | $155,000 / $620,000 | ||||||
| = | 25% | ||||||
| Ans.6 | Happy Days, Inc. | ||||||
| Comparative Balance Sheet | |||||||
| December 31, 2017 and 2016 | |||||||
| Assets | Increase/(Decrease) | ||||||
| 2017 | 2016 | Amount | Percent | ||||
| Current Asset | 225,000 | 180,000 | 45,000 | 25.0% | |||
| Property,plant and Equipment | 450,000 | 410,000 | 40,000 | 9.8% | |||
| Intangible Asset | 20,700 | 30,000 | (9,300) | -31.0% | |||
| Total Asset | 695,700 | 620,000 | 75,700 | 12.2% | |||
| Liabilities: | |||||||
| Current Liabilities | 75,000 | 80,000 | (5,000) | -6.3% | |||
| Long Term Liabilities | 220,000 | 260,000 | (40,000) | -15.4% | |||
| Total Liabilities | 295,000 | 340,000 | (45,000) | -13.2% | |||
| Stockholders' Equity | |||||||
| Common Stock | 275,000 | 210,000 | 65,000 | 31.0% | |||
| Retained Earnings | 125,700 | 70,000 | 55,700 | 79.6% | |||
| Total Stockholderss' Equity | 400,700 | 280,000 | 120,700 | 43.1% | |||
| Total Liabilities & Stockholders' Equity | 695,700 | 620,000 | 75,700 | 12.2% | |||
| # | Vertical Analysis: In 2017: Current Assets % of Total Assets is: | ||||||
| = | $225,000 / $695700 | ||||||
| = | 32.3% | ||||||
ekkarill92 answered 2 years agoRelated Solutions
Carolina Products Income Statement Years Ended 12/31/2016 & 12/31/2015 Horizontal Analysis 2016 2015 $ Change %...
Carolina Products
Income Statement
Years Ended 12/31/2016 &
12/31/2015
Horizontal Analysis
2016
2015
$ Change
% Change
Sales
$272,500
$270,010
Cost of Goods Sold
$157,472
$154,589
Gross Profit
$115,028
$115,421
Operating Expenses:
Selling Expense
$49,675
$48,500
Salary Expense
$30,000
$28,000
Administrative Expense
$15,500
$15,400
Advertising Expense
$3,400
$3,200
Utilities Exp
$1,100
$1,000
Depreciation Exp
$1,620
$1,450
Total Operating Expenses
$101,295
$97,550
Net Income
$13,733
$17,871
Carolina Products Balance Sheet 12/31/2016 & 12/31/2015 Horizontal Analysis Assets 2016 2015 $ Change % Change...
Carolina Products
Balance Sheet
12/31/2016 & 12/31/2015
Horizontal Analysis
Assets
2016
2015
$ Change
% Change
Cash
$108,886
$107,455
Accounts Receivable
$105,650
$112,420
Prepaid Insurance
$1,100
$1,000
Inventory
$205,000
$189,350
Prepaid Expenses
$1,200
$1,050
Land
$80,000
$80,000
Office Equipment
$10,500
$10,500
Accum Depr-Office Equip
($2,000)
($2,200)
Total Assets
$510,336
$501,590
Liabilities
Accounts Payable
$72,090
$70,005
Sales Tax Payable
$3,500
$3,450
Interest Payable
$860
$825
Total Liabilities
$76,450
$74,280
Stockholders Equity
Common Stock
$60,000
$58,000
Paid in Capital in Excess of...
Perform a horizontal analysis providing both the amount and percentage change. (Round Percentage answers to 1...
Perform a horizontal analysis providing both the amount and
percentage change. (Round Percentage answers to 1 decimal
place. Decreases should be indicated by a minus
sign.)
Year
2018
2017
Cash
$
278,860
$
730,000
Accounts
receivable
324,090
130,000
Inventory
715,680
630,000
Long-term
assets
3,280,330
2,230,000
Total assets
$
4,598,960
$
3,720,000
ABC Company Income Statement For the 12 month period ended 12/31/2016 Net Sales Cost of Sales...
ABC Company Income Statement
For the 12 month period ended 12/31/2016
Net Sales
Cost of Sales
$ 450,000
Gross Profit
$ 500,000
Operating Expenses:
Depreciation
$ 75,000
Amortization
$ 25,000
Other Operating Expenses
Total Operating Expenses
$ 400,000
Income From Operations
Interest Expense
Net Income Before Taxes
$ 80,000
Taxes- 30%
Net Income
EBITDA
17) Yellow Company reported net income of $520,000 for the year ended 12/31/21. Included in the...
17) Yellow Company reported net income of $520,000 for
the year ended 12/31/21. Included in the computation of net income
were: depreciation expense, $85,000; amortization of a patent,
$40,000; income from an investment in common stock of XYZ Inc.,
accounted for under the equity method, $62,000; and amortization of
a bond discount, $17,000. Yellow also paid an $60,000 dividend
during the year. The net cash provided (used) by operating
activities would be reported at ______
18) Apple, Inc. reported net...
Financial Position as of 12/31/16 12/31/17 12/31/18 Cash $ 89,100 $130,100 $154,500 Accounts receivable 79,700 101,600...
Financial Position as of
12/31/16
12/31/17
12/31/18
Cash
$ 89,100
$130,100
$154,500
Accounts receivable
79,700
101,600
125,400
Inventory
125,400
139,000
172,500
Other assets
162,800
171,400
198,400
Total assets
$457,000
$542,100
$650,800
Accounts payable
$ 39,700
$ 59,600
$ 79,700
Other liabilities
78,200
85,700
109,400
Common stock
198,400
198,400
198,400
Retained earnings
140,700
198,400
263,300
Total liabilities and equity
$457,000
$542,100
$650,800
Income for Years Ended
12/31/17
12/31/18
Sales revenue
$1,062,600
$1,490,760
Less:
Cost of goods sold
498,300
746,000
Other expenses...
BLOSSOM INC. COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 12/31/17 12/31/16 Cash $5,900...
BLOSSOM INC.
COMPARATIVE BALANCE SHEET
AS OF DECEMBER 31, 2017 AND 2016
12/31/17
12/31/16
Cash
$5,900
$6,900
Accounts receivable
61,400
50,800
Short-term debt investments
(available-for-sale)
35,000
17,800
Inventory
40,000
59,400
Prepaid rent
5,000
3,900
Equipment
155,200
129,000
Accumulated
depreciation—equipment
(35,000
)
(25,000
)
Copyrights
45,600
49,900
Total assets
$313,100
$292,700
Accounts payable
$46,300
$39,800
Income taxes payable
3,900
6,100
Salaries and wages
payable
7,900
3,900
Short-term loans payable
8,000
10,100
Long-term loans payable
60,100
68,400
Common stock, $10 par
100,000...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement
For 20Y2, McDade Company reported a decline in net income. At
the end of the year, T. Burrows, the president, is presented with
the following condensed comparative income statement:
McDade Company
Comparative Income Statement
For the Years Ended December 31, 20Y2 and 20Y1
20Y2
20Y1
Sales
$693,095
$579,000
Cost of goods sold
518,000
370,000
Gross profit
$175,095
$209,000
Selling expenses
$73,500
$49,000
Administrative expenses
42,160
31,000
Total operating expenses
$115,660
$80,000
Income from operations
$59,435...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement
For 20Y2, McDade Company reported a decline in net income. At
the end of the year, T. Burrows, the president, is presented with
the following condensed comparative income statement:
McDade Company
Comparative Income Statement
For the Years Ended December 31, 20Y2 and 20Y1
20Y2
20Y1
Sales
$815,178
$741,000
Cost of goods sold
573,400
470,000
Gross profit
$241,778
$271,000
Selling expenses
$79,050
$62,000
Administrative expenses
46,720
39,000
Total operating expenses
$125,770
$101,000
Income from operations
$116,008...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement
For 20Y2, McDade Company reported a decline in net income. At
the end of the year, T. Burrows, the president, is presented with
the following condensed comparative income statement:
McDade Company
Comparative Income Statement
For the Years Ended December 31, 20Y2 and 20Y1
20Y2
20Y1
Sales
$505,848
$446,000
Cost of goods sold
358,400
280,000
Gross profit
$147,448
$166,000
Selling expenses
$51,300
$38,000
Administrative expenses
30,050
24,000
Total operating expenses
$81,350
$62,000
Income from operations
$66,098...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Two cannons are mounted as shown in the drawing and rigged to fire simultaneously. They are...
- What is the potential of a cell made up of Zn|Zn2+ and Cu|Cu2+ half-cells at 25o...
- Write a Java Program using the following instruction: Create the following 3 methods that calculate and...
- How would the S/D curves shift if a $3 tax was imposed on suppliers for each...
- Why should a time-based authentication system invalidate the current password on a successful authentication?
- Explain the difference between a market penetration strategy and a market development strategy.
- QUESTION 4 Discuss the sanctity of life versus the quality of life debate as presented by...
ADVERTISEMENT