Microsoft Excel offers a simple tool to make this task easier: the PMT function. This function allows you to calculate the monthly ... with the simple example in the spreadsheet above. Suppose you ...

simply subtract the $271 from your principal and run the calculation again with the new loan amount. You can use a spreadsheet tool like Excel to make it easier to calculate your full amortization ...