ASC-310-20 prospective, retrospective accounting for mortgage backed securities

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 Advances
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

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

The software operates on
  •  Your PC or
  •  Your network

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


FASB 91 amortization software for
MBS, GNMA, LSBO, syndicated pool and loan packages

Operates on a PC or network sharing device at the PACKAGE level (not underlying loans level).
     Maintain all packages in an Excel template that comes with the software.
          Update the Excel file with current package balances each month.
     Automatically import the Excel file to the software.
          Amortize premiums, discount, fees for all MBS, GNMA and other records at the same time.
          Effective interest rate calculation for each package.
               General ledger account numbers, subsidiary ledger and posting files.
     Monthly income and expense deferral recognition.
     P&L, balance sheet totals.
     Lifetime month-by-month audit amortization schedules.
     Available in Prospective only or Prospective, Retrospective versions.

Price page
Free demo

Hard to

Income and expense recognition, deferral balances, book values at the Package Level.
Expense is displayed as (negative) to distinguish from income.

MBS, GNMAs, CMOs, ABMs, LSBO and other Packaged Loans plus Individual Loans
GAAP, FASB Accounting Amortization Software for a file with multiple records

Complete accounting and reporting for dozens, hundreds, thousands of records at the same time
     •  Effective interest rate calculation
               Prospective rate and Retrospective rates when anticipated balance differs from actual.
               Retrospective recalculation of income and expense using the newly calculated effective interest rates based on then-known balances.
     •  Premium amortization
     •  Discount accretion
     •  General ledger reports and monthly postings
     •  Auditing tools

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

Applicable for
     •  Purchasers
     •  Originators
     •  Seller servicers

Calculations and accounting reports for
     •  Your records
     •  Client records on behalf of CPA firms, Trust Departments, Financial Advisors ....

Calculation periods
     •  Current month, fiscal year
     •  Prior month, fiscal year(s) restatement

Current Deferral Balances
     •  The software can amortize premiums and discounts from original dates.
     •  Or, if you have been amortizing premiums and discounts using another procedure,
         the software can preserve your current deferral balances and amortize them forward.

Repayment methods 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)

     •  Balloon, average life periods:
               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

General ledger subsidiary account listing

Debits and Credits

Income and expense recognition for an entire year in a matter of seconds

Available for
     FASB 91 Prospective only or
     FASB 91 Prospective, Retrospective under ASC-310-20

1)  Prospective recognition
     Rate changes and balance paydown curtailments DO NOT re-amortize deferrals from begin date.
     If interest rate changes, calculate a new payment and effective interest rate for balance of term.
     If paydown curtailment, immediately recognize a percentage of the deferral calculated as curtailment/principal balance.
     Ex:  Principal balance = $80,000.00.  Paydown curtailment = $15,000.00.  Percentage = 15,000/80,000 = 18.75%.
            Deferral balance = $900.00.  Software will immediately recognize 18.75% of the $900.00 and take an additional $168.75 to income or expense in that month.

2)  Prospective and Retrospective recognition
     We also offer FASB 91 Prospective, Retrospective software where rate changes and paydown curtailments DO re-amortize deferrals from begin date.
     If interest rate changes, calculate new payment.  Calculate new effective interest rate from begin date for entire term using new cash flow due to P&I change for balance of term.
               Also calculate a Blended Rate and monthly interest at the Blended Rate for determining the new effective interest rate.
     If paydown curtailment or other principal anomalies, calculate a new effective interest rate rate from begin date for entire term using new cash flow.
     Re-amortize a deferral from the begin date through remainder of term utilizing newly calculated effective interest rate.
     Calculate an adjustment and include (+/-) in current month posting amount.

  Price page and free demo  ....

Price page and free demo
Click to open and view Price page
Request a free demo from the price page.
       •  Nothing to install
       •  Create a temporary folder
       •  Unzip a file
       •  Run the program
       •  Delete folder when done

For more information, please contact us.

Call 1-800-245-8444 or email



FASB 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