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

Published: 12 September 2008
on channel: TeachExcel
353,018
1.2k

Excel Courses: https://www.teachexcel.com/premium-co...


More tutorials: https://www.teachexcel.com
Excel Forum: https://www.teachexcel.com/talk/micro...

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:
TeachExcel.com


Watch video How to make a Fixed Rate Loan/Mortgage Calculator in Excel online without registration, duration hours minute second in high quality. This video was added by user TeachExcel 12 September 2008, don't forget to share it with your friends and acquaintances, it has been viewed on our site 353,018 once and liked it 1.2 thousand people.