Calculating Opportunity Costs with AI – Ex-ante Decisions at the Executive Level

Executive Summary: The Most Expensive Costs Don't Appear on Any Balance Sheet

What is the cost of an investment decision that appears economically sound but does not represent the best possible use of available capital?

This question is one of the most important—and at the same time most frequently underestimated—challenges of strategic corporate management.

Companies analyze capital expenditures, operating costs, returns on investment, and risks. They develop business cases, evaluate projects, and discuss investment decisions in management committees.

Yet one crucial economic factor often remains invisible: the opportunity costs of suboptimal capital allocation.

Opportunity costs describe the economic benefit that is foregone because a different course of action was chosen.

In strategic investment planning, this means that a company can finance only profitable projects and still leave significant additional value untapped.

The reason does not necessarily lie in poor projects, but rather in their combination.

The crucial question, therefore, is not only whether an investment makes economic sense, but whether a different combination of the same planned investments would yield a higher overall contribution with the same budget.

This is precisely where StratePlan’s mathematical ex-ante optimization comes into play.

The technology combines methods from operations research with AI-driven approaches to analyze complex investment portfolios and identify economically more efficient project combinations.

This enables companies to calculate, even before committing capital, what economic potential might remain untapped with a particular investment decision.

1. What are opportunity costs—and why are they crucial for management?

In economics and business administration, opportunity costs refer to the lost benefits of the best alternative that was not chosen.

They arise whenever scarce resources are allocated to a specific use and are therefore no longer available for other possibilities.

These resources include, for example:

• Investment capital (CAPEX)
• Operating budgets (OPEX)
• Personnel and skilled workers
• Production capacity
• Technical infrastructure
• Time and Organizational Resources

Opportunity costs are not additional bills that a company has to pay.

Rather, they describe the economic benefit that is foregone by choosing one option over another.

Here’s an example:

A company invests 10 million euros in a project portfolio that generates an expected net value contribution of 4 million euros.

Another viable combination of the same available projects could generate a net value contribution of 6 million euros with the same budget.

The difference is 2 million euros.

In this simplified model, the lost additional value contribution resulting from the chosen portfolio decision is 2 million euros.

This difference is not automatically apparent in traditional cost accounting.

However, it can be of considerable importance for the quality of strategic capital allocation.

2. Opportunity costs arise from choosing between alternatives

In many companies, investment decisions are considered on a case-by-case basis.

A project is evaluated based on its return on investment (ROI), net present value, payback period, or strategic importance.

If the investment is economically attractive, it is recommended for approval.

But when budgets are limited, different projects compete with one another.

The selection of one project therefore affects the feasibility of other investments.

The economic quality of an investment decision cannot be assessed solely on the basis of the attractiveness of the selected project.

It is also crucial to consider which other options are ruled out by this selection.

For example, a project with a particularly high individual rate of return may tie up so much capital that several other projects with a higher overall economic contribution can no longer be financed.

Opportunity costs thus do not arise exclusively at the level of individual projects.

In strategic capital allocation, they must be considered at the level of the entire investment portfolio.

The relevant management question is: What additional economic benefits could we achieve with a different combination of our planned investments?

3. The Exponential Decision Space: Why Opportunity Costs Often Remain Invisible

Calculating opportunity costs becomes significantly more complex as the number of potential investment projects increases.

In a simplified binary decision-making model, each project can either be implemented or not implemented.

With N independently selectable projects, there are theoretically 2^N possible project combinations.

• 7 projects: 2^7 = 128 combinations
• 10 projects: 2^10 = 1,024 combinations
• 20 projects: 2^20 = 1,048,576 combinations
• 30 projects: 2^30 = 1,073,741,824 combinations
• 40 projects: 2^40 = 1,099,511,627,776 combinations
• 50 projects: 2^50 = 1,125,899,906,842,624 combinations
• 100 projects: 2^100 = approximately 1.27 × 10^30 combinations

A company with 50 planned investment projects is thus considering a theoretical decision space of approximately 1.126 quadrillion possible combinations.

Not all of these combinations are permissible due to budget, resource, or project dependencies.

Nevertheless, this order of magnitude illustrates why traditional investment committees and manual scenario analyses can examine only a small fraction of the possible alternatives.

A board of directors can discuss and evaluate 50 projects.

However, it cannot mentally compare more than one quadrillion project combinations with one another.

The key challenge, therefore, is not to understand individual projects, but to determine the economically optimal permissible combination within an exponentially large decision space.

4. Ex ante rather than ex post: Calculating opportunity costs before the decision

Traditionally, opportunity costs are often discussed in hindsight.

For example, after an investment has been implemented, it may turn out that another course of action might have been more economically successful.

Such ex-post analyses can provide important insights.

However, they no longer change the original capital allocation.

Mathematical ex-ante optimization, therefore, begins before the investment decision is made.

It examines which combination of planned projects, within the available budgets and constraints, achieves the highest expected overall economic contribution.

This allows alternative investment portfolios to be compared with one another before capital is committed.

The central question changes:

Ex post: “What economic opportunities might we have missed?”

Ex ante: “Which combination of projects should we choose to maximize the expected total economic contribution under our given conditions?”

The difference is strategically significant.

While retrospective analysis primarily provides insights for future decisions, ex ante optimization can already improve the current investment decision.

Further background is explained in the article “Understanding Mathematics and Optimization—Why Better Decisions Require a Different Calculation Logic.”

5. A Calculation Example: 2 Million Euros in Opportunity Costs with an Identical CAPEX Budget

A company has an investment budget of 10 million euros.

Three projects are under consideration.

Project A has the highest single net value contribution.

If Project A is selected, 3 million euros will remain in the budget.

This is not enough for either of the other two projects.

The selected portfolio thus achieves a net value contribution of 4 million euros.

However, a mathematical analysis of all possible combinations reveals a better alternative.

Projects B and C together require 10 million euros in CAPEX and generate a combined net value contribution of 6 million euros.

Assuming the projects are independent and there are no other restrictions, B + C is the optimal combination in this example for maximizing the net value contribution.

The difference between the originally selected portfolio and the optimal portfolio is 2 million euros.

This corresponds to a 50% higher net value contribution compared to the original selection.

The simplified calculation is as follows:

Lost net value contribution = €6 million − €4 million = €2 million

These 2 million euros represent the modeled economic disadvantage of the original portfolio decision compared to the best available alternative.

The company does not need additional investment capital. It simply needs to select a different combination of its existing projects.

6. Why Excel, Scoring Models, and Investment Committees Alone Are Not Enough

Excel, scoring models, and investment committees are established tools of professional corporate management.

They enable the evaluation of business cases, the creation of investment plans, and the discussion of strategic priorities.

Their limitations become particularly apparent when dealing with large combinatorial decision spaces.

Excel: Scenario analysis does not automatically equate to portfolio optimization

Excel is ideal for calculating individual investment projects and presenting financial metrics.

With appropriate Solver functions, mathematical optimization problems can also be addressed.

However, numerous binary decision variables, project dependencies, and complex constraints can place a significant strain on simple Excel models.

A manually created investment list with 100 projects does not constitute a mathematical optimization of all possible project combinations.

Scoring Models: Prioritization Is No Substitute for Optimization

Scoring models evaluate projects based on defined criteria and generate a ranking from them.

The projects with the highest scores are given priority for implementation.

However, the best ranking does not necessarily lead to the economically optimal combination.

A lower-ranked project, when combined with other initiatives, may yield a higher overall contribution.

Investment Committees: A Few Scenarios Instead of a Systematic Search

Investment committees often compare several prepared scenarios.

For example, a base-case scenario, a conservative budget model, and a growth-oriented investment plan.

These scenarios may have been carefully developed.

However, they often represent only a small subset of the mathematically possible combinations.

The real challenge is not to discuss more scenarios, but to systematically identify the economically optimal combination of projects.

7. How StratePlan Makes Opportunity Costs Mathematically Visible

StratePlan was developed to mathematically optimize complex investment and project portfolios.

The technology combines optimization methods from operations research with AI-based approaches to efficiently analyze large combinatorial decision spaces.

For a basic economic optimization model, three pieces of information per project are initially sufficient:

1. Project ID: Unique identification of the project
2. Expenses: Planned expenditures or investments
3. Income: Expected revenue or economic returns

In addition, the available investment budget is defined.

The data can be imported, for example, from existing Excel investment plans.

StratePlan analyzes possible project combinations and calculates a portfolio based on the specified objective function.

In the “Maximize Net Contribution” scenario, the focus is on maximizing the total expected net value contribution.

The portfolio ROI can also be reported as an economic metric.

Advanced models can account for additional parameters:

• Project dependencies
• Strategic weightings
• Resource constraints
• Multi-year investment budgets
• Time constraints
• Risk and sustainability criteria

The result can then be compared with the originally planned investment portfolio.

The difference in expected net value contributions reveals the modeled potential for improvement in capital allocation.

If a global optimum has been mathematically proven, the distance of an existing portfolio from this optimum can be determined exactly within the defined model.

For approximately optimal solutions, however, the difference from the best solution found is first determined. An exact optimality gap requires corresponding mathematical proof.

8. Live in the Board Meeting: Calculating the Opportunity Costs of Various Decisions

Mathematical portfolio optimization becomes particularly valuable when it is directly integrated into strategic management decisions.

Let’s imagine an industrial conglomerate with 100 planned CAPEX projects.

The total of all proposed investments significantly exceeds the available budget.

Management must decide which projects to finance.

StratePlan first calculates an optimized project mix based on existing economic assumptions.

Then the strategic discussion begins.

Scenario A: What is the cost of our current investment plan?

The CFO asks:

“What is the expected economic difference between our originally planned CAPEX portfolio and the mathematically optimized project combination?”

The two portfolios are compared.

Management determines whether—and by how much—the optimized portfolio generates additional expected net value.

Scenario B: What is the cost of a budget reduction?

The CEO asks:

“How does our total economic contribution change if we have to reduce the investment budget by 15%?”

The budget constraint is adjusted.

StratePlan calculates a new combination of projects.

The comparison shows how the expected net value contribution changes under the reduced budget limit.

Scenario C: What is the cost of a strategic directive?

A member of the executive board asks:

“What economic contribution might we be giving up if certain strategic projects must be implemented regardless of their individual returns?”

The projects in question are treated as binding constraints.

The portfolio is optimized again.

By comparing it with the baseline scenario, it becomes clear what economic trade-off the additional constraint causes within the model.

Scenario D: What are the benefits of additional CAPEX?

The CFO wants to know:

“What additional net value contribution could we achieve if we increased our investment budget by another 20 million euros?”

The budget is adjusted, and a new optimization is performed.

Management can then compare the modeled additional value contribution with the required capital investment.

Change the budget. Adjust the constraints. Recalculate the portfolio. Highlight economic differences.

This transforms static investment planning into a dynamic foundation for strategic capital allocation.

9. Opportunity Costs and Sensitivity Analysis: How Robust Is Our Decision?

Investment decisions are based on assumptions about future economic developments.

Project costs may rise. Expected revenues may turn out to be lower. Resources may become scarcer.

That is why it is important not to rely solely on a single optimization calculation.

Sensitivity analyses allow us to examine different economic scenarios.

Typical questions include:

• How do the economic differences between portfolios change as project costs rise?
• Which projects remain selected under different CAPEX budgets?
• Which investments are particularly sensitive to changes in revenue expectations?
• How do strategic weightings change the composition of the portfolio?
• Which additional constraints cause the greatest economic trade-offs?

Such analyses can reveal how stable an investment decision remains under changing assumptions.

The quality of strategic capital allocation thus depends not only on the best calculated combination of projects, but also on how robust this combination is in the face of economic changes.

10. Opportunity Costs as a Governance Metric for CEOs and CFOs

Traditional KPIs primarily measure economic outcomes within an already chosen strategy.

Revenue, EBIT, ROI, return on capital, and budget variances show how successfully a company has implemented its decisions.

A modeled opportunity cost gap complements this perspective.

It describes the additional economic contribution that a better available alternative would enable under the same defined conditions.

This allows the quality of capital allocation itself to become a focus of management reporting.

This raises new questions for CEOs, CFOs, and supervisory boards:

• How significant is the economic difference between our planned and our optimized investment portfolio?
• Which budget constraints most severely limit our potential value contribution?
• Which strategic objectives cause measurable economic trade-offs?
• How much additional value could we generate with an unchanged CAPEX budget?
• How does the quality of our capital allocation change under different scenarios?

This information can provide an additional basis for investment committees, executive board decisions, and strategic corporate management.

Opportunity costs thus evolve from an abstract business concept into a quantifiable factor within mathematical decision analysis.

11. Case Study: Klybeck Site in Basel – Approximately 30 Million CHF in Additional Value

The StratePlan case study of the Klybeck site in Basel illustrates the economic potential that mathematical portfolio optimization can reveal.

As part of the portfolio optimization for Central Real Estate AG and Swiss Life AG, existing investment and project alternatives were analyzed mathematically.

The modeled result:

• Original return on investment: 7.0%
• Optimized return on investment: 11.4%
• Relative return improvement: approximately 63%
• Additional modeled economic value contribution: approximately 30 million CHF

The improvement was modeled by changing the combination of existing investment alternatives while maintaining the same budget.

The additional value contribution illustrates the economic improvement potential compared to the original portfolio composition.

The project-specific results do not constitute a general guarantee of return.

The key insight: It is not necessarily more capital, but rather a better combination of existing investment alternatives that can significantly increase the overall economic contribution.

12. Where the calculation of opportunity costs is particularly relevant

The mathematical analysis of opportunity costs is relevant wherever numerous projects compete for limited financial or operational resources.

Industry and CAPEX Planning

Machinery investments, production capacities, automation projects, and facility expansions compete for shared investment budgets.

Mathematical portfolio optimization can help identify economically more efficient combinations of these measures.

Digitalization and AI Transformation

Companies often have numerous potential digitalization and AI use cases.

The key challenge is to select the initiatives that, when implemented together, will yield the greatest economic return within the available budget.

Real Estate

Project developments, modernizations, renovations, and location investments can be optimized within a shared capital budget.

The selection of individual real estate projects influences the financing options for the entire portfolio.

Energy and Infrastructure

Energy projects, grid investments, efficiency measures, and infrastructure modernizations often require long-term capital commitments.

Mathematical portfolio optimization can help compare different investment combinations under economic and technical constraints.

Municipalities and Public Budgets

Cities and municipalities, too, must finance numerous investment projects within limited budgetary constraints.

Schools, roads, administrative buildings, infrastructure, and social services all compete for the same public funds.

In addition to economic criteria, technical considerations and social impact goals can also be taken into account here.

In this context, the concept of opportunity cost must be related to the respective defined economic or social objective function.

The common question is: What additional economic or social benefits could a different combination of available projects within the same resource constraints enable?

13. From Business Intelligence to Decision Intelligence

Business Intelligence primarily examines a company’s economic performance.

What has happened? Which KPIs have changed? Where are there deviations from the plan?

Decision Intelligence expands this perspective to include systematic support for strategic decisions.

What alternatives are available? What constraints apply? Which combination of projects best meets the defined objectives?

StratePlan supplements existing ERP, controlling, and business intelligence systems with a mathematical optimization layer.

The required project data can initially be provided via simple Excel spreadsheets.

This allows companies to use existing investment plans as a starting point for systematic portfolio optimization.

The key difference lies in not only measuring the economic consequences of decisions already made, but also mathematically analyzing alternative decisions before they are implemented.

14. Conclusion: The most expensive decision can be an economically sound one

Opportunity costs do not arise exclusively from obviously wrong investments.

They can also arise when companies select profitable projects but overlook an economically superior combination of existing investment alternatives.

The traditional evaluation of individual projects is therefore insufficient to assess the quality of the overall capital allocation.

As the number of planned projects increases, the theoretical decision space grows exponentially.

With 50 projects, there are already more than a quadrillion possible combinations.

This complexity requires suitable mathematical optimization methods.

StratePlan enables the systematic analysis of investment portfolios while taking into account economic objectives, available budgets, and defined constraints.

By comparing planned and optimized project combinations, companies can quantify economic differences and identify untapped value-creation potential.

The crucial question is no longer: Are our planned investments economically sound?

Rather: Which combination of our planned investments generates the highest overall economic contribution with the available capital—and what additional value might we be leaving untapped by choosing a different combination?

This is precisely where the transition from traditional investment planning to mathematical ex-ante optimization begins.

StratePlan – Make opportunity costs visible. Optimize investment portfolios. Allocate capital more intelligently.

FAQ – Calculating opportunity costs with AI

What are opportunity costs?

Opportunity costs describe the lost benefits of the best alternative that was not chosen.

In investment decisions, for example, they arise when capital is allocated to a combination of projects, even though another viable combination could yield a higher total economic contribution.

How can opportunity costs be calculated mathematically?

Given a clearly defined objective function, the selected investment portfolio can be compared with the best feasible alternative.

If the goal is to maximize the net value contribution, the modeled lost value contribution is derived from the difference between the optimal portfolio and the one actually selected.

An exact calculation of the deviation from the global optimum requires that this optimum has been mathematically proven.

Why should opportunity costs be calculated ex ante?

Because the analysis can still influence capital allocation before the investment decision is made.

While a retrospective analysis can provide important insights, capital that has already been committed often cannot be reallocated without incurring additional costs.

Why is a traditional ROI calculation insufficient?

ROI measures the economic return on an investment or a portfolio.

However, it does not automatically show whether a different combination of available projects would yield a higher absolute net value contribution.

That is why it is crucial to consider all relevant investment alternatives together.

Can Excel calculate opportunity costs?

Yes. Excel can calculate economic differences between investment alternatives and, using appropriate Solver functions, can also solve mathematical optimization problems.

However, for large combinatorial decision spaces and complex constraints, specialized optimization methods may be necessary or more efficient.

At what number of projects does mathematical portfolio optimization become worthwhile?

The number of possible combinations grows exponentially even with just a few projects.

With seven binary project decisions, there are 2^7 = 128 possible combinations.

Whether specialized optimization is required, however, depends not only on the number of projects but also on budget constraints, project dependencies, and the complexity of the mathematical model.

What data does StratePlan need for an initial calculation?

For a basic economic optimization model, three pieces of information are initially required for each project:

• Project ID
• Expenses – planned expenditures
• Income – expected revenue or economic returns

In addition, the available investment budget must be specified.

More complex models can take additional constraints and evaluation parameters into account.

Can StratePlan show the opportunity costs of a budget reduction?

By calculating different budget scenarios, it is possible to examine how the maximum achievable modeled net value contribution changes when the budget limit is lowered.

The difference between the results illustrates the economic trade-off associated with the budget reduction within the defined model.

What is the difference between opportunity costs and lost profits?

Opportunity costs describe the benefit of the best alternative that was not chosen.

Lost profit, on the other hand, is a narrower, profit-related term.

Opportunity costs can also refer to capital values, strategic effects, or other defined target metrics.

Is the mathematically optimal project combination always unambiguous?

No.

Several different project combinations can achieve the same optimal objective function value.

Furthermore, a calculated solution may be approximately optimal if there is no complete mathematical proof of optimality.

Any statement about the quality of the solution must therefore be consistent with the optimization method used.

Does AI replace management’s decision-making?

No.

Management defines the strategic objectives, economic assumptions, and relevant constraints.

StratePlan supports the calculation and comparison of potential investment portfolios.

The final decision and responsibility remain with the relevant executives.

Why are opportunity costs particularly relevant for CEOs and CFOs?

Because they can highlight the economic quality of capital allocation.

A company can achieve its planned KPIs and still leave additional value-creation potential untapped if a different combination of investments would have been more economically successful.

Mathematical portfolio optimization therefore complements traditional controlling by adding an additional ex-ante perspective.

How much economic value is left untapped by your current investment plan?

Find out which combination of your planned investment projects can achieve the highest expected net value contribution within your available budget.

Compare your current project planning with mathematically optimized investment scenarios and examine the potential opportunity costs of your capital allocation.

You can optimize up to 15 projects for free.

Optimize up to 15 projects for free now →