This assignment is in a different direction than your Module 1 Case in that it is mostly computational in nature. Before starting this assignment, work through some of the examples in the background readings to make sure you understand all of the steps involved in future value and present value, including use of present value formulas to compute the value of a bond. Question 4 requires the use of Excel, although you can get partial credit if you solve it instead using a calculator and show all of your work. Go through the videos and sample Excel spreadsheet in the background readings before starting on Question 4. Note that while Excel is only required for Question 4, you may also wish to use it for Questions 1-3. Present your answers to the following problems in a Word document, and include an Excel spreadsheet with your computations for Question 4 or any oth
er questions that you use Excel for. Note that you will get partial credit if you show your work even if the answers are incorrect, and Excel is only required for Question 4 (it is greatly recommended for Questions 1-3 but not required). Also, if you are unable to get up and running with Excel then you can get partial credit by instead using a calculator as long as you carefully show all of your steps in a Word document. Answer the assignment questions directly. For your Module 2 SLP, continue your research on the four companies that you selected for your Module 1 SLP. Whereas you focused on the stocks of each company in Module 1, we will now be looking at the bonds of these four companies. Do some research on credit ratings of the bonds of these companies as well as the yields and bond prices. Specifically, write a two-page paper presenting the following information: