We are evaluating a project that costs $110934, has a seven-year life, and has no salvage...

We are evaluating a project that costs $110934, has a seven-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 4139 units per year. Price per unit is $51, variable cost per unit is $21, and fixed costs are $81850 per year. The tax rate is 36 percent, and we require a 9 percent return on this project. Suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to within +/-12 percent. What is the NPV of the project in worst-case scenario?

Expert Solution

	0	1	2	3	4	5	6	7
Investment	-$110,934.00
Sales		$163,467.32	$163,467.32	$163,467.32	$163,467.32	$163,467.32	$163,467.32	$163,467.32
VC		-$85,667.37	-$85,667.37	-$85,667.37	-$85,667.37	-$85,667.37	-$85,667.37	-$85,667.37
FC		-$91,672.00	-$91,672.00	-$91,672.00	-$91,672.00	-$91,672.00	-$91,672.00	-$91,672.00
Depreciation		-$15,847.71	-$15,847.71	-$15,847.71	-$15,847.71	-$15,847.71	-$15,847.71	-$15,847.71
EBT		-$29,719.76	-$29,719.76	-$29,719.76	-$29,719.76	-$29,719.76	-$29,719.76	-$29,719.76
Tax (36%)		$10,699.11	$10,699.11	$10,699.11	$10,699.11	$10,699.11	$10,699.11	$10,699.11
Profits		-$19,020.65	-$19,020.65	-$19,020.65	-$19,020.65	-$19,020.65	-$19,020.65	-$19,020.65
Cash Flows	-$110,934.00	-$3,172.93	-$3,172.93	-$3,172.93	-$3,172.93	-$3,172.93	-$3,172.93	-$3,172.93
NPV	-$126,903.21

In worst-case scenario, sales are lower and costs are higher

Quantity = 4139 x (1 - 12%) = 3,642.32

Price = 51 x (1 - 12%) = 44.88

VC = 21 x (1 + 12%) = 23.52

Fixed Cost (FC) = 81,850 x (1 + 12%) = 91,672

Depreciation = Investment / 7

Cash Flows = Investment + Profits + Depreciation

jeff jeffy answered 7 months ago

We are evaluating a project that costs $118,894, has a seven-year life, and has no salvage...

We are evaluating a project that costs $118,894, has a seven-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 4,101 units per year. Price per unit is $47, variable cost per unit is $30, and fixed costs are $82,846 per year. The tax rate is 36 percent, and we require a 12 percent return on this project. Suppose the projections given for price, quantity, variable...

We are evaluating a project that costs $104,299, has a seven-year life, and has no salvage...

We are evaluating a project that costs $104,299, has a seven-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 4,235 units per year. Price per unit is $50, variable cost per unit is $30, and fixed costs are $81,714 per year. The tax rate is 36 percent, and we require a 9 percent return on this project. Suppose the projections given for price, quantity, variable...

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

We are evaluating a project that costs $827,000, has an seven-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 103,000 units per year. Price per unit is $35, variable cost per unit is $22, and fixed costs are $831,135 per year. The tax rate is 38 percent, and we require a 16 percent return on this project. The projections given for price, quantity, variable costs,...

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

We are evaluating a project that costs $1,582,000, has a seven-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 87,100 units per year. Price per unit is $34.30, variable cost per unit is $20.55, and fixed costs are $751,000 per year. The tax rate is 30 percent, and we require a return of 12 percent on this project. Calculate the base-case operating cash flow and...

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

We are evaluating a project that costs $1,638,000, has a seven-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 87,900 units per year. Price per unit is $34.70, variable cost per unit is $20.95, and fixed costs are $759,000 per year. The tax rate is 35 percent, and we require a return of 12 percent on this project. Suppose the projections given for price,...

We are evaluating a project that costs $116335, has a seven-year life, and has no salvage...

We are evaluating a project that costs $116335, has a seven-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 4367 units per year. Price per unit is $55, variable cost per unit is $24, and fixed costs are $80248 per year. The tax rate is 36 percent, and we require a 9 percent return on this project. Suppose the projections given for price, quantity, variable...

We are evaluating a project that costs $100356, has a seven-year life, and has no salvage...

We are evaluating a project that costs $100356, has a seven-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 4229 units per year. Price per unit is $51, variable cost per unit is $30, and fixed costs are $81802 per year. The tax rate is 33 percent, and we require a 11 percent return on this project. Suppose the projections given for price, quantity, variable...

We are evaluating a project that costs $115571, has a seven-year life, and has no salvage...

We are evaluating a project that costs $115571, has a seven-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 4293 units per year. Price per unit is $45, variable cost per unit is $25, and fixed costs are $81427 per year. The tax rate is 35 percent, and we require a 8 percent return on this project. Suppose the projections given for price, quantity, variable...

We are evaluating a project that costs $619,500, has a seven-year life, and has no salvage...

We are evaluating a project that costs $619,500, has a seven-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 90,000 units per year. Price per unit is $43, variable cost per unit is $30, and fixed costs are $705,000 per year. The tax rate is 22 percent, and we require a return of 11 percent on this project. a-1. Calculate the accounting break-even point....

We are evaluating a project that costs $105790, has a seven-year life, and has no salvage...

We are evaluating a project that costs $105790, has a seven-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 4108 units per year. Price per unit is $54, variable cost per unit is $24, and fixed costs are $83887 per year. The tax rate is 31 percent, and we require a 9 percent return on this project. Suppose the projections given for price, quantity, variable...

Question