^Please format in the same style as the above workbook and provide equations^

The bookkeeper at Jefferson Company has not reconciled the bank statement with the Cash account, saying, I don't have time. You have been asked to prepare a reconciliation and review the procedures with the bookkeeper. The February 28, current year, bank statement and the February t-account for Cash showed the following (summarized): BANK STATEMENT Checks Deposits Balance, Feb 1, current year Deposits during Feb $47,100 Interest collected 2,440 Checks cleared during Feb $51,000 NSF checkA. B. Wright 310 Bank service charges 50 Balance, Feb 28, current year Balance $31,000 78,100 80,540 29,540 29,230 29,180 29,180 Beginning Balance Cash 21,000 Checks written 49,500 Deposits 52,700 A comparison of checks written before and during February with the checks cleared through the bank showed outstanding checks at the end of February of $8,500 (including $3,700 written before and $4,800 written during February). No deposits in transit were carried over from January, but a deposit was in transit at the end of February. (hint: it would be the difference between the $52,700 that the firm recorded as increases to cash during February less the $47,100 amount that the bank indicated as the total deposits in February). Required: 1. Prepare a detailed bank reconciliation for the month of February. See page 310, exhibit 6.5 for an example. There is an Excel workbook set up that you can use. Be sure to use the power of Excel to perform any and all calculations. 2. Give any required adjusting journal entries as a result of the reconciliation. 3. What total amount of cash should be reported on the balance sheet at the end of February? A26 f A B D Bank Reconciliation for the Month of February Bank Statement 1 2 Company's Books Ending Cash Balance per books 3 before reconciliation 4 5 6 Add: Ending Cash balance per bank statement Add: 7 8 9 10 11 Deduct: 12 Deduct: 13 14 15 Ending Correct Cash Balance 16 17 Ending Correct Cash Balance 18 19 20 21 22 23 24