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