Financials Quick Reference

The following table lists methods that you can use to calculate financial information.

Statement	Purpose	Reference
FV	Returns future value of a cash flow stream.	Calculate Future Value Method
IPmt	Returns interest payment for a given period.	Calculate Interest Method
IRR	Returns internal rate of return for a cash flow stream.	Calculate Internal Rate of Return Method
NPV	Returns net present value of a cash flow stream.	Calculate Net Present Value Method
Pmt	Returns a constant payment for each period for an annuity.	Calculate Payment Method
PPmt	Returns principal payment for a given period.	Calculate Principal Method
PV	Returns present value of a future stream of cash flows.	Calculate Present Value Method
Rate	Returns interest rate for each period.	Calculate Interest Rate Method