 |
|
|
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 Indirect Lending Dealer Fees
Excel Worksheet Files |
|
Software to calculate
- FASB 91 effective interest rates and
- Recognize
deferred fee income and expense
for dozens,
hundreds,
thousands of
-
Dealer fee,
indirect lending
records covering
-
Automobiles,
vans, trucks -
new and used
- RVs,
other recreational
vehicles
- Boats,
pleasure craft
-
Virtually any
loan
with dealer fee, origination
expense
plus other costs
and fee deferrals,
including
income.
- Perfect for banks, credit unions, other financial and lending organizations
- Lease/buy software option
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.
FASB 91 compliance in seconds ....
Simply copy and paste worksheet loans to this software import screen:
Effective interest Rate column is calculated by the system during the import process
Deferral column = Fee Income or Fee Expense or a net amount when both are present
Jan'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
New! Unlimited paydowns and rate changes
-
Accelerated recognition for
Paydowns and curtailments
- Complete/final recognition for early payoffs
- Effective interest rate recalculation for
Rate changes (calculates a new payment, too)
Paydowns and curtailments
Sample Excel worksheet
|
|
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!
-
Click to open and
view screen sample page
|
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.
|
The software
also handles:
- Residential
mortgage closing
fee income and
expense
- Commercial
- Consumer
- Fixed rate
- Adjustable
- Interest only
- Balloon
(can also be
used as a
portfolio
average life
term)
- Zero
interest
-
Non-amortizing
- Leases
Utilize balloon
and
non-amortizing
features to
amortize leasing fees
over lease term.
Accommodates
both zero rate
and lease
payments with an
interest rate.
- Other
instruments with
fee income,
expense or both
For non-dealer
fee loans, view
our
FASB 91 Loan
files page
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
.... |
|
|
|
