Cash and Cash Equivalent
Cash and Cash Equivalent
Problem 8-4
(Locsin)
1) C
Let X = Principal Amount
Principal X
Less: Compensating Balance 5%X
Add: Current Balance 50,000
Amount needed ₱ 3,375,000.00
2) C
Annual interest payment 420,000
(3,500,000 x 12%)
Interest income on the loan proceeds in the compensating
balance
[(3,500,000 - 3,375,000) x 4%] 5,000
Net interest 415,000
Divide by loan proceeds
(3,500,000-175,000) 3,375,000
Effective interest rate 12.30%
PROBLEM 8-8 Petty Cash Fund (Meana)
Requirement No. 1
Currencies 3,000
Coins 450
A check drawn by the company payable to the order
of the petty cash custodian, representing her salary 3,800
Adjusted Petty Cash Fund 7,250
Requirement No. 3
Currencies 3,000
Coins 450
Petty cash vouchers:
Transportation 650
Office supplies 160
Repair of computer 400
Loans to employees 600
Miscellaneous expenses 240
Postage 200
A check drawn by the company payable to the
order of the petty cash custodian, representing her 3,800
salary
An employee’s check returned by the bank because 1,200
of insufficient funds
A piece of paper with names of several employees
together with a contribution for a wedding gift for
an employee. Attached to the sheet of paper is a 500 11,200
currency of
Less: Petty Cash Accountabilities 10,000
PCF imprest balance
A piece of paper with names of several employees
together with a contribution for a wedding gift
for an employee. Attached to the sheet of paper 500 10,500
is a currency of
Petty cash overage 700
Problem 8-9 Petty Cash Fund (Duarte)
Required: Compute the amount of cash shortage.
Petty Cash Count Sheet
January 3, 2018; 8:30AM
Vouchers
Date Particulars Amount
12/15/18 Transportation 65.00
12/16/18 Office Supplies 70.00
12/17/18 Xerox fees 80.00
12/18/18 Postage 150.00
1/2/19 Newspaper 10.00
1/2/19 Freight Charges 50.00
Total Vouchers 425.00
Sales Invoice
Date Invoices Amount
12/30/18 #143 4,000.00
12/31/18 #144 5,100.00
1/2/19 #145 3,050.00
Total Invoice 12,150.00
Bills and Coins 2,585.00
Checks for deposit 17,600.00
I.O.U's 150.00
Vouchers paid 425.00
Total Petty Cash Accounted 20,760.00
Less: Petty Cash Accountabilities Cash Collections 12,150.00
PC Fund Ledger Balance 5,000.00
Check collection from customer 6,500.00
Petty Cash Overage (2,890.00)
Bank Book
Credit memo:
October 1,600
November 750
Debit memo:
NSF: November - 665
BSC: October - 20
November - 22
- 35
Check No. 148 1,000
Check No. 150 - 270
Rent expense 35
Cash in bank 35
75,000 (75,000)
150,000 150,000
Total 1,540,000
Checks paid by bank
OC (150,000) (150,000)
390,000 (390,000)
153,000 153,000
Error bank charge
1 C
2 D
3 C
4 D
5 A
6 D
PROBLEM 8-15 PROOF OF CASH (Marquez)
Question No. 1
ANS. A
Question No. 2
Outstanding check, Aug. 31 P 67,122
Add: Checks paid by the bank
Bank debits except service P 1,702,830
charge
Less: Erroneous bank charge 1,166
Debit memo 4,950 1,696,714
Total P 1,763,836
Less: Checks issued by the
company this August 1,712,982
Outstanding check, July 31 P 50,944
ANS. C
ANS. 3.) A
4.) B
5.) A
Disbursement Adjusted
Beginning Balance Receipts s Balance
(500.00) (500.00) -
NSF check not
recorded (40,000.00) (40,000.00) -
Adjusted Balance 73,000.00 140,000.00 87,000.00 126,000.00
Beginning Adjusted
Balance Receipts Disbursements Balance
Total 82,000.00
08-Dec 10,000.00
Bank to Book
Bank Receipts, beg 171,500.00
Add: Deposit In Transit
30-Nov (11,000.00)
31-Dec 20,000.00 9,000.00
Less:
Error Correction (500.00)
B.
1. Outstanding Checks Beg. (Squeeze) 8000
Add: Check issued this month
Book
Disbursement 148,000
Less: DM recorded this month 2,500 145,500
Total 153,500
Less: Bank disbursement 150,000
NSF Rdeposited 3,000
DM for this month 1,500
Add: Paid out in currency 2,000 147,500
Outstanding Checks End. 6,000
BANK
Sept 30 Receipt Disbursement Oct 30
Unadjusted Balance - Bank 100,000 200,000 150,000 150,000
Undeposited Collection
September 30 5,000 (5,000)
October 31 7,000 7,000
Outstanding Checks End.
September 30 (8,000) (8,000)
October 31 6,000 (6,000)
Paid out in currency 2,000 2,000
A.
Adjusted Balance - Bank A 97,000 204,000 150,000 151000
2.) A
Outstanding Check, Beg. (Acct. 544) ₱ 250,000.00
Add: Checks issued during the month (DM, previous
is deducted) 3,490,000.00
Total ₱ 3,740,000.00
Deduct: Checks paid by the bank this month (DM,
current is deducted) (1,880,000.00)
Outstanding Check, End (Acct. 544) ₱ 1,860,000.00
Add: Outstanding Check (Acct. 143) 60,000.00
Total Outstanding Check, 12/31/18 ₱ 1,920,000.00
3.) B
4.) B November 30 Receipts Disbursements December 31
₱ ₱
Unadjusted Bank Balance (Acct. 544) 2,200,000.00 ₱ 1,000,000.00 2,000,000.00 ₱ 1,200,000.00
Deposit In Transit
Nov. 30 90,000.00 (90,000.00)
Dec. 31 240,000.00 240,000.00
Outstanding Check
Nov. 30 (250,000.00) (250,000.00)
Dec. 31 1,860,000.00 (1,860,000.00)
Errors 20,000 (20,000.00)
₱
Adjusted Balances ₱ 2,060,000.00 1,130,000.00 ₱ 3,610,000.00 (₱ 420,000.00)
5.) C
Adjusted Balance (Acct. 143) ₱ 1,020,000.00
Adjusted Balance (Acct. 544) (420,000.00)
Total Adjusted Balance, 12/31/18 ₱ 600,000.00
3-4)
5.)
Adjusted balances:
Account No. 143 1,020,000
Account No. 144 -420,000
Total adjusted balances 600,000
Previous Current
Receipts Disbursement
Month Month
Balance: 200,000 150,000 80,000 270,000
Credit Memo:
Previous Month 9,000 (9,000) - -
Current Month - 13,000 - 13,000
Debit Memo:
Previous Month (100) - (100) -
Current Month - - 150 (150)
Mutilated Check 700 - - 700
Company Check - (1,200) (1,200) -
Adjusted Balance 209,600 152,800 78,850 283,685
Bank
Bank Book
Bank Book
Unadjusted Balance 42,400 46,500
Deposit in Transit 5,000
Outstanding Checks (11,500)
Debit Memo (100)
Credit Memo 900
Adjusted Balance 35,900 47,300
1. C 2. D
3. B
Adjusted Cash in Bank Balance (Cash Accounted
35,900
Cash in Bank (Cash Accountability) 47,300
Cash Shortage as of June 30 11,400
4. D
July Collections per Duplicate Receipts 18,800
Collected Duplicate Slips
Total Duplicate Slips 11,000
Undeposited Collections 5,000 6,000
Cash on Hand 12,800
Actual Cash on Hand 4,800
Cash as of July 1-15 8,000
5. D
Understatement of Cash in Bank per Book 900
(46,500- 45,600)
Overstatement of Cash in Bank per Bank 1,600
(42,400 - 44,000)
Understatement of Outstanding Checks 7,900
(11,500 - 3,600)
Overstatement of Undeposited Collections 100
(5,000 - 5,100)
Credit Memo 900
Cash Shortage 11,400
Problem 8-25 (Abines)
Deposit in transit, unadjusted bal. P 175,250 Add: Credit memo for note coll. 15,000
OC, unadjusted balance P 246,760 Cash in bank per books bal. P 310,360
Less: Unreleased check (14,750) Less: Adjusted cash in bank balance 250,460
Unadjusted bal. per bank P 350,000 Unadjusted bal. per books P293,500
Add: Deposit in transit 125,250 Less: Adjusted cash in bank balance 250,460
2 Accounts Payable
Ending 120,000 - Beginning
Payment 360,000 480,000 Purchases
4,800,000 4,800,000
or
Purchases 480,000
Less: Unpaid
(120,000)
Paid/Payments 360,000 A.
3 Merchandise Inventory
Beginning - 60,000 Ending
Purchases 480,000 420,000 COGS B.
480,000 480,000
5 BOOK BANK
Beginning 240,000 101,000 Unadjusted
Collected 420,000
(9,000)
Paid 360,000 10,000 DIT
Loan Proceeds 200,000
Loan Paid
(140,000)
OPEX
(180,000)
Total 180,000 102,000 Adjusted Balance per Bank