Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

8. Federally Insured Bank Failures. The file FDICBankFailures contains data on failures of federally insured banks between 2000 and 2012. use a PivotTable in Excel

8. Federally Insured Bank Failures.

The file FDICBankFailures contains data on failures of federally insured banks between 2000 and 2012. use a PivotTable in Excel to answer the following questions.

The PivotTable should group the closing dates of the banks into yearly bins and display the counts of bank closures each year in columns of Excel. Row labels should include the bank locations and allow for grouping the locations into states or viewing by city. You should also sort the PivotTable so that the states with the greatest number of total bank failures between 2000 and 2012 appear at the top of the PivotTable.

a. Which state had the greatest number of federally insured bank closings between 2000 and 2012?

b. How many bank closings occurred in the state of Nevada (NV) in 2010? In what cities did these bank closings occur?

c. Use the PivotTable's filter capability to view only bank closings in California (CA), Florida (FL), Texas (TX), and New York (NY) for the years 2009 through 2012. What is the total number of bank closings in these states between 2009 and 2012?

d. Using the filtered PivotTable from part c, what city in Florida had the greatest number of bank closings between 2009 and 2012? How many bank closings occurred in this city?

e. Make the PivotChart to display a column chart that shows the total number of bank closings in each year from 2000 through 2012 in the state of Florida. Adjust the for-matting of this column chart so that it best conveys the data. What does this column chart suggest about bank closings between 2000 and 2012 in Florida? Discuss.

(Hint: You may have to switch the row and column labels in the PivotChart to get the best presentation for your PivotChart.)

DATA FOR EXCEL:

Bank Name

Fort Lee Federal Savings Bank, FSB

Fidelity Bank

Premier Bank

Covenant Bank & Trust

New City Bank

Global Commerce Bank

Home Savings of America

Central Bank of Georgia

SCB Bank

Charter National Bank and Trust

BankEast

Patriot Bank Minnesota

Tennessee Commerce Bank

First Guaranty Bank and Trust Company of Jacksonville

American Eagle Savings Bank

The First State Bank

Central Florida State Bank

Western National Bank

Premier Community Bank of the Emerald Coast

Central Progressive Bank

Polk County Bank

Community Bank of Rockmart

SunFirst Bank

Mid City Bank, Inc.

All American Bank

Community Banks of Colorado

Community Capital Bank

Decatur First Bank

Old Harbor Bank

Country Bank

First State Bank

Blue Ridge Savings Bank, Inc.

Piedmont Community Bank

Sun Security Bank

The RiverBank

First International Bank

Citizens Bank of Northern California

Bank of the Commonwealth

First National Bank of Florida

CreekSide Bank

Patriot Bank of Georgia

First Choice Bank

First Southern National Bank

Lydian Private Bank

Public Savings Bank

The First National Bank of Olathe

Bank of Whitman

Bank of Shorewood

Integra Bank National Association

BankMeridian, N.A.

Virginia Business Bank

Bank of Choice

LandMark Bank of Florida

Southshore Community Bank

Summit Bank

First Peoples Bank

High Trust Bank

One Georgia Bank

Signature Bank

Colorado Capital Bank

First Chicago Bank & Trust

Mountain Heritage Bank

First Commercial Bank of Tampa Bay

McIntosh State Bank

Atlantic Bank and Trust

First Heritage Bank

Summit Bank

First Georgia Banking Company

Atlantic Southern Bank

Coastal Bank

Community Central Bank

The Park Avenue Bank

First Choice Community Bank

Cortez Community Bank

First National Bank of Central Florida

Heritage Banking Group

Rosemount National Bank

Superior Bank

Nexity Bank

New Horizons Bank

Bartow County Bank

Nevada Commerce Bank

Western Springs National Bank and Trust

The Bank of Commerce

Legacy Bank

First National Bank of Davis

Valley Community Bank

San Luis Trust Bank, FSB

Charter Oak Bank

Citizens Bank of Effingham

Habersham Bank

Canyon National Bank

Badger State Bank

Peoples State Bank

Sunshine State Community Bank

Community First Bank Chicago

North Georgia Bank

American Trust Bank

First Community Bank

FirsTier Bank

Evergreen State Bank

The First State Bank

United Western Bank

The Bank of Asheville

CommunitySouth Bank & Trust

Enterprise Banking Company

Oglethorpe Bank

Legacy Bank

First Commercial Bank of Florida

Community National Bank

First Southern Bank

United Americas Bank, N.A.

Appalachian Community Bank, FSB

Chestatee State Bank

The Bank of Miami,N.A.

Earthstar Bank

Paramount Bank

First Banking Center

Allegiance Bank of North America

Gulf State Community Bank

Copper Star Bank

Darby Bank & Trust Co.

Tifton Banking Company

First Vietnamese American Bank

Pierce Commercial Bank

Western Commercial Bank

K Bank

First Arizona Savings, A FSB

Hillcrest Bank

First Suburban National Bank

The First National Bank of Barnesville

The Gordon Bank

Progress Bank of Florida

First Bank of Jacksonville

Premier Bank

WestBridge Bank and Trust Company

Security Savings Bank, F.S.B.

Shoreline Bank

Wakulla Bank

North County Bank

Haven Trust Bank Florida

Maritime Savings Bank

Bramble Savings Bank

The Peoples Bank

First Commerce Community Bank

Bank of Ellijay

ISN Bank

Horizon Bank

Sonoma Valley Bank

Los Padres Bank

Butte Community Bank

Pacific State Bank

ShoreBank

Imperial Savings and Loan Association

Independent National Bank

Community National Bank at Bartow

Palos Bank and Trust Company

Ravenswood Bank

LibertyBank

The Cowlitz Bank

Coastal Community Bank

Bayside Savings Bank

Northwest Bank & Trust

Home Valley Bank

SouthwestUSA Bank

Community Security Bank

Thunder Bank

Williamsburg First National Bank

Crescent Bank and Trust Company

Sterling Bank

Mainstreet Savings Bank, FSB

Olde Cypress Community Bank

Turnberry Bank

Metro Bank of Dade County

First National Bank of the South

Woodlands Bank

Home National Bank

USA Bank

Ideal Federal Savings Bank

Bay National Bank

High Desert State Bank

First National Bank

Peninsula Bank

Nevada Security Bank

Washington First International Bank

TierOne Bank

Arcola Homestead Savings Bank

First National Bank

Sun West Bank

Granite Community Bank, NA

Bank of Florida - Tampa

Bank of Florida - Southwest

Bank of Florida - Southeast

Pinehurst Bank

Midwest Bank and Trust Company

Southwest Community Bank

New Liberty Bank

Satilla Community Bank

1st Pacific Bank of California

Towne Bank of Arizona

Access Bank

The Bank of Bonifay

Frontier Bank

BC National Banks

Champion Bank

CF Bancorp

Westernbank Puerto Rico

R-G Premier Bank of Puerto Rico

Eurobank

Wheatland Bank

Peotone Bank and Trust Company

Lincoln Park Savings Bank

New Century Bank

Citizens Bank and Trust Company of Chicago

Broadway Bank

Amcore Bank, National Association

City Bank

Tamalpais Bank

Innovative Bank

Butler Bank

Riverside National Bank of Florida

AmericanFirst Bank

First Federal Bank of North Florida

Lakeside Community Bank

Beach First National Bank

Desert Hills Bank

Unity National Bank

Key West Bank

McIntosh Commercial Bank

State Bank of Aurora

First Lowndes Bank

Bank of Hiawassee

Appalachian Community Bank

Advanta Bank Corp.

Century Security Bank

American National Bank

Statewide Bank

Old Southern Bank

The Park Avenue Bank

LibertyPointe Bank

Centennial Bank

Waterfield Bank

Bank of Illinois

Sun American Bank

Rainier Pacific Bank

Carson River Community Bank

La Jolla Bank, FSB

George Washington Savings Bank

The La Coste National Bank

Marco Community Bank

1st American State Bank of Minnesota

American Marine Bank

First Regional Bank

Community Bank and Trust

Marshall Bank, N.A.

Florida Community Bank

First National Bank of Georgia

Columbia River Bank

Evergreen Bank

Charter Bank

Bank of Leeton

Premier American Bank

Barnes Banking Company

St. Stephen State Bank

Town Community Bank & Trust

Horizon Bank

First Federal Bank of California, F.S.B.

Imperial Capital Bank

Independent Bankers' Bank

New South Federal Savings Bank

Citizens State Bank

Peoples First Community Bank

RockBridge Commercial Bank

SolutionsBank

Valley Capital Bank, N.A.

Republic Federal Bank, N.A.

Greater Atlantic Bank

Benchmark Bank

AmTrust Bank

The Tattnall Bank

First Security National Bank

The Buckhead Community Bank

Commerce Bank of Southwest Florida

Pacific Coast National Bank

Orion Bank

Century Bank, F.S.B.

United Commercial Bank

Gateway Bank of St. Louis

Prosperan Bank

Home Federal Savings Bank

United Security Bank

North Houston Bank

Madisonville State Bank

Citizens National Bank

Park National Bank

Pacific National Bank

California National Bank

San Diego National Bank

Community Bank of Lemont

Bank USA, N.A.

First DuPage Bank

Riverview Community Bank

Bank of Elmwood

Flagship National Bank

Hillcrest Bank Florida

American United Bank

Partners Bank

San Joaquin Bank

Southern Colorado National Bank

Jennings State Bank

Warren Bank

Georgian Bank

Irwin Union Bank, F.S.B.

Irwin Union Bank and Trust Company

Venture Bank

Brickwell Community Bank

Corus Bank, N.A.

First State Bank

Platinum Community Bank

Vantus Bank

InBank

First Bank of Kansas City

Affinity Bank

Mainstreet Bank

Bradford Bank

Guaranty Bank

CapitalSouth Bank

First Coweta Bank

ebank

Community Bank of Nevada

Community Bank of Arizona

Union Bank, National Association

Colonial Bank

Dwelling House Savings and Loan Association

Community First Bank

Community National Bank of Sarasota County

First State Bank

Mutual Bank

First BankAmericano

Peoples Community Bank

Integrity Bank

First State Bank of Altus

Security Bank of Jones County

Security Bank of Houston County

Security Bank of Bibb County

Security Bank of North Metro

Security Bank of North Fulton

Security Bank of Gwinnett County

Waterford Village Bank

Temecula Valley Bank

Vineyard Bank

BankFirst

First Piedmont Bank

Bank of Wyoming

Founders Bank

Millennium State Bank of Texas

First National Bank of Danville

Elizabeth State Bank

Rock River Bank

First State Bank of Winchester

John Warner Bank

Mirae Bank

MetroPacific Bank

Horizon Bank

Neighborhood Community Bank

Community Bank of West Georgia

First National Bank of Anthony

Cooperative Bank

Southern Community Bank

Bank of Lincolnwood

Citizens National Bank

Strategic Capital Bank

BankUnited, FSB

Westsound Bank

America West Bank

Citizens Community Bank

Silverton Bank, NA

First Bank of Idaho

First Bank of Beverly Hills

Michigan Heritage Bank

American Southern Bank

Great Basin Bank of Nevada

American Sterling Bank

New Frontier Bank

Cape Fear Bank

Omni National Bank

TeamBank, NA

Colorado National Bank

FirstCity Bank

Freedom Bank of Georgia

Security Savings Bank

Heritage Community Bank

Silver Falls Bank

Pinnacle Bank of Oregon

Corn Belt Bank & Trust Co.

Riverside Bank of the Gulf Coast

Sherman County Bank

County Bank

Alliance Bank

FirstBank Financial Services

Ocala National Bank

Suburban FSB

MagnetBank

1st Centennial Bank

Bank of Clark County

National Bank of Commerce

Sanderson State Bank

Haven Trust Bank

First Georgia Community Bank

PFF Bank & Trust

Downey Savings & Loan

Community Bank

Security Pacific Bank

Franklin Bank, SSB

Freedom Bank

Alpha Bank & Trust

Meridian Bank

Main Street Bank

Washington Mutual Bank

Ameribank

Silver State Bank

Integrity Bank

Columbian Bank & Trust

First Priority Bank

First Heritage Bank, NA

First National Bank of Nevada

IndyMac Bank

First Integrity Bank, NA

ANB Financial, NA

Hume Bank

Douglass National Bank

Miami Valley Bank

NetBank

Metropolitan Savings Bank

Bank of Ephraim

Reliance Bank

Guaranty National Bank of Tallahassee

Dollar Savings Bank

Pulaski Savings Bank

First National Bank of Blanchardville

Southern Pacific Bank

Farmers Bank of Cheneyville

Bank of Alamo

AmTrade International Bank

Universal Federal Savings Bank

Connecticut Bank of Commerce

New Century Bank

Net 1st National Bank

NextBank, NA

Oakwood Deposit Bank Co.

Bank of Sierra Blanca

Hamilton Bank, NA

Sinclair National Bank

Superior Bank, FSB

Malta National Bank

First Alliance Bank & Trust Co.

National State Bank of Metropolis

Bank of Honolulu

City

Fort Lee

Dearborn

Wilmette

Rock Spring

Chicago

Doraville

Little Falls

Ellaville

Shelbyville

Hoffman Estates

Knoxville

Forest Lake

Franklin

Jacksonville

Boothwyn

Stockbridge

Belleview

Phoenix

Crestview

Lacombe

Johnston

Rockmart

Saint George

Omaha

Des Plaines

Greenwood Village

Jonesboro

Decatur

Clearwater

Aledo

Cranford

Asheville

Gray

Ellington

Wyoming

Plano

Nevada City

Norfolk

Milton

Woodstock

Cumming

Geneva

Statesboro

Palm Beach

Huntingdon Valley

Olathe

Colfax

Shorewood

Evansville

Columbia

Richmond

Greeley

Sarasota

Apollo Beach

Prescott

Port St. Lucie

Stockbridge

Atlanta

Windsor

Castle Rock

Chicago

Clayton

Tampa

Jackson

Charleston

Snohomish

Burlington

Franklin

Macon

Cocoa Beach

Mount Clemens

Valdosta

Dallas

Brooksville

Winter Park

Carthage

Rosemount

Birmingham

Birmingham

East Ellijay

Cartersville

Las Vegas

Western Springs

Wood Dale

Milwaukee

Davis

St. Charles

San Luis Obispo

Napa

Springfield

Clarkesville

Palm Springs

Cassville

Hamtramck

Port Orange

Chicago

Watkinsville

Roswell

Taos

Louisville

Stoughton

Camargo

Denver

Asheville

Easley

McDonough

Brunswick

Scottsdale

Orlando

Lino Lakes

Batesville

Atlanta

McCaysville

Dawsonville

Coral Gables

Southampton

Farmington Hills

Burlington

Bala Cynwyd

Carrabelle

Scottsdale

Vidalia

Tifton

Westminster

Tacoma

Woodland Hills

Randallstown

Scottsdale

Overland Park

Maywood

Barnesville

Gordon

Tampa

Jacksonville

Jefferson City

Chesterfield

Olathe

Shoreline

Crawfordville

Arlington

Ponte Vedra Beach

West Allis

Milford

Winder

Douglasville

Ellijay

Cherry Hill

Bradenton

Sonoma

Solvang

Chico

Stockton

Chicago

Martinsville

Ocala

Bartow

Palos Heights

Chicago

Eugene

Longview

Panama City Beach

Port Saint Joe

Acworth

Cave Junction

Las Vegas

New Prague

Sylvan Grove

Kingstree

Jasper

Lantana

Hastings

Clewiston

Aventura

Miami

Spartanburg

Bluffton

Blackwell

Port Chester

Baltimore

Baltimore

Albuquerque

Savannah

Englewood

Reno

Seattle

Lincoln

Arcola

Rosedale

Las Vegas

Granite Bay

Tampa

Naples

Fort Lauderdale

Saint Paul

Elmwood Park

Springfield

Plymouth

Saint Marys

San Diego

Mesa

Champlin

Bonifay

Everett

Butler

Creve Coeur

Port Huron

Mayaguez

Hato Rey

San Juan

Naperville

Peotone

Chicago

Chicago

Chicago

Chicago

Rockford

Lynnwood

San Rafael

Oakland

Lowell

Fort Pierce

Clermont

Palatka

Sterling Heights

Myrtle Beach

Phoenix

Cartersville

Key West

Carrollton

Aurora

Fort Deposit

Hiawassee

Ellijay

Draper

Duluth

Parma

Covington

Orlando

New York

New York

Ogden

Germantown

Normal

Boca Raton

Tacoma

Carson City

La Jolla

Orland Park

La Coste

Marco Island

Hancock

Bainbridge Island

Los Angeles

Cornelia

Hallock

Immokalee

Carrollton

The Dalles

Seattle

Santa Fe

Leeton

Miami

Kaysville

St. Stephen

Antioch

Bellingham

Santa Monica

La Jolla

Springfield

Irondale

New Baltimore

Panama City

Atlanta

Overland Park

Mesa

Miami

Reston

Aurora

Cleveland

Reidsville

Norcross

Atlanta

Fort Myers

San Clemente

Naples

Sarasota

San Francisco

St. Louis

Oakdale

Detroit

Sparta

Houston

Madisonville

Teague

Chicago

San Francisco

Los Angeles

San Diego

Lemont

Phoenix

Westmont

Otsego

Racine

Bradenton

Naples

Lawrenceville

Naples

Bakersfield

Pueblo

Spring Grove

Warren

Atlanta

Louisville

Columbus

Lacey

Woodbury

Chicago

Flagstaff

Rolling Meadows

Sioux City

Oak Forest

Kansas City

Ventura

Forest Lake

Baltimore

Austin

Birmingham

Newnan

Atlanta

Las Vegas

Phoenix

Gilbert

Montgomery

Pittsburgh

Prineville

Venice

Sarasota

Harvey

Elizabeth

West Chester

Jupiter

Altus

Gray

Perry

Macon

Woodstock

Alpharetta

Suwanee

Williamsville

Temecula

Rancho Cucamonga

Sioux Falls

Winder

Thermopolis

Worth

Dallas

Danville

Elizabeth

Oregon

Winchester

Clinton

Los Angeles

Irvine

Pine City

Newnan

Villa Rica

Anthony

Wilmington

Fayetteville

Lincolnwood

Macomb

Champaign

Coral Gables

Bremerton

Layton

Ridgewood

Atlanta

Ketchum

Calabasas

Farmington Hills

Kennesaw

Elko

Sugar Creek

Greeley

Wilmington

Atlanta

Paola

Colorado Springs

Stockbridge

Commerce

Henderson

Glenwood

Silverton

Beaverton

Pittsfield

Cape Coral

Loup City

Merced

Culver City

McDonough

Ocala

Crofton

Salt Lake City

Redlands

Vancouver

Berkeley

Sanderson

Duluth

Jackson

Pomona

Newport Beach

Loganville

Los Angeles

Houston

Bradenton

Alpharetta

Eldred

Northville

Henderson

Northfork

Henderson

Alpharetta

Topeka

Bradenton

Newport Beach

Reno

Pasadena

Staples

Bentonville

Hume

Kansas City

Lakeview

Alpharetta

Pittsburgh

Ephraim

White Plains

Tallahassee

Newark

Philadelphia

Blanchardville

Torrance

Cheneyville

Alamo

Atlanta

Chicago

Stamford

Shelby Township

Boca Raton

Phoenix

Oakwood

Sierra Blanca

Miami

Gravette

Hinsdale

Malta

Manchester

Metropolis

Honolulu

State

NJ

MI

IL

GA

IL

GA

MN

GA

IN

IL

TN

MN

TN

FL

PA

GA

FL

AZ

FL

LA

IA

GA

UT

NE

IL

CO

GA

GA

FL

IL

NJ

NC

GA

MO

MN

TX

CA

VA

FL

GA

GA

IL

GA

FL

PA

KS

WA

IL

IN

SC

VA

CO

FL

FL

AZ

FL

GA

GA

CO

CO

IL

GA

FL

GA

SC

WA

WA

GA

GA

FL

MI

GA

GA

FL

FL

MS

MN

AL

AL

GA

GA

NV

IL

IL

WI

OK

IL

CA

CA

GA

GA

CA

WI

MI

FL

IL

GA

GA

NM

CO

WI

OK

CO

NC

SC

GA

GA

AZ

FL

MN

AR

GA

GA

GA

FL

PA

MI

WI

PA

FL

AZ

GA

GA

CA

WA

CA

MD

AZ

KS

IL

GA

GA

FL

FL

MO

MO

KS

WA

FL

WA

FL

WI

OH

GA

GA

GA

NJ

FL

CA

CA

CA

CA

IL

VA

FL

FL

IL

IL

OR

WA

FL

FL

GA

OR

NV

MN

KS

SC

GA

FL

MI

FL

FL

FL

SC

SC

OK

NY

MD

MD

NM

GA

FL

NV

WA

NE

IL

MS

NV

CA

FL

FL

FL

MN

IL

MO

MI

GA

CA

AZ

MN

FL

WA

MO

MO

MI

PR

PR

PR

IL

IL

IL

IL

IL

IL

IL

WA

CA

CA

MA

FL

FL

FL

MI

SC

AZ

GA

FL

GA

MN

AL

GA

GA

UT

GA

OH

LA

FL

NY

NY

UT

MD

IL

FL

WA

NV

CA

IL

TX

FL

MN

WA

CA

GA

MN

FL

GA

OR

WA

NM

MO

FL

UT

MN

IL

WA

CA

CA

IL

AL

MI

FL

GA

KS

AZ

FL

VA

IL

OH

GA

GA

GA

FL

CA

FL

FL

CA

MO

MN

MI

GA

TX

TX

TX

IL

CA

CA

CA

IL

AZ

IL

MN

WI

FL

FL

GA

FL

CA

CO

MN

MI

GA

KY

IN

WA

MN

IL

AZ

IL

IA

IL

MO

CA

MN

MD

TX

AL

GA

GA

NV

AZ

AZ

AL

PA

OR

FL

FL

IL

NJ

OH

FL

OK

GA

GA

GA

GA

GA

GA

NY

CA

CA

SD

GA

WY

IL

TX

IL

IL

IL

IL

IL

CA

CA

MN

GA

GA

KS

NC

GA

IL

IL

IL

FL

WA

UT

NJ

GA

ID

CA

MI

GA

NV

MO

CO

NC

GA

KS

CO

GA

GA

NV

IL

OR

OR

IL

FL

NE

CA

CA

GA

FL

MD

UT

CA

WA

IL

TX

GA

GA

CA

CA

GA

CA

TX

FL

GA

IL

MI

NV

WV

NV

GA

KS

FL

CA

NV

CA

MN

AR

MO

MO

OH

GA

PA

UT

NY

FL

NJ

PA

WI

CA

LA

TN

GA

IL

CT

MI

FL

AZ

OH

TX

FL

AR

IL

OH

NH

IL

HI

Closing Date

20-Apr-12

30-Mar-12

23-Mar-12

23-Mar-12

9-Mar-12

2-Mar-12

24-Feb-12

24-Feb-12

10-Feb-12

10-Feb-12

27-Jan-12

27-Jan-12

27-Jan-12

27-Jan-12

20-Jan-12

20-Jan-12

20-Jan-12

16-Dec-11

16-Dec-11

18-Nov-11

18-Nov-11

10-Nov-11

4-Nov-11

4-Nov-11

28-Oct-11

21-Oct-11

21-Oct-11

21-Oct-11

21-Oct-11

14-Oct-11

14-Oct-11

14-Oct-11

14-Oct-11

7-Oct-11

7-Oct-11

30-Sep-11

23-Sep-11

23-Sep-11

9-Sep-11

2-Sep-11

2-Sep-11

19-Aug-11

19-Aug-11

19-Aug-11

18-Aug-11

12-Aug-11

5-Aug-11

5-Aug-11

29-Jul-11

29-Jul-11

29-Jul-11

22-Jul-11

22-Jul-11

22-Jul-11

15-Jul-11

15-Jul-11

15-Jul-11

15-Jul-11

8-Jul-11

8-Jul-11

8-Jul-11

24-Jun-11

17-Jun-11

17-Jun-11

3-Jun-11

27-May-11

20-May-11

20-May-11

20-May-11

6-May-11

29-Apr-11

29-Apr-11

29-Apr-11

29-Apr-11

29-Apr-11

15-Apr-11

15-Apr-11

15-Apr-11

15-Apr-11

15-Apr-11

15-Apr-11

8-Apr-11

8-Apr-11

25-Mar-11

11-Mar-11

11-Mar-11

25-Feb-11

18-Feb-11

18-Feb-11

18-Feb-11

18-Feb-11

11-Feb-11

11-Feb-11

11-Feb-11

11-Feb-11

4-Feb-11

4-Feb-11

4-Feb-11

28-Jan-11

28-Jan-11

28-Jan-11

28-Jan-11

21-Jan-11

21-Jan-11

21-Jan-11

21-Jan-11

14-Jan-11

7-Jan-11

7-Jan-11

17-Dec-10

17-Dec-10

17-Dec-10

17-Dec-10

17-Dec-10

17-Dec-10

10-Dec-10

10-Dec-10

19-Nov-10

19-Nov-10

19-Nov-10

12-Nov-10

12-Nov-10

12-Nov-10

5-Nov-10

5-Nov-10

5-Nov-10

5-Nov-10

22-Oct-10

22-Oct-10

22-Oct-10

22-Oct-10

22-Oct-10

22-Oct-10

22-Oct-10

15-Oct-10

15-Oct-10

15-Oct-10

1-Oct-10

1-Oct-10

24-Sep-10

24-Sep-10

17-Sep-10

17-Sep-10

17-Sep-10

17-Sep-10

17-Sep-10

17-Sep-10

10-Sep-10

20-Aug-10

20-Aug-10

20-Aug-10

20-Aug-10

20-Aug-10

20-Aug-10

20-Aug-10

20-Aug-10

13-Aug-10

6-Aug-10

30-Jul-10

30-Jul-10

30-Jul-10

30-Jul-10

30-Jul-10

23-Jul-10

23-Jul-10

23-Jul-10

23-Jul-10

23-Jul-10

23-Jul-10

23-Jul-10

16-Jul-10

16-Jul-10

16-Jul-10

16-Jul-10

16-Jul-10

16-Jul-10

9-Jul-10

9-Jul-10

9-Jul-10

9-Jul-10

25-Jun-10

25-Jun-10

25-Jun-10

18-Jun-10

11-Jun-10

4-Jun-10

4-Jun-10

4-Jun-10

28-May-10

28-May-10

28-May-10

28-May-10

28-May-10

21-May-10

14-May-10

14-May-10

14-May-10

14-May-10

7-May-10

7-May-10

7-May-10

7-May-10

30-Apr-10

30-Apr-10

30-Apr-10

30-Apr-10

30-Apr-10

30-Apr-10

30-Apr-10

23-Apr-10

23-Apr-10

23-Apr-10

23-Apr-10

23-Apr-10

23-Apr-10

23-Apr-10

16-Apr-10

16-Apr-10

16-Apr-10

16-Apr-10

16-Apr-10

16-Apr-10

16-Apr-10

16-Apr-10

9-Apr-10

26-Mar-10

26-Mar-10

26-Mar-10

26-Mar-10

19-Mar-10

19-Mar-10

19-Mar-10

19-Mar-10

19-Mar-10

19-Mar-10

19-Mar-10

12-Mar-10

12-Mar-10

12-Mar-10

11-Mar-10

5-Mar-10

5-Mar-10

5-Mar-10

5-Mar-10

26-Feb-10

26-Feb-10

19-Feb-10

19-Feb-10

19-Feb-10

19-Feb-10

5-Feb-10

29-Jan-10

29-Jan-10

29-Jan-10

29-Jan-10

29-Jan-10

29-Jan-10

22-Jan-10

22-Jan-10

22-Jan-10

22-Jan-10

22-Jan-10

15-Jan-10

15-Jan-10

15-Jan-10

8-Jan-10

18-Dec-09

18-Dec-09

18-Dec-09

18-Dec-09

18-Dec-09

18-Dec-09

18-Dec-09

11-Dec-09

11-Dec-09

11-Dec-09

4-Dec-09

4-Dec-09

4-Dec-09

4-Dec-09

4-Dec-09

4-Dec-09

20-Nov-09

13-Nov-09

13-Nov-09

13-Nov-09

6-Nov-09

6-Nov-09

6-Nov-09

6-Nov-09

6-Nov-09

30-Oct-09

30-Oct-09

30-Oct-09

30-Oct-09

30-Oct-09

30-Oct-09

30-Oct-09

30-Oct-09

30-Oct-09

23-Oct-09

23-Oct-09

23-Oct-09

23-Oct-09

23-Oct-09

23-Oct-09

23-Oct-09

16-Oct-09

2-Oct-09

2-Oct-09

2-Oct-09

25-Sep-09

18-Sep-09

18-Sep-09

11-Sep-09

11-Sep-09

11-Sep-09

4-Sep-09

4-Sep-09

4-Sep-09

4-Sep-09

4-Sep-09

28-Aug-09

28-Aug-09

28-Aug-09

21-Aug-09

21-Aug-09

21-Aug-09

21-Aug-09

14-Aug-09

14-Aug-09

14-Aug-09

14-Aug-09

14-Aug-09

7-Aug-09

7-Aug-09

7-Aug-09

31-Jul-09

31-Jul-09

31-Jul-09

31-Jul-09

31-Jul-09

24-Jul-09

24-Jul-09

24-Jul-09

24-Jul-09

24-Jul-09

24-Jul-09

24-Jul-09

17-Jul-09

17-Jul-09

17-Jul-09

17-Jul-09

10-Jul-09

2-Jul-09

2-Jul-09

2-Jul-09

2-Jul-09

2-Jul-09

2-Jul-09

2-Jul-09

26-Jun-09

26-Jun-09

26-Jun-09

26-Jun-09

26-Jun-09

19-Jun-09

19-Jun-09

19-Jun-09

5-Jun-09

22-May-09

22-May-09

21-May-09

8-May-09

1-May-09

1-May-09

1-May-09

24-Apr-09

24-Apr-09

24-Apr-09

24-Apr-09

17-Apr-09

17-Apr-09

10-Apr-09

10-Apr-09

27-Mar-09

20-Mar-09

20-Mar-09

20-Mar-09

6-Mar-09

27-Feb-09

27-Feb-09

20-Feb-09

13-Feb-09

13-Feb-09

13-Feb-09

13-Feb-09

6-Feb-09

6-Feb-09

6-Feb-09

30-Jan-09

30-Jan-09

30-Jan-09

23-Jan-09

16-Jan-09

16-Jan-09

12-Dec-08

12-Dec-08

5-Dec-08

21-Nov-08

21-Nov-08

21-Nov-08

7-Nov-08

7-Nov-08

31-Oct-08

24-Oct-08

10-Oct-08

10-Oct-08

25-Sep-08

19-Sep-08

5-Sep-08

29-Aug-08

22-Aug-08

1-Aug-08

25-Jul-08

25-Jul-08

11-Jul-08

30-May-08

9-May-08

7-Mar-08

25-Jan-08

4-Oct-07

28-Sep-07

2-Feb-07

25-Jun-04

19-Mar-04

12-Mar-04

14-Feb-04

14-Nov-03

9-May-03

7-Feb-03

17-Dec-02

8-Nov-02

30-Sep-02

27-Jun-02

26-Jun-02

28-Mar-02

1-Mar-02

7-Feb-02

1-Feb-02

18-Jan-02

11-Jan-02

7-Sep-01

27-Jul-01

3-May-01

2-Feb-01

14-Dec-00

13-Oct-00

image text in transcribed
DI JX Closing Date B C D E F G H K L M N O P Q Bank Name City State Closing Date Fort Lee Federal Savings Bank, FSB Fort Lee NJ 20-Apr-12 W N Fidelity Bank Dearborn MI 30-Mar-12 Premier Bank Wilmette IL 23-Mar-12 UT Covenant Bank & Trust Rock Spring GA 23-Mar-12 6 New City Bank Chicago IL 9-Mar-12 Global Commerce Bank Doraville GA 2-Mar-12 8 Home Savings of America Little Falls MN 24-Feb-12 Central Bank of Georgia Ellaville GA 24-Feb-12 10 SCB Bank Shelbyville IN 10-Feb-12 11 Charter National Bank and Trust Hoffman Estates IL 10-Feb-12 12 Bank East Knoxville TN 27-Jan-12 13 Patriot Bank Minnesota Forest Lake MN 27-Jan-12 14 Tennessee Commerce Bank Franklin TN 27-Jan-12 15 First Guaranty Bank and Trust Company of Jacksonville Jacksonville FL 27-Jan-12 16 American Eagle Savings Bank Boothwyn PA 20-Jan-12 17 The First State Bank Stockbridge GA 20-Jan-12 18 Central Florida State Bank Belleview FL 20-Jan-12 19 Western National Bank Phoenix AZ 16-Dec-11 20 Premier Community Bank of the Emerald Coast Crestview FL 16-Dec-11 21 Central Progressive Bank Lacombe LA 18-Nov-11 22 Polk County Bank Johnston IA 18-Nov-11 23 Community Bank of Rockmart Rockmart GA 10-Nov-11 24 SunFirst Bank Saint George UT 4-Nov-11 25 Mid City Bank, Inc. Omaha NE 4-Nov-11

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

9781266566899

Students also viewed these Mathematics questions