Valuatum Oy

 
  Main > Support > Analyst Help > Filling Empty Excel Model   

<- Previous

Step-by-step Excel Guide

Next ->


12. Estimates, balance sheet 2004 ->

The following estimate parameters are used in estimating balance sheet:
Investments
Tangible assets / Net sales %
Working capital %
Financial income % (3 subitems)

See Excel tutorials about estimating balance sheet.


Click picture for full-size map.

How to fix #REF in income statement and balance sheet?

You may have noticed that there are lot of cells with #REF sign in income statement and balance sheet. These errors can be fixed by clicking the macro button on the left side of income statement ('Fix Interest Expenses').

See more info about #REF error.


Less important balance sheet parameters

Some less important parameters do not have estimate parameters but they are estimated directly to balance sheet instead.

These parameters include e.g. other intangible rights, share capital, convertibles, etc.

As a default there are formulas that set the value in a cell to be same as in the previous year. Since the font is in light blue color, you can override the formula, if needed.


Click picture for full-size map.

 


General instructions

How to set value for Tangible assets / net sales %?
Estimating Working capital

 

<- Previous

 

Next ->


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

 

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