Question

In: Finance

An investor purchased a bond at its face value of $2500. The bond stipulates a fixed...

An investor purchased a bond at its face value of $2500. The bond stipulates a fixed nominal interest rate of 8% per year, paid quarterly, over its 5 year life. The investor is thinking about selling the bond after four years for $2200.

A) Draw out the cash flow diagram illustrating this situation (either manually or using Excel).

B) Determine the quarterly IRR, the nominal rate of return, and the effective rate of return if the bond is sold after four years. State the rates as percentages, formatted to two decimal places (i.e., xx.xx%). Briefly describe in plain English what each of these values means.

C) If the investor wants to obtain a nominal interest rate of at least 7% per year for this investment, will she meet her goal if she sells the bond as described above?

(if using excel please post code)

Solutions

Expert Solution

PLEASE FIND EXCEL IN IMAGE FORM.

I have used financial formulas : IRR, EFFECT so caclulate returns

ANY DOUBTS FEEL FREE TO ASK

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

An investor purchased a bond at its face value of $2500. The bond stipulates a fixed...
An investor purchased a bond at its face value of $2500. The bond stipulates a fixed nominal interest rate of 8% per year, paid quarterly, over its 5 year life. The investor is thinking about selling the bond after four years for $2200. a.Draw out the cash flow diagram illustrating this situation (either manually or using Excel). b.Determine the quarterly IRR, the nominal rate of return, and the effective rate of return if the bond is sold after four years....
Exactly two years ago an investor purchased a Portuguese government bond with a face value of...
Exactly two years ago an investor purchased a Portuguese government bond with a face value of EUR 10,000, an annually paid coupon of 5%, a remaining maturity of 10 years, and a YTM of 12%. Today, i.e., two years later, the bond has a YTM of 4%. What is the capital gain in EUR for this investor who bought the bond two years ago and sold it today (rounded to the nearest EUR)?
Exactly two years ago an investor purchased a Portuguese government bond with a face value of...
Exactly two years ago an investor purchased a Portuguese government bond with a face value of EUR 10,000, an annually paid coupon of 5%, a remaining maturity of 10 years, and a YTM of 12%. Today, i.e., two years later, the bond has a YTM of 4%. What is the capital gain in EUR for this investor who bought the bond two years ago and sold it today (rounded to the nearest EUR)?
An investor pays $1,230 for a bond with a face value of $1,000 and an annual...
An investor pays $1,230 for a bond with a face value of $1,000 and an annual coupon rate of 9 percent. The investor plans to hold the bond until its maturity date in eight years. The bond has a yield to maturity of __________ percent. (Note: This question requires a financial calculator.) 5.67 5.39 9.00 10.94
need it asap An investor is considering a bond priced at $953 with a face value...
need it asap An investor is considering a bond priced at $953 with a face value of $1,000. The coupon rate is 9.25% paid semiannually. There are 15 years remaining between settlement and maturity on the bond. Using the Excel YIELD function and the related example in Exhibit 10.2 in Chapter 10, calculate the yield to maturity. Note: Excel requires that bond prices and face values be expressed on 100 point scale so you must divide current price and redemption...
an investor buys a bond having a face value of $1,000 and a coupon rate of...
an investor buys a bond having a face value of $1,000 and a coupon rate of 6% payable semiannually. the market rate is now 3% and the bond natures in 15 Years. How much did the investor pay?
A $5000 face value industrial bond can be purchased for $4920. Its dividend rate is 9%...
A $5000 face value industrial bond can be purchased for $4920. Its dividend rate is 9% and it pays dividends semianually and will mature in eight years. What are the rate of return, and the effective rate of return that the purchaser can expect to receive if the bond is purchased?
An investor purchased a 3 year annual coupon bond one year ago. Its PAR value is...
An investor purchased a 3 year annual coupon bond one year ago. Its PAR value is $1,000 and coupon rate is 6%, paid annually. At the time you purchased the bond, its yield to maturity was 6.5%. The investor sells the bond now after receiving the first coupon payment. (a) What is the annual Realised Compound Yield (RCY) from holding the bond for 1 year if the yield to maturity remains at 6.5%? (b) What if the yield to maturity...
A bond very recently purchased for $9,000 has a face value of $10,000 and a bond...
A bond very recently purchased for $9,000 has a face value of $10,000 and a bond interest rate of 10% per year payable semiannually. The bond is due (matures) in 3 years. The company that issued the bond is contemplating a liquidity problem in 3 years and has just advised all bondholders that if they will keep their bonds for an additional 2 years past the original due date, the bond interest rate for the additional two years will be...
An investor purchases a bond that does not pay a coupon (zero-coupon) with a face value...
An investor purchases a bond that does not pay a coupon (zero-coupon) with a face value of $5,000. Assume the bond’s 8.4% yield to maturity is expected to remain constant over the duration of the bond’s life. What is the rate of return on his investment, if he sells this bond ten years later? Group of answer choices Not enouh information to answer the question 4.20% 6.72% 5.04% 8.40%
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT