## How to use MIRR Function in Excel

MIRR in excel is an in-build financial function used to calculate the modified internal rate of return for the cash flows supplied with a period. This …

## How to use NOMINAL Function in Excel

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 …

## 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 …