You are buying a house today and plan on selling it in exactly $10$ years. You will be paying $$6,171$ on your mortgage every month for the next $10$ years. If you sell your house in exactly $10$ years, what will be your remaining mortgage balance?

Loan Amount$$600,000$

Interest Rate$12\mathrm{.}00\%$

Fully AmortizingTerm $($Years$)30$

What would be your inputs in Excel?$=$F V$($rate$,$nper,pmt$,$pv$)$

Rate:

Nper:

PMT:

PV: