Mortgage Calculator

I have a lot of friends and friends of friends that are in real estate.  More importantly, I have a lot of friends who are home owners or soon-to-be home owners.  And I, too, am trying to navigate this grown-up stuff that includes providing a home for my family. So, it dawned on me the other day and I remembered one of Excel’s cool functions, Pmt().  Given the loan details— amount, interest rate, and term— the function returns the monthly payment.

So I decided to put together a simple Excel Sheet (form, really) that applies this function. It also highlights some of Excel’s other cool features, such as: Read more of this post