Question

In: Finance

You are considering a 10-year, $1,000 par value bond. Its coupon rate is 8%, and interest...

You are considering a 10-year, $1,000 par value bond. Its coupon rate is 8%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below.

If you require an "effective" annual interest rate (not a nominal rate) of 10.16%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent.

Solutions

Expert Solution

Given about a bond,

Years to maturity = 10

Face value = $1000

coupon rate = 8% paid semiannually

effective annual rate required = 10.16%

So, 1st calculated nominal rate of interest for semiannual compounding

On excel, use formula =nominal(effective_rate,npery)

So, we get nominal rate = nominal(10.16%,2) = 9.91%

Number of payment of the bond = 2*10 = 20

Coupon payment semiannully = (8%/2) of 1000 = $40

So, Price of the bond calculated using formula

Price = PV(rate,nper,PMT,FV) = PV(9.91%/2,20,40,1000) = -880.29

So, fair price of the bond is $880.29


Related Solutions

You are considering a 10-year, $1,000 par value bond. Its coupon rate is 10%, and interest...
You are considering a 10-year, $1,000 par value bond. Its coupon rate is 10%, and interest is paid semiannually. If you require an "effective" annual interest rate (not a nominal rate) of 11.2510%, how much should you be willing to pay for the bond? Do not round intermediate calculations. Round your answer to the nearest cent.
You are considering a 30-year, $1,000 par value bond. Its coupon rate is 8%, and interest...
You are considering a 30-year, $1,000 par value bond. Its coupon rate is 8%, and interest is paid semiannually. If you require an "effective" annual interest rate (not a nominal rate) of 9.4835%, how much should you be willing to pay for the bond? Do not round intermediate calculations. Round your answer to the nearest cent.
You are considering a 15-year, $1,000 par value bond. Its coupon rate is 8%, and interest...
You are considering a 15-year, $1,000 par value bond. Its coupon rate is 8%, and interest is paid semiannually. If you require an "effective" annual interest rate (not a nominal rate) of 7.9945%, how much should you be willing to pay for the bond? Do not round intermediate calculations. Round your answer to the nearest cent. $  
You are considering a 25-year, $1,000 par value bond. Its coupon rate is 10%, and interest...
You are considering a 25-year, $1,000 par value bond. Its coupon rate is 10%, and interest is paid semiannually. If you require an "effective" annual interest rate (not a nominal rate) of 11.58%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent.
You are considering a 25-year, $1,000 par value bond. Its coupon rate is 10%, and interest...
You are considering a 25-year, $1,000 par value bond. Its coupon rate is 10%, and interest is paid semiannually. If you require an "effective" annual interest rate (not a nominal rate) of 9.3275%, how much should you be willing to pay for the bond? Do not round intermediate calculations. Round your answer to the nearest cent.
You are considering a 10-year, $1,000 par value bond. Its coupon rate is 9%, and interest...
You are considering a 10-year, $1,000 par value bond. Its coupon rate is 9%, and interest is paid semiannually. If you require an "effective" annual interest rate (not a nominal rate) of 8.16%, then how much should you be willing to pay for the bond? Present value= payment= future value= annual rate= periods= compounding=
Bond valuation You are considering a 15-year, $1,000 par value bond. Its coupon rate is 8%,...
Bond valuation You are considering a 15-year, $1,000 par value bond. Its coupon rate is 8%, and interest is paid semiannually. If you require an "effective" annual interest rate (not a nominal rate) of 11.06%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. $   
You are considering a 25-year, $1,000 par value bond. Its coupon rate is 9%, and interest...
You are considering a 25-year, $1,000 par value bond. Its coupon rate is 9%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. If you require an "effective" annual interest rate (not a nominal rate) of 9.3%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest...
You are considering a 20-year, $1,000 par value bond. Its coupon rate is 11%, and interest...
You are considering a 20-year, $1,000 par value bond. Its coupon rate is 11%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 11.28%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to...
You are considering a 20-year, $1,000 par value bond. Its coupon rate is 11%, and interest...
You are considering a 20-year, $1,000 par value bond. Its coupon rate is 11%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 7.63%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT