Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ASSIGNMENT PART I. Prepare a bank reconciliation statement for Nics Company as of November 30, 201A. Use the adjusted method of bank reconciliation. (25 points)

ASSIGNMENT

PART I. Prepare a bank reconciliation statement for Nics Company as of November 30, 201A. Use the adjusted method of bank reconciliation. (25 points)

The following unadjusted cash balances are available for Nics Company for the month ended November 30, 201A.

Cash balance per bank statement, November 30, 201AP 299,067.60

Cash balance per company records, November 30, 201A298,510.56

The bank statement disclosed the following information:

1.Charges by bank included a returned customer's check for P 3,315.36 because of insufficient funds (NSF) and service charge of P360 for November.

2.Credits by the bank included a customer's note for P28,800 plus interest of P288 that was collected on November 29, 201A.

A review of the company records disclosed the following information:

1.A deposit for P27,428.88 made on November 29, 201A did not appear on the bank statement.

2.Customers' checks totaling P7,857.60 were still on hand at November 30, 201A awaiting deposit.

3.The following company checks were still outstanding as of November 30, 201A:

Check #145243

P

2,308.56

Check #145247

3,532.32

Check #145250

6,318.00

4.Check #145257 for P2,188.80 in payment of a creditor account and included with the canceled checks in the bank statement has been erroneously recorded in the company records as P 460.80.

PART II. Prepare a Proof of Cash from the following transactions of Nics Company given below: (25 points)

Balance per company's ledger

September 30P975,000.00

October 311,312,500.00

Total debits to cash per company's books (recorded receipts) during October4,687,500.00 Total credits to cash per company's books(recorded disbursements) during

October4,350,000.00

Balance per bank statement

September 301,007,625.00

October 311,271,625.00

December receipts recorded by the bank during October4,639,500.00

December disbursements recorded by the bank during December4,375,500.00 Deposits in transit

September 30300,000.00

October 31421,875.00

Outstanding checks

September 30268,125.00

October 31221,250.00

Bank service charges (recorded by the depositor in the month following the month of charge)

September 302 250.00

October 311,500.00

Bank credit memo for customer's note collected by the bank in September (face

value P60,000 plus interest of P600), recorded by the company only on October

31

113,625.00

Bank credit memo for proceeds of bank loan granted by the bank on October 31

187,500.00

Customer's DAIF check returned by the bank (recorded by the company in the

following month)

October

46,875.00

September

26,250.00

Rubric for grading (per part)

PERFORMANCE INDICATORS POINTS

Correct accounts and amounts used

10

Computed final amounts are correct/balanced

15

TOTAL

25

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Microsoft Excel And Access 2013 For Accounting

Authors: Glenn Owen

4th Edition

1305161858, 9781305161856

More Books

Students also viewed these Accounting questions

Question

1. Background knowledge of the subject and

Answered: 1 week ago