Dealer fee loan files - effective rates and reports

                    SOFTWARE  PRODUCTS 
Financial Data Support Systems, Inc.
   Accounting
       Amortization
           Software
 
  Home page
  About, contact us
  FASB 91 - all products
 
  LOAN FILES - FASB 91 deferred fees income and expense amortization
  MBS, LSBO, LOAN PACKAGES - FASB 91 premiums, discounts amortization
  BOND ISSUER ACCOUNTING SOFTWARE - premiums, discounts, issuance costs
  BOND PURCHASER ACCOUNTING SOFTWARE - effective interest method
  BOND PURCHASER ACCOUNTING SOFTWARE - straight line 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
  l



FASB, GAAP compliant



Mortgage loans

FASB 91 indirect lending, dealer fees amortization software

Monthly amortization of originated dealer and other fees from a
     •  Core system
     •  Service bureau
     •  Excel worksheet
     •  Manually serviced loans
     •  Purchased discounts/premiums at the individual loan level
     •  Other files and sources
     •  Up to 4 unique income/expense items per loan


FASB 91 accounting software for hundreds, thousands of loans ....
     •  Effective interest rate calculation
        (also utilize straight line for designated loans)
     •  Dealer and other fee expense amortization
     •  Fee income amortization
     •  Totals for each
     •  General ledger, journal voucher, monthly upload posting files
     •  Allocate income, expense to multiple cost, revenue centers
     •  Subsidiary account balance reporting
     •  Lifetime fee recognition audit schedules
     •  Prior period calculations
     •  Future income, expense projections
     •  FASB 91 Custom coding
     •  Special reports
     •  One-time file calculation services
  


Process an entire file:
     •  Calculate effective interest rates
     •  Amortize deferred loan fee income and expense
               Recognize current, prior and future periods
     •  Generate all monthly accounting reports
               Subsidiary account listing
               Journal voucher
               General ledger posting file
     •  Produce individual month by month audit and exam loan schedules


   Question about your loans?
   1-800-245-8444
   Support@fdssi.com








Small file?
Large file?
Different versions available to meet different operational requirements.

Free evaluation.
We will create a free version of the live software for you to
evaluate with your loans.
 













































SPECIAL FEATURES

     •  Individual loan schedules:
               Automatically generate a lifetime fee recognition schedule for any loan at any time.
               View, print, save in Adobe, save in Excel


     •  Delinquents, non-payment:
               The software continues the payment stream regardless of non-payment activity.
                    (this is accrual based and not a transaction based fee recognition system)
               Deferred fee recognition continues to occur.
               This logic remains consistent with loan interest income being accrued (earned).
               The software will continue recognizing a deferral on a delinquent loan until overt, other action is taken.


     •  Multiple fees:
               From 1 to 4 unique fee income or expense items per loan.
               Each fee can be assigned its own set of general ledger debit and credit accounts (or default to system generated numbers).


     •  Partial paydowns, curtailments:
               The software recognizes an additional portion of deferred income, expense balance attributable to the principal reduction.


     •  Early payoffs:
               The software will recognize deferred fee balances in full when
                    Principal balance goes to zero or
                    An "Early payoff date" is encountered or
                    When importing from a loan servicing system, the loan is "gone" (for which a report will be provided and loans flagged accordingly).


     •  Rate changes:
               The software calculates a new effective interest rate.
               The software calculates a new payment.


     •  Months to calculate fee recognition:
               Ability to
                    Recognize deferred fees for a single month and
                    Recognize deferred fees for a span of 2 months through 12 months.
                    Begin a period with any current, prior or future month/year


     •  Expense:
               A display option can show expense recognition as negative in order to readily distinguish between expense and income













MONTHLY ACCOUNTING FOR DEALER FEES AND OTHER LOANS

     •  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:
           P&I over balloon period
           P&I over longer term (e.g., five year balloon with P&I over a 30 year term)
           Average portfolio life


     •  Fixed rate
     •  Zero rate
     •  Variable rate
            Assigned
            Tied to an index such as LIBOR, Prime, other
     •  360, 365, 366, 365/360
     •  Customization available   
 


Account for loan packages, too
     •  Premiums, discounts, income and expense associated with
     •  MBS, LSBOs, syndicated pools, GNMAs ....
 












Existing loans and deferral balances:

Option 1
        Preserve your existing book values.
        No adjusting journal entries.
        The software can begin amortizing deferred fee income and
        expense balances using current loan information.


Option 2
         Calculate prior and current book values.
         The software can amortize deferred fee income and expense
         from original dates using original loan information.


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











                               PRICE PAGE AND FREE DEMO



Price page and free demo
Click to open and view Price page
     The price page also contains information on obtaining a free demo.



Questions?
1-800-245-8444
Support@fdssi.com












                                          REPORTS



Free set of monthly reports - sample loans
Send an email for a complete set of monthly reports.
     The software can export all reports to Excel.
     We'll return an Excel file with multiple worksheets
     demonstrating various capabilities of the system.
     Email  free set of reports
     Include any special interests or requirements you may have


Free set of monthly reports - your loans
Send an email requesting a free Excel template.
     Add a few of your loans to the file (exclude proprietary data).
     Return the file to us.
     We'll calculate your loans, generate reports and return the same file with
     multiple worksheets demonstrating various capabilities of the system.
     Email  free Excel template


Dealer fees file calculation services
We can calculate a loan file on a one-time basis.
Deferred fee income and expense amortization for a month.
For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
Typical turn-around time is less than 2 hours.
For more information, Email  Loan file calculation services













                        FASB 91 CUSTOM CODE

Unique situation?
Unusual records?  New fees?
File layout?  Source?

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

1-800-245-8444
Support@fdssi.com
 







 


 
 
 
 
 















































































FASB 91 Custom Code
Unique situation?
Unusual records?  Fees?
File layout?  Source?
We can write custom code
and embed your private
module within the existing
nuts and bolts portion
of the software.
1-800-245-8444
Support@fdssi.com

FASB 91 for indirect lending dealer fees software
Mortgage and other types of loans page
MBS, LSBO, syndicated loan packages page



Amortize hundreds, thousands of loan dealer fees in files from a

     •  Loan servicing system

     •  Core, in-house computer

     •  Service bureau

     •  Excel worksheet
               Typically for smaller files, manually serviced loans, non-automated processing

     •  Other spreadsheets and file types

     •  Custom files and programming requirements



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



Accrual accounting - not a transaction based system
     •  Monthly fee recognition is tied to loan interest income
               Interest received and
               Interest accrued
               Fee recognition occurs every month



Effective interest rate calculation for each loan



Recognition of deferred fee income and expense under FASB 91
     •  Current month
     •  Prior months and years
     •  Future months
     •  Annual projections




Amortize
     •  Dealer fees
     •  Fee income
     •  Points
     •  Discounts
     •  Expense
     •  Charges
     •  Closing costs
     •  Premiums
     •  Other deferred items



Account for multiple fees
     •  Up to four (4) distinct fees per loan



Detail schedules
     •  Month by month recognition
     •  Support for auditor, examiner queries



Effective rate recalculation for rate changes



Accelerated recognition of deferral balance due to
     •  Principal reductions due to paydowns, curtailments
     •  Early payoffs



Loan file totals
     •  Total fee income - monthly and annual
     •  Total fee expense - monthly and annual
     •  Net:  Income minus Expense



Subsidiary account balancing



General ledger
     •  Journal voucher
     •  Upload transaction posting file






 








 

Need FASB 91 loan calculations NOW?

Don't want to buy software?

Do what others have done:
     •  Send your file attached to a secure email
     •  We can
               Import your loans to the software
               Perform any necessary changes or file clean-up
               Amortize deferred loan fees for any period
               Return a complete set of reports in Excel
     •  Reports can be generated
               One time basis
               Recurring basis

Please call 1-800-245-8444
or email
 







































 Client testimonials ....

 Thank you so much for your help.
  It’s so refreshing to talk to someone who understands! 
                             California


I love your software and have had no issues.
                            Illinois


 Our outside accountants just completed their audit.
 This is the first year we've been using your software AND
  the first year we received a clean audit report.
                            New York



We have been utilizing FDSSI software to the fullest and we are so excited that we have it to do the calculations for us!
                           Florida


  I'm not technically inclined but was able to install your software without any problems.
 Then I imported my loan file.
 Your software performed all the calculations and totals we need in a matter of seconds.
 I can't believe how much work it's going to save us each month.
                            Texas


A HUGE thank you for going the extra mile plus!!!!!!!
                            Minnesota


 Thanks a lot!
 This program has just made my life so much easier.
                            Georgia


  Thanks.
  Your customer service is fantastic!
  Have a great week.
                          Washington








A proven system for small and large loan files

•  Different versions to meet different operational needs

•  Evaluate the software with your loans at no charge

•  Qualified assistance regarding unusual requirements

•  Software customization for unique needs

•  FASB, GAAP compliance without spending a fortune




Amortize deferred income and expense for

•  P&I amortizing loans

•  Fixed rate

•  Zero rate

•  Variable, adjustable rate
          Effective rate recalculation with each rate change

•  Balloons as interest only with a balloon payment

•  Balloons with partial P&I amortization at a longer term during the balloon term
          Supports average portfolio life fee amortization

•  Interest only loans

•  Interest only with periodic constant amount reductions to principal such as scheduled quarterly principal repayments

•  Interest calculations at 360, 365, 366 actual days, 365/360 ....

•  Full recognition due to early payoff

•  Paydown, curtailment accelerated fee recognition

•  Effective interest rate recalculation due to paydown reduction




Complete monthly fee accounting and reporting for ....

•  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

•  Complete monthly reporting and accounting in a matter of seconds

•  Lifetime month by month amortization and fee recognition schedules for each loan

•  View reports.  Print.  Export to Excel.
 



Loan fee recognition and totals for

•  Current month

•  Current period ranging from 1 to 12 months

•  Prior months

•  Prior accounting and audit periods up to a year.  Annual totals.

•  Future months and period projections

•  Calculate, recalculate a different period in seconds




Your existing loans

•  The software can amortize dealer fees from original dates or

•  Current general ledger and deferred dealer fee balances can be preserved

 

 


















Price page and free trial system  ....

Click the link to open and view price page.
Find out how to evaluate the software with your loans at no charge.
 Price page




Free set of monthly reports - sample loans
Send an email for a complete set of monthly reports.
     The software can export all reports to Excel.
     We'll return an Excel file with multiple worksheets
     demonstrating various capabilities of the system.
     Email  free set of reports
     Include any special interests or requirements you may have


Free set of monthly reports - your loans
Send an email requesting a free Excel template.
     Add a few of your loans to the file (exclude proprietary data).
     Return the file to us.
     We'll calculate your loans, generate reports and return the same file with
     multiple worksheets demonstrating various capabilities of the system.
     Email  free Excel template


Dealer fees file calculation services
We can calculate a loan file on a one-time basis.
Deferred fee income and expense amortization for a month.
For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
Typical turn-around time is less than 2 hours.
For more information, Email  Loan file calculation services






 

Amortization terms:
     Actual life of each loan
     Average portfolio life
     Other derived terms    
Calculate interest payment for non-amortizing loans
Calculate monthly fee recognition as
     Income
     Expense
Early payoff:
     The software recognizes the remaining deferral amount.
Curtailment, paydown, other partial reductions to loan balance principal:
     The software calculates a new effective interest rate.
     The software accelerates fee recognition proportionate to the reduction.
Variable rate, adjustable rate:
     The software calculates a new effective interest rate.
     The software calculates a new payment.
The software will calculate:
     Hundreds of loans
     Thousands
     Hundreds of thousands of loans at the same time.
Generate fee income and expense totals:
     For any month, year
     For any calendar or fiscal entire year
     For audit and examination periods
Loan ledger subsidiary account balance sheet report
General ledger upload posting file
Schedules:  Automatic lifetime fee amortization schedule for any loan
Audits:  Annual and other fiscal period reporting for audit and examinations
Customizing for unique situations, new lending programs




Many of our clients are
     •  CPA, accounting firms
     •  Auditors
     •  Asset management companies
     •  Financial advisors
View this page to see how they utilize the software
to calculate, audit or provide accounting services for client files




  Currently using another method?  Another system?  No system?
     The software can recalculate deferral balances for current and prior periods.
     Or, the software can preserve your current deferral balances.
               No general ledger adjustments necessary.


  •  Effective interest rate calculation and accounting for an entire loan file

  •  Dealer fees expense amortization

  •  Fee income amortization, if applicable

  •  Cost, expense amortization

  •  Portfolio totals in a matter of seconds
          Total fee income
          Total fee expense
          For a month.  Quarter.  Calendar or fiscal year.
          Current, past and future periods

  •  Detail audit schedules
          Lifetime amortization and fee recognition schedule for any loan on demand

  •  Amortizing loans

  •  Interest only loans

  •  Balloon loans
          Amortizing
          Interest only

  •  Loan amortization periods
          Recognize fees over the full term of the loan
          Recognize fees over an average life
               Amortize loans over an average life instead of a full term
               Apply to some loans or all loans

  •  Zero interest rate
          Some clients use this feature to amortize leasing fees

  •  No data maintenance or updating necessary

  •  Operates on
          Original loan and deferral balances
          Current loan and deferral balances

  •  Variable rates
          Supports rate changes

  •  Principal paydowns, curtailments
          Accelerated fee recognition due to paydown/curtailment/payoff





Flexible output ....
     •  View results on screen
     •  Send to local or network printer
     •  Copy and paste results to an Excel worksheet



Principal Balances
The system calculates the current principal balances for amortizing
loans "as of" the requested amortization month or period  (for MBS, pooled loans, syndicated packages, view this page)



Effective interest rate
The system calculates an effective interest rate under FASB 91 for each loan and
calculates a new effective rate for a rate change


Fee income and expense amortization
  •  Individual loan level
  •  File totals by category
  •  Lifetime amortization schedule for a loan


General ledger posting
  •  Subsidiary reports
  •  Journal voucher posting source document
  •  General ledger upload posting file


                            CHANGES during term ....
Rate changes
  •  Supports interest rate changes
  •  Effective interest rate recalculation due to a rate change
  •  The software calculates the new payment

Paydowns
  •  Supports partial paydowns and curtailments
  •  Accelerated recognition of deferral corresponding to reduction of principal

Payoffs
  •  Supports early payoffs
  •  Recognize deferred fee balance in full
  •  For payoff, sale, or otherwise disposed


New and existing loans
  •  New loans:  The system performs calculations using original loan information.
  •  Existing loans:
          1)  The system can "bring loans current" if original loan information is available.
                    Calculate a file for current and prior periods.
          2)  Or, the system can use current loan balances, current deferred fee balances and so forth.
                    The system can calculate a remaining term based on loan balance, rate and payment.


Amortize, recognize, account for and post
  •  Deferred loan fee income
  •  Cost, expense
  •  Finance charges
  •  Discounts and premiums 
        Interchange premiums and discounts with income and expense depending upon which they are to you



Methods
  •  Fixed rate
  •  Adjustable, variable rate (scheduled and "on demand" rate changes)
  •  Interest only
  •  Balloon term (can also be used as a portfolio average life term)
  •  Zero interest rate
  •  Non-amortizing loans (and loans with unscheduled or periodic principal reductions)



Unusual loans
  •  Loans your mainframe can't handle
  •  New products/loan offerings
  •  Unusual payback terms ....
        The software can be modified to meet specific client needs



Leases, too
  •  Utilize balloon and non-amortizing features to amortize leasing fees over lease term.
  •  Accommodates both zero interest rate as well as lease payments incorporating an interest rate.



Generate recognition and accounting reports
  •  Amortization and accretion
  •  Subsidiary listing with detail and totals
          Monthly recognition
          Accumulated
          Balances
  •  General ledger accounting
          Journal voucher posting source document
          General ledger transaction posting upload file
 


Types
  •  Residential mortgages with origination fee income and expense
  •  Commercial loans, paper
  •  Loan packages, purchased or sold
  •  Consumer loans, automobile, other vehicles
  •  Dealer fees, indirect lending costs
  •  Other conforming, non-conforming loans


Custom modifications
  • Custom calculations and routines for new lending programs, unique situations ....

Calculations
•  FASB 91 Effective interest rate
•  Deferral amortization recognition
     -  Fee income
     -  Fee expense, cost
     -  Net of both when applicable
     -  For loan term or average life
•  All monthly accounting reports

Calculate deferral recognition and balances as of:
•  Current month
•  Prior month
•  Prior year end (fiscal or calendar)
•  Future month or year end
•  Range of future months for annual budget/forecasting

Reports:
Trial Balance subsidiary ledger report
Detail and totals for
     •  Income
     •  Expense
     •  Accumulated
     •  Deferral balance
     •  Carrying amount (Accretion balance)
     •  Totals by category or general ledger account numbers

General ledger
     •  Journal Voucher posting source document
     •  Upload posting file
     •  Direct post to any chart of accounts
     •  Allocate selected or all recognition to revenue and cost centers

FASB 91 detail schedules
     •  Lifetime effective interest method amortization for each record


Available for
1) Loans at the individual loan level:
     -  Fixed rate, adjustable, amortizing, interest only (non amortizing) and balloon loans
     -  Monthly, quarterly, semi-annual and annual payment frequencies
     -  Mortgages
     -  Dealer fees, holdbacks, indirect auto lending expense
     -  P&I amortizing loans
     -  Balloon
     -  Interest only
     -  Average life term
     -  Callable

2) Groups and packages (fees treated as premium or discount using our Omnibus software):
     -  Individual rates, composite, dollar weighted
     -  Mortgage backed securities
     -  LSBOs
          Purchased loans
          Participations
     -  Other packaged loans
          Held to term
          Average life
     -  Amortizing
     -  Irregular principal receipts stream
          Variable amounts
          Curtailments, payoffs
          Partial sales
     -  Weighted rate changes
     -  Interest only
     -  Monthly bulk origination, aggregate

 








 

Price
Click to open  Price page


Free set of monthly reports
Send an email for a complete set of monthly reports.
     The software can export all reports to Excel.
     We'll return an Excel file with multiple worksheets
     demonstrating various capabilities of the system.
     Email  free set of reports.


Dealer fees file calculation services
We can calculate a loan file on a one-time basis.
Deferred fee income and expense amortization for a month.
For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
Typical turn-around time is less than 2 hours.
For more information, Email  Loan file calculation services


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
Omnibus - Loan, bond packages 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 Loan Fee 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

Top