MUST BE DONE ON EXCEL USING FORMULAS

4) For this question you will be using the FINRA website we reviewed in class. The link to the website is on slide 35. Your task will be to select two different bonds. The bonds must be issued by different companies and should not be the same bonds as your friends have selected. I recommend just randomly selecting bonds as the best approach. For each bond answer the following: What is the organization's name? What is the bond's symbol? What is the coupon rate? What is the last price? What is the last yield? What is the bond type? What is the bond rating (not all bonds are rated)? Is the bond callable? Based on the information you gathered, which bond would you invest in and why? There is not a right or wrong answer to this question, you but should have logic behind your