please show how to construct the excel workbook and solve questions!! (please show steps to each formula)

1. Construct an Excel Workbook with 5 worksheets labeled in order as follows: Your Name, Amortization, Dynamic Amortization, and Retirement. 2. Consider the following information: a. $18,000 original loan value b. 12.00% annual interest rate c. 5-year loan term d. Payments are made monthly Calculate the monthly payment. In the worksheet labeled Amortization, construct an amortization table. Be sure to label and identify all relevant inputs and outputs. 3. Consider the following information: a. You will work for 40 years and then, retire. b. You will live for an additional 30 years after you retire. c. You estimate that you will need $12,000 per month through your retirement years. d. You want to leave $1,000,000 to your heirs upon your demise. e. You expect to earn 12% on your retirement fund during your working years and) 3% after you retire. Your output (clearly identified and labeled) should be the monthly savings required to meet your goals. For this project, consider only the information and conditions provided. When constructing your worksheets, remember to consider economy and aesthetics. Your worksheets should be labeled so that