| |
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.
[Bond
Yield Calculator Screen Shot]
Key features of the Bond Yield Calculator include:
- 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.
- Automatic Yield to Maturity calculation.
The Bond Yield to Maturity Calculator download has two separate files:
one for Excel and NeoOffice 2.2.1 and one for OpenOffice or StarOffice
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. Further
resources for converting Excel VBA projects to OpenOffice Calc Bsic can
be found at the online Excel
VBA to OpenOffice Basic converter and the associated help
forum post on migrating Excel VBA projects to OpenOffice.
|
|
|
