How to do it in Excel

Adjustable Rate Mortgage Problem 5. Assume that you obtain a 3/1 ARM in the amount of $350,000 with an initial interest rate of 4.5%. The loan uses the One Year Constant Maturity Treasury yield (One Year Treasury') as the index rate. The margin is 2.5%. Looking at the table below which forecasts the One Year Treasury, calculate the mortgage payments for each of the years 1-5 (months 1-60). Period One Year Treasury 1st Year 2.0% 2nd Year 2.25% 3rd Year 2.75% 3.35% 5th Year 3.95% OL 1 1 1 1 1 4th year Year 1 Required Payment? Year 2 Required Payment? Year 3 Required Payment? Year 4 Required Payment?- Year 5 Required Payment?- Adjustable Rate Mortgage Problem 5. Assume that you obtain a 3/1 ARM in the amount of $350,000 with an initial interest rate of 4.5%. The loan uses the One Year Constant Maturity Treasury yield (One Year Treasury') as the index rate. The margin is 2.5%. Looking at the table below which forecasts the One Year Treasury, calculate the mortgage payments for each of the years 1-5 (months 1-60). Period One Year Treasury 1st Year 2.0% 2nd Year 2.25% 3rd Year 2.75% 3.35% 5th Year 3.95% OL 1 1 1 1 1 4th year Year 1 Required Payment? Year 2 Required Payment? Year 3 Required Payment? Year 4 Required Payment?- Year 5 Required Payment