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 effective interest method  
Loan fees income, expense, other charges amortization
Dealer indirect lending fees, charges amortization
Omnibus - MBS, hybrids, loan packages, syndicated
Bonds - Premium, discount accounting software
Bonds - Issuance, debt cost accounting software
Calculator Suite for individual bond schedules
Bonds - Call Dates and Call Prices
  •  Highlights
  •  Prices
  •  Free demo
  •  GAAP, FASB compliant
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 and without call prices



Bond accounting and reporting software ....

Maintain basic information for dozens, hundreds, thousands
of bonds in one or more Excel worksheets.
     Purchased bonds and
     Issued bonds
     •  Fixed rate
     •  Zero rate
     •  Variable rate
     •  Convertible
     •  Callable - with or without a call price
The software will
     •  Import one, some or all worksheets
     •  Calculate and display all bonds
     •  Generate premium, discount recognition totals
     •  For any month and current, prior, future calendar, fiscal, audit year 
Calculate effective interest rates for constant yield under FASB 91
     360
     365
     366 actual days basis
Premium recognition, balance, cost basis book value
Discount recognition, balance, cost basis book value
Interest at the coupon rate
Also amortize:
     Bond issue costs
     Bond acquisition costs
Rate change
        Recalculate effective rate over remaining term due to a rate change
        Calculate coupon interest over remaining term at the new rate
Par reduction
        Accelerated premium, discount recognition for reduction amount to par
Generate group and portfolio totals
Annual recap for audit and examinations
Automatically generate lifetime bond amortization schedules
General ledger reporting:
     Subsidiary listing trial balance:
               Premium, discount, book value subtotals within general ledger account
     Interest accruals:
               Monthly interest amount or
               Interest from "Accrue from" date for post and reverse operations
     Journal vouchers in debit and credit column format
     General ledger posting files with transactions formatted for your chart of accounts
   
   





































Related software ....
MBS, syndicated, LSBO, secondary market, grouped originations, bundled loans, other types of underlying collateral. 
FASB 91 premium, discount, other fees accounting amortization software for irregular reductions to par, principal on loans, packages, bond paydowns, other purchased and originated instruments.   Premium amortization, discount accretion, deferred fee recognition for purchasers, sellers, originators over a begin date to maturity date.  Effective interest rate calculation, accounting and reporting for actual, aggregated, weighted average rates, terms.  Accelerated recognition for paydowns.  Detail schedule for each record.
Omnibus FASB 91 for instruments, purchased, originated with irregular reductions to par or principal

Individual loans - fee income, cost, expense amortization under FASB 91.  Amortizing loans, interest only, balloon, fixed rate, variable rate, full term, average life term.  Interest rate changes.  Paydowns and curtailments.  Residential, commercial, consumer, auto, secured, unsecured and other loan types for originators and borrowers to recognize direct and indirect lending fees consisting of origination or borrowing points, income, cost, charges, expense.  Effective rate calculation, amortization, accounting and reporting for dozens, hundreds, thousands of deferred loan fee records.  Budget projections.  Detail lifetime FASB 91 schedule for each loan.  Supports early payoffs, paydown curtailments and rate changes.
Loan fees Cost, income, both Effective interest method, FASB 91

Calculators - FASB 91 effective interest method and Straight line method to calculate one bond at a time
Bond premium and discount effective interest method amortization
Bond premium and discount straight line method amortization
Comparer:  Straight line vs. effective interest method bond amortization schedules.  What's the difference?
Bond issue costs and bond acquisition charges amortization
Other methods for financial accounting general purposes
Calculator Suite page






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
     •  Evaluate the software
             Download a demo from the Price page right now.  No registration required.

     •  Evaluate reports
             The Price page contains an Excel file into which you can save some or all of your bonds.
             Send us the file and we will return the same file with additional worksheets and reports containing your bonds.






Related software  -  click to view page ....
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.

 

Screen samples.  Click to view ....


Bond purchasers and bond issuers
     Purchased bonds premiums and discounts and
     Original issue premiums and discounts (see below for bond issue costs)
  •  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 ....
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.

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







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