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 Excel bond calculator is designed to handle odd first time periods and is designed to analyze bond payment schedules and accurate yield to maturity calculations. The automatic schedule includes cash flow, discount and principal outstanding for the bond schedule fixed interest security duration. A solving algorithm is employed to calculate the bond yield to maturity to a specified number of decimal places.. The Excel Bond Calculator assists with input by providing automatic schedule creation and embedded help material providing detailed explanations of input and results. The Excel bond calculator creates automatic bond payment and cash flow date schedules and calculates the implied yield to maturity for the bond. The Bond Yield Calculator contains both an Excel and Open Office version with open source code for customization and compatibility across operating platforms.
Comments not found