How to make a Fixed Rate Loan/Mortgage Calculator in Excel

This video tutorial will show you how to make a fixed rate loan or mortgage calculator in excel. It is actually quite easy to do and after watching this step-by-step example and walk-through, you will be able to make your own also. This tutorial uses the PMT() function to calculate the required payments and it is also explained in the tutorial.

To follow along with the spreadsheet seen in the tutorial or to get some free excel macros or tips & tricks, go to the website:

24 Replies to “How to make a Fixed Rate Loan/Mortgage Calculator in Excel”

  1. I found a way to make money online.
    Check this website Money94.Com
    I subscribed to the website and after 15 days using the System
    I will able to make at least $500 a month. Now I am working with this system for last three months and my current income is $3000 a month, by using the system part Time. I got all the tools and training that I need to build my online business Empire. Currently I am totally focused to achieve the goal of earring at least $10,000 a month at the end of this year.
    

  2. Hey dude, cool videos. Only problem for me is… now which one is the next video? — would be cool if you had one of does pop up things at the end that said "click here for next video)

  3. CAVEAT: Hi ExcelisHell, be careful of the monthly rate. If the annual rate is APR then the monthly % rate, is APR/12.= 6.5%/12=.5416%, If the annual rate is expressed as "Effective Annual Rate" then the formula is what is given in the tutorial, Monthly rate = [(1+r) ^(1/M)]-1

Leave a Reply