Question

Problem 10-9 Scenarlo Analysls (LO3) The most likely outcomes for a particular project are estimated as follows: Unit price Variable cost: Fixed cost Expected sales: 58 30 $328,eee 31,808 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.5 million, which will be depreciated straight-line over the project life to a final value of zero. The firms tax rate is 35% and the required rate of return is 12%. a. What is project NPV in the best-case scenario, that is, assuming all variables take on the best possible value? (A negetlve emount should be Indlcated by a minus sign. Enter your answer In dollers not In millions. Do not round Intermedlete calculetions. Round your answer to the nearest doller emount.) NPV b. What is project NPV in the worst-case scenario? (A negative amount should be Indicated by e minus sign. Enter your answer In dollars not In millions. Do not round Intermediate calculations. Round your answer to the nearest dollar。mount.) NPV This is a numeric cel, so please enter numbers only

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

In Best case Scenario, Sales Price and units sales will be taken at the highest possible value and costs at the lowest possible values.

NPV of the project is the present value of future cash flows discounted at the required rate of return less the initial investment.

35% 10% Tax Rate Margin of error In Best case Scenario, Sales Price and units sales will be taken at the highest possible value and costs at the lowest possible values. Reverse will be the case for worst case scenario Base Case Best Case Worst Case Unit Price Variable Cost Fixed Cost Expected Sales (Units Per Year S320,000 $288,000 $352,000 12 31,000 34,100 34100 Depreciation each year can be calculated as follows: Initial investment 15 $1,500,000 10 years Salvage value Depreciation per year -(Investment - Salvage Value)/Expected life of equipment $150,000 (D15-D17)/D16 Free cash Flow calculation for Best Case: Free cash flow can be calculated as followed: Year Revenue Variable Cost Fixed Cost Depreciation Operating Income Before Tax (EBIT Tax (@35%) After Tax operating income (EBIT (1-T Add Depreciation Operating Cash Flow Initial investment Free Cash Flow 2 $1,875,500 $1,875,500 $1,875,500 SE$12*$ES9 920,700)($920,700) ($ ($288,000)($288,000) $150,000 $150,000 $816,800$816,800 ($285,880)($285,880) $530,920 ($150,000)(S150,000) $380,920$380,920 ($920,700)SE$12*SE$10 ($288,000)SE$11 $150,000 SD$19 $816,800 SUM(H26:H29) $285,880) -H30*SDS3 $530,920 H30+H31 ($150,000)H29 380,920 H32+H33 $530,920 ($1,500,000 ($1,500,000)$ 35 $380,920 $380,920 $380,920SUM(H34:H35 NPV Calculation for best case scenario NPV of the project is present value of future cash flows discounted at required rate of return less the initial investment. Given the following cash flow and WACC, NPV for the proiect can be calculated as follows: Year Free Cash Flow (FCF MARR (i) Present value if future cash flows 38 2 $1 1,500,000 S380,920 S380,920 $380,920 $485,920*( P/A, 12%, 10 $2,152,282.96E42*PV(D43,H41,-1,0 NPV for Project -Present value fo future cash flows - Initial investment 652282.956 D45+D42 Hence NPV of the project in best case is $652,282.9651 52 53 Free cash Flow calculation for Worst Case: Free cash flow can be calculated as followed: Year Revenue Variable Cost Fixed Cost Depreciation Operating Income Before Tax (EBIT Tax (@35% After Tax operating income (EBIT (1-T Add Depreciation Operating Cash Flow Initial investment Free Cash Flow 0 2 $1,534,500 $1,534,500 ($1,125,300) ($1,125,300) ($352,000)(S352,000) ($150,000)(S150,000) ($92,800)($92,800) $32,480 S32,480 ($60,320)($60,320) $150,000 $150,000 $89,680$89,680 10 $1,534,500 ($1,125,300) ($352,000) ($150,000) 92,800 $32,480 ($60,320) $150,000 $89,680 57 59 61 63 ($1,500,000) $1,500,000)$89,680$89,680 $89,680 NPV Calculation for worst case scenario: NPV of the project is present value of future cash flows discounted at required rate of return less the initial investment. Given the following cash flow and WACC, NPV for the proiect can be calculated as follows: Year Free Cash Flow (FCF MARR (i) Present value if future cash flows 71 72 0 2 10 $1)$S 1,500,000 89,680 89,680 $89,680 74. 75 76 $89,680*( P/A, 12%, 10 $506,712.00 E73*PV(D74,H72,-1,0) ($993,288.00 D76+D73 ($993,288.00) NPV for Project -Present value fo future cash flows - Initial investment 78 Hence NPV of the project in worst case is 81

Add a comment
Know the answer?
Add Answer to:
Problem 10-9 Scenarlo Analysls (LO3) The most likely outcomes for a particular project are estimated as...
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
  • The most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost:...

    The most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost: Fixed cost: Expected sales: $ 60 $ 40 $420,000 47,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $2.1 million, which will be depreciated straight-line...

  • The most likely outcomes for a particular project are estimated as follows: Unit price: $ 60...

    The most likely outcomes for a particular project are estimated as follows: Unit price: $ 60 Variable cost: $ 40 Fixed cost: $ 250,000 Expected sales: 30,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.2 million, which will be depreciated...

  • The most likely outcomes for a particular project are estimated as follows: Unit price: $ 80...

    The most likely outcomes for a particular project are estimated as follows: Unit price: $ 80 Variable cost: $ 60 Fixed cost: $ 380,000 Expected sales: 37,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 5% higher or 5% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.7 million, which will be depreciated...

  • The most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost:...

    The most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost: Fixed cost: Expected sales: $ 80 $ 60 $460,000 40,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 5% higher or 5% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.2 million, which will be depreciated straight-line...

  • The most likely outcomes for a particular project are estimated as follows: points Unit price: Variable...

    The most likely outcomes for a particular project are estimated as follows: points Unit price: Variable cost: Fixed cost: Expected sales: $ 50 $ 30 $420,000 41,000 units per year ebook Print However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.2 million, which will...

  • The most likely outcomes for a particular project are estimated as follows: Unit price: $50 Variable...

    The most likely outcomes for a particular project are estimated as follows: Unit price: $50 Variable cost: $30 Fixed cost: $300,000 Expected sales: 30,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1 million, which will be depreciated straight-line over the...

  • URGENTTT The most likely outcomes for a particular project are estimated as follows: Unit price: Variable...

    URGENTTT The most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost: Fixed cost: Expected sales: 80 68 $280,eee 30,eee units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 5% higher or 5% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.0 million, which will be depreciated straight-line over...

  • The most likely outcomes for a particular project are estimated as follows: Unit price: $50 Variable...

    The most likely outcomes for a particular project are estimated as follows: Unit price: $50 Variable cost: $30 Fixed cost: $300,000 Expected sales: 30,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1 million, which will be depreciated straight-line over the...

  • Variable cost: 20 Fixed cost: 350,000 Unit Price:40 Expected sales: 34,000 units per year However, you...

    Variable cost: 20 Fixed cost: 350,000 Unit Price:40 Expected sales: 34,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.2 million, which will be depreciated straight-line over the project life to a final value of zero. The firm’s tax rate is...

  • 8. value: 7.00 points Problem 9-19 Scenario Analysis [LO 3] We are evaluating a project that...

    8. value: 7.00 points Problem 9-19 Scenario Analysis [LO 3] We are evaluating a project that costs $1,220,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 88,900 units per year. Price per unit is $35.20, variable cost per unit is $21.45, and fixed costs are $769,000 per year. The tax rate is 30 percent, and we require a return of 10 percent...

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