Individual Assignment # 1 consists of 2 questions.

 Q1 accounts for 6 points and asks you to determine the monthly payment, ending balance, and to generate the amortization table for an ARM with interest rate caps.

 Q2 accounts for 4 points and asks you to determine the monthly payment, ending balance, and to generate the amortization table for an ARM with payment cap. Both of the 2 questions are included in this Excel file with the instructions. Please download this Excel file, use the tables in this Excel file to do the calculations and to complete this assignment. Upon completing these two questions, please upload your Excel file (with your answers) here.