You are given the following information. All bonds are from the same issuer (same credit risk). Bond Coupon Rate Maturity Price ($) A 6% 1036.17 5% 2 1041.49 6% 3 1074.21 All coupon payments are annual and face values are $1000. Answer the following and express rates as a %, to 2 decimal places a) Determine the 1-, 2- and 3-year spot rates from the given prices (Use the Bootstrapping method). 1- Year Spot rate is 2- Year Spot rate is 3- Year Spot rate is b) Compute the implied annual forward rate from year one to year two, i.e., f2 --> c) Compute the implied annual forward rate from year two to year three, i.e., f3 -->

You are given the following information. All bonds are from the same issuer (same credit risk). Bond Coupon Rate Maturity Price ($) A 6% 1036.17 5% 2 1041.49 6% 3 1074.21 All coupon payments are annual and face values are $1000. Answer the following and express rates as a %, to 2 decimal places a) Determine the 1-, 2- and 3-year spot rates from the given prices (Use the Bootstrapping method). 1- Year Spot rate is 2- Year Spot rate is 3- Year Spot rate is b) Compute the implied annual forward rate from year one to year two, i.e., f2 --> c) Compute the implied annual forward rate from year two to year three, i.e., f3 -->

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter11: Bond Pricing And Amortization (bonds)

Section: Chapter Questions

Problem 3R

See similar textbooks

Similar questions

Calculate the purchase price of the following bonds. Indicate whether the bonds are priced at a discount, at par or at a premium. Give your answers in dollars and cents to the nearest cent. Face Value Coupon Rate Years to Maturity Market Rate a) $100 r = 6.75% 5 j2 = 6.75% b) $1,000 r = 8% 11 j2 = 6.25% c) $10,000 r = 7% 20 j2 = 8.75% Quoted coupon rates and market rates are nominal annual rates compounded semi-annually. a)Price = $ This bond is priced at:a discountpara premium b)Price = $ This bond is priced at:a discountpara premium c)Price = $ This bond is priced at:a discountpara premium
c) Suppose you observe the following three bonds. Assume that all bonds are denominated at $100 face value per contract and that they pay their coupons annually. Price Coupon Maturity (years) Bond A 111.42 15 3 Bond B 108.33 15 Bond C 116.61 15 1 i) Compute the spot rates r0,1, r0,2 and r0,3. ii) Compute the forward rates r1,2 and r2,3.
This first table describes prevailing market interest rates. Market Data Yield 0.05 Required: Using the yield above and the information contained in the table below, please calculate the price and duration of the bond as well as all necessary steps. (Use cells A5 to B5 from the given information to complete this question.) Time Until Payment Payment Discounted Payment Weight Time × Weight 1.00 $30.00 2.00 $30.00 3.00 $30.00 4.00 $1,030.00 Price: Duration
Suppose you are provided with the following table of spot rates of different maturity bonds: Year Spot rate 1 8 2 9 3 7 4 8 5 10 Calculate, respectively, one period forward rates of these bonds for year 2, year 3 and year 4.
Determine the price of a single bond given the following information. Round your final answer to two decimal places. For example, if your answer is $89.12, enter 89.12 with no currency symbol. 4.39% Cost of Debt (Kd) The company is expected to pay the following forecasted CFFD (Cash Flows For Debt): Year 1: $50.00 interest payment Year 2: $50.00 interest payment Year 3: $50.00 interest payment Year 4: $50.00 interest payment Year 5: $50.00 interest payment The company will also pay the bond's face value of $1,000.00 at the end of year 5. The company faces a 25% tax rate. Type your answer...
numerical answers should be calculated to at least two decimal places. Face value of bonds is taken as $100. assume coupon payments are paid once a year. Bond A: term to maturity=10 years, coupon rate = 9.75%, current price = $160.55. Find the current yield and yield to maturity of Bond A. Bond B: term to maturity-5 years, coupon rate = 11.25%, yield to maturity -2.35% p.a. Find the current price of Bond B. From your answer, what do say about this price when compared with the face value of the bond?
A. Table below is information about three USD10000 par value bonds, each of which pays coupon semiannually. The required rate of return on each bond is 14%. Calculate the value of the bonds and determine whether the bond is selling at discount, premium or par value. Bond Coupon Rate (%) Maturity (years) 1 8 5 2 14 10 3 16 15 B. Using the Interpolation Method to calculate the YTM for the below Bonds: > The par value USD18000 > Coupon Rate 10% every year > Maturity period 10 years > Market Value of bond USD21800
Show all workings. Complete the following table and draw a graph showing how bond pricefor each bond changes over time as they move towards their maturitydates. Describe the relationship between bond prices and timeremaining for maturity.YearsreminingtomaturityBOND ACoupon rate = 8% p.a.Market interest rate =6% p.a.BOND BCoupon rate = 6% p.a.Market interest rate =6% p.a.BOND CCoupon rate = 4% p.a.Market interest rate =6% p.a.109876543210
Consider the following bonds: (Click on the following icon in order to copy its contents into a spreadsheet.) Coupon Rate (annual payments) Maturity (years) 13 0% 0% 12 2% 13 8% 12 Bond A B C D a. What is the percentage change in the price of each bond if its yield to maturity falls from 8% to 7%? b. Which of the bonds A through D is the most sensitive to a 1% drop in interest rates from 8% to 7% and why? Which bond is the least sensitive? Provide an intuitive explanation for your answer. Note: Assume annual compounding. a. What is the percentage change in the price of each bond if its yield to maturity falls from 8% to 7%? The percentage change in bond A is 5.47%. (Round to two decimal places.)
Consider the following bonds: . What is the percentage change in the price of each bond if its yield to maturity falls from 6.3% to 5.3%? The price of bond A at 6.3% YTM per $100 face value is $ (Round to the nearest cent.) - X Data table (Click on the following icon g in order to copy its contents into a spreadsheet.) Bond Coupon Rate (annual payments) Maturity (years) A 0.0% 15 В 0.0% 10 3.6% 15 8.4% 10 Print Done
What is the YTM of the bond given the information below. The bond makes annual interest payments. (Do not round intermediate calculations, round answer to two decimals, i.e. 32.16) Coupon Rate:8.4% Maturity (years):6 Current Price: $1,159.63 Par value: $1,000.00
The following information about bonds A, B, C, and D are given. Assume that bond prices admit noarbitrage opportunities. What is the convexity of Bond D?Cash Flow at the end ofBond Price Year 1 Year 2 Year 3A 91 100 0 0B 86 0 100 0C 78 0 0 100D ? 5 5 105