Question

In: Accounting

. Complete the two final columns shown beside each item in Pinnacle Plus's comparative financial statements....

. 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 $116,000 $103,200 % Cost of Goods Sold 53,200 48,600 Gross Profit 62,800 54,600 Operating Expenses 39,000 34,500 Interest Expense 4,600 4,600 Income before Income Tax Expense 19,200 15,500 Income Tax Expense (30%) 5,760 4,650 Net Income $13,440 $10,850 % Balance Sheet Cash $68,340 $34,800 % Accounts Receivable, Net 18,200 10,800 Inventory 25,600 39,200 Property and Equipment, Net 95,600 108,000 Total Assets $207,740 $192,800 % Accounts Payable $43,200 $35,600 % Income Tax Payable 2,200 1,100 Note Payable (long-term) 46,000 46,000 Total Liabilities 91,400 82,700 Common Stock (par $10) 82,000 82,000 Retained Earnings† 34,340 28,100 Total Liabilities and Stockholders’ Equity $207,740 $192,800 % †During the current year, cash dividends amounting to $7,200 were declared and paid.

2-a. Which account increased by the largest dollar amount?

2-b. Which account increased by the largest percentage?

Solutions

Expert Solution

Income statement

Current year

Previous Year

Change in Dollars

Change in %

Sales revenue

$ 1,16,000.00

$ 1,03,200.00

$   12,800.00

12.4%

Cost of goods sold

$      53,200.00

$      48,600.00

$      4,600.00

9.5%

Gross profit

$      62,800.00

$      54,600.00

$      8,200.00

15.0%

Operating expenses

$      39,000.00

$      34,500.00

$      4,500.00

13.0%

Interest Expense

$        4,600.00

$        4,600.00

$                   -  

0.0%

Income before income tax expense

$      19,200.00

$      15,500.00

$      3,700.00

23.9%

Income tax expense

$        5,760.00

$        4,650.00

$      1,110.00

23.9%

Net income

$      13,440.00

$      10,850.00

$      2,590.00

23.9%

Balance sheet

Current year

Previous Year

Change in Dollars

Change in %

Assets

Cash

$      68,340.00

$      34,800.00

$   33,540.00

96.4%

Accounts receivables

$      18,200.00

$      10,800.00

$      7,400.00

68.5%

Inventory

$      25,600.00

$      39,200.00

$ (13,600.00)

-34.7%

Property land and equipment, Net

$      95,600.00

$ 1,08,000.00

$ (12,400.00)

-11.5%

Total Assets

$ 2,07,740.00

$ 1,92,800.00

$   14,940.00

7.7%

Liabilities

Accounts payable

$      43,200.00

$      35,600.00

$      7,600.00

21.3%

Income tax payable

$        2,200.00

$        1,100.00

$      1,100.00

100.0%

Note payable(Long term)

$      46,000.00

$      46,000.00

$                   -  

0.0%

Total Liabilities

$      91,400.00

$      82,700.00

$      8,700.00

10.5%

Shareholder's Equity

Common stock

$      82,000.00

$      82,000.00

$                   -  

0.0%

Retained earnings

$      34,340.00

$      28,100.00

$      6,240.00

22.2%

Total Shareholder's equity

$ 1,16,340.00

$ 1,10,100.00

$      6,240.00

5.7%

Total liabilities and shareholder's equity

$ 2,07,740.00

$ 1,92,800.00

$   14,940.00

7.7%

Requirement 2a

Cash account increased by largest dollar amount of $ 33,540

Requirement 2b

Income tax payable increased by Highest % of 100.0%


Related Solutions

Complete each of the columns on the table below, indicating in which section each item would...
Complete each of the columns on the table below, indicating in which section each item would be reported on the statement of cash flows (operating, investing, or financing), the amount that would be reported, and whether the item would create an increase or decrease in cash. For item that affect more than one section of the statement, indicate all affected. Assume the indirect method of reporting cash flows from operating activities. The first item has been completed as an example....
The comparative financial statements prepared at December 31 for Pinnacle Plus showed the following summarized data:...
The comparative financial statements prepared at December 31 for Pinnacle Plus showed the following summarized data: Current Year Previous Year Income Statement Sales Revenue $ 155,000 $ 135,000 Cost of Goods Sold 70,000 66,000 Gross Profit 85,000 69,000 Operating Expenses 45,000 40,200 Interest Expense 4,900 4,900 Income before Income Tax Expense 35,100 23,900 Income Tax Expense (30%) 10,530 7,170 Net Income $ 24,570 $ 16,730 Balance Sheet Cash $ 81,245 $ 29,000 Accounts Receivable, Net 26,000 21,000 Inventory 34,000 47,000...
The comparative financial statements prepared at December 31 for Pinnacle Plus showed the following summarized data:...
The comparative financial statements prepared at December 31 for Pinnacle Plus showed the following summarized data: Current Year Previous Year Income Statement Sales Revenue $ 150,000 $ 131,000 Cost of Goods Sold 68,000 64,000 Gross Profit 82,000 67,000 Operating Expenses 44,000 39,400 Interest Expense 4,800 4,800 Income before Income Tax Expense 33,200 22,800 Income Tax Expense (30%) 9,960 6,840 Net Income $ 23,240 $ 15,960 Balance Sheet Cash $ 79,940 $ 30,000 Accounts Receivable, Net 25,000 20,000 Inventory 33,000 46,000...
The comparative financial statements prepared at December 31 for Pinnacle Plus showed the following summarized data:...
The comparative financial statements prepared at December 31 for Pinnacle Plus showed the following summarized data: Current Year Previous Year Income Statement Sales Revenue $ 190,000 $ 163,000 Cost of Goods Sold 84,000 80,000 Gross Profit 106,000 83,000 Operating Expenses 52,000 45,800 Interest Expense 5,600 5,600 Income before Income Tax Expense 48,400 31,600 Income Tax Expense (30%) 14,520 9,480 Net Income $ 33,880 $ 22,120 Balance Sheet Cash $ 90,380 $ 22,000 Accounts Receivable, Net 33,000 28,000 Inventory 41,000 54,000...
Comparative financial statements for Wildhorse and Novak Ltd. are shown below. WILDHORSE AND NOVAK LTD. Income...
Comparative financial statements for Wildhorse and Novak Ltd. are shown below. WILDHORSE AND NOVAK LTD. Income Statement Year Ended December 31 2021 2020 Net sales $900,000 $840,000 Cost of goods sold 625,000 575,000 Gross profit 275,000 265,000 Operating expenses 154,000 150,000 Profit from operations 121,000 115,000 Other revenues and expenses    Interest expense 30,000 20,000 Profit before income tax 91,000 95,000 Income tax expense 27,000 20,000 Profit $64,000 $75,000 WILDHORSE AND NOVAK LTD. Balance Sheet December 31 Assets 2021 2020 2019...
Comparative financial statements for The Cullumber Company Ltd. are shown below. THE CULLUMBER COMPANY LTD. Income...
Comparative financial statements for The Cullumber Company Ltd. are shown below. THE CULLUMBER COMPANY LTD. Income Statement Year Ended December 31 2021 2020 Net sales $1,779,530 $1,819,610 Cost of goods sold 1,091,290 1,028,920 Gross profit 688,240 790,690 Operating expenses 521,960 422,530 Profit from operations 166,280 368,160 Interest expense 25,650 18,630 Profit before income tax 140,630 349,530 Income tax expense 42,189 104,859 Profit $98,441 $244,671 - / 1 View Policies Current Attempt in Progress Comparative financial statements for The Cullumber Company...
Comparative financial statements for Oriole and Cheyenne Ltd. are shown below. ORIOLE AND CHEYENNE LTD. Income...
Comparative financial statements for Oriole and Cheyenne Ltd. are shown below. ORIOLE AND CHEYENNE LTD. Income Statement Year Ended December 31 2021 2020 Net sales $900,000 $840,000 Cost of goods sold 625,000 575,000 Gross profit 275,000 265,000 Operating expenses 154,000 150,000 Profit from operations 121,000 115,000 Other revenues and expenses    Interest expense 30,000 20,000 Profit before income tax 91,000 95,000 Income tax expense 27,000 20,000 Profit $64,000 $75,000 ORIOLE AND CHEYENNE LTD. Balance Sheet December 31 Assets 2021 2020 2019...
Comparative financial statements for Weaver Company
Comparative financial statements for Weaver Company follow:During 2009, the company sold some equipment for $20 that had cost $40 and on which there was accumulated depreciation of $16. In addition, the company sold long-term investments for $10 that had cost $3 when purchased several years ago. Cash dividends totaling $30 were paid during 2009. Required:1. Using the indirect method, determine the net cash provided by operating activities for 2009.2. Using the information in (1) above, along with an analysis of...
1. The completed financial statement columns of the worksheet for Blossom Company are shown as follows:...
1. The completed financial statement columns of the worksheet for Blossom Company are shown as follows: Blossom Company Worksheet For the Year Ended December 31, 2020 Income Statement Balance Sheet Account No. Account Titles Dr. Cr. Dr. Cr. 101 Cash 9,000 112 Accounts Receivable 10,600 130 Prepaid Insurance 2,800 157 Equipment 24,100 158 Accumulated Depreciation—Equip. 4,300 201 Accounts Payable 8,900 212 Salaries and Wages Payable 2,300 301 Owner’s Capital 20,000 306 Owner’s Drawings 10,300 400 Service Revenue 60,100 622 Maintenance...
The comparative condensed income statements of Emley Corporation are shown below.
The comparative condensed income statements of Emley Corporation are shown below.   Instructions (a) Prepare a horizontal analysis of the income statement data for Emley Corporation using 2016 as a base. (Show the amounts of increase or decrease.) (b) Prepare a vertical analysis of the income statement data for Emley Corporation in columnar form for both years.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT