The shared model / v1.0

Make every assumption
part of the conversation.

Our Excel framework connects the inputs, the analysis and the result. Explore its structure and try a focused interactive example.

Built in Excel. Developed together.

8 worksheets. 4 valuation perspectives. One shared starting point for discussion.

Open the interactive example ↓

Inside the workbook

A model you can follow.

The structure below follows the supplied SVN valuation workbook. Each module has a clear role in the analysis.

00

Control

Version, valuation date, base year, currency and company details.

Set the context
01

Assumptions

Market inputs, tax, capital structure, cost of equity and WACC.

Define the drivers
02

Historical Financials

Income statement and balance sheet inputs.

Understand the past
03

Discounted cash flow

Normalization, revenue, costs, working capital, cash flows and discounting.

Build the forecast
04

Multiples

Trading, SME and transaction approaches with an equity bridge.

Compare the market
05

Net Asset Value

Tangible, intangible and financial assets alongside liabilities.

Examine the assets
06

Residual Income

Book equity, required return and residual earnings.

Focus on equity
07

Output Dashboard

A consolidated view of the different valuation approaches.

Review the results

The model lab

Change the inputs.
See what moves.

A focused illustration using sample inputs from our workbook. Explore the mechanics behind a valuation.

SVN / Interactive illustration

01 / Your assumptions

5.00%12.00%
0.00%4.00%

Fixed sample free cash flows (2026–2030), EUR thousands:
31.83 / 32.62 / 33.44 / 34.11 / 35.13

02 / The effect on value

Illustrative enterprise value
—€k
PV of cash flows PV of terminal value

See the calculation

Enterprise value = Σ FCFₜ / (1 + WACC)ᵗ + [FCF₂₀₃₀ × (1 + g) / (WACC − g)] / (1 + WACC)⁵.

This is a simplified five-year illustration. The Excel DCF worksheet extends through 2036; this example does not reproduce its dashboard output.

Educational illustration · Sample values, not a valuation of a real company. Calculations run in your browser.

Developed through the work

The model is a starting point.
Judgment does the rest.

We use the framework to make the reasoning visible, compare perspectives and discuss the inputs that matter.

Members help develop the model as new company cases raise new questions. The goal is thoughtful, documented analysis that others can review.

Learn how we work

Shape what comes next

Your curiosity.
Our next chapter.

Join a growing student network and help build a more rigorous approach to valuation.

Explore membershipHave a question? Get in touch →