Explain the advantages of using the XIRR function

Assignment Help Finance Basics

Reference no: EM131928192

Question: (a) Explain briefly how you would price the following German government bond: it has a coupon of 1.4% payable annually, has a term to maturity of 6 years, and currently yields 1.7%. What Excel formula would you use to calculate the bond's price?

(b) What would happen to the bond's YTM if (i) the coupon rate were lower and (ii) the bond's price were lower? Explain your answers.

(c) Explain the advantages of using the XIRR function rather than the IRR function for calculating a bond's yield to maturity. Write out the standard format of the XIRR function.

Reference no: EM131928192

Questions Cloud

Prepare appropriate journal entry for b to record income tax : Prepare the appropriate journal entry for B to record the income tax provision for the current year. Show well-labeled supporting computations

Explain why a person starting up a small business : Explain why a person starting up a small business probably stands a better chance of raising money by applying for a bank loan than by issuing bonds.

What is the firm accounts receivables turnover : What is the firm's accounts receivables turnover? (Give your answer up to two decimal places)

Calculate the expected value of return : Integrativelong-Expected return, standard deviation, and coefficient of variation An asset is currently being considered by Perth Industries.

Explain the advantages of using the XIRR function : Explain the advantages of using the XIRR function rather than the IRR function for calculating a bond's yield to maturity.

Explain in words why the present values would be higher : If the interest rate is 4 percent instead of 6 percent, please explain in words why the present values would be higher.

How the bond price will be expected to adjust across time : Given the problem above, identify how the bond price will be expected to adjust across time as the bond approaches maturity.

What is weekly economic profit : If John's weekly accounting profit is $1,000 per week, what is his weekly economic profit? Was this a good decision for John?

What is the price of a 10 month forward contract to buy : If the spot exchange rate is 1.5 dollars per pound, what is the price of a 10 month forward contract to buy the British pound?

User Account

All Pages