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
























































































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, other fees your servicing system can't manage



Operates on a PC or network sharing device.
     Import and amortize fees for dozens, hundreds, thousands of loans at the same time.
     Effective interest rate calculations for 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.


Fixed rate, variable rate loans
     P&I loans
     Interest only
     Balloons with payment covering balloon term or longer period, such as 360 month P&I and 10 year balloon
     Constant principal amount payment such as $25,000 every quarter
     CPR - Conditional Prepayment Rate using declining balance %
     Straight line for non-FASB applicable loans
     Other user defined fee recognition methods

Hard to
find
accounting
solutions



















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













Income and expense recognition, deferral balances, book values.
Expense is displayed as (negative) in order to generate a "net" total.















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
 











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.
  











Audit and Exam schedules on demand











General ledger income, expense and deferral balances












Debit and credit postings











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










Prior periods, annual recaps, future projections










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