One such way is to create a Data table in Excel. Using the PMT function to do the calculations. So what is a data table? Well its basically a cross referencing block of calculated cells that you can ...