← All Articles

NPV Method: NPV-Calculation with Formula, Example and interpretation

What you'll take away from this article
  • How to understand npv method: definition and anwendung and use it for your capital strategy
  • How to understand the npv-formula: step-by-step explained and use it for your capital strategy
  • How to understand the richtige diskontrate wählen and use it for your capital strategy
  • How to understand praktisches calculation example: npv ar fabrik-mornisierung and use it for your capital strategy

NPV Method: Definition and Anwendung

The NPV Method, auch Net Present Value (NPV)-Methode genannt, is a Standardmethode for BeValueung of investmentsprojekten. Sie beantwortet The Frage: "how viel Value schafft These investment heute?" through Discounting aller tokünftigen Cash Flows on The Gegenwart with ar angemessenen Diskontrate will be a absoluter Valuegewinn in Euro are calculated.

The NPV-Formula: Step-by-Step Explained

The fundamental NPV-Formula is::

NPV = CF₀ + CF₁/(1+r)¹ + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ

or kompakt:

NPV = Σ (CFₜ / (1+r)ᵗ) for t = 0 bis n

Components:

  • CF₀, CF₁, ..., CFₙ = Cash Flows in den Perioden 0 bis n (meis Jahre)
  • r = Discount Rate (Diskontrate, Discount Rate)
  • n = investmentsdauer or Projectionhorizont
  • 1/(1+r)ᵗ = Diskontfactor for Periode t

The Logik: a Euro heute is mehr Value as a Euro morgen. the NPV verdichtet all tokünftigen Gewinne on ihren heutigen Value.

The richtige Diskontrate wählen

The Wahl the Diskontrate r is entscheidend and bestimmt den NPV stark:

for Corporate investments: Nutze den WACC (Weighted Average Cost of Capital) as Diskontrate. the WACC reflektiert The Costs for Eigen- and Debt of the company and is dawith The "gerechte" Return for a Projekt with durchschnittlichem Risk.

Example: a deutsches MaschinenbauCompany with WACC = 7% nutzt Thesen Satz for BeValueung neuer Produktionsinvestments.

for Private Equity / Venture: Nutze The Hurdle Rate des Fonds (e.g. 20% for LBOs). Thes spiegelt the higher Risk and The Expected Return withegegen.

Riskanpassung: Riskantere Projekte erforthen higher Discountingssätze. a NPV-Calculation with r = 7% vs. r = 12% can to völlig unterschiedlichen Resultsen führen.

Praktisches Calculation Example: NPV ar Fabrik-Mornisierung

Szenario: a Company aboutlegt a €500 Mio Fabrik-Mornisierung about 10 Jahre.

Gegebene Daten:

  • Anfangsinvestment (year 0): −€500 Mio
  • Jährliche Costsasparungen (Cash Flow Jahres 1–10): +€80 Mio
  • Salvage Value am Ende (year 10): +€50 Mio
  • WACC / Diskontrate: 6%

Step 1: Diskontfactors calculate

yearCF (€ Mio)Diskontfactor 1/(1,06)ᵗPV (€ Mio)
0-5001,000-500,0
1800,94375,4
2800,89071,2
3800,84067,2
4800,79263,4
5800,74759,8
6800,70556,4
7800,66553,2
8800,62750,2
9800,59247,4
10130 (80+50)0,55972,7

Step 2: Summe the BarValuee

NPV = −500,0 + 75,4 + 71,2 + 67,2 + 63,4 + 59,8 + 56,4 + 53,2 + 50,2 + 47,4 + 72,7

NPV = +€116,9 Mio

NPV-Entscheidungsregel: Annehmen or ablehnen?

The Entscheidungsregel is adeutig:

  • NPV > 0: Projekt schafft positiven Value for the company. Annahme empfohlen.
  • NPV = 0: Projekt entspricht genau the MindestReturn. Grenzfall, weitere factors entscheiden.
  • NPV < 0: Projekt zerstört Value. Ablehnung empfohlen.

in unserem Example: NPV = +€116,9 Mio is deutlich positiv → investment should durchgeführt will be.

NPV vs. IRR: Unterschiede and asatzbereiche

NPV:

  • Zeigt absolute Valueschöpfung in Euro
  • not beaflusst of the investmentsgröße
  • at sich fromschließenden Projekten: NPV entscheidend
  • Setzt explizite Diskontrate beforefrom
  • Theoretisch aboutlegen

IRR:

  • Zeigt prozentuale Return
  • Leicht to verstehen and to kommunizieren
  • Unabhängig of Diskontrate (findet The "Break-Even"-Rate)
  • can at not-konventionellen Cash Flows mehrfach ontreten
  • Praxisfreandlicher in PE/VC

Konflikt-Szenario: Projekt A has 25% IRR on €10 Mio, Projekt B has 15% IRR on €100 Mio. the NPV of B can trotz Lowem IRR höher sa. The beste Practice: atde Metriken nutzen.

NPV vs. Payback Period: Warum NPV aboutlegen is

Payback Period: "after how viel Jahren is the investment torückgeflossen?"

Example: €100 Mio investment with €25 Mio/year Cash Flow → Payback = 4 Jahre.

Probleme the Payback Period:

  • Ignoriert Cash Flows after the Payback-Periode
  • Considered not den ZeitValue des Moneyes
  • Willkürliche SchwellenValuee (2-5 Jahre?)

Warum NPV besser is:

  • Considered all Cash Flows
  • Diskontiert with realisische interest Rate
  • Objektivere Entscheidungsregel

The Payback Period is nur as schnelle Heurisik for Liquiditätsrisiken nützlich, not for investmentsentscheidungen.

Sensitivity Analysis: how robust is the NPV?

The NPV reagiert stark on Äntheungen the agabegrößen. a Sensitivity Analysis zeigt:

  • if WACC of 6% on 8% steigt: NPV sinkt of €116,9 Mio on approx. €75 Mio
  • if Cash Flows um 10% sinken: NPV sinkt um approx. 10%
  • if Salvage Value wegfällt: NPV sinkt um approx. €31 Mio

a 2D-Sensitivitytabelle with Variousn Discountingssätzen and Cash Flow Scenarios zeigt The Robustheit the investmentsentscheidung. a Stabler Highr NPV about mehrere Scenarios is beruhigend.

What this means for you

When you apply this knowledge, you gain a concrete advantage over competitors who enter investor conversations without this foundation. Use the insights from this article as the basis for your next step.

Excel NPV-Funktion: Practical Application

in Excel (deutsch: =BW(), englisch: =NPV()) will be the NPV easily calculated:

Syntax: =NPV(r, CF₁:CFₙ) + CF₀

Important: The Excel-NPV-Funktion Considered CF₀ not, daher must es separat adThert will be!

Example: =NPV(6%, B2:B11) + B1

with r = 6%, CF₀ = −500 Mio in B1, CF₁−CF₁₀ in B2:B11.

The NPV Method bleibt The solideste theoretische Grandlage for investmentsentscheidungen and should in jethe mornen Finanzanalyse is used.

Next Step: Free Strategy Call

Discover in 30 minutes which capital pathways are realistic for your project.

Book Your Call Now →
Your advantage after this article

What you now know — and how to use it

  • You know the core concepts and can apply them directly to your situation
  • You know which mistakes to avoid — saving you time and capital
  • You understand how this building block fits into your overall strategy

Your next step: Have your situation professionally assessed — free and non-binding in an initial consultation with Daniel Huber.

Daniel Huber
Daniel Huber Gruender & CEO, CANVENA
Daniel Huber

Ready for the Next Step?

In 30 min, Daniel Huber shows which capital strategy fits your situation.