Question: It states my answer is incomplete. The formulas may be wrong. The format may be wrong. Can you check this for me? M x1 Integrated
It states my answer is incomplete. The formulas may be wrong. The format may be wrong. Can you check this for me?
M x1 Integrated Excel Tool X Banking Activities as Controls X Homework Help - Q&A from O x + X C & https://ezto.mheducation.com/ext/common/excelonline/excel-tool.html?Q_13252726722937929_ans to . . . O Excel McGraw Hill Excel Question - Saved Search (Alt + Q) File Home Insert Draw Formulas Data Review View Help Editing v Comments Calibri (Body) 11 Av ... Ev ab Ev General $ 00 -20 . . . O A1 X v fx 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 v B D E F G H M N 1 McGraw Hill X Wright Company's cash account shows a $27,500 debit balance and its bank statement shows $25,800 on deposit at 3 the close of business on May 31. $27,500 $25,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 services. $100 UT b. Outstanding checks as of May 31 total $5,600. $5,600 Check My Work c. May 31 cash receipts of $6,200 were placed in the bank's night depository after banking hours and were not 6 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 Legend 7 account. $400 8 Graded cell: Leave blank if no answer is . The bank statement shows a $600 NSF check from a customer; the company has not yet recorded this NSF check. $600 9 Required: Prepare the bank reconciliation for Wright Company. needed. 10 WRIGHT COMPANY Scratchpad: Use as a non-graded 11 Bank Reconciliation workspace 12 May 31 13 Bank statement balance $25,800 Book balance $27,500 14 Add: Add 15 Deposit of May 31 5,200 16 Bank error 400 17 Subtotal 6,600 Subtotal 18 Deduct: Deduct: 19 Outstanding checks 5,600 Bank service charge 100 20 NSF check 600 E Graded Worksheet + Save and Return to Assignment Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + 87'F Sunny Q Search X 7:36 PM 6/24/2023M x1 Integrated Excel Tool X *Homework Help - Q&A from Onl x + X C & https://ezto.mheducation.com/ext/common/excelonline/excel-tool.html?Q_13252726722937929_ans to . . . Excel McGraw Hill Excel Question - Saved Search (Alt + Q) File Home Insert Draw Formulas Data Review View Help Editing v Comments Calibri (Body) v 11 Av ... v ab v General $ v 00 . . . A1 X v fx 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 v O A B C D E F G H M N X 12 May 31 McGraw Hill 13 Bank statement balance $25,800 Book balance $27,500 14 Add: Add 15 Deposit of May 31 6,200 Check Answers 16 Bank error 400 17 Subtotal 6,600 Subtotal Check My Work 18 Deduct: Deduct: 19 Outstanding checks 5,600 Bank service charge 100 20 NSF check 600 Legend 21 Adjusted bank balance $26,800 Adjusted book balance $26,800 Graded cell: Leave blank if no answer is 22 23 needed. 24 Scratchpad: Use as a non-graded 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. workspace 26 Nothing in this area will be graded, but it will be submitted with your assignment. 27 28 29 30 31 32 33 34 & Graded Worksheet + Save and Return to Assignment Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + 87.F 7:36 PM Sunny Q Search X 6/24/2023
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Students Have Also Explored These Related Finance Questions!