PPP Road OPEX CAPEX Bottom up Cost Model (Excel Template)
This Excel template provides a structured bottom-up lifecycle cost model for road infrastructure projects, covering both CAPEX and OPEX under a PPP / concession framework.The model is designed to support technical and financial analysis by combining historic cost structures, engineering quantities, and lifecycle assumptions into a single forecasting tool.🔹 Model Features Scenario control (Base / Lower / Upper cases) CAPEX and Heavy Maintenance forecasting OPEX modelling based on historic cost categories Pavement, structures, lighting, signage and asset-related calculations Staffing, vehicle operations and routine maintenance costs Traffic-based growth and escalation logic Integrated lifecycle cost forecasting and outputs 🔹 Workbook Structure Inputs and assumptions Cost rate tables and inventories O&M calculations and category aggregation Heavy Maintenance (HM) calculations Forecast and output summary tables 🔹 Intended Users Infrastructure analysts Project finance professionals Technical advisors and consultants Engineers supporting lifecycle cost assessments 🔹 Important NotesThis template is provided as a generic analytical framework and should be adapted to project-specific requirements.The model is intended for educational and analytical purposes.
Get it → infracostmodels.gumroad.com