Provide Answers In Excel

Part 2. Preparing a Bank Reconciliation Prepare a bank reconciliation for the Purple Company as of December 31, 2023. Use the format shown in Example 6A.1 at the top of page 6-41 (this is in Appendix 6A) of our textbook. The heading should contain the name of Purple Company's Bank: Main Street Bank. The data you will need is as follows: Balance per bank statement as of December 31, 2023 Deposits in transit as of December 31, 2023 Outstanding checks as of December 31, 2023 Correct Cash Balance as of December 31, 2023 Balance per Books as of December 31, 2023 Interest collected by the bank in December, 2023 but not recorded in Purple's books as of December 31, 2023 A "Not Sufficient Funds" (i.e. NSF) check was recorded by the bank in December, 2023 but not recorded in Purple's books as of December 31, 2023 $82,465 $9,775 $16,170 $76,070 $75,795 $600 \$ 325