EXCEL Assignment # 04 Saved 1 Required information (The following information applies to the questions displayed below.) 5 points In this Applying Excel exercise you will practice using cell referencing and formulas to create a bank reconciliation. Watch the tutorial video and then complete Parts 1 and 2 to practice and apply the skills demonstrated in the video. X 01:45:39 we eBook www Print References Revise your worksheet to reflect the following transactions and updated values at the end of the accounting period, then answer the questions that follow. (Note: You do not need to upload your revised worksheet for Part 2.) 1 Cash on hand at the company and not yet deposited at the bank. 2 EFT for monthly utility bill not yet recorded by the company. 3 Note collected by the bank and not yet recorded by the company. Interest collected by the bank from note in #3 not yet recorded by the company. 5 A check witten for insurance expense for $80 was cashed. The check was recorded on the books for $140. Checks written by the company but not yet processed by the bank. 7 Service fee charged by bank but not yet recorded by the company. 8 Customer checks determined by the bank to have nonsufficient funds. 5,100 1,600 9,600 1,400 2 2,700 100 3,100 Bank balance at the end of the period. Company balance at the end of the period. 17,680 13,820 Required: 1-a. What is the revised Cash balance at the end of the period? Cash 2-a. What is the balance in Cash if the entry to correct the insurance payment hasn't been made? Cash