finance assignment 44

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.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.