978-0078025600 Chapter 6 Excel

subject Type Homework Help
subject Pages 7
subject Words 923
subject Authors Barbara Chiappetta, John Wild, Ken Shaw

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Student Name:
Class:
27,233$ 27,497$
11,514 7,955
38,747 35,452
1,482$ NSF check 805$
382 Service charge 25
Problem 06-04A
McGraw-Hill/Irwin
Instructor
Deduct:
Book balance
Add:
Proceeds of note less collection charge
3031
BRANCH COMPANY
3065
Bank statement balance
Add:
Deposit of July 31
Total
Deduct:
Outstanding Checks:
Bank Reconciliation
page-pf2
Student Name:
Class:
Problem 06-04A
McGraw-Hill/Irwin
Instructor
statement cash balance on reconciliation.
a. (i) The final balance that results from adjusting the bank statement balance will not be
affected by the error; and (ii) The final balance that results from adjusting the book balance of
cash will be overstated by $450 ($27,947-$27,497), and the bank reconciliation will not
balance. b. (i) The final balance that results from adjusting the bank statement balance will be
overstated by $7,955; and (ii) The final balance that results from adjusting the book balance
will be understated by $7,955.
page-pf4
Student Name:
Class:
18,453.25$ 17,404.20$
1,682.75 12.50$
20,136.00 1,485.00 1,497.50
18,901.70
494.25$ 600.25
982.30 30.00
388.00 1,864.55 630.25
NSF check
Error on check no. 5904
Total
Book balance of cash
Add:
Interest earned
Proceeds of note less coll. fee
Deduct:
5906
5908
McGraw-Hill/Irwin
Instructor
Problem 06-05A
Bank statement balance
Add:
September 30, 2013
Deposit of September 30
Total
Deduct:
Checks No. 5893
page-pf5
Student Name:
Class:
McGraw-Hill/Irwin
Instructor
Problem 06-05A
There are several possible reasons why some prenumbered checks are missing from the sequence of
canceled checks returned with a bank statement. Reasons include: (1) Some of the checks in the numbered
sequence may have cleared the bank in a previous period and were returned with the bank statement in that
previous period. (2) Some of the checks in the numbered sequence may remain outstanding. If so, they will
be returned with the bank statement in a later period when they clear the bank. (3) The issuer of the checks
may have voided one or more of the checks in the numbered sequence, perhaps because of making an error
in writing the checks. (4) Occasionally, a check will reach the bank but the bank will incorrectly charge the
check to the wrong account. When the bank detects the error, it will return the check separately with a note of
explanation to the depositor.

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.