An investor is considering purchasing starbucks bond

Assignment Help Financial Management

Reference no: EM132061049

YOU MUST USE TIME VALUE FUNCTINS IN EXCEL FOR ALL TIME VALUE COMPUTATIONS

1. An investor is considering purchasing a Starbucks bond. The bond has a $1,000 face value, an 2.5% coupon rate and matures in 8 years. The bond is rated A and is currently quoted at 93.50

a. If the investor decides to buy the bond today, how much will she pay, in dollars?

b. If the investor has a required return of 5%, what is the most she should be willing to pay for the bond today? Make relevant calculations in Excel so I can see all of your work. All time value computations must be done using the time value functions in Excel.

c. Based on your calculations, should the investor buy the bond or not? Explain your reasoning briefly.

d. On the same day, a McDonalds bond that will also mature in 8 years and has a 3.7% coupon rate is quoted at 100.9. The McDonalds bond is rated BBB. Based on the information you have about the two bonds, why would a rational investor pay more for a McDonalds bond than for a Starbucks bond?

Reference no: EM132061049

Questions Cloud

Which is an example of typical capital budgeting project : Which is an example of a typical capital budgeting project that a company might undertake?

True of bondholders as opposed to stockhoders : Which of the following is true of bondholders as opposed to stockhoders?

Diversification is useful to manage : We can most correctly say that diversification is useful to manage ___ risk

Causes specific risk : Which of the following causes specific risk?

An investor is considering purchasing starbucks bond : An investor is considering purchasing a Starbucks bond. If the investor decides to buy the bond today, how much will she pay, in dollars?

Purchase equipment in order to produce the goods : A firm is introducing a new line of fashion merchandise and needs to purchase equipment in order to produce the goods.

Briefly tell bill about each of those four objectives : Briefly tell Bill about each of those four objectives and why these objectives are so important.

What is the investor required rate of return on the stock : Based on the CAPM, what is the investor’s required rate of return on the stock?

How much will you have in the account after six years : If you deposit $3,000 in a bank that pays 2% interest, compounded semiannually, how much will you have in the account after 6 years?

User Account

All Pages