Bond discount amortization schedule excel

To calculate cash interest, we multiply the 243 win vs 243 ai face value of the bonds (100,000) by the coupon rate (9) to get 9,000.
The bonds are sold at a premium, or gifted but twisted ice cream man lyrics 110,000 in total.
Such a bond is said to trade at a premium, and the tax laws allow you to amortize the bond's premium between the time you purchase it and its maturity date in order to offset your income.
How to use the straight-line method.This is best explained by example.For older bonds issued before Sept.As simple as the straight-line method is, the main problem with it is that the IRS generally doesn't allow you to use it anymore.The constant-yield method will give you a smaller amortization amount than the straight-line method in early years, with the constant-yield amortization figure growing in later years.When a bond has an interest rate that's higher than prevailing rates in the bond market, it will typically trade at a price higher than its face value.Interest expense is 7,000 each year (cash interest of 8,000 minus 1,000 of premium amortization).Under the straight line method, the premium or discount on the bond is amortized in equal amounts over the life of the bond.Number of periods: 10, payment: 9,000, rate: 8, solve for present value to get 106,710.08, or the amount investors will pay for these bonds assuming they want an annual send rakhi gifts to kolkata return of 8, also known as a yield to maturity.Codes, the accounting profession prefers the effective interest rate method, but allows the straight-line method when the amount of bond discount is not significant.
This figure is the interest expense for year one.
Investors only demand an 8 return for owning the bond, and thus pay the company 106,710.08 for the bonds.

To calculate total interest expense for the first year, we take the carrying amount of the bond and multiply it by investors' required return.Straight line amortization of premiums or discounts results in the same amount of interest expense, amortization, and cash interest in every single year until the bond is repaid.However, the difference between how much it has to ultimately repay in principal (100,000) and the amount it received from selling the bonds (95,000) represents an additional cost of financing.Amortizing Bond Discount Using the Effective Interest Rate.We Fools may not all hold the same opinions, but we all believe that considering a diverse range of insights makes us better investors.I calculated this with a finance calculator with the following inputs: Future value: 100,000.For the year of purchase and the year of sale or maturity, you have to account for a partial year, multiplying the monthly amount by the number of months during the year that you actually owned the bond.The effective interest method results in a different amount of interest expense and amortization each year.You can find the amount of discount amortization by taking the interest expense we calculated (9,385.54) and subtracting the cash interest (9,000 resulting in 385.54 of discount amortization in year one.We'd love to hear your questions, thoughts, and opinions on the Knowledge Center in general or this page in particular.Each year the amortization is subtracted from the carrying amount, and the new carrying amount is used to calculate interest expense and amortization for the next year.

It will pay 10,000 in interest to its bondholders each year.
27, 1985, the straight-line method is still an option.