Business, 25.02.2020 22:52, helo55

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 trans-action 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.

Below is the file. please show how you came about the answer.

Date Day of Week Account Type Amount Customer Branch
1-Aug Friday Savings New Account 3000 New Anderson Hills
1-Aug Friday Checking New Account 380 New Blue Ash
1-Aug Friday Checking New Account 3070 New Anderson Hills
1-Aug Friday Checking New Account 3560 New Blue Ash
1-Aug Friday Checking New Account 620 New Anderson Hills

Answers: 3

Show answers

Other questions on the subject: Business

Business, 22.06.2019 07:20, tynyiaawrightt

Go follow my instagram atx_humberto

Answers: 2

continue

Business, 22.06.2019 14:50, keishadawson

The following information is needed to reconcile the cash balance for gourmet catering services. * a deposit of $5,600 is in transit. * outstanding checks total $1,000. * the book balance is $6,400 at february 28, 2019. * the bookkeeper recorded a $1,800 check as $17,200 in payment of the current month's rent. * the bank balance at february 28, 2019 was $17,410. * a deposit of $400 was credited by the bank for $4,000. * a customer's check for $3,300 was returned for nonsufficient funds. * the bank service charge is $90. what was the adjusted book balance?

Answers: 1

continue

Business, 22.06.2019 16:10, boogerbuttday

Omnidata uses the annualized income method to determine its quarterly federal income tax payments. it had $100,000, $50,000, and $90,000 of taxable income for the first, second, and third quarters, respectively ($240,000 in total through the first three quarters). what is omnidata's annual estimated taxable income for purposes of calculating the third quarter estimated payment?

Answers: 1

continue

Business, 22.06.2019 21:20, danielahumajova6

In a market economy, supply and demand are important because theya. (i) play a critical role in the allocation of the economy's scarce resources. b. (ii) determine how much of each good gets produced. c. (iii) can be used to predict the impact on the economy of various events and policies. d. all of (i), (ii), and (iii) are correct.

Answers: 3

continue

Do you know the correct answer?

The People’s Choice Bank is a small community bank that has three local branches, in Blue Ash, Delhi...