Horizontal vs. Vertical Models

Horizontal vs. Vertical models thumbnail

There are two types of financial models – single and multi-sheet models. Single sheet or also known as vertical models contain the different areas of the model on a single sheet, while a multi-sheet model is composed of separate sheets for every single area of the model.

Single Sheet and Multi Sheet models

In general, single sheet models are used when the model that has to be created is smaller- it will include fewer drivers and will not be very detailed. They are easy to use and simpler to understand, which is a very good thing. The problem is that at some point, the model might expand and include additional parameters that were not considered before. If a single page model expands too much, it becomes difficult to manage. Typically a one page model will include the following sections:

With multi-sheet models every sheet will represent a different section of the model. There will be a separate sheet for the Assumptions, Income Statement, Balance Sheet, Cash Flow, D&A schedule, Debt schedule, Historical Inputs, etc.

Naturally, multi-sheet models are better positioned for more complex structures and higher level of detail.

Budgeting Approaches: Bottom-Up vs. Top-Down

When it comes to budgeting, organizations often follow a functional and strategic hierarchy to make decisions. Generally, we differentiate

Budgeting Approaches: Bottom-Up vs. Top-Down

When it comes to budgeting, organizations often follow a functional and strategic hierarchy to make decisions. Generally, we differentiate between “bottom-up” and “top-down” approaches. The Bottom-Up Approach The bottom-up approach progresses upwards, starting from the lowest level of details. Finance professionals compile various inputs in a comprehensive model the...
Learn More

Audit Reports

Financial statements are prepared according to a specific set of rules – either local accounting principles or International Financial

Audit Reports

Financial statements are prepared according to a specific set of rules – either local accounting principles or International Financial Reporting Standards. A question then arises, “Who oversees whether companies comply with financial regulation guidelines?” Use of Auditor’s Report Financial statements provide valuable information about the financial performance and position...
Learn More

Benefits of Budgeting

A Budget is an organization’s operational plan for the future. It illustrates a firm’s estimation of expected revenue and

Benefits of Budgeting

A Budget is an organization’s operational plan for the future. It illustrates a firm’s estimation of expected revenue and expenses as well as the inflow of resources and their allocation. Why Do Companies Need a Budget? Through budgeting, companies chart the course of their business in an unpredictable world....
Learn More