Respuesta :
Answer:
Because the NPV of project A is higher, this project is preferable than project B.
Explanation:
The net present value (NPV) is the sum of all cash flows in present value discounted at a rate (known as discount rate, cost of capital or WACC)
A company will never choose a project with a NPV that is negative because the company will not only recover the investment it will destroy value. A project with an NPV of 0 will recover the initial investment but will not generate other revenue, it will not create or destroy value. And a project with positive NPV is attractive for investors and the higher the NPV the best is the project.
To calculate the NPV you use the formula attached, but you can do it faster in excel:
First, you copy all cash flows including the investment with a negative sign.
For example, for project A:
year 0: -$15,000,000
year 1: $12,000,000
year 2: $11,000,000
Then we use the financial formula "NPV" in this way:
"=NPV(6%;C5:C6)+C4"= $1283,23
C5 is: $12,000,000
C6 is: $11,000,000
C4 is: -$15,000,000
And because the investment is to be paid this year and this value is already in present value, we sum it.
We do the same procedure to obtain the NPV for project B.
According to the results attached (excel table) project A has an NPV of $6,110,716 and project B has an NPV of $3,553,934. Because the NPV of project A is higher, this project is preferable than project B.

