Ключевые слова: Excel, OpenOffice, template, spreadsheet, bond, yield, maturity, calculator, payment, schedule, loans

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.