Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help please and show work for the worksheet it would realky help The People's Choice Bank is a small community bank that has three local

image text in transcribed

help please and show work for the worksheet it would realky help

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

The People's Choice Bank is a small community bank that has three local branches, in Blue Ash, Delhi, and Anderson Hills. The Excel file Peoples Choice Bank is a database of major account transactions for the month of August. 1. Note that it is difficult to determine whether each transaction in the Amount column represents a positive cash inflow or a negative cash outflow without information in other columns. Modify the database as appropriate to more easily analyze the data, 2. Suppose that you have been asked to prepare a summary of these transactions that would be clear and meaningful to the bank's president. Use PivotTables (that are well-designed and properly formatted) to provide a summary of the key information that the president and his direct reports would want to know. Justify and explain your reasoning. \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & C & D & E & G \\ \hline 83 7-Aug & Thursday & Checking & Deposit & $2,830,00 Current & Delhi \\ \hline 4. 7-Aug & Thursday & Checking & Withdrawal & $3,010.00 Current & Anderson Hills \\ \hline 35/7-Aug & Thursday & Checking & Deposit & $3,110.00 Current & Blue Ash \\ \hline 86 7-Aug & Thursday & Checking & Withdrawal & $930.00 Current & Anderson Hills \\ \hline 87 7-Aug & Thursday & Checking & Deposit & $3,680.00 Current & Delhi \\ \hline 188 7-Aug & Thursday & Checking & Deposit & $3,810.00 Current & Delhi \\ \hline 89 7-Aug & Thursday & Checking & Withdrawal & $2,780.00 Current & Anderson Hills \\ \hline 90 8-Aug & Friday & Savings & New Account & $500.00New & Blue Ash \\ \hline 91 8-Aug & Friday & Checking & New Account & $220.00New & Delhi \\ \hline 192 8-Aug & Friday & Checking & New Account & $430.00New & Anderson Hills \\ \hline 93 8-Aug & Friday & Checking & New Account & $990.00New & Anderson Hills \\ \hline 94 8-Aug & Friday & Certificate of Deposit & New Account & $26,600.00New & Anderson Hills \\ \hline 95 8-Aug & Friday & Certificate of Deposit & New Account & $36,900.00New & Anderson Hills \\ \hline 968 -Aug & Friday & Certificate of Deposit & New Account & $15,100.00New & Blue Ash \\ \hline 78-Aug & Friday & Savings & Withdrawal & $1,100.00 Current & Anderson Hills \\ \hline 98 8-Aug & Friday & Savings & Deposit & $1,900,00 Current & Anderson Hills \\ \hline 99 8-Aug & Friday & Savings & Withdrawal & $2,000.00 Current & Anderson Hills \\ \hline 8-Aug & Friday & Savings & Deposit & $1,200,00 Current & Anderson Hills \\ \hline 18-Aug & Friday & Savings & Deposit & $2,200.00 Current & Delhi \\ \hline 2 8-Aug & Friday & Savings & Deposit & $1,200.00 Current & Blue Ash \\ \hline 3 8-Aug & Friday & IRA & Current Contributiol & $2,000.00 Current & Anderson Hills \\ \hline 4 8-Aug & Friday & Checking & Deposit & $150.00 Current & Blue Ash \\ \hline 15 8-Aug & Friday & Checking & Withdrawal & $2,860.00 Current & Anderson Hills \\ \hline 6 8-Aug & Friday & Checking & Deposit & $500.00 Current & Anderson Hills \\ \hline 8-Aug & Friday & Checking & Withdrawal & $700.00 Current & Anderson Hills \\ \hline 8-Aug & Friday & Checking & Deposit & $680.00 Current & Anderson Hills \\ \hline 9-Aug & Saturday & Savings & New Account & $300.00New & Anderson Hills \\ \hline 109-Aug & Saturday & Savings & New Account & $2,200,00New & Anderson Hills \\ \hline 11 9-Aug & Saturday & Checking & New Account & $90.00NeW & Anderson Hills \\ \hline 129-Aug139-Aug & Saturday & Checking & New Account & $150.00New & Anderson Hills \\ \hline 9-Aug & Saturday & Checking & New Account & $230.00New & Blue Ash \\ \hline & Data & + & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & C & D & E & G \\ \hline 4411 -Aug & Monday & Checking & Deposit & $2,940.00 Current & Blue Ash \\ \hline 11-Aug & Monday & Checking & Deposit & $2,810.00 Current & Anderson Hills \\ \hline 611 -Aug & Monday & Checking & Deposit & $630.00 Current & Blue Ash \\ \hline 11-Aug & Monday & Checking & Withdrawal & $570.00 Current & Delhi \\ \hline 11-Aug & Monday & Checking & Deposit & $1,020.00 Current & Anderson Hills \\ \hline 11-Aug & Monday & Checking & Withdrawal & $940.00 Current & Anderson Hills \\ \hline 11-Aug & Monday & Checking & Deposit & $90.00 Current & Anderson Hills \\ \hline 12-Aug & Tuesday & Savings & New Account & $1,600.00New & Blue Ash \\ \hline 12-Aug & Tuesday & Checking & New Account & $770.00New & Anderson Hills \\ \hline 12-Aug & Tuesday & Checking & New Account & $3,670.00New & Anderson Hills \\ \hline A 12-Aug & Tuesday & Checking & New Account & $960.00New & Blue Ash \\ \hline 12 -Aug & Tuesday & Certificate of Deposit & New Account & $29,000.00New & Anderson Hills \\ \hline 12-Aug & Tuesday & Savings & Deposit & $1,100.00 Current & Delhi \\ \hline 12-Aug & Tuesday & Savings & Deposit & $1,800.00 Current & Anderson Hills \\ \hline 8 12-Aug & Tuesday & Savings & Deposit & $1,100.00 Current & Anderson Hills \\ \hline 9. 12-Aug & Tuesday & Savings & Withdrawal & $1,400.00 Current & Blue Ash \\ \hline 10. 12-Aug & Tuesday & Savings & Deposit & $1,700.00 Current & Delhi \\ \hline 61 12-Aug & Tuesday & Checking & Deposit & $50.00 Current & Blue Ash \\ \hline 6. 12-Aug & Tuesday & Checking & Withdrawal & $850.00 Current & Delhi \\ \hline 63 12-Aug & Tuesday & Checking & Deposit & $2,660.00 Current & Blue Ash \\ \hline 6412 -Aug & Tuesday & Checking & Withdrawal & $520.00 Current & Anderson Hills \\ \hline 65 12-Aug & Tuesday & Checking & Withdrawal & $980.00 Current & Delhi \\ \hline 6612-Aug6712-Aug & Tuesday & Checking & Withdrawal & $220.00 Current & Anderson Hills \\ \hline 6)12-Aug6812-Aug & Tuesday & Checking & Withdrawal & $580.00 Current & Blue Ash \\ \hline 12-Aug6912-Aug & TuesdayTuesday & Certificate of Deposit & New & $7,100.00 Current & Delhi \\ \hline 70. 13-Aug & TuesdayWednesday & CertificateofDepositSavings & New & $18,100.00 Current & Anderson Hills \\ \hline 1) 13-Aug & Wednesday & & New Account & $700.00New & Anderson Hills \\ \hline 72 13-Aug & Wednesday & SavingsSavings & New Account & $800.00New & Anderson Hills \\ \hline 273 13-Aug & Wednesday & SavingsChecking & New Account & $2,700.00New & Blue Ash \\ \hline 274 13-Aug & Wednesday & Checking & NewAccountNewAccount & $300.00New & Blue Ash \\ \hline & Data & & & $270.00 New & Anderson Hills \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline A & A & e & D & 1 & G \\ \hline 15-Aug & Friday & IRA & Current Contributior & 23,900 00 eurent & Andersen Hiils \\ \hline 15-Aug & Friday & Checking & Withdrawal & q280 00 Curreni & Andersen Hillis \\ \hline 8 15-Aug & Friday & Cheoking & Deposit & 93,30000 eurrent & Alue Ash \\ \hline 19. 15-Aug & Friday & Cheoking & Depesit & $2,74000 cument & Delhi \\ \hline 40 15-Aug & Friday & Checking & Withdrawal & 83000 Eurreni & Andersen Hills \\ \hline 41 15-Aug & Friday & Cheoking & Deposil & 9840.00 emrent & Andersen tiils \\ \hline 12 15-Aug & Friday & Cheoking & Withdrawal & 29500 00 Current & Dellit \\ \hline 43 15-Aug & Friday & Checking & Withdrawal & soto 00 Current & Hilue Ash \\ \hline 44 15-Aug & Friday & Cheeking & Withdrawal & 9310.00 Curient & Blue Ash \\ \hline 45 15-Aug & Friday & Cheoking & Deposit & $1,010.00 Current & Andersen Hiils \\ \hline 46 15-Aug & Friday & Checking & Withdrawal & 8500.00 Curtent & Blue Ash \\ \hline 47 15-Aug & Friday & Certifieate of Deposit & New & $10,000,00 Current & Blue Ash \\ \hline 48 16-Aug & Saturday & Savings & New Aeeount & $2,00000New & Andersen Hills \\ \hline 149 16-Aug & Saturday & Savings & New Apeount & $90000 New & Andersen Hilis \\ \hline 50 16-Aug & Saturday & Cheoking & New Aecount & 83,170,00NeW & Delhi \\ \hline 151 16-Aug & Saturday & Savings & Withdrawal & $900.00 Current & Alue Ash \\ \hline 152 16-Aug & Saturday & Savings & Deposit & $200.00 Current & Andersen Hills \\ \hline 153 16-Aug & Saturday & Checking & Deposit & $2,800,00 Current & Dellai \\ \hline 354 16-Aug & Saturday & Cheoking & Deposit & $640.00 eurrent & Andersen Hills \\ \hline 355 16-Aug & Saturday & Checking & Withdrawal & $590.00 Current & Andersen Hiils \\ \hline 156 16-Aug & Saturday & Checking & Deposit & $020.00 Current & Andersen Hiils \\ \hline 57 18-Aug & Monday & Savings & New Aceount & $1,700.00New & Blue Ash \\ \hline 8 18-Aug & Monday & Savings & New Aceount & $1,000,00New & Alue Ash \\ \hline 59 18-Aug & Monday & Cheeking & New Acoount & $490.00 New & Delhi \\ \hline 60 18-Aug & Monday & Certificate of Deposit & New Acoount & 355,400,00 New & Andersen Hills \\ \hline 6) 18-Aug & Monday & Certifieate of Deposit & New Aceount & $47,200,00 New & Alue Ash \\ \hline 362 18-Aug & Monday & Certifieate of Deposit & New Account & $10,200,00 New & Andersen Hills \\ \hline 63 18-Aug & Monday & Certificate of Deposit & New Aepeunt & $29,600,00 New & Delhi \\ \hline 64 18-Aug & Monday & Savings & Deposit & $1,100.00 Current & Andersen Hiils \\ \hline 65 18-Aug & Monday & Savings & Deposit & $800.00 eurtent & Andersen Hills \\ \hline 66 18-Aug & Monday & Savings & Deposit & $500.00 Current & Delhi \\ \hline & Data & + & & & \\ \hline \end{tabular} coss File Home Insert Draw Page Layout Formulas Data Review View Automate Help Q185 fx 82F Sunny. Q185 fx \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & c & D & f & 6 \\ \hline 50 21-Aug & Thursday & Checking & Deposit & $3,250,00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Checking & Deposit & $3,650,00 Current & Delhi \\ \hline 21-Aug & Thursday & Checking & Deposit & $920.00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Checking & Withdrawal & $760.00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Checking & Deposit & $760.00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Checking & Deposit & $240.00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Certificate of Deposit & New & $28,000,00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Certificate of Deposit & New & $15,100.00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Certificate of Deposit & New & $59,600.00 Current & Blue Ash \\ \hline 22-Aug & Friday & Savings & New Account & $100.00 New & Anderson Hills \\ \hline 22-Aug & Friday & Checking & New Account & $830.00 New & Blue Ash \\ \hline 22-Aug & Friday & Certificate of Deposit & New Account & $58,600.00New & Delhi \\ \hline 22-Aug & Friday & Certificate of Deposit & New Account & $49,900.00New & Anderson Hills \\ \hline 22-Aug & Friday & Certificate of Deposit & New Account & $55,000,00New & Anderson Hills \\ \hline 4 22-Aug & Friday & Certificate of Deposit & New Account & $15,000,00New & Anderson Hills \\ \hline 22-Aug & Friday & Certificate of Deposit & New Account & $35,900,00New & Anderson Hills \\ \hline 22-Aug & Friday & Savings & Deposit & $400.00 Current & Blue Ash \\ \hline 77 22-Aug & Friday & Savings & Withdrawal & $2,700.00 Current & Anderson Hills \\ \hline 78 22-Aug & Friday & Savings & Deposit & $900.00 Current & Blue Ash \\ \hline 179 22-Aug & Friday & IRA & Current Contributiol & $1,700.00 Current & Delhi \\ \hline 80 22-Aug & Friday & Checking & Deposit & $3,900,00 Current & Anderson Hills \\ \hline 181 22-Aug & Friday & Checking & Deposit & $3,690.00 Current & Delhi \\ \hline 182 22-Aug & Friday & Checking & Deposit & $840.00 Current & Blue Ash \\ \hline 183 22-Aug & Friday & Checking & Withdrawal & $760.00 Current & Blue Ash \\ \hline 184 22-Aug & Friday & Checking & Deposit & $810.00 Current & Anderson Hills \\ \hline 485 22-Aug & Friday & Checking & Deposit & $790.00 Current & Anderson Hills \\ \hline 6 22-Aug & Friday & Checking & Deposit & $300.00 Current & Blue Ash \\ \hline 22-Aug & Friday & Checking & Withdrawal & $1,000,00 Current & Anderson Hills \\ \hline 8 22-Aug & Friday & Checking & Withdrawal & $970.00 Current & Anderson Hills \\ \hline 489 22-Aug & Friday & Checking & Withdrawal & $460.00 Current & Blue Ash \\ \hline 90 23-Aug & Saturday & Savings & New Account & $2,400,00 New & Delhi \\ \hline> & Data & & & & \\ \hline \end{tabular} Ready ir Accessibility; investigate 01851fx \begin{tabular}{|c|c|c|c|c|c|c|} \hline A & B & C & D & F & G & H \\ \hline 19. Aug & Tuesday & Certificate of Deposit & New Account & $37,300.00New & Blue Ash & \\ \hline 19. Aug & Tuesday & Savings & Withdrawal & $1,700.00 Current & Anderson Hills & \\ \hline 00 19-Aug & Tuesday & Savings & Deposit & $600.00 Current & Anderson Hills & \\ \hline 91 19-Aug & Tuesday & Savings & Deposit & $500.00 Current & Delhi & \\ \hline 02 19-Aug & Tuesday & Savings & Withdrawal & $2,800,00 Current & Anderson Hills & \\ \hline 103 19-Aug & Tuesday & Savings & Deposit & $2,400,00 Current & Delhi & \\ \hline 101 19-Aug & Tuesday & Savings & Deposit & $400.00 Current & Anderson Hills & \\ \hline 405 19-Aug & Tuesday & Savings & Deposit & $2,700.00 Current & Anderson Hills & \\ \hline 106 19-Aug & Tuesday & Savings & Deposit & $1,200.00 Current & Anderson Hills & \\ \hline 407 19-Aug & Tuesday & Savings & Withdrawal & $2,300.00 Current & Blue Ash & \\ \hline 108 19-Aug & Tuesday & Savings & Deposit & $2,500.00 Current & Anderson Hills & \\ \hline A09 19-Aug & Tuesday & Savings & Deposit & $300.00 Current & Anderson Hills & \\ \hline 110 19-Aug & Tuesday & Savings & Deposit & $1,200.00 Current & Delhi & \\ \hline 411 19-Aug & Tuesday & IRA & Current Contributiol & $1,700.00 Current & Blue Ash & \\ \hline 412 19-Aug & Tuesday & Checking & Deposit & $990.00 Current & Anderson Hills & \\ \hline 413 19-Aug & Tuesday & Checking & Withdrawal & $120.00 Current & Blue Ash & \\ \hline 414 19-Aug & Tuesday & Checking & Withdrawal & $160.00 Current & Anderson Hills & \\ \hline 115 19-Aug & Tuesday & Checking & Withdrawal & $3,530.00 Current & Delhi & \\ \hline 416 19-Aug & Tuesday & Checking & Withdrawal & $980.00 Current & Anderson Hills & \\ \hline 117 19-Aug & Tuesday & Checking & Deposit & $3,250.00 Current & Blue Ash & \\ \hline 118 19-Aug & Tuesday & Checking & Withdrawal & $30.00 Current & Anderson Hills & \\ \hline 419 19-Aug & Tuesday & Checking & Deposit & $60.00 Current & Anderson Hills & \\ \hline 420 19-Aug & Tuesday & Checking & Withdrawal & $310.00 Current & Anderson Hills & \\ \hline 421 19-Aug & Tuesday & Checking & Deposit & $670.00 Current & Delhi & \\ \hline 42) 19-Aug & Tuesday & Checking & Withdrawal & $230.00 Current & Anderson Hills & \\ \hline 423 19-Aug & Tuesday & Certificate of Deposit & New & $15,300.00 Current & Anderson Hills & \\ \hline 424 19-Aug & Tuesday & Certificate of Deposit & New & $18,700.00 Current & Delhi & \\ \hline 125 19-Aug & Tuesday & Certificate of Deposit & New & $40,800.00 Current & Anderson Hills & \\ \hline 426 20-Aug & Wednesday & Savings & New Account & $400.00New & Delhi & \\ \hline 42120 -Aug & Wednesday & Savings & New Account & $500.00New & Anderson Hills & \\ \hline 428 20-Aug & Wednesday & Checking & New Account & $2,510.00New & Anderson Hills & \\ \hline & Data & + & & & & \\ \hline \end{tabular} Q185 \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & c & D & E & 6 \\ \hline 9-Aug & Saturday & Checking & New Account & $230.00 New & Bive Ash \\ \hline 9-Aug & Saturday & Savings & Withdrawal & $1,300.00 Current & Anderson Hillis \\ \hline 9-Aug & Saturday & IRA & Current Contributiol & $1.500.00 Current & Anderson Hills \\ \hline 9-Aug & Saturday & IRA & Current Contributiol & $3,400,00 Current & Dehi \\ \hline 9-Aug & Saturday & Checking & Deposit & $3.530.00 Current & Anderson Hills \\ \hline 9-Aug & Saturday & Checking & Deposit & $710.00 Current & Delhi \\ \hline 9-Aug & Saturday & Checking & Withdrawal & $200,00 Current & Anderson Hills \\ \hline 9.Aug & Saturday & Checking & Deposit & $120.00 Current & Anderson hills \\ \hline 9-Aug & Saturday & Certificate of Deposit & New & $44,90000 Current & Delh \\ \hline 11-Aug & Monday & Savings & New Account & $100.00 New & Anderson Hills \\ \hline 11-Aug & Monday & Savings & New Account & $2.000.00New & Delhi \\ \hline 11-Aug & Monday & Savings & New Account & $2,100,00New & Anderson Hills \\ \hline 11 -Aug & Monday & Savings & New Account & $70000 New & Bive Ast \\ \hline 11-Aug & Monday & Checking & New Account & $2,820,00New & Delhi \\ \hline 711 -Aug & Monday & Checking & New Account & $3.29000 New & Delhi \\ \hline 11-Aug & Monday & Certificate of Deposit & New Account & $51,300,00 New & Anderson Hills \\ \hline 11-Aug & Monday & Certificate of Deposit & New Account & $6,600.00New & Blue Ash \\ \hline 11-Aug & Monday & Certificate of Deposit & New Account & $29,000,00 New & Blue Ast \\ \hline 31 11-Aug & Monday & Certificate of Deposit & New Account & $20,400 00 New & Bive Ash \\ \hline 211 -Aug & Monday & Savings & Deposit & $2,700,00 Current & Delh \\ \hline 11-Aug & Monday & Savings & Deposit & $2.200.00 Current & Anderson Hills \\ \hline 34 11-Aug & Monday & Savings & Deposit & $900.00 Current & Blue Ash \\ \hline 5 11-Aug & Monday & Savings & Deposit & $300 00 Current & Anderson Hills \\ \hline 6. 11-Aug & Monday & Savings & Deposit & $2.700.00 Current & Delhi \\ \hline 17 11-Aug & Monday & Savings & Deposit & $70000 Current & Delhi \\ \hline 11-Aug & Monday & Savings & Deposit & $1,50000 Current & Dehi \\ \hline 9 11-Aug & Monday & Savings & Withdrawal & $1,100,00 Current & Blue Ash \\ \hline 11-Aug & Monday & Savings & Deposit & $300 00 Current & Blue Ast \\ \hline 11-Aug11-Aug & Monday & Savings & Deposit & $600,00 Current & Delin \\ \hline 11-Aug4)11-Aug & MondayMonday & IRAIRA & Current Contributior & $1,100.00 Current & Blue Ash \\ \hline ... & Data & ++IRA & Current Contributioi & $3,100,00 Cument & Anderson Hills \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & c & D & E & \\ \hline 18-Aug & Monday & IRA & Current Contributio & $1,300.00 Current & Anderson Hills \\ \hline 18-Aug & Monday & IRA & New Account & $6,400.00 Current & Blue Ash \\ \hline 18-Aug & Monday & Checking & Withdrawal & $430.00 Current & Anderson Hills \\ \hline 18-Aug & Monday & Checking & Deposit & $280.00 Current & Anderson Hills \\ \hline 18 Aug & Monday & Checking & Deposit & $800.00 Current & Blue Ash \\ \hline 18 Aug & Monday & Cheoking & Deposit & $140.00 Current & Anderson Hills \\ \hline 73 18-Aug & Monday & Checking & Deposit & $130.00 Current & Blue Ash \\ \hline 14. 18-Aug & Monday & Checking & Withdrawal & $810.00 Current & Anderson Hills \\ \hline 5 18-Aug & Monday & Checking & Deposit & $510.00 Current & Delhi \\ \hline to 18 -Aug & Monday & Checking & Deposit & $650.00 Current & Anderson Hills \\ \hline 7) 18-Aug & Monday & Checking & Deposit & $420.00 Current & Anderson Hills \\ \hline 13 19-Aug & Tuesday & Savings & New Account & $2,700,00 New & Blue Ash \\ \hline 9 19-Aug & Tuesday & Savings & New Account & $900.00 New & Blue Ash \\ \hline 10 19-Aug & Tuesday & Savings & New Account & $700.00 New & Blue Ash \\ \hline 19-Aug & Tuesday & Savings & New Account & $1,200,00New & Anderson Hills \\ \hline 32 19-Aug & Tuesday & Checking & New Account & $2,590,00 New & Blue Ash \\ \hline 283 19-Aug & Tuesday & Cheoking & New Account & $910,00New & Anderson Hills \\ \hline 784 19-Aug & Tuesday & Checking & New Account & $2,920,00New & Anderson Hills \\ \hline 385 19-Aug & Tuesday & Checking & New Account & $260.00 New & Anderson Hills \\ \hline 86 19-Aug & Tuesday & Checking & New Account & $120.00New & Blue Ash \\ \hline 87 19-Aug & Tuesday & Checking & New Account & $2,900,00 New & Anderson Hills \\ \hline 88 19-Aug & Tuesday & Checking & New Account & $330.00New & Anderson Hills \\ \hline 189 19-Aug & Tuesday & Checking & New Account & $530.00New & Anderson Hills \\ \hline 990 19-Aug & Tuesday & Certificate of Deposit & New Account & $21,100,00New & Anderson Hills \\ \hline 391 19-Aug & Tuesday & Certificate of Deposit & New Account & $43,300,00New & Anderson Hills \\ \hline 392 19-Aug & Tuesday & Certificate of Deposit & New Account & $35,600,00New & Anderson Hills \\ \hline 93 19-Aug & Tuesday & Certificate of Deposit & New Account & $54,700.00New & Blue Ash \\ \hline 194 19-Aug & Tuesday & Certificate of Deposit & New Account & $17,900,00 New & Delhi \\ \hline 95 19-Aug & Tuesday & Certificate of Deposit & New Account & $28,900,00New & Anderson Hills \\ \hline 396 19-Aug & Tuesday & Certificate of Deposit & New Account & $59,400,00 New & Blue Ash \\ \hline 397 19-Aug & Tuesday & Certificate of Deposit & New Account & $24,500,00 New & Delhi \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & c & D & E & 6 \\ \hline 1. Aug & Friday & Certificate of Deposit & New & $58,800,00 Current & Anderson fills \\ \hline 1. Aug & Friday & Certificate of Deposit & New & 358,400,00 Current & Anderson Hills \\ \hline 1. Aug & Friday & Certificate of Deposit & New & $25,200,00 Current & Anderson Hills \\ \hline 2Aug & Saturday & Savings & New Account & $2,200.00New & Anderson Hills \\ \hline 2-Aug & Saturday & Savings & New Account & $1,100,00New & Dehi \\ \hline 2-Aug & Saturday & Checking & New Account & $130.00New & Delhi \\ \hline 2-Aug & Saturday & Checking & New Ascount & $840.00Nen & Anderson Hills \\ \hline 2-Aug & Saturday & Certificate of Deposit & New Account & $16,300,00New & Dekhi \\ \hline 2-Aug & Saturday & Certificate of Deposit & New Account & 38,400.00New & Bue Ash \\ \hline 2-Aug & Saturday & Savings & Withdrawal & $1,150.00 Current & Anderson Hills \\ \hline 2.Aug & Saturday & Savings & Withdrawal & $250.00 Current & Delhi \\ \hline 2. Aug & Saturday & Savings & Deposit & $1,300,00 Current & Anderson Hills \\ \hline 2-Aug & Saturday & Savings & Deposit & $800.00 Current & Delhi \\ \hline 1 2.Aug & Saturday & Checking & Deposit & $3,880.00 Current & Anderson Hills \\ \hline 52 Aug & Saturday & Checking & Deposit & $810.00 Current & Anderson Hills \\ \hline 2-Aug & Saturday & Checking & Withdrawal & $775.00 Current & Bive Ash \\ \hline 4. Aug & Monday & Savings & New Account & $1,900.00New & Anderson Hls \\ \hline 4. Aug & Monday & Savings & New Account & $1,400.00New & Delhi \\ \hline 4.Aug & Monday & IRA & New Account & $4,000.00New & Blue Ash \\ \hline 4.Aug & Monday & Checking & New Account & $320.00New & Anderson fills \\ \hline 4. Aug & Monday & Checking & New Account & $3,030,00New & Bue Ash \\ \hline 4. Aug & Monday & Checking & New Account & $150.00New & Blue Ash \\ \hline 4.Aug & Monday & Checking & New Account & $850.00New & Dehi \\ \hline S4 Aug & Monday & Checking & New Account & 3850.00New & Delhi \\ \hline 4-Aug & Monday & Checking & New Account & $670.00New & Anderson Hl 's \\ \hline 6. Aug & Monday & Checking & New Account & 33,780.00New & Anderson tills \\ \hline 4. Aug & Monday & Checking & New Account & $250.00New & Anderson Hills \\ \hline 4.Aug & Monday & Certificate of Deposit & New Account & $18,100.00New & Anderson Hills \\ \hline 4.Aug4.Aun & Monday & Certificate of Deposit & New Account & $47,200.00New & Delhi \\ \hline 4.Augis-Aug & MondayMonday & CertificateofDepositCertificateofDasosit & New Account & $28,900,00 New & Anderson Hills \\ \hline oney & Dats & Centificate of Deposit & New Account & $45,200.00New & Anderson Hils \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & c & D & F & G \\ \hline 234ug & Saturday & Savings & New Account & $700.00New & Blue Ash \\ \hline 23-Aug & Saturday & Savings & New Account & $2,800.00New & Anderson Hills \\ \hline 23-Aug & Saturday & Checking & New Account & $110.00NeW & Anderson Hills \\ \hline 23 -4ug & Saturday & Checking & New Account & $270.00New & Anderson Hills \\ \hline 23-Aug & Saturday & Certificate of Deposit & New Account & $47,300.00New & Anderson Hills \\ \hline 23406 & Saturday & Savings & Withdrawal & $3,000,00 Current & Anderson Hills \\ \hline 23-Aug & Saturday & Savings & Deposit & $1,000.00 Current & Blue Ash \\ \hline 234ug & Saturday & Savings & Deposit & $1,900.00 Current & Delhi \\ \hline 23 Aug & Saturday & IRA & Current Contributiol & $3,100,00 Current & Delhi \\ \hline 23-Aug & Saturday & Checking & Deposit & $790.00 Current & Delhi \\ \hline & Saturday & Checking & Withdrawal & $3,770.00 Current & Blue Ash \\ \hline 23.Aug & Saturday & Checking & Deposit & $3,460.00 Current & Anderson Hills \\ \hline 23409 & Saturday & Checking & Withdrawal & $40.00 Current & Delhi \\ \hline 234 Aug & Saturday & Checking & Withdrawal & $2,670,00 Current & Anderson Hills \\ \hline 23-Aug & Saturday & Checking & Deposit & $800.00 Current & Anderson Hills \\ \hline 25Aug & Monday & Savings & New Account & $500.00New & Anderson Hills \\ \hline 25-Avg & Monday & Savings & New Account & $2,900.00New & Blue Ash \\ \hline 25-Aug & Monday & Savings & New Account & $1,600.00New & Blue Ash \\ \hline 25-Aug & Monday & Savings & New Account & $500.00New & Blue Ash \\ \hline 254ug & Monday & Savings & New Account & $1,000,00New & Anderson Hills \\ \hline 25 Aug & Monday & Savings & New Account & $1,100.00New & Anderson Hills \\ \hline 2254ug & Monday & IRA & New Account & $3,400,00New & Blue Ash \\ \hline 4325 -4ug & Monday & Checking & New Account & $710.00New & Anderson Hills \\ \hline 1425Aug & Monday & Checking & New Account & $740.00New & Blue Ash \\ \hline 15 25-Aug & Monday & Checking & New Account & $430,00New & Delhi \\ \hline - 25-Aug & Monday & Checking & New Account & $890.00New & Anderson Hills \\ \hline 25-Aug & Monday & Certificate of Deposit & it New Account & $35,900.00New & Anderson Hills \\ \hline \& 25-Aug & Monday & Certificate of Deposit & it New Account & $55,100.00 New & Delhi \\ \hline 19 25-Aug & Monday & Certificate of Deposit & it New Account & $22,500,00New & Anderson Hills \\ \hline 25 Aug & Monday & Certificate of Deposit & it New Account & $23,600.00New & Blue Ash \\ \hline 25-Aug & Monday & Savings & Deposit & $2,900,00 Current & Anderson Hills \\ \hline+8 & Data & + & & & \\ \hline \end{tabular} File Home Insert Draw Page Layout Formulas Data Review View Automate Help Q185 :xfx \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & C & D & F & G \\ \hline 92 5-Aug & Tuesday & Savings & Deposit & $1,500,00 Current & Anderson Hills \\ \hline 93 5-Aug & Tuesday & Savings & Withdrawal & $2,300,00 Current & Blue Ash \\ \hline 94 5-Aug & Tuesday & Savings & Deposit & $1,100,00 Current & Anderson Hills \\ \hline 95 5-Aug & Tuesday & Savings & Deposit & $800.00 Current & Delhi \\ \hline 5-Aug & Tuesday & Savings & Withdrawal & $800.00 Current & Blue Ash \\ \hline 97 5-Aug & Tuesday & IRA & New Account & $3,500.00 Current & Blue Ash \\ \hline 98 5-Aug & Tuesday & IRA & Current Contributiol & $1,300.00 Current & Anderson Hills \\ \hline 99 5-Aug & Tuesday & IRA & New Account & $2,700,00 Current & Blue Ash \\ \hline 100 5-Aug & Tuesday & Checking & Deposit & $3,840.00 Current & Anderson Hills \\ \hline 101 5-Aug & Tuesday & Checking & Withdrawal & $810.00 Current & Anderson Hills \\ \hline 102 5-Aug & Tuesday & Checking & Deposit & $190.00 Current & Anderson Hills \\ \hline 103 5-Aug & Tuesday & Checking & Deposit & $2,610.00 Current & Anderson Hills \\ \hline 104 5-Aug & Tuesday & Checking & Withdrawal & $410.00 Current & Anderson Hills \\ \hline 5 5-Aug & Tuesday & Checking & Deposit & $210.00 Current & Delhi \\ \hline 66 -Aug & Tuesday & Checking & Deposit & $2,820,00 Current & Anderson Hills \\ \hline 07 5-Aug & Tuesday & Checking & Withdrawal & $380.00 Current & Delhi \\ \hline 108 5-Aug & Tuesday & Checking & Deposit & $890.00 Current & Anderson Hills \\ \hline 109 5-Aug & Tuesday & Checking & Deposit & $150.00 Current & Delhi \\ \hline 110 5-Aug & Tuesday & Checking & Withdrawal & $210.00 Current & Anderson Hills \\ \hline 111 5-Aug & Tuesday & Checking & Withdrawal & $360.00 Current & Anderson Hills \\ \hline 112 5-Aug & Tuesday & Certificate of Deposit & New & $16,400.00 Current & Blue Ash \\ \hline 113 6-Aug & Wednesday & Savings & New Account & $200.00NeW & Anderson Hills \\ \hline 114 6-Aug & Wednesday & Checking & New Account & $750.00New & Delhi \\ \hline 115 6-Aug & Wednesday & Checking & New Account & $660.00New & Anderson Hills \\ \hline 116 6-Aug & Wednesday & Checking & New Account & $3,700.00New & Delhi \\ \hline 117 6-Aug & Wednesday & Checking & New Account & $950.00New & Anderson Hills \\ \hline 118 6-Aug & Wednesday & Checking & New Account & $790.00New & Anderson Hills \\ \hline 119 6-Aug & Wednesday & Certificate of Deposit & it New Account & $3,200.00New & Anderson Hills \\ \hline 120 6-Aug & Wednesday & Certificate of Deposit & it New Account & $12,500.00New & Delhi \\ \hline 121 6-Aug & Wednesday & Certificate of Deposit & it New Account & $19,000.00New & Delhi \\ \hline 122 6-Aug & Wednesday & Certificate of Deposit & it New Account & $10,200.00NeW & Delhi \\ \hline & Data & & & & \\ \hline \end{tabular} Ready 2x Accessibility, Investigate

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

Management Accounting Principles And Applications

Authors: Hugh Coombs, D Ellis Jenkins, David Hobbs

1st Edition

1412908434, 978-1412908436

More Books

Students also viewed these Accounting questions

Question

=+2. Identify potential shortcomings.

Answered: 1 week ago