Question

over frve years 2. Prepa 3. Prepare BRCs e-step format, with all revenues listed together and all income statement for the year ended December 31,201 re BRCs balance sheet at December 31,2018 listed together statement of cash flows for the year ended December 31,2018. tlows from operating activities by the direst method. Format cash f P14A-37A Preparing the statement of cash nlows-direct method Use the Rolling Hills, Inc. data from Problem P14-3MA. Requirements 1. Prepare the 2018 statement of cash flows by the direct method. 2. How will what you learned in this problem help you evaluate an investment? Appendix 14A 1.Net Cash Phow by Op. Act $125,100 Collections from Cust $438.900 P14B-38A Using a spreadsheet to prepare the statement of indirect method Appendix 148 The 2018 comparative balance sheet and income statement follow. Appleton dis of Appleton Group, Inc. posed of a plant asset at book value during 2018. Cash Pmt. of Di 528,300 Cash Pt. lor Acq o Land $25,200 APPLETON GROUP, INC. Income Statement Year Ended r 31, 2018 Net Sales Revenue Cost of Goods Sold Gross Profit 443,000 205,800 237,200 Salaries Expense Depreciation Expense-Plant Assets Other Operating Expenses Total Operating Expenses 5 76,800 15,400 49,300 141,500 95,700 Operating Income Other Income and (Expenses): 11,600 (24,400) Interest Revenue Interest Expense Total Other Income and (Expenses) (12,800) 82,900 16,200 66,700 Net Income Before Income Taxes Income Tax Expense Net Income
APPLETON GROUP INC. Comparative Balance Sheet December 31, 2018 and 2017 2018 2017 Assets Current Assets: 15,900 43,900 $ 14,700 Cash Accounts Receivable Merchandise Inventory 42,200 97,600 93,900 Long-term Assets: Land Plant Assets Accumulated Depreciation-Plant Assets 42,200 121,950 (20,250) S 298,400 17,000 110,750 (16,450) $ 265,000 Total Assets Liabilities Current Liabilities: $ 25,900 26,900 Accounts Payable Accrued Liabilities 24,500 22,700 Long-term Liabilities: 65,000 114,600 Notes Payable 51,000 Total Liabilities 101,400 Stockholders Equity Common Stock, no par Retained Earnings Total Stockholders Equity Total Liabilities and Stockholders Equity 138,900 130,700 19,700 150,400 $ 298,400 265,000 58,100 197,000 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
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Appletion Group Inc,
Statement of Cash Flow
For the year ended Dec. 31, 2018
A) Cash Flows from Operating Activities:
              Net Income 66,700
Adjustment to reconcile net Cash:
       Depreciation Expense 15,400
       Decrease in Account Receivables 1,700
       Increase in Merchandising inventories -3,700
       Decrease in Account Payable -1,000
       Increase in Accrued Liabilities 1,800
Total Adjustment 14,200
Net Cash provided by Operating Activities 80,900
B) Cash Flow from Investing Activities:
Purchase of Land with cash -25,200
Purchase of Plant Assets with cash (Note: 1) -22,800
Net Cash Used In Investing Activities: -48,000
C) Cash Flow From Investing Activities:
Re-payment of Notes Payable -14,000
Issue of common stock for cash 8,200
Cash Dividend Paid (Note:2) -28,300
Net Cash used in Financing Activities: -34,100
Net Cash in Operation (A+B+C) -1,200
Add: Beginning Cash Balance 15,900
Ending Cash Balance (Answer) 14,700
Note:1
Beginning Plant Assets 110,750
Less: Plant with original cost Disposed off 11,600
Balance Left   99,150
Ending Balance of Plant Assets 121,950
Less: Remaining Plant Assets 99,150
New Plant Purchased in current year 22,800
Note: 2
Beginning Retained Earning Balance 19,700
Add: Net Income 66,700
Total Balance 86,400
Less: Cash Dividend Paid (balancing figure) 28,300
Ending Retained Earning Balance 58,100
Add a comment
Know the answer?
Add Answer to:
over frve years 2. Prepa 3. Prepare BRC's e-step format, with all revenues listed together and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • P16B-45B Using a spreadsheet to prepare the statement of cash flows- indirect method The 2018 comparative...

    P16B-45B Using a spreadsheet to prepare the statement of cash flows- indirect method The 2018 comparative balance sheet and income statement of Attleboro Group, follow. Attleboro disposed of a plant asset at book value in 2018. ATTLEBORO GROUP, INC. Income Statement Year Ended December 31, 2018 $441,000 205,400 235,600 $ 76,300 15,300 49,600 Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Salaries Expense Depreciation Expense Other Operating Expenses Total Operating Expenses Operating Income Other Income and (Expenses):...

  • The 2018 Comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of...

    The 2018 Comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value during 2018. Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows operating activities by the indirect method. A plant asset was disposed of for $0. The cost and accumulated depreciation of the disposed asset was $12,300. There were no sales of land, no retirement of common stock, and no treasury stock transactions. Assume plant...

  • put together a Spreadsheet for Statement of Cash Flows for the same problem 16B-45B. Format the...

    put together a Spreadsheet for Statement of Cash Flows for the same problem 16B-45B. Format the spreadsheet as shown in Exhibit 16B-1. P16B-45B Using a spreadsheet to prepare the statement of cash flows-indirect method The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value in 2018. ATTLEBORO GROUP, INC. Income Statement Year Ended December 31, 2018 $441,000 205,400 235,600 $ 76,300 15,300 49,600 Net Sales Revenue Cost of...

  • The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of...

    The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value during 2018. The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value during 2018 EEE (Click the icon to view the comparative balance sheet.) EEB (Click the icon to view the income statement.) Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows...

  • The 2018 comparative balance sheet and income statement of Allen ​Group, Inc. follow. Allen disposed of...

    The 2018 comparative balance sheet and income statement of Allen ​Group, Inc. follow. Allen 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 $ 12,600. There were no sales of​ land, no retirement of common​ stock, and no treasury stock transactions....

  • A (Click the icon to view the additional information.) The 2018 income statement and comparative balance...

    A (Click the icon to view the additional information.) The 2018 income statement and comparative balance sheet of All Wired, Inc. follow: (Click the icon to view the income statement.) E: (Click the icon to view the comparative balance sheet.) Read the requirements. Requirement 1. Prepare the 2018 statement of cash flows, formatting operating activities by the indirect method. (Use a minus sign or parentheses for amounts that result in a decrease in cash. If a box is not used...

  • Ryle Exercise Equipment, Inc. reported the following financial statements for 2018: Prepare the company's statement of...

    Ryle Exercise Equipment, Inc. reported the following financial statements for 2018: Prepare the company's statement of cash flows-indirect method-for the year ended December 31, 2018. Assume investments are purchased with cash. Ryle Exercise Equipment, Inc. reported the following financial statements for Prepare the company's statement of cash flows-indirect method-for the 2018 EEB (Click the icon to view the income statement.) EB (Click the icon to view the comparative balance sheet) (Click the icon to view additional information.) year ended December...

  • U V W Cumparative balance sheet.) Read the requirements 0 Requirements i More info 1. Prepare...

    U V W Cumparative balance sheet.) Read the requirements 0 Requirements i More info 1. Prepare the 2018 statement of cash flows, formatting operating activities by the indirect method 2. How will what you leared in this problem help you evaluate an investment? Additionally, Get Wired purchased land of $22,900 by financing it 100% with long-term notes payable during 2018. During the year, there were no sales of land no retirements of stock, and no treasury stock transactions. A plant...

  • can someone please help me The 2018 income statement and comparative balance sheet of Granite Rock,...

    can someone please help me The 2018 income statement and comparative balance sheet of Granite Rock, Inc. follow: (Click the icon to view the income statement.) B (Clicly the icon to view the comparative balance sheet.) $ 108,500 Granite Rock, Inc. Statement of Cash Flows Year Ended December 31, 2018 Cash Flows from Operating Activities: Net Income Adjustments to Reconcile Net Income to Net Cash Provided by (Used for) Operating Activities: Depreciation Expense-Plant Assets Increase in Accounts Receivable Decrease in...

  • Please complete in excel The Statement of Cash Flows 989 P16-34A Preparing the statement of cash...

    Please complete in excel The Statement of Cash Flows 989 P16-34A Preparing the statement of cash flows-indirect method with Learning Objective 2 non-cash transactions The 2015 income statement and comparaive balance sheet of Rolling Hills, Inc. follow 1. Net Cash Prov. by Op. Act. $125,700 ROLLING HILLS, INC. Income Statement Year Ended December 31, 2015 Sales Revenue $436,000 Cost of Goods Sold 202,200 Gross Profit 233,800 Operating Expenses Salaries Expense $78,400 Depreciation Expense-Plant Assets 14,400 Other Operating Expenses 10,200 Total...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT