Please show computations in Excel formula.

Question 1:

Part 1: An investor purchased the following five bonds. Each bond had a par value of $1,000 and a 7.25% yield to maturity on the purchase day. Immediately after the investor purchased them, interest rates fell, and each then had a new YTM of 5.9%. What is the percentage change in price for each bond after the decline in interest rates? Fill in the following table.

Bond	Price @ 7.25%	Price @ 5.9%	% Change
10-year, 10% annual coupon
10-year zero
5-year zero
30-year zero
$100 perpetuity

Part 2: Last year Carson Industries issued a 10-year 12% semiannual coupon bond at its par value of $1,000. Currently, the bond can be called in 5 years at a price of $1,072 and it currently sells as $1,275.

a. What is the bonds nominal yield to maturity and its nominal yield to call? Would an investor be more likely to earn the YTM or the YTC?

b. What is the current yield? Is the current yield affected by whether the bond is likely to be called?

c. What is the expected capital gains (or loss) yield for the coming year? Is this yield dependent on whether the bond is expected to be called? Explain your answer.

Please show computations in Excel formula.