/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q38PGA The 2018 comparative balance she... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

The 2018 comparative balance sheet and income statement of Appleton Group, Inc. follow. Appleton disposed of a plant asset at book value during 2018

Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for \(0. The cost and accumulated depreciation of the disposed asset was \)11,600. There were no sales of land, no retirement of common stock, and no treasury stock transactions. Assume plant asset and land acquisitions were for cash.

Short Answer

Expert verified

Net increase/(decrease) in cash is ($1,200).

Step by step solution

01

Statement of cash flows using indirect method

Appleton Group Inc.

Spreadsheet for statement of cash flows

Year ended December 31, 2018
Panel A-Balance Sheet

Balance

31/12/2017

Transaction Analysis

Balance

31/12/2018

Debit

Credit

Cash

$15,900

$14,700

Account receivables

$43,900.00

$1,700.00

$42,200

Land

$17,000.00

$25,200.00

$42,200

Plant Assets

$110,750

$11,200

$121,950

Accumulated Depreciation

($16,450)

($3,800)

($20,250)

Merchandise Inventory

$93,900

$3,700

$97,600

Total Assets

$265,000

$298,400

Accounts Payable

$26,900

$1,000

$25,900

Accrued Liabilities

$22,700

$1,800

$24,500

Common stock

$130,700

$8,200

$138,900

Notes Payable (Long-Term)

$65,000

$14,000

$51,000

Retained Earnings

$19,700

$38,400

$58,100

Total Liabilities and Shareholder’s Equity

$265,000

$298,400

Panel B- Statement of Cash Flows

Cash Flows from Operating Activities

Net Income

$66,700

Adjustments to Reconcile Net Income to Net cash provided by Operating Activities:

Depreciation expense

$15,400

Decrease in account receivable

$1,700

Increase in merchandise inventory

$3,700

Increase in account payable

$1,000

Decrease in accrued liabilities

$1,800

Net cash provided/ (used) in Operating activities

Cash Flows from investing Activities:

Purchase of Plant

$22,800

Purchase of land

$25,200

Net cash provided/ (used) in investing activities

Cash Flows from Financing Activities:

Issuance of common stock

$8,200

Payment of notes payable

$14,000

Dividend Paid

$28,300

Net cash provided/ (used) in financing activities

Net increase/ (Decrease) in cash

$1,200

Total

$95,000

$95,000

02

Calculation of cash paid for the purchase of plant

Cashpaid=Closingbalance+costofdisposedasset–openingbalance=$121,950+$11,600-$110,750=$22,800

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Preparing the direct method statement of cash flows Use the data in Short Exercise S14A-12 and your results. Prepare the business’s complete statement of cash flows for the year ended June 30, 2018, using the direct method for operating activities.

Rouse Exercise Equipment, Inc. reported the following financial statements for 2018:

ROUSE EXERCISE EQUIPMENT, INC.

Income statement

Year ended December 31, 2018

Net sales revenue

\(713,000

Cost of goods sold

342,000

Gross Profit

371,000

Operating expense:

  • Depreciation expense

54,000

  • Other operatin expenses

210,000

Net Income

\)107,000

ROUSE EXERCISE EQUIPMENT, INC.

Comparative Balance sheet

December 31, 2018 and 2017

2018

2017

Assets

Current assets:

Cash

17,000

16,000

Accounts receivable

57,000

46,000

Merchandise inventory

79,000

90,000

Long term assets:

Plant assets

260,500

216,400

Accumulated depreciation-Plant assets

(38,500)

(32,400)

Investments

96,000

73,000

Total assets

\(471,000

\)409,000

Liabilities

Current liabilities

Accounts payable

72,000

71,000

Salaries payable

3,000

5,000

Long-term liabilities

Notes payable

61,000

69,000

Total liabilities

136,000

145,000

Stockholder’s equity

Common stock, no par

45,000

34,000

Retained earnings

290,000

230,000

Total stockholder’s equity

335,000

264,000

Total liabilities and stockholder’s equity

\(471,000

\)409,000

Requirements

1. Compute the amount of Rouse Exercise’s acquisition of plant assets. Assume the acquisition was for cash. Rouse Exercise disposed of plant assets at book value. The cost and accumulated depreciation of the disposed asset was $47,900. No cash was received upon disposal.

2. Compute new borrowing or payment of long-term notes payable, with Rouse

Exercise having only one long-term notes payable transaction during the year.

3. Compute the issuance of common stock with Rouse Exercise having only one

common stock transaction during the year.

4. Compute the payment of cash dividends.

Question: Big Island, Inc. began 2018 with cash of \(40,000. During the year, Big Island earned revenue of \)200,000 and collected \(120,000 from customers. Expenses for the year totaled \)160,000, of which Big Island paid \(65,000 in cash to suppliers and \)80,000 in cash to employees. The company received \(2,000 cash for interest revenue and paid \)10,000 for income taxes. Big Island also paid \(35,000 to purchase equipment and a cash dividend of \)15,000 to its stockholders during 2018. Prepare the company’s operating activities section of the statement of cash flows for the year ended December 31, 2018. Use the direct method.

Question: Computing cash flow items—direct method Consider the following facts:

  1. Beginning and ending Accounts Receivable are \(24,000 and \)20,000, respectively. Credit sales for the period total \(68,000.
  2. Cost of goods sold is \)77,000.
  3. Beginning Merchandise Inventory balance is \(29,000, and ending Merchandise Inventory balance is \)26,000.
  4. Beginning and ending Accounts Payable are \(12,000 and \)16,000, respectively.

Requirements

  1. Compute cash collections from customers.
  2. Compute cash payments for merchandise inventory

Use the Rouse Exercise Equipment data in Exercises E14-23 and E14-24. Rouse plansto purchase a truck for \(23,000 and a forklift for \)125,000 next year. In addition, itplans to pay cash dividends of $3,500. Assuming Rouse plans similar activity for 2019,what would be the amount of free cash flow?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.