excel question 2

Bayhawks22

Week2ExcelAssignment11.xlsx

Home >Reading homework help >excel question 2

Instructions

BANK INFO

On Bank Info- Account Data

Add new column after Branch Number called "Branch Location"

Use Vlookup to add Bracnh Location to the new column (from Bank Info-Branch Locations tab)

Use Sumif formula to calculate Total Amount for each Branch Location

Question- which customers did more in Total Amount- New or Exisiting?

TEA SALES

Spend some time cleaning up the data (formating cells, columns, etc)

Make two new tabs making copies of this data set and label Tea Sales- Pivot Tables and Tea Sales-Charts

Tea Sales- Pivot Tables

Pivot Table to show Tea Sales by State sort in descending order of sales

Pivot Table to show Tea Sales by Product sort in alpha order

Pivot Table to show Tea Sales by Month

Pivot Table to show Tea Sales by Product by Month

Tea Sales- Charts

Create Pie Chart to show Tea Sales by Product

Create Bar Chart to show Tea Sales by State

Create a Line Chart to show Tea Sales by Month

Amort Schedule

Create amortization schedule using the template and data provided

Bank Info- Account Data

Date	Day of Week	Amount	Account Type	Opened By	Branch Number	Customer Type
4/1/19	Friday	5,000	IRA	New Accts	100	Existing
4/1/19	Friday	500	Checking	New Accts	101	Existing
4/1/19	Friday	11,779	CD	Teller	102	New
4/1/19	Friday	50,000	Savings	New Accts	104	Existing
4/1/19	Friday	12,438	Checking	New Accts	100	Existing
4/1/19	Friday	11,957	Checking	New Accts	100	Existing
4/1/19	Friday	14,571	CD	Teller	100	New
4/1/19	Friday	15,000	CD	New Accts	100	Existing
4/1/19	Friday	5,879	Checking	New Accts	100	Existing
4/1/19	Friday	4,000	Savings	New Accts	100	Existing
4/1/19	Friday	12,962	Checking	Teller	100	Existing
4/1/19	Friday	500	Checking	New Accts	100	New
4/1/19	Friday	5,364	Checking	Teller	102	New
4/1/19	Friday	16,000	CD	New Accts	104	New
4/1/19	Friday	13,061	Checking	Teller	100	New
4/2/19	Saturday	4,995	Checking	New Accts	100	New
4/2/19	Saturday	10,096	Savings	New Accts	105	New
4/2/19	Saturday	14,861	Savings	New Accts	100	New
4/2/19	Saturday	500	Checking	Teller	100	New
4/2/19	Saturday	5,524	Checking	New Accts	100	Existing
4/2/19	Saturday	12,592	Savings	Teller	102	Existing
4/2/19	Saturday	9,208	Checking	Teller	104	Existing
4/2/19	Saturday	14,480	Checking	Teller	100	New
4/4/19	Monday	9,000	CD	Teller	205	Existing
4/4/19	Monday	5,538	Savings	New Accts	100	Existing
4/4/19	Monday	12,953	Savings	Teller	100	Existing
4/4/19	Monday	4,348	Savings	Teller	105	Existing
4/4/19	Monday	11,000	CD	New Accts	100	New
4/4/19	Monday	3,000	Checking	New Accts	100	Existing
4/4/19	Monday	9,095	IRA	Teller	100	Existing
4/4/19	Monday	240	Checking	New Accts	100	Existing
4/4/19	Monday	4,309	Savings	Teller	205	Existing
4/4/19	Monday	4,000	Checking	New Accts	205	Existing
4/4/19	Monday	6,000	Savings	New Accts	100	Existing
4/4/19	Monday	13,000	CD	New Accts	100	Existing
4/4/19	Monday	13,519	CD	New Accts	100	New
4/4/19	Monday	500	Checking	Teller	100	Existing
4/4/19	Monday	14,548	CD	New Accts	100	Existing
4/4/19	Monday	240	Checking	New Accts	100	Existing
4/4/19	Monday	35,000	CD	New Accts	100	Existing
4/5/19	Tuesday	7,770	CD	New Accts	100	Existing
4/5/19	Tuesday	7,839	CD	Teller	100	Existing
4/5/19	Tuesday	1,000	Checking	New Accts	205	Existing
4/5/19	Tuesday	7,434	Checking	Teller	100	Existing
4/5/19	Tuesday	3,000	Checking	New Accts	100	New
4/5/19	Tuesday	8,456	CD	Teller	205	Existing
4/5/19	Tuesday	11,135	CD	New Accts	100	Existing
4/5/19	Tuesday	11,761	CD	New Accts	100	New
4/5/19	Tuesday	3,715	Checking	New Accts	100	Existing
4/5/19	Tuesday	4,231	Checking	Teller	100	New
4/5/19	Tuesday	100	Checking	New Accts	102	Existing
4/5/19	Tuesday	3,644	Checking	New Accts	104	Existing
4/5/19	Tuesday	5,701	Savings	Teller	100	New
4/5/19	Tuesday	3,559	Savings	Teller	100	Existing
4/5/19	Tuesday	12,000	CD	Teller	105	Existing
4/5/19	Tuesday	10,135	Savings	Teller	105	New
4/6/19	Wednesday	400	Checking	Teller	105	Existing
4/6/19	Wednesday	6,762	Savings	New Accts	105	Existing
4/6/19	Wednesday	5,000	CD	New Accts	104	New
4/6/19	Wednesday	7,342	Checking	New Accts	100	Existing
4/6/19	Wednesday	11,828	CD	New Accts	100	New
4/6/19	Wednesday	100	Checking	New Accts	100	Existing
4/6/19	Wednesday	13,669	CD	Teller	100	New
4/6/19	Wednesday	13,574	Savings	New Accts	100	New
4/6/19	Wednesday	8,371	Savings	Teller	102	New
4/6/19	Wednesday	200	Savings	Teller	104	Existing
4/6/19	Wednesday	5,221	Checking	Teller	100	New
4/6/19	Wednesday	15,208	CD	New Accts	105	Existing
4/6/19	Wednesday	10,219	Checking	New Accts	100	Existing
4/6/19	Wednesday	124	Checking	Teller	100	Existing
4/6/19	Wednesday	90,000	CD	New Accts	100	Existing
4/7/19	Thursday	11,000	CD	New Accts	205	New
4/7/19	Thursday	11,594	CD	Teller	100	New
4/7/19	Thursday	4,000	Checking	New Accts	100	New
4/7/19	Thursday	5,282	Checking	Teller	100	Existing
4/7/19	Thursday	14,974	Checking	Teller	100	Existing
4/7/19	Thursday	13,390	Savings	New Accts	102	New
4/7/19	Thursday	600	Savings	New Accts	104	Existing
4/7/19	Thursday	8,000	Savings	Teller	100	Existing
4/7/19	Thursday	13,000	CD	New Accts	100	Existing
4/7/19	Thursday	13,428	CD	New Accts	100	Existing
4/7/19	Thursday	6,202	Savings	Teller	100	Existing
4/7/19	Thursday	9,009	Checking	Teller	100	New
4/7/19	Thursday	400	Checking	New Accts	205	Existing
4/7/19	Thursday	13,519	CD	New Accts	100	Existing
4/7/19	Thursday	13,903	CD	New Accts	100	Existing
4/7/19	Thursday	5,000	Savings	New Accts	100	New
4/7/19	Thursday	7,865	Checking	Teller	100	New
4/7/19	Thursday	240	Checking	New Accts	205	Existing
4/7/19	Thursday	100	Checking	New Accts	100	Existing
4/7/19	Thursday	14,548	CD	New Accts	100	Existing
4/7/19	Thursday	4,000	Savings	New Accts	100	Existing
4/7/19	Thursday	15,703	CD	New Accts	100	Existing
4/7/19	Thursday	16,000	CD	New Accts	100	New
4/7/19	Thursday	17,000	CD	Teller	100	Existing
4/7/19	Thursday	2,749	Checking	New Accts	100	New
4/7/19	Thursday	3,000	Checking	New Accts	100	Existing
4/7/19	Thursday	11,721	Savings	New Accts	100	New
4/7/19	Thursday	35,000	CD	New Accts	100	Existing
4/8/19	Friday	9,000	IRA	New Accts	105	Existing
4/8/19	Friday	8,915	Savings	New Accts	105	New
4/8/19	Friday	4,853	Savings	New Accts	100	Existing
4/8/19	Friday	3,434	Checking	New Accts	100	Existing
4/8/19	Friday	4,000	Checking	New Accts	205	Existing
4/8/19	Friday	8,815	Savings	Teller	205	Existing
4/8/19	Friday	1,000	Checking	New Accts	205	New
4/8/19	Friday	6,000	Savings	New Accts	100	New
4/8/19	Friday	4,635	Checking	New Accts	100	Existing
4/8/19	Friday	8,093	Checking	Teller	100	New
4/8/19	Friday	100	Checking	New Accts	100	Existing
4/8/19	Friday	14,475	Savings	Teller	100	Existing
4/8/19	Friday	9,154	CD	New Accts	100	Existing
4/8/19	Friday	10,097	CD	Teller	100	Existing
4/8/19	Friday	12,516	Checking	New Accts	100	Existing
4/11/19	Monday	500	Checking	Teller	100	Existing
4/11/19	Monday	9,877	Savings	New Accts	205	Existing
4/11/19	Monday	4,915	Checking	Teller	100	New
4/11/19	Monday	7,316	Savings	Teller	105	New
4/11/19	Monday	4,295	Checking	Teller	100	New
4/11/19	Monday	5,097	CD	New Accts	100	New
4/11/19	Monday	9,624	Checking	Teller	100	Existing
4/11/19	Monday	5,360	CD	Teller	100	Existing
4/11/19	Monday	8,552	Savings	Teller	100	New
4/11/19	Monday	13,494	Savings	New Accts	100	New
4/11/19	Monday	12,932	Savings	Teller	205	Existing
4/11/19	Monday	3,000	Checking	New Accts	100	Existing
4/11/19	Monday	500	Checking	New Accts	100	Existing
4/11/19	Monday	4,000	Checking	New Accts	100	Existing
4/11/19	Monday	10,181	CD	Teller	100	New
4/11/19	Monday	10,751	CD	New Accts	100	Existing
4/11/19	Monday	10,190	Checking	Teller	100	Existing
4/11/19	Monday	5,116	Checking	Teller	100	New
4/11/19	Monday	13,000	CD	New Accts	100	Existing
4/11/19	Monday	6,000	Savings	New Accts	100	Existing
4/11/19	Monday	240	Checking	New Accts	100	Existing
4/11/19	Monday	5,366	Savings	Teller	100	New
4/11/19	Monday	9,095	IRA	New Accts	100	Existing
4/11/19	Monday	13,519	CD	New Accts	100	New
4/12/19	Tuesday	5,761	Savings	Teller	100	Existing
4/12/19	Tuesday	100	Checking	New Accts	100	Existing
4/12/19	Tuesday	100	Checking	New Accts	100	New
4/12/19	Tuesday	5,000	CD	New Accts	100	Existing
4/12/19	Tuesday	8,613	CD	New Accts	100	New
4/12/19	Tuesday	4,540	Checking	New Accts	100	Existing
4/12/19	Tuesday	400	Checking	New Accts	205	New
4/12/19	Tuesday	11,931	Savings	Teller	100	Existing
4/12/19	Tuesday	12,006	CD	Teller	100	Existing
4/12/19	Tuesday	400	Checking	Teller	100	Existing
4/12/19	Tuesday	1,325	Checking	New Accts	100	New
4/12/19	Tuesday	17,000	CD	Teller	100	Existing
4/12/19	Tuesday	124	Checking	Teller	100	Existing
4/12/19	Tuesday	3,000	Checking	New Accts	100	Existing
4/13/19	Wednesday	6,190	CD	Teller	100	New
4/13/19	Wednesday	2,749	Checking	New Accts	100	Existing
4/13/19	Wednesday	19,000	Savings	New Accts	100	New
4/13/19	Wednesday	9,095	IRA	New Accts	100	Existing
4/13/19	Wednesday	12,000	Checking	New Accts	100	Existing
4/13/19	Wednesday	6,000	Savings	New Accts	100	Existing
4/13/19	Wednesday	12,535	CD	New Accts	108	Existing
4/13/19	Wednesday	8,000	Savings	New Accts	100	Existing
4/13/19	Wednesday	500	Checking	New Accts	100	Existing
4/13/19	Wednesday	4,000	Checking	New Accts	100	Existing
4/13/19	Wednesday	500	Checking	New Accts	100	Existing
4/13/19	Wednesday	5,723	Savings	Teller	100	New
4/13/19	Wednesday	8,000	Savings	New Accts	100	Existing
4/13/19	Wednesday	16,000	CD	New Accts	105	Existing
4/13/19	Wednesday	5,245	Savings	New Accts	100	Existing
4/13/19	Wednesday	6,000	Savings	New Accts	100	Existing
4/13/19	Wednesday	9,095	IRA	New Accts	100	Existing
4/13/19	Wednesday	7,289	Checking	New Accts	205	New
4/13/19	Wednesday	6,000	Savings	New Accts	100	Existing
4/14/19	Thursday	10,795	CD	Teller	100	Existing
4/14/19	Thursday	13,899	Checking	Teller	100	Existing
4/14/19	Thursday	11,217	Checking	Teller	100	Existing
4/14/19	Thursday	12,519	CD	Teller	100	Existing
4/14/19	Thursday	10,122	Checking	New Accts	100	Existing
4/14/19	Thursday	7,649	Savings	Teller	100	New
4/14/19	Thursday	7,342	Checking	New Accts	100	Existing
4/14/19	Thursday	3,949	Savings	New Accts	100	New
4/14/19	Thursday	600	Savings	New Accts	100	Existing
4/14/19	Thursday	15,208	CD	New Accts	108	New
4/14/19	Thursday	10,862	Savings	New Accts	100	New
4/14/19	Thursday	200	Savings	New Accts	100	Existing
4/14/19	Thursday	6,676	Savings	Teller	100	New
4/14/19	Thursday	6,762	Savings	New Accts	100	Existing
4/15/19	Friday	3,434	Checking	New Accts	100	Existing
4/15/19	Friday	4,000	Savings	New Accts	105	Existing
4/15/19	Friday	5,879	Checking	New Accts	108	Existing
4/15/19	Friday	11,489	Checking	Teller	108	Existing
4/15/19	Friday	14,706	Checking	New Accts	108	New
4/15/19	Friday	12,908	Checking	Teller	100	Existing
4/15/19	Friday	8,133	CD	Teller	100	New
4/15/19	Friday	10,368	Checking	Teller	100	Existing
4/15/19	Friday	10,071	Checking	Teller	100	New
4/15/19	Friday	14,611	Savings	New Accts	100	Existing
4/15/19	Friday	100	Checking	New Accts	100	Existing
4/15/19	Friday	1,000	Checking	New Accts	100	Existing
4/15/19	Friday	8,920	Savings	Teller	100	New
4/15/19	Friday	10,273	Checking	Teller	100	New
4/15/19	Friday	14,473	Checking	Teller	100	Existing
4/15/19	Friday	9,940	CD	New Accts	100	New
4/15/19	Friday	10,177	CD	New Accts	100	New
4/15/19	Friday	9,800	Checking	Teller	100	Existing
4/15/19	Friday	11,984	Checking	New Accts	108	Existing
4/15/19	Friday	5,156	Checking	New Accts	108	New
4/15/19	Friday	14,189	CD	Teller	100	New
4/18/19	Monday	10,141	Savings	New Accts	100	Existing
4/18/19	Monday	4,542	CD	Teller	100	New
4/18/19	Monday	9,098	Savings	New Accts	100	New
4/18/19	Monday	8,940	CD	Teller	100	Existing
4/18/19	Monday	13,000	CD	New Accts	100	Existing
4/18/19	Monday	5,589	Savings	New Accts	100	New
4/18/19	Monday	4,000	Checking	New Accts	100	Existing
4/18/19	Monday	10,365	Savings	Teller	105	Existing
4/18/19	Monday	13,519	CD	New Accts	105	Existing
4/18/19	Monday	200	Checking	New Accts	105	Existing
4/19/19	Tuesday	3,000	CD	Teller	100	Existing
4/19/19	Tuesday	3,000	Checking	New Accts	100	Existing
4/19/19	Tuesday	5,000	Savings	New Accts	100	Existing
4/19/19	Tuesday	9,000	IRA	New Accts	100	Existing
4/19/19	Tuesday	10,768	CD	New Accts	108	New
4/19/19	Tuesday	6,394	Savings	New Accts	100	New
4/19/19	Tuesday	240	Checking	New Accts	108	Existing
4/19/19	Tuesday	6,000	Savings	New Accts	100	Existing
4/19/19	Tuesday	40,599	Savings	New Accts	100	Existing
4/19/19	Tuesday	14,851	Savings	Teller	100	Existing
4/19/19	Tuesday	7,258	Savings	New Accts	100	Existing
4/19/19	Tuesday	13,000	CD	New Accts	100	Existing
4/19/19	Tuesday	240	Checking	New Accts	100	Existing
4/19/19	Tuesday	13,519	CD	New Accts	100	Existing
4/19/19	Tuesday	4,810	Checking	Teller	100	Existing
4/19/19	Tuesday	13,903	CD	New Accts	100	New
4/19/19	Tuesday	2,749	Checking	New Accts	100	Existing
4/19/19	Tuesday	4,635	Checking	New Accts	100	Existing
4/19/19	Tuesday	4,000	Checking	New Accts	100	Existing
4/19/19	Tuesday	8,000	Savings	Teller	100	Existing
4/19/19	Tuesday	15,703	CD	New Accts	100	Existing
4/19/19	Tuesday	4,000	Checking	New Accts	108	New
4/19/19	Tuesday	6,000	Savings	New Accts	100	Existing
4/19/19	Tuesday	10,147	Savings	New Accts	100	Existing
4/19/19	Tuesday	3,000	Checking	New Accts	100	Existing
4/19/19	Tuesday	100	Checking	New Accts	100	Existing
4/20/19	Wednesday	6,762	Savings	New Accts	100	Existing
4/20/19	Wednesday	7,970	Savings	Teller	100	Existing
4/20/19	Wednesday	7,342	Checking	New Accts	100	Existing
4/20/19	Wednesday	12,158	Checking	New Accts	100	Existing
4/20/19	Wednesday	6,761	CD	Teller	100	Existing
4/20/19	Wednesday	9,251	CD	New Accts	100	New
4/20/19	Wednesday	13,900	Savings	New Accts	100	Existing
4/20/19	Wednesday	600	Savings	New Accts	100	Existing
4/20/19	Wednesday	12,958	Checking	New Accts	105	Existing
4/20/19	Wednesday	15,208	CD	New Accts	100	Existing
4/20/19	Wednesday	2,749	Checking	New Accts	100	Existing
4/20/19	Wednesday	11,684	Savings	Teller	100	New
4/20/19	Wednesday	7,604	Checking	Teller	100	New
4/20/19	Wednesday	10,329	Savings	Teller	100	Existing
4/21/19	Thursday	4,635	Checking	New Accts	108	Existing
4/21/19	Thursday	4,000	Checking	New Accts	100	New
4/21/19	Thursday	4,000	Checking	New Accts	108	Existing
4/21/19	Thursday	3,951	Checking	New Accts	100	New
4/21/19	Thursday	10,101	Savings	Teller	100	Existing
4/21/19	Thursday	8,469	CD	New Accts	100	Existing
4/21/19	Thursday	5,680	Savings	Teller	100	Existing
4/21/19	Thursday	13,000	CD	New Accts	105	Existing
4/21/19	Thursday	3,000	Checking	New Accts	108	Existing
4/21/19	Thursday	13,519	CD	New Accts	100	Existing
4/21/19	Thursday	9,000	IRA	New Accts	100	Existing
4/22/19	Friday	5,904	Checking	New Accts	100	Existing
4/22/19	Friday	4,191	CD	Teller	100	New
4/22/19	Friday	5,586	CD	Teller	100	New
4/22/19	Friday	600	Savings	New Accts	100	Existing
4/22/19	Friday	5,943	CD	Teller	100	Existing
4/22/19	Friday	5,393	Savings	Teller	100	New
4/22/19	Friday	200	Savings	New Accts	100	Existing
4/22/19	Friday	12,789	Checking	Teller	100	New
4/22/19	Friday	30,000	Savings	New Accts	100	Existing
4/22/19	Friday	500	Checking	Teller	100	New
4/22/19	Friday	11,201	CD	New Accts	100	New
4/22/19	Friday	11,541	CD	New Accts	100	Existing
4/22/19	Friday	7,192	Savings	New Accts	100	New
4/22/19	Friday	2,749	Checking	New Accts	105	New
4/22/19	Friday	9,641	Checking	Teller	100	Existing
4/22/19	Friday	13,550	CD	New Accts	100	New
4/22/19	Friday	7,342	Checking	New Accts	100	New
4/22/19	Friday	7,167	Savings	New Accts	100	Existing
4/22/19	Friday	12,817	Checking	New Accts	100	New
4/22/19	Friday	15,208	CD	New Accts	108	Existing
4/22/19	Friday	14,433	Checking	Teller	100	Existing
4/22/19	Friday	4,562	Checking	Teller	108	New
4/25/19	Monday	3,714	CD	New Accts	100	New
4/25/19	Monday	4,010	Checking	New Accts	100	Existing
4/25/19	Monday	10,332	Checking	New Accts	105	New
4/25/19	Monday	14,693	Checking	Teller	100	Existing
4/25/19	Monday	4,518	CD	Teller	100	Existing
4/25/19	Monday	14,757	Checking	Teller	100	New
4/25/19	Monday	11,365	Savings	New Accts	100	Existing
4/25/19	Monday	7,358	Savings	Teller	100	Existing
4/25/19	Monday	3,434	Checking	New Accts	100	New
4/25/19	Monday	7,197	Checking	Teller	100	New
4/25/19	Monday	12,127	CD	Teller	100	Existing
4/25/19	Monday	6,762	Savings	New Accts	100	Existing
4/25/19	Monday	100	Checking	New Accts	100	New
4/25/19	Monday	600	Savings	New Accts	100	New
4/25/19	Monday	1,000	Checking	New Accts	100	Existing
4/25/19	Monday	13,091	CD	Teller	105	New
4/25/19	Monday	100	Checking	New Accts	100	Existing
4/25/19	Monday	10,351	Checking	Teller	100	New
4/25/19	Monday	8,894	Checking	New Accts	100	Existing
4/25/19	Monday	15,208	CD	New Accts	105	Existing
4/25/19	Monday	13,777	Checking	New Accts	100	New
4/25/19	Monday	32,000	Savings	New Accts	100	New
4/25/19	Monday	1,000	Checking	New Accts	100	Existing
4/25/19	Monday	7,955	Savings	New Accts	100	Existing
4/25/19	Monday	14,546	Savings	Teller	100	Existing
4/26/19	Tuesday	4,307	CD	New Accts	100	New
4/26/19	Tuesday	400	Checking	New Accts	100	Existing
4/26/19	Tuesday	1,325	Checking	New Accts	100	New
4/26/19	Tuesday	17,000	CD	Teller	100	Existing
4/26/19	Tuesday	124	Checking	Teller	100	Existing
4/26/19	Tuesday	400	Checking	Teller	100	Existing
4/26/19	Tuesday	13,617	Savings	Teller	100	New
4/26/19	Tuesday	12,887	Savings	Teller	100	New
4/26/19	Tuesday	100	Checking	New Accts	105	Existing
4/26/19	Tuesday	5,879	Checking	New Accts	100	New
4/26/19	Tuesday	100	Checking	New Accts	100	Existing
4/26/19	Tuesday	4,000	Savings	New Accts	100	New
4/26/19	Tuesday	90,000	CD	New Accts	105	Existing
4/27/19	Wednesday	8,264	CD	Teller	100	Existing
4/27/19	Wednesday	1,000	Checking	New Accts	100	Existing
4/27/19	Wednesday	3,434	Checking	New Accts	100	Existing
4/27/19	Wednesday	4,566	Checking	Teller	100	New
4/27/19	Wednesday	100	Checking	New Accts	100	Existing
4/27/19	Wednesday	13,428	CD	Teller	100	Existing
4/27/19	Wednesday	15,000	CD	New Accts	100	Existing
4/27/19	Wednesday	10,587	Savings	New Accts	100	New
4/28/19	Thursday	3,539	Savings	New Accts	108	Existing
4/28/19	Thursday	5,879	Checking	New Accts	108	New
4/28/19	Thursday	4,000	Savings	New Accts	100	New
4/28/19	Thursday	5,302	CD	Teller	105	Existing
4/28/19	Thursday	6,314	Checking	Teller	100	Existing
4/28/19	Thursday	9,247	Savings	Teller	100	New
4/28/19	Thursday	14,548	CD	New Accts	205	Existing
4/28/19	Thursday	4,113	Savings	New Accts	100	Existing
4/28/19	Thursday	9,010	Checking	Teller	100	New
4/28/19	Thursday	240	Checking	New Accts	100	Existing
4/29/19	Friday	124	Checking	Teller	100	Existing
4/29/19	Friday	11,765	Savings	New Accts	100	Existing
4/29/19	Friday	3,500	CD	New Accts	105	New
4/29/19	Friday	9,113	CD	Teller	100	Existing
4/29/19	Friday	10,474	CD	New Accts	100	New
4/29/19	Friday	11,000	CD	New Accts	100	New
4/29/19	Friday	12,000	Checking	New Accts	100	Existing
4/29/19	Friday	13,583	CD	Teller	100	New
4/29/19	Friday	1,946	Checking	New Accts	100	New
4/29/19	Friday	90,000	CD	New Accts	100	Existing
4/29/19	Friday	1,946	Checking	New Accts	100	Existing
4/29/19	Friday	3,728	Checking	Teller	105	Existing
4/29/19	Friday	100	Checking	New Accts	105	Existing
4/29/19	Friday	1,000	Checking	New Accts	100	Existing
4/30/19	Saturday	11,632	Checking	New Accts	100	Existing
4/30/19	Saturday	6,144	CD	Teller	105	New
4/30/19	Saturday	400	Checking	Teller	105	Existing
4/1/19	Friday	10,000	CD	Teller	101	Existing
4/1/19	Friday	4,623	Savings	New Accts	101	Existing
4/1/19	Friday	15,276	Savings	New Accts	101	Existing
4/1/19	Friday	13,636	CD	New Accts	101	Existing
4/1/19	Friday	7,177	Savings	Teller	101	Existing
4/1/19	Friday	4,690	Checking	New Accts	101	New
4/1/19	Friday	5,000	Checking	New Accts	101	Existing
4/1/19	Friday	7,000	Savings	New Accts	104	New
4/1/19	Friday	7,427	Checking	New Accts	105	Existing
4/1/19	Friday	4,500	Checking	New Accts	201	New
4/1/19	Friday	14,867	Checking	Teller	101	Existing
4/1/19	Friday	45,000	CD	Teller	101	Existing
4/2/19	Saturday	5,862	Savings	Teller	101	New
4/2/19	Saturday	9,159	Checking	Teller	101	New
4/2/19	Saturday	5,756	Savings	Teller	104	Existing
4/2/19	Saturday	7,028	CD	New Accts	105	New
4/4/19	Monday	9,397	Checking	Teller	201	Existing
4/4/19	Monday	5,025	CD	New Accts	101	New
4/4/19	Monday	8,190	Savings	New Accts	101	Existing
4/4/19	Monday	6,071	Savings	Teller	101	Existing
4/4/19	Monday	12,203	CD	New Accts	101	Existing
4/4/19	Monday	250	Checking	Teller	205	New
4/4/19	Monday	4,000	Checking	New Accts	101	Existing
4/4/19	Monday	6,307	Savings	Teller	101	Existing
4/4/19	Monday	5,000	Checking	New Accts	101	Existing
4/4/19	Monday	13,000	CD	New Accts	101	New
4/4/19	Monday	13,215	Checking	Teller	101	Existing
4/4/19	Monday	14,067	CD	New Accts	101	New
4/4/19	Monday	2,878	Savings	New Accts	101	Existing
4/4/19	Monday	14,702	CD	Teller	101	New
4/4/19	Monday	50,000	CD	New Accts	101	New
4/5/19	Tuesday	5,807	CD	New Accts	101	New
4/5/19	Tuesday	4,000	Checking	Teller	101	Existing
4/5/19	Tuesday	100	Checking	New Accts	101	Existing
4/5/19	Tuesday	5,000	Checking	New Accts	205	Existing
4/5/19	Tuesday	275	Checking	Teller	101	Existing
4/5/19	Tuesday	1,000	Savings	Teller	101	Existing
4/5/19	Tuesday	3,000	Checking	New Accts	205	New
4/5/19	Tuesday	7,000	IRA	New Accts	101	Existing
4/5/19	Tuesday	13,500	CD	New Accts	104	Existing
4/5/19	Tuesday	10,612	Savings	New Accts	105	Existing
4/6/19	Wednesday	5,000	CD	New Accts	201	Existing
4/6/19	Wednesday	11,552	CD	New Accts	101	New
4/6/19	Wednesday	12,000	CD	New Accts	101	Existing
4/6/19	Wednesday	3,820	Checking	New Accts	101	Existing
4/6/19	Wednesday	10,000	IRA	Teller	101	Existing
4/6/19	Wednesday	7,000	Savings	New Accts	101	New
4/6/19	Wednesday	12,455	IRA	Teller	101	Existing
4/6/19	Wednesday	14,841	CD	Teller	101	Existing
4/6/19	Wednesday	10,056	Checking	Teller	101	New
4/6/19	Wednesday	5,000	Savings	New Accts	101	Existing
4/7/19	Thursday	4,198	CD	New Accts	101	Existing
4/7/19	Thursday	250	Savings	New Accts	101	Existing
4/7/19	Thursday	2,878	Savings	New Accts	101	Existing
4/7/19	Thursday	4,000	Checking	Teller	101	Existing
4/7/19	Thursday	7,277	IRA	New Accts	101	Existing
4/7/19	Thursday	12,000	CD	New Accts	101	Existing
4/7/19	Thursday	500	Checking	New Accts	101	Existing
4/7/19	Thursday	6,307	Savings	Teller	104	Existing
4/7/19	Thursday	245	Checking	New Accts	105	Existing
4/7/19	Thursday	14,000	CD	Teller	201	Existing
4/7/19	Thursday	500	Checking	New Accts	101	Existing
4/7/19	Thursday	4,535	Checking	New Accts	101	New
4/7/19	Thursday	4,006	Savings	New Accts	101	New
4/7/19	Thursday	10,492	Checking	New Accts	101	Existing
4/7/19	Thursday	50,000	CD	New Accts	101	Existing
4/7/19	Thursday	75,000	CD	New Accts	101	New
4/8/19	Friday	4,000	Checking	New Accts	101	Existing
4/8/19	Friday	5,570	Checking	New Accts	101	New
4/8/19	Friday	10,553	Checking	New Accts	205	New
4/8/19	Friday	4,000	Savings	New Accts	101	Existing
4/8/19	Friday	8,174	CD	New Accts	101	Existing
4/8/19	Friday	12,794	Checking	New Accts	101	Existing
4/8/19	Friday	6,674	Savings	Teller	101	New
4/8/19	Friday	4,805	Checking	New Accts	101	New
4/8/19	Friday	8,801	CD	Teller	205	New
4/8/19	Friday	12,303	CD	New Accts	101	Existing
4/11/19	Monday	12,722	Checking	Teller	101	New
4/11/19	Monday	11,935	CD	Teller	101	New
4/11/19	Monday	4,000	Checking	New Accts	101	Existing
4/11/19	Monday	2,878	Savings	New Accts	101	Existing
4/11/19	Monday	12,418	Checking	New Accts	101	Existing
4/12/19	Tuesday	3,000	CD	New Accts	101	New
4/12/19	Tuesday	6,573	Checking	New Accts	101	New
4/12/19	Tuesday	16,000	CD	New Accts	101	Existing
4/12/19	Tuesday	7,000	Savings	Teller	101	Existing
4/12/19	Tuesday	11,798	Checking	New Accts	101	New
4/12/19	Tuesday	250	Savings	Teller	101	Existing
4/13/19	Wednesday	3,525	CD	New Accts	101	Existing
4/13/19	Wednesday	10,202	CD	New Accts	101	Existing
4/13/19	Wednesday	12,000	CD	New Accts	101	Existing
4/13/19	Wednesday	12,000	CD	New Accts	101	Existing
4/13/19	Wednesday	13,500	CD	New Accts	104	Existing
4/13/19	Wednesday	13,636	CD	New Accts	105	Existing
4/13/19	Wednesday	4,000	Checking	New Accts	201	New
4/13/19	Wednesday	7,000	IRA	New Accts	101	Existing
4/13/19	Wednesday	3,596	Savings	New Accts	101	New
4/13/19	Wednesday	5,000	Checking	New Accts	104	Existing
4/13/19	Wednesday	7,882	Savings	Teller	105	New
4/13/19	Wednesday	4,357	Checking	Teller	201	Existing
4/13/19	Wednesday	75,000	CD	New Accts	101	Existing
4/13/19	Wednesday	5,000	Savings	Teller	101	Existing
4/14/19	Thursday	12,455	IRA	Teller	101	Existing
4/14/19	Thursday	13,637	Savings	New Accts	205	New
4/14/19	Thursday	5,233	Savings	New Accts	101	New
4/14/19	Thursday	14,227	Checking	Teller	101	New
4/14/19	Thursday	8,866	Checking	Teller	205	New
4/14/19	Thursday	10,000	IRA	Teller	101	Existing
4/14/19	Thursday	50,000	CD	New Accts	101	Existing
4/15/19	Friday	4,652	CD	New Accts	101	New
4/15/19	Friday	7,811	Savings	New Accts	101	Existing
4/15/19	Friday	7,165	CD	New Accts	101	New
4/15/19	Friday	4,623	Savings	New Accts	101	New
4/15/19	Friday	7,989	Savings	Teller	101	New
4/15/19	Friday	9,395	CD	New Accts	104	Existing
4/15/19	Friday	11,406	Checking	New Accts	105	New
4/15/19	Friday	9,746	Checking	Teller	201	New
4/18/19	Monday	9,936	Checking	Teller	101	Existing
4/18/19	Monday	14,587	Savings	Teller	101	Existing
4/18/19	Monday	4,857	CD	New Accts	101	New
4/18/19	Monday	5,000	CD	Teller	101	Existing
4/18/19	Monday	8,882	Checking	New Accts	101	New
4/18/19	Monday	21,000	Savings	New Accts	101	Existing
4/18/19	Monday	4,000	Checking	New Accts	101	Existing
4/18/19	Monday	4,000	Checking	Teller	101	Existing
4/19/19	Tuesday	7,884	CD	Teller	101	Existing
4/19/19	Tuesday	14,750	Savings	New Accts	101	New
4/19/19	Tuesday	11,498	CD	Teller	101	New
4/19/19	Tuesday	12,000	CD	New Accts	101	Existing
4/19/19	Tuesday	5,000	Checking	New Accts	101	Existing
4/19/19	Tuesday	12,134	Checking	Teller	101	Existing
4/19/19	Tuesday	7,000	IRA	New Accts	101	New
4/19/19	Tuesday	4,000	Savings	New Accts	101	Existing
4/19/19	Tuesday	12,903	CD	Teller	101	Existing
4/19/19	Tuesday	13,500	CD	New Accts	101	Existing
4/19/19	Tuesday	8,545	Checking	Teller	101	Existing
4/19/19	Tuesday	13,636	CD	New Accts	101	Existing
4/19/19	Tuesday	4,000	Checking	New Accts	104	New
4/19/19	Tuesday	75,000	CD	New Accts	105	Existing
4/19/19	Tuesday	5,000	Savings	New Accts	201	New
4/19/19	Tuesday	4,000	Checking	New Accts	101	Existing
4/19/19	Tuesday	2,878	Savings	New Accts	101	Existing
4/20/19	Wednesday	5,664	Savings	New Accts	101	New
4/20/19	Wednesday	7,013	Savings	New Accts	101	Existing
4/20/19	Wednesday	12,455	IRA	Teller	101	Existing
4/20/19	Wednesday	10,000	IRA	Teller	104	Existing
4/20/19	Wednesday	12,198	Savings	New Accts	105	New
4/20/19	Wednesday	6,608	Savings	Teller	201	New
4/20/19	Wednesday	75,000	CD	New Accts	101	Existing
4/20/19	Wednesday	11,801	Savings	New Accts	101	Existing
4/21/19	Thursday	11,935	Savings	New Accts	104	Existing
4/21/19	Thursday	4,000	Checking	New Accts	105	Existing
4/21/19	Thursday	6,379	Checking	Teller	201	Existing
4/21/19	Thursday	4,000	Savings	New Accts	101	Existing
4/21/19	Thursday	2,878	Savings	New Accts	101	Existing
4/21/19	Thursday	6,561	Checking	Teller	101	New
4/22/19	Friday	3,728	Checking	New Accts	101	New
4/22/19	Friday	6,314	CD	Teller	101	Existing
4/22/19	Friday	7,854	Savings	Teller	101	New
4/22/19	Friday	10,306	CD	Teller	101	Existing
4/22/19	Friday	8,042	Savings	Teller	104	Existing
4/22/19	Friday	11,898	CD	New Accts	105	New
4/22/19	Friday	12,455	CD	Teller	201	Existing
4/22/19	Friday	13,155	CD	Teller	101	Existing
4/22/19	Friday	2,000	IRA	Teller	101	New
4/22/19	Friday	5,517	Checking	Teller	101	New
4/22/19	Friday	75,000	CD	New Accts	101	Existing
4/22/19	Friday	80,000	CD	New Accts	101	New
4/25/19	Monday	8,436	Savings	New Accts	101	New
4/25/19	Monday	14,849	Savings	New Accts	101	Existing
4/25/19	Monday	5,445	Savings	New Accts	101	Existing
4/25/19	Monday	11,901	CD	Teller	104	New
4/25/19	Monday	12,500	CD	New Accts	105	New
4/25/19	Monday	12,455	IRA	Teller	201	Existing
4/25/19	Monday	11,439	Checking	New Accts	101	Existing
4/25/19	Monday	10,000	IRA	Teller	101	Existing
4/25/19	Monday	50,000	CD	New Accts	205	Existing
4/26/19	Tuesday	7,874	Savings	Teller	101	New
4/26/19	Tuesday	250	Savings	New Accts	101	Existing
4/26/19	Tuesday	4,623	Savings	New Accts	101	Existing
4/26/19	Tuesday	5,159	Savings	Teller	101	Existing
4/26/19	Tuesday	11,134	Savings	New Accts	104	Existing
4/27/19	Wednesday	12,572	Savings	New Accts	105	Existing
4/27/19	Wednesday	1,000	Checking	New Accts	201	New
4/27/19	Wednesday	7,277	IRA	New Accts	101	Existing
4/27/19	Wednesday	13,128	Savings	Teller	101	New
4/27/19	Wednesday	9,525	Savings	Teller	101	New
4/27/19	Wednesday	13,462	Checking	Teller	101	New
4/27/19	Wednesday	15,984	Savings	New Accts	101	New
4/28/19	Thursday	10,461	Savings	Teller	101	Existing
4/28/19	Thursday	7,756	CD	New Accts	205	Existing
4/28/19	Thursday	25,000	Savings	New Accts	101	Existing
4/29/19	Friday	13,500	CD	New Accts	104	Existing
4/29/19	Friday	4,535	Checking	New Accts	105	New
4/29/19	Friday	4,535	Checking	New Accts	201	Existing
4/30/19	Saturday	7,000	IRA	New Accts	101	Existing
4/30/19	Saturday	4,000	Checking	Teller	101	Existing
4/1/19	Friday	8,721	Savings	New Accts	201	New
4/1/19	Friday	5,000	Savings	New Accts	102	Existing
4/1/19	Friday	12,000	CD	New Accts	102	Existing
4/1/19	Friday	6,837	Savings	New Accts	202	Existing
4/1/19	Friday	3,171	Checking	New Accts	202	Existing
4/1/19	Friday	15,759	CD	Teller	102	Existing
4/2/19	Saturday	7,188	Checking	Teller	102	New
4/4/19	Monday	500	Checking	Teller	102	Existing
4/4/19	Monday	12,000	CD	New Accts	102	Existing
4/4/19	Monday	3,075	Checking	New Accts	102	Existing
4/4/19	Monday	12,429	CD	New Accts	102	New
4/4/19	Monday	2,000	IRA	New Accts	102	Existing
4/4/19	Monday	12,824	CD	New Accts	202	Existing
4/4/19	Monday	65,000	Savings	New Accts	202	Existing
4/4/19	Monday	15,000	CD	New Accts	202	New
4/5/19	Tuesday	9,705	CD	New Accts	202	New
4/5/19	Tuesday	12,310	Savings	New Accts	102	New
4/5/19	Tuesday	13,000	CD	Teller	102	Existing
4/5/19	Tuesday	200	Checking	New Accts	201	Existing
4/5/19	Tuesday	17,000	CD	New Accts	102	Existing
4/5/19	Tuesday	45,000	CD	New Accts	102	Existing
4/5/19	Tuesday	200	Checking	Teller	102	Existing
4/6/19	Wednesday	14,158	Checking	New Accts	102	New
4/6/19	Wednesday	11,719	Checking	New Accts	102	Existing
4/6/19	Wednesday	500	Savings	New Accts	102	Existing
4/6/19	Wednesday	7,777	Checking	Teller	102	Existing
4/6/19	Wednesday	14,644	CD	New Accts	201	New
4/6/19	Wednesday	3,807	Checking	New Accts	102	Existing
4/6/19	Wednesday	133	Checking	New Accts	102	Existing
4/7/19	Thursday	4,005	CD	Teller	102	Existing
4/7/19	Thursday	4,405	Savings	New Accts	102	Existing
4/7/19	Thursday	10,373	CD	New Accts	102	Existing
4/7/19	Thursday	344	Checking	New Accts	102	Existing
4/7/19	Thursday	12,063	Savings	New Accts	102	New
4/7/19	Thursday	500	Checking	New Accts	102	Existing
4/7/19	Thursday	12,164	CD	New Accts	102	Existing
4/7/19	Thursday	3,171	Checking	New Accts	102	Existing
4/7/19	Thursday	500	Checking	New Accts	102	Existing
4/7/19	Thursday	2,000	IRA	New Accts	102	Existing
4/7/19	Thursday	4,000	Checking	New Accts	102	New
4/8/19	Friday	4,329	CD	New Accts	102	New
4/8/19	Friday	6,000	Checking	Teller	102	Existing
4/8/19	Friday	500	Savings	New Accts	102	Existing
4/8/19	Friday	3,845	Savings	Teller	102	Existing
4/8/19	Friday	4,681	CD	Teller	102	New
4/8/19	Friday	500	Checking	Teller	102	New
4/8/19	Friday	6,586	CD	Teller	102	New
4/8/19	Friday	6,794	CD	New Accts	102	Existing
4/8/19	Friday	8,512	CD	New Accts	102	New
4/8/19	Friday	9,268	CD	Teller	202	New
4/8/19	Friday	12,505	CD	New Accts	202	New
4/8/19	Friday	13,524	CD	Teller	201	Existing
4/8/19	Friday	14,969	CD	Teller	102	New
4/11/19	Monday	12,334	Savings	Teller	202	Existing
4/11/19	Monday	500	Checking	New Accts	102	New
4/11/19	Monday	65,000	Savings	New Accts	102	Existing
4/11/19	Monday	3,075	Checking	New Accts	102	Existing
4/11/19	Monday	8,349	Checking	New Accts	102	New
4/12/19	Tuesday	10,431	CD	Teller	102	New
4/12/19	Tuesday	14,722	Checking	Teller	102	Existing
4/12/19	Tuesday	14,644	CD	New Accts	102	New
4/13/19	Wednesday	500	Savings	New Accts	102	Existing
4/13/19	Wednesday	12,000	CD	New Accts	102	Existing
4/13/19	Wednesday	500	Savings	New Accts	202	Existing
4/13/19	Wednesday	500	Checking	New Accts	202	Existing
4/13/19	Wednesday	12,000	CD	New Accts	102	Existing
4/13/19	Wednesday	3,075	Checking	New Accts	202	Existing
4/13/19	Wednesday	500	Savings	New Accts	102	Existing
4/14/19	Thursday	5,603	Savings	New Accts	102	Existing
4/14/19	Thursday	3,807	Checking	New Accts	102	Existing
4/14/19	Thursday	13,521	Savings	New Accts	102	Existing
4/14/19	Thursday	133	Checking	New Accts	102	Existing
4/14/19	Thursday	13,000	CD	Teller	102	Existing
4/15/19	Friday	14,782	Checking	Teller	102	New
4/15/19	Friday	14,679	Savings	New Accts	102	Existing
4/15/19	Friday	6,534	CD	New Accts	102	New
4/15/19	Friday	6,000	Checking	Teller	102	Existing
4/15/19	Friday	2,000	IRA	New Accts	102	Existing
4/15/19	Friday	3,171	Checking	New Accts	102	Existing
4/15/19	Friday	7,218	Checking	Teller	102	New
4/15/19	Friday	5,000	Savings	New Accts	102	Existing
4/15/19	Friday	12,505	CD	New Accts	102	Existing
4/15/19	Friday	13,126	CD	Teller	102	New
4/18/19	Monday	7,037	Savings	Teller	102	Existing
4/18/19	Monday	10,373	CD	New Accts	102	Existing
4/18/19	Monday	6,808	Savings	New Accts	102	Existing
4/18/19	Monday	100	Checking	New Accts	102	Existing
4/18/19	Monday	10,103	Savings	Teller	201	Existing
4/18/19	Monday	13,916	CD	New Accts	201	New
4/19/19	Tuesday	500	Savings	New Accts	201	New
4/19/19	Tuesday	12,724	CD	New Accts	202	New
4/19/19	Tuesday	344	Checking	New Accts	202	Existing
4/19/19	Tuesday	13,130	CD	Teller	102	New
4/19/19	Tuesday	4,000	Checking	New Accts	102	Existing
4/19/19	Tuesday	4,779	Checking	Teller	102	Existing
4/19/19	Tuesday	14,169	CD	New Accts	102	New
4/19/19	Tuesday	500	Savings	New Accts	202	Existing
4/19/19	Tuesday	500	Savings	New Accts	102	Existing
4/19/19	Tuesday	3,075	Checking	New Accts	102	New
4/20/19	Wednesday	133	Checking	New Accts	102	Existing
4/20/19	Wednesday	3,807	Checking	New Accts	205	Existing
4/20/19	Wednesday	10,976	Checking	New Accts	202	New
4/20/19	Wednesday	8,633	Savings	Teller	102	Existing
4/20/19	Wednesday	9,591	Checking	Teller	201	Existing
4/20/19	Wednesday	4,323	CD	New Accts	201	Existing
4/20/19	Wednesday	5,981	Savings	Teller	201	New
4/20/19	Wednesday	13,000	CD	Teller	102	Existing
4/21/19	Thursday	344	Checking	New Accts	102	New
4/21/19	Thursday	3,075	Checking	New Accts	102	Existing
4/22/19	Friday	12,700	Checking	Teller	102	Existing
4/22/19	Friday	2,000	Checking	Teller	102	Existing
4/22/19	Friday	8,469	CD	Teller	102	Existing
4/22/19	Friday	133	Checking	New Accts	102	Existing
4/22/19	Friday	11,169	Savings	Teller	102	Existing
4/22/19	Friday	13,973	Savings	New Accts	202	Existing
4/22/19	Friday	12,276	CD	Teller	102	New
4/22/19	Friday	13,000	CD	Teller	102	Existing
4/22/19	Friday	3,807	Checking	New Accts	102	Existing
4/22/19	Friday	4,985	Savings	New Accts	102	Existing
4/22/19	Friday	14,698	CD	New Accts	102	New
4/25/19	Monday	7,193	Checking	New Accts	102	New
4/25/19	Monday	7,668	CD	Teller	202	New
4/25/19	Monday	6,000	Checking	Teller	201	Existing
4/25/19	Monday	10,322	Checking	Teller	201	New
4/25/19	Monday	12,505	CD	New Accts	201	Existing
4/25/19	Monday	12,505	CD	New Accts	205	Existing
4/25/19	Monday	10,039	Savings	Teller	102	Existing
4/25/19	Monday	6,000	Checking	Teller	102	Existing
4/25/19	Monday	13,596	CD	New Accts	202	New
4/26/19	Tuesday	4,384	CD	Teller	102	Existing
4/26/19	Tuesday	9,974	CD	New Accts	102	New
4/26/19	Tuesday	10,000	CD	New Accts	102	New
4/26/19	Tuesday	3,171	Checking	New Accts	102	Existing
4/26/19	Tuesday	25,000	CD	New Accts	102	Existing
4/26/19	Tuesday	14,348	Checking	New Accts	102	New
4/26/19	Tuesday	12,489	Checking	Teller	102	New
4/26/19	Tuesday	9,632	Checking	Teller	102	New
4/26/19	Tuesday	2,000	IRA	New Accts	102	Existing
4/26/19	Tuesday	5,000	Savings	New Accts	202	Existing
4/27/19	Wednesday	6,662	CD	Teller	102	Existing
4/27/19	Wednesday	5,000	Savings	New Accts	102	Existing
4/27/19	Wednesday	3,900	Checking	Teller	102	New
4/27/19	Wednesday	9,405	CD	New Accts	102	Existing
4/27/19	Wednesday	6,000	Checking	Teller	202	Existing
4/27/19	Wednesday	12,505	CD	New Accts	102	Existing
4/28/19	Thursday	1,000	Checking	Teller	201	New
4/28/19	Thursday	2,000	IRA	New Accts	201	Existing
4/28/19	Thursday	3,171	Checking	New Accts	201	Existing
4/28/19	Thursday	5,957	Checking	Teller	102	New
4/29/19	Friday	14,644	CD	New Accts	102	New
4/29/19	Friday	4,785	Savings	Teller	102	New
4/30/19	Saturday	4,257	Savings	New Accts	202	Existing
4/30/19	Saturday	12,673	Checking	New Accts	102	New

Bank Info- Branch Locations

Branch Number	Branch Location
100	Central
101	Westside
102	North County
104	Westside
105	North County
201	Central
202	North County
205	Westside
108	Central

Tea Sales- Data

Month	Product	State	Sales $
January	Amber Waves	Oregon	218
February	Amber Waves	Washington	638
February	Amber Waves	Oregon	150
February	Amber Waves	Washington	214
March	Amber Waves	California	270
March	Amber Waves	Oregon	527
March	Amber Waves	Washington	586
March	Amber Waves	California	464
March	Amber Waves	Oregon	529
March	Amber Waves	Washington	46
March	Amber Waves	California	244
March	Amber Waves	Oregon	236
March	Amber Waves	Washington	352
March	Amber Waves	California	624
March	Amber Waves	Oregon	975
March	Amber Waves	Washington	339
March	Amber Waves	California	353
March	Amber Waves	Oregon	304
March	Amber Waves	Washington	88
April	Amber Waves	California	967
April	Amber Waves	Oregon	915
April	Amber Waves	Washington	1
May	Amber Waves	California	864
May	Amber Waves	Oregon	857
May	Amber Waves	Washington	364
June	Amber Waves	California	147
June	Amber Waves	Oregon	627
June	Amber Waves	Washington	838
July	Amber Waves	California	809
July	Amber Waves	Oregon	352
July	Amber Waves	Washington	997
August	Amber Waves	California	247
August	Amber Waves	Oregon	612
August	Amber Waves	Washington	164
September	Amber Waves	California	872
September	Amber Waves	Oregon	42
September	Amber Waves	Washington	288
January	Blackbear Berry	California	158
January	Blackbear Berry	Oregon	886
February	Blackbear Berry	California	995
February	Blackbear Berry	Oregon	223
February	Blackbear Berry	Washington	813
March	Blackbear Berry	California	331
March	Blackbear Berry	Oregon	31
March	Blackbear Berry	Washington	109
March	Blackbear Berry	California	807
March	Blackbear Berry	Oregon	103
March	Blackbear Berry	Washington	19
March	Blackbear Berry	California	792
March	Blackbear Berry	Oregon	51
March	Blackbear Berry	Washington	910
March	Blackbear Berry	California	874
March	Blackbear Berry	Oregon	503
March	Blackbear Berry	Washington	963
March	Blackbear Berry	California	582
March	Blackbear Berry	Oregon	775
March	Blackbear Berry	Washington	309
April	Blackbear Berry	California	187
April	Blackbear Berry	Oregon	377
April	Blackbear Berry	Washington	453
May	Blackbear Berry	California	406
May	Blackbear Berry	Oregon	688
May	Blackbear Berry	Washington	779
June	Blackbear Berry	California	112
June	Blackbear Berry	Oregon	886
June	Blackbear Berry	Washington	105
July	Blackbear Berry	California	128
July	Blackbear Berry	Oregon	682
July	Blackbear Berry	Washington	835
August	Blackbear Berry	California	918
August	Blackbear Berry	Oregon	491
August	Blackbear Berry	Washington	217
September	Blackbear Berry	California	669
September	Blackbear Berry	Oregon	769
September	Blackbear Berry	Washington	789
January	Huckleberry Heat	Oregon	510
February	Huckleberry Heat	Washington	743
February	Huckleberry Heat	Oregon	502
February	Huckleberry Heat	Washington	856
March	Huckleberry Heat	California	605
March	Huckleberry Heat	Oregon	352
March	Huckleberry Heat	Washington	983
March	Huckleberry Heat	California	433
March	Huckleberry Heat	Oregon	897
March	Huckleberry Heat	Washington	88
March	Huckleberry Heat	California	180
March	Huckleberry Heat	Oregon	625
March	Huckleberry Heat	Washington	342
March	Huckleberry Heat	California	278
March	Huckleberry Heat	Oregon	14
March	Huckleberry Heat	Washington	999
March	Huckleberry Heat	California	898
March	Huckleberry Heat	Oregon	825
March	Huckleberry Heat	Washington	424
April	Huckleberry Heat	California	247
April	Huckleberry Heat	Oregon	317
April	Huckleberry Heat	Washington	390
May	Huckleberry Heat	California	422
May	Huckleberry Heat	Oregon	340
May	Huckleberry Heat	Washington	15
June	Huckleberry Heat	California	10
June	Huckleberry Heat	Oregon	269
June	Huckleberry Heat	Washington	823
July	Huckleberry Heat	California	28
July	Huckleberry Heat	Oregon	253
July	Huckleberry Heat	Washington	101
August	Huckleberry Heat	California	268
August	Huckleberry Heat	Oregon	872
August	Huckleberry Heat	Washington	637
September	Huckleberry Heat	California	824
September	Huckleberry Heat	Oregon	611
September	Huckleberry Heat	Washington	109
January	Purple Mountains	California	336
January	Purple Mountains	Oregon	2
February	Purple Mountains	California	489
February	Purple Mountains	Oregon	11
February	Purple Mountains	Washington	30
March	Purple Mountains	California	935
March	Purple Mountains	Oregon	988
March	Purple Mountains	Washington	765
March	Purple Mountains	California	70
March	Purple Mountains	Oregon	219
March	Purple Mountains	Washington	273
March	Purple Mountains	California	23
March	Purple Mountains	Oregon	194
March	Purple Mountains	Washington	909
March	Purple Mountains	California	246
March	Purple Mountains	Oregon	492
March	Purple Mountains	Washington	567
March	Purple Mountains	California	578
March	Purple Mountains	Oregon	561
March	Purple Mountains	Washington	294
April	Purple Mountains	California	534
April	Purple Mountains	Oregon	138
April	Purple Mountains	Washington	601
May	Purple Mountains	California	921
May	Purple Mountains	Oregon	472
May	Purple Mountains	Washington	349
June	Purple Mountains	California	565
June	Purple Mountains	Oregon	8
June	Purple Mountains	Washington	948
July	Purple Mountains	California	275
July	Purple Mountains	Oregon	903
July	Purple Mountains	Washington	326
August	Purple Mountains	California	97
August	Purple Mountains	Oregon	698
August	Purple Mountains	Washington	390
September	Purple Mountains	California	972
September	Purple Mountains	Oregon	218
September	Purple Mountains	Washington	716
January	Raspberry Rocket	California	23
February	Raspberry Rocket	California	823
February	Raspberry Rocket	Oregon	992
February	Raspberry Rocket	Washington	652
March	Raspberry Rocket	California	692
March	Raspberry Rocket	Oregon	656
March	Raspberry Rocket	Washington	939
March	Raspberry Rocket	California	729
March	Raspberry Rocket	Oregon	522
March	Raspberry Rocket	Washington	349
March	Raspberry Rocket	California	282
March	Raspberry Rocket	Oregon	278
March	Raspberry Rocket	Washington	134
March	Raspberry Rocket	California	908
March	Raspberry Rocket	Oregon	862
March	Raspberry Rocket	Washington	9
March	Raspberry Rocket	California	179
March	Raspberry Rocket	Oregon	370
March	Raspberry Rocket	Washington	278
April	Raspberry Rocket	California	955
April	Raspberry Rocket	Oregon	136
April	Raspberry Rocket	Washington	230
May	Raspberry Rocket	California	971
May	Raspberry Rocket	Oregon	615
May	Raspberry Rocket	Washington	865
June	Raspberry Rocket	California	212
June	Raspberry Rocket	Oregon	659
June	Raspberry Rocket	Washington	913
July	Raspberry Rocket	California	521
July	Raspberry Rocket	Oregon	274
July	Raspberry Rocket	Washington	603
August	Raspberry Rocket	California	110
August	Raspberry Rocket	Oregon	533
August	Raspberry Rocket	Washington	245
September	Raspberry Rocket	California	786
September	Raspberry Rocket	Oregon	171
September	Raspberry Rocket	Washington	12
January	Shining Seas	California	880
February	Shining Seas	California	683
February	Shining Seas	Oregon	794
February	Shining Seas	Washington	381
March	Shining Seas	California	411
March	Shining Seas	Oregon	763
March	Shining Seas	Washington	473
March	Shining Seas	California	406
March	Shining Seas	Oregon	56
March	Shining Seas	Washington	108
March	Shining Seas	California	631
March	Shining Seas	Oregon	12
March	Shining Seas	Washington	566
March	Shining Seas	California	507
March	Shining Seas	Oregon	886
March	Shining Seas	Washington	37
March	Shining Seas	California	181
March	Shining Seas	Oregon	336
March	Shining Seas	Washington	19
April	Shining Seas	California	656
April	Shining Seas	Oregon	562
April	Shining Seas	Washington	364
May	Shining Seas	California	149
May	Shining Seas	Oregon	693
May	Shining Seas	Washington	200
June	Shining Seas	California	119
June	Shining Seas	Oregon	566
June	Shining Seas	Washington	887
July	Shining Seas	California	728
July	Shining Seas	Oregon	176
July	Shining Seas	Washington	563
August	Shining Seas	California	797
August	Shining Seas	Oregon	799
August	Shining Seas	Washington	557
September	Shining Seas	California	489
September	Shining Seas	Oregon	406
September	Shining Seas	Washington	106

Amort Schedule

Create an amortization schedule for a new home purchase using the following information.
The loan is a 15-year fixed rate loan paid monthly.
Purchase Price:	$450,000.00
Percent Down Pmt:	20%
Loan Amount:		use formula to calculate
Interest Rate:	4.50%
Loan Term (years):	15		months
Beginning Month:	July
Beginning Year:	2020
Date	Pmt No.	Pmt	Principal	Interest	Beginning Balance	Ending Balance