FASB 91 Indirect Lending Dealer Fees Amortization Software  

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
   FASB 91 Dealer Fees Amortization
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





























FASB 91 effective interest rates

Monthly income and expense

Totals for both

Fee amortization audit schedules

General ledger subsidiary listing

Journal voucher

Upload posting file



































































FASB, GAAP compliance for
hundreds, thousands of loans
at the same time.





Operates on a PC or shared network




Custom services available




1-800-245-8444
     FASB 91 software.
     File calculation services.
     Custom coding.
 

FASB 91 amortization software for indirect lending dealer fees in a loan file

Amortize fees for dozens, hundreds, thousands of loans at the same time.
     Effective interest rate calculations.  Up to 4 income and expense fees per loan with "net" total for each loan.
     General ledger account numbers, subsidiary ledger and postings for each account.
     Monthly income and expense deferral recognition, P&L, balance sheet totals.
     Lifetime month-by-month audit amortization schedules for each fee.
     Amortize deferred fees from original loan dates.  Or preserve existing deferral balances (eliminate any adjusting entries).


Originated and Purchased loans   (at the package level)
     Originated loans extracted from a servicing system or Excel file
     and
     Monthly remittances for Purchased loans serviced by others
     (Fee information can be maintained in Excel.  The software will "match" fees with remittances.)


Highlights page with
Images
Price page
Free demo

Hard to
find
accounting
solutions


New!
Just need FASB 91 results for a one-time basis?
We'll provide you with the software.
     Run it on a PC or shared network for forty-five (45) days.
Import one or more loan files to the software.
Calculate:
     Effective interest rates
     Deferred fee balances for up to 4 income and expense deferrals per loan
     NPV - Net Present Values
     Totals of each for the entire file
For more information and pricing call 1-800-245-8444 or email  Support@fdssi.com










FASB 91 indirect lending accounting software for hundreds, thousands of loans
     •  Effective Interest Rate Calculation for all loans at the same time
     •  Up to 4 unique income/expense items per loan
     •  Amortize Income and Expense for any month
     •  Amortize using:
               Original principal balances, rates, fee amounts and dates or
               Current principal balances, rates and fee balances
     •  Deferred fee income and expense general ledger Balances
     •  Accumulated and Book Values
     •  Monthly Recognition and Totals
     •  Yearly recap (calendar or fiscal) Recognition and Totals including prior year(s) restatements
     •  Changes during term:
               Effective interest rate recalculation due to rate changes
               Accelerated (additional) recognition of deferral for paydowns, curtailments, payoffs
               Full recognition of deferral balance for early payoff
     •  Audit and exams:
               Month-by-month lifetime loan fee detail recognition schedules
     •  Reports:
               View on screen
               Send to local or network printer
               Send to Adobe pdf
               Send to Excel 



Supports all of these fee recognition methods at the loan level:
  •  FASB 91 income, expense amortization over
          Actual loan terms
          Balloon terms - Interest only, P&I based on longer term, fixed principal reductions
          Average portfolio life
          Fee amortization periods reduced for other reasons
  •  Straight line for non-FASB applicable
  •  CPR - conditional prepayment rate, declining balance percentage
  •  Other user defined methods
 






















































FASB 91 loan fee recognition software is available in a configuration to meet your needs ....


1)  Loans are on a servicing system.
      Loan fees are on the servicing system.

          Create an extract file from the servicing system each month containing loans and fees.
          Automatically import loans and up to 4 income and expense fees for each loan to the software.


2)  Loans are on a servicing system or serviced by others.
      Loan fees are not included with loan information
.
          Create an extract file from the servicing system each month containing loans.
          Place loan numbers and up to 4 income and expense fees in an Excel template that comes with the software.
                    The Excel fees file can also contain debit and credit general ledger account numbers for each fee.
          Automatically import loans and the Excel fees file to the software which "matches"  loans and fees.
          More than 4 fees per loan?  The software can handle that, too.


3)  Loans are on a servicing system or serviced by others.
      Some fees are included with loan information, some fees are not.

          Create an extract file from the servicing system each month containing loans and whatever fees are on the servicing system.
          (if your loan servicing system handles FASB 91 amortization for some or all of its fees, exclude them from the extract file)
          Place loan numbers and additional income and expense fees in an Excel template that comes with the software.
          Automatically import loans and the Excel fees file to the software which "matches"  loans and additional fees.
 

4)  Loans are not on a servicing system.
          Place loans and fees into a different Excel template that comes with the software.
          Automatically import the Excel file with loans and up to 4 income and expense fees to the software.


5)  Special APP
          Perhaps you just need FASB 91 software to provide some kind of interactive or unattended function during loan processing or servicing.
          You generate input data.  Launch APP which reads data and returns output for your processing.  APP opens and closes without intervention.


6)  Other combinations.  Other needs.  New lending program.
    New loan type.  Software customization.

         The software is flexible with respect to processing and operational needs.
         Please contact us to discuss yours.
         1-800-245-8444 or
          email:   Support@fdssi.com





























  Prices

Click to open and view Price page


Or contact us with any questions.
1-800-245-8444
Support@fdssi.com












Amortize deferred fee income and expense for
     •  Indirect lending charges
     •  Dealer fees
     •  Fee income
     •  Points
     •  Discounts
     •  Expense
     •  Closing costs
     •  Other deferred items
     •  Secured, unsecured loans
     •  P&I amortizing
     •  Purchased discounts/premiums at the individual loan level   at the package level
     •  Interest only:
            As interest only and
            Interest with periodic 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
           Average portfolio life
     •  Constant $Amount payment, such as lease payments
     •  % reduction of remaining principal balance, such as 8.3% of this month's balance, then 8.3% of next month's balance
           Typically for loan packages using a CPR (conditional prepayment rate)
     •  Fixed rate
     •  Zero rate
     •  Variable rate
     •  360, 365, 366, 365/360
     •  FASB, GAAP compliant
     •  Customization available
  



Import and amortize loan fees from
     •  Core system, service bureau
               Download your loan file with current balances to the software each month
     •  Aires - credit union report
     •  Manually serviced loans
     •  Excel
               A preformatted worksheet comes with the software.
               Enter or copy loan data to the worksheet once and the system takes care of everything else
               or
               import the worksheet each month with current loan balances, rates, paid off loans, new loans ....
     •  Other files and sources
  



Accrual basis accounting
     •  Fee Recognition is NOT based on payment transactions
     •  Fee Recognition occurs every month regardless of whether a payment was made because
          interest income is accrued every month.
  











Available in 3 versions for PC and shared networks ....



Version 1 -  For loans with additional income and expense fees which can not be handled by a loan servicing system:
(typically for loan servicing systems that can only amortize a single fee or have no capability for dealing with FASB 91 fees)

Fees file:
     Place loan numbers, up to 4 fees per loan plus related general ledger account numbers into an Excel template that comes with the software.
     Use copy/paste.  Fill down.  Fill across.  Whatever is easiest for you.
     More than 4 fees?  The software supports multiple templates.
Download an extract file from your loan servicing system containing basic loan information.
The software will:
     Automatically import loans using file browse, open.
     Automatically import the Excel file with loan numbers and fees on its own.
     Match the Excel fees to imported loans.
     Calculate effective interest rates.
     Amortize fee income and expense for a given month.
     Prepare a complete set of accounting and general ledger posting reports.

Mix and match:  Extract file can contain some fees and the Fees file more fees.

The software will automatically adjust for changes from a prior month to the current month.  Changes such as:
     •  Different interest rate. The system will calculate a new effective interest rate and, for amortizing loans
        a new P&I payment using current balance, current rate and remaining term.
     •  Reduced principal balance other than through normal P&I amortization, such as paydown curtailments.
        The system will accelerate deferral recognition by a proportionate amount.
     •  New loans during the current month. An effective interest rate will be calculated.
     •  Paid off loans, including those with principal that went to 0.00. The system will recognize deferral balance in full.
     •  Loans which may have just "gone away". Many times, paid off loans are purged from the servicing file only at year end.



Version 2 -  For all fees and loans on a loan servicing system:
(typically for loan fees that are in the servicing system but are not being amortized under FASB 91)

Download an extract file from your loan servicing system.
The software will:
     Automatically import loans and fees using file browse, open.
     Calculate effective interest rates.
     Amortize fee income and expense for a given month.
     Prepare a complete set of accounting and general ledger posting reports.

The software will automatically adjust for changes from a prior month to the current month.  Changes such as:
     •  Different interest rate. The system will calculate a new effective interest rate and, for amortizing loans
        a new P&I payment using current balance, current rate and remaining term.
     •  Reduced principal balance other than through normal P&I amortization, such as paydown curtailments.
        The system will accelerate deferral recognition by a proportionate amount.
     •  New loans during the current month. An effective interest rate will be calculated.
     •  Paid off loans, including those with principal that went to 0.00. The system will recognize deferral balance in full.
     •  Loans which may have just "gone away". Many times, paid off loans are purged from the servicing file only at year end.




Version 3 -  For fees and even loans which are not not on a loan servicing system:
(typically for servicing systems that don't amortize fees or loans which are not on a servicing system)

A very simple way to resolve FASB 91 issues.
Place basic loan and fee information into an Excel template that comes with the software.
     Dozens of loans
     Hundreds, thousands of loans

The software will:
     Automatically import loans and fees using file browse, open.
     Calculate effective interest rates.
     Amortize fee income and expense for a given month.
     Prepare a complete set of accounting and general ledger posting reports.

Amortize 1 to 4 income, expense fees per loan.
Easily adjust loans in the Excel file due to:
     Rate changes
     Paydown curtailments
     Early payoffs













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.










Accrual Accounting
Accrual based fee recognition ties to interest income.
Not transaction based.






Allocation
Available with an option to distribute monthly income and expense for all or selected loans to multiple revenue, cost center general ledger accounts.







Original loan data or current balances
Calculate income and expense from
     •  Original payment dates forward
Or ....
     •  Preserve and amortize current balances
     •  Software will calculate remaining term and effective rate based on principal, note rate and payment
     •  No adjusting journal entries
     •  Start using FASB 91 today









About the software
  •  Written in Microsoft's .NET Framework
  •  Operates on any MS product line
  •  Install to PC or network sharing device









About our company
  •  In business since 1982
  •  Market niche is Amortization Software
  •  Added FASB 91 software in 1987
  •  On the Internet since 1995
  •  First page rankings on Google and Bing










FASB 91 amortization services
Need answers NOW?
Audit?  Due diligence?  What if question?
Income, expense projections?
Do what others have done:
  Send us a loan file   View our NDA
  Get fee recognition reports for
       Any month
       Range of months
       Any 12 month period
  More info  Support@fdssi.com  









                       CUSTOM SOFTWARE and FILE CALCULATION SERVICES


Unique situation?  Unusual records?  New type of fees?
Different file layout?  File source?
Special internal or regulatory report?

Different configurations of the software or other products we offer may already meet your needs.
If not, we can write custom code and embed your private module within the existing nuts and bolts portion of the software.



File calculation services:
We can also calculate a file and provide recognition reports on a one time or recurring basis.

For more information, 1-800-245-8444 or email Support@fdssi.com

 











  Prices

Click to open and view Price page


Or contact us with any questions.
1-800-245-8444
Support@fdssi.com



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

Top