need help with getting the answers.

LAER In the tables below.cells that have a white background are to be hard coded with data. Cells with a yellow backround must be populated with formulas You are given a year bond with 4 years remaining to maturity. The Par value is $1,000 and the coupon is paid annually in wt1 You sou can buy the bond today at price of 51,104.00, follow the directions in column to calculate the yield to maturity for this bond today with 4 years remaining Once you calculate the visto maturity in Part 1, in Part 2. You will calculate the prke of the bond using the same yield to maturity at different points in time over the fear the bond Starting incl 25, use the function to calulate the price of the bond at each of the maturities listed using your vield to maturity from Part 1 Lastly, in Part , in 173 use the Vlookup function to allow a user to enter a number of years to maturity in Cell 123 and return the price of the band calculated in Part 2 1 Part 1: Calculating Yield To Maturity (YTM) Yield to Maturity Par = Par/face value of the bond. Coupon rate (%) = Coupon rate in % TTM (Yrs) = Time to maturity in years Price = Bond value or price Coupon payment ($) = Coupon payment per period ($) - Par * Coupon rate YTM= Use Rate Function to Calculate Yield to Maturity. Part 2: Calculating Bond Price With different Time to Maturity (TTM) ON YIM Par Coupon Function to Culote the bond with different years to mowity, but the same YIM coin one 21 22 21 24 25 26 27 211 20 10 11 12 13 34 ON ON 1 2 13 5 2 10 15 20 25 30 ON ON ON ON Part 3: Looking Up a Bond Price From Part 2 Using An Input Time To Maturity TIM Price Years To Matary use the VLOOKUP function to find the price of the bond from Part 2 by looking up the number of years to murity entered in C123 17 38 39 10 11 12 3