G$.$ Find the interest rate $($APR$)$ on a $25-$year mortgage with a initial loan amount of $$374,000,$ if the monthly payment is $$2624\mathrm{.}55$ Let's use references for input values; and be sure to annualize the rate!

INPUTS:

OUTPUT:

The goal of the question and Cash flows?

Period

Payment

Loan amount

H$.$ Today is Amy's $24$th birthday. Starting today, Any plans to begin saving for her retirement, which she expects to be at age $66.$ Her plan is to contribute $$5,000$ to a brokerage account each year on her birthday. Her first contribution will take place today. Her final contribution will take place on her $65$th birthday. Her grandpa has decided to help Amy with her savings, which is why he gave Amy $$8,000$ today as a birthday present to help get her account started. Assume that the account has an expected annual return of $9\mathrm{.}6$ percent. How much will Any expect to have in her account at retirement $($on her $66$th birthday$)?$ Hint: think of the cash flow type, annuity DUE.

$\backslash$table$[[$Inputs:$,$Output:$],[$itial deposit:,Future Balance$],[$Contribution:$,],[n$ of periods:,Question and Cash flows?$],[$inual Return:,$],[,5.]]$

Based on your calculation for Amy's retirement problem above, conduct a what$-$if analysis by creating a data table that shows that future balance at various rate of returns, ranging from $1\%$ to $19\%$ by a $2\%$ increment. Also create a $x-$y chart for the table. Be sure to give a chart title and $x-$axis label.