Net Present Value is primarily applied financial measure in investment analysis, capital budgeting, and corporate finance to measure the opportunity of project investment and make rational decisions about whether to accept the underlying project or not. NPV is also recognized as TVM (time value of money) calculated by discounting the future cashflows to PV (present value) at a specific discount rate.
Net Present Value NPV and IRR Calculator Excel
Instructions: In order to use this NPV Calculator Excel & IRR of a project, please input the discount rate in terms of %, initial project cash outlay in “Year 0” and the cash inflows for a period of time in the form below to get the answer:
Must Read: A full guide on how to calculate NPV and IRR in Excel