 |
|
|
FASB 91 effective interest method and straight line amortization software
Click a page link for screen samples, price and free demo download ....
|
Loan files |
Originated loan files - FASB 91 fee income and expense amortization for hundreds, thousands of secured and unsecured loans
Packaged loan files - premium and discount amortization for purchased loans, MBS, secondary market, syndicated, originated loan groups using FASB 91
Indirect loan files - dealer fees, other charges amortization using FASB 91 |
|
Bond files |
Effective interest method files - bond premium and discount amortization, other accounting and reporting for a bond portfolio
Straight line method files - bond premium and discount amortization, other accounting and reporting for a bond portfolio
Bond issuance, debt costs - amortizing issue costs over the life of bonds |
|
Calculators |
Originated direct and indirect loan fees FASB 91 calculator Packaged, purchased, MBS, syndicated loans FASB 91 calculator
Bond calculator, FASB 91 effective method Bond calculator, straight line Calculator Suite - all calculators |
|
Services |
Custom software Free demo, lease, buy options Question? Don't see what you need? FASB 91 products home page |
|
FAQ topics |
Bond straight line vs. effective method Purchased loans Premium, discount packages Reductions to Par Fiscal year totals |
|
Loan Calculators
Effective interest method page |
|
FASB 91 effective interest rate calculation. Loan fee income, expense amortization.
• Residential, commercial, consumer, auto, indirect ....
• Amortizing, interest only, balloon, fixed rate, variable rate, secured, unsecured and other loan types
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.
• Import a loan to the calculator. Simply copy and paste a worksheet row containing loan data.
- Ideal for repetitive calculations, such as determining deferral amount to recognize each month.
- Track and account for unexpected paydown curtailments, scheduled reductions to principal ....
- Unlimited number of rate changes (automatic payment recalculation)
- Calculates initial effective interest rate, recalculates when changes occur
• Import a file
View this page for calculating a file containing loans, with or without curtailment paydowns and rate changes
View this page for calculating a file containing MBS, packages, purchased or grouped loans
Sample 1 of 3) Enter a loan with fee income and/or expense (Purchased loan? Substitute fee income with loan discount, expense with premium)
Sample 2 of 3) Import a loan from a worksheet
Import loan changes, too - unlimited rate changes, principal paydown curtailments
Import a loan - regular loans plus variable, unusual, non-conforming loans and loan packages
If your loan "behaves" more like a bond, with a premium or a discount being amortized to a Maturity date, see our Omnibus calculator page)
Effective interest rate calculation, recalculation and amortization recognition schedule for a loan with changes.
- Rate adjustments - increase and decrease
- Paydown, principal curtailments
- Funny or quirky loan agreements
- Unusual payment streams
Import loan data plus an unlimited number of changes from an Excel worksheet:
- Paydowns, principal curtailments (the software recognizes paydown portion of deferred fee in paydown month)
- Rate adjustments (the software calculates a new payment)
- The software recalculates the effective interest rate due to either of the above
Sample
3 of 3)
Import a loan with projected and system generated rate adjustments and paydowns
Import a balloon loan, interest only with quarterly principal payments
Example of having the system automatically generate recurring rate changes and paydowns
Action Code or Date instructions
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
(Need to calculate a file with hundreds, thousands of loans each month? View our Loan File import software)
(Not what you're looking for? Visit our FASB 91 products Home page)
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
New!
Includes a separate calculator to import a loan worksheet record.
- Import original information for a loan to a worksheet (free template provided with the software)
Great for those with one loan or just a handful of loans.
- Import as many paydowns which occur
- Import unlimited number of rate changes
- Software produces a schedule with
Effective interest rate calculation
Effective interest rate recalculation with each paydown and rate change
Accelerate recognition for each paydown
Paydowns for a file with hundreds, thousands of loans? Rate changes?
Curtailments? Scheduled paydowns? New effective rates? Payment recalculations? View our loan worksheet import software.
|
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,
LIP)
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
|
|
|
|
