Exercise 7-11 (Part Level Submission)Metlock, Inc.’s bank statement from Main Street Bank at August 31, 2017, gives the following information.Balance, August 1$18,600Bank debit memorandum:August deposits71,200Safety deposit box fee$ 50Checks cleared in August68,653Service charge75Bank credit memorandum:Balance, August 3121,092 Interest earned70A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,900; receipts $74,200; disbursements $73,545; and balance, August 31, $19,555. Analysis reveals that the only reconciling items on the July 31 bank reconciliation were a deposit in transit for $4,825 and outstanding checks of $4,525. In addition, you determine that there was an error involving a company check drawn in August: A check for $400 to a creditor on account that cleared the bank in August was journalized and posted for $40.*(a)Your answer is correct.Determine deposits in transit.Deposits in transit$7825*(b)Your answer is correct.Determine outstanding checks. (Hint: You need to correct disbursements for the check error.)Outstanding checks$9777*(c)Your answer is correct.Prepare a bank reconciliation at August 31. (List items that increase balance as per bank & books first.)METLOCK, INC.Bank ReconciliationAugust 31, 2017Cash balance per bank statement$21092Add:Deposits in transit782528917Less:Outstanding checks9,777Adjusted cash balance per bank$19140Cash balance per books$19,555Add:Interest earned7019625Less:Service charge$75Error in recording check360Safety deposit box rent50485Adjusted cash balance per books$19140*(d)Journalize the adjusting entries to be made by Metlock, Inc. at August 31. (Credit account titles are automatically indented when amount is entered. Do not indent manually.)DateAccount Titles and ExplanationDebitCreditAug. 31(To record Interest earned)Aug. 31(To correct error in recording check)Aug. 31(To record service charge and safety deposit box fee)

Excel Ch. 2 Lab Project - Capstone ExcercisSubmitting a text entry box or a file uploadIn YOUR LAB SECTION, Complete the Capstone Exercise on page 133 (page 197 of the Excel textbook). You must download (right click and select 'Save Link As...' or 'Save Target As...') the attached file called 'e02c1ClassRing.xlsm' to start the project (make sure to save it someplace that you can get to it later eg. U:/ drive). After you are done, you need to submit your completed workbook file in Blackboard. To do this, click on the "Excel Ch. 2 Lab Project - Capstone Exercise" link and then use the "Attach File" functionality to attach your file for submission. Make sure that your submitted file is named "e02c1 ClassRing _LastnameFirstname.xlsm" as specified in the instructions (subsitute your last name and first name). AFTER YOU HAVE SUBMITTED IT, check to make sure it was successfully submitted. If it was not, you can submit it again.AttachmentsCapstone2 197_1.pdfe02c1ClassRing.xlsm