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?
See for yourself with this handy video guide!
How to calculate monthly loan payments in Excel