 |
|
|
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 |
|
FASB 91 effective
interest
method software for Deferred Loan Fees
Excel Worksheet Files |
|
Software to ....
- Calculate FASB 91 effective interest rates
- Recognize deferred fee income, expense, discounts for
- Residential
mortgage closing
fee income and
expense, discount and premium
- Commercial
loans, paper
- Consumer
loans, automobile,
other vehicles
- Dealer fees, indirect lending costs
- 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)
- 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.
Simple to use ....
- Place original loan fee records in a worksheet. Add new records as necessary.
- Copy entire worksheet, paste to the software
- Software calculates loan balance based on calculation month.
|
New! Unlimited paydowns and rate changes
-
Accelerated recognition for
Paydowns and curtailments
- Complete/final recognition for early payoffs
Try, buy, lease the software
- Download a free demo at any time
- Buy the software
- Lease the software. 1 month. Multiple months. Full credit applied.
Purchased loans? Sold loans? Packages?
With premium, discount maturity dates?
View our Omnibus portfolio software page.
Special requirement? Something different?
View our Services and custom software page.
Not sure what you need? Contact us |
Effective interest Rate column is calculated by the system
Deferral column = Fee Income or Fee Expense or a net amount when both are present
Feb'2012 = the amount to book for whatever calendar month or range of months is selected
Principal Balance is calculated by the system
Book Value = Principal Balance +Expense or -Income Balance
|
|
Maintain loan fees in one or more worksheets.
For monthly reporting:
1) Copy an entire worksheet (as if copying one worksheet to another).
2) Paste worksheet loan fee records to
the
software
import
screen.
3)
Select
a calendar
month and calculate:
- Loan fee
income
and
expense
recognition
for an
entire
file
-
FASB 91
calculations
and
compliance
-
All
monthly
accounting
reports
-
General
ledger
postings
-
Lifetime
amortization
schedule
for any
loan
-
In
a matter
of seconds!
|
Worksheets:
Enter loan data and fees.
Download loan data from a mainframe.
Export calculation results and reports to Excel.
For internal use.
Email to outside auditors.
Records retention.
Export reports to Excel.
Or save loan worksheets with a unique monthly name.
Import, calculate, report at any future date.
|
During
import, the
software:
Calculates effective
interest rates
Provides:
Monthly fee
income and costs
amortization
Calendar date
selection
determines
effective month.
For each
record:
Monthly
recognition
Accumulated
Deferral balance
Book value
carrying balance
Summary totals
of the above by
category:
Fee income
totals
Cost/expense
totals
You can
also:
Generate
amortized income
and expense
totals for a
Month
Quarter
Calendar or
fiscal year
As of a prior or
future period
View a lifetime
month by month
amortization and
fee recognition
schedule for any
record
Copy and paste
results
elsewhere
Paydowns:
Supports single
or multiple
paydowns.
Curtailments,
paydowns,
participation
sales.
Put date and
paydown amount
in the file.
The system will
automatically
accelerate
deferred fee
recognition for
the paydown
amount.
A percentage of
the paydown/loan
balance will be
used to
recognize that
portion of the
deferral.
A new effective
interest rate
will be
calculated based
on the new
remaining term.
Accepts
multiple
paydowns for the
same loan.
Including
separate,
multiple
paydowns in the
same month.
Log paydowns 2
ways (or use
both):
Immediately
following a loan
number row.
Grouped together
within a
"Changes"
section.
Payoffs:
Early payoff
date column to
recognize in
full prior to
end of
anticipated
term.
Rate changes:
The software
supports one
rate adjustment.
It also
supports
multiple
rate changes.
Put new rate and
effective date in the
file.
Enter as many
changes as
occur.
The system
calculates a new
payment and
recalculates the
effective
interest rate.
Log rate
changes 2 ways
(or use both):
Immediately
following a loan
number row.
Grouped together
within a
"Changes"
section.
Loan
types
- Fixed
rate
-
Adjustable
-
Amortizing
-
Interest only
- Balloon
- Zero
interest
-
Non-amortizing
Payment
frequencies
- Monthly
-
Bi-weekly
-
Quarterly
-
Semi-annual and
annual
|
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 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 in 2
versions, where
a file consists
of
1) Loans at the
individual loan
level:
- Fixed
rate,
adjustable,
amortizing,
interest only
(non amortizing)
and balloon
loans
-
Monthly,
bi-weekly,
quarterly,
semi-annual and
annual payment
frequencies
-
Mortgages
- Dealer
fees, holdbacks,
indirect auto
lending expense
- P&I
amortizing loans
- Balloon
-
Interest only,
LIP
- 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
Scroll
down for
price and free
software demo
.... |
|
|
|
