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.
Free Bond Valuation Spreadsheet is a free software application from the Investment Tools subcategory, part of the Business category.
The app is currently available in English and it was last updated on 2009-10-12. The program can be installed on Windows2000, WinXP, Windows2003, Windows Vista Starter, Windows Vista Home Basic.
Free Bond Valuation Spreadsheet (version 1.0) has a file size of 95.47 KB and is available for download from our website.
Just click the green Download button above to start. Until now the program was downloaded 275 times.
We already checked that the download link to be safe, however for your own protection we recommend that you scan the downloaded software with your antivirus.