You are considering a new product launch. The project will cost $574,000, have a five-year life,...

You are considering a new product launch. The project will cost $574,000, have a five-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 160 units per year; price per unit will be $16,000, variable cost per unit will be $12,500, and fixed costs will be $179,000 per year. The required return on the project is 13.5 percent, and the relevant tax rate is 35 percent. Based on your experience, you think the unit sales, variable cost, fixed cost projections given here are probably accurate within plus or minus 3%. What is the worst case NPV? (show your work not in excel)

Solutions

Expert Solution

Initial Investment = $574,000
Useful Life = 5 years

Annual Depreciation = Initial Investment / Useful Life
Annual Depreciation = $574,000 / 5
Annual Depreciation = $114,800

Worst Case:

Sales Volume = 160 * (1 - 0.03)
Sales Volume = 155

Selling Price per unit = $16,000

Variable Cost per unit = $12,500 * (1 + 0.03)
Variable Cost per unit = $12,875

Fixed Costs = $179,000 * (1 + 0.03)
Fixed Costs = $184,370

Annual Operating Cash Flow = [(Selling Price per unit - Variable Cost per unit) * Sales Volume - Fixed Costs)] * (1 - tax) + tax * Depreciation
Annual Operating Cash Flow = [($16,000 - $12,875) * 155 - $184,370] * (1 - 0.35) + 0.35 * $114,800
Annual Operating Cash Flow = $300,005 * 0.65 + 0.35 * $114,800
Annual Operating Cash Flow = $235,183.25

Required return = 13.50%

NPV = -$574,000 + $235,183.25/1.135 + $235,183.25/1.135^2 + $235,183.25/1.135^3 + $235,183.25/1.135^4 + $235,183.25/1.135^5
NPV = -$574,000 + $235,183.25 * (1 - (1/1.135)^5) / 0.135
NPV = -$574,000 + $817,201.27
NPV = $243,201.27

Worst Case NPV is $243,201.27

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You are considering a new product launch. The project will cost $1,282,500, have a five-year life,...

You are considering a new product launch. The project will cost $1,282,500, have a five-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 410 units per year; price per unit will be $20,300, variable cost per unit will be $16,800, and fixed costs will be $339,000 per year. The required return on the project is 15 percent, and the relevant tax rate is 30 percent. Based on your experience, you think the unit...

You are considering a new product launch. The project will cost $1,232,500, have a five-year life,...

You are considering a new product launch. The project will cost $1,232,500, have a five-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 310 units per year; price per unit will be $19,300, variable cost per unit will be $15,800, and fixed costs will be $329,000 per year. The required return on the project is 13 percent, and the relevant tax rate is 35 percent. Based on your experience, you think the unit...

You are considering a new product launch. The project will cost $1,222,500, have a five-year life,...

You are considering a new product launch. The project will cost $1,222,500, have a five-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 290 units per year; price per unit will be $19,100, variable cost per unit will be $15,600, and fixed costs will be $327,000 per year. The required return on the project is 15 percent, and the relevant tax rate is 30 percent. Based on your experience, you think the unit...

You are considering a new product launch. The project will cost $1,202,500, have a five-year life,...

You are considering a new product launch. The project will cost $1,202,500, have a five-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 250 units per year; price per unit will be $18,700, variable cost per unit will be $15,200, and fixed costs will be $323,000 per year. The required return on the project is 15 percent, and the relevant tax rate is 35 percent. Based on your experience, you think the unit...

You are considering a new product launch. The project will cost $1,192,500, have a five-year life,...

You are considering a new product launch. The project will cost $1,192,500, have a five-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 230 units per year; price per unit will be $18,500, variable cost per unit will be $15,000, and fixed costs will be $321,000 per year. The required return on the project is 13 percent, and the relevant tax rate is 30 percent. Based on your experience, you think the unit...

You are considering a new product launch. The project will cost $760,000, have a 4-year life,...

You are considering a new product launch. The project will cost $760,000, have a 4-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 450 units per year; price per unit will be $17,800, variable cost per unit will be $14,500, and fixed costs will be $740,000 per year. The required return on the project is 13 percent, and the relevant tax rate is 24 percent. a. The unit sales, variable cost, and fixed...

You are considering a new product launch. The project will cost $1,750,000, have a four-year life,...

You are considering a new product launch. The project will cost $1,750,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 220 units per year; price per unit will be $20,000, variable cost per unit will be $13,000, and fixed costs will be $500,000 per year. The required return on the project is 15 percent, and the relevant tax rate is 34 percent. a. The unit sales, variable cost, and...

You are considering a new product launch. The project will cost $680,000, have a four-year life,...

You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate...

You are considering a new product launch. The project will cost $1,950,000, have a 4-year life,...

You are considering a new product launch. The project will cost $1,950,000, have a 4-year life, and have no salvage value; depreciation is straight-line to 0. Sales are projected at 180 units per year; price per unit will be $24,000; variable cost per unit will be $15,000; and fixed costs will be $540,000 per year. The required return on the project is 10%, and the relevant tax rate is 34%. a. Based on your experience, you think the unit sales,...

You are considering a new product launch. The project will cost $2,300,000, have a four-year life,...

You are considering a new product launch. The project will cost $2,300,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 160 units per year; price per unit will be $30,000, variable cost per unit will be $18,500, and fixed costs will be $610,000 per year. The required return on the project is 15 percent, and the relevant tax rate is 36 percent. a. The unit sales, variable cost, and fixed...

Subjects