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