Simulating Cash Flow Model for Mega Construction Projects in Egypt | ||||
| JES. Journal of Engineering Sciences | ||||
| Article 2, Volume 49, No 6, November and December 2021, Page 734-752 PDF (703.16 K) | ||||
| Document Type: Research Paper | ||||
| DOI: 10.21608/jesaun.2021.79839.1056 | ||||
 View on SCiNiTO | ||||
| Author | ||||
Yasser Mahmoud Aboelmagd 
| ||||
| Assistant Professor in the Department of Mathematics and physics Engineering, Faculty of Engineering, Alexandria University, Alexandria, 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". | ||||
| Keywords | ||||
| Construction management; Road Construction; Prediction Model; Spread Sheets, Cash Flow | ||||
| 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. | ||||
|
Statistics Article View: 442 PDF Download: 1,003 |
||||
