In this video we use Microsoft Excel's PMT function to build a manual debt repayment schedule, mapping out 12 payments to repay an outstanding balance. Building the debt schedule this way we can see exactly how much of our monthly payments are going to interest, and how much is coming off of the principal (the outstanding balance). This also allows us to plan ahead and stagger payments instead of paying a fixed minimum payment every month, if our budget requires that level of flexibility. Questions/feedback please comment down below ! Thanks for watching :) #excel #exceltips #exceltricks #debtmanagement #finance