Required: 1. Prepare a complete statement of cash flows using a spreadsheet.
2.Prepare a complete statement of cash flows; report its operating activities according to the direct method.
Please show all the calculations work! Thank you for your help!
Cash flow direct method | |||
Sales | 632500 | ||
Adjustments to a cash basis | |||
Accounts receivable as per 2016 | 60625 | ||
Accounts receivable as per 2017 | -80870 | 612255 | |
Less | Cost of goods sold | 295000 | |
Adjustments to a cash basis | |||
Inventory as per 2016 | -261800 | ||
Inventory as per 2017 | 290656 | ||
Accounts payable as per 2016 | 129675 | ||
Accounts payable as per 2017 | -63141 | 390390 | |
Operating expense less depreciation and amortization | 142400 | ||
Adjustments to a cash basis | |||
Prepaid expense 2016 | -2095 | ||
Prepaid expense 2017 | 1310 | ||
short term payable 2016 | 8000 | ||
Short term payable 2017 | -13000 | 136615 | |
Income tax expense | 38250 | ||
Cash flow from operating activities | 47000 |
Cash flow statement | |||
Cash flow from operating activities | 47000 | ||
Cash flow from Investing activities | |||
Long term investment sold | |||
Equipment purchased | -50000 | ||
Land purchased | |||
Equipment sold | 21625 | -28375 | |
Cash flow from Financing activities | |||
Issue of common stock | 22500 | ||
Paid in capital inexcess | 47500 | ||
Dividend paid | -52100 | ||
Long term loan payable | -55125 | ||
-37225 | |||
Net Cash and cash equivalent | -18600 | ||
Add | Beginning cash and cash equivalent | 83500 | |
Ending cash and cash equivalent | 64900 |
Required: 1. Prepare a complete statement of cash flows using a spreadsheet. 2.Prepare a complete statement...
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)...
Required information [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...
Help Save & Exit Submit Check my work Required information [The following information applies to the questions displayed below.) Forten Company's current year income statement, comparative balance sheets, and additional information follow. For the year, () 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...
I need help with the cash flow spreadsheet for the debit and credit changes. Thank you. Use the following information for the Problems 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...
Required information 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 paid Expenses. The company s income statement...
Additional Information on Year 2017 Transactions a. The loss on the cash sale of equipment was $5,125 (details in b). b. Sold equipment costing $46.875, with accumulated depreciation of $30.125, for $11.625 cash. c. Purchased equipment costing S96.375 by paying S30.000 cash and signing a long-term note payable for the balance. d. Borrowed $4,000 cash by signing a short-term note payable .Paid $50.125 cash to reduce the long-term notes payable f. Issued 2,500 shares of common stock for $20 cash...
Required information (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...
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):...
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...
FORTEN COMPANY Comparative Balance Sheets December 31 Current Year Prior Year Assets Cash $ 72,400 $ 88,500 Accounts receivable 88,420 65,625 Inventory 298,156 266,800 Prepaid expenses 1,360 2,195 Total current assets 460,336 423,120 Equipment 142,500 123,000 Accum. depreciation—Equipment (44,125 ) (53,500 ) Total assets $ 558,711 $ 492,620 Liabilities and Equity Accounts payable $ 68,141 $ 137,175 Short-term notes payable 14,500 9,000 Total current liabilities 82,641 146,175 Long-term notes payable 57,500 63,750 Total liabilities 140,141 209,925 Equity Common stock, $5...