1) On the website above, go to the Yield and Price links, click on them and review how to compute Yield and Price in Excel. Now, create a new sample problem for each and solve your sample problem using Excel.
2) On the website above, review the sections ‘Bond Valuation on a Coupon Date’ and ‘Using the Price () Function. After reviewing each, construct a new sample problem for each and solve your sample problem using Excel.
3) Now, independently of these websites, create and solve in Excel one of each of the following:
a) Price of a zero coupon bond
b) Price of a 30 year bond with 12 years left until maturity
c) YTM of a discount bond
d) YTM of a premium bond
e) YTM of a par bond
f) YTC of a 30 year bond with 15 years until maturity and 3 years until the call date
Please put all this on one Excel document. You can do them on one tab or create tabs for each, that is up to you.