Project Cash Flow Creation Steps

Jul 4, 2024

Creating Project Cash Flow

Introduction

  • Part of financial planning
  • Summary of master cash flow
  • Planning for project completion

Process of Creating Cash Flow

Master Schedule

  • Planning for project completion (80 days)
  • Stage-wise activities
  • Data provided by planning engineer

Necessary Information

  • Final project price bill data
  • Final rate bill and quantity of the project
  • Quantity of items in the master schedule
  • Create columns for different activities

Example:

  • Cost of saline: 158 lakhs
  • Calculate the quantity of items (foundation, columns, plaster, etc.)
  • Create a measurement sheet (MB)

Therefore

  • Calculate the quantity of the complete project
  • Calculation of cement and steel
  • Project master schedule

Establishing Connection

  • Copy data into the master schedule
  • Link the payment amount with activities
  • Ample example: Link of foundation

Working of Activities

  • Month-wise sharing
  • Adding data according to measurements
  • Month-wise working, like all activities of August

Calculation of Cement and Steel Consumption

  • Stage-wise
  • Calculation of quantity (in bags)
  • Gather stage-wise data

Conclusion

  • Creating the final project cash flow is complex, but with good planning, it is possible.
  • Input all data correctly to avoid any mistakes in the project.