Question

In: Finance

Imagine that you're looking at a bond with a 7% coupon rate, a Face Value of...

Imagine that you're looking at a bond with a 7% coupon rate, a Face Value of $1,000, and 13 years left to maturity. It makes annual coupon payments. How much should we be willing to pay for this bond if you need a yield to maturity of at least 8.4%?

What finance functions do I use on excel?

Solutions

Expert Solution

We need to find price of the bond , we can find it using pv function in excel with input as

Price = PV(rate,n,pmt,fv)

PMT = 7%*1000 = 70

Price willing to pay for bond = 891.74


Related Solutions

Suppose that you bought a five year coupon bond with $20,000 face value, 7% coupon rate...
Suppose that you bought a five year coupon bond with $20,000 face value, 7% coupon rate and 7% yield to maturity. After holding it for a year and collecting the first coupon payment you decide to sell it. Calculate the return (in %) on this investment if the interest rate has increased to 9% while selling the bond.
A. Bond E has the following features:          Face value = $1,000,        Coupon Rate = 7%,        ...
A. Bond E has the following features:          Face value = $1,000,        Coupon Rate = 7%,         Maturity = 5 years, Yearly coupons          The market interest rate is 3.35% If interest rate remains at 3.35% for the life of the bond (i.e., 3.35 years), what is the price of Bond E in year 3? B. Bond A has the following features:          Face value = $1,000,        Coupon Rate = 6%,        Maturity = 10 years, Yearly coupons          The market interest...
You own a bond with the following features: Face value of $1000, Coupon rate of 7%...
You own a bond with the following features: Face value of $1000, Coupon rate of 7% (annual) 10 years to maturity. The bond is callable after 6 years with the call price of $1,054. If the market interest rate is 3.59% in 6 years when the bond can be called, if the firm calls the bond, how much will it save or lose by calling the bond? State your answer to the nearest penny (e.g., 84.25) If there would be...
b) Bond with 10 year maturity, a face value or $1,000, a coupon rate of 7%...
b) Bond with 10 year maturity, a face value or $1,000, a coupon rate of 7% (coupon is paid annually) and assume that the yield to maturity on the bond is 7%. Compute the duration of this bond. c) Next, we are going to analyze the effect of time to maturity on the duration of the bond. Compute the duration of a bond with a face value of $1,000, a coupon rate of 7% (coupon is paid annually) and a...
A bond with face Value =$1,000 with semi-annual payments, a coupon rate of 7%, and has...
A bond with face Value =$1,000 with semi-annual payments, a coupon rate of 7%, and has 8 years to maturity. The market requires a yield of 8% on bonds of this risk. What is this bond’s price?
A bond face value is $1000, with a 6-year maturity. Its annual coupon rate is 7%...
A bond face value is $1000, with a 6-year maturity. Its annual coupon rate is 7% and issuer makes semi-annual coupon payments. The annual yield of maturity for the bond is 6%. The bond was issued on 7/1/2017. An investor bought it on 8/1/2019. Calculate its dirty price, accrued interests, and clean price.
Bond Features Maturity (years) = 7 Face Value = $1,000 Starting Interest Rate 4.78% Coupon Rate...
Bond Features Maturity (years) = 7 Face Value = $1,000 Starting Interest Rate 4.78% Coupon Rate = 4% Coupon dates (Annual) If interest rates change from 4.78% to 5.02% immediately after you buy the bond today (and stay at the new interest rate), what is the price effect in year 5 ? State your answer to the nearest penny (e.g., 48.45) If there is a loss, state your answer with a negative sign (e.g., -52.30)
A 12-year semiannual bond with a coupon rate of 6% has a face value of $1,000 and a YTM of 7%. The price of the bond is
Question 1  A 12-year semiannual bond with a coupon rate of 6% has a face value of $1,000 and a YTM of 7%. The price of the bond isQuestion 1 options:912.85914.25916.36919.71920.57Question 2  A 4-year discount bond with a face value of $1,000 sells at $915. The YTM of the bond isQuestion 2 options:2.24%2.52%2.83%3.21%3.48%Question 3 A 7-year semiannual bond with a face value of $1,000 and a coupon rate of 8% sells at $974. The YTM of the bond isQuestion 3 options:4.3%5.5%6.5%7.2%8.5%Question 4  Consider a...
Compute the duration of a bond with a face value of $1,000, a coupon rate of...
Compute the duration of a bond with a face value of $1,000, a coupon rate of 7% (coupon is paid annually) and a yield to maturity of 7% for maturities of 2 to 18 years in 1-year increments (so here we are going to vary the time to maturity and see how duration changes if N=2, 3 … etc.). What happens to duration as maturity increases?
Compute the duration of a bond with a face value of $1,000, a coupon rate of...
Compute the duration of a bond with a face value of $1,000, a coupon rate of 7% (coupon is paid annually) and a maturity of 10 years as the interest rate (or yield to maturity) on the bond changes from 2% to 12% (consider increments of 1% - so you need to compute the duration for various yields to maturity 2%, 3%, …, 12%) . What happens to duration as the interest rate increases?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT