-
How to make a Fixed Rate Loan/Mortgage Calculator in Excel
Posted on August 6th, 2010 3 commentsExcelisHell asked:
www.TeachExcel.com 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 www.TeachExcel.com
JorgeEducation Excel Tips, Fixed Mortgage, Fixed Rate Loan, Free Excel Macros, Free Macros, Loan Calculator, Loan Mortgage, Mortgage Calculator, Pmt Function, Rate Calculator, Spreadsheet Tutorial, Video Tutorial3 responses to “How to make a Fixed Rate Loan/Mortgage Calculator in Excel”
-
Where can I get the 2nd part to this video? I cant find it or the excel download on the site.
Thanks -
ben75h August 11th, 2010 at 16:17
Thanks Bro, You are great teacher. I wish I had you as my good teacher before. Again, thank you very much!!
-
adityagusman August 11th, 2010 at 22:47
many thanks for the video, it helps me a lot. I didn’t know about the PMT function before.
-
c6cole August 9th, 2010 at 17:25