Finance 282 - Sample Excel Quiz #1/Test #1 Bond Questions Directions: Utilize the Sample Quiz #1 Bond Spreadsheet Template to answer both questions. Follow all of the directions described below explicitly in completing this quiz. You must transfer your work from the spreadsheet into the appropriate places. The following information is collected from http://reports.finance.yahoo.com as of 2-Dec- 2010. Use it to answer the next two smestions. Assume that both bonds have a dollar face value Bond Center. HOME DEPOT INC SHREVEPORT LA OVERVIEW HSG AUTH MTG REV Price ? 93.14 Coupon (%) 5.400 6.100 Maturity Date 1-Mar-2016 1-Aug-2019 Yield to Mat (%) 2.288 ? Current Yield (%) 4.683 6.550 Fitch Ratings BBB BB Coupon Payment Freq Semi-Annual Semi-Annual Callable No Yes Q1. Determine the price of the Home Depot Inc. bond assuming that it matures in 5.25 years. (Convert $ price to quote based on face value of 100 as last step in the answer.) Note: Where relevant, present value answers should be shown as a negative number. Place the appropriate values in the proper cells in row 3, given the columns as provided below. Provide the EXACT Excel function using cell references throughout. Row Column at. Cpn Rate 2m, rs | Ann Rate | PV PMT FV EXACT EXCEL FUNCTION