MEWC
FMWC
MECC
EEO
SPEAKER
SPEAKER
Hilary Smart
Hilary Smart is a director based in Operis’s London office and a member of Financial Modelling Institute’s Global Leader’s Council. She has fifteen years of experience in financial modelling and her current responsibilities at Operis include training and process development. She was the winner of the 2013 ModelOff world championships and wrote questions for the competition from 2015-2018. She holds a MMath in mathematics from Cambridge University.
Dec 2 | 09:00 AM - 09:55 AM
How to Use, Model, and Sense Check Debt Amortisation
A practical guide to understanding different types of senior debt amortization, including sculpted repayments, annuities, bullet repayments and cash sweeps. We will talk about the circumstances in which each repayment type might be used. We will go through a practical exercise to model each one, discussing the relevant mathematical principles and how to apply them to achieve efficient model optimization. Finally, we will look at techniques for sense-checking repayments in a model built by someone (or somebot) else.
Learning Objectives
By the end of this session, you will learn how to:
- -How to sculpt debt repayments to a cover ratio
- How to dynamically calculate an annuity amount with variable interest rates
- Key considerations for modelling bullet repayments
- How senior cash sweep repayments flow through the cash waterfall
- Rules of thumb for sense-checking different types of repayments.
OTHER SPEAKERS
Best-Selling Instructor & Learning Experience Designer at Maven Analytics
Excel MVP, CPA, fractional CFO, LinkedIn learning instructor, CEO of Mighty Digits.
MS Excel MVP, 2x Financial Modeling World Champion: 2014, 2021; 4x runner-up: 2016, 2020, 2022 and 2023.
Founder & CEO of Financial Modeling World Cup, Master Financial Modeler, Chartered Financial Analyst
Executive Director at Financial Modeling Institute, Chartered Financial Modeler
MS Excel MVP, Founder of Microsoft Excel Collegiate Challenge, Associate Professor of Finance at the University of Arizona, Financial Modeling World Championship finalist
OUR SPONSORS
OUR PARTNERS
