- January 30, 2019
6:00 pm - 8:00 pm
Financial modellers, particularly those working in project finance need to be able to calculate accurately the principal repayments such that the debt repayments will fit the cash flows expected during life of the project. A well-built financial model will contain a debt sculpting module which will accurately predict numbers such as CFADS (cash available for debt servicing), DSCR (debt service cover ratio) and LLCR (loan life cover ratio). Hear from investment banker Alex McNee as she explains why debt sculpting is such an important skill for financial modellers to master, walks us through a debt module and sculpts the principal amortisation to achieve a perfectly flat DSCR to maximise debt capability – and how to avoid using the goal seek or macro to achieve this!
• About your Speaker
Alex McNee is an Associate Director at Ironstone Capital, and was previously a Vice President of MUFG, specialising in tax and financial structuring of PPPS and PF transactions. Connect with Alex here: https://www.linkedin.com/in/alex-mcnee-63068017/
• About your Host
Danielle Stein Fairhurst is a financial modelling specialist and the author of three books on financial modelling. Danielle has regular engagements around Australia and globally as a speaker, course facilitator, financial modelling consultant and analyst, was a guest on Excel TV and has been interviewed for several industry podcasts. Connect with Danielle here: https://www.linkedin.com/in/daniellesteinfairhurst/
• What to bring
A laptop is not required for this session
• Meetup Format
We start the sessions with around 30 minutes of networking, a 45 minute presentation followed by 15 minutes of questions and discussion and conclude by 7.30 or 8pm.
This is a networking group so be sure to find someone to chat to before the session begins. If you’re new and not sure what to say, just ask someone what their favourite Excel function is and you’ll fit right in!