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 ...

Get Mastering Cash Flow and Valuation Modelling now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.