Problem 2 – Excel: Bond valuation (14 points) Download the a…
Problem 2 – Excel: Bond valuation (14 points) Download the attached Excel file “Problem_2_Template.xslx” (Problem_2_Template-1.xlsx) and answer the questions stated in the Excel file. When you have completed your solutions, please upload the Excel file with your solutions to your e-exam using the name “StudentID_Problem_2.xslx” (e.g., “123456789_Problem_2.xlsx”). When you want to upload an updated version of your solutions, please add a version tag (e.g., “_v2”) at the end of the file name (e.g., “123456789_Problem_2_v2.xlsx”). This problem consists of four parts. Parts a), b), c), and d) yield 3, 4, 4, and 3 points, respectively.