NPV

Free Tutorial and Video

Gain insight into the concept of Net Present Value (NPV), its calculation, and its significant role in capital budgeting and investment planning.

Net present value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time. NPV is used in capital budgeting and investment planning to analyze the profitability of a projected investment or project. NPV is the result of calculations used to find today’s value of a future stream of payments.

To calculate NPV, you need to estimate future cash flows for each period and determine the correct discount rate.

NPV accounts for the time value of money and can be used to compare similar investment alternatives.1 The NPV relies on a discount rate that may be derived from the cost of the capital required to invest, and any project or investment with a negative NPV should be avoided.

D48 = NPV($E$37, D40:D45)

Financial Modeling Bootcamp: Live & Hands-on, In NYC or Online, Learn From Experts, Free Retake, Small Class Sizes,  1-on-1 Bonus Training. Named a Top Bootcamp by Forbes, Fortune, & Time Out. Noble Desktop. Learn More.

The second investment has a negative NPV and wouldn’t be a good one even without comparison with the first option.

How to Learn Financial Modeling

Master financial modeling with hands-on training. Financial modeling is a technique for predicting the financial performance of a business or other type of institution over time using real-world data.

Yelp Facebook LinkedIn YouTube Twitter Instagram