You are evaluating the ponds at Starbucks. One pond Starbucks has a coupon rate of 3.60% immaturity 2044 and you require a rate of 4% per year. the current price Starbucks is expressed as $106.25.

a) given this is a US corporate bond (so semi annual payments) what is the value of the bond? ____________

b) what is the yield to maturity of the Starbucks bond? ___________

c) A year ago the yield to maturity of Starbucks was higher than your answer to

b. What factors for Starbucks or the economy would have caused the yield to change? (There is more than one logical answer to this question.)

_______________

please use excel and please please explain not only what formula you used but what you pluged into the formula. excel is still a little new to me so im still trying to learn. thank you in advance!