please include the formulas in excell!

Chapter 6 Problem 18: Using a Spreadsheet to calculate Bond Values (LG 6-2) What is the bond quote for a $1,000 face value bond with an 8 percent coupon rate (paid semiannually) and a required return of 75 percent of the bond is 648574,847148, 10.519, and 14.87875 years from maturity? Chapter 6 Problem 18: Using a Spreadsheet to Calculate Bond Values (LG 6-2) Student Name: Course Name: Select the red highlighted items below for tips and suggestions to complete this problem. FV(rate,nperpmt.pvtype) Enter today's date to use as the bond's settlement date: 10/28/21 Percent of Face Value 100 Years from Maturity 6.48574 8.47148 10.51900 14.87875 Maturity Date 03/19/28 03/04/30 03/10/32 06/27/36 Annual Coupon Payment (%) 8% 8% 8% 8% Bond Value FUNCTION Required Return 7.5% 7.5% 7.5% 7.5% 100 # # 100 7 100 For hele with the PRICE function cick here ho