Question

In: Finance

We are evaluating a project that costs $912,000, has an thirteen-year life, and has no salvage...

We are evaluating a project that costs $912,000, has an thirteen-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 147,000 units per year. Price per unit is $36, variable cost per unit is $29, and fixed costs are $921,120 per year. The tax rate is 33 percent, and we require a 18 percent return on this project. The projections given for price, quantity, variable costs, and fixed costs are all accurate to within +/- 14 percent. (a) Calculate the best-case NPV. (b) Calculate the worst-case NPV.

Please use Excel and show formulas. Thanks.

Expert Solution

(a) the best-case NPV is $146,405.20.

In best-case NPV, projections given for price, quantity, variable costs, and fixed costs will be increased by 14%.

best-case price = base case price*(1+rate of increase) = $36*(1+0.14) = $36*1.14 = $41.04

best-case quantity = 147,000*1.14 = 167,580

best-case variable costs = $29*1.14 = $33.06

best-case Fixed costs = $921,120*1.14 = $1,050,076.8

Formulas

(b) the worst-case NPV is -$900,689.20.

In worst-case NPV, projections given for price, quantity, variable costs, and fixed costs will be decreased by 14%.

worst-case price = base case price*(1-rate of decrease) = $36*(1-0.14) = $36*0.86 = $30.96

best-case quantity = 147,000*086 = 126,420

best-case variable costs = $29*0.86 = $24.94

best-case Fixed costs = $921,120*0.86 = $792,163

Formulas

jeff jeffy answered 4 months ago

We are evaluating a project that costs $1,920,000, has a 6 year life, and no salvage...

We are evaluating a project that costs $1,920,000, has a 6 year life, and no salvage value. Assume that depreciation is staright-line to zero over the life of the project. Sales are projected at 94,000 units per year. Price per unit is $38.43, variable cost per unit is $23.60 and fixed costs are $839,000 per year. The tax rate is 23 percent and we require a return of 12 percent on this project. Suppose the projections given for the price,...

We are evaluating a project that costs $972,000, has a 4 year life, and no salvage...

We are evaluating a project that costs $972,000, has a 4 year life, and no salvage value. Assume that depreciation is staright-line to zero over the life of the project. Sales are projected at 88,000 units per year. Price per unit is $35.15, variable cost per unit is $21.40 and fixed costs are $768,000 per year. The tax rate is 35 percent and we require a return of 13 percent on this project. A) Calculate the best case operating cash...

we are evaluating a project that costs $690,000, has a five year life, and no salvage...

we are evaluating a project that costs $690,000, has a five year life, and no salvage value. Assume that straightline to zero over the life of the project. sales are projected at 71,000 units per year. price per unit is $75, variable cost per unit is $38 and fixed costs are $790,000 per year. The tax rate is 35%, and we require a return of 15% on this project Calculate the best case and wore case npv figures

We are evaluating a project that costs $739,600, has aneight-year life, and has no salvage...

We are evaluating a project that costs $739,600, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 80,000 units per year. Price per unit is $49, variable cost per unit is $34, and fixed costs are $735,000 per year. The tax rate is 23 percent, and we require a return of 9 percent on this project. Suppose the projections given for price, quantity,...

We are evaluating a project that costs $604,000, has an 8-year life, and has no salvage...

We are evaluating a project that costs $604,000, has an 8-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 55,000 units per year. Price per unit is $36, variable cost per unit is $17, and fixed costs are $685,000 per year. The tax rate is 21 percent and we require a return of 15 percent on this project. Suppose the projections given for price, quantity,...

We are evaluating a project that costs $748,000, has a twelve-year life, and has no salvage...

We are evaluating a project that costs $748,000, has a twelve-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 113,000 units per year. Price per unit is $36, variable cost per unit is $23, and fixed costs are $760,716 per year. The tax rate is 37 percent, and we require a 12 percent return on this project. Requirement 1: Calculate the accounting break-even point.(Round your...

We are evaluating a project that costs $500,000, has an eight-year life, and has no salvage...

We are evaluating a project that costs $500,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 50,000 units per year. Price per unit is $40, variable cost per unit is $25, and fixed costs are $600,000 per year. The tax rate is 22 percent, and we require a return of 12 percent on this project. Suppose the projections given for price, quantity,...

We are evaluating a project that costs $1,080,000, has a ten-year life, and has no salvage...

We are evaluating a project that costs $1,080,000, has a ten-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 52,000 units per year. Price per unit is $48, variable cost per unit is $27, and fixed costs are $756,000 per year. The tax rate is 25 percent, and we require a return of 15 percent on this project. a. Calculate the accounting break-even point. (Do...

We are evaluating a project that costs $660,000, has a five-year life, and has no salvage...

We are evaluating a project that costs $660,000, has a five-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 69,000 units per year. Price per unit is $58, variable cost per unit is $40, and fixed costs are $660,000 per year. The tax rate is 22 percent, and we require a return of 12 percent on this project. Suppose the projections given for price, quantity,...

We are evaluating a project that costs $841,992, has an eight-year life, and has no salvage...

We are evaluating a project that costs $841,992, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 60,261 units per year. Price per unit is $44, variable cost per unit is $19, and fixed costs are $420,392 per year. The tax rate is 35%, and we require a return of 20% on this project. Calculate the Accounting Break-Even Point. (Round answer to 0...