In this guide you will find a clear formula to calculate the Kit Digital ROI, which costs and benefits to include, practical examples by category (e‑commerce, CRM/ERP, cybersecurity…) and a template you can copy into Excel or Google Sheets. Note: amounts and the opening of calls change quickly; always check the Sede Electrónica de Red.es and the BOE before making decisions.
Quick summary: ROI formula and practical steps in 60 seconds
Common basic formula:
- Simple ROI = (Net benefit − Net cost) / Net cost
- Alternative (more compact): ROI = Net benefit / Net cost
Where “Net cost” for projects supported by the Kit Digital is usually understood as: total project invoice − subsidised amount (only if the aid has actually been granted and justified) + any recurring costs you decide to include in the chosen evaluation horizon.
Quick checklist to calculate it:
1) Set the evaluation horizon (1, 3 or 5 years).
2) Calculate net initial investment = total invoice − subsidised amount (if granted).
3) Add implementation costs, training and annual recurring costs (hosting, subscription, support).
4) Estimate annual benefits (additional revenue and monetised savings).
5) Calculate ROI and payback.
Mini illustrative example (hypothetical):
- Net initial investment: EUR 6,000
- Savings and additional revenue year 1: EUR 3,000
- ROI year 1 = (3,000 − 6,000) / 6,000 = −0.5 (−50%) — indicates payback > 1 year.
PAST / PRESENT / FUTURE of the programme and what you must check before calculating ROI
Practical orientation: the Kit Digital has been launched in calls since 2021 and has seen successive resolutions and annexes that set bands and requirements. Calls, annexes and conditions vary over time; before assuming a “voucher” amount or an Anexo IV value you must check the specific call applicable on the Sede Electrónica de Red.es and in the BOE. Do not assume a call is open without verifying those sources.
To avoid errors when transferring amounts to your spreadsheet, always consult the Anexo IV of the applicable call (if relevant) on the Sede Electrónica de Red.es.
Which costs to include when calculating ROI for supported projects
Always include the following blocks:
- Net initial investment (total invoice − subsidised amount). The grant reduces the net cost only if it has been granted and justified.
- Implementation costs: configuration, data migration, integrations, internal staff time.
- Training: hours of training per person × hourly rate.
- Annual recurring costs: SaaS subscriptions, hosting, maintenance, licences, upgrades.
- Cost of the digital agent: commissions or professional services outside the solution invoice.
- Opportunity cost: internal resources diverted from the business (for example, owner/employee hours allocated to the project).
- Indirect costs: periods of reduced productivity during rollout and process adaptation.
How to calculate net initial investment (breakdown example)
Practical formula:
- Net initial investment = Total solution invoice + implementation costs + training − subsidised amount (if applicable and granted).
Illustrative example (hypothetical):
- Platform e‑commerce invoice: EUR 10,000
- Implementation and migration: EUR 2,500
- Training (10 hours at EUR 30/h): EUR 300
- Subsidy granted (illustrative example): EUR 6,000
- Net initial investment = 10,000 + 2,500 + 300 − 6,000 = EUR 6,800 (illustrative example).
Remember: always mark the subsidised amount and keep the grant resolution as supporting evidence.
If you prefer us to set this up with you, during the architecture phase of the Momentum Process we review the breakdown and validate which costs you should allocate. (soft assistance offer)
Which benefits to account for (and how to estimate them)
Direct benefits that can be monetised:
- Sales increase: (traffic × conversion rate × average ticket) before and after.
- Hours saved: hours/person saved × hourly cost.
- Reduction in operating costs: less paper, fewer calls, fewer errors.
- Costs avoided from incidents (in cybersecurity): estimate of losses avoided.
Indirect or intangible benefits (document these, but value them cautiously): improved customer service, higher satisfaction, brand value, regulatory compliance.
How to monetise hours saved (practical method):
- Annual hours saved = (manual task hours/month × 12 × % automation).
- Monetary saving = Annual hours saved × average hourly cost of the profile that performed the task.
Suggested approach: model scenarios at 1, 3 and 5 years. To compare results you can annualise benefits or calculate a cumulative flow.
Formulas to annualise benefits:
- Average annual benefit = (Benefit year 1 + … + Benefit year N) / N
- Annualised ROI = Average annual benefit / Initial net cost
Metrics and time horizon: how to choose evaluation period and relevant KPIs
The horizon depends on the solution: marketing and e‑commerce solutions typically show impact earlier (1–2 years); cybersecurity or BI may justify evaluations at 3–5 years. These are indicative orientations; adjust to your company reality.
Quick template (category → KPIs → recommended horizon):
- E‑commerce: traffic, conversion rate, average ticket, CAC (cost per acquisition) → 1–2 years.
- CRM/ERP: hours saved per process, lead-to‑close rate, sales cycle time → 1–3 years.
- Cybersecurity: downtime avoided, estimated cost per incident, compliance level → 3–5 years.
- Marketing/automation: CPL (cost per lead), conversion rate, LTV (customer lifetime value) → 1–2 years.
- Invoicing and BI: time to close accounts, errors avoided, faster decisions → 1–3 years.
Practical calculation by category: illustrative examples
Note: the following examples are indicative estimates and are presented as hypothetical illustrations.
E‑commerce (web presence and online store)
What to include: platform cost, gateways, commissions per sale, implementation, initial marketing.
Measurable benefits: increased conversions, higher average ticket, reduced abandonment.
Quick formula: Revenue increase = traffic × (convrateafter − convratebefore) × average_ticket.
Illustrative example:
- Current monthly traffic: 5,000 visits
- Current conversion rate: 1%
- Expected conversion rate after improvements: 1.5%
- Average ticket: EUR 50
- Monthly increase = 5,000 × (0.015 − 0.01) × 50 = EUR 12,500 / month → EUR 150,000 / year (illustrative).
- Translate this into ROI by comparing annual revenue increase against net cost.
CRM / ERP (customer and process management)
What to include: licence, implementation, integrations, training.
Benefits: hours saved in administrative tasks, better lead conversion.
Illustrative example based on hours:
- Administrative tasks: 400 h/year that can be reduced by 40% → 160 h/year saved.
- Average hourly cost: EUR 25 → annual saving = 160 × 25 = EUR 4,000 (illustrative).
Cybersecurity
How to value it: usually measured as risk reduction. Practical technique: estimate expected loss = incidentprobability × incidentcost.
Illustrative example:
- Annual probability before: 20% (0.2)
- Average incident cost: EUR 20,000
- Expected loss before = 0.2 × 20,000 = EUR 4,000
- After improvements: probability 5% → expected loss = 0.05 × 20,000 = EUR 1,000
- Estimated benefit = EUR 3,000 / year (illustrative).
Warning: quantifying incident probability and cost is imprecise; document your assumptions.
Digital marketing and automation
Measure by CPL, CAC and LTV. Automation reduces cost per lead and speeds up nurturing.
Illustrative example:
- Current cost per lead: EUR 20; with automation it falls to EUR 15
- Monthly leads 100 → monthly saving = 100 × (20 − 15) = EUR 500 → EUR 6,000 / year (illustrative).
Electronic invoicing, cloud and BI
Benefits: less time on administrative processes, faster close, fewer errors.
Illustrative example:
- 2 employees spent 10 h/month on manual tasks; automation reduces to 4 h/month → total annual saving = (2 × (10 − 4) × 12) × hourly_cost.
Practical tools: spreadsheet template (copy to Excel/Google Sheets) and filled example
Below is a minimal template to copy into a spreadsheet. Create columns by year up to your chosen horizon (e.g. 1–5) and replace values.
Basic template (row per concept):
- Initial investment: solution invoice
- Implementation costs
- Training
- Subsidy granted (put 0 if not applicable)
- Net initial investment (formula: sum all − subsidy)
- Annual recurring costs (row per year)
- Annual benefits (row per year)
- Annual ROI = Annual benefit / Net initial investment
- Payback period = Net initial investment / Annual benefit (if benefit>0)
Filled example (hypothetical and simplified):
- Net initial investment: EUR 6,800
- Benefit year 1: EUR 3,000
- Benefit year 2: EUR 6,000
- Benefit year 3: EUR 6,500
- ROI year 1 = 3,000 / 6,800 = 0.44 (44%)
- Approximate payback ≈ 6,800 / 6,000 = 1.13 years (using average benefit years 2–3)
Usage instructions: copy these rows into Excel or Google Sheets, enter your real figures and create formulas to sum and divide. Keep a column for assumptions and another for source documents.
Limitations, risks and administrative and tax checks that affect ROI
Key administrative risks:
- Only accredited digital agents may manage the aid; verify accreditation on the Sede Electrónica de Red.es.
- The grant reduces net cost only after it has been granted and correctly justified; there is a risk of repayment if documentation is not compliant.
- Keep invoices, contracts, payment receipts and installation records; these documents are requested during audits.
Checklist of documents to keep:
- Invoice for the solution and for the digital agent.
- Contract with the accredited digital agent.
- Grant resolution and proof of receipt.
- Implementation and training report (minutes/signatures).
Tax considerations: the tax treatment of the received amount depends on current tax rules and the circumstances of each company. Consult your tax adviser or the Agencia Tributaria for your specific case.
How to present the ROI calculation to a digital agent, bank or auditor
Recommended one‑page structure:
- Executive summary (1–2 sentences): project objective and summary of expected results.
- Key assumptions: horizon, growth assumptions, conversion rate, hourly cost, incident probability (if applicable).
- Calculation (tables): net investment, annual recurring costs, annual benefits, ROI and payback.
- Sensitivity: three scenarios (pessimistic/realistic/optimistic) showing impact on ROI.
- Attached documentation: invoices, contract with the agent, grant resolution.
Always include a separate sheet with the formulas used and references for the assumptions.
Frequently asked questions
1) How is the Kit Digital subsidy incorporated in the ROI calculation?
- A: Subtract the subsidised amount from the initial investment (total invoice). The subsidy only reduces net cost if it has been granted and justified officially. Check the grant resolution on the Sede Electrónica de Red.es.
2) Can I treat the voucher amount as income in my accounts when calculating ROI?
- A: We do not provide accounting/tax treatment in this article. Treatment depends on tax rules and your accounting: consult a tax adviser or the Agencia Tributaria for your case.
3) Which recurring costs should I include?
- A: SaaS subscriptions, hosting, maintenance, licences, support and any annual cost related to the solution.
4) What documentation must I keep to justify the voucher to Red.es?
- A: Invoices, contracts with the accredited digital agent, proofs of payment, implementation and training report, and the grant resolution.
5) How long until I see ROI from an e‑commerce financed with public support (typical horizon)?
- A: As an illustration, many online shops see impact between 6 and 18 months depending on marketing spend and business maturity; this is an estimate and varies by sector and case.
6) What happens if there is a repayment of the aid: how does it affect the ROI calculation?
- A: If there is a repayment, the net cost increases by the repaid amount and a previously positive ROI can turn negative. Keep all documentation and seek advice if you receive a requirement.
Conclusion
Public aid can substantially reduce the initial cost, but it does not by itself guarantee a positive ROI: project quality, assumptions, recurring costs and correct administrative justification matter. Start by defining horizon and KPIs, monetise savings and sales, and build scenarios to measure sensitivity.
Request a Free Assessment: in a Free Assessment we review your situation and propose a realistic implementation plan and ROI calculation adapted to your SME. This is offered as guidance and does not promise guaranteed results.
Official quick reference sources:
- Kit Digital page at Red.es: https://www.red.es/
- Sede Electrónica de Red.es (calls and Annexes): https://sede.red.gob.es/
- Boletín Oficial del Estado (BOE): https://www.boe.es/
This article was drafted with the support of artificial intelligence and reviewed by qualified Momentum Logic AI staff before publication.
- Momentum Logic AI Team . momentumlogicai.es . LinkedIn
Leave a Reply