TeachExcel

Rank: 3613 / 5440

2 selected videos

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

http://www.TeachMsOffice.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...

How to find Interest & Principal payments on a Loan in Excel

voir la vidéo

http://www.TeachMsOffice.com

How to find the interest and principal payments on a fixed rate loan in excel. This tutorial will walk you through using the PPMT() and IPMT() functions in excel in order to find out how much of a monthly payment on a loan actually goes to pay off the loan amount and how much is just an interest payment.

To follow along with this spreadsheet as well as to get more free excel stuff such as macros, tutorials, articles, etc. go...