Minimum Requirements in Excel Model
This document lists what values should be filled to an
empty Excel model so that it can be inserted to the database.
Please notice that the links below go to the help sections
where the issue in question is described more detailed.
The pages behind the links don't tell the thing in the
minimum requirement view.
I-divQ sheet
Division
names
At
least one division (names as 'Group' for example)
Latest
actualized current year quarter
Mark
with 'x' to row 4
Latest
actualized income statement to cumulative values section
Fill
at least cumulative Q4
Latest
actualized current year quarter to cumulative values section
Not
needed if Q1 not actualized
Current
year (Y+0) estimates in quarter level
Net
sales and EBIT (either relative or absolute)
Year
Y+1...Y+3 estimates in full-year level
Net
sales and EBIT (either relative or absolute)
I-main sheet
The
last estimate year (as terminal values)
Net
sales growth and EBIT-%
Latest
actualized balance sheet
No
of shares for current year
Metadata in I-main and Database-interface sheets
See
Excel2DB preparations.
|