Bond Yield Calculator Excel Model
  • Bond Yield Calculator Excel Model
  • Bond Yield Calculator Excel Model
Originally published: 19/04/2018 15:18
Publication number: ELQ-17577-1
View all versions & Certificate
certified

Bond Yield Calculator Excel Model

Automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.

bondscalculatorcouponsdebtdebt scheduleyieldyield to maturity

Description
The Bond Yield Calculator 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.

This business tool includes
1 Excel file for Excel 97 or higher

Business Spreadsheets offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

Calculate payment schedules and yield to maturity for bonds

Fixed interest investments

Investments that are not fixed interest in nature

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More tools from Business Spreadsheets

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Bond Yield Calculator Excel Model?

The user community and author are here to help. Go ahead!

please wait...