Excel Loan Payment Formula | Excel Mortgage, Home Loan or Car Finance Calculator | Template Download

nn

Microsoft Excel Tips and Tricks

nnIn this Microsoft Excel video tutorial I demonstrate how to calculate monthly repayments on a loan. This is possible in Excel using the PMT function. It is interesting to see how lowering the interest rate and/or term has a big impact on the total interest paid.nnnn

Credit Chester Tugwell

n