Skip to main content

How to tell a good story with financial modelling

Man working at laptop with pie chart graphic

Fancy yourself a storyteller? Financial modelling is the numerical way to tell a story and transform simple digits into insights and predictions. For example, you have a business idea but you need to convince potential investors or directors that your plan will succeed - this is where financial modelling comes in.

What is financial modelling?

Financial modelling is the art of creating mathematical representations, or models, to predict a company’s financial performance. These models serve as a roadmap which guides decision-makers through the web of possibilities and helps them to make informed choices.

But it’s not all about numbers and equations. Financial modelling can be quite an exciting adventure - blending creativity and analysis to tell a (hopefully happy) story.

How does financial modelling work?

Gathering data

To tell a good story, you need to know where it’ll start. This is where the first step of financial modelling comes in.

Any good financial model requires the initial step of collecting the relevant historical data. This includes expenses, revenue, and market trends that will act as the foundation on which the model will be built.

Setting assumptions

Of course, you can’t change the real data to fit with your preferred conclusion. But where do you expect your story to go?

Every financial model relies on certain assumptions about the future. So, think of this as your story plot: what is going to happen? With careful research and industry knowledge, you can determine factors such as growth rates, market share projections, and pricing strategies.

Constructing formulas

You have your starting point, and where you expect the story to go - so now plot your story!

Using existing data and assumptions, you can build the formulas and equations that will calculate future financial outcomes. Your ‘characters’ can include revenue forecasts, cost projections, cash flow analysis and more.

Sensitivity analysis

Financial modelling allows you to best test different scenarios by tweaking the assumptions. A good story isn’t always predictable, so it’s important to explore other endings just in case.

Considering other possible assumptions will empower you to make adjustments or explore alternative strategies, which will help you understand the impact of various factors on the business’s bottom line.

Presenting insights

What helps to tell an engaging story? Illustrations!

Once your financial model is complete, you can visualise the data using graphs, charts or dashboards which will transform a sea of numbers into a story of trends and patterns. And the most important thing is that it’s easier to understand.

Practice makes perfect

Most seasoned writers will tell you that their first few stories didn’t always go to plan. Like any craft, financial modelling requires honing your skills and refining your approach. The more experienced you become, the more skilled you’ll be. So, embrace the learning curve, experiment, and don’t be afraid to ask for guidance along the way.

Who is financial modelling for?

Financial modelling isn’t just for financial analysts or CFOs. It can be a powerful tool for entrepreneurs, managers, or just individuals aiming to make informed financial decisions. The skills that you gain from financial modelling are always going to be useful - so dive into the world of numbers and data and watch your ability to make positive financial predictions flourish.

The story goes on…

If you’re looking to upskill in financial modelling and use data and numbers to become a great storyteller, consider becoming a Chartered Financial Analyst with the CFA qualification.

If you’re still not sure whether this is right for you, try our free 7 day CFA trial.

If you’re an employer looking to upskill your team in financial modelling, and equip them with the skills needed to excel, enquire about our in-house or online training courses in Microsoft Excel for Financial Modelling.

Looking to transform your career?

Start your free trial

Mentioned Products:

CFA qualification

Related articles

A FLP-ing good route to CIMA’s CGMA professional qualification

A FLP-ing good route to CIMA’s CGMA professional qualification

Expert tutor, John Bennett, discusses the benefits of opting for CIMA’s CGMA Finance Leadership Program (FLP) to boost your career.

Kaplan · 11 minute read

Enhancing learning strategies for ADHD and autism

Enhancing learning strategies for ADHD and autism

Our inclusion team teamed up with a Kaplan apprentice to discuss techniques when studying and/or working ADHD or autism.

Kaplan · 14 minute read

ACCA exams - what to do if you fail

ACCA exams - what to do if you fail

No matter what style of ACCA learner you are, we can help you pass your exams and get through the qualification.

Kaplan · 20 minute read

View all articles

How to tell a good story with financial modelling

Man working at laptop with pie chart graphic

Fancy yourself a storyteller? Financial modelling is the numerical way to tell a story and transform simple digits into insights and predictions. For example, you have a business idea but you need to convince potential investors or directors that your plan will succeed - this is where financial modelling comes in.

What is financial modelling?

Financial modelling is the art of creating mathematical representations, or models, to predict a company’s financial performance. These models serve as a roadmap which guides decision-makers through the web of possibilities and helps them to make informed choices.

But it’s not all about numbers and equations. Financial modelling can be quite an exciting adventure - blending creativity and analysis to tell a (hopefully happy) story.

How does financial modelling work?

Gathering data

To tell a good story, you need to know where it’ll start. This is where the first step of financial modelling comes in.

Any good financial model requires the initial step of collecting the relevant historical data. This includes expenses, revenue, and market trends that will act as the foundation on which the model will be built.

Setting assumptions

Of course, you can’t change the real data to fit with your preferred conclusion. But where do you expect your story to go?

Every financial model relies on certain assumptions about the future. So, think of this as your story plot: what is going to happen? With careful research and industry knowledge, you can determine factors such as growth rates, market share projections, and pricing strategies.

Constructing formulas

You have your starting point, and where you expect the story to go - so now plot your story!

Using existing data and assumptions, you can build the formulas and equations that will calculate future financial outcomes. Your ‘characters’ can include revenue forecasts, cost projections, cash flow analysis and more.

Sensitivity analysis

Financial modelling allows you to best test different scenarios by tweaking the assumptions. A good story isn’t always predictable, so it’s important to explore other endings just in case.

Considering other possible assumptions will empower you to make adjustments or explore alternative strategies, which will help you understand the impact of various factors on the business’s bottom line.

Presenting insights

What helps to tell an engaging story? Illustrations!

Once your financial model is complete, you can visualise the data using graphs, charts or dashboards which will transform a sea of numbers into a story of trends and patterns. And the most important thing is that it’s easier to understand.

Practice makes perfect

Most seasoned writers will tell you that their first few stories didn’t always go to plan. Like any craft, financial modelling requires honing your skills and refining your approach. The more experienced you become, the more skilled you’ll be. So, embrace the learning curve, experiment, and don’t be afraid to ask for guidance along the way.

Who is financial modelling for?

Financial modelling isn’t just for financial analysts or CFOs. It can be a powerful tool for entrepreneurs, managers, or just individuals aiming to make informed financial decisions. The skills that you gain from financial modelling are always going to be useful - so dive into the world of numbers and data and watch your ability to make positive financial predictions flourish.

The story goes on…

If you’re looking to upskill in financial modelling and use data and numbers to become a great storyteller, consider becoming a Chartered Financial Analyst with the CFA qualification.

If you’re still not sure whether this is right for you, try our free 7 day CFA trial.

If you’re an employer looking to upskill your team in financial modelling, and equip them with the skills needed to excel, enquire about our in-house or online training courses in Microsoft Excel for Financial Modelling.

Looking to transform your career?

Start your free trial

Mentioned Products:

CFA qualification

Related articles

A FLP-ing good route to CIMA’s CGMA professional qualification

A FLP-ing good route to CIMA’s CGMA professional qualification

Expert tutor, John Bennett, discusses the benefits of opting for CIMA’s CGMA Finance Leadership Program (FLP) to boost your career.

Kaplan · 11 minute read

Enhancing learning strategies for ADHD and autism

Enhancing learning strategies for ADHD and autism

Our inclusion team teamed up with a Kaplan apprentice to discuss techniques when studying and/or working ADHD or autism.

Kaplan · 14 minute read

ACCA exams - what to do if you fail

ACCA exams - what to do if you fail

No matter what style of ACCA learner you are, we can help you pass your exams and get through the qualification.

Kaplan · 20 minute read

View all articles