Solved by verified expert:Greetings ALL, I need people to do a Bond problems in Excel, Requirements are as follows. 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. No Similar Work Accepted, IT MUST BE A UNIQUE WORK FROM YOU. Thanks, The best.
