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

payback period calculation excelaccounts receivable turnover ratio calculatormaterial requisitiondebits and credits made easydouble declining balance depreciation tablevertical analysis cash flow statementamortization of prepaid expensesquick ratio formula calculatorsupplier reconciliation templatehow to calculate depreciation rate formulafifo accounting examplegaap basicsreplenish petty cash fundhow to calculate carrying value of a bondnpv calculator in excelgross profit margin percentage formulaannuity present value formulacalculate fixed cost per unitbookkeeping for dummies uk pdfaging receivablesworking capital efficiency ratiofixed overhead volume variance formulacalculate inventory turnover ratiohow to calculate work in process inventory endingdefinition of unearned revenueprofitable indexentry to replenish petty cashsample cash receipt templateadjustment journal entrieswork in progress accounting entriesformula to calculate direct labor costcalculate markup formulasample retained earnings statementonline apportionment calculatoroverhead cost examplesfinancial leverage ratio definitioncalculating ratios in excelledger entry in accountingdouble entry bookkeeping system definitiontrade discount calculationdaily petty cash formatdeclining depreciation methodhow to calculate tie ratiowhat does eom meandifferentiate between trade discount and cash discountpresent value annuitydisposal of fixed assets journal entryaverage receivable turnoveraccounting roadirect materials cost varianceconvert cash calculatorinterest rate formula excelaccrued revenues examplesformat of general ledgerbudget projection templatevertical analysis for income statementcash receipts accounting definitionmanual bookkeeping exampleswarranty expense income statementcapital turnoverjournal entry for stock dividendoverstatement examplessub ledgerssundry accounts definitionroce calculationadjusting journal entriesfifo accounting examplecompute total manufacturing costhow do you calculate dsomarkup calculator percentagehow to record prepaid rent journal entrybad debt expense formulaexcel spreadsheet for accountingformula of material price variancedeferred taxation definition