Please answer using excel!

Use the spreadsheet from this problem:

Address only the first three items in the case study (1 thru 4). Skip item 4 and the correlations. Be sure to provide the excel model set up as well as the @RISK run with output. Provide the NPV of the 4 year operation for the following scenarios:

Low End Product Design, Mildly Aggressive Marketing Campaign

Low End Product Design, Very Aggressive Marketing Campaign

High End Product Design, Mildly Aggressive Marketing Campaign

High End Product Design, Very Aggressive Marketing Campaign

CASE 10.4 New Product Introduction at eTech marketing,andcompetitorbehavior.TheadjustmentswithnocompetingproductappearinTable2.3.TheadjustmentswithacompetingproductappearinTable2.4.EachadjustmentistodemandfortheePlayerXineachofyears2to4.Forexample,iftheadjustmentis10%,thendemandineachofyears2to4willbe10%lowerthanitwouldhavebeeninthebasecase.Demandandunitssoldarethesame-thatis,eTechwillproduceexactlywhatitscustomersdemandsothatnoinventoryorbackorderswilloccur. New production introduction at eTech Input section Forecasts of net revenues from existing products, with no cannibalization (\$ millions) CASE 10.4 New Product Introduction at eTech marketing,andcompetitorbehavior.TheadjustmentswithnocompetingproductappearinTable2.3.TheadjustmentswithacompetingproductappearinTable2.4.EachadjustmentistodemandfortheePlayerXineachofyears2to4.Forexample,iftheadjustmentis10%,thendemandineachofyears2to4willbe10%lowerthanitwouldhavebeeninthebasecase.Demandandunitssoldarethesame-thatis,eTechwillproduceexactlywhatitscustomersdemandsothatnoinventoryorbackorderswilloccur. New production introduction at eTech Input section Forecasts of net revenues from existing products, with no cannibalization (\$ millions)