Simulating Cash Flow Model for Mega Construction Projects in Egypt

Abstract
This research presents a cash flow construction road projects prediction model. The model based upon actual current invoices analysis and payments data of road construction projects. Initial results indicate that this simple model is best way for predicting future cash flows especially construction road projects. The main concern is to look at highway road tender projects. This investigation could be used by road authorities who manage multiple projects. It could be used for providing a forecast technique of new project payments. Latest researches from General Authority for Road, Bridges and Land Transporting (GARBLT) projects from 2003 to 2020 were analyzed. This data is used to implement mathematical models for road construction to represent monthly payment invoices for different projects types. Cost estimates of financial data were collected from 78 highway road contracts which are consist of 46 highway strengthening contracts and 32 highway overlay contracts. All collected data from field was arranged into main categories and/or subcategories according to project type and contract amount. A polynomial regression analysis for seventh degree is done for all collected data, and then regression curve is constructed. Statistically equations were performed and taken into research consideration to can provide payment curve expectation. Finally, proposed built in model by using Microsoft Excel was implemented to develop investigation results. The proposed model was named as Multi Road Projects Cash Flow Model "MRPCFM".