Bond Issue costs amortization software  

Financial Data Support Systems, Inc. 
Amortization Software Products
Loan Files: FASB Effective interest method
Loan Packages: Effective interest method
Corporate Debt  Issue GAAP amortization
Merchant Cash Advances
FASB 91: All products
Bond  Purchasers: Effective Interest Method
  Bond Issuers: GAAP software
Prepaid Expenses, Deferred Charges    
Deferred Income, Unearned Revenue
Fixed Assets, FF&E Depreciation    
Home page
About, contact us






GAAP compliant
 

Bond accounting software for Bond, other Debt Issuers 
GAAP effective interest method, level yield
     With ability to utilize GAAP or Straight Line method at the file, debt record or individual cost, premium, discount level
     •   Corporate Debt Issuers page 

On demand monthly reporting for bonds, debentures, other debt instruments requiring:
     Premium income amortization
     Discount expense accretion
     Issue costs amortization as actual, estimated, subsequent month adjustments
     Debt interest expense accruals
     Annual and projection totals, including cash flow, from any month through 1 to 60 months.



Partial calls/redemptions/repayments, refinances and/or rate changes:
The software calculates:
     Interest at the coupon rate.
     Interest at the effective interest rate.
     Interest at a constant rate:
          Constant rate is a single rate that will produce the same total amount of interest as the coupon rate.
     Premium, discount recognition is the difference between constant rate interest and effective rate interest.






Hard to find
GAAP
Amortization
Software to run on a
PC,
Network sharing or
Cloud based system
supporting
Windows 7, 10, 11




Scroll down for
     Highlights
     Images
     Price page
     Free demo zip file


 













































































































































REPORTS LISTING


1) Monthly Posting: Costs, Premiums, Discounts Amortization Report. Followed with Journal Voucher then General Ledger Posting file.
Column A codes C & N: Costs plus Premium amortization and discount accretion recognized for the selected calendar calculation month. Records will be sorted by the values in spreadsheet column "H P&L Accounts" within "column I Offset Account". Totals will be provided for each account.
A Journal Voucher and General Ledger posting file will also be created.
This report can also provide Costs, Premium and Discount totals by general ledger accounts at any time.
(after the report is produced, click "Escape" to cancel Journal Voucher processing).


2) Monthly Posting: Accrued Interest Report. Followed with Journal Voucher then General Ledger Posting file.
Column A code D: Requires values in Debt columns J Payment Due Date and K Payment Frequency.
The system determines the amount of Debt interest to accrue for the selected dropdown Calendar month. Also provides "Total Accrued" for balancing to payable accounts.
Records will be sorted by the Debt record values in column L Interest Accrual P&L Account and column M Interest Accrual Offset Account. 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 dropdown Calendar month. Records which have finalized in or prior to the Calendar month will be excluded.
The Accrued Interest report and Accrued Interest Reversal report (below) eliminate the need to reconcile Interest Payable accounts each month. Simply post cash interest payments to an expense account. The system will "undo" previous accruals in an Interest payment month.


3) Monthly Posting: Accrued Interest Reversal Report. Followed with Journal Voucher then General Ledger Posting file.
Column A code D: Requires values in Debt columns J Payment Due Date and K Payment Frequency.
The system determines the amount of accrued interest to reverse for records with an Interest Payment date during the selected dropdown Calendar month.
Subtotals are provided based on values in spreadsheet column T.
Reversal amounts consist of accrued interest previously posted by the system for ALL prior months (since the prior Interest payment month).
The system calculates running accrual for Debt through the preceding month to determine the amount to reverse (do not delete a Debt record from the spreadsheet until after running this report).
Records will be sorted by the Debt record values in spreadsheet column L Interest Accrual P&L Account and column M Interest Accrual Offset Account. Totals will be provided for each account. A Journal Voucher and General Ledger posting file will also be created.
The report consists of Debt records with a Begin Date equal to or earlier than the calendar month. Records which have finalized, such as matured, in months PRIOR to the calendar month will be excluded.


4) Debt Balancing Report. Book Value and NPV Balances. Subtotals by Debt column H account OR "N" records Offset account column I.
Codes D and N: Subtotals within Debt column H general ledger account or "N" code Premium and Discount records column I.
Original and current balances for Debt, Premium and Discount balances and NPV Book Values.
This report is typically used to balance Book Values when Premiums and Discounts are involved.
Set dropdown Calendar date to any month. Set Months to Calculate to a value of 1 through 60 months to obtain future projection results.


5) Summary Report: Debt with Costs.
Column A codes D and C: Original and current balances for Debt plus all Costs. Subtotals for each Debt record.
Option to run as "Cost Totals only" which combines Costs on a single line for each Debt record.
If Costs exist, separate rows for Debt and total Costs amounts will be provided.
Note: Code N Premium and Discount records are excluded from this report.
Set dropdown Calendar date to any month. Set Months to Calculate to a value of 1 through 60 months to obtain future projection results.


6) Summary Report: Debt with Costs, Discounts, Premiums, Net Proceeds.
Column A codes D, N and C: Original and current balances for Debt, premiums, discount and all Costs. Subtotals for each Debt record.
If Costs, Premiums or Discounts exist, separate rows for Debt and those total amounts will be provided.
If Premiums or Discounts involved, also provides Costs related to Net Proceeds (cash received).
Set dropdown Calendar date to any month. Set Months to Calculate to a value of 1 through 60 months to obtain future projection results.


7) Cash Outflow Projection Report: Interest payments plus Debt reductions for the reporting period.
Cash Outflow Projection for interest payable, interim Debt and maturing reductions and remaining Debt balance at end period.
Set dropdown Calendar month to Beginning month. Set "Number of Months" to calculate from 1 to 60 months.
Records having a zero Debt balance at beginning of period will be excluded.


8) Matured Records Report showing Debt record balances that dropped to zero during the reporting period.
Debt records which matured or otherwise paid off during the reporting period.
Similar to "Cash Outflow Projection report" but includes only records where Debt dropped to zero within the period.


9) Interest Payable Report for Debt records having an interest payment due this month.
Debt records having an interest payment this month.
Similar to "Accrued Interest Report" but includes only records having an interest payment due.
There are no general ledger postings involved.





Options for existing records

Option 1
         The software can calculate records using original information.
         Amortize costs, premiums and discounts from original dates.
         Book any variances from software results to your existing balances.

Option 2
          Preserve current balances.         
          Begin amortizing from an "as of" date using current balances.












  View on line documentation for D,C,N,P,R,A codes, SubGroups and Groups









Price and free demo - download a zip file at any time

Click to open and view Price page
     Free demo  Price page contains a link to
     download a zip file containing the software and sample records.



Bond file calculation services
We can calculate a file on a one-time basis.
Costs, 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  File calculation services


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

 

  Debt issuance GAAP amortization
 Software for Windows® on a computer, laptop, shared network and cloud based systems
© 1995 - 2024 Financial Data Support Systems, Inc.
Home page        |        About us       |        Contact us       |        Site map

Top