In: Finance
Herjavec Enterprises is thinking about introducing a new surface cleaning machine. The marketing department has come up with the estimate that the company can sell 14 units per year at $299,000 net cash flow per unit for the next five years. The engineering department has come up with the estimate that developing the machine will take a $14.1 million initial investment. The finance department has estimated that a discount rate of 15 percent should be used. a. What is the base-case NPV? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) b. If unsuccessful, after the first year, the project can be dismantled and will have an aftertax salvage value of $10.4 million. Also, after the first year expected cash flows will be revised up to 19 units per year or down to 0 units with equal probability. What is the revised NPV? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.)
Present Value (PV) of Cash Flow: | ||||||||||
(Cash Flow)/((1+i)^N) | ||||||||||
i=Discount Rate=15%=0.15 | ||||||||||
N=Year of Cash Flow | ||||||||||
Net CashFlow per year | $4,186,000 | (14*299000) | ||||||||
N | Year | 0 | 1 | 2 | 3 | 4 | 5 | |||
A | Initial CashFlow | ($14,100,000) | ||||||||
B | Net Annual CashFlow | $4,186,000 | $4,186,000 | $4,186,000 | $4,186,000 | $4,186,000 | ||||
C=A+B | Total Cash Flow | ($14,100,000) | $4,186,000 | $4,186,000 | $4,186,000 | $4,186,000 | $4,186,000 | SUM | ||
PV=C/(1.15^N) | Present Value (PV) of Cash Flow: | ($14,100,000) | $3,640,000.00 | $3,165,217.39 | $2,752,362.95 | $2,393,359.09 | $2,081,181.81 | ($67,878.76) | ||
NPV=Sum of PV | Base Case NPV | ($67,878.76) | ||||||||
CASH FLOW IF UNSUCCESSFUL | ||||||||||
(Probability 50%) | ||||||||||
N | Year | 0 | 1 | |||||||
C | Total Cash Flow | ($14,100,000) | $10,400,000 | SUM | ||||||
PV=C/(1.15^N) | Present Value (PV) of Cash Flow: | ($14,100,000) | $9,043,478.26 | ($5,056,522) | ||||||
Net Present Value(NPV) | ($5,056,522) | |||||||||
CASH FLOW IF SUCCESSFUL | ||||||||||
(Probability 50%) | ||||||||||
Annual Cash flow | $5,681,000 | (19*299000) | ||||||||
N | Year | 0 | 1 | 2 | 3 | 4 | 5 | |||
C | Total Cash Flow | ($14,100,000) | $5,681,000 | $5,681,000 | $5,681,000 | $5,681,000 | $5,681,000 | SUM | ||
PV=C/(1.15^N) | Present Value (PV) of Cash Flow: | ($14,100,000) | $4,940,000.00 | $4,295,652.17 | $3,735,349.72 | $3,248,130.19 | $2,824,461.03 | $4,943,593 | ||
Net Present Value(NPV) | $4,943,593 | |||||||||
Probability | NPV | Probability*NPV | ||||||||
0.5 | ($5,056,522) | ($2,528,260.87) | ||||||||
0.5 | $4,943,593 | $2,471,796.56 | ||||||||
SUM | ($56,464.31) | |||||||||
Expected NPV | ($56,464.31) | |||||||||
Revised NPV | ($56,464.31) | |||||||||