That’s what we are discussing today: Two helpful Excel formulas ... can save by paying off a loan early). Note that this is built into our mortgage calculator spreadsheet template.

You can better observe this by trying out a compound interest calculator in Excel ... Let's demonstrate this with the spreadsheet above. Imagine you've taken a loan of $15,000 (PV) at an annual ...