. Use the base case assumptions (pg.4) as well as the information presented in the case to build a four-year discounted cash flow model for Advanced Seal given a 50% Cannibalization rate for the Premium Product and a 15% Cannibalization rate for the Basic Product. What are your NPV and IRR results? Please use the "Basic Template " from the Excel le provided for the project? . Calculate {1) again using a 55% Cannibalization for the Premium Product and a 15% Cannibalization rate for the Basic Product. Show your NPV and IRR results. Also, calculate (1) again using a 60% Cannibalization rate for the Premium Product and a 15% Cannibalization rate for the Basic Product. Show your NPV and IRR results. - Use the model developed in (1) to test the implications of Christina Whitman's "Proposal to Drive Revenue\" (pg_5)_ Please use a 50% Cannibalization rate for the Premium Product and a 15% Cannibalization rate for the Basic Product. Show your NPV and IRR results. Now, repeat this step but use A 57.5% Cannibalization rate for the Premium Product and a 15% Cannibalization rate for the Basic Product. Show your NPV and IRR results. A 65% Cannibalization rate for the Premium Product and a 15% Cannibalization rate for the Basic Product. Show your NPV and IRR results. - Use the model developed in (1) to test the implications of Margaret Tan's "Proposal to Minimize Cannibalization" (i.e., raising the price to $23 dollar and minimize the Cannibalization rate to 45% - pg. 6) Show your NPV and IRR results. . Going back to the base case (Questions (1) St (2)), assuming for base case there is a 30% probability for a 50% Cannibalization rate for the Premium Product, a 40% probability for a 55% Cannibalization rate for the Premium Product, and a 30% probability for a 60% Cannibalization rate for the Premium Product - calculate Expected NPV, Standard Deviation of NPV, and Coefficient of Variation of NPV. Assuming P816 generally accepts projects with a Coefficient of Variation range between 0.3 and 0.5, should P&G accept the Premium Product? Going back to Christina Whitman's I'Proposal to Drive Revenue" (Question (3), assuming for " Proposal to Drive Revenue" there is a 40% probability for a 50% Cannibalization rate for the Premium Product, a 35% probability for a 57.5% Cannibalization rate for the Premium Product, and a 25% probability for a 65% Cannibalization rate of the Premium Product - calculate Expected NPV, Standard Deviation of NPV, and Coefficient of Variation of NPV. Assuming P&G generally accepts projects with a Coefcient of Variation range between 0.3 and 0.5, should P&G accept the New Product now