Please, show excel steps

Below is the loan terms for an Adjustable-Rate Mortgage (ARM) with payment cap:

Initial loan amount: 600,000

Term: 30 years (360 months)

Teaser rate: 3% (first year only)

Margin: 300bps (3%)

Rate adjustment intervals: every year

Market index for year 1: 2.5%; Index for year 2: 3.5%

Payment cap: 6%

Assuming negative amortization is allowed.

Given the loan terms, please calculate the following:

Below is the loan terms for an Adjustable-Rate Mortgage (ARM) with payment cap:

Initial loan amount: 600,000

Term: 30 years (360 months)

Teaser rate: 3% (first year only)

Margin: 300bps (3%)

Rate adjustment intervals: every year

Market index for year 1: 2.5%; Index for year 2: 3.5%

Payment cap: 6%

Assuming negative amortization is allowed.

Given the loan terms, please calculate the following:

a. Year 1 monthly payment

b. Loan balance at the end of year 1

c. Year 2 monthly payment with the payment cap

d. Loan balance at the end of year 2.

Loan Terms \begin{tabular}{|l|r|} \hline Original loan amount & $600,000 \\ \hline Loan terms (in years) & 30 \\ \hline Teaser rate (1st year only) & 3% \\ \hline Margin & 3% \\ \hline Payment cap & 6% \\ \hline \end{tabular} \begin{tabular}{rrrrrrrr} \hline \multicolumn{6}{c}{ ARM monthly payment \& loan balance } \\ \hline & & \multicolumn{5}{c}{ Monthly payment } \\ \hline & & \multicolumn{2}{c}{ Monthly payment w/ } \\ Year & Beginning balance & Annual interest rate & w/o payment cap & \multicolumn{2}{c}{ payment cap } & Ending Balance \\ \hline 1 & $ & 600,000.00 & 3.00% & $1,677.28 & $ & 1,677.28 & $597,843.13 \\ 2 & $ & 597,843.13 & 6.50% & $667,688.06 & $ & 1,777.92 & $615,899.55 \\ \hline \end{tabular} Loan Terms \begin{tabular}{|l|r|} \hline Original loan amount & $600,000 \\ \hline Loan terms (in years) & 30 \\ \hline Teaser rate (1st year only) & 3% \\ \hline Margin & 3% \\ \hline Payment cap & 6% \\ \hline \end{tabular} \begin{tabular}{rrrrrrrr} \hline \multicolumn{6}{c}{ ARM monthly payment \& loan balance } \\ \hline & & \multicolumn{5}{c}{ Monthly payment } \\ \hline & & \multicolumn{2}{c}{ Monthly payment w/ } \\ Year & Beginning balance & Annual interest rate & w/o payment cap & \multicolumn{2}{c}{ payment cap } & Ending Balance \\ \hline 1 & $ & 600,000.00 & 3.00% & $1,677.28 & $ & 1,677.28 & $597,843.13 \\ 2 & $ & 597,843.13 & 6.50% & $667,688.06 & $ & 1,777.92 & $615,899.55 \\ \hline \end{tabular}