Investment Modeling and Capital Efficiency Assessment in Retail

Implementation Period: 2015–2016

Toolkit: DCF Analysis, Sensitivity Analysis, Monte-Carlo Simulation Elements

Role: Lead Financial Analyst

Context:

Securing financing for the construction of transport infrastructure facilities requires flawless justification of economic feasibility. ALLTERRA GROUP conducted a full-cycle investment analysis for an auto-complex construction project, substantiating its attractiveness to private investors and credit institutions.

ALLTERRA GROUP’s Solution:

• Developed a dynamic financial model (P&L, Cash Flow, Balance Sheet) with quarterly granularity over a 5-year horizon, accounting for demand seasonality and construction phases.
• Calculated key efficiency metrics: NPV (Net Present Value) amounted to RUB 668 million, IRR (Internal Rate of Return) reached 69%, and PI (Profitability Index) stood at 2.18.
• Conducted sensitivity analysis of the project to changes in key drivers: revenue volume, organizational costs, and fuel/service cost of goods sold.
• Identified break-even points and financial stability zones: the project remains profitable even with a 54% drop in revenue or a 4,893% increase in organizational costs.
• Developed risk management scenarios (regulatory changes, raw material price hikes, currency risks).

Result:

Both projects demonstrated high investment attractiveness and rapid payback (DPP ~1.8 years). The models served as the basis for strategic decision-making and provided owners with a clear understanding of acceptable risk boundaries. Investors received not just forecasts, but a verified architecture of profitability.