Loan / mortgage calculator template - Excel

Excel comes with a built in template to model loans, the loan amortization template

Right click on a sheet tab - Insert - spreadsheet solutions – loan amortization 

 

  
Input to parameter highlighted in orange and table will be auto populated

Additional monthly payments can also be factored in using the optional extra payments input