Cash model
Enter gross certificates and receipt timing, select a manual Early or Late payment profile, and schedule retention releases. Outstanding net certificates, retention and unrecovered advance remain visible at the horizon.
Product case study
In development — not yet on saleCASH FLOW & MANPOWERکاربرگ نقدینگی و نیروی انسانی
A manual Excel forecast for monthly cash and manpower capacity; commercial release pending.
The rebuilt workbook models 24 months of contractor cash flows from dated certificates, retention, advance recovery and selected payment inputs. Month-end funding needs and manpower capacity update with the inputs. Calculations and both native charts have been checked in desktop Excel; sales remain closed.
Product snapshot
- Platform
- Microsoft Excel
- Scope
- 24 months / up to 24 certificates
- Verification
- Calculations and charts checked in Excel 16.0
- Sales
- Not open
The product question
Connect monthly work plans with payment timing and resource needs.
A useful cash forecast must distinguish costs, expected receipts, deductions and cash balances. A manpower forecast must also make the capacity assumptions visible.
Key product decisions
Verification
24 calculation checks cover date boundaries, payment delays, recovery caps, missing inputs and capacity. The saved workbook was also recalculated in Excel 16.0, including both linked charts. A Persian and English guide accompanies the file.
Defined scope
Project-start forecast with one receipt per certificate and monthly closing cash. No partial receipts, opening receivables, VAT, financing interest, automatic P6 import or resource-leveling algorithm. Manpower inputs are manual.
Current outcome
Current outcome
The workbook is ready for review within its documented manual-input scope. This is a cash forecast and capacity report; it does not calculate schedule dates or reschedule resources.
My role
Monthly cash modeling, resource reporting and calculation verification.
Next step
Commercial release remains closed while plan scope, support and delivery are finalized. You can request an estimate for a project-specific setup.