Loan Calculator effective rate fee amortization
Prepaid expenses, deferred charges amortization
Deferred income, revenue amortization
Fixed assets, FF&E straight line depreciation

FASB 91 effective interest method  
Loan fees income, expense, other charges amortization
Loan fee amortization calculator
  •  FASB 91 effective interest method Calculator
  •  Highlights
  •  Prices
  •  Free demo
Dealer indirect lending fees, charges amortization
Omnibus loan packages, irregular payments amortization
Bond premiums, discounts, costs amortization
FASB 91 effective interest method all products

Financial Data Support Systems, Inc.  
Home page
About us
Contact us
Technical FAQs
PC, laptop, workstation and
shared network devices
running Windows®

Business, government, financial institutions, accounting firms ....

Loan Fee Amortization Calculator

FASB 91  loan fee income, expense amortization calculator for
  •  Residential, commercial, consumer, auto, indirect ....
  •  Amortizing, interest only, balloon, fixed rate, variable rate, secured, unsecured and other loan types

Also see:
  •  Accounting software to calculate an entire loan file

Calculator input
•  Principal (original loan amount or balance)
     - Fixed rate
     - Adjustable
     - Amortizing
     - Interest only (non-amortizing)
     - Balloon
•  Note rate
•  Payment (leave blank for system to calculate as non amortizing, "interest only")
•  Term
     Input any three of the above and the software can solve for the unknown.
•  Fees
     - Income
     - Cost (expense) origination charges, dealer fees ....
     - Both. When both are present, software determines the "net amount" to amortize.
     Or, run two pure schedules. One for fee income, a second for costs.
•  Monthly, bi-weekly, quarterly, semi-annual, annual payment frequency (button selection)

Additionally available entries:
• Balloon term (callable, average life)
     If entered, Payment can be blank and the
     software will calculate an interest only payment amount
•  Reprice After
     A future point to reprice an adjustable loan
•  Reprice By
     An amount by which to increase or decrease the Note rate

Calculator output
•  Effective interest rate
     -  Calculated by the software
     -  Applicable to fixed rate, adjustable, interest only and balloon loans
•  Determination of deferred fee amount to amortize as:
     -  Income only (up front charges and fees for a lender)
     -  Cost only (origination expenses, up front charges and fees for a borrower)
     -  A "net" fee derived by subtracting the smaller from the larger
•  FASB 91 amortization schedule:
     -  Accrued monthly interest at note rate
     -  Monthly interest at effective rate on loan balance plus or minus remaining deferred fee balance
     -  Deferral recognition (difference between stated and effective interest rates)
     -  Accumulated
     -  Deferral balance (remaining fee to be amortized)
     -  Book value, carrying amount
•  With output results -  View, print and copy, paste to Excel or other spreadsheet program

But ....
     Why calculate 1 loan when you can

     calculate dozens, hundreds, thousands of loans at a time
     -  Monthly
     -  Quarterly
     -  Annually (calendar and fiscal years)
     -  Past, current and future periods
     -  Import original loan data
     -  Calculate principal balances and
        fee recognition "as of" requested month or period

•  Effective interest rate
     -  Calculates effective interest rate under FASB 91 for each loan

•  Fee income and expense amortization
     -  File totals by category
     -  General ledger posting totals by account
     -  Lifetime amortization schedule for a loan

•  Amortize, recognize, account for and post
     -  Deferred loan fee income
     -  Cost, expense
     -  Finance charges
     -  Premiums and discounts
       (for MBS, purchased loan packages with premiums and discounts, view this page)

•  Early payoff dates
     -  Recognize deferred fee balance if paid off, sold, other reason

•  Paydowns
     -  Supports partial paydowns and curtailments
     -  Accelerated recognition of deferral corresponding to reduction of principal
     -  Effective interest rate recalculation

•  Rate changes
     -  Effective interest rate recalculation due to a rate change
     -  New payment calculation

               View sample screens for loan fee amortization software  ....

Excel worksheet
  •  Excel worksheet with amortizing loans, interest only, balloons ....
          including loans with rate changes, paydown curtailments, accelerated recognition

Import Screen - Loans and totals 
  •  FASB 91 monthly fee income and expense recognition

Trial balance and other monthly reporting
  •  Subsidiary general ledger accounts trial balance listing
          the software creates a trial balance, journal voucher plus general ledger postings

Amortization schedule for imported loans
  •  Loan fee amortization schedule.  Lifetime month by month fee recognition
          includes additional fee recognition for a loan with a paydown curtailment

Early payoff
  •  Fee recognition for a loan with an early payoff date
          the software recognizes the remaining deferral balance

Audit and examination 
  •  Fee recognition for an entire year - calendar, fiscal, audit or examination period

               Your existing records ....

Have not been recognizing fees:
If you have not been booking fee recognition, the software can provide the amount which should have been been recognized under FASB 91 from original loan dates through any month and year.

Have been recognizing fees:
If you have been booking fee recognition using another method, the software allows you to retain current fee balances.
In the Excel worksheet:
Substitute original loan balance with current loan balance.
Original fee income or expense becomes current fee income or expense.
First payment date needs to be the first month for the system to begin recognizing the fee.
Term column should be left blank, which instructs the system to calculate a remaining term based on payment, rate and balance.

               Related software ....
Irregular paydown amounts or payment streams?
Loan packages?  Syndicated?  MBS?  Participations?
Other loan type financial instruments, originated or purchased?
View our Omnibus FASB 91 amortization software

Price ....

Click to open and view calculator Price page

Multiple loans?  Hundreds?  Thousands?
View this page to import and calculate a loan file.

Purchased loans, packages?  Irregular payments?
View our Omnibus FASB 91 premium and discount amortization software for
  •  MBS, syndicated packages, LSBO, secondary market, grouped originations, bundled loans, bonds with monthly par reductions and more.

Dealer fees?  Indirect lending?
View samples screens for FASB 91 software for Dealer fees

Flexible ....
Enter a loan to the effective interest rate calculator screen
       •  Enter basic loan information plus fee income, expense or both income and expense.
       •  Calculate effective interest rate.
       •  Produce lifetime loan and deferral amortization schedule. 

Ideal for one or dozens of loans with or without rate changes and payment curtailments
     •  Regular amortizing loans
          Residential, commerical, consumer, auto, other ....
     •  Balloons, with or without payments or principal paydowns
     •  Interest only
     •  Packages, pools, groupings - One big loan, log each monthly principal reduction as a paydown
               If your packages have maturity dates instead of a term in months, view our bond calculator page
     •  Fixed, variable rate
     •  Monthly, quarterly, annual pay
     •  Loans with unusual, variable repayment terms
     •  For originators, borrowers, sellers, buyers, accountants, auditors


Price page includes ....
     •  Stand alone and network sharing software prices.
     •  Free demo
     •  Click to open and view price page

Multiple loans?  Hundreds?  Thousands?
View this page to import and calculate a loan file.

or email
Other pages of interest ....
FASB 91 products page
Omnibus - Loan, bond packages FASB 91 amortization
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
  Loan Fee Calculator Software for Windows® PC, laptop, workstation and network sharing by
© 1995 - 2015 Financial Data Support Systems, Inc.
Home page        |        About us       |        Contact us       |        Site map