Required information
[The following information applies to the questions displayedbelow.]
Forten Company, a merchandiser, recently completed itscalendar-year 2017 operations. For the year, (1) all sales arecredit sales, (2) all credits to Accounts Receivable reflect cashreceipts from customers, (3) all purchases of inventory are oncredit, (4) all debits to Accounts Payable reflect cash paymentsfor inventory, and (5) Other Expenses are paid in advance and areinitially debited to Prepaid Expenses. The company’s incomestatement and balance sheets follow.
FORTEN COMPANY Comparative Balance Sheets December 31, 2017 and 2016 |
| 2017 | | 2016 |
Assets | | | | | | | |
Cash | $ | 49,800 | | | $ | 73,500 | |
Accounts receivable | | 65,810 | | | | 50,625 | |
Inventory | | 275,656 | | | | 251,800 | |
Prepaid expenses | | 1,250 | | | | 1,875 | |
Total current assets | | 392,516 | | | | 377,800 | |
Equipment | | 157,500 | | | | 108,000 | |
Accum. depreciation—Equipment | | (36,625 | ) | | | (46,000 | ) |
Total assets | $ | 513,391 | | | $ | 439,800 | |
Liabilities and Equity | | | | | | | |
Accounts payable | $ | 53,141 | | | $ | 114,675 | |
Short-term notes payable | | 10,000 | | | | 6,000 | |
Total current liabilities | | 63,141 | | | | 120,675 | |
Long-term notes payable | | 65,000 | | | | 48,750 | |
Total liabilities | | 128,141 | | | | 169,425 | |
Equity | | | | | | | |
Common stock, $5 par value | | 162,750 | | | | 150,250 | |
Paid-in capital in excess of par, common stock | | 37,500 | | | | 0 | |
Retained earnings | | 185,000 | | | | 120,125 | |
Total liabilities and equity | $ | 513,391 | | | $ | 439,800 | |
|
 Â
FORTEN COMPANY Income Statement For Year Ended December 31, 2017 |
Sales | | | | $ | 582,500 | |
Cost of goods sold | | | | | 285,000 | |
Gross profit | | | | | 297,500 | |
Operating expenses | | | | | | |
Depreciation expense | $ | 20,750 | | | | |
Other expenses | | 132,400 | | | 153,150 | |
Other gains (losses) | | | | | | |
Loss on sale of equipment | | | | | (5,125 | ) |
Income before taxes | | | | | 139,225 | |
Income taxes expense | | | | | 24,250 | |
Net income | | | | $ | 114,975 | |
|
Additional Information on Year 2017Transactions
- Net income was $114,975.
- Accounts receivable increased.
- Inventory increased.
- Prepaid expenses decreased.
- Accounts payable decreased.
- Depreciation expense was $20,750.
- Sold equipment costing $46,875, with accumulated depreciationof $30,125, for $11,625 cash. This yielded a loss of $5,125.
- Purchased equipment costing $96,375 by paying $30,000 cash and(i.) by signing a long-term note payable for thebalance.
- Borrowed $4,000 cash by signing a short-term note payable.
- Paid $50,125 cash to reduce the long-term notes payable.
- Issued 2,500 shares of common stock for $20 cash pershare.
- Declared and paid cash dividends of $50,100.
 Â
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.)
FORTEN COMPANYSpreadsheet for Statement of Cash FlowsFor YearEnded December 31, 2017Analysis of ChangesDecember 31,2016DebitCreditDecember 31, 2017Balancesheet—debitCash$73,500$49,800Accountsreceivable50,625Inventory251,800Prepaidexpenses1,875Equipment108,000$485,800$49,800Balancesheet—creditAccumulated depreciation—Equipment$46,000Accountspayable114,675Short-term notes payable6,000Long-term notespayable48,750Common stock, $5 par value150,250Paid-in capital inexcess of par value, common stock0Retainedearnings120,125$485,800$0Statement of cash flowsOperatingactivitiesInvesting activities Financing activitiesNon cashinvesting and financing activitiesPurchase of equipment financed bylong-term note payable$0$0