Beta
190856

Simulating Cash Flow Model for Mega Construction Projects in Egypt

Article

Last updated: 23 Jan 2023

Subjects

-

Tags

Civil Engineering: structural, Geotechnical, reinforced concrete and s…nd sanitary engineering, Hydraulic, Railway, construction Management.

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

DOI

10.21608/jesaun.2021.79839.1056

Keywords

Construction Management, Road Construction, prediction model, Spread Sheets, Cash Flow

Authors

First Name

Yasser

Last Name

Aboelmagd

MiddleName

Mahmoud

Affiliation

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

Email

yasser.aboelmajd@alexu.edu.eg

City

-

Orcid

-

Volume

49

Article Issue

No 6

Related Issue

18892

Issue Date

2021-11-01

Receive Date

2021-06-09

Publish Date

2021-11-01

Page Start

734

Page End

752

Print ISSN

1687-0530

Online ISSN

2356-8550

Link

https://jesaun.journals.ekb.eg/article_190856.html

Detail API

https://jesaun.journals.ekb.eg/service?article_code=190856

Order

2

Type

Research Paper

Type Code

1,438

Publication Type

Journal

Publication Title

JES. Journal of Engineering Sciences

Publication Link

https://jesaun.journals.ekb.eg/

MainTitle

-

Details

Type

Article

Created At

23 Jan 2023