What is the yield on a $100,000 adjustable-rate mortgage loan? The starting interest rate is 7%, 30-year term, adjustment interval is 1 year. There are no caps or floors on interest or on payments (unrestricted). The margin over the index is 2% and there is a $2,000 loan origination fee. The index rates are provided in the excel Workbook below. Use this excel workbook to help you solve this problem: Ch5 homework ARMS Q1 Workbook.xlsx x & fox A B D E F G Loan assumptions Amount $100,000 Initial rate 7.00% Term Payments per year 12 Margin 2.00% Fees $ 2,000 30 years Year Index Rate Payment Balance Cash flow 7.00% 1 2 3 4 5 8.00% 10.00% 12.00% 13.00% Yield based on annual cash flows Yield What is the yield on a $100,000 adjustable-rate mortgage loan? The starting interest rate is 7%, 30-year term, adjustment interval is 1 year. There are no caps or floors on interest or on payments (unrestricted). The margin over the index is 2% and there is a $2,000 loan origination fee. The index rates are provided in the excel Workbook below. Use this excel workbook to help you solve this problem: Ch5 homework ARMS Q1 Workbook.xlsx x & fox A B D E F G Loan assumptions Amount $100,000 Initial rate 7.00% Term Payments per year 12 Margin 2.00% Fees $ 2,000 30 years Year Index Rate Payment Balance Cash flow 7.00% 1 2 3 4 5 8.00% 10.00% 12.00% 13.00% Yield based on annual cash flows Yield