Excel Functions


Loans

CUMIPMTReturns the cumulative interest paid on a loan between two dates.
CUMPRINCReturns the cumulative principal paid on a loan between two dates.
FVThe future value of an investment over a period of time.
NPERThe number of periods for an investment.
PVThe present value of an investment.
RATEThe 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

PMTReturns the full amount (principal + interest) paid every period on a loan with fixed interest.
PPMTReturns the principal amount paid on a given period on a loan with fixed interest.
IPMTReturns 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