Loan Payment - Balance (FV)

This calculates the loan balance (balloon payment) for a real estate loan. Enter four inputs. Enter years remaining (n), interest per year (i), loan amount (PV), and loan payment per month (PMT).

Use no percentage or dollar characters.



Example

You get a loan for $495,000 with an interest rate of 7.25%. The term is 25 years and the monthly payment is $3,577.89.

Payments per year = 12
Years = 25
Interest = 7.25
Amount = 495000
Payment = 3577.89

What's the balance due on the loan after 25 years?

$0


Take the same loan but change the years.

Years = 18

What is the balance due after 18 years of payments?

$235,155


This is a handy way to calculate a loan balance after a certain numbers of payments without using an amortization schedule.