left.html

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


http://www.TeachExcel.comThis 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: http://www.TeachExcel.com

Channel: Education
Uploaded: November 30, 1999 at 12:00 am
Author: ExcelisHell

Length: 07:24
Rating: 4.6666665
Views: 6885

Tags: excel  how  to  tutorial  loan  payments  pmt()  function  formula  mortgage  calculator  interest  rates  

Video Url:


Embed Code:

Video Comments

c6cole (November 30, 1999 at 12:00 am)
Where can I get the 2nd part to this video? I cant find it or the excel download on the site. :( Thanks
ben75h (November 30, 1999 at 12:00 am)
Thanks Bro, You are great teacher. I wish I had you as my good teacher before. Again, thank you very much!!
adityagusman (November 30, 1999 at 12:00 am)
many thanks for the video, it helps me a lot. I didn't know about the PMT function before.