http://www.excelfunctions.net/Excel-Financial-Functions.html
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.
http://www.tvmcalcs.com/index.php/calculators/apps/excel_bond_valuation
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.