This calculates the years left on a real estate loan. Enter three or four inputs. Enter interest per year (i), loan amount (present value - PV), payment per month (PMT), and/or loan balance (future value - balloon payment - FV).
Use no percentage or dollar characters.
ExampleYou have a loan with interest at 8.0% and a monthly payment of $3,087.26. The original amount of the loan was $400,000. Payments per year = 12 What is the term of this loan? 25 years Suppose there's a balloon payment (balance) on this loan of $100,000. Balance = 100000 How many years until the balloon payment (balance of $100,000) is due? 22 years If you don't know the term of a loan, you can calculate it. |