Please re-construct the Variations in Amortization Method I & II table, we used

Please re-construct the Variations in Amortization Method I & II table, we used

Please re-construct the Variations in Amortization Method I & II table, we used in the class (15 years amortization period, rates change in first 3 years and the rate is fixed from year 4) by changing the interest rates of year 1, year 2, year 3, year 4 and year 5 to 2%, 3% 4%, 5% and 6%, respectively. The first three years are interest only mortgage. The borrower starts to pay principal from year 4. The interest rate is then fixed at 10% from year 6 to year 19.
2. Please re-construct the Variations in Amortization Method III table, we used in the class (negative amortization, 10% contract rate, 15 years amortization period, rates change in first 3 years) by changing the interest rates of year 1, year 2, year 3, year 4, year 5 and Year 6 to 0.5%, 1%, 1.5%, 2%, 2.5% and 3%, respectively. The interest rate is then fixed at 11% from year 7 to year 25. Please also change the contract rate from 10% to 11%.
3. Please re-construct the Monthly Amortization, we used in the class (12% interest rate, 3 years amortization period) by changing the interest rate to 18% and amortization period to 33 years. Please report both the monthly cash flows (396 periods) and annual cash flows (33 periods) based on the monthly payments.
The file I uoloaded, contains the original version of the table, and the one I tried to done. Use whichever sheet to finish the task above.