Let’s say your outstanding balance is $200,000, your interest rate is 5% and you want to pay off the balance in 60 payments – five years. In Excel, the formula is PMT(interest rate/number of payments per year,total number of payments,outstanding balance). So, for this example you would type =PMT(. 05/12,60,200000).
【How-to】How big of a house can i afford
|
