You can follow the discussion on Calculate How many payments are necessary to pay off a loan in Excel without having to leave a comment. Cool, huh? Just enter your email address in the form here below and you’re all set.