|
|
| Home > Bond Yield Calculator |
Bond Yield Calculator
Automated bond payment scheduling & yield to maturity calculation |
...Create bond payment
schedules and calculate yield to maturity. |
|
|
|
|
| |
| 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 designed to facilitate bond payment
and yield calculations. |
|
Key features of the Bond Yield Calculator include:
- Simple and flexible input with embedded help icons.
- Provides the ability to specify the decimal place accuracy of bond yield calculation.
- Displays automatic cash flow, discount and principal outstanding amount schedules.
- The Yield to Maturity calculation is fully automated.
- Free and open source code for Excel and Open Office Calc.
|
The Bond Yield to Maturity Calculator download has two separate files:
one for Excel and Neo Office 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. Further
resources for converting Excel VBA projects to OpenOffice Calc Basic 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.
|
|
| Recommended Bond Valuation References |
|
| by Recognized Experts |
|
|
|
| |
|
|
|
| |
© 2012 Business Spreadsheets. All Rights Reserved. Legal | About Us |
|
){kind=link}
