Bond accounting software using level yield, effective interest method    

Financial Data Support Systems, Inc. 
Amortization Software for
Prepaid Expenses, Deferred Charges    
Deferred Income, Unearned Revenue
MBS, GNMA, LSBO Premiums, Discounts
Loan Fees Income and Expense
Merchant Cash Advance Discounts
Indirect Lending Dealer Fees
FASB 91 Products Page
  Bond Purchasers, Level Yield Method
Bond Purchasers,  Straight Line Method
Bond Issuers, Level Yield or Straight Line
Excel Worksheet Amortization
Allocation to Cost and Profit Centers
Fixed Assets, FF&E Depreciation   
Home page
About, contact us





GAAP, FASB compliant
 
Related software:  Merchant Cash Advance Discounts     Purchased Loan Packages Premiums, Discounts     Bond Issuers   Straight Line Bonds

Bond Accounting Software
Effective Interest Method, Level Yield, Constant Yield 
for Bond Purchasers, with or without General Ledger and Accrued Interest Reporting


FASB 91 premium amortization, discount accretion for dozens, thousands of records at the same time.
     MUNICIPAL BONDS
     CALLABLE AND NON-CALLABLE, with or without a call price, with or without OID (also amortized by the software)
     CORPORATE BONDS
     HOSPITAL
     AGENCIES
     TREASURIES, BILLS, NOTES 
     FIXED RATE, VARIABLE RATE, ZERO RATE, CONVERTIBLE RATE
     OTHER BONDS AND INVESTMENTS
EXCEL  automatically import a file with all records to software installed on your computer or network

Highlights page with
Images
Price
Free demo

Hard to
find
accounting
software












Manage and account for:
     Municipal bonds
     Callable and non-callable bonds, with or without a call price, with or without OID
     Corporate bonds
     Hospital bonds
     Agencies
     Treasuries
     Bills
     Notes
     GNMAs, MBS, CMOs - account for monthly remittances, declining par balances (or use ASC-310-20 amortization)
     Special issues
     Other investments with or without reductions to par
     PIKs - payment in kind with increases to par



Virtually any premium or discount instrument having
     Fixed rate
     Variable rate
     Zero rate
     Convertible rate
     360, 365, 366 day basis



Generate reports for all bonds at the same time including:
    +  Earned interest
    +  Discount accretion income  (with OID comparison for applicable bonds)
    -   Premium amortization expense
 +/-   Gain or loss on sale
   =   NET EARNINGS



Amortization periods
     Any prior, current, future:
          Month
          Year
          Multiple years, calendar or fiscal for
                    Each bond
                    Totals for all bonds
                    User defined Group totals
                    Multiple bond files



Interest and rate calculations:
     Purchased interest:  Track and account for interest paid at time of purchase but not yet due
     Accrued interest:  Current month income posting plus Accrued Receivable Account balances (for business)
     Coupon interest:  Cash due this month:
                                         Coupon interest
                                         Purchased interest
                                         Par due to sale, maturity, call
                                         Total amount of coupon and purchased interest owed but not yet due
     Earned interest:  Coupon rate earnings for a period irrespective of accrual or cash activity
     Effective interest rate:  The difference between this and coupon rate determines level yield recognition 
     Constant yield rate:  Convertible bond earnings rate blending original and convertible coupon rates
     Portfolio rate:  Dollar weighted average coupon and effective rates for all investments



Amortize your investments
     Software and bonds reside on your computer
Amortize client investments
     Import and calculate a file for/from one or more clients
     Prior periods.  Current.  Future projections.




GROUP
     Group bonds and investments.  Obtain subtotals by any category.
     Examples:
               Group = Lot 123, Lot 456, Lot 789 .... (get subtotals for each lot)
               Group = California, New York, Florida .... (get subtotals by each issuance state)
               Group = Broker name1, Broker name 2 .... (get subtotals by each different broker)
               Group = 2019, 2018, 2017 .... (get subtotals by each year of purchase)
               Group using any category for which you require subtotals of all bonds and investments within each Group
     Multiple worksheets.
               Maintain bonds and investments in more than one worksheet.
               Import and calculate one worksheet.
               Import and calculate some or all worksheets.



Call dates:
     Amortize to Maturity date or
     Amortize to a Call date including
               Call price other than Par
               Callable but not called
               Partial calls, early redemptions



Administrative:
     Reconciliation worksheet for audits and exams
              Beginning balances for Par, Premiums and Discounts
              + Additions for the period
              -  Activity for amortization, accretion, reductions to Par
              =  Ending Balances
                  Net Change summation
     Mark to Market report - Book Value vs. Market Value position
     Portfolio value as of any given day



Month-by-month recognition schedule for each bond.  Annual subtotals.
     Includes a bond amortization calculator for "what if" questions
     What would happen if I sold an existing bond today?
     Should I buy this new bond?



Software and bonds reside on your computer, PC, network sharing system
     Copy, export, archive results.
     Income and expense, remaining balance, book value (cost basis), earned interest for each and totals for all records in a matter of seconds.
         From original begin dates or
         Current balances forward, as a conversion (no journal adjustments)










Click the Right Arrow to view next image ....








                                           Ideal for ....


Client servicing:
     CPA Accounting Firms, Financial Advisors.
     Import client data, export reports for
               Current month and year
               Prior and future months and years
     Amortization and accretion reports can span 1 to 60 months beginning with any month, year.
     Cost Basis, Book Values for entire portfolio
               As of any month
               As of any day


Individuals:
     Monthly, yearly discount income and premium (expense) totals.
     Lifetime month-by-month audit detail amortization, accretion schedule for each bond.


Business:
     All of the above plus a General ledger module which includes
               Subsidiary ledger account listing
               Journal entries and posting file
               Monthly interest accruals











  Price page and free demo  ....

Effective Interest Method

     Click to open and view Price page
     and download a free demo right now

Straight Line Method
     Click to open and view Price page
     and download a free demo right now


Bond file calculation services
We can calculate a bond file on a one-time basis.
Premium and discount amortization for a month.
     For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
For more information, Email  Bond file calculation services















REPORTS ....

     •  View
     •  Send to local or network printer
     •  Automatically export to Adobe
     •  Automatically export to Excel for internal and external distribution



Report 1:   Enlarged view of the software import screen listing
Another view of the Import screen, primarily so you can sort records by desired values, such as Coupon rate, Maturity date and more.



Report 2:  Trial Balance report
Premium, Discount recognition report.  Includes Journal Voucher and General Ledger Posting file.

Typically for General Ledger Business Version.
Premium amortization and discount accretion will be recognized for the selected calendar calculation month. Records will be sorted by the values in spreadsheet column U general ledger accounts. Totals will be provided for each account. Totals will be grouped within Discount and Premium categories.
A Journal Voucher and General Ledger posting file will also be created.
For non-business purposes, spreadsheet column U values can be used to generate subtotals for other purposes dealing with premiums and discounts.



Report 3:  Net recap report for calendar month or period
CASH interest +/- Discount, Premium amortization +/- Net Gain on sale.

Cash coupon interest received during the report period (the calendar month or number of months) plus Discount recognition and minus Premium recognition. The result is NET earnings for the period based on coupon cash receipts.



Report 4:  Finalized records report
Net Gain or Loss for All records which have matured or otherwise ended their term.

All records which have reached Maturity date, Call date, have been Sold, Paid Down to zero, Redeemed in full or otherwise finished their term.
Report consists of Net Gain or Loss based on spreadsheet column M, Gain/Loss on sale and/or column O, Sale Proceeds.
This report can also be used as a purge list when beginning a new year. Create a new spreadsheet with a file name dated for the new year. Delete records appearing on this report through the prior year end.
Records will appear in the order they appear in the spreadsheet in order to facilitate the above.



ABOUT COUPON INTEREST:  CASH vs. EARNED ....
CASH:
CASH and coupon interest due represent interest from one coupon payment date to the next.
Actual cash activity and dates need not be logged (see the following regarding differences between calculated earned and cash interest receipts). The system "moves" spreadsheet column R Payment Due date, along with a prior due/accrue from date, forward and backward based on the calendar calculation month.
EARNED:
EARNED interest is the amount to which you are entitled, typically representing full month periods but also spanning the entire life of the record. Interest is always being earned regardless of whether or not interest is received as cash (whether it be cash, check, direct deposit and otherwise). Think of Earned Interest as having a job where you get paid on Friday. Come Thursday evening, you have earned 4 days worth of your pay even though you won't get the cash until Friday.
This system calculates all interest based on spreadsheet values as they exist when imported. No calculations, report values or other results are ever saved from one import to another.
Penny differences will likely arise between actual cash received and what is calculated by the system. Substantial differences may need to be investigated.
Furthermore, coupon interest calculations in this software should never be used for tax or other reporting purposes. Instead, obtain and use the figures provided by the entity responsible for coupon payment disbursements.



Report 5:  Net recap report for calendar month or period
EARNED interest +/- Discount, Premium amortization +/- Net Gain on sale.

Earned interest for the report period (the calendar month or number of months) plus Discount recognition and minus Premium recognition. The result is NET earnings for the period.



About CASH INTEREST ....
The system "moves" spreadsheet column R Payment Due date, along with Accrue From date, forward and backward based on the calendar calculation month.
Actual cash activity and dates need not be logged.  Simply enter any Coupon due date and frequency for the system to adjust as needed.



Report 6:  Coupon Interest Status report
All coupon interest due since previous payment minus Cash Due this month.

Requires values in spreadsheet columns R and S (if columns R and S are blank, records will be flagged as missing required values).
The system determines the amount of coupon interest earned through this month including cash interest due. This furnishes everything earned and due since prior coupon payment dates. Records will be sorted by the values in spreadsheet column T general ledger accounts. Totals will be provided for each value in spreadsheet column T.
The report consists of records with a Begin Date equal to or earlier than the calendar month.



Report 7:  Cash Due this month report
Coupon interest payments plus any par reductions, sales, maturities occurring this month.

Requires values in spreadsheet columns R and S (otherwise, records will be flagged as missing required values) .
The report includes records having a coupon payment due date matching the selected calendar calculation month. The report will also include interest plus Par for records with a Maturity date, Sale date or other finalized reason date falling within the calendar month. Also included are any Net gain for sold bonds as well as Par for reductions to Par for the month.
Subtotals are provided based on values in spreadsheet column T.
The report can be printed and/or exported to Excel or another spreadsheet, enabling you to "tick off" cash receivables as they come in (it is not necessary to update the system with cash receipts).
Records with a Begin Date later than the calendar month will be excluded. Records which have finalized, such as matured or called, in months PRIOR to the calendar month will be excluded.



Report 8:  Accrued Interest report (requires General ledger module)
What was Earned this month.  Includes Journal Voucher and General Ledger Posting File.

Requires values in spreadsheet columns R, S and T (if columns R and S are blank, records will be flagged as missing required values).
Typically for business (running this report is optional and not required for the system to operate).
The system determines the amount of coupon interest to accrue for the selected calendar calculation month. Also provides a "Total Accrued" which includes applicable Purchased Interest for balancing to receivable accounts. Records will be sorted by the values in spreadsheet column T general ledger accounts. Totals will be provided for each account. A Journal Voucher and General Ledger posting file will also be created.
The report consists of records with a Begin Date equal to or earlier than the calendar month. Records which have finalized, such as matured or called, in or prior to the calendar month will be excluded.

RECONCILING RECEIVABLE ACCOUNTS: The Accrued Interest Report provides a subsidiary listing for general ledger receivable accounts.
CASH INTEREST RECEIVED: Interest receipts can be posted directly to income.
The Accrued Interest report and Accrued Interest Reversal report (below) eliminate the need to reconcile cash receipts to receivable accounts each month.



Report 9:  Accrued Interest Reversal report (requires General ledger module)
Reverse accruals for Cash Due that has been received.  Includes Journal Voucher and General Ledger Posting File.

Requires values in spreadsheet columns R, S and T (if columns R and S are blank, records will not appear on this report).
Typically for business (running this report is optional and not required for the system to operate).
The system determines the amount of accrued interest to reverse for the selected calendar calculation month.
Subtotals are provided based on values in spreadsheet column T.
Prior month accruals are NOT being reversed.
Reversals are created ONLY for records having a coupon payment due plus Matured, Called, Sold and records which Paid off in the selected reversal month.
Reversal amount consists of accrued interest previously posted by the system for these records for ALL months, including Purchased Interest posted by you.
The system calculates running accrual for bonds through the preceding month to determine the amount to reverse (bonds with accrued interest should not be deleted from the spreadsheet until reversals have been done).
Records will be sorted by the values in spreadsheet column T general ledger accounts. Totals will be provided for each account. A Journal Voucher and General Ledger posting file will also be created.
The report consists of records with a Begin Date equal to or earlier than the calendar month. Records must also have a Coupon Due date in spreadsheet column R and a column S code greater than 0. Records which have finalized, such as matured or called, in months PRIOR to the calendar month will be excluded.
   


Report 10:  Reconciliation Report for any month or annual period - Beginning balances plus activity for the period.
Balances at the beginning of the desired period, plus additions for new records during the period, minus activity equals ending balances.
Primarily used for reconciling changes to Balance Sheet accounts.



Report 11:  Market Position Quote report. Compare Market Quote to Cost Basis calculated as of calendar 'dd' day.
Requires values in spreadsheet column V and also uses optional values in columns W and X
The system will compare a Market Quote for a bond to the Cost Basis calculated as of (TO) the 'dd' date portion of the calendar date. Premiums and discounts are not recognized for the 'dd' date.
Determine your portfolio position for each bond, with a total for all bonds.
The report excludes these bonds:
Blank column V value
Matured or otherwise finalized










  Price page and free demo  ....

Effective Interest Method

     Click to open and view Price page
     and download a free demo right now

Straight Line Method
     Click to open and view Price page
     and download a free demo right now


Bond file calculation services
We can calculate a bond file on a one-time basis.
Premium and discount amortization for a month.
     For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
For more information, Email  Bond file calculation services








1
 












Client testimonials ....


Thank you!
This program has just made my life so much easier.  I can finally stop adding up all of my amortization schedules!
                  Georgia



We installed your software and just used it for the first time.  I can't believe how much work it will save us each month.
What used to take hours is now done in a matter of minutes.  Your product performs exactly as advertised!
                    Texas


Thanks.  Your customer service is fantastic!  Have a great week.
               Washington


Our outside accountants just completed their audit.  This is the first year we've been using your software AND the first year we received a clean audit report.
             New York


I'm a partner in a small CPA firm.
We were recently engaged to audit municipal bonds issued by a local agency.  Bond discounts needed to be recalculated using the effective interest method.
Calculations with annual reports had to be provided for each of the past seven years.  I can't believe how easily your software allowed us to finish the entire job in such a short period of time.
            New Mexico
 

Many thanks for the excellent help and support.  I was really not expecting feedback so quickly.
           Tennessee
 










If you don't see what you need ....
Special project?  Pressed for time?
We offer
     •  Bond calculation services on a one-time or recurring basis
     •  Software customization
     •  Other amortization software products

For more information,
email Support@fdssi.com
  




Amortize all bonds at the same time
     •  Effective interest rate calculation for level, constant yield
     •  Premium amortization
     •  Discount accretion
     •  Book Values, Cost Basis as of any month/year
     •  Monthly Totals
     •  Yearly (calendar or fiscal) Totals
     •  Prior months and years
     •  Future projections
     •  Coupon interest status report
               Total amount owed to you
     •  Cash due this month report
               Coupon interest due, purchased interest, par due to sale, maturity ....
     •  Reconciliation report for any month, entire year
               Beginning balances, new bonds, amortization activity, ending balances
     •  Gains and losses on sales, early calls
     •  OID (original issue discount) amortization for applicable bonds
     •  Audit and exams
          Month-by-month lifetime bond recognition schedules
     •  $ Dollar weighted portfolio rates
     •  FASB, GAAP compliant
   





Reports
     •  Import screen with ability to change reporting dates and periods (any month, several months, entire year ....)
     •  Lifetime month-by-month recognition schedule for any bond
     •  Subsidiary listing - discounts and premiums by category
     •  Coupon interest status report - total earned for all bonds
     •  Cash due this month: Interest, maturing par, sales ....
     •  CPA auditor "work paper" annual reconciliation report
     •  Portfolio cost basis, book value "as of" any DAY
     •  View reports
     •  Print reports.
     •  Export to Excel, distribute to others
     •  Export to Adobe
   





Software and Price
     •  Software and bond files reside on your computer
     •  Operates on Windows 7, 8, 8.1, NT and Win 10
     •  Single user PC or
     •  Multiple user, network sharing device
     •  Software support is available but not required
  





General Ledger Module
     •  Trial Balance subsidiary listing report - par, book value, premium and discount balances within each account
     •  Journal Voucher with debit, credit posting columns
     •  Accrued interest calculations and reports
     •  Auditor worksheet - Reconciliation Report for any month or entire year:
     •  Balance Sheet:  Beginning balances, new additions, reductions, recognition, ending balances
     •  P&L:  Interest, premium expense, discount income, gain/loss on sales, net income for the period
     •  Each bond plus File Totals Recap
   




Records retention
     •  No need to save reports or schedules on paper
     •  Hard copy retention can be eliminated
     •  Whenever a report is needed for any prior month, year or other period:
              1)  Import the applicable Excel file containing your bond portfolio at that time
                    Many clients "save as" and create a new file each year, and then delete matured and sold bonds from the new file.
              2)  Set the software dropdown calendar date to the desired reporting month, year
              3)  Run reports and schedules
  





Daily cost basis, book value
     •  Current portfolio value
     •  Comparison of Cost Basis/Book Values to Market quotes as of a given day
               Enter market quotes or
               Retrieve using Excel's RTD function to obtain quotes from an on-line source
     •  Gain or loss if sold column
     •  Each bond
     •  Portfolio totals
     •  Daily Cost Basis/Book Value listing for any date
     •  EOM Mark to Market reporting
 




 Accounting services firm?  Financial advisor?
Do you prepare amortization reports for another party?
     •  Import client bond file to the software
                    File can be maintained by you or
                    File can be maintained by client and emailed to you
     •  Generate monthly, yearly bond amortization and other reports
     •  Export results to Excel
     •  Email to clients
 






                                Supports both
  •  Cost Basis (typically individuals):
         Sale of a bond retains unamortized premium, discount
  •  Book Value (typically business):
         Sale of a bond recognizes unamortized premium, discount
 

                                      Excel
 An Excel file and worksheet template come with the software.
  •  Maintain bonds in 1 worksheet or multiple worksheets
  •  Segregate, aggregate, Group bonds by/for any purpose
  •  Import 1 worksheet, some or all worksheets at the same time
  •  Browse, open a file, select worksheet(s) from a list


                                    Clients?
 Using Excel allows bonds and reports to be shared between:
  •  Client and CPA accounting firm via email
  •  Financial advisors - calculate a portfolio in a few seconds
  •  Service providers:
          Import client bonds from Excel
          Export reports and schedules to Excel with a single click
 
 
                                   Software Reports
     •  Import screen, above (copy/paste bonds or browse/open file)
     •  Lifetime month-by-month recognition schedule for any bond
     •  Subsidiary listing - discounts and premiums by category
     •  Coupon interest status report - total earned for all bonds
     •  Cash due this month: Interest, maturing par, sales ....
     •  CPA auditor "work paper" annual reconciliation report
     •  Portfolio cost basis, book value "as of" any DAY
     •  View reports.  Print reports.
     •  Export reports to Excel and Adobe for distribution to others

                                  Versions
  •  Effective interest method, level yield, constant yield
  •  Straight line method

                           General ledger module
     •  Accrued interest report - this month plus total accrued
     •  Accrued interest reversals in "cash due" month
               Reversals eliminate receivable penny problems
     •  Journal vouchers - debit, credit column recaps
     •  General ledger posting files
     •  Mark to market report

 







Price
Effective Interest Method, level yield
     Click to open and view Price page
     and download a free demo right now

Straight Line Method
     Click to open and view Price page
     and download a free demo right now


Bond file calculation services
We can calculate a bond file on a one-time basis.
Premium and discount amortization for a month.
     For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
For more information, Email  Bond file calculation services


Questions?
Don't see what you need?
1-800-245-8444
or email Support@fdssi.com

Other pages of interest ....
FASB 91 products page
Omnibus - Loan, bond packages FASB amortization
Loan origination fees 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


 


 
  Discount and premium effective interest method amortization
 software for Windows® PC, laptop, workstation and network sharing by
© 1995 - 2019 Financial Data Support Systems, Inc.
Home page        |        About us       |        Contact us       |        Site map

Top