Does the project appear economically viable

Assignment Help Other Subject

Reference no: EM133689733

Case #1: The Procter & Gamble Company: Investment in Crest Whitestrips Advanced Seal

Note that to complete this assignment, each group (3 students) must write-up a report that contains both executive summary and detailed analysis. All students must prepare for class discussion.

Executive summary should contains all info for executive to understand the issue and help them make proper decision. The summary should not be longer than one page.

The rest of the report should be between 3-10 pages. The length of the report is not our focus as long as you provide all answers adequately and write the report well. The report should be understandable by people who do not know much about finance concepts.

Change the unit price of Basic product to $13.6 per unit. If you use $13 in your report, it will be automatic 1 point penalty out of 10 points maximum score.

Write a report to answer the following questions.

Question 1: Does the project appear economically viable? Which strategic proposal do you find most appealing? Build a four-year DCF model to support your recommendation

Question 2: What are the key value drivers of the Advanced Seal Investment? Conduct sensitivity analysis to identify which factors affect NPV of the projects the most.

Question 3: What recommendation would you make to Roman for P&G's investment in Advanced Seal? Note that you can also create a new recommendation. You don't have to follow the ones shown in the case. You should be creative.

Clarification
Let's assume that $1.5 million in one-time development expenses will not be capitalized. Treat this as expenses at time 0.
For depreciation, the case recommends five-year accelerated schedule for tax purpose.
Because we are focusing on cash flow which is directly linked to tax, we therefore should use five-year accelerated schedule to compute FCF.

20% in year 1
32% in year 2
19.2% in year 3
11.52% in year 4
11.52% in year 5
5.76% in year 6
The depreciation schedule above follows half-year convention

Using the half-year convention, a taxpayer claims a half of a year's depreciation for the first taxable year, regardless of when the property was actually put into service. It is assumed that the property being depreciated was placed into service at the midpoint of the year. To compensate for this computation, the taxpayer is entitled to another half-year of depreciation at the end of the normal recovery period
Here is an example of how to handle a situation in which you use the machine for 2 years but the depreciation schedule is 3 years.
Capital Expenditure at time 0 = 90
Depreciation = 30 per year for 3 years
However, you use machine only for 2 years and its market value at the end of year 2 = 0
At the end of year 2, Book value = 30, you can write off this book value and create accounting loss which will have tax benefit because it will help us reduce tax of the firm by 30 * Tax rate. If tax rate = 20% then this write off will create positive cash flow effect 30*20% = 6 at the end of year 2. The machine will not show up on balance sheet after writing it off.

Cannibalization
From the case "... cannibalization of existing Crest Whitestrips products would be high, on the order of 50% to 60% for Premium units and 15% for Basic units. Such cannibalization rates meant that 65% to 75% of Advanced Seal's 2 million expected units was coming straight out of existing P&G sales".

Notice that the statements above focus on "units". This means that if P&G sells 100 units of Advanced Seal, P&G will sell Premium 50 to 60 units fewer and sell Basic 15 units fewer.

Reference no: EM133689733

Questions Cloud

Explain how the element will help students learn : For each element of your activity plan, explain how this element will help students learn about their senses and aid in their development.

What is the purpose of the allen test : What is the purpose of the Allen test? Should you perform an Allen test when drawing from a brachial artery?

Analyze the rationale for health insurance expansion : Analyze the rationale for health insurance expansion. Include how health insurance expansion relates to the problem of adverse selection.

Which minerals do they fail to consume most of : Why do many athletes and non-athletes fail to consume an adequate amount of minerals? Which minerals do they fail to consume most of?

Does the project appear economically viable : FINA 5120 Corporate Finance, The Hong Kong University of Science and Technology - Does the project appear economically viable? Which strategic proposal

How did you feel as you broke the norm : Give a clear definition of what the norm is and how your behavior violated it. How did you feel as you broke the norm?

Explain the normal anatomy of the system the disease : Through this two-part discussion with classmates, will state diagnosis, explain the normal anatomy of the system the disease impacts the most.

Discuss advantages and disadvantages of each model : Discuss advantages and disadvantages of each model. Provide 1-2 examples of types of activities that would be appropriate for each model.

What questions have come up for you at this point : What questions have come up for you at this point? Do you have any helpful tips that you've picked up in this course or in a past course?

User Account

All Pages