Skip to main content
HEOR Africa

Free template

Programme Costing Template (Ingredients Approach)

A blank Excel workbook for costing a health programme or service with the ingredients approach — recurrent and capital inputs, annualisation, financial and economic costs, and the unit cost per output.

ExcelUpdated 30 September 2026Costing

What's inside

  • Setup sheet for the costing question, perspective, currency, price year and output
  • Recurrent costs sheet with input categories and a source column for every row
  • Capital costs sheet that annualises equipment, vehicles and buildings automatically
  • Summary sheet with totals by category, financial and economic costs, and the unit cost
  • An instructions sheet explaining each step

Key points

  1. 01Blank structure with formulas only — no data are included.
  2. 02Separates financial costs (cash outlays) from economic costs (all resources used).
  3. 03Annualises capital items with the equivalent annual cost method.
  4. 04Every row has a source column, so the result can be checked.

Frequently asked questions

Does the template contain any data?

No. It is a blank structure with formulas. You enter your own quantities, prices and sources.

Which discount rate should I use for capital costs?

Use the rate required by your national guidelines or funder, and record it on the Setup sheet with its source.

Can I add more rows?

Yes. Insert rows inside the existing table ranges so that the summary formulas include them, and check the totals after any change.

Need this done properly?

This template gives you the structure. If you would rather have the analysis done for you — with local data, independent quality control and a report you can defend — we can help.

Need this done properly?

Tell us about the decision you need to support. We will propose a scope, timeline and price.

WhatsApp HEOR Africa (opens WhatsApp)