Formulas in Excel to Calculate Net Present Value

by Unknown
Microsoft Excel has five functions to calculate net present value: NPV, XNPV, IRR, XIRR, and MIRR. Which you choose depends on the financial method you prefer, whether or not cash flows occur at regular intervals, and whether or not the cash flows are periodic.
Source: http://www.npv-irr-guide.info/
Tags: net present value, calculation, formulas
Vote for this tip: up down