Sunday, September 5, 2021

Interactive Model

Step 1) Inputs are made in the spreadsheet area at the bottom half
Step 2) Click the Calculate button
Step 3) Select Output in the top-left area
Step 4) View output at the top-right area

Step 1 and 2) Input and Calculate - Bottom half

This is where you input data, and click the Calculate button to get updated outputs.

Step 3 and 4) Select and View Output - Top half

On the left hand side you select what you want to view/output, and the selected output appear on the right hand side.


The input is done on the bottom half, sorted by themes. You select the Input theme in the top-left drop-down list. The below image shows the main Input theme: Forecast.

Dedicated input area

The top part of the spreadsheet table is the Dedicated input area.
In this area there are labels in the A column with a gray background. These labels dictate the type of input data to be on that row.
As an example the 2’nd row shall contain expected revenues in column C, column D and onwards. That is, in the calculation, the data input in these cells are assumed to be expected revenues.

Volume/amount A quantity of something, especially the total of a thing or things in number.


The amount of money expected, required, or given in payment for something.

COGS/cost of goods solds
Cost of goods sold (COGS) refers to the direct costs of producing the goods sold by a company.

Revenue is the money generated from normal business operations, calculated as the average sales price times the number of units sold.

A cost is the value of money that has been used up to produce something or deliver a service.

Variable costs
A variable cost is a corporate expense that changes in proportion to how much a company produces or sells.

Fixed costs
Fixed costs, such as rent, are constant costs that do not directly depend upon the amount of goods/services produced or sold.

Depreciation is a reduction in the value of an asset over time, due in particular to wear and tear.

Loan interest rate

A loan is money that is borrowed, and that is expected to be paid back with interest.
Interest rate is the proportion of a loan that is charged as interest to the borrower, typically expressed as an annual percentage of the loan outstanding.

Tax is a compulsory financial charge or some other type of levy imposed on a taxpayer by a governmental organization in order to fund government spending and various public expenditures.


A dividend is a distribution of profits by a corporation to its shareholders.

Inventory change
Inventory or stock refers to the goods and materials that a business holds for the ultimate goal of resale, production or utilization. An increase in inventory reduces the cash, and a decrease in inventory increases the cash.


The amount invested in building, land, machinery and equipment, and infrastructure related to the company/project. An investment reduces the cash.

Change loans

A loan is money that is borrowed, and that is expected to be paid back with interest.

An increase in loans will increase the cash. A decrease in loans will decrease the cash. 

Financing is the process of providing cash for business activities. This can be in the form of equity and  loans. 

Free space area and ‘@Variables’

The area below the Dedicated input area, is the Free space area.
That means that the input in these cells are not directly included in the calculations. However, you can link cells in the Dedicated input area to cells in the Free space area. As an example you can create input and calculations in the Free space area for the revenues and costs, and then link the revenues cells to this Free space area calculation. In the below example Revenues in cell C2, D2 linked to the Free space area cells C16, D16 etc. Input in cell C2 is '=C16'.

Your own specified output: ‘@Variables’In the below image the cell A14 ‘@Revenues Products:’ is highlighted. In the Free space area, you can add the ‘@’ sign in front of the variable name, and then this variable is also available for chart output. 


You can use all the standard/normal formulas as e.g.:
Plus: +

Minus: -

Division: /

Multiplication: *
Sum: SUM(C2:F2)
Max: MAX(C2:F2)

Min: MIN(C2:F2)

You can also use ‘if’: =if(E7>15,10,0)

Copy cells

Cells without and with formulas can also be copied by dragging the cell (see the Gif at the top of this document).

Copy, paste, delete ranges

You can mark several cells and then copy/paste/delete that whole range at one time. You can do this by either a) using keys ‘CTRL + C’ for copying, ‘CTRL + V’ for pasting, or b) right click and then select the relevant function.


Click the top right gear icon to open settings.

Here you can Mange features (which features/input you would like to have included).

You can share the analysis with others.

You can copy the analysis.

Gif example

Link to step-by-step explanation: Using the Solution

Interactive Model

Step  1) Inputs are made in the spreadsheet area at the bottom half Step 2) Click the Calculate button Step 3) Select Output in the top-left...