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:

  • Assumptions
  • Calculations
  • Income Statement
  • Balance Sheet
  • Cash Flow
  • Summary

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.

Financial Auditing: Ultimate Guide

Financial auditing entails producing an opinion on the truth and fairness of the financial statements of a company. Only

Financial Auditing: Ultimate Guide

Financial auditing entails producing an opinion on the truth and fairness of the financial statements of a company. Only licensed accounting professionals (auditors) authorized by the relevant governing bodies for the territories they operate in can carry out the auditing of financial statements. Audits were first regulated with the...
Learn More

Clearinghouses and Custodians: Financial Intermediaries 101

Intermediaries are vital for a well-functioning financial system and allow their clients to solve the problems they face more

Clearinghouses and Custodians: Financial Intermediaries 101

Intermediaries are vital for a well-functioning financial system and allow their clients to solve the problems they face more efficiently than they could by themselves. We find several types: Brokers, Exchanges, and Alternative trading systems Dealers and Securitizers Depository Institutions Insurance Companies Arbitrageurs, and Clearinghouses and Custodians We shall...
Learn More

Long and Short Positions: Guide to Wall Street Lingo

Rather than an instance of duration, long and short positions are a reference to haves and have-nots. They touch

Long and Short Positions: Guide to Wall Street Lingo

Rather than an instance of duration, long and short positions are a reference to haves and have-nots. They touch on securities an investor really owns versus securities an investor owes. Basically, the terms “short” and “long” denote what “selling” and “buying” do respectively. Featured: What is a Long Position?...
Learn More