Excel McGraw Hill Excel Question - Saved File Home Insert Draw Formulas Data Review View Help Editing Calibri 11 A A B I U A ab Align v Wrap Me A1 A 1 fx Accessibility tab summary: General financial information about Wright Company is presented in rows 2 to 12. A statement for requirement is pr B C E F G H KL D 2 Wright Company's cash account shows a $27,500 debit balance and its bank statement shows $25,800 on deposit at the close of business on May 31. 3 $27,500 $25,800 4 5 6 a. The May 31 bank statement lists $100 in bank service charges; the company has not yet recorded the cost of these services. 100 7 b. Outstanding checks as of May 31 total $5,600. 5,600 8 c. May 31 cash receipts of $6,200 were placed in the bank's night depository after banking hours and were not recorded 9 on the May 31 bank statement. 6,200 d. In reviewing the bank statement, a $400 check written by Smith Company was mistakenly drawn against Wright's 10 account. 11 400 12 e. The bank statement shows a $600 NSF check from a customer; the company has not yet recorded this NSF check. 600 13 14 Required: 15 Prepare its bank reconciliation using the above information. 16 17 (Use cells A2 to 112 from the given information to complete this question.) WRIGHT COMPANY Bank Reconciliation May 31 Book balance Add: 18 19 20 21 Bank statement balance 23 Add: 24 25 Subtotal Deduct: 27 Subtotal 28 Deduct: Adjusted book balance Adjusted bank balance 30 31 32 33 34 35 36 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 37 Nothing in this area will be graded, but it will be submitted with your assignment. 2676222222222222222222 40 42 43 AA