Computer Tutoring Logo
Est. 2002
Menu Button

How to calculate monthly loan payments in Excel?


Formula for loan repayments in Excel

You're about to enter into the showroom. You're nervous. Although the sales people are all smiles, in the back of your mind you're wondering if they are going to cheat you by offering a finance package that isn't as accurate as you think.

Beat the financiers at their own game by using the PMT function in Excel to work out what your monthly loan payments should be before you enter the domain of the sales person. Why not do a comparision on different products and offers to see if you are getting the best loan deal and repayment package.

Loan Repayment Exercise file that goes with the video

You may have to click on enable editing in Excel to be able to complete the exercise.