V.I.K. Corp. has a credit rating of A and is planning to issue 17-year bonds with a $1000 face value and a 12.25% coupon rate paid semi-annually. Recently, three trenches of 17-year bonds were issued by L.J.K. Corp., a company with a credit rating of A. They offered an 11% coupon rate paid semi-annually and sold at a price of $910. E.N.L. is a municipality with a junk bond rating.

a. What should be the price of a VIK bond when it is issued?

b. What is the current yield of the VIK bond two years later if selling for $1200 at that time?

c. After four years, the price of a VIK bond is $1045. What is the bond's new yield to maturity?

d. Assume you are an investor who bought a VIK bond when issued at the price in a. above and sold it at four years later at the price in c. above, what would be your holding period rate of return?

PLEASE show how to enter this information on Excel, including the equations/functions to solve the information. Thank you! :)