Structuring Inputs in Financial Models: A Single Page or Throughout the Model?

Jun 6 / Geoff Robinson



In the world of financial modeling, the organization of data inputs is an often-debated topic among investment analysts. Should all inputs be compiled on one page for easy access, or spread throughout the model for contextual relevance?

Let's delve into this discussion and consider the implications of sensitivity analysis and the sanity-checking of assumptions.

Your Personalized Investment Training Platform.

The Case for a Single Input Page
The appeal of a single input page lies in its simplicity and centrality. Having all inputs in one place enables a quick overview of all the assumptions driving the model, and this consolidated view facilitates easier review and adjustments, streamlining the modeling process.
As Timothy R. Mayes, author of "Financial Analysis with Microsoft Excel", says, "Consolidating all model inputs on a single worksheet can enhance the clarity of your model and make it much easier to modify your assumptions."
Such an approach can significantly benefit sensitivity analysis. With all variables in one location, adjusting inputs to evaluate different scenarios becomes more streamlined. It also aids in documenting changes, which is crucial when multiple analysts work on the same model.

The Case for Spreading Inputs Throughout the Model
On the other hand, spreading inputs throughout the model may provide more contextual relevance. Inputs located in the sections where they're directly used can enhance the understanding of the model's structure and the interrelations between its components.

John Tjia, in his book "Building Financial Models," argues, "Embedding inputs within their respective sections of the model helps to maintain a clear line of sight between an assumption and its impact, aiding in understanding and troubleshooting the model."
Distributing inputs can also aid in sanity-checking the consistency of assumptions. Locating inputs close to their corresponding calculations makes it easier to check that the assumptions align with the resulting outputs visually.
Striking a Balance
While both approaches have merits, it often boils down to the model's complexity and the analyst's preference. Some prefer a hybrid approach: key assumptions and drivers are placed on a single input sheet for easy manipulation and high-level analysis, while more granular, module-specific assumptions are embedded within their respective sections.
This approach strikes a balance between maintaining an overview and ensuring contextual relevance. As Danielle Stein Fairhurst, one of my fellow Master of Modeling inductees, states "A well-organized model will gather its inputs in a central location, but it's also helpful to have some context around where and how these inputs are used."

Conclusion

In conclusion, whether inputs are collected on a single page or spread throughout the model depends mainly on the model's complexity, the analyst's preference, and the need for clarity and convenience in reviewing and adjusting assumptions.

I align with Danielle's view and want to collect my inputs together: it allows me to be better organized, and I find it easier to sanity-check my assumptions and the consistency of my narrative. And finally, setting up data tables is straightforward if the inputs driving the sensitivity analysis are all on the same page as the data table build. But I also see value in having the inputs and drivers I use in my model pop up on relevant pages in my model too. I then get the line-of-sight argument that John Tjia speaks about.

Whatever the choice, ensuring clear documentation, ease of navigation, and logical consistency, is paramount in building robust and reliable financial models.

Choose Your Plan.

Get 2 months for FREE with our yearly subscription.

InshgtOne Logo

Monthly Subscription

30-day free trial
5,000+ digital assets

£20/month
Billed monthly

Yearly Subscription

30-day free trial
5,000+ digital assets
2 months FREE
£200/year
Billed yearly

Enterprise Program

Professional-grade investment training for institutions.

Monthly & Yearly
Enterprise Options POA