|
2. Model structure
Different sheets
Normally you need to fill figures only in two input sheets:
I-divQ and I-main.
Although you do not necessarily need output sheets (O-sheets),
they might be helpful when you finalize or change your
estimates, as the sheets gather the relevant parameters
in tables and graphs.
(I refers to input, O refers to output.)
 See
more info from Excel manual
I-divQ
The I-divQ sheet includes division and quarter level
income statement.
I-main
The I-main sheet includes full-year income statement,
balance sheet, most of the full-year estimate parameters,
share information and valuation calculations (DCF and
EVA).
The following pages will tell you more detailed what
to input and where.
Possible problems?
Circular
reference problem.
|
