The Bond Yield Calculator for Excel or OpenOffice Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.
The model is equipped to handle `odd` first time periods and is ideal to speed up bond payment and yield calculations.
The Bond Yield to Maturity Calculator download has two separate files: one for Excel and Neo Office 2.2.1 and one for OpenOffice or Star Office Calc. The source code in both files is open so that the Excel VBA can be compared to the equivalent OpenOffice Basic code.
This may be useful as a reference for converting Excel VBA applications to OpenOffice Calc Basic as the code represents a good example of both calculation sub routines as well as a dialogue form input interacted with the spreadsheet.
Here are some key features of "Bond Yield Calculator":
· Ease and flexibility of input, with embedded help prompts.
· Ability to specify decimal place accuracy of yield.
· Automated cash flow, discount and principal outstanding schedules.
· Bond Yield Calculator is also offering support for automatic Yield to Maturity calculation.