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 9 months 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...
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...
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
$501,094
$418,000
Cost of goods sold
364,000
260,000
Gross profit
$137,094
$158,000
Selling expenses
$52,500
$35,000
Administrative expenses
29,920
22,000
Total operating expenses
$82,420
$57,000
Income from operations
$54,674...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 1.What do you see as the long term impacts of damaging species on the ecosystems of...
- Write a code in C to shift serially the content of the register labelled x through...
- Managing interpersonal relationships: What are the Layers of Self Disclosure? Which layers do you think are...
- merger and acquisition Firm Z has a current market value of $35 million and is considering...
- Compare the key components inherent in the national health insurance financing systems of two (2) different...
- Case – Bromiis Inc. Bromiis Inc., is an international ethical medical research drug manufacturer that specializes...
- Which psychological traps do you believe need to be watched for most in making smart decisions...
ADVERTISEMENT