


Loan Fees
Calculator
FASB 91 effective interest method amortization
schedules
View these pages for software to calculate a file with hundreds, thousands of loan fees:
Loan origination fees for a loan file
Dealer fees for a loan file
Purchased loans premiums and discounts
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
Calculator
input
•
Principal
(original loan
amount or
balance)
 Fixed rate
 Adjustable
 Amortizing
 Interest only
(nonamortizing)
 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,
biweekly,
quarterly,
semiannual,
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

Resolve FASB
91 issues in a matter of
seconds!
Benchmark results
for loan fee accounting
software ....
•
Automatically import
17,473
loans in an Excel
file
Amortizing,
interest only, balloons,
various terms ....
• Verify principal,
payment, term and rate
coincide for each loan
• Calculate
effective interest rate
for each loan
• Calculate current
principal balance for
amortizing loans
•
Calculate amortized fee
income for the month
• Calculate amortized
fee expense for the
month
• Recalculate
effective interest rate
for loans with rate
changes
• Accelerate fee
recognition for
paydowns, curtailments,
payoffs
• Generate
fee income totals
• Generate fee expense totals
• Display individual
loan detail
• Generate
income and expense subtotals for each
general ledger account
• Create journal
voucher debit and credit
column fee amounts
• Format an upload
file for posting to the
general ledger
As both
a
Disk file and
Screen display
 copy and paste to
Excel.
• Total time:
18
seconds
• Other
calculations
....
• Recalculate the
file for a different
month: 14
seconds
• Recalculate fee
recognition for an entire year, January
through December:
15 seconds
• Recalculate fee
recognition for the entire prior
or audit year:
15 seconds
• Recalculate
for the third quarter:
15 seconds
• Recalculate as
income and expense
projection for next
year: 15
seconds
• Display a month
by month lifetime
amortization schedule for a single
loan: 1
second
• Larger
file ....
•
Automatically import
52,418
loans from 3
worksheets in an Excel
file
• Perform the same
calculations
• Total time:
43 seconds
OS: Windows 7
Processor: 3.10 GHz
Memory: 4.00 GB




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



