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.
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.