PLEASE SOLVE WITH EXCEL AND SHOW ALL STEPS.

$*$The answers in the boxes are correct, and the correct yield for part b is $9\mathrm{.}65\%.$ I cannot find the answers for years $2-5.$ Please provide detailed steps in excel.

QUESTION:

Assume that a lender offers a $30-$year, $$159,000$ adjustable rate mortgage $($ARM$)$ with the following terms:

Initial interest rate $=7\mathrm{.}5$ percent

Index $=$ one$-$year Treasuries

Payments reset each year

Margin $=2$ percent

Interest rate cap $=1$ percent annually; $3$ percent lifetime

Discount points $=2$ percent

Based on estimated forward rates, the index to which the ARM is tied is forecasted as follows: Beginning of year $($BOY$)2=7$ percent;

$($BOY$)3=8\mathrm{.}5$ percent; $($BOY$)4=9\mathrm{.}5$ percent; $($BOY$)5=11$ percent.

Required:

a$.$ Compute the payments and loan balances for the ARM for the five$-$year period.

b$.$ Compute the yield for the ARM for the five$-$year period.

Complete this question by entering your answers in the tabs below.

Required A

Compute the payments and Ioan balances for the ARM for the five$-$year period.

Note: Do not round intermediate calculations. Round your final answers to the nearest whole dollar.