Overview
A screen shot of an ERR Excel spreadsheet.
MCC is making available its Economic Rate of Return (ERR) data via interactive, downloadable Microsoft Excel spreadsheets. the spreadsheets are unique to each project within a compact.
Each spreadsheet includes:
- A description of the project, including its economic rationale;
- The expected project impacts, including detailed cost and benefit estimates;
- A tool allowing users to modify key assumptions and study the effects of those modifications on the project’s returns.
Some familiarity with cost-benefit analysis will be essential to use these spreadsheets.
Calculating ERRs
MCC’s methodology for ERR analysis is best described as micro-economic growth analysis, which measures the expected increases in household incomes or the value-added of individual firms. ERRs can also be considered MCC’s best pre-investment estimate of the likely economic impact of the proposed investment. These ERRs also include income or value added that is expected to be generated through environmental and social improvements, but do not attempt to quantify and incorporate the broader social value of these improvements.
Every ERR calculation considers two scenarios:
- The expected outcome with the project investment; and
- The expected outcome without the project investment.
Scenario 1:
Expected Outcome with Project Investment
This scenario reflects the increases in income or value added generated by the proposed program, as well as the full costs related to the program.
Scenario 2:
Expected Outcome with No Project Investment
The second scenario, called the counterfactual, reflects an estimate of what is likely to happen in the future if no project investment takes place. While this may be considered a “status quo” scenario, the estimation of future economic outcomes without the project also accounts for dynamic trends. For example, a growing economy would be expected to continue growing consistent with recent projections, even without the project.
ERR analysis compares the difference in incomes or value added between the two scenarios. The ERR, then, is expressed in percentage terms, and represents the interest rate at which the discounted net benefits equal the discounted costs. Projects that are likely to generate larger increases in household incomes per dollar invested will have higher ERRs.
MCC models incorporate the best information available at the time regarding core parameters, but projections of future economic activity for both scenarios must account for uncertainty. MCC conducts sensitivity analysis on its ERRs using a range of plausible values on the major variables that drive the results. Thus, ERRs represent MCC’s best estimate of what we expect will happen as a result of the project, while the sensitivity analysis represents the potential range of outcomes.
MCC Investment Decisions
MCC takes into consideration a number of factors when making its decisions to approve Compact investments. First, we value country ownership and place a premium on supporting initiatives that have broad based support in the country and that were developed through a consultative process. We also examine whether the program proposal is consistent with MCC policies and guidelines on gender, the environment, and procurement procedures, among others. Given our focus on measurable results that will reduce poverty, we analyze each program to determine its sustainability and its Economic Rate of Return (ERR). We expect programs will generate adequate benefit streams to justify the specific investments. MCC also conducts beneficiary analysis to ensure that investments will deliver tangible benefits to the poor.
ERR and Due Diligence
MCC’s due diligence process includes the estimation of the economic rate of return (ERR) for projects in the proposal from each compact-eligible country. An ERR is a comparison of costs and the potential benefits of those costs.
In MCC’s analysis:
- Costs are the financial expenses of a proposed project, including expenses covered by other parties;
- Benefits are the increased income of a country’s population or value added by its firms due specifically to the proposed project.
ERRs and Compact Proposals
Compact-eligible countries prepare a compact proposal which identifies the main constraints to economic growth and proposes several programs to address those constraints.
These countries have the primary responsibility for analyzing the economic impact of their proposed programs, and are expected to estimate this impact with an ERR. MCC’s due diligence process includes reviewing and validating ERR estimates produced by our country partners and, if necessary, working with a country to identify and assess possible alternatives, modifications or complements to the proposed projects.






