FASB
91 Software
Effective Interest Method
|
| Straight
Line Amortization
|
| Financial
Data Support Systems, Inc.
|
For
PC, laptop,
workstation and
shared devices
running Windows® |
|
Utilized by
Business
Government
Financial Institutions
Accounting Firms |
|
|
|
.
MBS,
LSBO,
loan pools, paydowns ....
 |
|
|
..
FASB
91 software to amortize premiums and discounts
with prepayments, paydowns, partial sales
| Applicable
for bonds, MBS, securities, loan pools, investment groupings, hybrids,
LSBO packages and other originated, issued and purchased financial instruments,
collateralized obligations having a fee, premium or discount when par or
principal balance, nominal rate and other terms are subject to reduction,
modification or other change on a scheduled or irregular basis including
curtailments and payoffs. |
|
...
Key
features
Simple.
Safe.
FASB 91 compliance and monthly reporting with
just a few mouse clicks ....
Maintain records in an Excel worksheet provided
with the software.
A single worksheet
Segregate records using
multiple worksheets
Copy, paste a worksheet to the software for calculations
and all monthly reports.
Accelerated discount, premium recognition
for principal paydown, curtailment, partial sale, payback reductions.
Automatic effective
interest rate recalculation due to changes.
Detailed schedule provided for each record:
Separately reported
categories for
Normal month to month premium, discount amortization recognition
Accelerated recognition due to paydown
Applicable "as of" actual paydown date
FASB 91 effective interest
rate calculation:
Calculated for initial values
Recalculated for a paydown
Month end balances and
totals:
Premium
Discount
Par
Accumulated recognition
Carrying balance book value
Accounting reports with subtotals for balancing
to the general ledger. |
|
........
Monthly
Processing
Highlight,
copy, paste the provided Excel template to the software.
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
• 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 effective interest rates
• 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
• Generate current and historical reports
- go paperless
• Export schedules and reports to Excel |
|
...
Your
existing records
Convert
and preserve recognition, accumulated and book values in order to maintain
general ledger status.
Or, the software can
recalculate records from their begin dates employing the effective interest
method.
Software includes an Excel template worksheet.
Copy, paste, enter your
existing and new records.
Column comments provide
detailed documentation, as does the software Help system. |
|
..
Scroll down for samples, price and free software demo ....
... |
|
|
|
