Chapter 12: Cash Flow Estimation and Risk Analysis
Integrated Case
349
I. The expected cash flows, considering inflation (in thousands of
dollars), are given in Table IC 12.2. Allied’s WACC is 10%. Assume
that you are confident about the estimates of all the variables that
affect the cash flows except unit sales. If product acceptance is poor,
sales would be only 75,000 units a year, while a strong consumer
response would produce sales of 125,000 units. In either case, cash
costs would still amount to 60% of revenues. You believe that there
is a 25% chance of poor acceptance, a 25% chance of excellent
acceptance, and a 50% chance of average acceptance (the base
case). Provide numbers only if you are using a computer model.
(1) What is the worst-case NPV? The best-case NPV?
Answer: [Show S12-32 and S12-33 here.] We used a spreadsheet model to
develop the scenarios (in thousands of dollars), which are
I. (2) Use the worst-case, most likely case (or base-case), and best-case
NPVs with their probabilities of occurrence, to find the project’s
expected NPV, standard deviation, and coefficient of variation.
Answer: [Show S12-34 here.] The expected NPV is $14,968 (rounded to the
nearest thousand below).