Suppose you invest $5,000 at an annual interest rate of 5%, compounded monthly over ... these inputs, Excel predicts it will take approximately 36.5 months to pay off the loan. Useful, right? You can ...

Shaun from Spreadsheet Point shares the two most helpful personal finance functions in Microsoft Excel ... monthly contributions) and how quickly you can pay off a loan. They might seem complicated, ...