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: