Formula Generator - YIELD function
The YIELD function calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on its settlement date, maturity date, coupon rate, price, redemption value, frequency of interest payments, and day count convention.How to generate an YIELD formula using AI.
To obtain the YIELD formula for Excel, you can ask the AI chatbot the following question: "What is the Excel formula for calculating bond yield?"
YIELD formula syntax.
The YIELD function in Excel calculates the yield of a bond, which represents the annual return on investment. The syntax for the YIELD function is: YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) - settlement: The date on which the bond was purchased. - maturity: The date on which the bond will mature. - rate: The annual coupon rate of the bond. - pr: The price per $100 face value of the bond. - redemption: The redemption value of the bond at maturity. - frequency: The number of coupon payments per year. - [basis]: Optional argument that specifies the day count basis to use. The YIELD function returns the yield of the bond as a percentage.
Calculating Yield for a US Treasury Bond
Calculates the annual yield of a US Treasury Bond based on its settlement date, maturity date, coupon rate, price, redemption value, frequency of interest payments, and day count convention.
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
Estimating Yield for a Corporate Bond
Estimates the annual yield of a corporate bond based on its settlement date, maturity date, coupon rate, price, redemption value, frequency of interest payments, and day count convention.
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
Analyzing Yield for a Municipal Bond
Analyzes the annual yield of a municipal bond based on its settlement date, maturity date, coupon rate, price, redemption value, frequency of interest payments, and day count convention.