Your company is developing a new product for cleaning up oil spills. This process quickly turns oil spilled from tankers into a biodegradable component, but it is expense to produce and now that you have done some intial development, you are trying to determine if it is feasible to move forward into full scale production. Based on your engineering estimates, it will cost $22,500,000 to build the production facility to make this product. It will cost $1,200,000 to operate it annually. However, you don't know how many oil spills there will be per year and how much of your product will be needed. You look over the last 25 years of history and come up with 4 scenarios and you figure they are all equally likely and your company MARR is 20% due to the risk of this project for a 10 year life. Should you do it? Please Use Excel and show equations

Scenario 1	Few Spills
Sales	$1,500,000 per year
Scenario 2	Starts high, but goes down due to conversion to Renewable Energy
Sales yr 1	8,000,000 goes down by 3% per year
Scenario 3	Starts Low, but increases due to tankers getting old and in bad shape
Sales Yr 1	3,000,000 and increases by 4% per year
Scenario 4	Steady at first, but Declines by 50% per year in years 7-10
Sales Yr 1	6,000,000

Potential Answers: A)-13,264,500 B) -9,395,633 C) -21,242,258 D)310,9099