FASB 91 software for callable bonds
 
logo
    Amortization
     Software
 
Accounting  
Prepaid expenses, deferred charges amortization
Deferred income, revenue amortization
Fixed assets, FF&E straight line depreciation

FASB 91 Accounting  
Omnibus irregular payments FASB 91 amortization
Loan fees accounting FASB 91 amortization
Bond accounting effective method FASB 91 amortization
Bond accounting straight line method amortization
Bond issue costs, original debt amortization
Variable rate bond amortization
Paydown, payback, bond partial sale, recall amortization
Bonds - Call Dates and Call Prices
  •  Calculators and accounting software
  •  Purchased bonds and Issued bonds
  •  Import bond data stored in Excel
  •  Highlights
  •  Prices
  •  Free demo
  •  GAAP, FASB compliant
Generate lifetime bond schedules calculator suite
     Premium and discount schedule calculator
     Issue cost amortization schedule calculator
     Acquisition cost amortization schedule calculator
     Effective method vs. straight line calculator
CPA, auditor, financial advisor FASB 91 page
FASB 91 effective interest method all products

Financial Data Support Systems, Inc.  
Home page
About us
Contact us
Technical FAQs
 
PC, laptop, workstation and
shared network devices
running Windows®

Business, government, financial institutions, accounting firms ....
 


 
Callable Bonds - with or without call prices



 
Bond accounting and reporting software to ....
Automatically import your bonds from Excel
   •  Import all bonds from a single worksheet
   •  Import from multiple worksheets at the same time
Calculate FASB 91 constant yield effective interest rates
Calculate premium recognition and balances
Calculate discount recognition and balances
Calculate interest at the coupon rate
Generate income and expense totals
For any month
For the current year
For any prior calendar, fiscal, audit year
   




               Sample screen highlights  ....


Regular bonds
  •  Excel worksheet.  Software import screen.  Lifetime bond schedule.
  •  Calculate entire year(s).  Audit.  Prior periods.  Applicable for all bond types.

Callable bonds 
  •  Excel worksheet.  Software import screen.  Lifetime bond schedule.

Convertible bonds 
  •  Excel worksheet.  Software import screen.  Lifetime bond schedule.

Zero rate bonds 
  •  Excel worksheet.  Software import screen.  Lifetime bond schedule.

Variable rate bonds 
  •  Excel worksheet.  Software import screen.  Lifetime bond schedule.

Partial sale, partial call, reduction to par 
  •  Excel worksheet.  Software import screen.  Lifetime bond schedule.

Sale, early call 
  •  Excel worksheet.  Software import screen.  Lifetime bond schedule.

Issue costs 
  •  Excel worksheet.  Software import screen.  Lifetime bond schedule.

Acquisition costs 
  •  Excel worksheet.  Software import screen.  Lifetime bond schedule.



               Your existing bonds ....

Have not been recognizing premiums and discounts:
If you have not been booking premium and discount recognition, the software can provide the amount which should have been been recognized under FASB 91 from original bond dates through any month and year.

Have been recognizing premiums and discounts:
If you have been booking premium and discount recognition using another method, the software allows you to retain current balances.
In the Excel worksheet:
Substitute Price column with:
     Par plus current premium balance or
     Par minus current discount balance
Begin Date will be the first month for the system to begin, typically the month following that of the premium and discount balances.



               Related software ....
Bond packages?  Syndicated?  MBS?  Participations?
Irregular paydown amounts or payment streams?
Other types of financial instruments, originated or purchased?
View our Omnibus FASB 91 amortization software






Accounting for ....

     •  Callable bonds
                With a call date
                With or without a call price

     •  Non callable bonds

     •  Effective interest rate, constant yield calculation 

     •  Premium amortization

     •  Discount accretion

     •  Bond purchasers and

     •  Bond issuers

     •  Municipal, corporate, government, notes, bills, agencies

     •  Virtually any type of premium, discount financial instruments

     •  Dozens, hundreds, thousands of

     •  Fixed rate bonds

     •  Convertible bonds
               Calculates a constant rate

     •  Zero rate

     •  Variable rate, steps

     •  Floating rate

     •  Rate change - other

     •  Partial sale, partial call

     •  Reductions to par - other

     •  Complete sale, early call, redemption

     •  Bond acquisition costs
               Acquisition costs are an expense
               Amortize acquisition costs as a premium

     •  Bond issuance costs
               Issuance costs are an expense and amortized as a discount











 

Designed for ....
      •  Business, financial institutions and other monthly accounting bond purchasers
              Generate monthly premium and discount recognition, interest accruals and more

     •  Government, agencies who issue bonds
              Generate monthly, annual premium and discount recognition
              Amortize original issue, debt costs

     •  Individual investors
              Generate all premium, discount information required by you and your accountant
              Discount income, premium expense, coupon interest, OID Original Issue Discounts
              Track and clear purchased interest
              Net sale proceeds utilizing cost basis accounting

    •  CPA and accounting firms.  Financial advisors.
                Business, government, individual investor clients
                Calculate recognition for their bond files
                     Generate calendar and fiscal year totals.  Monthly, quarterly totals.
                Recalculate a file for prior years
                    Audit and due diligence
                Straight line vs. effective interest method comparisons
                     "What if?" questions.  Special projects.
                Export, archive calculations and reports to Excel
                Exclude bonds which were added after a desired calculation time period
                    Example:  A worksheet contains bonds from 2009, 2010, 2011, 2012, 2013 and 2014
                    When working with the year 2013, you can exclude the 2014 bonds from calculations and view.
                Client servicing
                    Calculate bonds on behalf of a client for any period.  Export results.
                    View this page to see how they utilize the software to calculate, audit or provide accounting services for client files


Simple to use
      Basic information for a bond portfolio is maintained in one or more Excel worksheets
               Par, settlement, maturity, coupon rate ....

      Worksheet templates with headers and column documentation come with the software
               Enter bond data and
               Copy/paste bonds from existing worksheets
               Add/insert new bonds at any time

      User defined Group categories to segregate bonds and provide totals by/for any purpose.

      The software automatically imports a worksheet and performs required calculations
              Constant yield, FASB 91 effective interest rate
              Premium amortization
              Discount accretion and more
              Import and calculate dozens, hundreds, thousands of bonds in a matter of seconds



Price page and free demo  ....
Click to open and view Price page
Free demo as MSI or Zip file ....
         Download a demo from the Price page right now.  No registration required.  Available as:
              MSI - Microsoft installable package - install the demo to your business or home computer.
              Zip - Skip installation.  Simply extract and run the program.
     Demo includes several Excel files with:
          •  Bonds
          •  Bonds with reductions to par and changes to coupon rate
          •  Acquisition costs
          •  Issuance costs





Related software  -  click to view page ....
Generate lifetime bond schedules calculator suite
     Premium and discount schedules
     Issue cost amortization schedules
     Acquisition cost amortization schedules
     Effective method vs. straight lines

Bond or loan packages?  Irregular paydown amounts?  Other loan type financial instruments?
     View our FASB 91 Omnibus software for purchased loans
      packages, MBS, LSBO, sold participations, other instruments
      Omnibus premium, discount FASB 91 amortization software












Enhanced option for business ....
General Ledger Posting and Reporting Module includes
     •  General ledger journal voucher and posting file for premium, discount recognition
               Asset and liability general ledger account numbers
               Income and expense general ledger account numbers

     •  Subsidiary listing Trial Balance with totals by each set of general ledger accounts
               Income and expense totals
               Premium and discount balance totals
               Book value totals
               For any month, quarter or year

     •  Interest accruals with journal voucher and general ledger posting file
               Accruals can be for a month (period) or
               Total accrual from an "Accrue From" date for accrue and reverse operations
               Purchasers:  Income and receivable general ledger account numbers
               Issuers:  Expense and liability account numbers

     •  General ledger posting files for all of the above 
               Postings can be created for a month, quarter or calendar/fiscal year
               Postings have an Undo function to reverse a posting made in error
               Postings can be formatted for uploading to any general ledger system

     •  Bond issuers:
               Separate amortization of bond acquisition charges, issue costs






Calculate premium and discount recognition for

     •  Purchased or Issued
               -  Municipal bonds
               -  Agencies
               -  Corporate, government, notes, bills, debentures ....
               -  Virtually any instrument having a premium or discount
   
     •  Premium amortization using the effective interest method
               Amortization for each bond plus a detailed, lifetime schedule
               Amortization and balance totals for all bonds with a premium

     •  Discount accretion using the effective interest method
               Accretion for each bond plus a detailed, lifetime schedule
               Accretion and balance totals for all bonds with a discount

     •  Constant yield, effective interest rate calculations under FASB 91
               The same system also supports the straight line method

     •  Coupon rate interest calculation for each bond, plus a total for all bonds
               Interest accruals with general ledger posting file

     •  Calculate
               Dozens, hundreds, thousands of bonds at the same time
               Monthly.  Quarterly.  Range of months.  Calendar and fiscal year totals.
               Current period.  Prior periods.  Future periods.

     •  Fixed rate bonds plus

     •  Convertible bonds
               The system calculates a constant rate
               The constant rate and effective interest rate determine amortization, accretion recognition

     •  Zero rate bonds, convertible or otherwise

     •  Variable rate bonds, floating rate, steps
               Calculation of initial effective interest rate
               Effective interest rate recalculation with each rate change

     •  Call dates, with or without a call price
               Premium, discount calculations to a call date Cost Basis, Book Value

     •  Reductions
               Bonds with reductions to par, such as a partial sale, recall, paydown
               Accelerated recognition of premium or discount balance proportionate to reduction in par

     •  Existing bonds
              Two solutions:
              Recalculate existing bonds using original dates
              or
              Retain current cost basis, book value.  Convert existing bonds and balances with no journal adjustments.

 



A single software system provides ....

     •  Accounting - Effective interest method portfolio calculations and totals for multiple bonds in an Excel file

     •  Accounting - Straight line method portfolio calculations and totals for multiple bonds in an Excel file

     •  Calculator - Effective interest method for one bond at a time

     •  Calculator - Straight line method for one bond at a time

     •  All support 360/365/366 day basis



Portfolio NET totals consisting of
     Coupon rate interest
     + Discount Accretion
     - Premium Amortization
     = NET for any Month.  Quarter.  Calendar or fiscal year.  Go back in time.  Go forward in time.





Bonds consist of loan packages?  View our Omnibus FASB 91 premium and discount amortization software for
  •  MBS, syndicated packages, LSBO, secondary market, grouped originations, bundled loans, bonds with monthly par reductions and more.


Premium and discount portfolio accounting
  •  Generate income and expense detail plus totals for:
  •  Any month
  •  Any quarter
  •  Any annual, yearly period - calendar or fiscal
  •  Historical - view a portfolio as it was at any time in the past
  •  360/365/366 days in a year basis at the bond level matches coupon interest basis
  •  User defined Group totals



Purchased bonds
     •  Investors, traders, business, institutions, trust departments, client accounting services ....
     •  Calculate discount income, premium expense on a monthly, quarterly, annual basis for all bonds at the same time



Issued bonds
     •  Municipalities, taxing districts, corporate .... (amortize bond issuance costs, too)
     •  Calculate discount expense, premium income on a monthly, quarterly, annual basis for all bonds at the same time
     •  Amortize original issue, debt issuance amounts, too



Variable rate instruments, such as Steps
     •  The system calculates a new effective interest rate with each rate change, including mid-month dates
     •  The system switches to calculating coupon interest at the new rate as of the actual rate change day


Convertible rate bonds
     •  The system calculates a blended, constant interest rate
               Premium and discount recognition is the difference between effective rate interest and constant rate interest
     •  The system switches to calculating coupon rate interest at the convertible rate on the convertible date


Call Dates
     •  Premium and discount recognition to a Call Date


Call Prices
     •  Premium, discount recognition to a Cost Basis Call Price
     •  Example:  Purchase 100,000 at 97 with a Call at 102 and the system accretes 5,000 to a Cost Basis 102,000
     •  Example:  Purchase 100,000 at 103 with a Call at 101 and the system amortizes 2,000 to a Cost Basis of 101,000


Sale or early call, redemption date
     •  The system recognizes the remaining premium, discount balance in full
     •   If a Call Price is involved, the system makes all necessary adjustments, including the recapture of any recognized portion of the Call


Partial sale, early call, redemption
     •  The system accelerates premium, discount recognition by the percentage of: ReductionToPar / Par
     •  Remaining premium or discount is calculated over the remaining term
     •  If a Call Price is involved, the system makes all necessary adjustments, including the percentage recapture of any recognized portion of the Call


Reductions to Par
  •  Accelerated recognition of premium and discount balances for
  •  Partial and complete sales
  •  Partial and complete recalls
  •  Other reductions to Par for any reason



Comply with these FASB, GAAP recognition methods ....
     •  FASB 91 effective interest method, level yield
           Calculates effective interest rates for fixed rate and convertible bonds
           Amortization and accretion based on the difference between the effective interest rate and coupon rate
     •  Constant interest rate method
           Calculates constant rates for convertible bonds
           Amortization and accretion based on the difference between the effective interest rate and constant rate



Easily account for exceptions arising from ....
     •  Early calls, redemption  (the software recognizes premium, discount balance in full)
     •  Partial calls, redemption  (the software accelerates premium, discount recognition by the call amount percentage)
     •  Sales  (the software recognizes premium, discount balance in full)
     •  Partial sales  (the software accelerates premium, discount recognition by the par reduction percentage)
     •  Periodic reductions to Par for any reason  (the software accelerates premium, discount recognition by the par reduction percentage)



•  Purchased bonds
     -  Held to maturity or trade/sale/early call date



•  Issued bonds
     -  Including issuance cost amortization (for more on this, view our Bond Issue Costs amortization page)



•  Fixed rate bonds
   and
•  Convertible bonds
     -  Including initial rate of zero
     -  Convertible rate amortization, accretion at Constant interest rate
     -  OID bonds
     -  For variable rate bonds when future dates, rates are unknown, view our Omnibus Variable, Floating Rates software page)



•  Discount accretion
     -  Individual bond level
     -  File, portfolio totals
     -  General ledger totals
     -  Lifetime accretion schedule for a bond



•  Premium amortization
     -  Individual bond level
     -  File, portfolio totals
     -  General ledger totals
     -  Lifetime amortization schedule for a bond



•  OID
     -  OID accretion totals (for more on this, view our Original Issue Discounts OID amortization page)
     -  Group and track OID with purchased bonds accretion totals
     -  Compare recognition amounts between OID and purchased
             Monthly
             Quarterly
             Annual (fiscal and calendar year totals)



•  Early call/redemption/sale date
     -  Recognize deferral balance in full as of any date for any reason



•  Interest at the coupon rate
     -  Calculate coupon rate interest and accruals for any period, too
     -  Supports 360/365/366 day basis



•  Generate:
     -  Premium recognition subtotals
     -  Discount recognition subtotals
     -  Accounting reports
     -  Journal voucher posting source document
     -  General ledger transaction posting file (supports any chart of accounts)



•  Existing bonds
     -  Preserve current deferral balances or
     -  System can calculate current balances



•  Virtually any premium or discount instrument to be calculated under GAAP, FASB 91
     -  Municipals
     -  Corporate
     -  Government
     -  Notes
     -  Bills



Software to
     •  Calculate FASB 91 effective interest rate for all bonds at the same time
     •  Effective interest method recognition under FASB 91 for
          -  Premium amortization
          -  Discount accretion
          -  Issue costs - Amortized and tracked separately
          -  Group totals
          -  File totals
          -  Remaining balance and book values
     •  Accounting recognition periods:
          -  Monthly
          -  Quarterly
          -  Other multiple months
          -  Annual:  Calendar or fiscal year
          -  Past, current and future periods
     •  Lifetime amortization, accretion schedule for each bond
    


Available with a General Ledger and Reporting module ....
     •  General ledger reporting
          -  Subsidiary ledger balancing report
               Detail and totals by each general ledger account for
                    -  Premium and discount recognition
                    -  Accumulated
                    -  Remaining balance book values
          -  Journal voucher posting source document
          -  General ledger transaction posting file
                    -  Formatted for uploading to your general ledger system

     •  Interest accruals at bond coupon rate:
         -  Monthly amount (book to receivable) or
         -  Gross accrual from an accrual date (for book and reverse operations)
         -  Accrual report, journal voucher posting source document and general ledger transaction posting file


     •  NET report - what did you earn on your portfolio?
              Coupon interest for the period
          +  Discount accretion
          -  Premium amortization
          +  Gain on Sale
          =  NET result for each bond and entire portfolio



Your existing records
     •  Easy conversion ....
          -  Preserve current general ledger balances or
          - Have the software recalculate premium and discount amortization from Begin dates.



Enhanced reporting ....
•  Accounting and general ledger posting and reporting
     -  Generate amount to book to income and expense accounts
     -  General ledger reports, posting reports and upload posting file
     -  Monthly interest accruals
     -  Totals by user defined Row Header category
     -  Issuance cost amortization for bond issuers
     -  Early maturity date to recognize all due to call, sale or other disposition


Maintain bond records in one or more worksheets.  At any time,
1)  Import a worksheet
2)  Select a calendar month and calculate:
     -  Premium and discount recognition for an entire file
     -  Issue costs, fee recognition for an entire file
     -  FASB 91 effective rate, calculations and compliance
     -  Interest accruals
     -  All monthly accounting reports
     -  General ledger postings
          Direct post and
          Allocate to multiple cost and revenue centers
     -  Lifetime amortization schedule for any bond
     -  In a matter of seconds!


Getting started is easy.
     No adjusting journal entry required.
     Be up and running in no time.

Export calculation results and reports to Excel, other spreadsheet.
     For internal use.
     Email to outside auditors.

Records retention.
     Export reports to a worksheet.
     Or save bond worksheets with a unique monthly name.
          Import, calculate, report at any future date.


During import, the software:
     -  Determines premium or discount amount
     -  Calculates effective interest rates
     -  Provides:
          Monthly premium and discount amortization and accretion based on selected calendar date
          For each record:
               Monthly premium and discount recognition
               Accumulated recognition
               Deferred premium or discount balance
               Book value carrying balance
          Summary totals of the above by category:
               Premium totals
               Discount totals

You can also:
     Generate amortized income and expense totals for a
          Month
          Quarter
          Calendar or fiscal year
          As of a prior or future period
     View a lifetime month by month amortization and recognition schedule for any record
     Copy and paste results elsewhere

 


 


Price
Price pages include ....
Stand alone and network sharing prices
Free demo you can download right now

Bond accounting software
Excel files with sample bonds
Click to open and view bond accounting Price page


Bond Calculator only
Calculate one bond at a time
     Click to open and view Price page



Questions?
Don't see what you need?
     Need some assistance with your situation?
1-800-245-8444
or email Support@fdssi.com

Other pages of interest ....
FASB 91 products page
Omnibus - Loan, bond packages FASB 91 amortization
Loan origination fees FASB 91 amortization
Bond accounting straight line amortization
Bond issue costs FASB 91 amortization
Enter, calculate one record at a time calculator suite
CPA, auditor, financial advisor FASB 91 page
FASB 91 custom system
FASB 91 services offered
 
 
  FASB 91 software for callable bonds
 Windows® PC, laptop, workstation and network sharing by
© 1995 - 2015 Financial Data Support Systems, Inc.
Home page        |        About us       |        Contact us       |        Site map

Top

fas 91 software page  fas91 page   sfas91 page   loan income software   bond amo page   effective method calculators   fas91 software   securities   effective interest   fasb trial   dealer fee   bond accounting  fasb91 calculator