[an error occurred while processing this directive]
Valuatum Oy

 
  Main > Support > Analyst Help > Minimum Requirements in Excel Model   

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.


Submit a new question. We will answer it within 24 hours by e-mail.

 

Copyright © 2001 Valuatum Oy. All rights reserved. Disclaimer.