FASB 91 Indirect Lending Dealer Fees Amortization Software  

Financial Data Support Systems, Inc. 
Amortization Software Products
 Loan files: FASB Effective interest method
Loan Packages: Effective interest method
Merchant Cash Advances
FASB 91: All products
Bond  Purchasers: Effective Interest Method
Bond  Issuers: Effective Interest Method
Prepaid Expenses, Deferred Charges    
Deferred Income, Unearned Revenue
Fixed Assets, FF&E Depreciation    
Home page
About, contact us





FASB, GAAP compliant software







 

Loan Files:  FASB 91 Effective interest method software for Dealer Fees


Deferred fee income and expense amortization, Effective Rate and NPV recalculations
at the individual loan level for a file:

     Originated loans
     Purchased Loans
     Seller Servicers
     Loan Packages:  MBS, CMO, LSBO Packaged Loans page
     Merchant Cash Advances - Originators and Investors:  GAAP, FASB for MCA Daily, Weekly Payments page


Automatically import a loan file to the software.
     Generate GAAP, FASB income and expense recognition monthly, other periods.
     Supports prepayment assumptions.

Automatic adjustments to Effective Rate, NPV for:
     Rate changes.  Additional reductions to principal which also recognizes more deferral.

Scroll down for
     Highlights
     Price page with free demo.



Hard to find
(including custom)
GAAP
Amortization
Software to run on a
PC,
Network sharing or
Cloud based system
supporting Windows














Existing loans:

 Use a Conversion file to preserve fee income and expense balances as of the conversion month:

     •  Convert at any time:
     •  Convert as of last month, end of prior fiscal year, some other month.


  No Conversion fee balances?
     •   The software can amortize fees from the loan's original date forward.


 Been using straight line or another method on a Gross monthly fees basis?
     •  The software can distribute gross deferral balances to individual loans using Dollar Weighted principal balances.

 











Pooled Loans with Prepayment Assumptions

The software can also amortize "pools" as individual loans.
Uses whatever assumption term you choose at the pool level.

Amortize discounts, premiums, income, expense over an assumed term using any of the following:
     •  P&I payment calculated by the software
     •  Constant monthly principal reduction amount
     •  Constant percentage applied to previous month par/principal balance

 






























Available in these Configurations ....


Configuration 1
Loans are on a service bureau or core system.
Originated loans.  Serviced loans.


Download/create an extract file in Excel each month.
     Existing loans can be converted as of the current date
     or a prior date.  Deferral balances can be preserved.

Deferred fee income and expense can be:
      A)  In the extract file.
      B)  In a separate Excel "Fees" file which the software will
           also import and "match" fees to loans.
      C)  As a "Gross" amount for new loans which the software
           will distribute on a dollar weighted basis to new loans.

Multiple fees per loan.
      Supports 1 to 4 different fees per loan.  

Automatically import the Excel file to the software.
     Amortize 1 deferral at a time.
     Amortize all deferrals at the same time.

Effective Interest Rates:
     Calculates Effective Interest Rates for all loans
     and each deferral.

Totals provided for:
     Original Deferrals
     Current month income and expense recognition
     Accumulated recognition
     Deferral balances
     Book Value NPV (Net Present Value)

Verify results.
     Create lifetime Deferral recognition schedule for any loan.
     Export to Excel.

ASC-310-20 recalculation of Effective Interest Rate and NPV:
     The software maintains a History file for prior months,
     allowing it to detect and adjust for:
     Rate changes.
     The software changes the rate, calculates a new
     payment and Effective Interest Rate
     Excess principal reductions.
          Software recognizes additional portion of deferral and
          calculates a new Effective Interest Rate and NPV.
     Payoff date or principal balance to 0.00.
          Software recognizes remaining deferral balance.

Missed, late payments:
     The software operates on an accrual basis and thus
     "makes" a payment and recognizes a deferral
     as if a payment had been made even if Principal balance
     has not changed from last month's History file balance.

Monthly accounting reports:
     General ledger subsidiary listing.
     Journal voucher posting document.
     General ledger upload posting file.
     Export to Excel, Adobe.

Note:
Some clients send us their monthly file and we return their reports in Excel. 


Configuration 2
Loans are maintained in an Excel file



Enter loans and deferred fees in an Excel file we provide.
    The software operates on an accrual basis and thus
     "makes" a payment and recognizes a deferral
     as if a payment had been made.
     Principal balances do not need to be updated each month.

Multiple fees per loan.
      Supports 1 to 4 different fees per loan.  

Automatically import the Excel file to the software.
     Amortize 1 deferral at a time.
     Amortize all deferrals at the same time.

Effective Interest Rates:
     Calculates Effective Interest Rates for all loans
     and each deferral.

Totals provided for:
     Original Deferrals
     Current month income and expense recognition
     Accumulated recognition
     Deferral balances
     Book Value NPV (Net Present Value)

Verify results.
     Create lifetime Deferral recognition schedule for any loan.
     Export to Excel.

ASC-310-20 recalculation of Effective Interest Rate and NPV:
     Enter changes to the Excel file when a rate changes,
     unusual reduction to Principal or Payoff.
     Rate changes.
     The software changes the rate, calculates a new
     payment and Effective Interest Rate
     Excess principal reductions.
          Software recognizes additional portion of deferral and
          calculates a new Effective Interest Rate and NPV.
     Payoff date or principal balance to 0.00.
          Software recognizes remaining deferral balance.

Missed, late payments:
     The software operates on an accrual basis and thus
     "makes" a payment and recognizes a deferral
     as if a payment had been made even if Principal balance
     has not changed from last month's History file balance.
     You do not need to update Principal balances each month.

Monthly accounting reports:
     General ledger subsidiary listing.
     Journal voucher posting document.
     General ledger upload posting file.
     Export to Excel, Adobe.

 


Don't see what you need?
We have other software and also support
custom requests.
1-800-245-8444      email  Support@fdssi.com  


Configuration 3
Purchased loans in a Servicer Remittance File



Remittance file needs to be in or copied to Excel.

Typical changes needing to be made to the file:
     Insert 1 to 4 deferred fees for newly added loans.
     (the software's History feature contains prior month fees)

Automatically import the Excel file to the software.

From that point on is the same as Configuration 1.


Multiple fees per loan.
      Supports 1 to 4 different fees per loan.  

Automatically import the Excel file to the software.
     Amortize 1 deferral at a time.
     Amortize all deferrals at the same time.

Effective Interest Rates:
     Calculates Effective Interest Rates for all loans
     and each deferral.

Totals provided for:
     Original Deferrals
     Current month income and expense recognition
     Accumulated recognition
     Deferral balances
     Book Value NPV (Net Present Value)

Verify results.
     Create lifetime Deferral recognition schedule for any loan.
     Export to Excel.

ASC-310-20 recalculation of Effective Interest Rate and NPV:
     The software maintains a History file for prior months,
     allowing it to detect and adjust for:
     Rate changes.
     The software changes the rate, calculates a new
     payment and Effective Interest Rate
     Excess principal reductions.
          Software recognizes additional portion of deferral and
          calculates a new Effective Interest Rate and NPV.
     Payoff date or principal balance to 0.00.
          Software recognizes remaining deferral balance.

Missed, late payments:
     The software operates on an accrual basis and thus
     "makes" a payment and recognizes a deferral
     as if a payment had been made even if Principal balance
     has not changed from last month's History file balance.

Monthly accounting reports:
     General ledger subsidiary listing.
     Journal voucher posting document.
     General ledger upload posting file.
     Export to Excel, Adobe.

Note:
Some clients send us their monthly file and we return their reports in Excel.








  Price and free demo



Click to open and view Price page
Download a free demo from the Price page which includes:
     •  A live version of the software
     •  Sample records
     •  Ability to run all reports




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









Loan files can be:

     Excel worksheet
     Service bureau extract
     Core system download
     Seller service remittance report ...



New and Existing loans
For existing loans:
     Retain existing deferral balances and start using effective interest method forward.
          Start now or as of a prior date.
          Calculate income and expense recognition for prior month(s), prior year(s).



Loan Fee Income and Expense can be:
A)  Known amounts which are included in the loan file.

B)  Known amounts which are not included in the loan file.
          The software can "match" Fees from an Excel file and assign them to each loan during the import process.

C)  Gross amounts which need to be assigned to each loan:
          Some fees might be billed to you as a single amount covering all services for the month (not broken down by individual loan).
          Simply assign a single amount to be distributed to some or all new loans.
          The software will calculate a Dollar Weighted Average for the sum of principal and
          distribute the percentage of applicable loan's principal divided by sum and assign the result.

D)  Combinations of the above.





Need FASB results today?

We can send you effective interest method reports covering:
     Prior months
     Prior years
     Current month - once or continual basis


Many clients outsource their FASB, GAAP requirements to us for
     •  One time calculations
     •  Straight line "What if?" compared to effective interest method
     •  Conversions
     •  Due diligence
     •  Custom requirements
     •  Recurring monthly fee amortization, accounting and general ledger reports


Simply send a file attached to an email or secure service.
We'll process your loans and return an Excel Reports file with:
     •  Fee income and expense recognition using effective interest method.
     •  Detail and totals.
     •  Subsidiary listing with subtotals by general ledger account, loan type or other category.
     •  Journal voucher and general ledger posting file.
     •  Lifetime loan fee recognition schedules.


Let us know what you need:  1-800-245-8444      email  Support@fdssi.com










FASB 91 indirect lending accounting software for hundreds,
thousands of originated loans at the same time


    •  Originated, purchased and sold loans, new and existing         MBS, CMOs Packaged Loans
     •  Effective Interest Rate Calculation for all loans at the same time
     •  Up to 4 user defined 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
  •  Other user defined methods
 

Amortize deferred fee income and expense for
     •  Mortgage loans
     •  Consumer loans
     •  Commercial and other loans
     •  Secured, unsecured
     •  Purchased discounts/premiums at the individual loan level   at the package level
     •  Monthly, quarterly, semi-annual and annual payments
     •  P&I amortizing
     •  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
               P&I over 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
     •  Fixed rate
     •  Zero rate
     •  Variable rate
     •  360, 365, 366, 365/360
     •  FASB, GAAP compliant
     •  Customization available  


Amortize 1 to 4 deferrals
     •  Indirect lending charges
     •  Dealer fees
     •  Fee income
     •  Points
     •  Discounts
     •  Expense
     •  Closing costs
     •  Other deferred items


Import and amortize loan fees from
     •  Core system, service bureau
               Download your loan file with current balances to the software each month
     •  Seller servicer remittance reports
     •  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.
  









We offer all of the following:


1)  Software
Fee amortization and accounting reports.
Scroll down for more information, price page and free demo.


2)  Client Modules to satisfy your requirements
Need something unique?
Special interface?
New loan product?
Recognition method?
Interactive App?
Something else?
No matter what kind of deferrals you need to amortize using the effective interest method:
     Income
     Expense
     Discounts
     Premiums
     With up to 4 deferred amounts per record.
     We can create a dedicated module to meet your requirements.
Request more information  Support@fdssi.com   or  1-800-245-8444



3)  Outsourcing
Send a loan file.  Have us:
     Calculate effective interest rates, amortize fees and return a set of financial reports,
               On a one-time basis or
               Recurring monthly basis
Request more information  Support@fdssi.com   or  1-800-245-8444












Now Available - FASB 91 services at a very low price

SEND an Excel file containing basic information on loans including dealer fees and other deferred fee income and expense amounts.

RECEIVE an Excel file containing multiple worksheets with reports including:
     Effective interest rate calculations for loans listed in the same order as your file.
     Subsidiary ledger listing with:
          Subtotals by category or, if included in the file,
          Subtotals by general ledger P&L + Balance Sheet Accounts
     Journal voucher posting summary in Debit and Credit columns.
     Fee amortization schedule for a couple of loans.

Click to view FASB 91 Software As A Service page 
 










  Price and free demo



Click to open and view Price page
Download a free demo from the Price page which includes:
     •  A live version of the software
     •  Sample records
     •  Ability to run all reports




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

Sample Reports Packet

Request a free software overview containing:
     Sample reports
     Screen images
     Price
Mention any "must have" features and we'll include them with the samples.

Send request to Support@fdssi.com
 








Already amortizing deferred fees?
     The software can preserve current income and expense deferral balances.
     No adjusting journal entries.
 The software can also amortize deferred fees from original loan dates.



Customization available
Need something just for your operation?
Many of our clients had us modify the software to satisfy:
     •  Hybrid lending products
     •  Special interface requirements
     •  Read this, export that functions
               Use the software as a "background tool" to facilitate an internal processing function
     •  New loan programs
     •  Unique repayment methods
     •  Auditor requests
     •  Other proprietary, industry and competitive needs
Click here to Learn more

  
 







  Price and free demo



Click to open and view Price page
Download a free demo from the Price page which includes:
     •  A live version of the software
     •  Sample records
     •  Ability to run all reports




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





New!
     Loans Serviced by Others
     Amortize LSBO deferred fees using FASB 91
     Import remittance report directly into software for monthly amortization and accounting reports
     View  FASB 91 deferral recognition for purchased loans page






Free sample reports for YOUR loans

     •  We can provide you with free report samples for up to 15 of your loans

     •  Request our Excel loan data layout file

     •  Email the file

     •  We will generate and return an email with an Excel file containing your reports


Click to request the Excel loan file via emailSupport@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
     Download a free demo from the Price page, too.



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



 
FASB 91 Loan Fee Amortization
 Software for Windows® on a computer, laptop, shared network and cloud based systems
© 1995 - 2022 Financial Data Support Systems, Inc.
Home page        |        About us       |        Contact us       |        Site map

Top