Preparing Bond Amortization Schedule in Excel: 2 Methods

Notice that under both methods of amortization, the book value at the time the bonds were issued ($96,149) moves toward the bond’s maturity value of $100,000. The reason is that the bond discount of $3,851 is being reduced to $0 as the bond discount is amortized to interest expense. The difference between the present value of $67,600 and the single future principal payment of $100,000 is $32,400. This $32,400 return on an investment of $67,600 gives the investor an 8% annual return compounded semiannually. The present value of a bond is calculated by discounting the bond’s future cash payments by the current market interest rate. Over the life of the bond, the balance in the account Discount on Bonds Payable must be reduced to $0.

How an Amortized Bond Works

Since the coupon rate is paid semi-annually, it means that every six months, a coupon of $25 ($1,000 x  5/2) will be paid. Also, the yield to maturity is stated in annual terms, so semi-annually the yield to maturity is 1.945% (3.89% / 2). Simplify your bond amortization process with our Effective Interest to Maturity Premium/(Discount) Amortization Template, the most recommended method for accuracy and compliance. This powerful tool allows you to input maturity details, calculate precise amortization schedules, and compare a bond’s Face Value Stated Interest to its Book Value Effective Interest. Streamline your calculations Statement of Comprehensive Income and ensure your financial reporting is always on point.

Bond Amortization Calculator

• When the bond matures at the end of the 10th six-month period, the corporation must make the $100,000 principal payment to its bondholders.
• If the bond is purchased at more than its maturity value, the yield to maturity includes the annual interest minus the loss as the bond decreases from the investment amount to the maturity value.
• Let’s examine the effects of higher market interest rates on an existing bond by first assuming that a corporation issued a 9% $100,000 bond when the market interest rate was also 9%.
• One of the most crucial aspects of running a successful business is understanding your competitive…
• Interest income from some bonds may be taxable at different rates, and tax treatment can vary based on the issuer’s location or the type of bond.

When a bond is sold for less than its face amount, it is said to have been sold at a discount. The discount is the difference between the amount received (excluding accrued interest) and the bond’s face amount. The difference is known by the terms discount on bonds payable, bond discount, or discount. However, for standard bonds, a bond amortization schedule can still be useful for tracking periodic interest payments and the remaining principal balance over time. An amortizing bond is a type of bond that pays both interest and principal to the bondholders over the life of the bond.

Straight-Line Amortization of Bond Discount on Annual Financial Statements

The $4,100 more than the bond’s face amount is referred to as Premium on Bonds Payable, Bond Premium, Unamortized Bond Premium, or Premium. Use the semiannual market interest rate (i) and the number of semiannual periods (n) that were used to calculate the present value of the interest payments. Next, let’s assume that just prior to offering the bond to investors on January 1, the market interest rate for this bond increases to 10%. The corporation decides to sell the 9% bond rather than changing the bond documents to the market interest rate. Since the corporation is selling its 9% bond in a bond market which is demanding 10%, the corporation will receive less than the bond’s face amount.

• As we delve into the second step of our journey, we embark on a crucial aspect calculating the bond’s face value and coupon payments.
• These schedules offer a clear picture of how the bond will amortize over time, making it easier for both investors and issuers to plan and manage their finances.
• If a corporation that is planning to issue a bond dated January 1, 2024 delays issuing the bond until February 1, the corporation will not have interest expense during January.
• With bondholders buying and selling their bond investments on any given day, there needs to be a mechanism to compensate each bondholder for the interest earned during the days a bond was held.
• In our example, there will be a $100,000 principal payment on the bond’s maturity date at the end of the 10th semiannual period.

Present Value of a Bond’s Maturity Amount

• If a bond pays interest quarterly or annually, the schedule follows that same frequency.
• It empowers investors to make informed decisions and assists issuers in managing their financial commitments.
• Mastering the amortization schedule for bond analysis is a crucial skill for investors.
• Other factors such as credit rating, issuer’s financial health, and market conditions should also be considered before making investment decisions.
• From various perspectives, it is evident that amortizing bonds offer several advantages.
• The discount is the difference between the amount received (excluding accrued interest) and the bond’s face amount.

This calculation is then continued through the maturity date of the bonds. For callable premium bonds, the Yield to Maturity differs from the Stated Yield in offering documents. The Effective Interest Rate method compares a bond’s Face Value Stated Interest to the normal balance bond’s Book Value Effective Interest. DebtBook’s Premium/Discount Amortization feature allows clients to easily track their amortization of original issuance premium/discount (“OIP” or “OID”) within their DebtBook profile.