Question

We are evaluating a project that costs $1,710,000, has a life of 6 years, and has no salvage value. Assume that depreciation
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Base case Best case = base case value*(1+growth rate) Worst case = base value*(1+growth rate)
Units sold 86400 86400*1.1 95040 86400*0.9 77760
selling price 38.01 38.01*1.1 41.811 38.01*0.9 34.209
variable cost 23.25 23.25*1.1 25.575 23.25*0.9 20.925
Total fixed cost 818000 818000*1.1 899800 818000*0.9 736200
Best Case NPV
Year 0 1 2 3 4 5 6
Initial Investment -1710000
sales= units sold*selling price 3973717.44 3973717.44 3973717.44 3973717.44 3973717 3973717
variable cost = units sold*variable cost 2430648 2430648 2430648 2430648 2430648 2430648
fixed cost 899800 899800 899800 899800 899800 899800
annual depreciation 285000 285000 285000 285000 285000 285000
operating profit 358269.44 358269.44 358269.44 358269.44 358269.4 358269.4
less taxes-21% 75236.5824 75236.5824 75236.5824 75236.5824 75236.58 75236.58
after tax profit 283032.8576 283032.8576 283032.8576 283032.8576 283032.9 283032.9
add depreciation 285000 285000 285000 285000 285000 285000
net operating cash flow -1710000 568032.8576 568032.8576 568032.8576 568032.8576 568032.9 568032.9
present value factor at 9% =1/(1+r)^n 1 0.917431193 0.841679993 0.77218348 0.708425211 0.649931 0.596267
present value of cash flow = net operating cash flow*present value factor -1710000 521131.062 478101.8918 438625.5888 402408.797 369182.4 338699.4
Net present value of best case =sum of present value factor*net operating cash flow 838149.16
Worst Case NPV
Year 0 1 2 3 4 5 6
Initial Investment -1710000
sales 2660091.84 2660091.84 2660091.84 2660091.84 2660092 2660092
variable cost 1627128 1627128 1627128 1627128 1627128 1627128
fixed cost 736200 736200 736200 736200 736200 736200
annual depreciation 285000 285000 285000 285000 285000 285000
operating profit 11763.84 11763.84 11763.84 11763.84 11763.84 11763.84
less taxes-21% 2470.4064 2470.4064 2470.4064 2470.4064 2470.406 2470.406
after tax profit 9293.4336 9293.4336 9293.4336 9293.4336 9293.434 9293.434
add depreciation 285000 285000 285000 285000 285000 285000
net operating cash flow -1710000 294293.4336 294293.4336 294293.4336 294293.4336 294293.4 294293.4
present value factor at 9% =1/(1+r)^n 1 0.917431193 0.841679993 0.77218348 0.708425211 0.649931 0.596267
present value of cash flow = net operating cash flow*present value factor -1710000 269993.9758 247700.8952 227248.5277 208484.8878 191270.5 175477.6
Net present value of best case =sum of present value factor*net operating cash flow -389823.62
Add a comment
Know the answer?
Add Answer to:
We are evaluating a project that costs $1,710,000, has a life of 6 years, and has...
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 $1,710,000, has a 6-year life, and has no salvage...

    We are evaluating a project that costs $1,710,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 86,400 units per year. Price per unit is $38.01, variable cost per unit is $23.25, and fixed costs are $818,000 per year. The tax rate is 21 percent, and we require a return of 9 percent on this project. points Skipped eBook a. Calculate the base-case...

  • 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 $832,000, has a life of 8 years, and has...

    We are evaluating a project that costs $832,000, has a life of 8 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 40,000 units per year. Price per unit is $40, variable cost per unit is $17, and fixed costs are $700,000 per year. The tax rate is 23 percent and we require a return of 13 percent on this project. Suppose the projections given for...

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
ADVERTISEMENT