In this episode of Financial Modelers Corner, host Paul Barnhurst welcomes Ruby Liu, Director at KPMG Australia’s Valuation Team, to dive into intricacies of financial modeling. Having led KPMG Australia’s Sydney modeling team and worked as the head of corporate finance in the energy sector, Ruby’s vast experience spans from transactional modeling for infrastructure assets to advising clients on valuation and capital raising. Ruby Liu brings over 16 years of professional expertise in corporate finance, financial modeling, and valuations.

This episode offers practical insights on managing complex financial models, optimizing processes, and the challenges of transitioning models from transactional to operational use. Ruby’s guidance provides a valuable learning opportunity on how to build efficient and user-friendly financial models. Her deep knowledge and hands-on experience make her a key voice in the field of financial modeling.

Key takeaways from this week's episode include:

• The key differences between transactional and operational models and how to adapt them for long-term use.
• Why keeping the model user in mind is crucial for building effective financial models.
• Ruby’s top strategies for creating models that are simple, visually appealing, and efficient in calculation speed.
• Insights into the challenges of working with large, complex models and how to manage issues.
• How Ruby’s experiences at KPMG shaped her understanding of the financial modeling landscape.

Here are a few quotes from Ruby Liu:

• "The most efficient model isn’t the one with the most complex formulas, but the one that’s easy to understand and use." - Ruby Liu
• "In financial modeling, the goal is to fit the user’s purpose, not dazzle them with complexity." - Ruby Liu
• "I think AI can help build models, but we’ll still need human oversight to interpret the results." - Ruby Liu

In this insightful episode, Ruby Liu offers a masterclass in financial modeling. From her candid reflections on the pitfalls of overly complex models to the importance of keeping the end user in mind, Ruby’s practical advice is invaluable for both novice and seasoned modelers alike.

Follow Ruby Liu:

• LinkedIn - https://www.linkedin.com/in/liuruby

Follow Paul: 

• Website - https://www.thefpandaguy.com   
• LinkedIn - https://www.linkedin.com/in/thefpandaguy  
• YouTube - https://www.youtube.com/@thefpaguy8376  

Follow Financial Modeler's Corner  

• LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  
• Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984

Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.

Visit www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. 

In today’s episode:

[01:13] - Introduction to the episode and guest

[03:01] - Worst financial model and lessons learned

[08:28] - Ruby reflects on her evolving perspective on the industry

[12:47] - Ruby’s leadership experience at KPMG’s Sydney team

[16:47] - Insights into Ruby’s current role in valuations

[22:14] - Different valuation methods; income and market approaches

[25:57] - Converting transactional models into operational ones

[41:16] - Rapid fire questions segment with Ruby

[47:49] - Advice for modelers and contact information