Part 1View the video Bond Pricing, Valuations and Functions…
Part 1View the video Bond Pricing, Valuations and Functions at the link below:https://www.youtube.com/embed/tJLR3se4Pa4Complete the missing values in table below using the Excel functions: NPER, PMT, FV, RATE, PV. In Excel leave the PV as a negative number and remember to specify FV (par value) and type parameter (set to 0 for end of period payments) even though they are optional in the Excel formula. Work to 5 decimal places in Excel.Part 2Suppose you are a financial adviser to a young couple that has just married. They are looking to invest the money they were gifted by friends and family on the occasion of their marriage. You can offer them any of the bonds, from Bond B to Bond F, in the above table. Which bond would you recommend for them and why? Remember to include in your answer the trade-off between the different features of these bonds – such as size of coupon, years to maturity and any other relevant features from the table.Your answer should be no more than 300 words.