To preserve your existing balances, substitute the following Excel worksheet values:
     •  Column F: Price
        Set Price to either
               Par + current Premium balance or
               Par - current Discount balance

     •  Column C: Begin Date (normally the settlement or acquisition date)
        Set all Begin dates to the 1st of your effective conversion month.

     •  The software will:
         - Establish premium or discount classification
         - Preserve your deferral balances
         - Calculate an effective interest rate using the remainder of the term

Tip:  Following conversion, the same logic can be employed in the event of a par paydown, partial sale, assignment or other change (the software also has a reporting and deferral balance recognition module for early payoff bringing par to zero)

•  Calculate, report and account for
          Premium and discount amortization
               A detailed lifetime recognition schedule is provided for each record
          Interest accruals
          Par amortization, accretion

•  All monthly reports:
          View, print, export
          Subsidiary ledger trial balance
               Detailed records plus accounting subtotals
          Journal voucher source document
          General ledger posting file
               Debit and (credit) summary postings
               Supports any chart of accounts

•  Premiums and discounts
         Monthly recognition to income, expense
         Accumulated
         Deferral balance
         Accretion balance as FASB Carrying amount

•  Interest accruals
         Calculate an accrual for the current month only
         Calculate a total accrued using an "accrue from" date
              Supports accrue and accrual reversal functions
         Projections:  Calculate interest accrual through end of year, other period

• Par amortization for sinking fund, other tracking purposes
         Monthly amortized recognition
         Accumulated
         Par balance

•  Period calculations
         Fiscal and calendar years
         Determine all balances "as of" a future month, EOY period
         Determine income, expense spanning multiple months

•  Export
          Copy and paste to Excel worksheet
          Copy reports, data, schedules
               Copy calculated results "as of" any month

•  Free Calculator
          The software includes our Bond Calculator screen
          Double clicking an import record opens and prefills the screen
          Enter Bond data directly to the Calculator screen, too

•  Graphs
          Contrast one value within another
          Examples:
               Par within maturity months for cash flow projections
               Par grouped by nominal rate (nearest quarter)
          Copy a graph to Excel
          Copy the data and use Excel graph functions

•  Allocation capabilities
         Distribute income, expense to revenue and cost centers

•  Download a free demo and try the software today

Optional data columns:
• Days in year for calculation basis of 360, 365, 366
• General ledger accounts for premium, discount deferrals and for interest accruals
• Interest accrual "Accrue from" date

Why rent?
Import and calculate all of your records as of prior, current or future month.
Compare results to current procedures or straight line vs. effective interest method.
Prices and how to download a free demo can be found at bottom of this page.

Rental Tip!
Open software in two windows.  Run effective method in one window, straight line in the other (rental includes both methods).  Compare screens.  Copy each screen to Excel - subtract columns from one another.