For part 4 i need solving

Part Four Instructions In this part of the practice set, the student will prepare a Bank Reconciliation for the month of January. Prepare it in Excel and use the ending balance in your cash account for the ending cash for your books. Be prepared to turn in the Bank Reconciliation after answering the questions in Blackboard. Requirements 1. Make sure you have corrected any errors on your journal and adjusting journal entries and have the correct balance for the cash account in your T-Account before starting the Bank Reconciliation. Please use the correct balance in the cash account to start on the book side of the reconciliation. 2. Bank Reconciliation: Using the cash balance per books and the bank statement, prepare a bank reconciliation. A template you can use to create a Bank Reconciliation is located on the following page. 3. Record Bank Reconciliation Adjustments: After you have prepared the bank reconciliation you must make any adiusting journal entries to your cash account by entering them in the general journal of the practice set so that the general ledger cash account agrees with the Bank Reconciliation. Once you finish the Bank Reconciliation follow the instructions below: tep 1: Use the template on the next page to create an Excel spreadsheet to show the econciled balance using the Bank Statement and the correct ending balance in the cash ccount. Once the bank reconciliation is completed, print it out. tep 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder or the corresponding week. ep 3: Once you complete entering all the information into Blackboard, upload the Bank part one. The following are the have been made to any of the previous journal enties in Record all adjusting entries as of Jasting ioumalentries for the month of January. Record Adjusting Entries: Record the following montin ond aojusting entries for the month of January. Write the joumal entrios in the proctice set atter the original journal: entries. Round all answers to the noarest cent. e. $70 of offlice supples remalred on hand. b. $200 of shipping supples remained ori hand. c. $1.300 of wages for the part-time help trom trene's Temp Services for January should be occrued. Do not wory obout payroll taxes: Temp Services Inc, will handle there. . Make the necessary adjusting entries for orie month's depreciation for the Computer Equipment using Straight Line Depreciation. e. Make the necessary adjusting entry for one month's depreciation for the fumiture and fixlures using Straight tine Depreciation. f. One month of the prepaid irsurance has expired 33.33 g. One month of the prepaid rent has expired. h. Record the interest for the logn from Wells Fargo tor one month ake sure you prepare the adjusting entries and write them in the template for the Ljusting entries. Follow the same instructions for the adjusting joumal entries that you d in part one. Once the adjusting entries have been completed in the spreadsheet the spreadsheet to answer the questionis in Blockboard then vpload the eadsheet to Blackboard. Follow these instructions. p 1: Enter the adjusting journal entries in an Excel spreadsheet and print it out. 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder he corresponding week. 3: Once you complete entering information into Blackboard upload the spreadsheet into kboard. Template T.Accounts Bank Statement Wells Fargo Bank page 1 PO Box 12345 El Paso, Texas 79998-2345 Hit the Slopes 123 Main Avenue El Paso, Texas 79945 WELLS FARGO BANK STATEMENT "Hit the Slopes" Assume any errors are made by the bank