|
GAAP, FASB compliant
|
|
Bond Accounting
Software for
Purchased Bonds
and Investments
Bond Issuers
Effective
Interest Method,
Level Yield,
Constant Yield
Straight Line
Method
Configurations
and
settings
for ....
|
Effective
interest
rate,
level
yield
accounting
for ....
|
Calendar year and
Fiscal year
reporting.
Simply
change the
dropdown
calendar to any
beginning month,
then "Months to
Calculate" to
desired period,
shown here for
12 months:
January, 2019
through
December, 2019
Activity recap
for an entire
year in a matter
of a few seconds
....
|
Related software:
Merchant
Cash Advance
Discounts
Purchased Loan
Packages
Premiums,
Discounts
Bond Issuers Straight
Line
Bonds
FASB ASC 310-20
Manage and account for:
Municipal bonds
Callable and non-callable bonds, with or
without a call price, with
or without OID
Corporate bonds
Hospital bonds
Agencies
Treasuries
Bills
Notes
GNMAs, MBS, CMOs - account for monthly
remittances, declining par
balances (or
use ASC-310-20 amortization)
Special issues
Other investments with
or without
reductions to par
PIKs - payment in kind with increases to par
Virtually any premium or
discount instrument
having
Fixed rate
Variable
rate
Zero rate
Convertible rate
360, 365, 366 day basis
|
Amortization periods
Any prior, current,
future:
Month
Year
Multiple years, calendar or
fiscal for
Each bond
Totals for all bonds
User defined Group totals
Multiple bond files
Interest and rate calculations:
Purchased interest: Track and account for
interest paid at time of
purchase but not yet due
Accrued interest: Current
month income posting plus
Accrued Receivable Account
balances (for business)
Coupon interest: Cash due this
month:
Coupon interest
Purchased interest
Par due to sale, maturity, call
Total
amount of coupon and purchased interest owed
but not yet due
Earned interest:
Coupon
rate earnings for a period irrespective
of accrual or cash activity
Effective interest rate:
The difference between this and
coupon rate determines level
yield recognition
Constant yield rate: Convertible bond earnings
rate blending original and
convertible coupon rates
Portfolio rate: Dollar weighted average
coupon and effective rates for
all investments
Amortize your investments
Software and bonds reside on your computer
Amortize client investments
Import and calculate a file for/from one or
more clients
Prior periods. Current. Future projections.
GROUP
Group bonds and investments. Obtain subtotals by any category.
Examples:
Group = Lot 123, Lot 456, Lot
789 .... (get subtotals
for each lot)
Group = California, New York,
Florida .... (get
subtotals by each issuance
state)
Group = Broker name1, Broker
name 2 .... (get
subtotals by each different
broker)
Group = 2019, 2018, 2017 .... (get subtotals by
each year of purchase)
Group using any category for which
you require subtotals of all
bonds and investments within each Group
Multiple worksheets.
Maintain bonds and investments in more than one
worksheet.
Import and calculate one worksheet.
Import and calculate some or all worksheets.
Call dates:
Amortize to Maturity date or
Amortize to a Call date
including
Call price other than Par
Callable but not called
Partial
calls, early redemptions
Administrative:
Reconciliation
worksheet for audits and exams
Beginning
balances for Par, Premiums and
Discounts
+ Additions
for the period
- Activity
for amortization, accretion,
reductions to Par
= Ending
Balances
Net Change
summation
Mark to Market report - Book Value vs. Market
Value position
Portfolio value as of any given day
Month-by-month recognition schedule
for each bond. Annual subtotals.
Includes a bond amortization calculator for
"what if" questions
What would happen if I sold an existing bond
today?
Should I buy this new bond?
Software and bonds reside on
your computer, PC, network
sharing system
Copy, export, archive results.
Income and
expense, remaining
balance, book value (cost
basis), earned interest
for each and totals for all records in a
matter of seconds.
From original begin dates
or
Current balances forward, as a conversion
(no journal adjustments)
|
REPORTS ....
• View
• Send to local or network printer
• Automatically export to Adobe
• Automatically export to Excel for internal and
external distribution
Report 1:
Enlarged view of the software import screen
listing
Another view of the Import screen,
primarily so you can sort records by desired
values, such as Coupon rate, Maturity date and
more.
Report 2:
Trial Balance report
Premium, Discount recognition report.
Includes Journal Voucher and General Ledger
Posting file.
Typically for General Ledger Business Version.
Premium amortization and discount accretion will
be recognized for the selected calendar
calculation month. Records will be sorted by the
values in spreadsheet column U general ledger
accounts. Totals will be provided for each
account. Totals will be grouped within Discount
and Premium categories.
A Journal Voucher and General Ledger posting
file will also be created.
For non-business purposes, spreadsheet column U
values can be used to generate subtotals for
other purposes dealing with premiums and
discounts.
Report 3:
Net recap report for calendar month or period
CASH interest +/- Discount, Premium amortization
+/- Net Gain on sale.
Cash coupon interest received during the report
period (the calendar month or number of months)
plus Discount recognition and minus Premium
recognition. The result is NET earnings for the
period based on coupon cash receipts.
Report 4:
Finalized records report
Net Gain or Loss for All records which have
matured or otherwise ended their term.
All records which have reached Maturity date,
Call date, have been Sold, Paid Down to zero,
Redeemed in full or otherwise finished their
term.
Report consists of Net Gain or Loss based on
spreadsheet column M, Gain/Loss on sale and/or
column O, Sale Proceeds.
This report can also be used as a purge list
when beginning a new year. Create a new
spreadsheet with a file name dated for the new
year. Delete records appearing on this report
through the prior year end.
Records will appear in the order they appear in
the spreadsheet in order to facilitate the
above.
ABOUT
COUPON INTEREST: CASH vs. EARNED ....
CASH:
CASH and coupon interest due represent interest
from one coupon payment date to the next.
Actual cash activity and dates need not be
logged (see the following regarding differences
between calculated earned and cash interest
receipts). The system "moves" spreadsheet column
R Payment Due date, along with a prior
due/accrue from date, forward and backward based
on the calendar calculation month.
EARNED:
EARNED interest is the amount to which you are
entitled, typically representing full month
periods but also spanning the entire life of the
record. Interest is always being earned
regardless of whether or not interest is
received as cash (whether it be cash, check,
direct deposit and otherwise). Think of Earned
Interest as having a job where you get paid on
Friday. Come Thursday evening, you have earned 4
days worth of your pay even though you won't get
the cash until Friday.
This system calculates all interest based on
spreadsheet values as they exist when imported.
No calculations, report values or other results
are ever saved from one import to another.
Penny differences will likely arise between
actual cash received and what is calculated by
the system. Substantial differences may need to
be investigated.
Furthermore, coupon interest calculations in
this software should never be used for tax or
other reporting purposes. Instead, obtain and
use the figures provided by the entity
responsible for coupon payment disbursements.
Report 5:
Net recap report for calendar month or period
EARNED interest +/- Discount, Premium
amortization +/- Net Gain on sale.
Earned interest for the report period (the
calendar month or number of months) plus
Discount recognition and minus Premium
recognition. The result is NET earnings for the
period.
Report 6:
Coupon Interest Status report
All coupon interest due since previous payment
minus Cash Due this month.
Requires values in spreadsheet columns R and S
(if columns R and S are blank, records will be
flagged as missing required values).
The system determines the amount of coupon
interest earned through this month including
cash interest due. This furnishes everything
earned and due since prior coupon payment dates.
Records will be sorted by the values in
spreadsheet column T general ledger accounts.
Totals will be provided for each value in
spreadsheet column T.
The report consists of records with a Begin Date
equal to or earlier than the calendar month.
Report 7:
Cash Due this month report
Coupon interest payments plus any par
reductions, sales, maturities occurring this
month.
Requires values in spreadsheet columns R and S
(otherwise, records will be flagged as missing
required values) .
The report includes records having a coupon
payment due date matching the selected calendar
calculation month. The report will also include
interest plus Par for records with a Maturity
date, Sale date or other finalized reason date
falling within the calendar month. Also included
are any Net gain for sold bonds as well as Par
for reductions to Par for the month.
Subtotals are provided based on values in
spreadsheet column T.
The report can be printed and/or exported to
Excel or another spreadsheet, enabling you to
"tick off" cash receivables as they come in (it
is not necessary to update the system with cash
receipts).
Records with a Begin Date later than the
calendar month will be excluded. Records which
have finalized, such as matured or called, in
months PRIOR to the calendar month will be
excluded.
Report 8:
Accrued Interest report (requires General ledger
module)
What was Earned this month. Includes
Journal Voucher and General Ledger Posting File.
Requires values in spreadsheet columns R, S and
T (if columns R and S are blank, records will be
flagged as missing required values).
Typically for business (running this report is
optional and not required for the system to
operate).
The system determines the amount of coupon
interest to accrue for the selected calendar
calculation month. Also provides a "Total
Accrued" which includes applicable Purchased
Interest for balancing to receivable accounts.
Records will be sorted by the values in
spreadsheet column T general ledger accounts.
Totals will be provided for each account. A
Journal Voucher and General Ledger posting file
will also be created.
The report consists of records with a Begin Date
equal to or earlier than the calendar month.
Records which have finalized, such as matured or
called, in or prior to the calendar month will
be excluded.
RECONCILING RECEIVABLE ACCOUNTS: The Accrued
Interest Report provides a subsidiary listing
for general ledger receivable accounts.
CASH INTEREST RECEIVED: Interest receipts can be
posted directly to income.
The Accrued Interest report and Accrued Interest
Reversal report (below) eliminate the need to
reconcile cash receipts to receivable accounts
each month.
Report 9:
Accrued Interest Reversal report (requires
General ledger module)
Reverse accruals for Cash Due that has been
received. Includes Journal Voucher and
General Ledger Posting File.
Requires values in spreadsheet columns R, S and
T (if columns R and S are blank, records will
not appear on this report).
Typically for business (running this report is
optional and not required for the system to
operate).
The system determines the amount of accrued
interest to reverse for the selected calendar
calculation month.
Subtotals are provided based on values in
spreadsheet column T.
Prior month accruals are NOT being reversed.
Reversals are created ONLY for records having a
coupon payment due plus Matured, Called, Sold
and records which Paid off in the selected
reversal month.
Reversal amount consists of accrued interest
previously posted by the system for these
records for ALL months, including Purchased
Interest posted by you.
The system calculates running accrual for bonds
through the preceding month to determine the
amount to reverse (bonds with accrued interest
should not be deleted from the spreadsheet until
reversals have been done).
Records will be sorted by the values in
spreadsheet column T general ledger accounts.
Totals will be provided for each account. A
Journal Voucher and General Ledger posting file
will also be created.
The report consists of records with a Begin Date
equal to or earlier than the calendar month.
Records must also have a Coupon Due date in
spreadsheet column R and a column S code greater
than 0. Records which have finalized, such as
matured or called, in months PRIOR to the
calendar month will be excluded.
Report 10:
Reconciliation Report for any month or annual
period - Beginning balances plus activity for
the period.
Balances at the beginning of the desired period,
plus additions for new records during the
period, minus activity equals ending balances.
Primarily used for reconciling changes to
Balance Sheet accounts.
Report 11:
Market Position Quote report. Compare Market
Quote to Cost Basis calculated as of calendar
'did' day.
The system will compare a Market Quote for a
bond to the Cost Basis calculated as of (TO) the
'dd' date portion of the calendar date. Premiums
and discounts are not recognized for the 'dd'
date.
Determine your portfolio position for each bond,
with a total for all bonds.
|
 |
Price page and free demo .... |
Effective
Interest Method
Click to open and view
Price page
Download a free demo from the Price page
right now. Nothing to install.
Delete at any time.
Straight
Line Method
Click to open and view
Price page
Download a free
demo from the Price page
right now. Nothing to install.
Delete at any time.
Bond file
calculation services
We can calculate a bond file on a one-time
basis.
Premium and discount amortization for a month.
For an entire calendar/fiscal year.
Reports and supportive data are provided in
Excel.
For more information, Email
Bond file calculation services
|
|
|
