Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
General Instructions
1. The following worksheet may be used to complete the exercise/problem.
You may need to refer to your textbook for additional information.
E6-1
75,000$
150,000
125,000
25,000
65,000
100,000
500,000
Required
Investment in stock
90-day Treasury bills
Treasury note, due December 1, 2046
Determine the amount of cash equivalents that should be combined with cash on the
Systematic Enterprises invested its excess cash in the following instruments during
December 2016:
Certificate of deposit, due January 31, 2019
Certificate of deposit, due March 30, 2017
Commercial paper, original maturity date February 28, 2017
Deposit into a money market fund
General Instructions
2. The blue cells are for data entry. Enter text in the T cells, formulas in the F cells, and
dollars or numbers in the $ cells.
E6-5
Required
Prepare the necessary journal entries, with explanations, for January. Assume that all
stamps and office supplies were used during the month.
Jan. 2 Petty Cash Fund 300.00
Cash 300.00
On January 2, Carson Car Rentals decided to set up a petty cash fund. The treasurer established the
fund by writing and cashing a $300 check and placing the coin and currency in a locked petty cash drawer.
Earl Paxton was designated as the custodian for the fund. During January, the following receipts were
given to Paxton in exchange for cash from the fund:
To record establishment of petty cash fund.
Assets = Liabilities + Stockholders' Equity Revenues
− Expenses = Net Income
Cash (225.90) (225.90) Postage (225.90)
Expense 76.00
Delivery
Expense 45.30
BALANCE SHEET
INCOME STATEMENT
General Instructions
2. The blue cells are for data entry. Enter text in the T cells, formulas in the F cells, and
dollars or numbers in the $ cells.
P6-1A
The following information is available to assist you in preparing a bank reconciliation for
Karen’s Catering on March 31:
Required
6,506.10$
KAREN'S CATERING
BANK RECONCILIATION
MARCH 31
Balance per bank statement, March 31
1. Prepare a bank reconciliation statement and determine the balance on the books before any
adjustments as well as the corrected balance to be reported on the balance sheet.
a. The balance on the March 31 bank statement is $6,506.10.
b. Not included on the bank statement is a $423 deposit made by Karen’s late on March 31.
c. A comparison between the canceled checks listed on the bank statement and the company
records indicated that the following checks are outstanding at March 31:
81.00 (517.17)
6,411.93$
$909 charged against the account
Adjusted balance, March 31
1. The following worksheet may be used to complete the exercise/problem.
You may need to refer to your textbook for additional information.
3. The completed exercise/problem may be printed or e-mailed per direction from your instructor.
P6-1
Required
1. Prepare a bank reconciliation in good form.
CALICO CORNERS
BANK RECONCILIATION
MAY 31
h. A comparison between the deposits listed on the bank statement and the company’s books revealed that a customer’s
check in the amount of $123.45 was recorded on the books during May but was never added to the company’s account.
The bank erroneously added the check to the account of Calico Closet, which has an account at the same bank.
i. The comparison of deposits per the bank statement with those per the books revealed that another customer’s check in
the amount of $101.10 was correctly added to the company’s account. In recording the check on the company’s books,
however, the accountant erroneously increased the Cash account by $1,011.00.
The following information is available to assist you in preparing a bank reconciliation for Calico Corners on May 31:
a. The balance on the May 31 bank statement is $8,432.11.
b. Not included on the bank statement is a $1,250 deposit made by Calico Corners late on May 31.
c. A comparison between the canceled checks returned with the bank statement and the company records indicated that
8,432.11$
Add: 1,250.00$
123.45 1,373.45
Deduct:
May 31 Cash 519.60
Interest Revenue 519.60
To record interest earned.
= Liabilities + Stockholders' Equity Revenues
−Expenses = Net Income
Cash (50.00) (50.00) Bank Service (50.00)
Fees Exp. 50.00
BALANCE SHEET
INCOME STATEMENT
Assets
2. Record the necessary journal entries on the company’s books resulting from the bank reconciliation prepared
in part (1) above.
Deposit in transit
Bank error: deposit credited to wrong account
Outstanding checks:
Balance per bank statement, May 31
Cash 166.00
To record customer’s NSF check.
May 31 Accounts Receivable 909.90
Cash 909.90
To correct error in recording customer’s check.
3. A friend says to you: “I don’t know why companies bother to prepare bank reconciliations—it seems a waste
of time. Why don’t they just do like I do and adjust the Cash account for any difference between what the bank
shows as a balance and what shows up in the books?" Explain to your friend why a bank reconciliation should
be prepared as soon as a bank statement is received.
