Bond Amortization Calculator

What does it do?

Bonds are a form of debt finance used by a business. When a bond is issued at a value above or below its par value, a premium or discount is created. In order to account for the bond properly, this premium or discount needs to be amortized over the lifetime of the bond.

This bond amortization calculator can be used for any bond up to a maximum term of 200 interest payment periods. The calculator will calculate both straight line method amortization, and will also produce an effective interest method bond amortization schedule, setting out for each period, the bond book value opening balance, amount of interest, periodic payment, closing bond balance, and the bond premium or discount amortization.

Bond Amortization Calculator Instructions

The Excel bond amortization calculator, available for download below, is used to calculate bond premium or discount amortization by entering details relating to the bond rate, term, payment periods, bond amount, and the market interest rate at the time the bond is issued. The bond amortization calculator is used as follows:

Bond-Amortization-Calculator-v-1.0 d
Bond Amortization Calculator Preview

Step 1

Enter the annual bond rate.

Step 2

Enter the term of the bond in years.

Step 3

Enter the number of times interest payments are made on the bond each year. For example, a semi-annual bond has two interest payments each year and the number 2 would be entered.

Note: The total number of periods (term in years x number of payments each year) must not exceed 200, otherwise a error message will be shown.

Step 4

Enter the par value of the bonds issued.

Step 5

Enter the annual market interest rate at the date the bond is issued.

The bond amortization calculator calculates the bond issue price, which is a function of both the bond rate and the market rate.

Note: If the market rate is not known and the bond issue price is given, then use the Excel goal seek feature to set the bond issue price value by changing the market rate cell.

Step 6

The bond amortization calculator calculates the total premium or discount over the term of the bond. the straight line method amortization for each period, and produces an effective interest method amortization schedule showing the premium or discount to be amortized each period.

Bond Amortization Calculator Download

The Excel bond amortization calculator, available for download below, allows for any bond up to a maximum term of 200 interest payment periods, and is used by simply entering values for the bond, rates, and term.

The bond amortization schedule calculator is one type of tvm calculator used in time value of money calculations, discover another at the links below.

Notes and major health warnings
Users use this bond amortization calculator template at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a amortization schedule calculator that you might use. It is purely illustrative of a bond amortization schedule excel. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the bond amortization calculator, please let us know and we will try to fix it.
Bond Amortization Calculator November 6th, 2016Team

You May Also Like


Related pages


debtors control accountaccounts receivable reconciliation exampleunearned revenue deferred revenuedays sales in receivables ratio formuladefine contrasamortization accounting treatmentbookkeeping formulajournalize accountingunearned revenue entryaccounts payable debit or credit balancefuture value annuity chartbeginning inventory purchasesabsorbed overheadwhat is accounts receivable turnoverbank reconciliations definitioncallable preference sharesaccrual and deferral accountingprepaid expenses appear in theexcel amortization spreadsheetcalculate interest expense on loansimple annuity formulacalculation of irr in exceldefinition of bills payablecash voucher formatcost of goods sold chart of accountsannuity formula in exceladjusting entries for dummiesdefine deferred incomebudget projection templatepv of an annuity dueonline apportionment calculatortimesheets templatedebtor days outstanding6 steps in accounting cyclehow to use pmt function in excelimplicit interest ratethe basic accounting equation isannuity due payments are madewhy is unearned revenue a liabilitywhat is lifo methodmarkup and gross profitapic journalhow to compute ending retained earningscalculate lease payment formulaformula retained earningsfixed asset register template downloadhow to calculate trial balanceamortisation definitionpartnership profit sharing rationet30 termsconsignment stock definitionhow to solve for variable costcredit card equationconsignee consignorgeneral ledger knowledge teststatement of retained earningwhat is a post closing trial balancepurchase of marketable securitiesformula for reducing balance depreciationtotal assets turnover formuladouble entry bookkepinghow to calculate accounts payablejournal entry for capital accountaccounting journalizingsimple depreciation calculatorfuture value annuity tabledefine contribution margin ratiodebits and credits cheat sheetleverage ratio formulaequation for cost of goods soldcost volume profit graph excel templatecalculating finished goods inventoryaccrual and prepaymentdebiting and creditingcash disbursement journal sample