Chapter 10

Building an Integrated Financial Statements Model


check Learning about financial statements

check Entering assumptions

check Calculating revenue and expenses

check Building the financial statements

check Adding scenarios

Financial statements are the mainstay of many financial models. The financial statements consist of three reports:

  • Income statement
  • Cash flow statement
  • Balance sheet

technicalstuff Some financial models might include only a profit-and-loss statement, some might include simply a cash flow statement, but many include all three. If a financial model does contain all three, you might hear it referred as a three-way financial model.

What you really need to know about financial statements from a financial modeling perspective is that they should hang together and interrelate with each other with links. This is called an integrated financial statement.

Every output in a financial model ...

Get Financial Modeling in Excel For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.