image image image image image image

(Solved) Golden Corporation’s statement of cash flows using a spreadsheet

Golden Corporation’s current year income statement, comparative balance sheets, and additional information follow. For the year,

  1. (1) all sales are credit sales,
  2. (2) all credits to Accounts Receivable reflect cash receipts from customers,
  3. (3) all purchases of inventory are on credit,
  4. (4) all debits to Accounts Payable reflect cash payments for inventory, and
  5. (5) any change in Income Taxes Payable reflects the accrual and cash payment of taxes.
GOLDEN CORPORATION
Comparative Balance Sheets
December 31
 Current YearPrior Year
Assets  
Cash$ 177,000$ 121,300
Accounts receivable102,50084,000
Inventory620,500539,000
Total current assets900,000744,300
Equipment370,000312,000
Accumulated depreciation—Equipment(164,500)(110,500)
Total assets$ 1,105,500$ 945,800
Liabilities and Equity  
Accounts payable$ 113,000$ 84,000
Income taxes payable41,00031,600
Total current liabilities154,000115,600
Equity  
Common stock, $2 par value607,600581,000
Paid-in capital in excess of par value, common stock219,400179,500
Retained earnings124,50069,700
Total liabilities and equity$ 1,105,500$ 945,800
GOLDEN CORPORATION
Income Statement
For Current Year Ended December 31
Sales$ 1,857,000
Cost of goods sold1,099,000
Gross profit758,000
Operating expenses (excluding depreciation)507,000
Depreciation expense54,000
Income before taxes197,000
Income taxes expense40,200
Net income$ 156,800

Additional Information on Current Year Transactions

  1. Purchased equipment for $58,000 cash.
  2. Issued 13,300 shares of common stock for $5 cash per share.
  3. Declared and paid $102,000 in cash dividends.

Required:

Prepare a complete statement of cash flows using a spreadsheet under the indirect method.

Note: Enter all amounts as positive values.

Solution – Golden Corporation’s statement of cash flows using a spreadsheet

error: Content is protected !!