Our Modelling Approach
In the capital-intensive steel industry, robust financial modelling is essential for effective decision-making. Whether you're seeking project financing, planning a major modernisation, or assessing business viability, a well-structured financial model provides the analytical foundation for confident strategic choices. MCI's financial modelling services help steel companies and their stakeholders understand the economic implications of proposed investments, operational changes, and market scenarios.
Our team develops comprehensive Excel-based financial models tailored specifically to steel industry operations, incorporating steel production costs, capital expenditure outlays, working capital requirements, and revenue projections. Clients scoping a financial model can find an overview of all available data resources — plant capacities, capex benchmarks, M&A transactions and cost models — on the steel datasets page. These models serve multiple critical purposes: demonstrating viability to lenders and investors, supporting internal business planning, evaluating strategic alternatives, and providing a framework for ongoing performance monitoring and variance analysis.
Financial Modelling Applications
Our financial modelling services support steel companies across a wide range of critical business scenarios:
- Viability Assessment: Determine whether existing or proposed operations can achieve sustainable profitability under realistic market and operating assumptions. These models incorporate detailed key performance indicators, production cost structures, market pricing scenarios, and sensitivity analysis to identify key value drivers and risk factors.
- Business Plan Development: Create robust financial projections to support strategic business planning. Our models translate operational strategies into quantified financial outcomes, enabling management teams to set realistic targets, allocate resources effectively, and communicate plans clearly to stakeholders.
- Funding Applications: Prepare the financial analysis required for bank lending, private equity investment, or development finance institution (DFI) applications. Our models meet lender requirements for detailed cash flow forecasting, debt service coverage analysis, and downside scenario testing.
- Investment Appraisal: Evaluate proposed capital investments including plant modernisation, capacity expansion, or new technology adoption. Models calculate key metrics such as NPV, IRR, and payback period whilst incorporating realistic implementation timelines and ramp-up curves.
- Restructuring Analysis: Support business turnaround initiatives by modelling the financial impact of operational improvements, asset disposals, debt restructuring, and organisational changes. These models help stakeholders understand the path to restored viability and sustainable operations.
- Acquisition Due Diligence: Build financial models to support buy-side or sell-side transaction analysis. Models incorporate synergy assumptions, integration costs, and post-acquisition performance projections to inform valuation and negotiation strategies.
Model Structure and Capabilities
Our financial models are built using industry-standard Excel practices with clear structure, transparent assumptions, and robust error-checking. Typical model components include:
- Production volume and product mix forecasts aligned with market analysis and capacity constraints
- Detailed operating cost build-up covering raw materials, energy, labour, maintenance, and overhead
- Capital expenditure schedules for plant and equipment investments
- Working capital calculations reflecting industry-typical payment terms and inventory requirements
- Revenue projections based on pricing assumptions and sales volume forecasts
- Funding structure incorporating equity, debt, and other financing sources
- Full financial statements: profit and loss, cash flow, and balance sheet
- Key performance metrics and financial ratios
- Sensitivity analysis and scenario planning capabilities.
Industry-Specific Expertise
Steel industry financial modelling requires deep understanding of sector-specific factors that generic financial consultants may overlook. Our models properly account for:
- Production Economics: Accurate representation of steel-specific cost structures including metallics consumption, energy intensity, yield losses [especially scrap credits], and quality-related costs. We understand the economics of different production routes (BOF, EAF, DRI-based) and can model complex multi-stage operations.
- Market Cycles: Appropriate treatment of steel industry price cyclicality and its impact on profitability. Our models can incorporate historical volatility analysis and help stress-test performance under adverse market conditions.
- Environmental Compliance: Inclusion of carbon costs, emissions trading implications, and capital requirements for environmental improvements – increasingly critical factors in steel industry economics.
- Technical Constraints: Realistic production ramp-up profiles, maintenance shutdown requirements, and the relationship between capacity utilisation and unit costs.
Engagement Process
Our typical financial modelling engagement follows a structured approach:
Initial Discussion (1-2 days): We meet with your team to understand the business context, modelling objectives, key assumptions, and timeline requirements. This scoping phase ensures the model addresses your specific decision-making needs.
Data Collection (1 week): We gather necessary information including historical financial performance, production data, cost structures, capital expenditure plans, and market assumptions. Our team can work from your existing data or help develop assumptions where information is limited.
Model Development (2-3 weeks): We build the financial model according to agreed specifications, incorporating all relevant market, operational and financial drivers. The model structure allows for easy assumption updates and scenario analysis.
Review and Refinement (1 week): We present the model to your team, walk through the logic and outputs, and refine based on your feedback. This iterative process ensures the model accurately represents your business and provides actionable insights.
Documentation and Training: We provide comprehensive model documentation explaining assumptions, calculations, and use.
Investment and Value
Financial modelling fees vary based on project complexity, model scope, and timeline requirements. Typical engagements range from 5-20 man days, with most assignments falling in the 10-15 day range. Modelling work is most often carried out inside a wider advisory or due diligence engagement, as our project experience record shows.
The investment in professional financial modelling delivers substantial value: enabling more informed decision-making, facilitating access to funding, providing a platform for performance management, and ultimately supporting better business outcomes. A well-constructed financial model serves as a strategic asset that continues delivering value long after the initial engagement.
Getting Started
If you're considering a financial modelling project, we welcome an initial discussion about your specific requirements. Contact us at info@steelonthenet.com or call +44 775 149 0885 to arrange a no-obligation consultation. We'll be pleased to explain how our financial modelling services can support your business objectives and provide a detailed proposal tailored to your needs.