Question

In: Accounting

Required: Prepare a complete statement of cash flows using a spreadsheet; report its operating activities using...

Required:
Prepare a complete statement of cash flows using a spreadsheet; report its operating activities using the indirect method. (Enter all amounts as positive values.)

Please use the indirect method

Required information

Use the following information for the Problems below.

[The following information applies to the questions displayed below.]

Forten Company, a merchandiser, recently completed its calendar-year 2017 operations. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, (4) all debits to Accounts Payable reflect cash payments for inventory, and (5) Other Expenses are paid in advance and are initially debited to Prepaid Expenses. The company’s income statement and balance sheets follow.

FORTEN COMPANY
Comparative Balance Sheets
December 31, 2017 and 2016
2017 2016
Assets
Cash $ 51,400 $ 74,500
Accounts receivable 67,310 51,625
Inventory 277,156 252,800
Prepaid expenses 1,300 2,025
Total current assets 397,166 380,950
Equipment 156,500 109,000
Accum. depreciation—Equipment (37,125 ) (46,500 )
Total assets $ 516,541 $ 443,450
Liabilities and Equity
Accounts payable $ 54,141 $ 116,175
Short-term notes payable 10,300 6,200
Total current liabilities 64,441 122,375
Long-term notes payable 64,500 49,750
Total liabilities 128,941 172,125
Equity
Common stock, $5 par value 164,750 151,250
Paid-in capital in excess of par, common stock 38,500 0
Retained earnings 184,350 120,075
Total liabilities and equity $ 516,541 $ 443,450

  

FORTEN COMPANY
Income Statement
For Year Ended December 31, 2017
Sales $ 587,500
Cost of goods sold 286,000
Gross profit 301,500
Operating expenses
Depreciation expense $ 21,750
Other expenses 133,400 155,150
Other gains (losses)
Loss on sale of equipment (6,125 )
Income before taxes 140,225
Income taxes expense 25,650
Net income $ 114,575

Problem 12-4AA Indirect: Cash flows spreadsheet LO P1, P2, P3, P4

Additional Information on Year 2017 Transactions

  1. Net income was $114,575.
  2. Accounts receivable increased.
  3. Inventory increased.
  4. Prepaid expenses decreased.
  5. Accounts payable decreased.
  6. Depreciation expense was $21,750.
  7. Sold equipment costing $49,875, with accumulated depreciation of $31,125, for $12,625 cash. This yielded a loss of $6,125.
  8. Purchased equipment costing $97,375 by paying $32,000 cash and (i.) by signing a long-term note payable for the balance.
  9. Borrowed $4,100 cash by signing a short-term note payable.
  10. Paid $50,625 cash to reduce the long-term notes payable.
  11. Issued 2,600 shares of common stock for $20 cash per share.
  12. Declared and paid cash dividends of $50,300.
FORTEN COMPANY
Spreadsheet for Statement of Cash Flows
For Year Ended December 31, 2017
Analysis of Changes
December 31, 2016 Debit Credit December 31, 2017
Balance sheet—debit
Cash $74,500 $51,400
Accounts receivable 51,625
Inventory 252,800
Prepaid expenses 2,025
Equipment 109,000
$489,950 $51,400
Balance sheet—credit
Accumulated depreciation—Equipment $46,500
Accounts payable 116,175
Short-term notes payable 6,200
Long-term notes payable 49,750
Common stock, $5 par value 151,250
Paid-in capital in excess of par value, common stock 0
Retained earnings 120,075
$489,950 $0
Statement of cash flows
Operating activities
Investing activities
Financing activities
Non cash investing and financing activities
Purchase of equipment financed by long-term note payable
$0 $0

Solutions

Expert Solution

Solution

Forten company

spreadsheet for statement of cash flows:

December 31,2016 Debit Credit December 31,2017
Balance sheet -debits
Cash 74500 51400
Account receivable 51625 (b) 15685 67310
Inventory 252800 (c) 24356 277156
Prepaid expenses 2025 (d) 725 1300
Equipment 109000 (h) 97375 (g) 49875 156500
489950 553666
Balance sheet-credits
Accum.depreciation-equipment 46500 (g) 31,125 (f) 21750 37125
Account payable 116175 (e) 62034 54141
Short-term notes payable 6200 (j) 4100 10300
Long-term notes payable 49750 (k) 50625 (i) 65375 64500
Common stock, $5 par value 151250 (l) 13500 164750
Paid in capital in excess of par value, common stock 0 (l) 38500 38500
Retained earnings 120075 (m) 50300 (a) 114575 184350
489950 553666
Statement of cash flows
Operating activities
Net income (a) 114575
Increase in account receivable (b) 15685
Increase in merchandise inventory (c) 24356
Decrease in prepaid expenses (d) 725
Decrease in account payable (e) 62034
Depreciation expense (f) 21750
Loss on sale of equipment (g) 6125
Investing activities
Receipt from sale of equipment (g) 12625
Payment to purchase equipment (h) 32000
Financing activities:
Borrowed on short term note (j) 4100
Payment on long term note (k) 50625
Issued common stock for cash (l) 52000
Payment of cash dividends (m) 50300
Noncash investing and financing activities
Purchase of equipment financed by long term note payable (i)

65375

(97375-32000)

(h) 65375
608775 608775

Related Solutions

Prepare a complete statement of cash flows; report its cash flows from operating activities according to...
Prepare a complete statement of cash flows; report its cash flows from operating activities according to the direct method. Golden Corp., a merchandiser, recently completed its 2017 operations. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, (4) all debits to Accounts Payable reflect cash payments for inventory, (5) Other Expenses are all cash expenses, and (6) any change in Income...
Using the following data, prepare the operating activities section of a statement of cash flows for...
Using the following data, prepare the operating activities section of a statement of cash flows for Maximum Corporation for the year ended December 31, 20X6, using the indirect method. Increase in salary payable $1,50 Decrease in accounts payable 2,0000 Increase in accounts receivable 3,500 Net income 98,00 Decrease in inventory 5,800 Increase in prepaid expenses 1,200 Depreciation expense – equipment 5,000 Depreciation expense – building 7,500 Gain on sale of equipment 1,300 Loss on sale of patent 2,500 Question 2...
Prepare the Cash flows from operating activities section of the statement of cash flows, using the indirect method.
Demers Inc. reported the following data:ParticularsAmount$Net income490,000Depreciation expense52,000Gain on Disposal of equipment26,500Decrease in accounts receivable32,400Decrease in accounts payable12,350Prepare the cash flows from operating activities section of the statement of cash flows using the indirect method
Cemptex Corporation prepares its statement of cash flows using the indirect method to report operating activities.
Cemptex Corporation prepares its statement of cash flows using the indirect method to report operating activities. Net income for the 2021 fiscal year was $624,000. Depreciation and amortization expense of $87,000 was included with operating expenses in the income statement. The following information describes the changes in current assets and liabilities other than cash: Decrease in accounts receivable ...........$22,000Increase in inventory ..................................9,200Increase prepaid expenses ........................8,500Increase in salaries payable ....................10,000Decrease in income taxes payable ........14,000   Required:Prepare the operating activities section of the 2021 statement...
Prepare the cash flows from operating activities section of HHC’s statement of cash flows using the direct method.
The following are summary cash transactions that occurred during the year for Hilliard Healthcare Co. (HHC)ParticularsAmount$Cash received from : Customers6,60,000Interest on note receivable12,000Collection of note receivable1,00,000Sale of land40,000Issuance of common stock2,00,000Cash paid for : Interest on note payable18,000Purchase of equipment1,20,000Operating expenses4,40,000Dividends to shareholders 30,000Prepare the cash flows from operating activities section of HHC’s statement of cash flows using the direct method
Prepare the cash flows from operating activities section of HHC's statement of cash flows using the direct method.
The following are summary cash transactions that occurred during the year for Hilliard Healthcare Co. (HHC): Cash Received from: Customers ........................................................$660,000 Interest on note receivables ..........................12,000 Collection of note receivable.......................100,000 Sale of land ..........................................................40,000 Insurance of common stock..........................200,000   Cash paid for: Interest on note payable .................................18,000 Purchase of equipment .................................120,000 Operating expenses .......................................440,000 Dividends to shareholders .............................30,000   Prepare the cash flows from the operating activities section of HHC's statement of cash flows using the direct method.
Prepare the cash flows from operating activities section of Mansfield's statement of cash flows using the indirect method.
Net income of Mansfield Company was $45,000. The accounting records reveal depreciation expense of $80,000 as well as increases in prepaid rent, salaries payable, and income taxes payable of $60,000, $15,000, and $12,000, respectively. Prepare the cash flows from operating activities section of Mansfield's statement of cash flows using the indirect method.
Prepare the cash flows from operating activities section of Tiger’s 2021 statement of cash flows using the direct method.
Required:Prepare the cash flows from operating activities section of Tiger’s 2021 statement of cash flows using the direct method. Assume that all purchases and sales of inventory are on account, and that there are no anticipated bad debts for accounts receivable.   E 4–20  
Prepare a statement of cash flows for 2019, using the direct method to determine net cash flow from operating activities.
Rowe Publishing Company Balance Sheets December 31, 2019 and 2018 1 2019 2018 2 Assets 3 Current assets: 4 Cash $85,000.00 $66,000.00 5 Accounts receivable 240,000.00 231,000.00 6 Inventory 190,000.00 170,000.00 7 Total current assets $515,000.00 $467,000.00 8 Property, plant, and equipment: 9 Building $400,000.00 $400,000.00 10 Equipment 155,000.00 130,000.00 11 $555,000.00 $530,000.00 12 Accumulated depreciation (375,000.00) (350,000.00) 13 Net property, plant, and equipment 180,000.00 180,000.00 14 Total assets $695,000.00 $647,000.00 15 LIABILITIES AND EQUITY 16 Current liabilities: 17 Accounts...
Compute Cash Provided by Operating Activities Prepare a partial statement of cash flows reporting cash provided...
Compute Cash Provided by Operating Activities Prepare a partial statement of cash flows reporting cash provided by operating activities for the year ended December 31, 20-2. Use a minus to indicate any decreases in cash or cash outflows. Horn Company's condensed income statement for the year ended December 31, 20-2, was as follows: Net sales $1,203,000 Cost of goods sold 732,000 Gross profit $471,000 Operating expenses 137,000 Operating income $334,000 Other revenues and expenses:   Interest revenue $400 Interest expense (1,100)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT