1. Please re-construct the amortization tables of the first and the fifth ARMs C

1. Please re-construct the amortization tables of the first and the fifth ARMs Contained in the excel uploaded (a total of 2 ARMS). In addition, please extend the period from 37 months to 50 months for both ARMs. Please also calculate the IRR and MIRR (FMRR) of each ARM using the 50-month period . Please note that it is 50-month period, not 49-month
2.Please re-construct the amortization table of the graduated payment mortgage ($100,000 at 12 percent for 30 years, graduation in payments through the first 5 years) For this assignment, the annual payment growth rate is 7% per year, the annual interest rate is 18%, and the graduation in payments is for the first 8 years. (This means that the payments from month 97 to month 360 are a constant.) Please report the amortization table of the 360 months, the steps you used to calculate the first-year payment, and a figure plotting the loan balance of the mortgage during the period.