Create an excel spreadsheet that shows 1. The calculation of bond issue price. Show the PV of interest payments and the PV of the lump sum (maturity value of bond), then show final bond issue price. You will have 3 different bond issues (one with discount, one with premium, and one at par). Each scenario should be in a separate tab of the excel file. Ideally you should use formulas and be able to change the parameters of the problem and the second and third scenarios only require copy and paste and changing input fields. (Market rate of interest is the only changing parameter. 2. The amortization table for each scenario. You can do the columns like our book does. If you prefer to include a discount or premium account, you may do that as well. 3. Use formatting tools to make your excel file look professional and user-friendly. In the end you should have 3 worksheets in one excel file. Here is the data: On January 2, Donald Corp. iIssued 700, $1,000 bonds to finance a new building. They are 10-year, bonds paying interest on July 1 and December 31 each year. The stated rate of interest = 6%, when issued, the market rate of issue was: Scenario 1: 8% Scenario 2: 4% Scenario 3: 6% Upload your file here