top of page

Financial Model Schema


Financial Model Schema
Click here to download the infographic in high resolution

Setting up your financial model structure is the foundation for a robust forecast.


While every model is different, they almost all follow the same schema.


When your schema is well defined, it allows for easy editing, and a clear and cohesive view for your readers to ingest the material


Schema Overview


The general idea is that your model should follow this structure:


Schema Overview - Financial Model Schema

Each section feeds into the next, allowing for maximum flexibility & comprehension on your models.


Source Data


Source Data can be any external information that you bring into your model…

most commonly those are your financial statements, headcount, and customer details.


Connect your data - Financial Model Schema

The idea is that this data should be imported into your model in their native format, making it easier to refresh...

and if need be, you can clean your data using Power Query.


Input Tabs


It’s common to consolidate as much as possible with your inputs into just one tab.

This makes it easy for your readers to understand all the assumptions that go into your model, allowing for a centralized location where everything can be tweaked.


Drivers - Financial Model Schema

Sometimes though, you may have too much information to fit on one tab.

That’s where your other input tabs come into play, which will then all push to your centralized drivers tab


Input Tabs - Financial Model Schema


Output Tabs


Now that you have your source tabs…

and you’ve tweaked your assumptions on your input tabs…

it’s time to present your findings.

The most important findings will be the output for your 3 financial statements


Output Tabs - Financial Model Schema

It’s also common to divide up your output tabs between detailed outputs (IE, your full P&L, Balance Sheet and Cash Flows)…


and summarized outputs



Summarize outputs - Financial Model Schema

with summarized outputs, you gain the ability to understand what is happening at a high level, before diving deep into the weeds.


Dashboards & Reporting - Financial Model Schema


Now comes my favorite part of a model…

Your Dashboards & Reporting.

This is where you woo your audience with beautiful visuals that summarize the key information 🤩



Dashboards & reporting - Financial Model Schema

For more information on how to prepare these dashboards, check out my course on CFO Dashboards & Reporting


It’s common to also include a table of contents with your models so that the readers can understand how everything is laid out, and where the edits can be made.

Remember…your models are not just for yourself - they will almost always be reviewed and tweaked by outside parties.


The more coherent & clear the structure of your model is, the easier it is for you to manage and nail your projections.

Those are my tips for how I create a financial model schema.

101 views

Related Posts

See All
bottom of page