Excel Financial Functions

Payment Functions

ISPMT functionCalculates the amount of interest paid on a loan/ investment for a specific period.
PMT functionCalculate the periodic payment for a loan.
PPMT functionCalculates the principal value of an investment for a given period.
CUMIPMT functionCalculates the cumulative interest paid between the start date and the end date.

Interest Rate Functions

INTRATE functionCalculates the interest rate for a fully invested security.
ACCRINTM functionReturns the accrued interest of a security (usually a bond) that pays interest at maturity.

Investment Functions

RECEIVED functionCalculates the amount of return at maturity of fully invested security.
FVSCHEDULE functionReturns the future value of an investment (an initial principal) after applying series of compound interest rates.
FV functionCalculates the future value of an investment.
PV functionReturns the present value/ current worth of the future cash flows that will receive at a future date.
NPV functionCalculates the net present value of an investment by using a discount rate and a series of future payments.
Copyright © 2016 - 2018 Explainry.com | All Rights Reserved