A bond is a financial instrument issued by the government or corporations when they need to borrow money from the public on a long term basis to finance certain projects. Interest payments called coupons are typically paid out to bond holders on a regular basis while the entire loan amount called the Face or Par value is repaid at the end. The public can purchase a bond to collect the regular interests and hold the bond to the end called the maturity date to collect the principal amount. Otherwise, at any time before the maturity date, the bond holder can choose to sell the bond in the market at a market price.

This spreadsheet calculates the Yield to Maturity which is the interest rate that the bond holder receives if he holds the bond to maturity. The spreadsheet distinguishes between the Annual Percentage Rate and the Effective Annual Rate. When people talk about yield to maturity, they typically refer to the Annual Percentage Rate. The Effective Annual Rate basically takes into account the effect of compounding interests of the coupons.

• Bond Yield Calculator 2.0
  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...

• Bonds & Stocks 3.0
  This financial assistant will help you to easily calculate the Price and Yield to Maturity of a bond

• Bonds & Stocks (WM) 3.0
  This financial assistant will help you to easily calculate the Price and Yield to Maturity of a bond. When using stock options section, it will help you calculate the earnings and return of investment when exercising your options (either call or put...

• Savings Bond Tracker 2.6.0
  Track United States Savings Bond Portfolios on your Mac! Track and price EE bonds, I bonds, E bonds, and Savings Notes issued from 1941 to today

• Bond Value Calculator 1.0
  Bond Value Calculator makes it possible to estimate the prices of bullet and callable bonds using the arbitrage-free binomial tree of risk-free short rates model.

• Bond Value Calculator for PPC 1.0
  Bond Value Calculator makes it possible to estimate the prices of bullet and callable bonds using the arbitrage-free binomial tree of risk-free short rates model

• LSL Financial Suite 2.8
  Financial Suite contains 4 financial applications, from Lakshmi Solutions LLC, giving the user many options for performing financial calculations: 1) Cash Flows is a Time Value of Money calculator that allows you to perform complex calculations on...

• LSL Financial Suite (WM) 2.8
  Financial Suite contains 4 financial applications, from Lakshmi Solutions LLC, giving the user many options for performing financial calculations: 1) Cash Flows is a Time Value of Money calculator that allows you to perform complex calculations on single payments, equal payments and growing payments cash flows

• Income Ladder Calculator 1.00
  Use this calculator to create a reliable stream of investment income with ordinary bank CDs, bonds, or other fixed-rate investments.