MBS Accounting Software: FASB 91 accounting for mortgage backed securities

                    SOFTWARE  PRODUCTS 
Financial Data Support Systems, Inc.
  Home page
  About, contact us
  FASB 91 - all products
  LOAN FILES - FASB 91 deferred fees income and expense amortization
  OMNIBUS - MBS, GNMA, LSBO, loan packages premiums, discount amortization
  BOND ISSUER ACCOUNTING SOFTWARE - premiums, discounts, issuance costs
  BOND PURCHASER ACCOUNTING SOFTWARE - effective interest method
  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
  DEALER FEES - FASB 91 software for indirect lending charges

FASB 91 File Amortization Software
     Effective Interest Method, Constant Yield
     Accounting for MBS Premiums and Discounts
     FASB, GAAP Compliant

•  Current period calculations and reporting
•  Prior period restatement
•  Calendar and fiscal years
•  Monthly and annual totals

Premium and discount recognition for dozens, hundreds, thousands of
     •  MBS bonds
     •  GNMAs, CMOs, other syndicated loans, pools
     •  LSBO
               Whole loan packages
     •  Other packaged loans
     •  Non-conforming individual loans
     •  Structured, multiple fundings
     •  Staggered pool deliveries
     •  Also amortize:
               Corporate bonds
               Other bonds, virtually any premium and discount instruments
     •  Current month or
     •  Restatement of prior months

Applicable for:
     •  Purchasers
     •  Originators
     •  Seller servicers

Available as:
     •  Purchase or
     •  Special project, short term use

     •  Effective interest rate calculation at the package level 
     •  Premium amortization
     •  Discount accretion
     •  Premium and discount recognition attributed to
             par/principal repayment reductions
     •  Par and Book Value calculations
     •  Rate changes
     •  Recalculation of effective interest rate
     •  Subsidiary ledger listing with general ledger subtotals
     •  General ledger posting totals
     •  Accounting and administrative reports
     •  CPR (Conditional Prepayment Rate) projection at any rate for 1 to 120 months

Changes during the premium, discount amortization term ....

Reductions to Par
     •  Easily record monthly remittances for multiple records.
     •  Reduce Par for a single record due to any receipt or partial sale.

Changes to earnings Rate
     •  Change an interest rate at any time.

Increases to Par
     •  Increase Par due to multiple take-outs, additional funding.
     •  Include any additional fee associated with the increase.

When any of the above occur, the system will ....

     •  Calculate a new effective interest rate

     •  For a reduction to par,
                the system will recognize proportionate premium or discount balance
                and adjust Par and Book Value accordingly.

     •  For an increase to par without an additional fee,
               the system will adjust Par and Book Value accordingly.

     •  For an increase to par with an additional fee,
               the system will increase the current premium or discount balance
               and adjust Par and Book Value accordingly.

     •  All changes will be reflected in a detail audit amortization schedule.

Early payoff, outright sale

     •  The system will recognize remaining discount or premium in full.

Excel interface:

  •  Import records from Excel

  •  Export records, reports to Excel


     •  Open and view Price page
               PC and network sharing prices.
               Download a free demo from the Price page, too.

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

Calculate for:
     •  Current month, fiscal year
     •  Prior month, fiscal year(s) restatement

  Related Products ....
  LOAN FILES - FASB 91 deferred fees income and expense amortization at the individual mortgage level
  DEALER FEES - FASB 91 software for indirect lending charges at the individual loan level


                                SOFTWARE LICENSES

The software is available under two licensing arrangements.

Permanent license:
Purchase the software and use on your PC or network sharing device just as you would buy and use other software.

Short Term license:
Many of our clients are CPA and Financial Advisory firms.
Some obtained a Short Term license to reduce the cost involved of handling a special project or need by a specific client.
     •  Includes all features of the Permanent license
     •  Organize, automate client records
     •  Transfer data and reports via email with Excel attachments
     •  Recalculate prior years under FASB 91
     •  Restate balance sheet and P&L
     •  Migrate client records from straight line to FASB 91
     •  Other services required by a client on a short term basis
     •  Provide on-going or periodically required client reports

                      ACTUAL LIFE vs. AVERAGE LIFE

The software featured on this page amortizes premiums and discounts using an effective interest rate calculated over the Actual Life of the instruments from a Beginning date to Maturity date, accounting for reductions to Par/Principal as they are received.

We also offer a separate module that can be included which will amortize premiums and discounts over a shorter period of time (typically a derived Average Life) irrespective of actual cash flow.  Premium and discount recognition is a function of the effective interest rate calculated for each.
Par/principal can be amortized as:

1)  % reduction, such as reduce par/principal each month by 8.5% of the previous month's par/principal balance.

2)  Constant par/principal reduction amount, such as reduce par/principal each month by $25,000.00.

3)  P&I, calculated as a monthly level repayment stream as would occur for a monthly amortizing instrument.


  Calculate recognition for multiple months.  Recap fiscal years, past and present.


                                     EVALUATE THE SOFTWARE AT NO CHARGE

Free demo:
Scroll down to the Price and Free Demo page link.


Free sample reports with your records:
Send a few of your MBS bonds in an Excel file.
     •  Nothing proprietary.
     •  Label your bonds as MBS A, MBS B and so on.
We will:
     •  Import your records to the software.
     •  Generate a set of reports.
     •  Return all reports in separate worksheets in an Excel file.

Please call 1-800-245-8444 for more information or
email Free sample reports for my MBS records
(please include your first name in the body of the email)


  CPR and P&I Projections

Options for existing fee, premium and discount balances

Option 1
        Preserve your existing book values.
        No restatement or adjusting journal entries necessary.
        The software can begin amortizing current fee, premium and discount balances.

Option 2
         Calculate prior and current book values.
         The software can amortize premiums and discounts from original dates using original information.

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

                                          EVALUATE THE SOFTWARE AT NO CHARGE

Price page and free demo
Purchase the software or
Request the price of a Short Term License
          Ideal for special projects, client servicing and other temporary needs
Click to open and view Price page
     The price page also contains information on obtaining a free demo.



     •  Fee amortization,
     •  Premium amortization and
     •  Discount accretion software for
MBS, LSBO and other purchased and packaged loans
FASB 91 mortgage, consumer, dealer fee loans page
Bonds, FASB 91 effective interest method page


 FASB 91 effective interest method recognition software for

     •  MBS bonds, mortgage backed securities

     •  ABM asset backed mortgages

     •  Packaged loans

     •  LSBO
               Participations and
               Whole loans

     •  CMOs  collateralized mortgage obligations

     •  Syndicated loan pools

     •  Non-conforming loans

     •  Distressed, substandard assets

     •  Unusual loans, heavily discounted sales and more


We just went through this year's annual audit using your software.
For the first time ever, our outside auditors gave us a clean report.
Not a single footnote to our financials!
Thank you,
                             New York

We used to spend days at the end of each month recalculating effective
interest rates due to rate changes coupled with principal paydown reductions.
Your software does that for us now.  And a lot more.  All in a matter of seconds.
                           New Mexico

I had to calculate a client's MBS portfolio going back 7 years and have no
idea how it could have been done so quickly without using your software.

FASB 91 compliance software that imports all
packages from an Excel file with:
     •  Package numbers, seller name, code, other identifier
     •  Begin/settlement date/purchase date
     •  Maturity date
     •  Par, principal amount
     •  Coupon/earnings/package rate
     •  Price, premium, discount, other fee adjustment to par

Create the file once.
Update monthly with current balances or reductions.

Recognize dozens, hundreds, thousands of
income and expense deferrals
     •  Monthly recognition and reporting in a matter of seconds

Start amortizing "when" you want
     •  Start "as of" now
               Preserve your existing premium, discount, deferred fee general ledger balances
               No adjusting journal entries
     •  Start "as of" a prior month, prior year
               Recalculate income, expense and deferral balances from a prior period forward

The software will

•  Calculate effective interest rates

•  Amortize premiums, discounts, other deferred fee income and expense under FASB 91

•  Amortize all records at the same time

•  Provide detail amortization schedules for auditor, examiner queries

•  Generate file totals
          Total fee income
          Total fee expense
          Net:  Income minus Expense

•  Furnish general ledger posting and subsidiary account balancing

Need FASB 91 calculations NOW?

Don't have time to evaluate software?
But need fee amortization and reports?
     •  Income
     •  Expense
     •  Book values
     •  Totals
     •  For a month
     •  For an entire year
     •  Audit, regulatory support schedules
View our
STSL - Short Term Software License page

Easy to operate

•  Set up your records once

•  On a monthly basis, update with either
          Current package balances or
          Reductions to par/principal for the month

•  That's all there is to it

Automatic adjustments for 

•  Reductions and remittances in fluctuating amounts

•  Irregular, staggered paydowns, reductions to par, principal

•  Early payoffs

•  Sales, full or partial

•  Rate changes

A proven system for small and large files

•  Evaluate the software with your records at no charge

•  Qualified assistance regarding unusual requirements

•  Software customization for unique needs

•  FASB, GAAP compliance without spending a fortune

Complete monthly fee accounting and reporting

•  All monthly financial and accounting reports

•  Subsidiary ledger listing with subtotals by general ledger account
          P&L totals
          Balance sheet totals

•  Debit and credit column journal voucher

•  General ledger posting file

•  Cash flow projections and other managerial, audit reporting

•  View reports

•  Send to local or network printer

•  Export schedules and reports to Excel

Your existing records:

•  Convert and preserve recognition, accumulated and book values in order to maintain general ledger status.

•  Or, the software can recalculate records from their begin dates employing the effective interest method.



Price page and free demo  ....

Click the link to open and view price page
     Evaluate the software with some of your records at no charge.

Price page
Purchase the software or
Request the price of a Short Term License
          Ideal for special projects, client servicing and other temporary needs

 Account for

  •  Loan packages - secondary market
          Fixed rate
          Variable rate
          Amortize over
               Actual life
               Estimated, average life

•  Bonds - corporate, government, other premium and discount instruments
          Variable rates, floating rates
          Unusual terms or conditions
          Reductions to par due to partial sale, other reasons
          Bonds without rate change or paydowns, too
  •  Syndicated loans, bulk loans, pools ....

  •  Mortgage backed securities

  •  Purchased loans

  •  LSBO
          Participation and whole Loans Serviced By Others

  •  Participation loans sold

  •  Discounted cash advances

  •  Originated loan groups
          Grouped by month of origination or other criteria
          Weighted average rates, terms, fees (as discount or premium)

  •  Hybrid loans
          Fee income and expense are treated as discounts and premiums
          as an adjustments to par, principal, face value such as merchant loans, other advances

  •  Other assets or liabilities with
          Premium, discount, fee income, expense, cost, charges ....
          Periodic, irregular reduction in value
          Coupon rate, interest rate, earnings rate or rate of zero
          Variable rate changes
          Maturity date or a Term in months
          Par, principal paydown reductions, curtailments
          Partial sales

The software will

 •  Calculate FASB 91 effective interest rates
          Calculate for initial values
•  Recalculate effective interest rate due to a paydown reduction, rate or other changes

  •  Determine monthly recognition of

  •  Journal voucher preparation with offsets to balance sheet accounts

  •  Report general ledger balances for
          Par/principal balance
          Premium deferral balance
          Discount deferral balance
          Carrying amount /book value

  •  Accelerate deferral recognition due to paydown/partial sale

  •  Prepare a complete set of accounting reports
          View on screen
          Send to printer
          Export schedules and reports to Excel
          Upload file with general ledger debits and credits
          Direct post or allocate to revenue and cost centers
          Supports calendar and fiscal year periods

  •  Produce a detailed recognition schedule for each record
          Normal month to month premium, discount amortization recognition
          Accelerated discount, premium recognition for principal paydown, curtailment, partial sale, payback reductions

  •  GAAP, FASB compliant
          Generate, export audit and examination reports

Excel Template
The software comes with an Excel worksheet template.
     -  Maintain records in the worksheet
     -  Update with monthly or other frequency changes
     -  Make copies of the worksheet to maintain multiple, segregated files
At any time, automatically import the worksheet.
The software:
     -  Determines premium or discount amount
     -  Calculates and recalculates FASB 91 effective interest rates
     -  Based on selected dropdown calendar month, provides:
               •  Monthly premium or discount recognition for each record
                     -  Normal recognition plus
                     -  Accelerated recognition due to paydown reductions
                     -  A detail schedule for each record provides exact breakdown and how calculated
               •  Accumulated recognition
               •  Deferred premium or discount balance
               •  Book value carrying balance
               •  Detail recognition schedule
          Summary totals of the above by category:
               •  Premium totals
               •  Discount totals
               •  All accounting reports
               •  General ledger postings and upload file using any chart of accounts
     -  View reports.  Print reports.  Export to Excel.

More about accounting and reporting ....

•  Maintain records in
     -  A single worksheet
     -  Multiple worksheets to segregate records
     -  Also applicable for records where par is not subject to reduction - mix or segregate

Import dozens, hundreds, thousands of records with:
     •  Cusip or your assigned IDentifier
     •  Par, principal balance
     •  Purchase/settlement/begin date
     •  Maturity date
     •  Coupon/interest/nominal rate
     •  Price (Par +premium or -discount) = initial carrying balance
          As $Dollar amount or %Percent
          Premium, discount can be loan fee expense, fee income
          Software establishes premium/discount amount
     •  Conversion balances, if desired
     •  Supports calendar and fiscal year
     •  Maintain records in one Excel worksheet or segregated files

Premium, discount, fee income and expense recognition
•  FASB 91 effective interest rate calculation
  •  Premium, fee amortization to income or expense
  •  Discount, fee accretion to income or expense
  •  Accelerated premium, discount, fee recognition for par/principal reduction

Automatic effective interest rate recalculation when ....
  •  Coupon/note rate changes
  •  Reductions to par/principal due to
          Remittance paydown reductions - regular and unscheduled
          Partial sale, assignment
          Accelerated premium and discount recognition to recognize reductions
  •  Increases to par/principal


Click to open  Price page
Purchase the software or
Request the price of a Short Term License
       Ideal for special projects, client servicing and other temporary needs

Just gathering information?
Our customer support department would be glad to answer your questions.
Call 1-800-245-8444 or email Support@fdssi.com
Other pages of interest ....
FASB 91 products page
Loan origination fees FASB 91 amortization
Bond accounting 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 discount and premium effective interest method amortization
 software for Windows® PC, laptop, workstation and network sharing by
© 1995 - 2017 Financial Data Support Systems, Inc.
Home page        |        About us       |        Contact us       |        Site map