BONDS Bond Analytics

This calculator allows for calculation of price, yield, duration, and other statistics for various types of bonds, including US Treasuries, Munis, Corporates, and Japanese Governments.

The Bonds function in FinTools XL is designed to price bond instruments and calculate various bond-related metrics such as yield to maturity, duration, and convexity.

Bond Price (Price): The current market price of the bond. This is essential for calculations related to yield to maturity and other return metrics.

Par Value (Par): The face value of the bond, which is the amount that will be paid back to the bondholder at maturity.

Coupon Rate (CouponRate): The annual coupon rate of the bond, expressed as a percentage. This rate is applied to the par value to determine the annual coupon payments.

Yield to Maturity (YTM): The annual return expected on the bond if it is held until maturity. This is calculated based on the current price, coupon payments, and time to maturity.

Maturity Date (Maturity): The date on which the bond will mature and the principal, or par value, will be paid to the bondholder.

Issue Date (Issue): The date the bond was issued.

Frequency (Freq): The number of coupon payments per year. Common values are 1 for annual payments, 2 for semi-annual, and 4 for quarterly.

Basis (Basis): The day count convention used to calculate the accrued interest and other date-related calculations. Common bases include:

1. Actual/Actual: The actual number of days in the month and year are used.
2. 30/360: Each month is treated as having 30 days with a year of 360 days.
3. Actual/360: The actual number of days in the month are used, with a year assumed to have 360 days.
4. Actual/365: The actual number of days in the month are used, with a year assumed to have 365 days.

Call/Put Options (Callable, Putable): Indicators whether the bond is callable or putable. Callable bonds can be redeemed by the issuer before they mature, and putable bonds can be sold back to the issuer before maturity at a specified price.

Call/Put Prices (CallPrice, PutPrice): The prices at which the bond can be called or put.

Call/Put Dates (CallDate, PutDate): The dates on which the bond can first be called or put.

These inputs allow the Bonds function to provide a comprehensive analysis of the bond's value and performance characteristics under various conditions, making it a valuable tool for bond investors and portfolio managers to assess and manage fixed-income securities.