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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext