Simulating Cash Flow Model for Mega Construction Projects in Egypt

Aboelmagd, Yasser Mahmoud

doi:10.21608/jesaun.2021.79839.1056

Simulating Cash Flow Model for Mega Construction Projects in Egypt

Document Type : Research Paper

Author

Yasser Mahmoud Aboelmagd

Assistant Professor in the Department of Mathematics and physics Engineering, Faculty of Engineering, Alexandria University, Alexandria, Egypt

10.21608/jesaun.2021.79839.1056

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".

Keywords

Main Subjects

Civil Engineering: structural, Geotechnical, reinforced concrete and steel structures, Surveying, Road and traffic engineering, water resources, Irrigation structures, Environmental and sanitary engineering, Hydraulic, Railway, construction Management.

References

[1]. Michael Schellenger and Joann Noe Cross (1994) "FASB 95, Cash flow and Bankruptcy", Journal of Economics and Finance 18 (3), 261-274.

[2]. Cristine do Nascimento Mutti and Will Hughes (2002) "Cash flow management in construction firms", Greenwood, D (Ed.), 18th Annual ARCOM Conference, 2-4 September 2002, University of Northumbria. Association of Researchers in Construction Management, Vol. 1, 23-32.

[3]. Gholamreza Kordestani, Vahid Biglari, and Mehrdad Bakhtiari (2011) "Ability of combinations of cash flow components to predict financial distress", Malaya University, 50603 Kuala Lumpur, Malaysia.

[4]. Ibrahim Lubwama (2006) "Construction project Cash Flow Prediction for Owners", King Fahad University of Petroleum & Minerals.

[5]. Navon R. (1996) “Company-level cash-flow management”, Journal of Construction Engineering and Management, ASCE, 122 (1), 22-29.

[6]. Reinschmidt K.F. and Frank W.E. (1977) "Construction cash flow management system", Journal of Construction Engineering and Management, ASCE, 102 (4), 615-627.

[7]. Kenley R. (1999) "Cash farming in building and construction: a stochastic analysis", Construction Management and Economics, 17 (4), 393-401.

[8]. Cygas D., Laurinavicius, A., Vaitkus, A., Perveneckas, Z., and Motiejunas, A, (2008) "Research of Asphalt Pavement Structures on Lithuanian Roads", Baltic Journal of Road and Bridge Engineering, 3 (2), 77-83.

[9]. Skrodenis B., Venckauskaite J., and Burinskiene (2009) "Substantiation of Communication Infrastructure Selection in Newly Developed Territories", Baltic Journal of Road and Bridge Engineering, 4 (2), 87-94.

[10]. Simon E., Gibson G., Haas C., O'Connor J., Somali B., and Zhang Z., (2002)" Development of a tool for expediting highway construction while retaining quality," University of Texas at Austin. Center for Transportation Research, Texas. Department of Transportation, United States. Federal Highway Administration.

[11]. Joseph Prather (2008) "Cash Management Spending Plan", Transportation Cabinet, Frankfurt, Kentucky.

[12]. Tian Chen; Hao Hu; and Fengfeng Zhu (2020) "Developing a Hierarchical Road Layout Method for Large-Scale Construction Site" Journal of Construction Engineering and Management Volume 146 Issue 9.

[13]. Peter E. D. Love, D.Sc.; Chun-Pong Sing, Brad Carey; and Jeong Tai Kim (2015) "Estimating Construction Contingency: Accommodating the Potential for Cost Overruns in Road Construction Projects" Journal of Infrastructure Systems Volume 21 Issue 2.

[14]. Dan Chong; Lin Chen; and Jianxun Xie (2019) "Occupational Health Management in Road Construction Enterprises: A View of Cognitive Bias"International Conference on Construction and Real Estate Management.

[15]. Pramen P. Shrestha, Kabindra K. Shrestha, and Thomas K. Kandie (2017) "Effects of Change Orders on the Cost and Schedule of Rural Road Maintenance Projects" Journal of Legal Affairs and Dispute Resolution in Engineering and Construction Volume 9 Issue 3.

[16]. Yunping Liang, Baabak Ashuri, and Mingshu Li (2021) “Forecasting the Construction Expenditure Cash Flow for Transportation Design-Build Projects with a Case-Based Reasoning Model” Journal of Construction Engineering and Management, 147 (6): 04021043.