Question

In: Accounting

5. The accounting staff of Sparks INC has assembled the following information for the year ended...

5. The accounting staff of Sparks INC has assembled the following information for the year ended December 31, 2019:

Cash Sales

$825,000

Credit sales

2,500,000

Collections on Account Receivable

2,200,000

Cash transferred from the money market fund to the general bank account

250,000

Interest and dividends received

100,000

Purchases all on account

1,800,000

Payments on accounts payable to merchandise suppliers

1,500,000

Cash payments for operating expenses

1,050,000

Interest paid

180,000

Income taxes paid

95,000

Loans made to borrowers

500,000

Collections on loans excl. receipts of interest

260,000

Cash paid to acquire plant assets

3,100,000

BV of plant assets sold

660,000

Loss on sales of plant assets

80,000

Proceeds from issuing bonds payable

2,500,000

Dividends paid

120,000

Cash and cash equivalents Jan 1

512,000

5.1. Prepare a statement of cash flows in the format Example below (Allison corporation) Place brackets around amounts representing cash outflows. Use the direct method of reporting cash flows from operating activities.

5.2. Some of the items above will be listed in your statement without change. However, you will have to combine certain given information to compute the amounts of
5.2.1. collections from customers,
5.2.2. cash paid to suppliers and employees, and

5.2.3. proceeds from sales of plant assets.
(Hint: Not every item listed is used in preparing a statement of cash flows.)

Solutions

Expert Solution

Sparks INC
Cash Flow Statement - Direct Method
For Year Ended December 31, 2019
Cash Flow from Operating Activities
Cash received from customers    3,025,000
Interest and dividend received      100,000
Cash provided by operating activities     3,125,000
Cash paid to suppliers & employees (2,550,000)
Interest paid     (180,000)
Income taxes paid       (95,000)
Cash distributed for operating activities    (2,825,000)
Net cash flows operating activities        300,000
Cash Flow from Investing Activities
Loans made to borrowers     (500,000)
Collections on loans      260,000
Purchases of plant assets (3,100,000)
Proceeds from sales of plant assets      580,000
Net cash flows investing activities    (2,760,000)
Cash Flow from Financing Activities
Proceeds from issuing bonds payable    2,500,000
Dividend paid     (120,000)
Net cash flows from financing activities     2,380,000
Net increase (decrease) in cash        (80,000)
Cash and cash equivalents, Jan 1, 2019        512,000
Cash and cash equivalents, Dec 31, 2019      432,000

Related Solutions

The accounting staff of Wyoming Outfitters, Inc., has assembled the following information for the current year...
The accounting staff of Wyoming Outfitters, Inc., has assembled the following information for the current year ended December 31. Cash and cash equivalents, Jan. 1 $ 35,800 Cash and cash equivalents, Dec. 31 120,900 Cash paid to acquire plant assets 23,000 Proceeds from short-term borrowing 10,000 Loans made to borrowers 4,300 Collections on loans (excluding interest) 4,000 Interest and dividends received 41,400 Cash received from customers 805,000 Proceeds from sales of plant assets 9,000 Dividends paid 54,000 Cash paid to...
The accounting staff of Wyoming Outfitters, Inc., has assembled the following information for the current year...
The accounting staff of Wyoming Outfitters, Inc., has assembled the following information for the current year ended December 31. Cash and cash equivalents, Jan. 1 $ 35,800 Cash and cash equivalents, Dec. 31 105,000 Cash paid to acquire plant assets 25,000 Proceeds from short-term borrowing 10,000 Loans made to borrowers 4,400 Collections on loans (excluding interest) 4,000 Interest and dividends received 27,600 Cash received from customers 795,000 Proceeds from sales of plant assets 9,000 Dividends paid 44,000 Cash paid to...
The accounting staff of Wyoming Outfitters, Inc., has assembled the following information for the current year...
The accounting staff of Wyoming Outfitters, Inc., has assembled the following information for the current year ended December 31. Cash and cash equivalents, Jan. 1 $ 35,800 Cash and cash equivalents, Dec. 31 137,700 Cash paid to acquire plant assets 22,000 Proceeds from short-term borrowing 10,000 Loans made to borrowers 4,200 Collections on loans (excluding interest) 4,000 Interest and dividends received 42,100 Cash received from customers 815,000 Proceeds from sales of plant assets 9,000 Dividends paid 45,000 Cash paid to...
Question 3 The accounting records of Nutronics Inc include the following information for the year ended...
Question 3 The accounting records of Nutronics Inc include the following information for the year ended Dec 31. 2017 Dec 31, 2017 Jan 1, 2017 Raw material inventory Work in process Finished goods inventory Direct Material used Direct labor Manufacturing overhead Selling expenses Administrative expenses Sales revenue $24,000 8,000 90,000 210,000 120,000 192,000 170,000 140,000 720,000 $20,000 12,000 80,000 Required A. Prepare a schedule of Cost of goods manufactured B. Assume that the company manufactures a single product and that...
Exercise 12-5 The following information is available for Splish Brothers Inc. for the year ended December...
Exercise 12-5 The following information is available for Splish Brothers Inc. for the year ended December 31, 2017. Beginning cash balance $ 47,835 Accounts payable decrease 3,933 Depreciation expense 172,206 Accounts receivable increase 8,717 Inventory increase 11,693 Net income 301,998 Cash received for sale of land at book value 37,205 Cash dividends paid 12,756 Income taxes payable increase 4,996 Cash used to purchase building 307,207 Cash used to purchase treasury stock 27,638 Cash received from issuing bonds 212,600 Prepare a...
The following information is available from the accounting records of Manahan Co. for the year ended...
The following information is available from the accounting records of Manahan Co. for the year ended December 31, 2016: Net cash provided by financing activities $ 118,000 Dividends paid 18,400 Loss from discontinued operations, net of tax savings of $41,367 124,100 Income tax expense 27,355 Other selling expenses 12,000 Net sales 649,200 Advertising expense 46,500 Accounts receivable 57,000 Cost of goods sold 370,044 General and administrative expenses 142,500 a. Calculate the operating income for Manahan Co. for the year ended...
Metlock, Inc. has the following information available for accruals for the year ended December 31, 2017....
Metlock, Inc. has the following information available for accruals for the year ended December 31, 2017. The company adjusts its accounts annually. 1. The December utility bill for $385 was unrecorded on December 31. Metlock paid the bill on January 11. 2. Metlock is open 7 days a week and employees are paid a total of $3,150 every Monday for a 7-day (Monday–Sunday) workweek. December 31 is a Thursday, so employees will have worked 4 days (Monday, December 28–Thursday, December...
The accounting staff of Pearl Inc. has prepared the following pension worksheet. Unfortunately, several entries in...
The accounting staff of Pearl Inc. has prepared the following pension worksheet. Unfortunately, several entries in the worksheet are not decipherable. The company has asked your assistance in completing the worksheet and completing the accounting tasks related to the pension plan for 2020. Determine the missing amounts in the 2020 pension worksheet, indicating whether the amounts are debits or credits. (Enter all amounts as positive.) Pension Worksheet—Pearl Inc. General Journal Entries Memo Record Annual Pension Expense    Cash OCI—Prior Service...
The following information is available for Weber Inc. on September 30 for the year just ended....
The following information is available for Weber Inc. on September 30 for the year just ended. Of the consulting fees Weber Inc. received in advance, $800 has been earned. Equipment purchased in a previous year for $18,500 will be sold after five years for $2,500. Interest of $1,140 has accrued on a bank loan and is unrecorded. Property taxes of $600 have accrued but are unrecorded. Buildings purchased in a previous year for $68,750 will be sold after ten years...
The following information is given for Aphria Farming Services Inc. for the year ended December 31,...
The following information is given for Aphria Farming Services Inc. for the year ended December 31, 2018. The account balances (all of which had their normal balance of debit or credit) at the beginning of 2018 (January 1, 2018) were as follows: Cash $ 2,200 Accounts Payable $ 23,700 Accounts Receivable $ 4,400 Income Tax Payable $ 15,100 Prepaid Supplies (Feed and Straw) $ 27,800 Interest Payable $ 2,700 Land (cost) $ 167,000 Wages Payable $ 14,200 Buildings (cost) $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT