All the information is provided on here there is nothing else included in this problem!!!!! Must be done as an Excel worksheet or similar. You can screen shot it or write it.....

EAS-R1 Create a Bank Reconciliation for Auto Salvage Co. In this exercise, you will create a bank reconciliation for Auto Salvage Co. for the month ended December 31, 2016. The reconciliation will be partly based on these figures: Bank Statement Balance (12/31/2016) equals $17,000; Notes Receivable equals $1,300; NSF Check equals $1,200; Bank Charges equals $610. During the month, the company erroneously recorded a check written by Auto Salvage Co. as $600 instead of the actual amount of $400 1. Open a Blank Workbook and save the file in your Chapter 05 folder as: EA5-R1-BankRec-[YourName] 2. Enter this data and apply bold formatting to all three cells: Cell A1 Cell A2 Cell A3 Auto Salvage Co. Bank Reconciliation December 31, 2016 3. Highlight the range A1:G3, choose Home->Alignment->Merge and Center Merge Across, and center-align the content. 4. Enter this data: Cell A5 Cell E5 Cells A6 and E6 Cells A9 and E9 Beginning Bank Balance: Beginning Book Balance: Add: Deduct