Site icon The Learning Zone

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

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

Microsoft Excel Tips and Tricks

In 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.

Credit Chester Tugwell

Exit mobile version