Bond Valuation

1) On the website “excel financial function “, 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) 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

Question 2

write a paper comparing real estate investment to other forms of investments. Minimum of 8 pages including references page and a maximum of 12 pages. 12 point font 1-inch margins double-spaced. Please use MLA or APA style.