Calculation model v2 (lite version)

UPDATE 10.06.2024: Latest version 3.91

– Fixed more than 20 small bugs.

UPDATE 02.06.2014: Latest version 3.02

– New correct translation in english.
– Fixed more than 30 small bugs.

Many teams do not calculate anything at all or use very lousy models. From our experience - the better model you use, the further you go in challenge. This calculation excel model is powerfull companion in your journey to defeat other teams. Zip archive contains calculation excel model in english language. Other languages can be downloaded in store. Model can help you to improve your decisions and contains:

– Operations calculator
– Finance calculator

Operations calculator consists of several parts:

– Physical resouces (space, machines, materials, internet-ports)
– Human resources (production personnel, assembly workers, agents and distributors, transport, carbon footprint)
– Product data (quantities, delivered, orders, sold, backlog, warehouse stocks, guarantee services, product improvements, components)

Finance calculator consists of several parts:

– Administrative expenses (accumulated taxable profit, insurance)
– Income statement (sales revenue, cost of sales, gross profit, earnings per share)
– Balance sheet (non-current assets, current assets, liabilities, equity)
– Cash flow statement (operating activities, investing activities, financing activities)

Cells colors:

– White background, Blue font - cells with formulas, do not change.
– Green background, Red font - for manual input.
– White background, Black font - static data from report or constant, do not change.
– Yellow background - empty cells, which are active only in PRO version of calculation model.
– Red background - alert, check your decision, it is not good enough.

Warning - model contains VBA macroses, so you need to activate macroses in excel worksheet. Write us, if you still have problems.</p