By Jyoti Singh
By Jyoti Singh
Excel Functions Tutorials
There are many financial functions that are too complex to be performed manually or with a use of a calculator. However, if you use Excel for these financial calculations then you will find that they take no time in calculations. This is the reason excel is very popular among financial analysts.
Top Financial Functions discussed here are as follows -
Yield function is an advanced financial function in excel and it is used to calculate amount of income generated each year from the investment amount.
FV function is a financial function in excel in which the FV in excel stands for ‘Future Value’.
IPMT is a financial function in excel that returns the interest amount of a payment received based on an interest rate and a constant payment schedule.
MIRR function is an in-build financial function in Excel to calculate the modified internal rate of return for the cash flows supplied with a period.
NPV function is one of the most important financial function in excel and it calculates the Net Present Value for periodic cash flows, based on a supplied discount rate, and a series of payments.
PPMT function in excel returns the payment on the principal on the monthly loan payment based on an interest rate and a constant payment schedule.
PMT function is advance excel formula and one of the financial functions is used to calculate the monthly payment amount against the simple loan amount.
Price excel function is used to calculate the price of a security/bond, per $100 face value of a security that pays a periodic interest.
PV Function in Excel is a financial function, which is used to calculate PV Function of a future sum of money or fixed cashflows at a constant rate of interest.
RATE function is an advanced build-in function in excel and one of the financial functions is used to calculate the interest rate per payment period for an annuity.
XIRR is another important financial function in excel and it is used to calculate the rate of return.