Bond Calculator
This tool has been designed for a wide range of Bond
calculations
for those in the finance industry that struggle with tracking
and
reporting of their Bond portfolio. The current version is setup to
track a portfolio of bonds over a 10 year period.
If the
calculator does not meet your specific needs then let us know what
other requirements or adjustments you have and the XLAutomation team
can provide you with an estimate of those enhancements to the existing
product.
How Does
it Work ?
The Bond information for the
portfolio is entered into the "Bond Data" worksheet. Standard bond
information is required for this entry including End Date, Start Date,
Starting Principal.
Interest
rates for this calculator are the same for all Bonds on a yearly basis
(if a you have a requirement to specify interest rates for each of the
bonds or a group of bonds then this can be included to an enhanced
version of the workbook). The annual interest rate is entered into the
workbook.
Note :The financial year
for the current workbook is based on the US financial year ending in
August.
With
all the data entry completed the calculation of the bonds annual
returns and remaining principal is driven from a single
field the
Financial Year specified at the top of the calculation worksheet.

This
calculator can be customised to any business need so contact the
XLAutomation development team with your specific requirements and we
will advise how we can help you.
Features
- Data entry is via a basic worksheet within the calculation
workbook. Required fields are clearly marked for ease of entry.
- All bonds are included to single worksheet making summaries
and charting on the bond performance very simple.
- Custom functions included to the workbook have been
optimised for speed resulting in fast re-calculations when required.
Price
The licence costs for the Bond Calculator are provided
below. All costs shown are in $AUD.
Product Description
|
Price
|
Buy Now
|
Bond Calculator
- Bond Calculator (Single User Licence)
|
$39 |
 |
For full licensing details please refer to the
End User
Licence Agreement
Free
Trial Download
If you would like to see for yourself how Bond Calculator works the
click on then link below to receive a Free Trial Download.
To receive your Free Trial Download click on this link
Bond Calculator Trial Download