The most important functions are PV and FV.
PV function – Returns the present value of an investment
FV function – Returns the future value of an investment
Other useful functions are as follows:
CUMIPMT function – Returns the cumulative interest paid between two periods
CUMPRINC – Returns the cumulative principal paid on a loan between two periods
EFFECT function – Returns the effective annual interest rate
IRR function – Returns the internal rate of return for a series of cash flows
NPER function – Returns the number of periods for an investment
NPV function – Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
PMT function – Returns the periodic payment for an annuity
XIRR function – Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
Leave a Reply