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.
VERSION HISTORY
- Version 1.0 posted on 2009-10-12
New Release
Program Details
- Category: Business > Investment Tools
- Publisher: ConnectCode Pte Ltd
- License: Free
- Price: N/A
- Version: 1.0
- Platform: windows
EULA
Software License Agreement The Free Bond Valuation Spreadsheet together with its accompanying documentation (referred to as "Software" in this Agreement) is the property of ConnectCode Pte Ltd ("ConnectCode"). By installing or using this Software, you (or you on behalf of your organization) are agreeing to the terms and conditions of this Agreement. This Software is protected under International Copyright Laws. 1. License Grants Free Personal User License The license associated with this Software allows for free personal use only. 2. License Restrictions You may not sell, copy, emulate, clone, rent, lease, adapt, translate, sublicense, decompile, disassemble, otherwise reverse engineer Software except as specified in this agreement. Any unauthorized use shall result in immediate and automatic termination of this license and may result in prosecution. 3. Termination This Agreement takes effect upon your use of the Software and remains effective until terminated. It will be terminated automatically without notice from ConnectCode if you fail to comply with any provision contained here. You agree on termination of this Agreement to destroy all copies of the Software in your possession. 4. Limitation of liability In no event will ConnectCode be liable to you for any damages, including any lost profits, lost savings, or other incidental or consequential damages arising from the use or the inability to use the software, even if an authorized dealer or distributor has been advised of the possibility of these damages. ConnectCode will not be liable to you for any damages if you lose money (or reputation, or any other losses) on your investments or speculations as a result of using or misusing the Software. 5. Warranty Disclaimer ConnectCode disclaims all warranties, whether expressed, implied, or otherwise, including the warranties of merchantability or fitness for a particular purpose. ConnectCode does not warrant that the software is error-free or will operate without interruption.