Question

In: Finance

We are evaluating a project that costs $670,000, has a life of 5 years, and has...

We are evaluating a project that costs $670,000, has a life of 5 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 59,000 units per year. Price per unit is $44, variable cost per unit is $24, and fixed costs are $760,000 per year. The tax rate is 23 percent and we require a return of 16 percent on this project.

What is the sensitivity of NPV to changes in the sales figure? (Change)NPV/(change)Quantity

What is the sensitivity of OCF to changes in the variable cost figure? (change)OCF/(Change)VC

Solutions

Expert Solution

Year Sales(unit) Revenue (Sales*Price/unit) Variable Cost (Unit*VC) Fixed Cost Depreciation (Initial Cost/5) PBT (Revenue-VC-Fixed Cost) Tax( (PBT-Depreciation)*tax rate) PAT (PBT-TAX) Discounted Present Value (PAT/1.16^year)
0 0 -670000 0 0 0 -670000 0 -670000 -670000
1 59000 2596000 1416000 760000 134000 420000 65780 354220 322018.2
2 59000 2596000 1416000 760000 134000 420000 65780 354220 292743.8
3 59000 2596000 1416000 760000 134000 420000 65780 354220 266130.7
4 59000 2596000 1416000 760000 134000 420000 65780 354220 241937
5 59000 2596000 1416000 760000 134000 420000 65780 354220 219942.8
NPV (Sum of all Present Value) 672772.5

For sales of 59000 unit NPV is 672772.5 and using the same model if sale is 50000 then NPV becomes 147369.4. So, sensitivity= change of NPV/change of quantity=(672772.5-147369.4)/(59000-50000)=$58.37

Similarly, in the above scenario OCF(PAT+Depreciation) =488220 when VC=24 and OCF=442790 when VC=25

So, sensitivity= (442790-488220)/(25-24)=$-45430


Related Solutions

We are evaluating a project that costs $670,000, has a five-year life, and has no salvage...
We are evaluating a project that costs $670,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 59,000 units per year. Price per unit is $44, variable cost per unit is $24, and fixed costs are $760,000 per year. The tax rate is 35 percent, and we require a return of 18 percent on this project A. Calculate the accounting break-even point (Units)...
We are evaluating a project that costs $650,000, has a life of 5 years, and has...
We are evaluating a project that costs $650,000, has a life of 5 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 45,000 units per year. Price per unit is $56, variable cost per unit is $26, and fixed costs are $860,000 per year. The tax rate is 21 percent and we require a return of 14 percent on this project. a. Calculate the accounting break-even...
We are evaluating a project that costs $690,000, has a life of 5 years, and has...
We are evaluating a project that costs $690,000, has a life of 5 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 51,000 units per year. Price per unit is $75, variable cost per unit is $50, and fixed costs are $790,000 per year. The tax rate is 25 percent and we require a return of 13 percent on this project. a. Calculate the accounting break-even...
We are evaluating a project that costs $660,000, has a life of 5 years, and has...
We are evaluating a project that costs $660,000, has a life of 5 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 58,000 units per year. Price per unit is $57, variable cost per unit is $38, and fixed costs are $660,000 per year. The tax rate is 22 percent and we require a return of 16 percent on this project. Suppose the projections given for...
We are evaluating a project that costs $680,000, has a life of 5 years, and has...
We are evaluating a project that costs $680,000, has a life of 5 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 64,000 units per year. Price per unit is $43, variable cost per unit is $26, and fixed costs are $685,000 per year. The tax rate is 24 percent and we require a return of 14 percent on this project. Suppose the projections given for...
We are evaluating a project that costs $972,000, has a life of twelve years, and has...
We are evaluating a project that costs $972,000, has a life of twelve years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 117,000 units per year. Price per unit is $35, variable cost per unit is $25, and fixed costs are $989,496 per year. The tax rate is 22 percent, and we require a return of 21 percent on this project. The projections given for price,...
We are evaluating a project that costs $743,000, has a life of eight years, and has...
We are evaluating a project that costs $743,000, has a life of eight years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 124,000 units per year. Price per unit is $37, variable cost per unit is $20, and fixed costs are $749,687 per year. The tax rate is 22 percent, and we require a return of 21 percent on this project. The projections given for price,...
We are evaluating a project that costs $1,100,000, has a life of 10 years, and has...
We are evaluating a project that costs $1,100,000, has a life of 10 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 47,000 units per year. Price per unit is $50, variable cost per unit is $25, and fixed costs are $820,000 per year. The tax rate is 21 percent and we require a return of 16 percent on this project. Suppose the projections given for...
We are evaluating a project that costs $1,080,000, has a life of 10 years, and has...
We are evaluating a project that costs $1,080,000, has a life of 10 years, 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 $50, variable cost per unit is $30, and fixed costs are $730,000 per year. The tax rate is 25 percent and we require a return of 15 percent on this project. Suppose the projections given for...
We are evaluating a project that costs $709,000, has a life of fifteen years, and has...
We are evaluating a project that costs $709,000, has a life of fifteen years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 96,000 units per year. Price per unit is $43, variable cost per unit is $21, and fixed costs are $723,889 per year. The tax rate is 23 percent, and we require a return of 16 percent on this project. The projections given for price,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT