Excel FunctionsLesson 100Free preview

NPV

This lesson is part of Excel · All levels

Summary

NPV (Net Present Value) is an Excel financial function that calculates the present value of a series of future cash flows at a certain discount rate. The syntax is. A positive NPV generally indicates a profitable project.

Key points

Syntax: NPV(tingkat_diskonto, arus_kas1, ...)
The first argument is the discount rate per period.
The first period cash flows are considered to end at the end of the first period
Initial investments (period 0) are usually processed outside the NPV function

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.