How to calculate the total number of monthly payments given the amount of loan ($275,000), the annual interest rate (4.35%) and the number of years (30)? I'm confused because I'm trying to use the NPER function but it depends on the PMT and the PMT also depends on the NPER, am I missing something here?

  • 1
    Number of monthly payments = number of years x 12 Mar 2 '15 at 10:01

Assuming the rate is 4.35% nominal, compounded monthly, in Excel the formula would be


resulting in -$1,368.98

You can also use the mathematical formula here:


enter image description here


r = 0.0435/12 = 0.003625
PV = 275000
n = 30*12 = 360
P = r (PV)/(1 - (1 + r)^-n) = 1368.98
  • Hi Chris. I just wanted to say thank you for your detailed math answers ... always helpful. Mar 2 '15 at 14:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.