E4.16 Consider the following table with sample data. BANK ACCOUNTS TABLE AccountID АсcountType CurrentBalance AccountHolderID AccountHolderName A111 Checking $1,000.00 C11 Joe Smith C222 Sue Smith A222 Checking S2,000.00 C333 Mary Moore A333 Money Market $15,000.00 C444 Pat Clark C555 Lisa Clark C666 Timmy Clark A444 Savings $3,000.00 C111 Joe Smith C222 Sue Smith E4.16a Normalize the Bank Accounts Table to 1NF by increasing the number of records in the existing table. E4.16b Normalize the Bank Accounts Table to 1NF by creating a new separate table in addition to the existing table.

E4.16 Consider the following table with sample data. BANK ACCOUNTS TABLE AccountID АсcountType CurrentBalance AccountHolderID AccountHolderName A111 Checking $1,000.00 C11 Joe Smith C222 Sue Smith A222 Checking S2,000.00 C333 Mary Moore A333 Money Market $15,000.00 C444 Pat Clark C555 Lisa Clark C666 Timmy Clark A444 Savings $3,000.00 C111 Joe Smith C222 Sue Smith E4.16a Normalize the Bank Accounts Table to 1NF by increasing the number of records in the existing table. E4.16b Normalize the Bank Accounts Table to 1NF by creating a new separate table in addition to the existing table.

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter8: Fraud, Internal Controls, And Cash

Section: Chapter Questions

Problem 9PA: Domingo Company received the following bank statement. Using PA9, prepare the bank reconciliation.

See similar textbooks

Similar questions

if a bank quotes usd/jpy at 105.24-25, and an individual wishes to buy JPy, what is the corret price 105.25 105.245
What is the adjusted cash in bank on December 31? 8,200,000 9,050,000 8,970,000 9,150,000 What is the cash in bank per ledger on December 31? 8,990,000 8,270,000 8,560,000 8,660,000 for fc479f51-46ab-41af-b134-12bc9f4c0777.png How much from the list above should be presented as part of noncurrent assets 4,000,000 1,000,000 4,900,000 5,500,000
What is the bank statement balance at June 30, 2023?a. P70,564.40b. P78,314.60c. P83,109.60d.. P87,904.60
How effective is the organization in collecting its receivables? Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in cells A40 through C60. Table 1: Hillside, Inc. Balance Sheet ($ in Millions) ASSETS LIABILITIES Cash & Marketable Securities 449.90 Accounts Payable 1,611.20 Accounts Receivable 954.80 Salaries Payable 225.20 Inventories 3,645.20 Other Current Liabilities 1,118.80 Other Current Assets 116.60 Total Current Liabilities 2,955.20 Total Current Assets 5,165.27 Other Liabilities 693.40 Machinery & Equipment 1,688.90 Land 1,129.70 Total Liabilities 3,648.60 Buildings 2,348.40 Depreciation (575.60) SHAREHOLDER'S…
In the following, assume that the required reserve ratio is 5%. a. With T-Accounts (like the ones below), show the immediate effect of a $1000 Open Market Purchase by the Fed from a member of the public who deposits the Fed's payment into a checking account at the AAA Bank. AAA Bank Fed Fed Assets Liabilities Assets Liabilities
The following information pertains to jeng Company: Balance per bank statement, Dec. 31, 2013, P73,350Cash ledger balance, Dec. 31, 2013, P63,675Proceeds of a customer’s note collected by the bank including P50 interest, P6,525Bank service charges, P45Deposit in transit, P4,158NSF check of customer deposited and returned, P378Outstanding checks, P7,731 Requirement:a. Prepare the bank reconciliation statement.b. Journalize the adjusting entries
Blue Corporation requires a P150,000minimum cash balance on its:checkingaccount. Based on the control limit model, itsspread should be P120,000. If as of the end ofthe day, the cash balance is P30,000, it shouldinfuse cash or (invest in marketablesecurities) amounting to : a. 160,000b. 190,000c. 240,000d. 120,000
Give typing answer with explanation and conclusion When a bank increases its fed funds sold, its deposit balance in the Fed will _________ ; when a bank's deposit balance in the Fed increases, the bank has increased its fed funds______ Group of answer choices increase; purchased increase; sold decrease; purchased decrease; sold
ThefollowingtrialbalancehasbeenextractedfromtheledgerofMr.Cole,asoletrader:Trialbalanceasat31December,2020ParticularsDebit¢Credit¢Sales138,000Purchases82,350Travelexpenses5,200Drawings7,800Rent,rates&insurance6,600Postageandstationery3,000Advertisement1,330Salariesandwages26,420Baddebt8,700InvestmentIncome15,890Debtors12,120 Creditors 130 Cashinhand1,700Cashatbank1,000Inventoryasat1January,202011,800Equipmentatcost58,000Loan19,000Capital53,000226,020226,020Inventoryatthecloseofbusinesshasbeenvaluedat¢13,500Required;Prepareanincomestatementfortheyearending31stDecember2020andabalancesheetasatthatdate.
ABC Company provided the following information:Balance per bank statement- May 31 2,600,000Deposits outstanding 300,000Checks Outstanding (100,000)Correct Bank Balance- May 31 2,800,000Balance per book- May 31 2,810,000Bank Service Charge (10,000)Correct book balance- May 31 2,800,000June data are as follows: BANK BOOK Checks recorded2,200,000 2,500,000Deposits recorded1,600,000 1,800,000Serbbice charge recorded50,000Note collected by bank, 500,000 plus interest550,000NSF Check returned with June 30 statement100,000Balances2,400,000 2,100,0001. What is the amount of outstanding checks on June 30?2. What is the amount of deposits in transit on June 30?3. What is the adjusted cash in bank on June 30?
Which of the following item, have been recorded on the company's books but not yet by the bank: ered f1.00 Select one: stion a. Cash per bank b. Outstanding checks c. Cash per book d. Deposits in transit
Use T-accounts to show the impact of deposits withdrawals of 350 million from DIs on balance sheets of customers, the Central bank and DIs, monetary base and money stock if required reserves ratio is 0.1, excess reserves ratio is 0.05 and currency ratio is 0.10.