Blog main article:
CFO ROI Decision-Making AI Tool
Executive Summary: The greatest untapped value often lies within investment projects
How much additional total economic contribution could your company achieve with the same CAPEX budget—simply by better combining its planned investment projects?
This question is one of the central challenges of modern corporate finance.
CFOs and finance executives are responsible for allocating substantial investment funds. At the same time, production facilities, digitalization projects, AI initiatives, energy projects, location investments, and growth programs all compete for limited capital.
Most of these projects have carefully developed business cases.
Net present values, internal rates of return, payback periods, and return on investment metrics are calculated. Projects are evaluated, prioritized, and then incorporated into investment programs.
Yet one key question often remains unanswered:
Is the selected combination economically superior to all other feasible combinations of our existing projects?
Even with just 25 binary project decisions, there are theoretically 2^25 = 33,554,432 possible project portfolios.
With 50 projects, there are 2^50 = 1,125,899,906,842,624 combinations—roughly 1.126 quadrillion.
A traditional ROI ranking cannot fully capture this decision space.
This is exactly where StratePlan comes in.
StratePlan combines mathematical optimization methods from operations research with AI-driven approaches to systematically analyze large combinatorial decision spaces and identify economically efficient investment portfolios.
The goal is not to evaluate individual projects more effectively.
The goal is to determine the economically optimal combination from existing projects.
Same projects. Same budget limit. Optimized combination. Higher potential total contribution.
1. Why CFOs Must Not Only Evaluate Projects but Also Optimize Portfolios
Traditional investment analysis initially considers individual projects.
Established evaluation tools include:
- Net Present Value (NPV): The net present value of an investment project
- Internal Rate of Return (IRR): Internal rate of return
- Return on Investment (ROI): The ratio of returns or value added to capital invested
- Payback Period: The time it takes for an investment to pay for itself
- Risk Analysis: Assessment of economic uncertainties
These metrics are key foundations for professional investment decisions.
However, they primarily answer the question of how attractive a single project is.
A CFO must also decide which projects should be financed collectively.
This gives rise to interdependencies.
A project can tie up capital that is then unavailable for several other investments.
Another project may depend on technical prerequisites that can only be created through a further investment.
Several projects may require the same skilled workers, production capacities, or IT resources.
The economic quality of an investment decision therefore does not depend solely on the key performance indicators of individual projects.
What matters is the overall economic contribution of the selected combination of projects given the resources actually available.
2. Capital Allocation: Why the Best ROI Ranking Doesn’t Result in the Best Portfolio
Many companies prioritize their investment projects based on individual return metrics.
Projects with particularly high ROI or IRR are given high priority.
This approach seems economically sound.
However, it can lead to suboptimal investment portfolios.
The reason lies in the limited divisibility of investments.
A company often cannot scale down a production facility at will to make optimal use of the remaining budget.
In many cases, investment projects are either implemented in full or not at all.
This creates a combinatorial optimization problem.
A project with a high individual rate of return may require so much capital that several other projects can no longer be financed.
These other projects could collectively generate a higher absolute value contribution.
Maximizing individual project returns is therefore not automatically synonymous with maximizing the total economic contribution of an investment portfolio.
3. Calculation Example: 50% More Net Value Contribution Without Additional CAPEX
A company has an investment budget of 10 million euros.
Three projects are under consideration.
| Project | CAPEX | Net value contribution |
|---|---|---|
| A – New production facility | €7 million | €4 million |
| B – Automation | €5 million | €3 million |
| C – Energy Efficiency | 5 million € | €3 million |
Project A has the highest single net value contribution.
If Project A is selected, 3 million euros of the investment budget will remain.
This remaining budget is not sufficient to implement either Project B or Project C in addition.
The total net value contribution is therefore 4 million euros.
However, combinatorial optimization reveals a more economically viable alternative.
Projects B and C together require 10 million euros and generate a net value contribution of 6 million euros.
Assuming the projects are independent and there are no additional constraints, B + C is the optimal combination for maximizing the net value contribution.
The optimized portfolio achieves a net value contribution that is 50% higher than the original selection.
The company does not need any additional investment capital to achieve this.
It simply needs to select a different combination of its existing projects.
This example illustrates the difference between project evaluation and portfolio optimization.
Investments that are attractive on their own do not automatically result in the economically best overall portfolio.
4. The exponential decision space: 25 projects mean over 33 million combinations
In a simplified binary investment model, each project can either be selected or not selected.
With N projects, there are theoretically 2^N possible project combinations.
The number grows exponentially.
| Number of projects | Possible Combinations |
|---|---|
| 10 | 1,024 |
| 15 | 32,768 |
| 20 | 1,048,576 |
| 25 | 33,554,432 |
| 30 | 1,073,741,824 |
| 40 | 1,099,511,627,776 |
| 50 | 1,125,899,906,842,624 |
Even with just 25 projects, there are theoretically more than 33 million possible portfolios.
With 50 projects, there are more than a quadrillion.
By way of comparison: According to astronomical estimates, the Milky Way contains approximately 100 to 400 billion stars.
A theoretical decision space consisting of 50 binary projects thus encompasses significantly more combinations than our galaxy has stars.
Of course, not every project combination is permissible.
Budget constraints, project dependencies, and other restrictions reduce the number of feasible portfolios.
Nevertheless, this comparison of scales illustrates the magnitude of the mathematical challenge.
The CFO does not have to make 50 individual decisions. He must select an economically viable combination from an exponentially growing decision space.
5. Why Excel, BI, and traditional financial planning alone are not enough
Excel, ERP systems, and business intelligence platforms are key components of modern corporate management.
They enable the calculation of business cases, cash flows, budgets, and economic scenarios.
Mathematical optimization is also fundamentally possible with suitable Excel solvers.
However, a traditional Excel project list that sorts investments by ROI or net present value does not automatically perform combinatorial portfolio optimization.
Similarly, a BI dashboard does not automatically answer the question of the best combination of projects.
The difference lies in the mathematical problem formulation.
| Traditional Financial Planning | Mathematical portfolio optimization |
|---|---|
| Evaluates individual projects | Evaluates project combinations |
| Compares prepared scenarios | Systematically searches for high-performing combinations |
| Generates ROI and NPV rankings | Optimizes a defined portfolio objective function |
| Documents budget allocation | Takes budget limits into account as mathematical constraints |
| Analyzes existing plans | Calculates alternative investment portfolios |
This comparison describes typical approaches. Specialized planning and portfolio management systems may also include optimization functions.
What matters is not which software product is used, but whether the entire investment portfolio is mathematically optimized under the relevant constraints.
6. Local Optima versus Global Optimum: Why Better Individual Decisions Are Not Enough
Many companies improve their investment programs incrementally.
Individual projects are swapped out. Budgets are reallocated. Projects with low returns are canceled.
Such changes can improve results.
However, they do not guarantee that the best possible overall portfolio will be achieved.
In mathematical optimization, a distinction is made between local and global optima.
- Local optimum: A solution that cannot be further improved within a defined neighborhood.
- Best solution found: The most efficient combination identified by an optimization method.
- Global optimum: A solution for which no other feasible combination has a better objective function value.
A step-by-step improvement of the existing investment portfolio may result in a local optimum.
To find better alternatives, it may be necessary to swap out multiple projects simultaneously.
This is often difficult to detect through manual prioritization.
Mathematical portfolio optimization therefore examines not only individual project improvements but also the economic quality of entire project combinations.
A global optimum is only proven if the mathematical method used provides corresponding proof of optimality.
In the case of approximate methods, the best solution found is evaluated based on its economic quality and, where applicable, available optimality bounds.
7. StratePlan: AI-powered Capital Allocation and Mathematical CAPEX Optimization
StratePlan was developed to mathematically optimize complex investment and project portfolios.
The technology combines operations research methods with AI-supported approaches to efficiently analyze large combinatorial decision spaces.
The focus is on calculating economically viable project combinations under defined constraints.
For a basic economic optimization model, only three pieces of information per project are initially required:
- Project ID: Unique identifier for the investment project
- Expenses: Planned expenditures or investments
- Income: Expected revenue or economic returns
In addition, the available investment budget is specified.
The project data can, for example, be imported from existing Excel investment plans.
StratePlan analyzes possible project combinations and calculates a portfolio based on the selected objective function.
With “Maximize Net Contribution,” the focus is on maximizing the total expected net value contribution.
The portfolio ROI can also be reported as an economic metric.
Maximizing the absolute net value contribution and maximizing the portfolio ROI are different mathematical objectives.
For more complex investment portfolios, additional parameters and constraints may be relevant:
- Project dependencies
- Strategic weightings
- Multi-year investment budgets
- Resource and capacity constraints
- Time constraints
- Risk and sustainability criteria
Taking these requirements into account requires appropriate modeling.
StratePlan supplements traditional investment analysis with a mathematical optimization layer for the entire project portfolio.
8. Maximize Net Contribution and Portfolio ROI: Two Metrics, Different Purposes
For CFOs, distinguishing between absolute value contribution and relative return on investment is crucial.
Net value contribution describes the economic surplus of a project or portfolio based on the revenues and expenses defined in the model.
Portfolio ROI compares the economic contribution to the capital invested.
Both metrics are relevant.
However, they answer different questions.
Maximize Net Contribution
Which combination of projects generates the highest absolute net economic value contribution within the available budget?
Portfolio ROI
What is the relative return on investment (ROI) of the selected overall portfolio based on the defined calculation method?
A portfolio with a particularly high ROI does not necessarily have the highest absolute net value contribution.
Conversely, a portfolio with a higher net value contribution may have a lower relative return.
For capital allocation, it must therefore be clearly defined which economic target metric is to be maximized.
StratePlan uses the “Maximize Net Contribution” objective and reports the portfolio ROI as a supplementary metric.
9. The key CFO question: How much ROI potential remains in the CAPEX budget?
The quality of capital allocation influences a company’s long-term economic performance.
A CFO must ensure that available investment funds are not only deployed but also allocated in a way that maximizes value creation.
The crucial question is therefore not solely:
“Which investment projects have the highest ROI?”
But rather:
“Which combination of our planned investments generates the highest overall economic contribution within our CAPEX budget?”
This perspective changes the way investment planning is approached.
Instead of ranking projects solely based on individual metrics, the overall portfolio is optimized.
This can reveal economic alternatives that would not have been considered in a traditional ranking-based decision.
A higher net value contribution can have a positive impact on the portfolio’s economic performance.
Whether the portfolio ROI increases at the same time depends on the specific combination of projects and the capital deployed.
Better capital allocation begins with calculating alternative project combinations—not with merely improving individual business cases.
10. Live at the Board Meeting: Five Strategic Questions, Five Calculated Investment Scenarios
An industrial conglomerate has 50 planned CAPEX projects.
The total investment requirement exceeds the available budget.
The executive board wants to know which combination of projects will generate the highest expected net value contribution.
Scenario A: Best combination within the existing CAPEX budget
The CFO asks:
“Which of our 50 investment projects should we select to achieve the highest total economic contribution within our budget?”
The projects are modeled collectively and optimized while taking the budget constraint into account.
Scenario B: Reduce the CAPEX budget by 20%
The CEO asks:
“How will our investment portfolio change if we have to reduce our CAPEX budget by 20%?”
The budget limit is adjusted.
StratePlan calculates a new combination of projects.
The executive board can see which projects will be eliminated and how the expected net value contribution will change.
Scenario C: Strategically Mandatory Projects
A member of the Executive Board asks:
“What are the implications if we have to implement three strategically important projects regardless of their individual returns?”
The projects in question are taken into account as binding constraints.
The portfolio is optimized again.
The comparison shows the modeled economic effects of this constraint.
Scenario D: Additional Investment Capital
The CFO asks:
“How much additional net value contribution could we achieve if we increased our CAPEX budget by 10 million euros?”
The budget constraint is increased, and a new combination of projects is calculated.
This allows us to examine which additional projects could be selected in a way that makes economic sense.
Scenario E: Other Strategic Priorities
The Executive Board asks:
“How does our investment portfolio change if we place greater emphasis on automation, energy efficiency, or specific growth areas?”
The corresponding evaluation parameters are adjusted.
The portfolio is recalculated and compared with the previous scenarios.
Change strategic assumptions. Recalculate the investment portfolio. Compare economic impacts. Make more informed decisions.
11. Opportunity Costs: The Invisible Loss of Value from Suboptimal Investment Decisions
Every investment decision ties up capital and resources.
This capital is then no longer available for other projects.
This results in opportunity costs.
They describe the lost benefits of the best alternative that was not chosen.
In mathematical portfolio optimization, the previously planned combination of projects can be compared with an optimized alternative.
The difference between the expected net value contributions indicates the modeled economic improvement potential.
Once the global optimum has been mathematically proven, the difference from the selected solution can be precisely determined within the model.
In approximate methods, the distance to the best solution found is first determined.
This raises important new questions for CFOs:
- How much of the total economic contribution remains untapped by our current combination of projects?
- Which projects are crowding out economically more attractive alternatives?
- What costs result from strategically binding investments?
- How does the value contribution change under different budget constraints?
- Which alternatives are economically close to the best solution identified?
Opportunity costs thus transform from an abstract financial concept into concrete, modelable decision-making information.
12. Case Study: Klybeck Site in Basel – Approximately 63% Higher Return on Investment
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.
These project-specific results do not constitute a general guarantee of return.
The key insight: A better combination of existing investment alternatives can enable a significantly higher overall economic contribution—without an additional CAPEX budget.
13. Risk, Liquidity, and Capital Commitment: Why the Objective Function Is Crucial
Mathematical portfolio optimization can pursue different economic objectives.
Maximizing net value added is one possible objective.
Depending on the model, other objective measures may also be relevant:
- Maximizing net present value
- Minimizing capital requirements
- Limiting total risk
- Optimizing multi-year investment budgets
- Accounting for liquidity constraints
- Maximizing defined strategic performance metrics
These objectives are not automatically compatible with one another.
For example, a portfolio with maximum net value contribution does not necessarily have the lowest risk or the lowest capital commitment.
That is why it is important to clearly define the objective function and the constraints.
A CFO can, for example, maximize net value contribution while simultaneously setting specific risk limits or liquidity constraints.
Mathematical optimization does not replace the definition of financial objectives. It consistently translates these into a calculable decision-making framework.
14. Sensitivity Analysis: How robust is the optimized investment portfolio?
Investment decisions are based on assumptions about future developments.
Project costs may rise. Revenues may be lower than expected. Resources may become scarcer.
Therefore, it makes sense not to consider only a single optimization scenario.
Sensitivity analyses allow for the examination of different assumptions.
Typical questions include:
- Which projects remain attractive even with a reduced CAPEX budget?
- How does the portfolio change as investment costs rise?
- What are the implications of lower revenue expectations?
- Which projects will be displaced if additional resource constraints arise?
- How stable is the calculated project mix under changing economic conditions?
These analyses help assess the robustness of different portfolio alternatives.
A well-founded capital allocation therefore considers not only the best value under a single assumption, but also the economic implications of potential changes.
15. From Business Intelligence to Decision Intelligence: The Next Level of CFO Management
Many companies already have comprehensive systems for financial planning and corporate management.
ERP systems document business processes.
Business intelligence platforms visualize key performance indicators.
Controlling systems analyze budget variances and financial results.
These systems answer important questions:
- How is our CAPEX budget developing?
- Which projects are on track?
- Which investments are generating the expected return?
- How are our cash flows changing?
Decision Intelligence broadens this perspective.
It examines which decisions should be made given the defined goals and constraints.
In the area of capital allocation, this means:
Which combination of our existing investment projects generates the highest overall economic contribution?
StratePlan supplements existing financial planning and controlling processes with a mathematical optimization layer.
The necessary project data can initially be provided via simple Excel spreadsheets.
This marks a transition from the mere analysis of existing investment plans to the calculation of alternative capital allocations.
Business intelligence becomes mathematically supported decision intelligence.
16. For which companies is a CFO ROI decision-making AI tool particularly relevant?
Mathematical portfolio optimization is particularly relevant when numerous investment projects are simultaneously competing for limited capital and resources.
Industrial and manufacturing companies
Production facilities, automation, capacity expansions, and site investments must be planned within shared CAPEX budgets.
Digital Transformation and AI Investments
Companies often identify numerous potential digitalization and AI projects.
Mathematical optimization can help determine an economically efficient combination of these initiatives.
Real Estate
Project developments, renovations, modernizations, and site investments compete for shared financing resources.
Energy and Infrastructure
Investment programs in the energy and infrastructure sectors often require long-term capital commitments and the consideration of technical dependencies.
Corporate Groups and Holding Companies
Multiple subsidiaries or business units compete for the same investment funds.
Company-wide portfolio optimization can help analyze capital allocation decisions across individual business units.
What matters is not the size of the company alone, but the complexity of the investment portfolio and the number of competing project alternatives.
17. Why Mathematical Capital Allocation Is a Governance Issue
Investment decisions are not driven solely by economic metrics.
Strategic goals, regulatory requirements, existing obligations, and corporate responsibility also play a role.
Mathematical portfolio optimization can make these decisions more transparent.
It makes it possible to systematically compare the effects of different criteria.
For example:
- What are the economic implications of mandatorily implementing a strategic project?
- How does the portfolio change as a result of additional sustainability requirements?
- Which projects will be displaced by a budget cut?
- How much of the total economic contribution remains untapped with a given capital allocation?
This allows decisions to be documented in a more transparent manner.
Responsibility remains with management.
Mathematical optimization provides an additional basis for decision-making.
The CFO continues to determine the goals and framework conditions. Optimization shows which combination of projects best meets these requirements from an economic standpoint.
18. Conclusion: The next leap in productivity for CFOs lies in capital allocation
Companies invest significant resources in evaluating individual investment projects.
Business cases are calculated in detail. Return metrics are compared. Investment programs are carefully planned.
However, the economic quality of the overall portfolio does not depend solely on the quality of these individual analyses.
It depends crucially on which projects are selected together.
With 25 projects, there are already more than 33 million theoretically possible combinations.
With 50 projects, the number rises to approximately 1.126 quadrillion.
This decision space cannot be fully assessed through traditional project prioritization alone.
Mathematical portfolio optimization makes it possible to systematically examine alternative investment combinations and compare their economic impacts.
To this end, StratePlan combines methods from operations research with AI-driven approaches.
This allows CFOs, CEOs, and finance executives to expand their capital allocation by adding a mathematical dimension to their decision-making.
The crucial question is not: Have we selected the best individual projects?
Rather: Have we selected the economically optimal combination of our investment projects?
This is precisely where the transition from traditional investment evaluation to mathematical capital allocation begins.
StratePlan – Same projects. Optimal combination. Better results.
FAQ – CFO ROI Decision-Making AI Tool
What is a CFO ROI Decision-Making AI Tool?
A CFO ROI Decision-Making AI Tool supports CFOs in the mathematical optimization of complex investment portfolios.
It analyzes different project combinations under defined budget and resource constraints and helps identify economically efficient capital allocations.
How does portfolio optimization differ from traditional project prioritization?
Traditional project prioritization evaluates individual investment projects based on defined metrics.
Portfolio optimization, on the other hand, examines which combination of these projects achieves the highest defined total contribution within the available resources.
Why isn’t the highest project ROI automatically the best investment decision?
A project with a high individual ROI can tie up significant amounts of capital or resources.
Several other projects combined could generate a higher absolute net value contribution.
Therefore, the economic quality of the entire portfolio must be considered.
What does “Maximize Net Contribution” mean?
“Maximize Net Contribution” refers to maximizing the total expected net value contribution of an investment portfolio within defined constraints.
Portfolio ROI can also be reported as an economic metric.
What is the difference between Net Contribution and Portfolio ROI?
Net Contribution describes the absolute economic net value contribution.
Portfolio ROI measures the economic contribution relative to the capital invested.
Maximizing both metrics can lead to different project combinations.
Why are there more than 33 million combinations for 25 projects?
If each project can either be selected or not selected, there are theoretically 2^N possible combinations for N projects.
With 25 projects, there are 2^25 = 33,554,432 combinations.
Can AI always calculate the global optimum?
With suitable mathematical models and optimization methods, a global optimum can be calculated and proven.
For particularly complex problems, approximately optimal solutions can also be used.
The assessment of solution quality depends on the method used and, where applicable, a proof of optimality.
Do all 2^N combinations have to be calculated individually?
No.
Modern mathematical optimization methods can efficiently explore large decision spaces without having to fully evaluate every theoretically possible combination individually.
Can Excel perform mathematical portfolio optimization?
Yes. Excel can handle mathematical optimization problems using appropriate Solver functions.
However, for large combinatorial decision spaces and complex constraints, specialized optimization methods may be necessary or more efficient.
What data does StratePlan require?
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 is specified.
More complex models can take additional constraints and evaluation parameters into account.
Can StratePlan account for strategically binding projects?
Strategically binding projects can be taken into account as fixed constraints with appropriate modeling.
This makes it possible to analyze the impact of these requirements on the entire investment portfolio.
Can StratePlan highlight opportunity costs?
By comparing an existing combination of projects with an optimized alternative, the modeled economic improvement potential can be determined.
If global optimality is proven, the difference from the global optimum can be precisely determined within the model.
Can StratePlan also account for multi-year CAPEX budgets?
Multi-year analyses are possible provided that the corresponding temporal data and constraints are incorporated into the optimization model.
This may include annual investment budgets, project durations, and cash flow requirements.
How high is the potential for improvement?
The economic improvement potential depends on the specific project list, the available budget, the constraints, and the defined targets.
A general improvement figure cannot be derived from this.
The StratePlan case study for the Klybeck site in Basel shows a modeled relative improvement in return on investment of approximately 63% with an identical budget.
This result is project-specific and does not constitute a general guarantee of return.
For which companies is a CFO ROI decision-making AI tool suitable?
Mathematical portfolio optimization is particularly relevant for companies with numerous competing investment projects and limited capital or resource budgets.
Typical areas of application include manufacturing, CAPEX planning, digital transformation, AI investments, real estate, energy, and infrastructure.
What is the most important takeaway for CFOs?
The economically best individual decision does not automatically lead to the best overall solution.
Mathematical portfolio optimization makes it possible to systematically examine alternative project combinations and improve capital allocation at the enterprise-wide level.
The key question is: Do we prioritize individual investment projects—or do we optimize the combination of our investments?
How much more overall economic value can you still extract from your CAPEX budget?
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 whether a different combination of existing projects could yield a higher total economic contribution.
You can optimize up to 15 projects for free.