Moses Kagan on Real Estate

How to determine what your mortgage payment would be

join the conversation »


As part of WordPress, the software that runs this blog, I can see the search terms that land people on my site. Almost every day, there is someone asking Google something like “what are my payments at 5% on $400,000″. Figured I’d share with you how I estimate those.

If I’m doing a spreadsheet, I just use the “PMT” function in either Excel or Google Docs. But that’s kind of annoying for someone who isn’t a former investment banker / Excel jockey (and you should see me on Power Point…).

Assuming you’re not one of that sorry brother/sisterhood, justĀ go to this websiteĀ here. Plug in the correct loan amount, interest rate and re-payment term (almost always 30 years) and click “submit”. The site will spit out your estimated monthly payment in bold black text.

(Note: I apologize in advance for the ads… it’s a really cheesy site!)


Written by mjkagan

05/18/2012 at 5:03 am

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>