Please assist.

*See attached excel workbook for problem details and additional information

Question: Use the adjusted trail balance, statement of retained earnings, multistep income statement, comparative Balance Sheets and the following additional information to prepare the Statement of Cash Flows for the month of January 2015. Use the indirect method to prepare the operating activities section.

I. Issued 10,000 new shares of common stock when the stock was selling on the market at an average price of $10 per share on the date of sale and the par value of the stock was 50 cents.

II.Purchased land with a cost $200,000. A down payment was made in the amount of $100,000 cash and a 10% 5-year note payable was signed for the difference.

III.Purchased additional store equipment for $20,000 paying cash.

IV. The $15,000 notes receivable was related to the sale of merchandise inventory to a credit customer this period.

V. Issued bonds with a face amount of $150,000 at 97.

VI. Paid off the mortgage payable of $175,000.

VII.The company repurchased 20,000 shares of its common stock on the open market for $9 per share.

VIII.The company reissued 10,000 of the treasury shares at a price of $18 per share.

IX.Issued 1,500 shares of preferred stock at $105 per share.

X.Paid cash dividends of $35,000 to preferred and common stockholders

\fQuestion: Use\tthe\tComparative\tBalance\tSheet\ton\tpage\t2\tand\tthe\tfollowing\tadditional\tinformation\tto\tprepare\tthe Statement\tof\tCash\tFlows\tfor\tthe\tmonth\tof\tJanuary\t2015. Use\tthe\tindirect\tmethod\tto\tprepare\tthe\toperating\tactivities\tsection. I. II. III. IV. V. VI. VII. VIII. IX. X. Issued\t10,000\tnew\tshares\tof\tcommon\tstock\twhen\tthe\tstock\twas\tselling\ton\tthe\tmarket\tat\tan average\tprice\tof\t$10\tper\tshare\ton\tthe\tdate\tof\tsale\tand\tthe\tpar\tvalue\tof\tthe\tstock\twas\t50\tcents. Purchased\tland\twith\ta\tcost\t$200,000. A\tdown\tpayment\twas\tmade\tin\tthe\tamount\tof\t$100,000 cash\tand\ta\t10%\t5-year\tnote\tpayable\twas\tsigned\tfor\tthe\tdifference. Purchased\tadditional\tstore\tequipment\tfor\t$20,000\tpaying\tcash. The\t$15,000\tnotes\treceivable\twas\trelated\tto\tthe\tsale\tof\tmerchandise\tinventory\tto\ta\tcredit customer\tthis\tperiod. Hint: The\tincrease\tin\tnotes\treceivable\tshould\tbe\treported\tas\tan\taddition to\tthe\toperating\tactivities\tsection\tof\tthe\tstatement\tof\tcash\tflows. Issued\tbonds\twith\ta\tface\tamount\tof\t$150,000\tat\t97. Hint: The\tamortization\tof\tthe\tbond discount\tin\tthe\tamount\tof\t$450\tshould\tbe\treported\tas\tan\taddition\tto\tthe\toperating\tactivities section. Paid\toff\tthe\tmortgage\tpayable\tof\t$175,000. The\tcompany\trepurchased\t20,000\tshares\tof\tits\tcommon\tstock\ton\tthe\topen\tmarket\tfor\t$9\tper share. The\tcompany\treissued\t10,000\tof\tthe\ttreasury\tshares\tat\ta\tprice\tof\t$18\tper\tshare. Issued\t1,500\tshares\tof\tpreferred\tstock\tat\t$105\tper\tshare. Paid\tcash\tdividends\tof\t$35,000\tto\tpreferred\tand\tcommon\tstockholders