In the second scenario, Liam could pay back the loan in $20$ years instead of $15$ and reduce his monthly payments to $$6,000$ with an annual interest rate of $4\mathrm{.}5\%.$ He wants to know the loan amount he should request with those conditions.

In cell H$4,$ insert a formula using the PV function and the monthly interest rate $($cell H$6),$ the loan period in months $($cell H$8),$ and the monthly payment $($cell H$10)$ to calculate the loan amount for the $20-$year scenario.