The retainage and progress payment calculator gives the gross value earned, the retainage held with a rate reduction at a threshold, the net amount due to date and the net payment of the period of a construction contract.
How the calculation works
- Enter the contract sum, the percent complete and the stored materials billed to date.
- Enter the net payments already certified and the retainage rates with the threshold where the rate changes.
- The calculator gives the gross value earned, the retainage held, the net due to date and the net payment of the period.
Example
A contract of $2,400,000 is 58 % complete, with $45,000 of stored materials. The gross value to date is $1,437,000. Retainage is 10 % of the first 50 % of the contract, or $1,200,000, and 5 % above it, so $131,850 is held, an effective rate of 9.18 %. The net amount due to date is $1,305,150. After the $1,150,000 already certified, the payment of the period is $155,150.
Why it matters
The calculator helps contractors, subcontractors, owners and project accountants to prepare or check a payment application, to see how much is held back and for how long, and to plan the cash flow of a project.
Good to know
Match the percent complete with the schedule of values of the contract, and keep the previous certified amounts from the earlier applications. Check the retainage rule of each subcontract, because it often differs from the prime contract. Track the retainage as a separate account, since it is both a receivable for the contractor and a liability for the owner, and ask for its release in writing at the right milestone. Keep copies of the lien waivers, the certified payroll and the insurance certificates that the owner requires with each application, because a missing document delays the payment of the whole period.
Related tools
The earned value calculator compares the work done with the plan, the equipment owning and operating cost calculator gives the hourly cost of a machine, the markup calculator adds a margin to a cost and the overhead rate calculator spreads the fixed costs.