are those answers correct and how do i get work shown like the formulas for part 2 using PV function and part 3 using VLOOKUP function.

Excel Assignment 2 In the best that have a wound to be handed with de Colls with a view the point with form You want with an The Par vi 51.000 de in Part1 You can buy the bond today at 51.100 follow the decision Once you at they did to main Part wil matetimeve teleb Starting the contacte acheter Labin Portion towards my wonder of the bonds 9 10 Part 1: Calculating Yield To Maturity (YTM) Yield to My at the end Coupons TTM 1 Price 14 Coupon 30 Coro 16 17 th 19 OM 21 Part 2:Calculating Bond Price with different Time to Maturity (TTM) YIM 24 25 200 1000 Yhto Mar 1 25 45 sis SLOJEVunction to come the bow orice with rent years to maturity. But the same Mod Part 1 MON 10000 20 TEEEEEEEEEE 10 10 1.16 1.22093 1.29 1S 2015 14111 12 33 M 35 16 37 38 39 40 41 42 Part 3: Looking Up a Bond Price From Part 2 Using An Input Time To Maturity TIMP 10031 VIOOKUP function to find the price of the band from Port 2 by looking up the rumber of years to maturity Excel Assignment 2 In the best that have a wound to be handed with de Colls with a view the point with form You want with an The Par vi 51.000 de in Part1 You can buy the bond today at 51.100 follow the decision Once you at they did to main Part wil matetimeve teleb Starting the contacte acheter Labin Portion towards my wonder of the bonds 9 10 Part 1: Calculating Yield To Maturity (YTM) Yield to My at the end Coupons TTM 1 Price 14 Coupon 30 Coro 16 17 th 19 OM 21 Part 2:Calculating Bond Price with different Time to Maturity (TTM) YIM 24 25 200 1000 Yhto Mar 1 25 45 sis SLOJEVunction to come the bow orice with rent years to maturity. But the same Mod Part 1 MON 10000 20 TEEEEEEEEEE 10 10 1.16 1.22093 1.29 1S 2015 14111 12 33 M 35 16 37 38 39 40 41 42 Part 3: Looking Up a Bond Price From Part 2 Using An Input Time To Maturity TIMP 10031 VIOOKUP function to find the price of the band from Port 2 by looking up the rumber of years to maturity