Bond Yield Calculator

Bond Yield to Maturity and payment calculator for Excel and OpenOffice Calc.

The Bond Yield Calculator for Excel or Open Office Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity. The bond yield to maturity calculator is designed to handle odd first time periods and is ideal to analyze bond payment schedules and yield to maturity calculations. The Bond Yield Calculator assists with input by providing automatic schedule creation and embedded help prompts. The number of decimal places can be specified to yield to maturity calculation. The automatic schedule includes cash flow, discount and principal outstanding for the bond schedules. A solving algorithm is employed to calculate the bond yield to maturity. The Bond Yield Calculator contains both an Excel and Open Office version with open source code for customization and compatibility across operating platforms.

Changes: Compatible with Microsoft Excel 2016 for Windows and Mac

Minimum requirements: Requires OpenOffice or Microsoft Excel 97 or higher

Operating system: Win2000,WinXP,Win7 x32,Win7 x64,Windows 8,Windows 10,WinServer,WinOther,WinVista,WinVista x64

Program URL: http://www.business-spreadsheets.com/bondytm.htm

Video: https://www.youtube.com/watch?v=az0rK3JREjM

G+ Linikedin Twitter Facebook

Bond Yield Calculator screenshot

...

The Bond Yield to Maturity calculator for Excel and OpenOffice Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.

Special permissions

You are able to make multiple copies of this model on the same computer. It is recommended to make a copy of the model before use so that an original 'clean' copy is accessible without the need to download a new one.

EULA

Business Spreadsheets MAKE NO REPRESENTATIONS OR WARRANTIES OF ANY KIND, EXPRESS OR IMPLIED, AS TO THE OPERATION OF THIS SOFTWARE OR THE INFORMATION, CONTENT, MATERIALS, OR SERVICES INCLUDED WITHIN IT. YOU EXPRESSLY AGREE THAT YOUR USE OF THIS SOFTWARE IS AT YOUR SOLE RISK. TO THE FULL EXTENT PERMISSIBLE BY APPLICABLE LAW, Business Spreadsheets DISCLAIM ALL WARRANTIES, EXPRESSED OR IMPLIED.

Read more