Widgets Inc. is a vendor who supplies machine parts to an appliance manufacturing company. In return, Widgets Inc. relies on the
1 answer:
You might be interested in
Answer:
With mitigation: NPV =$36,670,000, IRR= 15,24%
Without mitigation: NPV= $ 42,000,000, IRR= 19,86%
Explanation:
To calculate the Net Present Value (NPV) we have to sum the present value of a project´s cash flows (positive and negative cashflows). To do so, we need: the number of periods of the project, the discount rate, cost of captal or WACC, and the future values of the cash flows. Then we apply the formula attached.
To calculate the Internal Rate of Return (IRR) we have to find the discount rate, cost of capital or WACC that makes the NPV equal to cero. That means we have to find a rate in which the investor do not create or destroy value, only recovers the investment. I attached the formula.
But, this is better if we use excel:
First we copy the cash flows of the two projects. To find the NPV we use the financial formula "NPV" in this way:
"=NPV(rate;cash flows from year 1 to year 5)+ cash flow of year 0"
To find the IRR we use the financial formula "IRR" in this way:
"=IRR(cash flows from year 0 to year 5)"
I attached the excel figure.
