Free Excel templates

A free European Defence Fund funding rate and scoring calculator

The economics of a European Defence Fund proposal: the funding rate blended across research, prototyping and testing, the bonuses, the co-financing each partner must find, the EDIP windows and the evaluation thresholds.

A development action with EUR 40 million of eligible cost blends to a 41% base rate. Bonuses add 15% of eligible cost, for EUR 22.4 million of EU support. The consortium still has to find EUR 17.6 million, 44% of the cost.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

EDF_Funding_Rate_and_Scoring_Calculator.xlsx (34 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with Breaking Into European Defence Procurement, which explains the method behind it, chapter by chapter.

Get the book on Apple Books →

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

7 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Funding rates
The co-financing trap
EDIP windows
Scoring
Thresholds
Seven ways a proposal dies
Checks

What the worked case returns

MeasureValue
Total eligible cost (EUR m)40.0
Prototyping funding rate20%
Testing and certification funding rate80%
Blended base rate41%
Bonus points applied15%
Effective funding rate56%
EU support (EUR m)22.4
Consortium co-financing (EUR m)17.6
One partner's co-financing (EUR m)2.112
Of which not yet secured (EUR m)0.950

A research action of the same size would be funded in full. A development action leaves EUR 17.6 million to the consortium, which is why the funding rate decides who can afford to bid.

How to use it on your own case

  1. Enter the eligible cost and its split between prototyping and testing on Funding rates.
  2. Tick the bonuses the consortium qualifies for and read the effective rate and EU support.
  3. Enter your share of the cost on The co-financing trap and how your co-financing is funded.
  4. Score a draft proposal against the thresholds on Scoring and Thresholds.

Questions people ask about it

What does the European Defence Fund fund?

Research actions up to 100% of eligible costs, and development actions at lower rates that depend on the activity, plus bonuses for SME and mid-cap participation.

What is co-financing in an EDF development action?

The share of eligible costs the EU does not fund. The consortium partners must find it from their own funds or national support.

How are EDF proposals scored?

On weighted criteria with a pass mark and a threshold on each criterion. A proposal can clear the overall mark and still fail one threshold.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of Breaking Into European Defence Procurement go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with Breaking Into European Defence Procurement. See the book.