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
The YIELD function returns the yield on a security that pays periodic interest. In the example shown, the formula in F6 is:
=YIELD(C9,C10,C7,F5,C6,C12,C13)
with these inputs, the YIELD function returns 0.08 which, or 8.00% when formatted...Read more
The Excel TBILLEQ function returns the bond-equivalent yield for a Treasury bill, based on a settlement date, a maturity date, and a discount rate. In the example shown, the settlement date is 5-Feb-2019, the maturity date is 1-Feb-2020, and the discount rate is 2.54...Read more