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
         - Amortize deferral balances over 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.

•  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 listing trial balance
          Detailed records plus accounting subtotals
          Journal voucher with general ledger debit and credit summary recap 

•  General ledger posting file preparation
          Supports any chart of accounts

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

•  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

•  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

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.