@ McGraw Hill Excel Question - Saved - Search for tools, help, and more (Alt + Q) @ File Home Insert Share Formulas Data Review \\View Help Draw Pediting v [ Comments Do e & = \" A A B @ D v & a = v 4 B T 5 T Qv tye PO~ . Al v X/ j Accessibility tab summary: General financial information about Wright Company is presented in rows 2 to 8. A statement for requirement is presented in row 9. A bank reconciliation for student presentation is presented in cells A13 to D21. ~ 4 A B c D E F G H M N o P a R s T u \\ i 4+ McGraw Hill X 2 wright Company's cash account shows a $27,500 debit balance and its bank statement shows $25,800 on deposit at 2 [the close of business on May 31. $27,500 525,800 a. The May 31 bank statement lists $100 in bank service charges; the company has not yet recorded the cost of these Check Answers (f) services. s100 5 | b. Outstanding checks as of May 31 total $5,600. $5,600 5 | May 31 cash receipts of $6,200 were placed in the bank's night depository after banking hours and were not Check My Work recorded on the May 31 bank statement. $6,200 b d. In reviewing the bank statement, a $400 check written by Smith Company was mistakenly drawn against Wright's Legend account. $400 V' Graded cell: Leave blank if no answer is 8 | e.The bank statement shows a $600 NSF check from a customer; the company has not yet recorded this NSF check. $600 needed 9 Required: Prepare the bank reconciliation for Wright Company. 10 [ Scratchpad: Use as a non-graded - workspace 12 13 Bank statement balance $25,800 _|Book balance 27,500 14 [Add: [Add: 15 F Deposit of May 31 6,200 2 F 16 F Bank error 00 F F 17 [subtotal 5,600 [subtotal |4 18 Deduct: Deduct: 19 Qutstanding checks 5,600 I Bank service charge fLo0 20 F F I NSF check fs00 21 | Adjusted bank balance 539,000 Adjusted book balance S 27,000 o 2 @ 23 24 25 [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. 26 |Nothing in this area will be graded, but it will be submitted with your assignment. 27 28 29 30 . 4 > v Give Feedback to Microsoft 100% + = Workbook Statistics IMPORTANT: Answer grading policy For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. McGraw Hill Excel Question - Saved Search for tools, help, and more (Alt + Q) File Home Insert Share Formulas Data Review View Help Draw Editing v Comments K) |Calibri (Body) |11 ~ A" A B I U ab D v v Av v 22 Wrap Merge | General $ 38 :28 Conditional Formatting v Cell Styles v Format As Table v | Insert v #8 Delete v [Fil Format | Ev v TV Ov | Add-ins Open 412 v x V f B D E G H M N P Q R S T U v w Y Z McGraw Hill X a. The May 31 bank statement lists $100 in bank service charges; the company has not yet recorded the cost of these services. $100 b. Outstanding checks as of May 31 total $5,600. $5,600 Check My Work View c. May 31 cash receipts of $6,200 were placed in the bank's night depository after banking hours and were not recorded 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 x Your answer is not complete account. $400 Legend e. The bank statement shows a $600 NSF check from a customer; the company has not yet recorded this NSF check. $600 Correct Answer Required: Prepare the bank reconciliation for Wright Company. 10 WRIGHT COMPANY * Incorrect Answer 11 Bank Reconciliation 12 Correct formula but wrong value May 31 13 Bank statement balance 7#########@ Book balance $27,500 Graded cell: Leave blank if no answer is 14 Add Add needed. 15 / Deposit of May 31 6,200 Bank error Scratchpad; Use as a non-graded 17 Subtota 32,400 Subtotal workspace 18 Deduct Deduct: Outstanding checks 5,600 Bank service charge 20 NSF check 600 21 Adjusted bank balance 26,8 Adjusted book balance $26,800 23 24 25 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. 26 Nothing in this area will be graded, but it will be submitted with your assignment. 27 28 36 39 & Graded Worksheet Continue Working