Bond problems in Excel

Reading Time: < 1 minute

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.