The Transport Module The “Scenario Analysis” sheet

The “Scenario Analysis” sheet helps to determine the breakeven price and Marginal Abatement Cost of carbon between any two scenarios.


  • Click here to get an animated introduction to this sheet.

  • Read the detailed overview of the sheet while you work on it by clicking here.


  • Modifications to this sheet can be made simply by adding more rows for the overview of scenarios.

    Overview of the sheet

    The “Scenario Analysis” sheet includes a Scenario Calculator to support comparison of any two scenarios. It helps to determine the breakeven price and Marginal Abatement Cost of carbon between any two scenarios.

    The breakeven price of carbon is the value that would have been given for each tonne of carbon saved, or mitigated, to achieve the same net discounted value in both scenarios over the modeling period.

    Both the implicit value of CO2-equivalent emissions and the costs are discounted at the same rate.

    The sheet also contains The Marginal Abatement Cost, of carbon based on a pair-wise comparison of alternatives that achieve the same primary objective – generally non-climate-change related.

    The Marginal Abatement Cost is the value that would have been given to each tonne of carbon saved, or mitigated, to give the same net discount value for each scenario over the lifetime of the options.