How to use the Financial Functions DURATION, MDURATION
The Macaulay duration (named after Frederick Macaulay) and its modified version, is a measure of a bond’s sensitivity to interest rate changes.
2607, 2019
Tag Archives: Financial
2305, 2019
How to use the Financial Functions PRICE, PRICEDISC, PRICEMAT
In order to be able to calculate the price per $100 face value we pay for an investment, Excel provides us with 3 tools.
The functions PRICE, PRICEMAT, PRICEDISC.
2305, 2019
How to use the Financial Functions YIELD, YIELDDISC, YIELDMAT
Excel provides us with numerous functions to calculate and manage securities.
Let’s start with the functions that calculate the Yield of a security. These are YIELD, YIELDMAT and YIELDDISC
2305, 2019
How to use the Financial Functions ACCRINT, ACCRINTM
Excel provides us with 2 functions for calculating accrued interest. ACCRINT, ACCRINTM.
But what exactly is accrued interest?
2204, 2019
The YIELDMAT Function
It calculates the annual yield for a discounted security.
2204, 2019
The YIELDDISC Function
It calculates the annual yield for a discounted security.
2204, 2019
The YIELD Function
It calculates the yield on a security that pays periodic interest.
2204, 2019
The PRICEDISC Function
It calculates the price per $100 face value of a discounted security.
2204, 2019
The PRICEMAT Function
It calculates the price per $100 face value of a security that pays interest at maturity.
2204, 2019
The PRICE Function
It calculates the price per $100 face value of a security that pays periodic interest.
