CCOUNTING Bank Statement SOCIETY Wells Fargo Bank Page 1 PO Box 12345 El Paso, Texas 79998-2345 Evy's Electric Bikes 123 Main Avenue El Paso, Texas 79945 WELLS FARGO BANK STATEMENT Evy's Electric Bikes Balance, beginning Deposits and other credits Checks and other debits Balance on statement date 01/01/2022 January January 01/31/2022 $0.00 $112,908 $36,545 $76,363 Deposits Added 1/2/2022 Deposit 1 $70,000 1/5/2022 Deposit 2 $10,000 1/20/2022 Deposit 3 $12,124 1/23/2022 Deposit 4 $12,557 1/28/2022 Deposit 5 $8,227 Wells Fargo Bank Statement - Checks Paid and other Debts 1001 $9,000 1007 $490 1002 $4,000 1008 $250 1003 $1,100 1009 $200 1004 $14,000 1011 $6,000 1005 $750 DM $70 Check Printing Fee 1006 $450 DM $235 American Express for Gas *Assume any errors are made by the bank 15 Page ACCOUNTING Society Part Five Instructions Before preparing the Financial Statements make sure all the assignments have been corrected in your spreadsheets. Prepare the Financial Statements listed below using Excel. a. Adjusted Trial Balance b. Income Statement c. Statement of Retained Earnings d. Balance Sheet Once you finish the Financial Statements follow the instructions below: Step 1: Take the corrected balances in each account and prepare the Financial Statements listed above. Once completed print out the Financial Statements. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder for the corresponding week. Step 3: Once you complete entering all the information into Blackboard, upload the Financial Statements into Blackboard