Which single variable has the greatest impact on the npv

Reference no: EM131885007

Question: You are a financial analyst for a major consumer products company. They are considering the product launch of a new cereal with the following expenditures:

New Plant Cost: $10 million ($5 million upfront, $5 million at end of 1st year). Plant will take 1 year to construct. $3mm salvage value at end of 10 years

Feasibility studies: $50,000 upfront (will be expended regardless of whether the project goes forward or not).

Depreciation: Straight line over 5 years to zero, beginning at end of 1st year Unit Sales: 1 million units (sales begin at end of 1st year and grow at 5% p.a. thereafter)

Price per Unit: $5.75 per unit, growing at 2% inflation per year COGS: 60% of Sales

Fixed costs: $150,000 per annum

Working capital: $300,000 incurred at end of first year and recouped at end of 10 years

Cost of Capital: 11%

Marginal Tax Rate: 25%

1. Forecast the project's after-tax cashflows for 10 years using excel

2. What is the NPV?

3. What is the IRR?

4. Which single variable (holding the others constant) has the greatest impact on the NPV?(change each of the discount rate, price per unit, COGS, inflation rate, and tax rate by 1% holding the other variables constant).

5. Create a 2-variable data table (columns and rows) showing NPV at 10%, 11%, and 12% cost of capital and 20%, 25%, and 30% tax rates.

6. Is this project is worth pursuing? Why or why not?

Reference no: EM131885007

Questions Cloud

Discuss the differences between medicare and medicaid : Discuss the differences between Medicare and Medicaid.

Various third party insurance plans : Discuss the differences and similarities of the various third party insurance plans.

Manage a pediatric patient : How would you evaluate and manage a pediatric patient who has a painful swelling of the hands and feet, fatigue, or fussiness?

Filmmakers to capture viewers : Cinematic language allows filmmakers to capture viewers' attention and transport them into a myriad of imaginative worlds.

Which single variable has the greatest impact on the npv : You are a financial analyst for a major consumer products company. They are considering the product launch of a new cereal with the following expenditures.

Statement for the methods section of a grant : Which of the following versions provides a stronger statement for the methods section of a grant?

Explore the dynamics of employee loyalty : In this week's Discussion, you will explore the dynamics of employee loyalty and what limitations exists in regards to rights and freedoms in the workplace.

Explore the marketing strategy : Critically analyze the value of the approach suggested by the article. Evaluate its content, providing support and counterarguments from the literature.

Actual characteristics of the potential audience : In a second paragraph, explain how you surmised these are actual characteristics of the potential audience. Describe how these characteristics

User Account

All Pages