Help me solve the below including the Factor table in excel.

You borrow a GPM of $$120,000$ with annual payments and $30-$year term. The interest rate is $10\%.$ The payment rises by $2\%$ each year.

Questions:

$1.$ What are the annual payments for years $1$ to $30?$

$2.$ What is remaining balance at the end of each year?

$3.$ What are the interest payment and principal payment for years $1$ to $30?$