Required 1 Complete the two final columns shown beside each item in Pinnacle Plu
ID: 2411646 • Letter: R
Question
Required 1 Complete the two final columns shown beside each item in Pinnacle Plus's comparative financial statements. (Decreases should be indicated by a minus sign. Round your percentage values to 1 decimal place.) PINNACLE PLUS Horizontal Analysis Increase (Decrease in the Current year (versus Previous year) Current Year Previous Year Amount Percentage Income Statement Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Interest Expense Income before Income Tax Expense Income Tax Expense (30%) Net Income Balance Sheet Cash Accounts Receivable, Net Inventory Property and Equipment, Net Total Assets Accounts Payable Income Tax Payable Note Payable (long-term) Total Liabilities Common Stock (par $10) Retained Earningst Total Liabilities and Stockholders' Equity 212,360$ 196,700 tDuring the current year, cash dividends amounting to $7,500 were declared and paid $ 119,000 S 105,300 48,900 56,400 35,250 4,900 16,250 4,875 11,375 53,800 65,200 40,500 4,900 19,800 5,940 2-a. Which account increased by the largest dollar amount? $ 13,860 S ccount $ 71,760 37,200 10,200 39,800 109,500 $ 212,360 S 196,700 $ 43,800 35,900 1,400 49,000 86,300 82,000 28,400 18,800 25,900 95,900 2,800 49,000 95,600 82,000 34,760 2-b. Which account increased by the largest percentage? ccountExplanation / Answer
Answers
Current Year
Previous Year
Increase (Decrease)
Amount
%
[A]
[B]
[C = A – B]
[D = (C/B) x 100]
Income Statement
Sales Revenue
$ 1,19,000.00
$ 1,05,300.00
$ 13,700.00
13.0%
Cost of Goods Sold
$ 53,800.00
$ 48,900.00
$ 4,900.00
10.0%
Gross profit
$ 65,200.00
$ 56,400.00
$ 8,800.00
15.6%
operating expenses
$ 40,500.00
$ 35,250.00
$ 5,250.00
14.9%
interest expenses
$ 4,900.00
$ 4,900.00
$ -
0.0%
Income before ITE
$ 19,800.00
$ 16,250.00
$ 3,550.00
21.8%
ITE
$ 5,940.00
$ 4,875.00
$ 1,065.00
21.8%
Net Income
$ 13,860.00
$ 11,375.00
$ 2,485.00
21.8%
Balance Sheet
Cash
$ 71,760.00
$ 37,200.00
$ 34,560.00
92.9%
A/R net
$ 18,800.00
$ 10,200.00
$ 8,600.00
84.3%
inventory
$ 25,900.00
$ 39,800.00
$ (13,900.00)
-34.9%
PPE, net
$ 95,900.00
$ 1,09,500.00
$ (13,600.00)
-12.4%
Total Assets
$ 2,12,360.00
$ 1,96,700.00
$ 15,660.00
8.0%
A/P
$ 43,800.00
$ 35,900.00
$ 7,900.00
22.0%
Income tax payable
$ 2,800.00
$ 1,400.00
$ 1,400.00
100.0%
Notes payable LT
$ 49,000.00
$ 49,000.00
$ -
0.0%
Total Liabilities
$ 95,600.00
$ 86,300.00
$ 9,300.00
10.8%
Common Stock
$ 82,000.00
$ 82,000.00
$ -
0.0%
Retained earnings
$ 34,760.00
$ 28,400.00
$ 6,360.00
22.4%
Total Liabilities & SE
$ 2,12,360.00
$ 1,96,700.00
$ 15,660.00
8.0%
Current Year
Previous Year
Increase (Decrease)
Amount
%
[A]
[B]
[C = A – B]
[D = (C/B) x 100]
Income Statement
Sales Revenue
$ 1,19,000.00
$ 1,05,300.00
$ 13,700.00
13.0%
Cost of Goods Sold
$ 53,800.00
$ 48,900.00
$ 4,900.00
10.0%
Gross profit
$ 65,200.00
$ 56,400.00
$ 8,800.00
15.6%
operating expenses
$ 40,500.00
$ 35,250.00
$ 5,250.00
14.9%
interest expenses
$ 4,900.00
$ 4,900.00
$ -
0.0%
Income before ITE
$ 19,800.00
$ 16,250.00
$ 3,550.00
21.8%
ITE
$ 5,940.00
$ 4,875.00
$ 1,065.00
21.8%
Net Income
$ 13,860.00
$ 11,375.00
$ 2,485.00
21.8%
Balance Sheet
Cash
$ 71,760.00
$ 37,200.00
$ 34,560.00
92.9%
A/R net
$ 18,800.00
$ 10,200.00
$ 8,600.00
84.3%
inventory
$ 25,900.00
$ 39,800.00
$ (13,900.00)
-34.9%
PPE, net
$ 95,900.00
$ 1,09,500.00
$ (13,600.00)
-12.4%
Total Assets
$ 2,12,360.00
$ 1,96,700.00
$ 15,660.00
8.0%
A/P
$ 43,800.00
$ 35,900.00
$ 7,900.00
22.0%
Income tax payable
$ 2,800.00
$ 1,400.00
$ 1,400.00
100.0%
Notes payable LT
$ 49,000.00
$ 49,000.00
$ -
0.0%
Total Liabilities
$ 95,600.00
$ 86,300.00
$ 9,300.00
10.8%
Common Stock
$ 82,000.00
$ 82,000.00
$ -
0.0%
Retained earnings
$ 34,760.00
$ 28,400.00
$ 6,360.00
22.4%
Total Liabilities & SE
$ 2,12,360.00
$ 1,96,700.00
$ 15,660.00
8.0%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.