Business

FinanceQ&A Library[EXCEL] Bond price: Pierre Dupont just received a cash gift from his grandfather. He plans to invest in a five-year bond issued by Venice Corp. that pays an annual coupon rate of 5.5 percent. If the current market rate is 7.25 percent, what is the maximum amount Pierre should be willing to pay for this bond? Please use Excel.Question

Asked Mar 7, 2020

47 views

[EXCEL] Bond price: Pierre Dupont just received a cash gift from his grandfather. He plans to invest in a five-year bond issued by Venice Corp. that pays an annual coupon rate of 5.5 percent. If the current market rate is 7.25 percent, what is the maximum amount Pierre should be willing to pay for this bond? **Please use Excel.**

Step 1

The question is based on the concept to calculate market value of a bond, using following function in excel ,

**Rate = Current market rate =7.25%**

**nper = number of payment / maturity = 5**

**Pmt = Periodic payment (5.5%) = $5.5**

**Fv= maturity value = $ 100**

Find answers to questions asked by student like you

Show more Q&A

Q: These bonds were rated AA2 by S&P. Would you consider them investment-grade or junk bonds?

A: Note: For S&P credit rating of AA2 is not there, however, AA+ and below are there in the table p...

Q: Explain how knowing the standard deviation of a security’s historical returns increases an investor’...

A: The question is based on the concept, which establish relation between return and risk for investmen...

Q: The residual dividend approach is the best dividend policy to adopt if a firm’s management wants to ...

A: I believe that, residual dividend policy is a good approach when the management aims at maximizing t...

Q: Clarissa wants to fund a growing perpetuity that will pay $10,000 per year to a local museum, starti...

A: Present value of the growing perpetuity is the amount she needs to fund today This can be calculated...

Q: A firm is considering two mutually exclusive projects, X and Y, with the following cash flows: ...

A: Answer: MIRR of 15.26% of project Y maximizes shareholders value. Calculation of NPV, IRR and MIRR: ...

Q: Now consider the case of another company: US Robotics Inc. has a current capital structure of 30% d...

A: Introduction : after Changing the Debt and Equity Debt = 60% Equity = 40% Tax = 25% Levered Beta = ...

Q: PQR Co. has earnings of $2.66 per share. The benchmark PE for company is 19. What stock price (to tw...

A: Formula:

Q: Moonscape has just completed an initial public offering. The firm sold 6 million shares at an offer ...

A: Total flotation costs will comprise of cost of underpricing absorbed, underwriting spread & othe...

Q: The expected pretax return on three stocks is divided between dividends and capital gains in the fol...

A: Expected Return = E(R) = [D x (1 - TD) + G x (1 - TG)] / P where D = Dividend, G = Capital gain; TD...