O'Reilly logo

Mastering Cash Flow and Valuation Modelling by Alastair Day

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4

Historic statements

Accounting sheets

Income Statement

Balance sheet

Adjustments

Summary

File: MCFM_Skeleton.xls

ACCOUNTING SHEETS

The first schedules to be added to the model are the historic income and balance sheets. The analysis begins with up to five annual reports for the model company and the application needs to present them in a standardised form for further analysis. Companies vary their layout due to local accounting practices or presentation requirements and the purpose of the initial accounts is to establish a layout that can be used for other cases and in the forecast and other statements. As discussed in Chapter 3, we can consider all models to be templates or sources of reusable code.

You can copy the schedule template ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required