Lance Rubin – Financial Modelling

Lance Rubin was the first guest on a podcast dedicated to financial modelling, talking about what the field means for people entering it and the challenges modellers face. This page introduces the episode and answers common questions about Lance Rubin and his work in financial modelling.

Lance had the privilege of being the first guest on the newly launched podcast on Financial Modelling run by Matthew Bernath.

Listen in to hear more about what it means for those entering the sector and wanting to gain a better understanding of some of the challenges in Financial Modelling.

Lance Rubin: frequently asked questions

To automate the repeatable parts of modelling, we built EXL Cloud, our own SaaS modelling platform: driver-based 3-way models in Excel, connected to Xero, with a library of Claude skills that help build, check and report on the model while the modeller keeps control of the logic.

Who is Lance Rubin?

Lance Rubin is a Chartered Accountant and financial modeller based in Melbourne, Australia. He is the CEO and Founder of Model Citizn and EXL Cloud, and previously worked at PwC, KPMG, Investec and NAB. His work focuses on financial modelling, finance data and helping accounting and finance professionals use AI and modern tools in their day-to-day work.

What does Lance Rubin talk about on financial modelling podcasts?

Lance Rubin typically talks about what it takes to build reliable financial models, the challenges new modellers face and how the profession is changing. Common themes include modelling standards, the move from spreadsheets to structured financial models, data literacy, and how tools such as Power BI and AI change the way finance teams forecast and make decisions.

What is Model Citizn?

Model Citizn is a Melbourne-based firm founded by Lance Rubin that provides financial modelling, fractional CFO, finance intelligence and financial automation services. It also runs training in financial modelling, Power BI and AI for accounting and finance professionals, and publishes a free knowledge hub of articles, podcasts and webinars on the future of finance.

How can someone new to financial modelling get started?

Start by learning modern Excel well, then study a recognised financial modelling standard so your models are consistent and easy to audit. Practise by building a simple 3-way model that links the profit and loss, balance sheet and cash flow. Structured courses, modelling competitions and reviewing well-built models from experienced modellers all speed up the learning curve.

What challenges do new financial modellers face?

New modellers often hardcode numbers into formulas, build without a clear specification and skip error checks. Those habits make models hard to audit and easy to break. Other common challenges are knowing which assumptions really drive the business and explaining outputs to decision makers. Following a modelling standard and getting models peer reviewed addresses most of these problems early.

Need a financial model built or reviewed for your business? See our Financial and Business Modelling services.

About the Author

Lance Rubin is CEO and Founder of Model Citizn, and founder and Chief Excel Officer of EXL Cloud, the SaaS platform that connects Xero to Excel with driver-based financial models, dashboards and Claude AI skills. He is a Chartered Accountant, FMI Certified Trainer, co-author of the CA ANZ Financial Modelling Study Guide, and creator of the AI-Powered Accountant programme on Maven, currently live at Level 1 with Level 2 in design, and author of the companion book “AI-Powered Accounting with Excel and Power BI” (Packt). He has worked at PwC, KPMG, Investec, and NAB, and is based in Melbourne, Australia.

Related reading: Best Practice Formula Construction for Financial Modelling and The Demand for Financial Modelling Skills Reaches new Heights.

Share This

Related Articles

Andrew Codd interviews Lance to help people understand the benefits of learning financial modelling and the practical steps people can take to embrace it in their careers.
An LBO model evaluates a leveraged buyout, where a business is acquired using a significant amount of debt alongside equity. It combines the entry price, sources and uses, an operating forecast, a debt schedule and an exit assumption to calculate the equity investor's returns, usually IRR and multiple on invested capital (MOIC).
Unlock the full potential of your business data with our tailored Power BI models designed specifically for corporate needs.