Welcome to a 5-part video series on the “Must-have Excel Functions for Financial Modelling”. Often the most complex part of a financial model is the debt calculations and in part 3 of this series, we take a look at some of the Excel functions that can help with calculating the debt repayment on a loan schedule.

Watch as Microsoft MVP, Danielle Stein Fairhurst demonstrates how to use the PMT function to calculate debt repayments and then split these into interest and principal components using the IPMT and PPMT functions. We then create a 5 year debt schedule using these techniques.

Follow Danielle Stein Fairhurst on LinkedIn