excel please

Required information [The following information applies to the questions displayed below] Powell Company began the Year 2 accounting period with $18,800 cash $60,300 inventory, $49,100 common stock, and $30,000 retained earnings. During Year 2. Powell experienced the following events: 1. Sold merchandise that cost $38,200 for $74,690 on account to Prentise Furniture Store 2. Delivered the goods to Prentise under terms FOB destination Freight costs were $345 cash 3. Received returned goods from Prentise. The goods cost Powell $1,830 and were sold to Prentise for $3,970 4. Granted Prentise a $1,040 allowance for damaged goods that Prentise agreed to keep 5. Collected partial payment of $52,100 cash from accounts receivable. Req ci Reg C2 Reg C3 Prepare a multistep income statement. POWELL COMPANY Income Statement For the Year Ended December 31, Year 2 0 Operating expenses $ 0 POWELL COMPANY Balance Sheet As of December 31, Year 2 Assets $ $ 0 Total assets Liabilities Stockholders' Equity Total stockholders' equity Total liabilities and stockholders' equity 0 $ EA 0 Prepare an statement of cash flows. (Cash outflows should be indicated with a minus sign.) a POWELL COMPANY Statement of Cash Flows For the Year Ended December 31, Year 2 Cash flows from operating activities: $ 0 Net cash flow from operating activities Cash flows from investing activities Cash flows from financing activities Net change in cash 0 Ending cash balance