1. Work each of the following DCF problems in Excel. You will need to build the Present Value Interest Factor of an Annuity (PVIFA = {1 - 1 / [(1 + i)^n]} / i) and Future Value Interest Factor of an Annuity (FVIFA = [(1 + i)^n - 1] / i) into your Excel spreadsheet. 2. Prepare full amortization and/or investment schedules in Excel in the format as shown in class. Problem 3: Penny Pinchier plans to purchase a sail boat for her spoiled husband. She will make monthly payments to the bank over 10 years. The boat she is looking at costs $235,000. The bank is charging an annual interest rate of 6.24% for 10 years.