Answers are provided, please provide steps to the solutions.

What will be your monthly mortgage payment? 4. You are going to buy your first home. This house you will buy at the current median Charlotte area home price of approximately $190,000. You will put 20% down and finance the remaining 80% of the house value with a 30 -year, fixed-rate mortgage at 4%. c. What will be the balance of the loan at the end of 5 years, 10 years, 15 years, 20 years, 25 years, and 30 years? (The end of months 60 , 120,180,240,300 and 360 , respectively.) \begin{tabular}{l|r} \hline Part c & \\ \hline Loan balance at end of 5 year & 1,37,480.22 \\ \hline Loan balance at end of 10 year & 1,19,751.62 \\ \hline Loan balance at end of 15 year & 98,105.06 \\ \hline Loan balance at end of 20 year & 71,674.68 \\ \hline Loan balance at end of 25 year & 39,403.27 \\ \hline Loan balance at end of 30 year & 0.00 \end{tabular}