Question 1: Prepare the amortization schedule for a thirty-year loan of $100,000. The APR is 4% and the loan calls for equal monthly payments. The following table shows how you should prepare the amortization schedule for the loan. a. Beginning Total Interest Principal Ending Month Balance Payment Paymen Payment Balance 1S100,000.00 b. Use the annuity formula to find how much principal you still owe to the bank at the end of the third year. Check that this value is the same you have in your amortization schedule. Suppose that in the beginning of the first month of the fourth year the interest rate decreased to 3%. Modify the amortization schedule in order to interest rate (you should change the values in your schedule that occur after the first month of the fourth year, not the ones before this date). c. consider this change in the Use the annuity formula to find how much principal you still owe to the bank at the end of the fifth year. Check that this value is the same you have in your amortization schedule. d. e. Suppose that in beginning of the first month of the fourth year (month 37) vou are able to Question 1: Prepare the amortization schedule for a thirty-year loan of $100,000. The APR is 4% and the loan calls for equal monthly payments. The following table shows how you should prepare the amortization schedule for the loan. a. Beginning Total Interest Principal Ending Month Balance Payment Paymen Payment Balance 1S100,000.00 b. Use the annuity formula to find how much principal you still owe to the bank at the end of the third year. Check that this value is the same you have in your amortization schedule. Suppose that in the beginning of the first month of the fourth year the interest rate decreased to 3%. Modify the amortization schedule in order to interest rate (you should change the values in your schedule that occur after the first month of the fourth year, not the ones before this date). c. consider this change in the Use the annuity formula to find how much principal you still owe to the bank at the end of the fifth year. Check that this value is the same you have in your amortization schedule. d. e. Suppose that in beginning of the first month of the fourth year (month 37) vou are able to