Reset  Recalculate     Contact     Help  
 
A B C D E F G H I J K L
  1    BondBeagle
  2   
  3   
  4    conheady@telfer.uottawa.ca
  5   
  6    bondterrier.com and bondlabrador.com
  7   
  8    BondBeagle deals with:
  9   
  10   ·        Issuance on or between interest payment dates.
  11   ·        Retirement on or between interest payment dates.
  12   ·        Straight-line or effective-interest-rate amortization of discount/premium.
  13  
  14  
  15   What BondBeagle does:
  16  
  17  
  18  
  19   **Journal entries and accompanying explanations generated:
  20   1:         On the date of issuance.
  21  
  22   3:         On the date of retirement.
  23  
  24   5:         On the date of maturity.
  25  
  26   BondBeagle does not deal with:
  27  
  28                     see BondTerrier at bomode.telfer.uottawa.ca/BondTerrier
  29  
  30                     see BondLabrador at bomode.telfer.uottawa.ca/BondLabrador
  31   ·        Defeasance.
  32   ·        Serial bonds. bomode.telfer.uottawa.ca/tdr/tdr_sheet.aspx
  33   ·        Troubled debt restructuring.
  35  
  36   BondBeagle's constraints:
  37   ·        1, 2 or 4 interest payments per year.
  38   ·        Assumes straight-line amortization of bond issuance costs.
  39   ·        The stated (coupon) interest rate must be >=0%.
  40   ·        Interest payment anniversary dates occur on the first or last day of the month.
  41   ·        Percent of bonds retired: 0% to 100%.
  42   ·        Retirement or call price as a % of face value must be > 0%.
  43   ·        Maximum of one retirement or call event during the bond's life-cycle.
  44   ·        Does not consider the value to the issuer of a bond's call feature.
  45   ·        Number of decimal places for the present value calculations: 3, 4, 5, 6, 7 or 8.
  46  
  47   ·        The amortization table displays a maximum of 40 interest payment periods.
  48   ·        The amortization table is not generated for situations where all of the following conditions exist:
  49   (i) the effective interest rate method is used for bond premium/discount amortization, and
  50   (ii) the effective interest rate (yield) is not provided in the INPUT worksheet, and
  51   (iii) the date of issuance is between interest payment dates.
  52  
  53   BondBeagle Copyright (c) Brian Conheady. All Rights Reserved.
  54  
  55  
  56  
  57  
  58  
  59  
  60  
  61  
  62  
  63  
  64  
  65  
  66  
  67  
  68  
  69  
  70  
  71  
  72  
  73