Example 3: Bond Pricing | |||
Input area: | |||
Settlement date | 1/1/00 | ||
Maturity date | 1/1/17 | ||
Coupon rate | 0.00% | ||
Coupons per year | 2 | ||
Face value | 100 | ||
Yield to maturity | 4.90% | ||
Par value | $ 10,000 | ||
Output area: | |||
Price | |||
To find the bond price, we need to put the following values in the financial calculator:
INPUT | 17x2=34 | 4.9/2=2.45 | 0 | 10,000 | |
TVM | N | I/Y | PV | PMT | FV |
OUTPUT | -4,391.30 |
Hence, Bond Price = $4,391.30
Example 3: Bond Pricing Input area: Settlement date 1/1/00 Maturity date 1/1/17 Coupon rate 0.00% Coupons...
Example 2: Bond YTM Input area: Annual coupon rate 7% Settlement date 1/1/00 Maturity date 1/1/09 Coupons per year 1 Bond price (% of par) 96.150 Face value (% of par) 100 Output area: Yield to maturity
Solution (s) is needed in EXCEL Format (EXCEL Formula only please) Example 2: Bond YTM Input area: Annual coupon rate 7% Settlement date 1/1/00 Maturity date 1/1/09 Coupons per year 1 Bond price (% of par) 96.150 Face value (% of par) 100 Output area: Yield to maturity
Chapter 7 Question 1 Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of €1,000, 23 years to maturity, and a coupon rate of 3.8 percent paid annually. If the yield to maturity is 4.7 percent, what is the current price of the bond 1/1/2000 1/1/2023 For settlement date for the starting date of you owning the...
1. What is the yield to maturity of a eighteight-year, $10,000 bond with a 4.8% coupon rate and semiannual coupons if this bond is currently trading for a price of $8,740? 2.What is the present value (PV) of $100,000 received five years from now, assuming the interest rate is 99% per year? 3. What is the coupon rate of a eighteight-year, $10,000 bond with semiannual coupons and a price of $8,637.58, if it has a yield to maturity of 7.4%?...
A bond has the following terms: January 1, 2000, settlement date January 1, 2020, maturity date 10 percent semiannual coupon 12 percent yield $100 redemption value Frequency is semiannual 30/360 basis =PRICE("1/1/2000","1/1/2020",10%,12%,100,2,0)=84.954 Bond Problems 1. Calculate the price of a 20-year 10% coupon bond with a par value of $1,000. The bond should be price to provide a yield to maturity of 11%. Interest payments are paid semiannually. 2. Calculate the price of a 20-year 10% coupon bond with a...
CIUL wrap Text General Paste Clear B I U Merge % ) ,00 .00 2.0 Cong Form J20 A В D F H K L 1 2 С Bond A has a coupon rate of 4 percent. Bond B has a coupon rate of 9 percent. Both bonds have 14 years to maturity, make semiannual payments and have a YTM of 6 percent. If interest rates suddenly fall by 1 percent, what is the percentage price change of these bonds?...
• Solve for the price of a coupon bond with a coupon rate of 10 percent and maturity of 25 years. The yield on the bond is 5%. Assume annual coupons and face value of $100. Is the bond trading at par?
ANSWER MUST BE IN EXCEL FORMAT - EXAMPLE - =D7+D9/E8
Compute the current bond price.
ANSWER MUST BE IN EXCEL FORMAT - EXAMPLE - =D7+D9/E8
Compute the current bond price.
AB Ninja Co. issued 14-year bonds a year ago at a coupon rate of 6.9 percent. The bonds make semiannual payments. If the YTM on these bonds is 5.2 percent, what is the current bond price in dollars? Assume a par value of $1,000 1/1/2000 1/1/2013 6.90% Settlement date Maturity...
Please help solve using Excel.
BUSCODE OSTERN 1 Input 2 Bond X: 3 Coupon rate 4 Face value 5 Coupons per year 6 Years to maturity 7 Current price 7.0% 100 Need to solve in Excel. 100 7.0% 9 Bond Y: 10 Coupon rate 11 Face value 12 Coupons per year 13 Years to maturity 14 Current price 100 2 Please show formulas. 100 2.096 17 Calculation & Output 18 Question 10 19 Increase in interest rate 20 New YTM...
Problem 1: Consider a $1000 bond with a coupon rate of 10% and annual coupons. The par value is $1,000, and the bond has 5 years to maturity. The yield to maturity is 9%. For each question, show your work/calculations. A. What is the present value of coupons? B. What is the present value of face value (i.e. par value)? C. What is the value of the bond? D. Is it a premium or discount bond? Problem 2: Consider a...