Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please complete the following exercises and/or problems from the textbook: P11-26A P11-28A P11-35 - continuing problem from last week will attach also last weeks worksheet.
Please complete the following exercises and/or problems from the textbook:
- P11-26A
- P11-28A
- P11-35 - continuing problem from last week will attach also last weeks worksheet.
- P13-47 - Continuing problem from the one above.
Prepare your answers in an Excel workbook, using one worksheet per exercise or problem. please name tabs on excel worksheet to the corresponding exercise/problem.
Week 7 is the attachment with problems to be completed
Davies is the attachment from last week to help complete P11-35
Problems are attached.
Preliminary calculations(adjustments to bank statement) uncredited checks=3690 outstanding checks=190+550=740 bank errors=395 Adjustments to cash book undebited cash=interest +direc deposits by customers interest u=income=22 collections bt bank=700 uncredited expenses bank charges=18 standing orders=9+1095+85=1189 Davis consulting Bank reconciliation statement For the month of march 2015 cash per bank statement add: uncredited checks 27,375 4,090 less: outstanding checks bank errors Adjusted cash balance 740 395 cash as per the cash book add: interest income 31,065 direct deposits subtotal less: bank charges -1,135 standind orders -1207 $29,930 Adjusted cash balance Journal entries cash interest income accounts receivable Debit Credit 1122 (To record cash received from customers and interest) Accounts payable 740 cash (To record cash payments to creditors) bank charges expense 18 cash ( To record bank charge expenses) 22 1100 740 18 30,015 22 1100 1,122 31,137 18 1189 $29,930 1 Provision for bad debts= 5% x 4,500 =$225 Dr. Bad debts Account 225 Cr. Allowance for uncollectible Accounts 225 Dr. Allowance for Bad debts Cr. Accounts Receivables 200 2 200 P11-28A: I wi P11-35 This continues from last week Davies - I will attach last weeks Davies problem. P13-47 is continuum of the one aboveStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started