Question

We are evaluating a project that costs $1,860,000, has a 6-year life, and has no salvage value. Assume that deprecia...

We are evaluating a project that costs $1,860,000, has a 6-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 89,300 units per year. Price per unit is $38.31, variable cost per unit is $23.50, and fixed costs are $833,000 per year. The tax rate is 21 percent and we require a return of 9 percent on this project.

Suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to within ±10 percent. Calculate the best-case and worst-case NPV figures. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Best case

Time line 0 1 2 3 4 5 6
Cost of new machine -1860000
=Initial Investment outlay -1860000
100.00%
Unit sales 98230 98230 98230 98230 98230 98230
Profits =no. of units sold * (sales price - variable cost) 2061945.93 2061945.93 2061945.93 2061945.9 2061945.9 2061945.9
Fixed cost -749700 -749700 -749700 -749700 -749700 -749700
-Depreciation Cost of equipment/no. of years -310000 -310000 -310000 -310000 -310000 -310000 0 =Salvage Value
=Pretax cash flows 1002245.93 1002245.93 1002245.93 1002245.9 1002245.9 1002245.9
-taxes =(Pretax cash flows)*(1-tax) 791774.2847 791774.2847 791774.2847 791774.28 791774.28 791774.28
+Depreciation 310000 310000 310000 310000 310000 310000
=after tax operating cash flow 1101774.28 1101774.28 1101774.28 1101774.3 1101774.3 1101774.3
+Tax shield on salvage book value =Salvage value * tax rate 0
=Terminal year after tax cash flows 0
Total Cash flow for the period -1860000 1101774.28 1101774.28 1101774.28 1101774.3 1101774.3 1101774.3
Discount factor= (1+discount rate)^corresponding period 1 1.09 1.1881 1.295029 1.4115816 1.538624 1.6771001
Discounted CF= Cashflow/discount factor -1860000 1010802.092 927341.3686 850771.8978 780524.68 716077.69 656952
NPV= Sum of discounted CF= 3082469.72

Worst case

Time line 0 1 2 3 4 5 6
Cost of new machine -1860000
=Initial Investment outlay -1860000
100.00%
Unit sales 80370 80370 80370 80370 80370 80370
Profits =no. of units sold * (sales price - variable cost) 693512.73 693512.73 693512.73 693512.73 693512.73 693512.73
Fixed cost -916300 -916300 -916300 -916300 -916300 -916300
-Depreciation Cost of equipment/no. of years -310000 -310000 -310000 -310000 -310000 -310000 0 =Salvage Value
=Pretax cash flows -532787.27 -532787.27 -532787.27 -532787.3 -532787.3 -532787.3
-taxes =(Pretax cash flows)*(1-tax) -420901.943 -420901.943 -420901.943 -420901.9 -420901.9 -420901.9
+Depreciation 310000 310000 310000 310000 310000 310000
=after tax operating cash flow -110901.94 -110901.94 -110901.94 -110901.9 -110901.9 -110901.9
+Tax shield on salvage book value =Salvage value * tax rate 0
=Terminal year after tax cash flows 0
Total Cash flow for the period -1860000 -110901.94 -110901.94 -110901.94 -110901.9 -110901.9 -110901.9
Discount factor= (1+discount rate)^corresponding period 1 1.09 1.1881 1.295029 1.4115816 1.538624 1.6771001
Discounted CF= Cashflow/discount factor -1860000 -101744.899 -93343.9441 -85636.646 -78565.73 -72078.65 -66127.2
NPV= Sum of discounted CF= -2357497.07
Add a comment
Know the answer?
Add Answer to:
We are evaluating a project that costs $1,860,000, has a 6-year life, and has no salvage value. Assume that deprecia...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • We are evaluating a project that costs $788,400, has a nine-year life, and has no salvage...

    We are evaluating a project that costs $788,400, has a nine-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 75,000 units per year. Price per unit is $52, variable cost per unit is $36, and fixed costs are $750,000 per year. The tax rate is 21 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 $2,070,000, has a 7-year life, and has no salvage...

    We are evaluating a project that costs $2,070,000, has a 7-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 93,400 units per year. Price per unit is $38.73, variable cost per unit is $23.85, and fixed costs are $854,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 price, quantity,...

  • We are evaluating a project that costs $2,010,000, has a 7-year life, and has no salvage...

    We are evaluating a project that costs $2,010,000, has a 7-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 89,400 units per year. Price per unit is $38.61, variable cost per unit is $23.75, and fixed costs are $848,000 per year. The tax rate is 21 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 $2.130,000, has a 8-year life, and has no salvage...

    We are evaluating a project that costs $2.130,000, has a 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 90,600 units per year. Price per unit is $38.85, variable cost per unit is $23.95, and fixed costs are $860,000 per year. The tax rate is 25 percent and we require a return of 11 percent on this project. Suppose the projections given for price, quantity,...

  • We are evaluating a project that costs $2,040,000, has a 7-year life, and has no salvage...

    We are evaluating a project that costs $2,040,000, has a 7-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 89,700 units per year. Price per unit is $38.67, variable cost per unit is $23.80, and fixed costs are $851,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 $744,000, has a six-year life, and has no salvage...

    We are evaluating a project that costs $744,000, has a six-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 45,000 units per year. Price per unit is $60, variable cost per unit is $20, and fixed costs are $740,000 per year. The tax rate is 35 percent, and we require a return of 18 percent on this project. Suppose the projections given for price, quantity,...

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

    We are evaluating a project that costs $1,160,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 39,000 units per year. Price per unit is $41, variable cost per unit is $20, and fixed costs are $645,000 per year. The tax rate is 35 percent, and we require a return of 20 percent on this project. Suppose the projections given for price, quantity,...

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

    We are evaluating a project that costs $1,120,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 64,000 units per year. Price per unit is $50, variable cost per unit is $25, and fixed costs are $620,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 $788,400, has a nine-year life, and has no salvage...

    We are evaluating a project that costs $788,400, has a nine-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 75,000 units per year. Price per unit is $52, variable cost per unit is $36, and fixed costs are $750,000 per year. The tax rate is 21 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 $924,000, has an eight-year life, and has no salvage...

    We are evaluating a project that costs $924,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 75,000 units per year. Price per unit is $46, variable cost per unit is $31, and fixed costs are $825,000 per year. The tax rate is 35 percent, and we require a 15 percent return on this project. Suppose the projections given for price, quantity, variable...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT