Loan Repayment Calculator (PMT & EOMONTH)

In this tutorial I demonstrate how to create a loan calculator. I use Excel 2011 for Mac but it also works just the same in all Windows versions. I use a number of functions including: – TODAY – to calculate today’s date – EOMONTH – to...

Calculate End Date of Loan or Project

**Download this tutorial (zipped PDF)** Not only do spreadsheets excel at calculating numbers, they can also calculate dates too. Imagine that you have taken out a 6-month loan and you want to know when it will be paid off (assuming that it is 6 calendar months from...