| 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 | |||
Please provide rating..
| Given that- | ||||
| Annual coupon rate | 7% | |||
| Settlement date | 1/1/2000 | |||
| Maturity date | 1/1/2009 | |||
| Coupons per year | 1 | |||
| Bond price (% of par) | 96.150 | |||
| Face value (% of par) | 100 | |||
| Put in financial calculator | ||||
| PV | -96.15 | |||
| FV | 100 | |||
| PMT=100*7% | 7 | |||
| N | 9 | |||
| Compute I | 7.61% | |||
| Therefore Yield to matutiry = | 7.61% | |||
Example 2: Bond YTM Input area: Annual coupon rate 7% Settlement date 1/1/00 Maturity date 1/1/09...
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
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
ANSWER MUST BE IN EXCEL FORMAT - EXAMPLE - =D7+D9/E8
Calculate the YTM.
ANSWER MUST BE IN EXCEL FORMAT - EXAMPLE - =D7+D9/E8
Calculate the YTM.
1/1/2000 1/1/2018 7.10% Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) 100 105 Complete the following analysis. Do not hard code values in your answers. 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...
The yield to maturity on 1-year zero-coupon bonds is currently 7%; the YTM on 2-year zeros is 8%. The Government plans to issue a 2-year maturity coupon bond, paying coupons once per year with a coupon rate of 9%. The face value of the bond is $100. a. At what price will the bond sell? b. What will the yield to maturity on the bond be? (Hint: Use a financial calculator to get the YTM) c. If the expectations theory...
Sqeekers Co. issued 15-year bonds a year ago at a coupon rate of 4.1 percent. The bonds make semi-annual payments and have a standard par value of $1,000. The YTM on these bonds is 4.5 percent. What is the current price of the bond? Settlement date (MM/DD/YYYY) Maturity date (MM/DD/YYYY) Years to Maturity (# of years) Coupon rate (%) Coupons per year (# per year) Face value (% of par) Yield to maturity (%) Par value ($)
Calculate the YTM.
ANSWER MUST BE IN EXCEL FORMULA FORMAT
A Stone Sour Corp. issued 20-year bonds two years ago at a coupon rate of 7.1 percent. The bonds make semiannual payments. If these bonds currently sell for 105 percent of par value, what is the YTM? 1/1/2000 1/1/2018 7.10% Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) 100 105 Complete the following analysis. Do not hard code...
pleas the answer using excel
Bond B Settlement Date Maturity Date Coupon Rate Required Return (YTM) Redemption Value Frequency Basis 28/3/19 15/8/34 10.00% 8.00% 1,000 Modified Duration Convexity Predicted % Change
Bond B Settlement Date Maturity Date Coupon Rate Required Return (YTM) Redemption Value Frequency Basis 28/3/19 15/8/34 10.00% 8.00% 1,000 Modified Duration Convexity Predicted % Change
The spreadsheet shows you how to calculate invoice price for 6-year maturity bond with a coupon rate of 2.25% (paid semiannually). The market interest rate given is 7.9%. Now, please modify the spreadsheet and calculate invoice price of bond with 6.25% coupon (paid semiannually), settlement date July 31,2012, maturity date May 15, 2030, YTM 7.9%. 2.25% coupon bond, maturing July 31, 2018 Formula in column B Settlement date 7/31/2012 =DATE(2012,7,31) Maturity date 7/31/2018 =DATE(2018,7,31) Annual coupon rate 0.0225 Yield to...
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...