Monthly Cash Flow Template For Construction Projects “Excel XLS”

Monthly Cash Flow Template For Construction Projects “Excel XLS”

Overview:

In this monthly cash flow template excel, you can create s-curve cash flow for any construction project

Free Cash Flow Template

-Cash Flow S-Curve template can be used for tracking cash in and cash out

-Cash Flow S-Curve template shows the needed cash every month

Monthly Cash Flow Plan

-In order to make a workable project plan, the resources needed for the project & their availability must be checked.

-Money is one of the most important resources.

-Cash flow forecasting is required to determine whether or not the funds to execute the plan are available.

-Cash flow forecasting is the forecasting of both cash in &  cash out of the project.

Cash In

-Construction project contracts typically provide that the client shall make progress payments of the contract amount to the prime contractor as the work progresses.

-Cash in = Cash receipt = Income

Main components of cash in

Value of work: actually performed in the field. The total value of work done to date is obtained in different ways, depending on the
contract type.

Material stored: on the site, but not yet incorporated into work, as well as any prefabrication or pre-assembly work that the contractor may have done at some location other than the job site.

Cash Out

-Construction projects can make substantial demands on a contractor’s cash.

-Cash out = payment of costs = expense

Main components of cash out

“Up-front” costs = initial expenses = start-up costs are costs necessary to start the project such as costs of moving in workers & equipment; erecting field offices, fences, storage sheds, job layout; installation of water, temporary electrical, telephone, sanitary & other services; bonds; permits &  project insurance.

-Payment of direct job costs. These include costs associated with materials, payrolls, equipment & subcontractor payments.

-Payments for filed overhead expense & tax.

-An S-curve is a smooth curve is used to represent contract cash out




Related Materials:
Understanding Project S-Curve
S-Curve Excel Template
Advanced S-Curve Excel Template

Download Template

error: Content is protected !!
0
preloader