Ford Motor Company issues a 5-year bond with a coupon rate of 7% and a face value of $100. The bond pays interest semiannually. What is the price of the bond if the yield to maturity is 6% compounded semiannually?
Please provide the excel formula to help with the solution.
The present value of the following bond can be calculated by inserting following vales in the string of present value function in the excel sheet :-
The arguments are :-
Future value :- $100
PMT :- $3.5 SEMIANNUAL coupons of 7%
Nper :- 10 (semmiannual in 5) years
I/Y ( rate) :- 0.03 ( 6 percent rate semmianual)
Type =o
=PV(rate, nper, pmt, [fv], [type])
Present value = $134.6428
I hope this helps.
Please press the like button
Thanks & Regards
Ford Motor Company issues a 5-year bond with a coupon rate of 7% and a face...
5a. Smirch Corp. issues a 7-year bond with a face value of $1,000, an 8% coupon rate, and a yield to maturity of 9%. The bond pays interest semiannually. What is the price of the bond? (4 points) 5b. What will the price of the Smirch Corp. bond be 2 years from today, assuming the yield to maturity remains at 9%? (2 points)
1)A Ford Motor Co. coupon bond has a coupon rate of 7%, and pays annual coupons. The next coupon is due tomorrow and the bond matures 40 years from tomorrow. The yield on the bond issue is 6.15%. At what price should this bond trade today, assuming a face value of $1,000? The price of the bond today should be $ 2) If the nominal rate of interest is 13.07% and the real rate of interest is 7.09 % what...
Suppose Ford Motor Company issues bonds with a face value of $500 and an annual coupon payment of $5 What is the interest rate Ford is paying on the borrowed funds?
A Ford Motor Co. coupon bond has a coupon rate of 6.8%, and pays annual coupons. The next coupon is due tomorrow and the bond matures 28 years from tomorrow. The yield on the bond issue is 6.35%. At what price should this bond trade today, assuming a face value of $1,000?
A Ford Motor Co. coupon bond has a coupon rate of 6.556.55%, and pays annual coupons. The next coupon is due tomorrow and the bond matures 4040 years from tomorrow. The yield on the bond issue is 6.16.1%. At what price should this bond trade today, assuming a face value of $1 comma 0001,000? The price of the bond today should be $
What is the price of a 5-year, 7.5 % coupon rate, $1,000 face value bond that pays interest quarterly if the yield to maturity on similar bonds is 11.6% ? The price of the bond is $_____. (Round to the nearest cent.)
What is the price of a 5 year, 7.6 % coupon rate, $1,000 face value bond that pays interest annually if the yield to maturity on similar bonds is 7.3 %? The price of the bond is $______. (Round to the nearest cent.)
A government bond issued in France has a coupon rate of 7 percent, a face value of 100 euros, and matures in five years. The bond pays annual interest payments. Calculate the price of the bond (in euros) if the yield to maturity is 3.5 percent.
The yield to maturity for a $1,000 face value bond is 7.23%. If the bond pays a 7.23% semiannually compounded coupon for the next 25 years, what is the price of the bond? (Provide solution in dollars and cents, to the nearest cent.)
Consider a 2-year coupon bond that pays coupon annually with a coupon rate of 3%, face value $1000, a yield to maturity of 4%. (a) What is the approximated bond price estimated by both duration and convexity if the yield is increased by 0.5%? (b) Suppose you purchased 1 unit of the above coupon bond mentioned above and is worried if the interest rate will increase. You are considering taking short position on a zero coupon bond. The zero coupon...