When using the NPV function, errors that commonly occur include: referencing the wrong cells, constant jamming, inadequate documentation, inconsistent assumptions about cash flows being real/nominal and before/after tax, misinterpretation of an ambiguous model specification, and incorrect cash flow timing.

When should you reject NPV?

If the NPV of an investment is greater than zero, accept! If the NPV of an investment is less than zero, reject!

What is the Net Present Value ( NPV ) rule?

What is the Net Present Value Rule? The net present value rule is the idea that company managers and investors should only invest in projects or engage in transactions that have a positive net present value (NPV). They should avoid investing in projects that have a negative net present value. It is a logical outgrowth of net present value theory.

What can cause a company to ignore a positive NPV?

For example, a company with significant debt issues may abandon or postpone undertaking a project with a positive NPV. The company may take the opposite direction as it redirects capital to resolve an immediately pressing debt issue. Poor corporate governance can also cause a company to ignore or miscalculate NPV.

What are the disadvantages of using NPV calculations?

Because NPV calculations require the selection of a discount rate, they can be unreliable if the wrong rate is selected. Making matters even more complex is the possibility that the investment will not have the same level of risk throughout its entire time horizon.

What’s the difference between the IRR and the NPV?

Unlike the IRR, a company’s NPV, or net present value, is expressed in a dollar figure. It is the difference between a company’s present value of cash inflows and its present value of cash outflows over a specific period of time. NPV estimates a company’s future cash flows of the project.