2 IE 04-01 (Static) Using Excel to Prepare a Bank Reconciliation [LO4-5] A company provides the following information related to its ending cash balance. 1 Cash on hand at the company and not yet deposited at the bank $4,500 5 2 EFT for monthly utility bill not yet recorded by the company 1,400 points 3 Note collected by the bank and not yet recorded by the company 9,000 4 Interest collected by the bank from note in #3 not yet recorded by the company 600 5 Debit card used to purchase supplies not yet recorded by the company 500 6 Checks written by the company but not yet processed by the bank 1,900 100 2,200 eBook References 7 Service fee charged by bank but not yet recorded by the company 8 Customer checks determined by the bank to have nonsufficient funds Bank balance at the end of the period Company balance at the end of the period Required: 1. Complete the bank reconciliation in the spreadsheet. $16,200 13,400 2. Use a conditional statement to evaluate whether the reconciled balances are equal. 3. Prepare necessary journal entries to update the Cash account. a. Prepare a journal entry for items that increased the Cash account. b. Prepare a journal entry for items that decreased the Cash account. 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect