Mar 23, 2013

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...
Jan 20, 2013

Not only is my loan calculator a useful application, but from a training point of view it demonstrates a number of useful formulas. As an example, imagine that you want to purchase a computer. The computer store will provide you with a quote which is valid for 14...
Nov 19, 2012

The PMT function returns the payment amount for a loan based on an interest rate and a constant payment schedule. In the example below, B6 contains a function: =PMT(B3/12,B4,B2) The PMT functions has 3 required arguments (and 2 optional arguments not covered here): 1....