Look no further and copy this project planner template in your Excel workbook ... You can enter loan amount, annual interest rate, load period in years, number of payments in a year, start date, ...