Question a explain briefly how you would price the, Ask an Expert

Finance

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.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92766851

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Rose berry is attempting to evaluate her expected return

Rose Berry is attempting to evaluate her expected return over the coming year. She holds shares in the following two companies, 60% in A and the rest in B. Expected Return State Probability of State Company A Company B B ...

Suppose that a zero-coupon bond that matures in 1 year

Suppose that a zero-coupon bond that matures in 1 year costs $97 and that a zero-coupon bond that matures in 2 years costs $94. a) What must be the price of a 2-year coupon bond with a 5% coupon rate? (All face values ar ...

You have just received a windfall from an investment you

You have just received a windfall from an investment you made in a? friend's business. She will be paying you$37,748 at the end of this? year, $75,496 at the end of next? year, and $113,244 at the end of the year after t ...

How to collect data and turn it into information useful for

How to collect data and turn it into information useful for controlling the project. There are five formats in which the majority of data collected would eventually exist. Briefly describe each of the five formats.

If the rate of inflation is 43 what nominal interest rate

If the rate of inflation is 4.3%?, what nominal interest rate is necessary for you to earn a 2.8 %real interest rate on your? investment? ?(Note: Be careful not to round any intermediate steps less than six decimal? plac ...

1 i dont understand what major benefits do corporations and

1. I don't understand what major benefits do corporations and investors enjoy because of the existence of organized security exchanges? 2. What is a dividend? 3. Within a corporation, who decides whether to pay dividen ...

Abc company has projected sales of 19810 in january the

ABC Company has projected Sales of $19810 in January. The sales are expected to grow by 10% each month. ABC's collection schedule is as follows: ABC collects 88 percent of its sales in the month of sale and the remainder ...

Heliocorpular magnetics is currently valued at 32 per share

Heliocorpular Magnetics is currently valued at 32 per share. They are expected to pay a 3.20 dividend, because the dividend has been growing at 5% per year for the past 8 years. Find the dividend yield, the capital gains ...

How could legislation impact on operations within your

How could legislation impact on operations within your organisation in relation to innovation, project management, and operational planning? Briefly outline any relevant requirements (e.g. intellectual property, WHS).

The satellite shoppe has current sales per share of 840 the

The Satellite Shoppe has current sales per share of $8.40. The sales per share are expected to increase at an annual rate of 12%. The historical P/E ratio is 16.2 and the historical P/S ratio is 7.6. What is the expected ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert