 |
|
|
FASB 91 effective interest method and straight line amortization software click a page link for screen samples, price and free demo download ....
|
Loan files |
Deferred loan fees Indirect lending dealer fees Omnibus-MBS, syndicated, pooled loans |
|
Bond files |
Bond portfolios, effective interest method Bond portfolios, straight line method Bond issue, debt costs |
|
Calculators |
Loan calculator Omnibus calculator-MBS, syndicated loans Bond calculator, effective method Bond calculator, straight line Calculator Suite, all in one |
|
Services |
Free demo, lease, buy options Customizing 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 |
|
Omnibus portfolio files
MBS, packages, loan pools, groups
Effective interest method software page
FASB 91 effective interest rate calculation and recalculation for
loans,
MBS, syndicated and loan packages, bonds, groups and pools. Originated, sold, purchased.
Software to
amortize
• Premiums and
discounts
• Fee income and expense
• For issued and purchased instruments
• Monthly and fiscal year reporting
Effective interest rate recalculation when
• Par or
principal
balance changes
Accelerated recognition on reduction amount
• Rate changes
• Other changes
• On a scheduled
or irregular
basis.
How it works ....
Copy
data records
from a
worksheet.
The
software
comes
with an
Excel
template.
Paste
records to
the
software
import
screen
for
-
FASB 91
calculations
and compliance.
-
Monthly
accounting
reports.
-
General
ledger
postings.
-
All in a
matter
of
seconds.
Your
existing
records:
1) Convert and
preserve
recognition,
accumulated and
book values in
order to
maintain general
ledger status.
2) Or, the
software can
recalculate
records from
their begin
dates employing
the effective
interest method.
Includes an
Excel template
worksheet.
Copy, paste,
enter your
existing and new
records.
Column comments
provide
documentation.
Try, buy, lease the software
- Download a free demo at any time
- Buy the software
- Lease the software - 1 month at a time
Just have a handful of records?
View our FASB 91 Omnibus calculate a record page |
FASB 91 compliance in seconds ....
Copy all records in an Excel worksheet. Paste to this software import screen.
Copy and paste dozens, hundreds, thousands of records with paydowns and changes.
The software calculates, recalculates effective interest rates and
also calculates premium and discount
recognition for the selected month ....
Journal Voucher
Recap of posting transactions using your general ledger account numbers.
The system also creates
- General ledger upload posting file
- Trial Balance report with records grouped within general ledger accounts for balancing
Excel worksheet layout ....
Enter basic information into this worksheet template that comes with the software.
Par = Par, principal, grouped note amounts, participation or whole loans
sold/servicing balance, other originated, purchased or sold amounts to
be received or paid ....
Activity and changes are simple ....
Enter monthly activity into worksheet columns.
Worksheets contain 12 sets of monthly columns set to your fiscal year.
Import any worksheet at any time to calculate any month within that fiscal year.
The software initializes each new fiscal year worksheet with all of your records intact.
Activity is normally a reduction to Par. A Paydown Day, if used, allows for a very precise
calculation of partial month accelerated recognition and effective rate recalculation.
|
Accounting for financial instruments
such as, but not
limited to
• Loans -
Syndicated packages, bulk loans,
pools,
participations
and individual
loans with fees,
expenses,
discounts and
premiums
• Bonds -
Purchased or
issued, premiums
and discounts
With or without
reductions to
par during term
• MBS -
mortgage backed
securities and
CMOs
•
Originated
loan groupings, such
as by month of
origination -
weighted average
rates, terms
For a file consisting of typically amortizing loans, wth or
without
paydowns and rate
changes, view
our
FASB 91 loan
files page.
• LSBO -
participation
and whole loans
serviced by
others
• Hybrid
loans
• Other
assets or
liabilities with
periodic,
irregular
reduction in
value, rate
change, maturity
date adjustment
including
- Par, principal
paydown
reductions,
curtailments,
payoffs
- Partial sales
- Variable rates
- Other changes
during term
Instruments
requiring fee,
premium,
discount
amortization
• On a
month by month
basis plus
accelerated
recognition as a
percentage of
excess paydown
to principal or
par requiring
a recalculation
of the
effective
interest rate.
•
Generate general
ledger posting
totals on a
Monthly
frequency or
Annual basis (fiscal
year ending
month)
During
import, the
software:
-
Determines
premium or
discount amount
-
Calculates
effective
interest rates
-
Provides:
Monthly premium
and discount
amortization and
accretion based
on selected
calendar date
For each record:
Monthly premium
and discount
recognition
Accumulated
recognition
Deferred premium
or discount
balance
Book value
carrying balance
Summary totals
of the above by
category:
Premium totals
Discount totals |
More
about
accounting and
reporting ....
• Maintain
records in
- A
single worksheet
-
Multiple
worksheets to
segregate
records
- Also
applicable for
records where
par is not
subject to
reduction - mix
or segregate
Paste dozens,
hundreds,
thousands of
records with:
• Cusip
or your assigned
IDentifier
• Par,
principal
balance
•
Purchase/settlement/begin
date
•
Maturity date
•
Coupon/interest/nominal
rate
• Price
(Par +premium or
-discount) =
initial carrying
balance
As $Dollar
amount or
%Percent
Premium,
discount can be
loan fee
expense, fee
income
Software
establishes
premium/discount
amount
•
Conversion
balances, if
desired
•
Supports
calendar and
fiscal year
•
Adjustments
which may occur.
Maintained in
sets of 5
columns for each
month:
Nominal rate
change
Par/balance
paydown
reduction,
partial sale
amount
Day of month for
old days, new
days recognition
Additional fees,
expenses
Maturity date
change
• If no
changes occur,
nothing need be
entered
•
Software also
amortizes
records that
don't experience
changes
•
Maintain records
in one Excel
worksheet or
segregated files
The
software will
•
Calculate FASB
91 effective
interest rates
- Calculated for
initial values
- Recalculated
for a paydown or
other changes
•
Recalculate
effective rate
if a change
occurs
•
Determine
calendar month
recognition
- Income
- Expense
- Journal
voucher
preparation
• Report
general ledger
balances for
-
Par/principal
balance
- Premium
deferral balance
- Discount
deferral balance
- Carrying
amount
(Accretion
balance)
•
Accelerate
recognition due
to
paydown/partial
sale
• Prepare
a complete set
of accounting
reports
- View
- Send to
printer
-
Copy/paste to
Excel
- Upload
file with
general ledger
debits and
credits
- Direct
post or allocate
to revenue and
cost centers
- Supports
calendar and
fiscal year
periods
• Produce
a detailed
recognition
schedule for
each record
- Normal
month to month
premium,
discount
amortization
recognition
-
Accelerated
discount,
premium
recognition for
principal
paydown,
curtailment,
partial sale,
payback
reductions
•
Generate current
and historical
reports - go
paperless
• Export
schedules and
reports to Excel |
|
|
|
