How to use NOMINAL Function in Excel
by The Excel NOMINAL function returns the nominal interest rate, given an effective annual interest rate and the number of compounding periods per year. The effective …
Author: Excel
How to use IRR Function in Excel
The IRR function is categorized under Excel Financial functions. IRR will return the Internal Rate of Return for a given cash flow, that is, the …
How to use MDURATION Function in Excel
The Excel MDURATION function returns the Macauley modified duration for a security with an assumed par value of $100 Syntax:= MDURATION (settlement, maturity, coupon, yld, …
How to use ISPMT Function in Excel
The Excel ISPMT function calculates the interest paid during a given period of an investment where principal payments are equal. The given period is specified …
How to use INTRATE Function in Excel
The INTRATE Function is categorized under Excel Financial functions. It will calculate the interest rate for a fully invested security. The function was introduced in …
How to use EFFECT Function in Excel
The Excel EFFECT function returns the effective annual interest rate, given a nominal interest rate and the number of compounding periods per year. Effective annual interest …
How to use FV Function in Excel
FV function in excel is an inbuilt financial function in excel which can be also termed as future value function, this function is very useful …
How to use DURATION Function in Excel
The DURATION function is categorized under Excel Financial functions. It helps to calculate the Macauley Duration. The function calculates the duration of a security that …
How to use DOLLARFR Function in Excel
The Excel DOLLARFR function converts a dollar price in a regular decimal number format to a dollar price in a particular fractional notation used for …
How to use DOLLARDE Function in Excel
DOLLARDE (an Analysis ToolPak function) allows you to convert a fractional dollar amount to a decimal amount. You can use this function to convert the …