In finance, duration is a measure of the price sensitivity to changes in interest rates for an asset that pays interest on a periodic basis, like a bond. Duration can be used by financial managers as part of a strategy to minimize the impact of interest rates changes on net worth.
Excel'...Read more
The PDURATION function calculates how much time is needed for an initial investment (present value) to reach a given amount (future value), assuming a constant annual interest rate. PDURATION returns an amount of time in periods, which is linked to the number of compounding periods per year....Read more
The INTRATE function calculates the annual effective interest rate for a "fully invested" security. A fully invested security does not pay periodic interest before maturity. The interest income is the difference between the redemption value of the security and the original investment.
The Excel DISC function returns the discount rate for a security. A discounted security does not pay periodic interest, but has a specified redemption value at maturity. The return on a discounted security is the difference between the price and redemption value.
Discount rate is based...Read more
In finance, bonds prices are quoted "clean". The "clean price" of a bond excludes any interest accrued since the issue date, or most recent coupon payment. The "dirty price" of a bond is the price including accrued interest. The ACCRINTM function can be used to calculate accrued interest for a...Read more
In finance, bonds prices are quoted "clean". The "clean price" of a bond excludes any interest accrued since the issue date or most recent coupon payment. The "dirty price" of a bond is the price including accrued interest. The ACCRINT function can be used to calculate accrued interest for a...Read more
Some bonds have an irregular first or last period, so interest payments don't fit a normal schedule. To calculate the yield of a bond with an irregular last period, you can use the ODDLYIELD function. The ODDLYIELD function returns the yield of a security with a short or long last period as a...Read more
Some bonds have an irregular first or last period, so interest payments don't fit a normal schedule. To calculate the yield of a bond with an irregular first period, you can use the ODDFYIELD function. The ODDFYIELD Function returns the yield (as a percentage) of a security with a short or long ...Read more
The Excel YIELDDISC function returns the annual yield for a discounted security (non-interest-bearing), such as a Treasury bill, that is issued at a discount but that matures at face value. In the example shown, the formula in F5 is:
=YIELDDISC(C7,C8,C5,C6,...Read moreThe YIELDMAT function returns the annual yield of a security that pays interest at maturity. In the example shown, the formula in F5 is:
=YIELDMAT(C9,C7,C8,C6,C5,C10)
with these inputs, the YIELDMAT function returns 0.081 which, or 8.10%...Read more