Import a file to an Excel worksheet

                    SOFTWARE  PRODUCTS 
Financial Data Support Systems, Inc.
   Accounting
       Amortization
           Software
 
  Home page
  About, contact us
  FASB 91 - all products

  LOAN FILES - deferred fees income and expense amortization
  MBS, GNMA, LSBO, LOAN PACKAGES - FASB premiums, discounts amortization
  PROSPECTIVE, RETROSPECTIVE amortization software for ASC-310-20
  BOND PURCHASERS - effective interest method for premiums and discounts
  BOND PURCHASERS - straight line method for premiums and discounts
 
  PREPAID EXPENSES - monthly amortization and reporting
  DEFERRED INCOME - monthly amortization and reporting
  FIXED ASSETS, FF&E - monthly depreciation and reporting
  NON-MONTHLY - daily, days, weeks, other periods amortization and reporting
  EXCEL - worksheet import monthly amortization and reporting
  l

   Calculate income and (expense) from Begin dates forward.  Or preserve and amortize current balances.  For any month.  An entire year.
 



Related products ....
MBS purchased loans






The software operates on
  •  Your PC or
  •  Your network



Maintain records in:
  •  Your file or
  •  An Excel template we provide



Import entire file to the software
  •  Run reports
  •  View, print, export reports



Free demo
  •  Nothing to install
  •  Create a temporary folder
  •  Unzip a file
  •  Run the program
  •  Delete folder when done
FASB, GAAP amortization software
Prospective, Retrospective accounting for a file with multiple records

ASC-310-20 effective interest method amortization which adjusts net investment when actual prepayment activity is different
from anticipated prepayment activity.  Cash flow effective rate adjustments are compared to prior general ledger postings and
reflected in current month as
     •  P&L debit or credit with offset to
     •  Balance Sheet book value, carrying balance, cost basis


Browse, import a file, run monthly reports
Scroll down for
     •  Highlights
     •  Price
     •  Free demo


Complete accounting and reporting for dozens, hundreds, thousands of records at the same time
     •  Effective interest rate calculations
     •  Premium amortization
     •  Discount accretion
     •  Deferred income and expense
     •  Amortize and account for 1 to 4 unique deferrals per record
     •  General ledger reports and monthly postings
     •  Automatically adjusts net investment when actual prepayment activity is different from anticipated
         prepayment activity using Prospective and Retrospective recognition
     •  Auditing tools



An ideal solution for
     •  MBS portfolio
     •  GNMAs, CMOs, other syndicated loans, pools
     •  LSBO
               Participations
               Whole loan packages
     •  Other packaged loans
     •  Non-conforming individual loans
     •  Commercial and other loans
     •  Other premium and discount investments with structured or fluctuating payback



Anticipated Repayment Activity can be established as
     •  P&I amortizing
               P&I assigned by you or
               P&I calculated by the system to establish a forecasted cash flow
                    Typically for MBS and other unknown repayment schedules
               P&I, at your option, can also be recalculated by the software with each cash flow adjustment
     •  Interest only:
               As interest only and with
               Principal payments of a constant amount (e.g., $25,000 every three months)
     •  Balloons:
               Interest only with a balloon
               P&I over balloon period
               P&I over longer term such as 5 year balloon with 30 year P&I
               P&I over average portfolio life
     •  CPR - Conditional Prepayment Rate
                % reduction of remaining principal balance, such as 8.3% of this month's balance, then 8.3% of next month's balance
                CPR is typically excluded from Prospective, Retrospective calculations because "repayment" is not cash activity
  





 



















































 











Generate:
     •  Effective interest rates
     •  General ledger, journal voucher, monthly upload posting files
     •  Allocate income, expense to multiple cost, revenue centers
     •  Subsidiary account balance reporting
     •  Lifetime recognition audit schedules
     •  Prior period calculations
     •  Future income, expense projections


Custom coding and services available:
     •  Custom reports
     •  One-time file calculation services
     •  Recognize current and prior periods
     •  Forecast future period recognition
 









Existing records and deferral balances:

Option 1
        Preserve your existing book values.
        No adjusting journal entries.
        The software can begin amortizing deferred fee income and expense balances using current information.


Option 2
         Calculate prior and current book values.
         The software can amortize deferred fee income and expense from original dates using original data.


Option 3
          Begin amortizing from an "as of" date.
         Typically the beginning of a calendar or fiscal year using prior EOY balances. 
 









                                PRICE PAGE AND FREE DEMO



Price page and free demo
Click to open and view Price page
     You can also download a free demo from the price page.



For more information, please contact us.

Call 1-800-245-8444 or email Support@fdssi.com

 


 
 
 
Software for Windows® PC, laptop, workstation and network sharing
© 1995 - 2018 Financial Data Support Systems, Inc.
Home page       |        About us       |        Contact us       |        Site map

Top
d