Question: 1) Use the base case assumptions as well as the information presented in the case to build a four-year discounted cash flow model for Advanced

1) Use the base case assumptions 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 file provided for the project.

2) 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.

3) 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.

4) 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.

5) 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.

6) Summarize your results for part (1) to (5) using the “summary of scenarios “template provided in the excel file. Also, please recommend what P&G should do (between Proposal to Drive Revenue & Proposal to Minimize Cannibalization )

Step by Step Solution

★★★★★

3.46 Rating (182 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer 1 Using a 50 cannibalization rate for the Premium Product and a 15 cannibalization rate for the Basic Product the NPV and IRR results for the fouryear discounted cash flow model for Advanced Se... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Use excel to do your analysis. Follow the steps and have what if analysis data table for your car loan case. You are loaning 20,000 with 8.5 % interest for 60 months. In this scenario you need to pay...

Need to answer quickly, please use Excel to answer questions, and calculate accurately and in detail. For the exact answer, I will click and give a thumbs up. thank you Gogba, is a former...

Financial Planning: Ryan Daniels, age 32, graduated 5 years ago with an MBA and is currently employed as a manager in a fairly successful local food manufacturer. His current annual salary of $85,000...

The earnings, dividends, and stock price of Carpet to Technologies Inc. are expected to grow at 7 percent per year in the future. Carpettos common stock sells for $23 per share, its last dividend was...

An important rule is that you should never show a nominal rate on a time line or use it in calculations unless what condition holds? (Hint: think of annual compounding, when iNom = EAR = iPer.) What...

What is the estimated cost of equity using the discounted cash flow (DCF) approach? MINI CASE During the last few years, Harry Davis Industries has been too constrained by the high cost of capital to...

Sam Johnson inherited $85,000 from his father. Sam is considering investing the money in a house, which he will then rent to tenants. The $85,000 cost of the property, consists of $17,500 for the...

If you want an investment to double in three years, what interest rate must it earn? MINI CASE Assume that you are nearing graduation and that you have applied for a job with a local bank. As part of...

What is the effective annual rate (EAR)? What is the ear for a nominal rate of 12 percent, compounded semiannually? Compounded quarterly? Compounded monthly? Compounded daily? MINI CASE Assume that...

Define each of the following terms: a. Project cash flow; accounting income b. Incremental cash flow; sunk cost; opportunity cost; externality; cannibalization; expansion project; replacement project...

a. What are the expected return and standard deviation of returns on his portfolio? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) b. How would...

Computerized medical records have promoted ________ in recent years, while industry costs are ________. Question 28 options: a) greater efficiency; rising b) decreased privacy; declining c) greater...

You recently bought a home M7.5 Discussion: Considering the Possibilities in Your Own Backyardwith a structure distant from the main house. This area was used as an art studio by the previous owner....

When several conditions are necessary for the top event to occur, we use the "AND" symbol. If the failure rates (IE probabilities) are known for each of these conditions, what would we then do to...

Question 1 Which theoretical probabilities are equal to 1/3? Check all that apply. landing on a star space on the first roll rolling an even number on the first roll landing at Cat Town on the first...

Suppose you put $1,500per month into a Roth IRA, that pays 10%APR (compounded monthly).Assume you have nothing saved today, calculate the future value of the retirement account 30 years from today....

Assuming that each of the following bit patterns originally had even parity, which one contains an error? Question 1 4 options: 1 0 0 0 0 1 0 0 1 0 0 0 0 1 1 0 0 0 1 0 0 1 1 0 1 0 0 1 0 0 0 0 0 0 1 1

The following information is for Montreal Gloves Inc. for the year 2020: Manufacturing costs Number of gloves manufactured Beginning inventory $ 3,016,700 311,000 pairs 0 pairs Sales in 2020 were...

What is ADO.NET, and what two new features make it important for application development?

What are the typical activities involved in the maintenance of the DBMS and its utilities and applications? Would you consider application performance tuning to be part of the maintenance activities?...

The DBMS does not guarantee that the semantic meaning of the transaction truly represents the real-world event. What are the possible consequences of that limitation? Give an example.

The policy of the Suburban Transit Authority is to add a bus route if more than 55% of the potential commuters indicate they would use the particular route. A sample of 70 commuters revealed that 42...

A coin toss is used to decide which team gets the ball first in most sports. It involves little effort and is believed to give each side the same chance. In 47 Super Bowl games, the National Football...

An urban planner claims that, nationally, 20% of all families renting condominiums move during a given year. A random sample of 200 families renting condominiums in the Dallas Metroplex revealed that...