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

Don't use plagiarized sources. Get Your Custom Essay on
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
Just from $13/Page
Order Essay
Homework On Time
Calculate the Price of your PAPER Now
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.

Admissions

Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.

Reviews

Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.

Reviews

Revising your paper

Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers

See all services