Required information (The following information applies to the questions displayed below.) In this Applying Excel exercise you will practice using basic formulas to create a Statement of Cash Flows. Watch the tutorial video and then complete Parts 1 and 2 to practice and apply the skills demonstrated in the video. A B C D E F G H Glen Information la) Operating Cash Flowe Beginning cash balance 9 6 7 8 9 10 11 Cash inflows Collections from customers Sale of land Issuance of common stock Borrow from the bank Net operating cash flows Cash outflows Purchase of inventory Purchase of equipment Payment of dividende Payment of salaries Payment of advertising Purchase building (6) Investing Cash Flow Net investing cash flows 15 16 17 Ice Financing Cash Flows 19 20 21 Net financing cash flows (d) Ending Cash Balance cili the given to where calculations ta Revise your Statement of Cash Flows based on the new information provided below and then answer the questions that follow. (Note: You do not need to upload your revised worksheet for Part 2.) Beginning cash balance Collections from customers Sale of building for cash Bank borrowing Sales to customers on account Purchase of materials on account Purchase of equipment with a promissory note to pay later $ 52,400 Issuance of Common Stock for cash 202,800 Payment of office rent 93,300 Payment of dividends 51,200 Payment of salaries 165, 700 Payment of advertising expense 121,900 Purchase of equipment for cash 35,200 Payment for materials $ 14,800 42,300 12,900 52,500 27,800 18,600 233,100 Required: LAUL UUUUUAAL AAAUL V. Required information Required: 1. What is the Cash balance at the end of the year? Cash balance 2. What is the Net operating cash flows? (Negative values should be indicated with a minus sign.) Net operating cash flow 3. What is the Net investing cash flows? (Negative values should be indicated with a minus sign.) Net investing cash flow 4. What is the Net financing cash flows? (Negative values should be indicated with a minus sign.) Net financing cash flow