must use Excel. please show work/equations used.

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? 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 Yr1 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 Yn 1 6,000,000 O -9,395 633 O-21.242 258 310,9099 0-13.264,500