In this monthly cash flow template excel, you can create s-curve cash flow for any construction project
-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
-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.
-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
–Value of work: actually performed in the field. The total value of work done to date is obtained in different ways, depending on the
–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.
-Construction projects can make substantial demands on a contractor’s cash.
-Cash out = payment of costs = expense
–“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