Project Case Analysis Report Assume your responsibility is to analyze a pool of investment options from around the country. A capital budget with a cap of

Project Case Analysis Report Assume your responsibility is to analyze a pool of investment options from around the country. A capital budget with a cap of $435,000 is available. Using Excel, first, analyze the investments individually using three methods and rank them accordingly. Second, consolidate the results for all three methods on a single worksheet for additional analysis. Plant
Albuquerque; New Mexico
Anaheim; California
Anchorage municipality, Alaska
Arlington; Texas
Atlanta; Georgia
Aurora; Colorado
Austin; Texas
Bakersfield; California
Baltimore; Maryland
Baton Rouge; Louisiana
Birmingham; Alabama
Boise; Idaho
Boston; Massachusetts
Buffalo; New York
Chandler; Arizona
Charlotte; North Carolina
Chesapeake; Virginia
Chicago; Illinois
Chula Vista; California
Cincinnati; Ohio
Cleveland; Ohio
Colorado Springs; Colorado
Columbus; Ohio
Corpus Christi; Texas
Dallas; Texas
Denver; Colorado
Detroit; Michigan
Durham; North Carolina
El Paso; Texas
Fort Wayne; Indiana
Fort Worth; Texas
Fremont; California
Fresno; California
Garland; Texas
Gilbert town, Arizona
Glendale; Arizona
Greensboro; North Carolina
Henderson; Nevada
Hialeah; Florida
Honolulu; Hawaii
Houston; Texas
Indianapolis; Indiana
Irvine; California
Irving; Texas
Jacksonville; Florida
Initial
Investment
(20,000)
(40,000)
(22,000)
(38,000)
(29,000)
(20,000)
(25,000)
(29,000)
(32,000)
(30,000)
(35,000)
(25,000)
(20,000)
(32,000)
(33,000)
(26,000)
(22,000)
(27,000)
(27,000)
(28,000)
(22,000)
(24,000)
(32,000)
(29,000)
(20,000)
(32,000)
(34,000)
(28,000)
(26,000)
(32,000)
(37,000)
(21,000)
(34,000)
(21,000)
(40,000)
(31,000)
(26,000)
(27,000)
(23,000)
(22,000)
(23,000)
(27,000)
(31,000)
(24,000)
(20,000)
Year 1
10,000
20,000
16,000
16,000
6,000
16,000
7,000
17,000
3,000
18,000
20,000
17,000
8,000
13,000
19,000
15,000
7,000
11,000
4,000
12,000
19,000
9,000
9,000
8,000
15,000
5,000
9,000
19,000
2,000
8,000
19,000
16,000
16,000
6,000
9,000
12,000
12,000
20,000
14,000
3,000
16,000
4,000
2,000
7,000
11,000
Year 2
8,000
13,000
5,000
14,000
16,000
15,000
12,000
16,000
17,000
2,000
16,000
9,000
5,000
4,000
14,000
14,000
10,000
10,000
12,000
9,000
18,000
10,000
7,000
16,000
10,000
12,000
6,000
20,000
3,000
4,000
20,000
3,000
15,000
14,000
12,000
20,000
20,000
7,000
17,000
11,000
16,000
2,000
18,000
5,000
10,000
Year 3
9,000
14,000
4,000
10,000
3,000
15,000
8,000
8,000
2,000
6,000
7,000
19,000
11,000
14,000
19,000
18,000
19,000
5,000
13,000
2,000
5,000
10,000
18,000
15,000
20,000
15,000
4,000
4,000
17,000
18,000
10,000
5,000
16,000
12,000
20,000
18,000
18,000
16,000
7,000
2,000
13,000
12,000
10,000
2,000
2,000
Year 4
8,600
16,000
8,000
14,000
5,000
13,000
8,000
20,000
9,000
6,000
6,000
11,000
19,000
16,000
14,000
11,000
15,000
11,000
3,000
17,000
12,000
4,000
8,000
2,000
18,000
12,000
19,000
20,000
16,000
15,000
8,000
14,000
20,000
2,000
8,000
8,000
5,000
20,000
20,000
2,000
17,000
1,000
1,000
12,000
2,000
Payback
Jersey ; New Jersey
Kansas ; Missouri
Laredo; Texas
Las Vegas; Nevada
Lexington-Fayette; Kentucky
Lincoln; Nebraska
Long Beach; California
Los Angeles; California
Louisville/Jefferson; Kentucky
Lubbock; Texas
Madison; Wisconsin
Memphis; Tennessee
Mesa; Arizona
Miami; Florida
Milwaukee; Wisconsin
Minneapolis; Minnesota
Nashville-Davidson; Tennessee
New Orleans; Louisiana
New York City; New York
Newark; New Jersey
Norfolk; Virginia
North Las Vegas; Nevada
Oakland; California
Oklahoma ; Oklahoma
Omaha; Nebraska
Orlando; Florida
Philadelphia; Pennsylvania
Phoenix; Arizona
Pittsburgh; Pennsylvania
Plano; Texas
Portland; Oregon
Raleigh; North Carolina
Reno; Nevada
Riverside; California
Sacramento; California
San Antonio; Texas
San Bernardino; California
San Diego; California
San Francisco; California
San Jose; California
Santa Ana; California
Scottsdale; Arizona
Seattle; Washington
St. Louis; Missouri
St. Paul; Minnesota
St. Petersburg; Florida
Stockton; California
(26,000)
(40,000)
(25,000)
(37,000)
(32,000)
(33,000)
(35,000)
(35,000)
(24,000)
(20,000)
(24,000)
(29,000)
(24,000)
(39,000)
(20,000)
(30,000)
(35,000)
(26,000)
(38,000)
(21,000)
(29,000)
(26,000)
(20,000)
(28,000)
(39,000)
(28,000)
(30,000)
(37,000)
(37,000)
(38,000)
(40,000)
(25,000)
(34,000)
(27,000)
(27,000)
(40,000)
(31,000)
(38,000)
(33,000)
(20,000)
(23,000)
(20,000)
(32,000)
(40,000)
(29,000)
(30,000)
(36,000)
18,000
7,000
20,000
3,000
14,000
5,000
10,000
14,000
11,000
19,000
12,000
20,000
10,000
15,000
4,000
14,000
7,000
8,000
17,000
3,000
8,000
14,000
19,000
5,000
20,000
15,000
15,000
2,000
11,000
8,000
6,000
5,000
3,000
18,000
11,000
9,000
3,000
19,000
14,000
19,000
9,000
19,000
9,000
15,000
16,000
8,000
10,000
9,000
11,000
5,000
18,000
17,000
18,000
20,000
4,000
1,000
12,000
15,000
13,000
14,000
10,000
5,000
17,000
13,000
20,000
16,000
17,000
5,000
7,000
19,000
17,000
9,000
2,000
17,000
17,000
9,000
9,000
17,000
19,000
15,000
2,000
3,000
5,000
15,000
7,000
19,000
19,000
7,000
15,000
19,000
15,000
7,000
13,000
15,000
10,000
16,000
13,000
6,000
15,000
8,000
16,000
11,000
17,000
2,000
4,000
1,000
3,000
6,000
2,000
18,000
11,000
4,000
16,000
12,000
19,000
20,000
17,000
9,000
17,000
9,000
5,000
5,000
10,000
20,000
20,000
15,000
9,000
3,000
12,000
8,000
15,000
4,000
15,000
1,000
7,000
14,000
14,000
9,000
6,000
2,000
8,000
20,000
11,000
20,000
11,000
9,000
2,000
20,000
18,000
9,000
15,000
2,000
4,000
14,000
14,000
12,000
4,000
4,000
10,000
16,000
7,000
10,000
5,000
1,000
4,000
9,000
14,000
2,000
20,000
7,000
4,000
9,000
11,000
9,000
5,000
10,000
19,000
1,000
18,000
5,000
14,000
5,000
12,000
11,000
7,000
3,000
14,000
3,000
Tampa; Florida
Toledo; Ohio
Tucson; Arizona
Tulsa; Oklahoma
Virginia Beach; Virginia
Washington; DC
Wichita; Kansas
Winston-Salem; North Carolina
(30,000)
(37,000)
(22,000)
(25,000)
(27,000)
(23,000)
(21,000)
(38,000)
9,000
2,000
6,000
16,000
15,000
16,000
14,000
14,000
8,000
8,000
17,000
11,000
10,000
2,000
6,000
6,000
10,000
9,000
2,000
18,000
15,000
1,000
14,000
20,000
14,000
5,000
3,000
14,000
19,000
15,000
15,000
4,000
NPV
IRR
Plant
Albuquerque; New Mexico
Anaheim; California
Anchorage municipality, Alaska
Arlington; Texas
Atlanta; Georgia
Aurora; Colorado
Austin; Texas
Bakersfield; California
Baltimore; Maryland
Baton Rouge; Louisiana
Birmingham; Alabama
Boise; Idaho
Boston; Massachusetts
Buffalo; New York
Chandler; Arizona
Charlotte; North Carolina
Chesapeake; Virginia
Chicago; Illinois
Chula Vista; California
Cincinnati; Ohio
Cleveland; Ohio
Colorado Springs; Colorado
Columbus; Ohio
Corpus Christi; Texas
Dallas; Texas
Denver; Colorado
Detroit; Michigan
Durham; North Carolina
El Paso; Texas
Fort Wayne; Indiana
Fort Worth; Texas
Fremont; California
Fresno; California
Garland; Texas
Gilbert town, Arizona
Glendale; Arizona
Greensboro; North Carolina
Henderson; Nevada
Hialeah; Florida
Honolulu; Hawaii
Houston; Texas
Indianapolis; Indiana
Irvine; California
Irving; Texas
Jacksonville; Florida
Jersey ; New Jersey
Initial Investment
(20,000)
(40,000)
(22,000)
(38,000)
(29,000)
(20,000)
(25,000)
(29,000)
(32,000)
(30,000)
(35,000)
(25,000)
(20,000)
(32,000)
(33,000)
(26,000)
(22,000)
(27,000)
(27,000)
(28,000)
(22,000)
(24,000)
(32,000)
(29,000)
(20,000)
(32,000)
(34,000)
(28,000)
(26,000)
(32,000)
(37,000)
(21,000)
(34,000)
(21,000)
(40,000)
(31,000)
(26,000)
(27,000)
(23,000)
(22,000)
(23,000)
(27,000)
(31,000)
(24,000)
(20,000)
(26,000)
Year 1
10,000
20,000
16,000
16,000
6,000
16,000
7,000
17,000
3,000
18,000
20,000
17,000
8,000
13,000
19,000
15,000
7,000
11,000
4,000
12,000
19,000
9,000
9,000
8,000
15,000
5,000
9,000
19,000
2,000
8,000
19,000
16,000
16,000
6,000
9,000
12,000
12,000
20,000
14,000
3,000
16,000
4,000
2,000
7,000
11,000
18,000
Year 2
8,000
13,000
5,000
14,000
16,000
15,000
12,000
16,000
17,000
2,000
16,000
9,000
5,000
4,000
14,000
14,000
10,000
10,000
12,000
9,000
18,000
10,000
7,000
16,000
10,000
12,000
6,000
20,000
3,000
4,000
20,000
3,000
15,000
14,000
12,000
20,000
20,000
7,000
17,000
11,000
16,000
2,000
18,000
5,000
10,000
9,000
Year 3
9,000
14,000
4,000
10,000
3,000
15,000
8,000
8,000
2,000
6,000
7,000
19,000
11,000
14,000
19,000
18,000
19,000
5,000
13,000
2,000
5,000
10,000
18,000
15,000
20,000
15,000
4,000
4,000
17,000
18,000
10,000
5,000
16,000
12,000
20,000
18,000
18,000
16,000
7,000
2,000
13,000
12,000
10,000
2,000
2,000
10,000
Year 4
8,600
16,000
8,000
14,000
5,000
13,000
8,000
20,000
9,000
6,000
6,000
11,000
19,000
16,000
14,000
11,000
15,000
11,000
3,000
17,000
12,000
4,000
8,000
2,000
18,000
12,000
19,000
20,000
16,000
15,000
8,000
14,000
20,000
2,000
8,000
8,000
5,000
20,000
20,000
2,000
17,000
1,000
1,000
12,000
2,000
20,000
Year 1
(10,000)
(20,000)
(6,000)
(22,000)
(23,000)
(4,000)
(18,000)
(12,000)
(29,000)
(12,000)
(15,000)
(8,000)
(12,000)
(19,000)
(14,000)
(11,000)
(15,000)
(16,000)
(23,000)
(16,000)
(3,000)
(15,000)
(23,000)
(21,000)
(5,000)
(27,000)
(25,000)
(9,000)
(24,000)
(24,000)
(18,000)
(5,000)
(18,000)
(15,000)
(31,000)
(19,000)
(14,000)
(7,000)
(9,000)
(19,000)
(7,000)
(23,000)
(29,000)
(17,000)
(9,000)
(8,000)
Kansas ; Missouri
Laredo; Texas
Las Vegas; Nevada
Lexington-Fayette; Kentucky
Lincoln; Nebraska
Long Beach; California
Los Angeles; California
Louisville/Jefferson; Kentucky
Lubbock; Texas
Madison; Wisconsin
Memphis; Tennessee
Mesa; Arizona
Miami; Florida
Milwaukee; Wisconsin
Minneapolis; Minnesota
Nashville-Davidson; Tennessee
New Orleans; Louisiana
New York City; New York
Newark; New Jersey
Norfolk; Virginia
North Las Vegas; Nevada
Oakland; California
Oklahoma ; Oklahoma
Omaha; Nebraska
Orlando; Florida
Philadelphia; Pennsylvania
Phoenix; Arizona
Pittsburgh; Pennsylvania
Plano; Texas
Portland; Oregon
Raleigh; North Carolina
Reno; Nevada
Riverside; California
Sacramento; California
San Antonio; Texas
San Bernardino; California
San Diego; California
San Francisco; California
San Jose; California
Santa Ana; California
Scottsdale; Arizona
Seattle; Washington
St. Louis; Missouri
St. Paul; Minnesota
St. Petersburg; Florida
Stockton; California
Tampa; Florida
(40,000)
(25,000)
(37,000)
(32,000)
(33,000)
(35,000)
(35,000)
(24,000)
(20,000)
(24,000)
(29,000)
(24,000)
(39,000)
(20,000)
(30,000)
(35,000)
(26,000)
(38,000)
(21,000)
(29,000)
(26,000)
(20,000)
(28,000)
(39,000)
(28,000)
(30,000)
(37,000)
(37,000)
(38,000)
(40,000)
(25,000)
(34,000)
(27,000)
(27,000)
(40,000)
(31,000)
(38,000)
(33,000)
(20,000)
(23,000)
(20,000)
(32,000)
(40,000)
(29,000)
(30,000)
(36,000)
(30,000)
7,000
20,000
3,000
14,000
5,000
10,000
14,000
11,000
19,000
12,000
20,000
10,000
15,000
4,000
14,000
7,000
8,000
17,000
3,000
8,000
14,000
19,000
5,000
20,000
15,000
15,000
2,000
11,000
8,000
6,000
5,000
3,000
18,000
11,000
9,000
3,000
19,000
14,000
19,000
9,000
19,000
9,000
15,000
16,000
8,000
10,000
9,000
11,000
5,000
18,000
17,000
18,000
20,000
4,000
1,000
12,000
15,000
13,000
14,000
10,000
5,000
17,000
13,000
20,000
16,000
17,000
5,000
7,000
19,000
17,000
9,000
2,000
17,000
17,000
9,000
9,000
17,000
19,000
15,000
2,000
3,000
5,000
15,000
7,000
19,000
19,000
7,000
15,000
19,000
15,000
7,000
13,000
15,000
8,000
16,000
13,000
6,000
15,000
8,000
16,000
11,000
17,000
2,000
4,000
1,000
3,000
6,000
2,000
18,000
11,000
4,000
16,000
12,000
19,000
20,000
17,000
9,000
17,000
9,000
5,000
5,000
10,000
20,000
20,000
15,000
9,000
3,000
12,000
8,000
15,000
4,000
15,000
1,000
7,000
14,000
14,000
9,000
6,000
2,000
8,000
10,000
11,000
20,000
11,000
9,000
2,000
20,000
18,000
9,000
15,000
2,000
4,000
14,000
14,000
12,000
4,000
4,000
10,000
16,000
7,000
10,000
5,000
1,000
4,000
9,000
14,000
2,000
20,000
7,000
4,000
9,000
11,000
9,000
5,000
10,000
19,000
1,000
18,000
5,000
14,000
5,000
12,000
11,000
7,000
3,000
14,000
3,000
14,000
(33,000)
(5,000)
(34,000)
(18,000)
(28,000)
(25,000)
(21,000)
(13,000)
(1,000)
(12,000)
(9,000)
(14,000)
(24,000)
(16,000)
(16,000)
(28,000)
(18,000)
(21,000)
(18,000)
(21,000)
(12,000)
(1,000)
(23,000)
(19,000)
(13,000)
(15,000)
(35,000)
(26,000)
(30,000)
(34,000)
(20,000)
(31,000)
(9,000)
(16,000)
(31,000)
(28,000)
(19,000)
(19,000)
(1,000)
(14,000)
(1,000)
(23,000)
(25,000)
(13,000)
(22,000)
(26,000)
(21,000)
Toledo; Ohio
Tucson; Arizona
Tulsa; Oklahoma
Virginia Beach; Virginia
Washington; DC
Wichita; Kansas
Winston-Salem; North Carolina
(37,000)
(22,000)
(25,000)
(27,000)
(23,000)
(21,000)
(38,000)
2,000
6,000
16,000
15,000
16,000
14,000
14,000
8,000
17,000
11,000
10,000
2,000
6,000
6,000
9,000
2,000
18,000
15,000
1,000
14,000
20,000
5,000
3,000
14,000
19,000
15,000
15,000
4,000
(35,000)
(16,000)
(9,000)
(12,000)
(7,000)
(7,000)
(24,000)
Year 2
(2,000)
(7,000)
(1,000)
(8,000)
(7,000)
11,000
(6,000)
4,000
(12,000)
(10,000)
1,000
1,000
(7,000)
(15,000)
3,000
(5,000)
(6,000)
(11,000)
(7,000)
15,000
(5,000)
(16,000)
(5,000)
5,000
(15,000)
(19,000)
11,000
(21,000)
(20,000)
2,000
(2,000)
(3,000)
(1,000)
(19,000)
1,000
6,000
8,000
(8,000)
9,000
(21,000)
(11,000)
(12,000)
1,000
1,000
Year 3
7,000
7,000
3,000
2,000
(4,000)
26,000
2,000
12,000
(10,000)
(4,000)
8,000
20,000
4,000
(1,000)
19,000
21,000
14,000
(1,000)
2,000
(5,000)
20,000
5,000
2,000
10,000
25,000
(15,000)
15,000
(4,000)
(2,000)
12,000
3,000
13,000
11,000
1,000
19,000
24,000
16,000
15,000
(6,000)
22,000
(9,000)
(1,000)
(10,000)
3,000
11,000
Year 4
15,600
23,000
11,000
16,000
1,000
39,000
10,000
32,000
(1,000)
2,000
14,000
31,000
23,000
15,000
33,000
32,000
29,000
10,000
5,000
12,000
32,000
9,000
10,000
12,000
43,000
12,000
4,000
35,000
12,000
13,000
20,000
17,000
33,000
13,000
9,000
27,000
29,000
36,000
35,000
(4,000)
39,000
(8,000)
2,000
5,000
31,000
Payback
2.2
(22,000)
(16,000)
(1,000)
(10,000)
(5,000)
(17,000)
(12,000)
11,000
3,000
4,000
(14,000)
(11,000)
1,000
(15,000)
2,000
(5,000)
(1,000)
(16,000)
(5,000)
18,000
(6,000)
(10,000)
(11,000)
2,000
(18,000)
(17,000)
(21,000)
(17,000)
(1,000)
(16,000)
(7,000)
(13,000)
(26,000)
(13,000)
(12,000)
18,000
(7,000)
14,000
(4,000)
(10,000)
(6,000)
(9,000)
(11,000)
(13,000)
(6,000)
13,000
(10,000)
14,000
(2,000)
11,000
(6,000)
5,000
13,000
7,000
5,000
3,000
(8,000)
(9,000)
19,000
(4,000)
6,000
11,000
11,000
3,000
15,000
35,000
3,000
7,000
(2,000)
7,000
(13,000)
(7,000)
(1,000)
3,000
14,000
(7,000)
(4,000)
(1,000)
(18,000)
2,000
(8,000)
15,000
19,000
28,000
10,000
(1,000)
(7,000)
(3,000)
(3,000)
5,000
33,000
1,000
23,000
31,000
12,000
14,000
28,000
9,000
9,000
17,000
6,000
3,000
23,000
16,000
27,000
18,000
13,000
20,000
36,000
7,000
16,000
12,000
9,000
7,000
3,000
12,000
25,000
2,000
1,000
9,000
1,000
3,000
10,000
20,000
33,000
5,000
40,000
21,000
6,000
3,000
7,000
11,000
(27,000)
1,000
2,000
(2,000)
(5,000)
(1,000)
(18,000)
(18,000)
3,000
20,000
13,000
(4,000)
13,000
2,000
(13,000)
6,000
34,000
32,000
11,000
28,000
6,000
Plant
Albuquerque; New Mexico
Anaheim; California
Anchorage municipality, Alaska
Arlington; Texas
Atlanta; Georgia
Aurora; Colorado
Austin; Texas
Bakersfield; California
Baltimore; Maryland
Baton Rouge; Louisiana
Birmingham; Alabama
Boise; Idaho
Boston; Massachusetts
Buffalo; New York
Chandler; Arizona
Charlotte; North Carolina
Chesapeake; Virginia
Chicago; Illinois
Chula Vista; California
Cincinnati; Ohio
Cleveland; Ohio
Colorado Springs; Colorado
Columbus; Ohio
Corpus Christi; Texas
Dallas; Texas
Denver; Colorado
Detroit; Michigan
Durham; North Carolina
El Paso; Texas
Fort Wayne; Indiana
Fort Worth; Texas
Fremont; California
Fresno; California
Garland; Texas
Gilbert town, Arizona
Glendale; Arizona
Greensboro; North Carolina
Henderson; Nevada
Hialeah; Florida
Honolulu; Hawaii
Houston; Texas
Indianapolis; Indiana
Irvine; California
Irving; Texas
Jacksonville; Florida
Jersey ; New Jersey
Initial Investment
(20,000)
(40,000)
(22,000)
(38,000)
(29,000)
(20,000)
(25,000)
(29,000)
(32,000)
(30,000)
(35,000)
(25,000)
(20,000)
(32,000)
(33,000)
(26,000)
(22,000)
(27,000)
(27,000)
(28,000)
(22,000)
(24,000)
(32,000)
(29,000)
(20,000)
(32,000)
(34,000)
(28,000)
(26,000)
(32,000)
(37,000)
(21,000)
(34,000)
(21,000)
(40,000)
(31,000)
(26,000)
(27,000)
(23,000)
(22,000)
(23,000)
(27,000)
(31,000)
(24,000)
(20,000)
(26,000)
Year 1
10,000
20,000
16,000
16,000
6,000
16,000
7,000
17,000
3,000
18,000
20,000
17,000
8,000
13,000
19,000
15,000
7,000
11,000
4,000
12,000
19,000
9,000
9,000
8,000
15,000
5,000
9,000
19,000
2,000
8,000
19,000
16,000
16,000
6,000
9,000
12,000
12,000
20,000
14,000
3,000
16,000
4,000
2,000
7,000
11,000
18,000
Year 2
8,000
13,000
5,000
14,000
16,000
15,000
12,000
16,000
17,000
2,000
16,000
9,000
5,000
4,000
14,000
14,000
10,000
10,000
12,000
9,000
18,000
10,000
7,000
16,000
10,000
12,000
6,000
20,000
3,000
4,000
20,000
3,000
15,000
14,000
12,000
20,000
20,000
7,000
17,000
11,000
16,000
2,000
18,000
5,000
10,000
9,000
Year 3
9,000
14,000
4,000
10,000
3,000
15,000
8,000
8,000
2,000
6,000
7,000
19,000
11,000
14,000
19,000
18,000
19,000
5,000
13,000
2,000
5,000
10,000
18,000
15,000
20,000
15,000
4,000
4,000
17,000
18,000
10,000
5,000
16,000
12,000
20,000
18,000
18,000
16,000
7,000
2,000
13,000
12,000
10,000
2,000
2,000
10,000
Year 4
8,600
16,000
8,000
14,000
5,000
13,000
8,000
20,000
9,000
6,000
6,000
11,000
19,000
16,000
14,000
11,000
15,000
11,000
3,000
17,000
12,000
4,000
8,000
2,000
18,000
12,000
19,000
20,000
16,000
15,000
8,000
14,000
20,000
2,000
8,000
8,000
5,000
20,000
20,000
2,000
17,000
1,000
1,000
12,000
2,000
20,000
Kansas ; Missouri
Laredo; Texas
Las Vegas; Nevada
Lexington-Fayette; Kentucky
Lincoln; Nebraska
Long Beach; California
Los Angeles; California
Louisville/Jefferson; Kentucky
Lubbock; Texas
Madison; Wisconsin
Memphis; Tennessee
Mesa; Arizona
Miami; Florida
Milwaukee; Wisconsin
Minneapolis; Minnesota
Nashville-Davidson; Tennessee
New Orleans; Louisiana
New York City; New York
Newark; New Jersey
Norfolk; Virginia
North Las Vegas; Nevada
Oakland; California
Oklahoma ; Oklahoma
Omaha; Nebraska
Orlando; Florida
Philadelphia; Pennsylvania
Phoenix; Arizona
Pittsburgh; Pennsylvania
Plano; Texas
Portland; Oregon
Raleigh; North Carolina
Reno; Nevada
Riverside; California
Sacramento; California
San Antonio; Texas
San Bernardino; California
San Diego; California
San Francisco; California
San Jose; California
Santa Ana; California
Scottsdale; Arizona
Seattle; Washington
St. Louis; Missouri
St. Paul; Minnesota
St. Petersburg; Florida
Stockton; California
Tampa; Florida
(40,000)
(25,000)
(37,000)
(32,000)
(33,000)
(35,000)
(35,000)
(24,000)
(20,000)
(24,000)
(29,000)
(24,000)
(39,000)
(20,000)
(30,000)
(35,000)
(26,000)
(38,000)
(21,000)
(29,000)
(26,000)
(20,000)
(28,000)
(39,000)
(28,000)
(30,000)
(37,000)
(37,000)
(38,000)
(40,000)
(25,000)
(34,000)
(27,000)
(27,000)
(40,000)
(31,000)
(38,000)
(33,000)
(20,000)
(23,000)
(20,000)
(32,000)
(40,000)
(29,000)
(30,000)
(36,000)
(30,000)
7,000
20,000
3,000
14,000
5,000
10,000
14,000
11,000
19,000
12,000
20,000
10,000
15,000
4,000
14,000
7,000
8,000
17,000
3,000
8,000
14,000
19,000
5,000
20,000
15,000
15,000
2,000
11,000
8,000
6,000
5,000
3,000
18,000
11,000
9,000
3,000
19,000
14,000
19,000
9,000
19,000
9,000
15,000
16,000
8,000
10,000
9,000
11,000
5,000
18,000
17,000
18,000
20,000
4,000
1,000
12,000
15,000
13,000
14,000
10,000
5,000
17,000
13,000
20,000
16,000
17,000
5,000
7,000
19,000
17,000
9,000
2,000
17,000
17,000
9,000
9,000
17,000
19,000
15,000
2,000
3,000
5,000
15,000
7,000
19,000
19,000
7,000
15,000
19,000
15,000
7,000
13,000
15,000
8,000
16,000
13,000
6,000
15,000
8,000
16,000
11,000
17,000
2,000
4,000
1,000
3,000
6,000
2,000
18,000
11,000
4,000
16,000
12,000
19,000
20,000
17,000
9,000
17,000
9,000
5,000
5,000
10,000
20,000
20,000
15,000
9,000
3,000
12,000
8,000
15,000
4,000
15,000
1,000
7,000
14,000
14,000
9,000
6,000
2,000
8,000
10,000
11,000
20,000
11,000
9,000
2,000
20,000
18,000
9,000
15,000
2,000
4,000
14,000
14,000
12,000
4,000
4,000
10,000
16,000
7,000
10,000
5,000
1,000
4,000
9,000
14,000
2,000
20,000
7,000
4,000
9,000
11,000
9,000
5,000
10,000
19,000
1,000
18,000
5,000
14,000
5,000
12,000
11,000
7,000
3,000
14,000
3,000
14,000
Toledo; Ohio
Tucson; Arizona
Tulsa; Oklahoma
Virginia Beach; Virginia
Washington; DC
Wichita; Kansas
Winston-Salem; North Carolina
(37,000)
(22,000)
(25,000)
(27,000)
(23,000)
(21,000)
(38,000)
2,000
6,000
16,000
15,000
16,000
14,000
14,000
8,000
17,000
11,000
10,000
2,000
6,000
6,000
9,000
2,000
18,000
15,000
1,000
14,000
20,000
5,000
3,000
14,000
19,000
15,000
15,000
4,000
NPV
Rate
14%
(Formula hint 1: Use an absolute value for the I2 cell reference)
Check figure for Albuquerque: $6,094.30
e I2 cell reference)
Plant
Albuqu…
Purchase answer to see full
attachment