|
Bond Valuation
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Description
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Bond is a long-term
promissory note issued by a business or a business firm.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Value of the bond price
is the sum of present value of annuities (or coupon) over the life of the
bond and present value
|
|
| |
of the face value of the bond.
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Bond value or price of
the bond is calculated on the basis of face value, coupon rate, market rate
and maturity period
|
|
|
| |
of the bond.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Parameters
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
1. Face Value
|
|
|
|
|
|
|
|
|
|
| |
Enter Face value of the
Bond
|
|
|
|
|
|
|
|
|
| |
2. Coupon Rate
|
|
|
|
|
|
|
|
|
|
| |
Enter Coupon Rate and
Select Compund(Annually, Semi-Annually, Quarterly, Monthly)
|
|
|
|
|
| |
3. Market Rate
|
|
|
|
|
|
|
|
|
|
| |
Enter Market Rate in
Percentage
|
|
|
|
|
|
|
|
|
| |
4. Maturity Period
|
|
|
|
|
|
|
|
|
|
| |
Enter Maturity Period in
Years and Months
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calculator
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Data Entry
|
|
OUTPUT
|
|
| |
Face Value ($)
|
|
|
|
|
|
Bond Price
|
|
|
| |
|
|
|
|
| |
Coupon Rate
|
|
|
|
|
Number of Payments
|
|
|
| |
|
|
|
|
| |
Market Rate
|
|
|
|
Coupon Factor
|
|
|
| |
|
|
Coupon Amount
|
|
|
| |
|
|
|
|
| |
Maturity Period
|
|
Years
|
|
Months
|
|
Yield
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Case
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
ABC Co. issued 7 year bond with coupon rate of 14
percent payable semiannually. Face Value of the bond is $ 1,000.00.
|
|
| |
Market rate of interest is 14 percent. Calculate
the price of the bond.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Copyright @2010
All Right Reserved by SpreadsheetConverter
|
|
|
http://www.spreadsheetconverter.com
|
|
|
|
|
|
|
|
|
|
|
|
|