 |
|
|
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 |
|
Straight line method software for Premiums and Discounts
Excel Worksheet
files - Portfolio accounting |
|
Bond accounting software
Monthly. Quarterly. Fiscal and calendar year
reporting and posting totals.
Calculate straight line
- Premium amortization
- Discount accretion
- Issue costs, debt origination fees (bond issuers) amortization
- Acquisition fees (bond purchasers) amortization
- Interest accruals
How it works ....
-
Simply copy worksheet bonds.
-
Paste bonds to the software import screen.
-
Amortization, recognition, posting totals and reports. |
Calculate, amortize dozens, hundreds, thousands of ....
- Municipal bonds
- Corporate
-
Government
- Notes
- Bills
- Other premium, discount instruments
Premium, discount posting totals by:
• Month
• Quarter
• Calendar year
• Fiscal year
|
Sample Excel worksheet ....
Column F is sale or purchase Price. Or other value. The system compares column F to column B and determines premium or discount.
(a column F value of less than 200 is consider to be a percentage of Par)
To recognize issue costs and debt origination fees:
Column O, not displayed, contains issuance costs for amortizing separately, with or without premium and discounts
Software import screen ....
Deferral column = Deferred discount or premium
Jan'2012 = the amount to book for whatever calendar month or period is selected
Book Value = Par + Premium or - Discount balance
|
|
Maintain bond records in one or more worksheets. At any time,
1) Copy an entire worksheet (as if copying one worksheet to another).
2) Paste worksheet records to
the
software
import
screen.
3)
Select
a calendar
month
and calculate:
-
Premium
and
discount
recognition
for an
entire
file
- Issue costs, fee recognition for an entire file
- Interest accruals
-
All
monthly
accounting
reports
-
General
ledger
postings
Direct post and
Allocate to multiple cost and revenue centers
-
Lifetime
amortization
schedule
for any
bond
-
In
a matter
of seconds!
|
Getting started is easy.
No adjusting journal entry required.
Be up and running in no time.
Export calculation results and reports to Excel, other spreadsheet.
For internal use.
Email to outside auditors.
Records retention.
Export reports to a worksheet.
Or save bond worksheets with a unique monthly name.
Import, calculate, report at any future date.
|
During
import, the
software:
-
Determines
premium or
discount amount
-
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
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
recognition
schedule for any
record
Copy and paste
results
elsewhere
Your
existing
records:
Preserve
current general
ledger balances
or the software
can
recalculate
current book
values from each
begin date. |
More
about bond
accounting and
reporting ....
All
monthly reports:
View, print,
export
Subsidiary
listing trial
balance by
general ledger
account
Detailed
records plus
accounting
subtotals
Journal voucher
General ledger
debit and credit
posting summary
recap
General
ledger posting
file preparation
Supports any
chart of
accounts
Issue
costs - separate
amortization
for:
Issuance cost
and charges
Acquisition
fees
Other fees (and
income) to be
deferred but not
included within
premium and
discount
recognition
General ledger
posting account
numbers or
system assigned
defaults
Interest
accruals
Calculate an
accrual for the
current month
only or
Calculate a
total accrued
using an "accrue
from" date
Supports accrue
and accrual
reversal
functions
General ledger
posting account
numbers or
system assigned
defaults
Projections:
Calculate
interest accrual
through end of
year, other
period
Early
maturity, call
date column
Take full
premium and
discount
balances prior
to scheduled
maturity date
System
automatically
finalizes a
record if
redeemed early,
sold, called or
otherwise
disposed
Par
amortization for
sinking fund,
other tracking
purposes
Monthly
amortized
recognition
General ledger
posting account
numbers or
system assigned
defaults
Accumulated
Par balance
Period
calculations
Fiscal and
calendar years
Determine all
balances "as of"
a future month,
EOY period
Determine
income, expense
spanning
multiple months
Allocation
capabilities
Distribute
income, expense
to revenue and
cost centers
|
|
|
|
