Questions: Forten Company's current year Income statement, comparative balance sheets, and additional information follow. 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, and (4) all debits to Accounts Payable reflect cash payments for Inventory. Assets Cash 69,400 86,500 Accounts receivable 85,400 63,625 Inventory 295,156 264,800 Prepaid expenses 1,340 2,155 Total current assets 451,296 417,080 Equipment 144,500 121,000 Accumulated depreciation-Equipment (43,125) (52,500) Total assets 52,671 485,580 Liabilities and Equity Accounts payable 66,141 134,175 Long-term notes payable 72,400 70,350 Total liabilities 138,541 204,525 Equity Common stock, 5 par value Paid-in capital in excess of par, common stock 182,250 163,250 Paid-in capital in excess of par, common stock 174,880 117,805 Total liabilities and equity 552,671 485,580 Additional Information on Current Year Transactions a. The loss on the cash sale of equipment was 18,125 (details in b). b. Sold equipment costing 85,875, with accumulated depreciation of 43,125, for 24,625 cash. c. Purchased equipment costing 109,375 by paying 56,000 cash and signing a long-term notes payable for the balance. d. Paid 51,325 cash to reduce the long-term notes payable. e. Issued 3,800 shares of common stock for 20 cash per share. f. Declared and paid cash dividends of 52,700. Required: Prepare a complete statement of cash flows using a spreadsheet using the indirect method.

Forten Company's current year Income statement, comparative balance sheets, and additional information follow. 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, and
(4) all debits to Accounts Payable reflect cash payments for Inventory.

Assets
Cash 69,400 86,500
Accounts receivable 85,400 63,625
Inventory 295,156 264,800
Prepaid expenses 1,340 2,155
Total current assets 451,296 417,080
Equipment 144,500 121,000
Accumulated depreciation-Equipment (43,125) (52,500)
Total assets 52,671 485,580
Liabilities and Equity
Accounts payable 66,141 134,175
Long-term notes payable 72,400 70,350
Total liabilities 138,541 204,525
Equity
Common stock, 5 par value
Paid-in capital in excess of par, common stock 182,250 163,250
Paid-in capital in excess of par, common stock 174,880 117,805
Total liabilities and equity 552,671 485,580

Additional Information on Current Year Transactions
a. The loss on the cash sale of equipment was 18,125 (details in b).
b. Sold equipment costing 85,875, with accumulated depreciation of 43,125, for 24,625 cash.
c. Purchased equipment costing 109,375 by paying 56,000 cash and signing a long-term notes payable for the balance.
d. Paid 51,325 cash to reduce the long-term notes payable.
e. Issued 3,800 shares of common stock for 20 cash per share.
f. Declared and paid cash dividends of 52,700.

Required:
Prepare a complete statement of cash flows using a spreadsheet using the indirect method.
Transcript text: Forten Company's current year Income statement, comparative balance sheets, and additional information follow. 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, and (4) all debits to Accounts Payable reflect cash payments for Inventory. Assets Cash $69,400 $86,500 Accounts receivable $85,400 $63,625 Inventory $295,156 $264,800 Prepaid expenses $1,340 $2,155 Total current assets $451,296 $417,080 Equipment $144,500 $121,000 Accumulated depreciation-Equipment $(43,125)$ $(52,500)$ Total assets $$52,671 $485,580 Liabilities and Equity Accounts payable $66,141 $134,175 Long-term notes payable $72,400 $70,350 Total liabilities $138,541 $204,525 Equity Common stock, $5 par value Paid-in capital in excess of par, common stock $182,250 $163,250 Paid-in capital in excess of par, common stock $174,880 $117,805 Total liabilities and equity $552,671 $485,580 Additional Information on Current Year Transactions a. The loss on the cash sale of equipment was $18,125 (details in b). b. Sold equipment costing $85,875, with accumulated depreciation of $43,125, for $24,625 cash. c. Purchased equipment costing $109,375 by paying $56,000 cash and signing a long-term notes payable for the balance. d. Paid $51,325 cash to reduce the long-term notes payable. e. Issued 3,800 shares of common stock for $20 cash per share. f. Declared and paid cash dividends of $52,700. Required: Prepare a complete statement of cash flows using a spreadsheet using the indirect method.
failed

Solution

failed
failed

To prepare a complete statement of cash flows using the indirect method, we need to follow these steps:

  1. Operating Activities: Start with net income and adjust for changes in working capital accounts and non-cash items.
  2. Investing Activities: Include cash flows from the purchase and sale of equipment.
  3. Financing Activities: Include cash flows from issuing stock, paying dividends, and changes in long-term debt.
Step-by-Step Solution:
1. Operating Activities

Start with net income and adjust for non-cash items and changes in working capital.

Net Income: Not provided directly, but we can infer it from changes in equity and other transactions.

Adjustments for non-cash items:

  • Depreciation: \( \$ 52,500 - \$ 43,125 = \$ 9,375 \)
  • Loss on sale of equipment: \( \$ 18,125 \)

Changes in working capital:

  • Increase in Accounts Receivable: \( \$ 85,400 - \$ 63,625 = \$ 21,775 \) (decrease cash)
  • Increase in Inventory: \( \$ 295,156 - \$ 264,800 = \$ 30,356 \) (decrease cash)
  • Decrease in Prepaid Expenses: \( \$ 2,155 - \$ 1,340 = \$ 815 \) (increase cash)
  • Decrease in Accounts Payable: \( \$ 134,175 - \$ 66,141 = \$ 68,034 \) (decrease cash)
2. Investing Activities

Include cash flows from the purchase and sale of equipment.

  • Sale of equipment: \( \$ 24,625 \)
  • Purchase of equipment: \( \$ 56,000 \)
3. Financing Activities

Include cash flows from issuing stock, paying dividends, and changes in long-term debt.

  • Issued common stock: \( 3,800 \times \$ 20 = \$ 76,000 \)
  • Paid dividends: \( \$ 52,700 \)
  • Paid long-term notes payable: \( \$ 51,325 \)
  • New long-term notes payable: \( \$ 109,375 - \$ 56,000 = \$ 53,375 \)
Statement of Cash Flows (Indirect Method)

Cash Flows from Operating Activities: \[ \begin{align_} Net Income & \quad \text{(to be calculated)} \\ Adjustments to reconcile net income to net cash provided by operating activities: \\ Depreciation & \quad \$ 9,375 \\ Loss on sale of equipment & \quad \$ 18,125 \\ Changes in working capital: \\ Increase in Accounts Receivable & \quad (\$ 21,775) \\ Increase in Inventory & \quad (\$ 30,356) \\ Decrease in Prepaid Expenses & \quad \$ 815 \\ Decrease in Accounts Payable & \quad (\$ 68,034) \\ Net cash provided by operating activities & \quad \text{(to be calculated)} \\ \end{align_} \]

Cash Flows from Investing Activities: \[ \begin{align_} Proceeds from sale of equipment & \quad \$ 24,625 \\ Purchase of equipment & \quad (\$ 56,000) \\ Net cash used in investing activities & \quad (\$ 31,375) \\ \end{align_} \]

Cash Flows from Financing Activities: \[ \begin{align_} Proceeds from issuance of common stock & \quad \$ 76,000 \\ Payment of dividends & \quad (\$ 52,700) \\ Payment of long-term notes payable & \quad (\$ 51,325) \\ Proceeds from new long-term notes payable & \quad \$ 53,375 \\ Net cash provided by financing activities & \quad \$ 25,350 \\ \end{align_} \]

Net Increase (Decrease) in Cash: \[ \begin{align_} Net cash provided by operating activities & \quad \text{(to be calculated)} \\ Net cash used in investing activities & \quad (\$ 31,375) \\ Net cash provided by financing activities & \quad \$ 25,350 \\ Net increase (decrease) in cash & \quad \text{(to be calculated)} \\ \end{align_} \]

Cash at Beginning of Year: \[ \begin{align_} Cash at beginning of year & \quad \$ 86,500 \\ \end{align_} \]

Cash at End of Year: \[ \begin{align_} Cash at end of year & \quad \$ 69,400 \\ \end{align_} \]

Calculation of Net Income:

To find the net income, we need to consider the changes in equity and other transactions: \[ \begin{align_} Ending Equity & = Beginning Equity + Net Income + Issuance of Stock - Dividends \\ \text{Ending Equity} & = \$ 414,130 \\ \text{Beginning Equity} & = \$ 281,055 \\ \text{Issuance of Stock} & = \$ 76,000 \\ \text{Dividends} & = \$ 52,700 \\ \text{Net Income} & = Ending Equity - Beginning Equity - Issuance of Stock + Dividends \\ \text{Net Income} & = \$ 414,130 - \$ 281,055 - \$ 76,000 + \$ 52,700 \\ \text{Net Income} & = \$ 109,775 \\ \end{align_} \]

Final Statement of Cash Flows:

Cash Flows from Operating Activities: \[ \begin{align_} Net Income & \quad \$ 109,775 \\ Adjustments to reconcile net income to net cash provided by operating activities: \\ Depreciation & \quad \$ 9,375 \\ Loss on sale of equipment & \quad \$ 18,125 \\ Changes in working capital: \\ Increase in Accounts Receivable & \quad (\$ 21,775) \\ Increase in Inventory & \quad (\$ 30,356) \\ Decrease in Prepaid Expenses & \quad \$ 815 \\ Decrease in Accounts Payable & \quad (\$ 68,034) \\ Net cash provided by operating activities & \quad \$ 17,925 \\ \end{align_} \]

Cash Flows from Investing Activities: \[ \begin{align_} Proceeds from sale of equipment & \quad \$ 24,625 \\ Purchase of equipment & \quad (\$ 56,000) \\ Net cash used in investing activities & \quad (\$ 31,375) \\ \end{align_} \]

Cash Flows from Financing Activities: \[ \begin{align_} Proceeds from issuance of common stock & \quad \$ 76,000 \\ Payment of dividends & \quad (\$ 52,700) \\ Payment of long-term notes payable & \quad (\$ 51,325) \\ Proceeds from new long-term notes payable & \quad \$ 53,375 \\ Net cash provided by financing activities & \quad \$ 25,350 \\ \end{align_} \]

Net Increase (Decrease) in Cash: \[ \begin{align_} Net cash provided by operating activities & \quad \$ 17,925 \\ Net cash used in investing activities & \quad (\$ 31,375) \\ Net cash provided by financing activities & \quad \$ 25,350 \\ Net increase (decrease) in cash & \quad \$ 11,900 \\ \end{align_} \]

Cash at Beginning of Year: \[ \begin{align_} Cash at beginning of year & \quad \$ 86,500 \\ \end{align_} \]

Cash at End of Year: \[ \begin{align_} Cash at end of year & \quad \$ 69,400 \\ \end{align_} \]

This completes the statement of cash flows for Forten Company using the indirect method.

Was this solution helpful?
failed
Unhelpful
failed
Helpful