The IRR function is categorized under Excel Financial functions. IRR will return the Internal Rate of Return for a given …
The Excel MDURATION function returns the Macauley modified duration for a security with an assumed par value of $100 Syntax:= …
The Excel ISPMT function calculates the interest paid during a given period of an investment where principal payments are equal. …
The INTRATE Function is categorized under Excel Financial functions. It will calculate the interest rate for a fully invested security. …
The Excel EFFECT function returns the effective annual interest rate, given a nominal interest rate and the number of compounding …
FV function in excel is an inbuilt financial function in excel which can be also termed as future value function, …
The DURATION function is categorized under Excel Financial functions. It helps to calculate the Macauley Duration. The function calculates the …
The Excel DOLLARFR function converts a dollar price in a regular decimal number format to a dollar price in a …
DOLLARDE (an Analysis ToolPak function) allows you to convert a fractional dollar amount to a decimal amount. You can use …
The DISC Function is an Excel Financial function. It will calculate the rate of discount for a bond. It helps …