please answer the question as clear as possible. also if you can use excel. thank you

1 2 TRANSACTIONS 1 Walden Corporation issued 100,000 shares of $4.00 par value common stock at par. . ALT-EZ-CASH FLOW 3 4 5 6 CASH ACCOUNTS PAYABLE COMMON STOCK RETAINED EARNINGS 2 Walden purchased Land in the amount of $20,000, paying cash. F 1 7 8 0 3 Waldon purchased equipment in the amount of $38,000, paying cash. 9 1 0 F 10 11 12 EXPENSES SERVICE REVENUE 4 Walden earned revenue of $80,000, receiving $15,000 in cash, and the rest $65,000 on account. ACCOUNTS RECEIVABLE 13 14 15 16 HH 5 Walden incurred expenses of $40,000, paying $22,000 in cash and the rest, $18,000, on account. DEPRECIATION EXPENSE GAIN ON DISPOSAL 17 6 Walden sold 1/4 of the land for $8,000, making again on disposal. 18 19 LAND 20 20 21 22 7 Walden recorded depreciation on the equipment in the amount of $4,200. EQUIPMENT ACCUM. DEPR. EQUIP. 23 24 24 25 26 27 8 The accounts were closed: SERVICE REVENUE XXX GAIN ON DISPOSAL XXX EXPENSES XXX DEPRECIATION EXPENSE XXX RETAINED EARNINGS XXX DEBIT CREDIT 9 Walden Corp declared and paid a cash dividend of $5,000. 29 28 29 30 5H 31 COUNTS RECEIVABLE 32 ND 33 UIPMENT 34 CUM. DEPR EQUIP. 35 COUNTS PAYABLE 36 MMON STOCK 37 TAINED EARNINGS 38 VICE REVENUE 39 PENSES 40 PRECIATION EXPENSE 41 IN ON DISPOSAL 42 TALS CASH FLOW STATEMENT-INDIRECT METHOD-OBSERVE SIGNS NET INCOME + DEPRECIATION EXPENSE -INCREASE IN ACCOUNTS RECEIVABLE +INCREASE IN ACCOUNTS PAYABLE GAIN ON DISPOSAL CASH FLOW FROM OPERATIONS 0 Automated sum -PURCHASE OF EQUIPMENT -PURCHASE OF LAND +SALE OF LAND = CASH FLOW FROM INVESTING 0 Automated sum 0 +ISSUANCE OF COMMON STOCK