Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 01, 2024

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

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

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

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

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

Closing Date

20-Apr-12

30-Mar-12

23-Mar-12

9-Mar-12

2-Mar-12

24-Feb-12

10-Feb-12

27-Jan-12

20-Jan-12

16-Dec-11

18-Nov-11

10-Nov-11

4-Nov-11

28-Oct-11

21-Oct-11

14-Oct-11

7-Oct-11

30-Sep-11

23-Sep-11

9-Sep-11

2-Sep-11

19-Aug-11

18-Aug-11

12-Aug-11

5-Aug-11

29-Jul-11

22-Jul-11

15-Jul-11

8-Jul-11

24-Jun-11

17-Jun-11

3-Jun-11

27-May-11

20-May-11

6-May-11

29-Apr-11

15-Apr-11

8-Apr-11

25-Mar-11

11-Mar-11

25-Feb-11

18-Feb-11

11-Feb-11

4-Feb-11

28-Jan-11

21-Jan-11

14-Jan-11

7-Jan-11

17-Dec-10

10-Dec-10

19-Nov-10

12-Nov-10

5-Nov-10

22-Oct-10

15-Oct-10

1-Oct-10

24-Sep-10

17-Sep-10

10-Sep-10

20-Aug-10

13-Aug-10

6-Aug-10

30-Jul-10

23-Jul-10

16-Jul-10

9-Jul-10

25-Jun-10

18-Jun-10

11-Jun-10

4-Jun-10

28-May-10

21-May-10

14-May-10

7-May-10

30-Apr-10

23-Apr-10

16-Apr-10

9-Apr-10

26-Mar-10

19-Mar-10

12-Mar-10

11-Mar-10

5-Mar-10

26-Feb-10

19-Feb-10

5-Feb-10

29-Jan-10

22-Jan-10

15-Jan-10

8-Jan-10

18-Dec-09

11-Dec-09

4-Dec-09

20-Nov-09

13-Nov-09

6-Nov-09

30-Oct-09

23-Oct-09

16-Oct-09

2-Oct-09

25-Sep-09

18-Sep-09

11-Sep-09

4-Sep-09

28-Aug-09

21-Aug-09

14-Aug-09

7-Aug-09

31-Jul-09

24-Jul-09

17-Jul-09

10-Jul-09

2-Jul-09

26-Jun-09

19-Jun-09

5-Jun-09

22-May-09

21-May-09

8-May-09

1-May-09

24-Apr-09

17-Apr-09

10-Apr-09

27-Mar-09

20-Mar-09

6-Mar-09

27-Feb-09

20-Feb-09

13-Feb-09

6-Feb-09

30-Jan-09

23-Jan-09

16-Jan-09

12-Dec-08

5-Dec-08

21-Nov-08

7-Nov-08

31-Oct-08

24-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

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

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