Can someone do this in excel so it is easy to follow.

CASH FLOW PROBLEM TRANSACTIONS 1 Walden Corporation issued 100,000 shares of $4.00 par value common stock at par. CASH ACCOUNTS PAYABLE COMMON STOCK RETAINED EARNINGS 1 O 3 Waldon purchased equipment in the amount of $38,000, paying cash. F EXPENSES SERVICE REVENUE 4 Walden earned revenue of $80,000, receiving $15,000 in cash, and the rest $65,000 on account. ACCOUNTS RECEIVABLE 5 Walden incurred expenses of $40,000, paying $22,000 in cash and the rest, $18,000, on account. DEPRECIATION EXPENSE GAIN ON DISPOSAL 7 Walden recorded depreciation on the equipment in the amount of $4,200. EQUIPMENT ACCUM. DEPR. EQUIP. 8 The accounts were closed: SERVICE REVENUE XXX EXPENSES XXX DEPRECIATION EXPENSE XXX RETAINED EARNINGS XXX LAND 9 Walden Corp declared and paid a cash dividend of $5,000. DEBIT CREDIT CASH CASH FLOW STATEMENT--INDIRECT METHOD--OBSERVE SIGNS NET INCOME + DEPRECIATION EXPENSE ACCOUNTS RECEIVABLE LAND -INCREASE IN ACCOUNTS RECEIVABLE +INCREASE IN ACCOUNTS PAYABLE =CASH FLOW FROM OPERATIONS 0 Automated sum EQUIPMENT ACCUM. DEPR EQUIP. ACCOUNTS PAYABLE COMMON STOCK RETAINED EARNINGS -PURCHASE OF EQUIPMENT = CASH FLOW FROM INVESTING 0 Automated sum SERVICE REVENUE EXPENSES DEPRECIATION EXPENSE GAIN ON DISPOSAL TOTALS +ISSUANCE OF COMMON STOCK -PAYMENT OF DIVIDEND =CASH FLOW FROM FINANCING 0 0 0 Automated sum NET CASH FLOW 0 Automated sum The trial balance is generated automatically from the T-accounts. 0 +BEGINNING BALANCE OF CASH =ENDING BALANCE OF CASH 0 Automated sum. HINT: THIS FIGURE MUST MATCH YOUR CASH BALANCE