How to calculate your Comenius Regio budget?
This excel file should help you to calculate your budget. It provides automatic calculations of the percentages
spent in each budget category, the maximum amounts eligible for equipment and subcontracting and the total
grant amount. Although the sheet has been tested, applicants are advised to check calculations before
transferring the results into their application form. The responsibility for the information given in the application
form remains with the applicant.
How to use the different excel tables?
The sheet "Summary" reflects the structure of the application form. For the categories "Equipment" and
"Subcontracting" it calculates the maximum amounts eligible, respecting the ceiling of 10% resp. 30% of the total
project costs. The table E3 "Total requested grant amount" takes its information from the section E1 and E2 and
calculates the total.
The sheet "Calculation equipment" helps you in calculating the eligible costs for equipment, taking into account
the depreciation of any purchase. Calculation results in this table are not automatically transfered to the summary
sheet.
The sheet "Staff costs" helps you in calculating staff costs, based on daily rates.
The sheet "Co-financing travel and subsistence" shall help you to calculate these costs in case you want to
cover the travel of external experts under the heading "other costs". You will have to respect the calculation rules
outlined in the Guide for Applicants; the tables provide you with the correct format on how to calculate them.
You are of course not obliged to use this excel file to calculate your budget. In case of simple budgets with only a
few items you will probably not need it. You can use it for more complicated budget scenarios and / or to verify
that your calculations are in line with the existing rules.
Please note, that cells containing formulas or text are protected. If you have questions concerning the formulas
used, please contact your National Agency. They can unprotect the sheet, help you with problems and verify if
there are any hidden logical or mathematical mistakes.
E. Requested EU funding
Preliminary remarks: In order to compile your own budget, it is sufficient to fill in the figures for your region only. Please fill in all cost categories before checking
the ceilings in the categories "Equipment" and "Subcontracting". Only this will safeguard a reliable plausibility check of the total requested grant amount (section
E.3).
E.1 Mobility
Distance between the two applicant institutions (in km):
Partnership type No. of planned mobilities Grant amount requested (€)
Partner region 1
Partner region 2
E.2 Other (non-mobility) costs
Please refer to sections 4.E and 4.F of the Guide for Applicants when filling in the following tables.
Indirect costs are not eligible for funding support.
Travel and subsistence costs (incl. local transport during mobilites) have to be covered by the mobility lump sum.
Other (non-mobility) costs can only be funded up to 75% of the eligible non-mobility costs within a region and up to a maximum of 25. 000 EUR per
Possible cost categories in "other (non-mobility) costs"
Staff costs: costs relating to statutory or temporary staff, based on real daily staff cost rates which cannot exceed the maximum eligible daily rates indicated in
the LLP Guide, part 4.F.
Subcontracting: costs incurred by procurement contracts, e.g. translation, interpreting, printing, (These costs mustn't exceed 30 % of the total project costs.)
Equipment: purchase, rent or lease of equipment justified and necessary for the project, depreciated in accordance with tax and accounting rules (these costs
mustn't exceed 10 % of the total project costs.)
Other project costs: on the basis of real costs (e.g. rental costs, purchase of consumables, travel costs for experts or speakers at conferences)
STAFF COSTS
(add rows if necessary)
Seite 2 von 12
Cost per
Staff category N° of working days working day Costs (in EUR)
(in EUR)
Partner Region 1
Partner Region 1
Partner Region 1
Partner Region 1
Total staff costs in partner region 1 0.00
Cost per
Staff category N° of working days working day Costs (in EUR)
(in EUR)
Partner Region 2
Partner Region 2
Partner Region 2
Partner Region 2
Partner Region 2
Total staff costs in partner region 1 0.00
SUBCONTRACTING
(add rows if necessary)
Costs
Service or task subcontracted
(in EUR)
Partner region 1
Partner region 1
Partner region 1
Partner region 1
Partner region 1
Total subcontracting costs in partner region 1 0.00
The costs for subcontracting should not exceed 30 % total project costs. In the budget compiled by you so far, this maximum amount would be
EUR
Seite 3 von 12
Costs
Service or task subcontracted
(in EUR)
Partner region 2
Partner region 2
Partner region 2
Partner region 2
Partner region 2
Total subcontracting costs in partner region 2
The costs for subcontracting should not exceed 30 % total project costs. In the budget compiled by you so far, this maximum amount would be
EUR
EQUIPMENT
(add rows if necessary)
Costs
Equipment
(in EUR)
Partner region 1
Partner region 1
Partner region 1
Partner region 1
Partner region 1
Total equipment costs partner region 1 0.00
The costs for subcontracting should not exceed 10 % total project costs. In the budget compiled by you so far, this maximum amount would be
EUR
Costs
Equipment
(in EUR)
Partner region 2
Partner region 2
Partner region 2
Partner region 2
Partner region 2
Total equipment costs partner region 2 0.00
The costs for subcontracting should not exceed 10 % total project costs. In the budget compiled by you so far, this maximum amount would be
EUR
Seite 4 von 12
OTHER COSTS
(add rows if necessary)
Costs
Type of costs
(in EUR)
Partner region 1
Partner region 1
Partner region 1
Partner region 1
Partner region 1
Total other costs partner region 1 0.00
Costs
Type of costs
(in EUR)
Partner region 2
Partner region 2
Partner region 2
Partner region 2
Partner region 2
Total other costs partner region 2 0.00
E.3 Total requested grant amount
Please note, that it is not possible to grant more than 25 000 Euro for non-mobility project costs. In case the calculated amount (75% of the non-mobility project
costs) is higher than 25 000 Euro, the table will automatically show only 25 000 Euro.
Partner region 1 Partner region 2
in % in %
Requested lump sum amount #DIV/0! 0.00 #DIV/0! 0.00
Staff costs #DIV/0! 0.00 #DIV/0! 0.00
Subcontracting #DIV/0! 0.00 #DIV/0! 0.00
Equipment #DIV/0! 0.00 #DIV/0! 0.00
Other costs #DIV/0! 0.00 #DIV/0! 0.00
Total other (non-mobility) project costs 0.00 0.00
75% of the total non mobility project costs 0.00 0.00
Total project costs 0.00 0.00
Seite 5 von 12
Total grant amount requested 0.00 0.00
Seite 6 von 12
Calculation of equipment costs
Please use the depreciation rates which are in accordance with the tax and accounting rules of the beneficiary incurring the costs.
Annual Period of Use
Purchase or Degree of Eligible
Description Total Costs Cost date Depreciation in Project
Rent/Lease ? Use (%) Costs
rate (%) (months)
Partner region 1
Partner region 1
Partner region 1
Partner region 1
Partner region 1
Partner region 1
Partner region 1
total 0.00
Annual Period of Use
Purchase or Degree of Eligible
Description Total Costs Cost date Depreciation in Project
Rent/Lease ? Use (%) Costs
rate (%) (months)
Partner region 2
Partner region 2
Partner region 2
Partner region 2
Partner region 2
Partner region 2
Partner region 2
total 0.00
Staff Costs
This table shall help you to calculate staff costs according to the rules outlined in the Guide for Applicants.
All figures in Euro
Staff by category
Overall 1. Manager 2. Researcher, teacher and / or trainer 3. Technical 4. Administrative
Overall
Partner total days on the Cost per day Total staff days on the Cost per day Total staff days on the Cost per day Total staff days on the Cost per day Total staff
total staff
region number of project cost by project cost by project cost by project cost by
costs
working category category category category
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Co-financing Travel and Subsistence Costs 1/0/1900 1/0/1900
This table shall help you to calculate travel and subsistence costs
All figures in Euro
City and Country of City and Country of Start End Total costs
Partner Name of the person Purpose of the trip Travel costs Subsistence costs
departure destination Date Date 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
All figures in Euro (Call 2012 ceilings)
Country STAFF
Researcher
Description Manager Teacher Technical
Trainer
Belgique/Belgie BE Belgium 460 360 240
Balgarija BG Bulgaria 40 26 22
Česká republika CZ Czech Republic 134 88 72
Danemark DK Denmark 361 284 236
Deutschland DE Germany 419 310 221
Eesti EE Estonia 102 73 59
Ellas EL Greece 279 218 142
España ES Spain 321 212 163
France FR France 435 351 257
Eire IE Ireland 309 328 239
Italia IT Italy 454 298 200
Kypros CY Cyprus 316 217 142
Latvija LV Latvia 78 63 50
Lietuva LT Lithuania 75 55 42
Luxembourg LU Luxembourg 496 331 282
Magyarország HU Hungary 107 79 57
Malta MT Malta 119 99 74
Nederland NL Netherlands 305 262 212
Österreich AT Austria 449 302 244
Polska PL Poland 109 77 51
Portugal PT Portugal 258 181 122
Romania RO Romania 84 51 34
Slovenia SI Slovenia 240 161 109
Slovenská republika SK Slovakia 95 54 45
Suomi /Finland FI Finland 368 255 196
Sverige SE Sweden 360 256 226
United Kingdom GB United Kingdom 355 334 231
Island IS Iceland 338 219 193
Liechtenstein LI Liechtenstein 449 302 244
Norge NO Norway 440 345 311
Hrvatska HR Croatia 141 102 66
Schweiz / Suisse / Svizzera / Svizra CH Switzerland 478 354 252
Türkiye TR Turkey 86 60 42
STAFF
Administrative
214
15
53
197
203
42
118
117
193
178
174
96
38
34
197
44
58
170
194
39
77
28
89
34
163
176
153
151
194
239
49
232
36
Maximun elegible daily rates (in EUR) for Subsistence costs for Multilateral projects, Networks,
Accompanying measures, Studies and Comparative research (Call 2012 ceilings)
Country Daily rate
Belgique/Belgie BE Belgium 232
Balgarija BG Bulgaria 145
Česká republika CZ Czech Republic 195
Danemark DK Denmark 311
Deutschland DE Germany 220
Eesti EE Estonia 175
Ellas EL Greece 220
España ES Spain 227
France FR France 269
Eire IE Ireland 253
Italia IT Italy 247
Kypros CY Cyprus 194
Latvija LV Latvia 172
Lietuva LT Lithuania 168
Luxembourg LU Luxembourg 232
Magyarország HU Hungary 184
Malta MT Malta 191
Nederland NL Netherlands 242
Österreich AT Austria 246
Polska PL Poland 179
Portugal PT Portugal 197
Romania RO Romania 161
Slovenia SI Slovenia 208
Slovenská republika SK Slovakia 186
Suomi/Finland FI Finland 277
Sverige SE Sweden 275
United Kingdom GB United Kingdom 312
Island IS Iceland 235
Liechtenstein LI Liechtenstein 340
Norge NO Norway 340
Schweiz / Suisse / Svizzera / Svizra CH Switzerland 340
Hrvatska - HR HR Croatia 214
Türkiye TR Turkey 190