. . . EA5-E3 Complete a Bank Reconciliation for Pond Maintenance Corp. In this exercise, you will complete a bank reconciliation as of 12/31/2016 for Pond Maintenance Corp. One of your primary goals is to ensure that the file can be easily under- stood by the end user. Use this information to populate the reconciliation: Deposits in Transit: $10,100 and $1,000 NSF Check: $7,150 Notes Receivable: $7,000 Outstanding Checks: $3,100 and $600 Bank Charges: $1,100 The bank erroneously deposited a $250 check written to TreeSky Industries into the bank account of Pond Maintenance Corp. The bank statement reflects a 12/31/16 balance of $94,200, while the company's general ledger reflects a 12/31/16 cash balance of $102,600. Modify the appearance of the reconciliation using Format Painter and Quick Styles. Set a conditional formatting rule that will highlight the bank balance if it exceeds $90,000. Apply a header that displays the filename and file path and a footer that displays the current time. Ensure that all column widths, row heights, and font sizes are appropriately adjusted