Youtube Linkedin Twitter RSS
Automating Business Through Excel Soloutions
Contact Us | Newsletter | Blog | Members    +61 (7) 5641 2111
Bond Calculator PDF Print E-mail
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.

Bond Value Calculator

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.

Bond Rates Calculation
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.

Bond Calculator Report

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

  1. Data entry is via a basic worksheet within the calculation workbook. Required fields are clearly marked for ease of entry.
  2. All bonds are included to single worksheet making summaries and charting on the bond performance very simple.
  3. Custom functions included to the workbook have been optimised for speed resulting in fast re-calculations when required.

Just for You

If the Bond 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.

Price

The licence costs for the Bond Calculator are provided below. All costs shown are in $AUD.

Product Description
 Cost Purchase
Bond Calculator (Single User Licence) $39 (AUD) Buy Invoice Generator

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.

btn-freetrial