# Finance Functions

<table><thead><tr><th width="136">NAME</th><th>SYNTAX</th><th>DESCRIPTION</th></tr></thead><tbody><tr><td><a href="finance-functions/irr">IRR</a></td><td>IRR (Values, Guess?) - > number</td><td>Returns the internal rate of return for a series of cash flows. Node references are also accepted as arguments</td></tr><tr><td><a href="finance-functions/npv">NPV</a></td><td>NPV (Rate, value1, valueN?) - > number</td><td>Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values)</td></tr><tr><td><a href="finance-functions/pmt">PMT</a></td><td>PMT(Rate, Nper, PV, FV?, Type?) - > number</td><td>Calculates the payment for a loan based on constant payments and a constant interest rate</td></tr><tr><td><a href="finance-functions/ipmt">IPMT</a></td><td>IPMT (Rate, Per, Nper, PV, FV?,Type?) - > number</td><td>Returns the interest payment for a given period for an investment, based on periodic, constant payments and a constant interest rate</td></tr><tr><td><a href="finance-functions/fv">FV</a></td><td>FV(Rate, Nper,Pmt?, PV,Type?) - > number</td><td>Returns the future value of an investment based on periodic, constant payments and a constant interest rate</td></tr><tr><td><a href="finance-functions/pv">PV</a></td><td>PV(Rate,Nper,Pmt?,FV,Type?) - > number</td><td>Returns the present value of an investment</td></tr><tr><td><a href="finance-functions/cumipmt">CUMIPMT</a></td><td>CUMIPMT (Rate, Nper, PV, start_period, end_period, Type) - > number</td><td>Returns the cumulative interest paid between two periods</td></tr><tr><td><a href="finance-functions/cumprinc">CUMPRINC</a></td><td>CUMPRINC (Rate, Nper, PV, start_period, end_period, Type) - > number</td><td>Returns the cumulative principal paid on a loan between two periods</td></tr><tr><td><a href="finance-functions/rate">RATE</a></td><td>RATE(Nper, PMT, PV?,FV?,Type?,Guess?) - > number</td><td>Returns the interest rate per period of a loan or an investment.</td></tr></tbody></table>