This homework question requires that you complete the Excel file entitled "HW#2 Template Spring2019.xlsx found on Courseweb. Once you have completed it, print it and attach it to your homework submission with the first six questons. You just won a prize of S5,000 at the local talent show. You can receive the money all up front (t-0), or get a series of monthly or weekly payments as described below. In all cases, your discount rate is 5% APR (annual percentage rate),You may choose to get 39 monthly payments, with the first payment starting 4 months from now. Using an annuity formula, calculate the monthly payment that makes you indifferent between receiving the S5,000 all up front or in monthly installments as described above. This formula should appear in Box 1 on the spreadsheet and give the monthly payment amount. You must check this result by completing the table and summing all the present values of this monthly amount in Sum Column 1; the total of the values in this Column should equal $5,000 a. b. Across town, your friend has entered a similar contest, but the prize money payout schedule is already set: $135 today, followed by 39 monthly payments that grow this original payout at 3% APR (40 payments in all). Your friens discount rate is 6% APR. (Assume all compounding is annual). What NPV does your friend receive from the prize? To do this, you must add the first $135 payment to the PV of all 39 of the future payments, determined by using a growing annuity formula. This formula should appear in Box 2 on the spreadsheet You must check this result by completing the table and summing all the present values of the 40 monthly amounts in Sum Column 2 APR 5% 135 APR 6% S 5,000 Prize First Installmen S 39 Monthly Payments; Delayed star Check PV $ of this column 40 Monthly Payments;Start Immediatel Check PV $- of this column APR of Prize Growth 3.00% Step 1 FV of $5,000 prize at t-3 months Step 1 Step 2 TOTAL 35.00 PV of "Instantaneous Payment Box 1 Box 2 Step 2 Monthly Annuity PV of Monthly Growing Annui #VAI- Sum Nominal Monthly Monthly Discount Column 1 Nominal Monthly Sum Monthly Discount Column 2 Factor Pmt Eactor Pmt PV 135.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4 10 12 18 18 19 20 21 21 23 24 25 26 27 28 23 24 25 26 27 28 32 32 34 35 36 37 38 39 40 34 35 36 37 39 42