Excel Functions
Loans
| CUMIPMT | Returns the cumulative interest paid on a loan between two dates. | 
| CUMPRINC | Returns the cumulative principal paid on a loan between two dates. | 
| FV | The future value of an investment over a period of time. | 
| NPER | The number of periods for an investment. | 
| PV | The present value of an investment. | 
| RATE | The interest rate per period of an annuity. | 
| CUMIPMT Returns the cumulative interest paid on a loan between two dates. | 
| CUMPRINC Returns the cumulative principal paid on a loan between two dates. | 
| FV The future value of an investment over a period of time. | 
| NPER The number of periods for an investment. | 
| PV The present value of an investment. | 
| RATE The interest rate per period of an annuity. | 
Payments
| PMT | Returns the full amount (principal + interest) paid every period on a loan with fixed interest. | 
| PPMT | Returns the principal amount paid on a given period on a loan with fixed interest. | 
| IPMT | Returns the interest amount paid on a given period on a loan with fixed interest. | 
| PMT Returns the full amount (principal + interest) paid every period on a loan with fixed interest. | 
| PPMT Returns the principal amount paid on a given period on a loan with fixed interest. | 
| IPMT Returns the interest amount paid on a given period on a loan with fixed interest. | 
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext