elected financial statement information and additional data for Doble Siete Inc. is presented below. statement of cash flows for the year ending December 31, 2012

December 31

20112012

Cash..........................................................$42,000$75,000

Accounts receivable(net)...........................84,000144,200

Inventory..................................................168,000201,600

Land..........................................................58,80016,000

Equipment.................................................504,000789,600

TOTAL............................................$856,800$1,226,400

Accumulateddepreciation..........................$84,000$115,600

Accountspayable.......................................50,40086,000

Notes payable -Short-term........................67,20029,400

Notes payable -Long-term.........................168,000302,400

Commonstock...........................................420,000487,200

Retainedearnings......................................67,200205,800

TOTAL............................................$856,800$1,226,400

Additional data for 2012:

1.Net income was $240,200.

2.Depreciation was $31,600.

3.Land was sold at its original cost.

4.Dividends of $101,600 were paid.

5.Equipment was purchased for $84,000 cash.

6.A long-term note for $201,600 was used to pay for an equipment purchase.

7.Common stock was issued to pay a $67,200 long-term note payable.

Required:

Prepare Cash Flow (Indirect Method) in Excel format.