Retainage and Cash Flow Calculator

Profit and cash are different animals. A job can be priced correctly, run efficiently and finish exactly on the margin you bid, and still require more of your money in the middle than you have, because you paid for it months before you were paid for it.

Usually monthly. Six billings is roughly a six-month job.
Everything you spend. The rest is your gross profit.
Held back from each progress payment. What is permitted is a matter of contract and state law.
From submitting the billing to the money landing, not the terms on the invoice
Supplier terms and payroll blended. Payroll is effectively zero.
From substantial completion to the holdback landing. Often longer than the contract says.
Received at the start and credited against the first billings
Optional. Your line of credit rate, to put a price on the gap.
Retainage and Cash Flow Calculator — The Cash Gap on a Progress-Billed JobBuildFigure

What retainage does to a job that is otherwise fine

Retainage, or holdback, is a percentage withheld from each progress payment and released after the work is complete and whatever conditions the contract sets have been satisfied. Its purpose is straightforward: it gives the party paying a reserve against defective or unfinished work. Its effect on the contractor is equally straightforward. You perform the work, you pay for the labor and materials that went into it, you bill for it, and you receive less than you billed, with the difference held for months.

The number worth staring at is the comparison in the output above between the retainage held and the gross profit on the job. On a job with a ten percent holdback and a fifteen percent margin, the retainage is two thirds of everything you will make, and it arrives last. On thinner margins it exceeds the profit outright, which means that until release you are financing an amount larger than the entire upside of the work. Nothing about that indicates a badly run job. It is the normal shape of progress-billed contracting.

The lag usually hurts more than the percentage

Contractors negotiate hard on the retainage percentage and often ignore the payment lag, which on many jobs is the larger effect. Retainage is a share of the contract held once. The lag applies to every dollar of every billing, every month, for the length of the job. Cutting a forty-five day cycle to thirty does more for your cash position than cutting a ten percent holdback to five, and it is frequently more achievable, because a lot of the lag is administrative rather than contractual.

Where the administrative time goes is worth auditing. Billings submitted late because the paperwork was not ready, billings rejected and resubmitted because a lien waiver or a certified payroll document was missing, billings that sat waiting for someone to approve a quantity nobody had verified. Each of those adds a cycle. The contractors who get paid fastest are usually the ones whose documentation is complete on the first submission, which is a solvable problem rather than a negotiation.

Working capital is per job, and jobs overlap

The deepest cash hole in the output is what one job requires. Two jobs of similar size running with offset schedules require something approaching twice as much, and this is the mechanism behind the oldest failure pattern in contracting: a business grows, wins more and larger work, is profitable on every job, and runs out of cash. Growth consumes working capital before it produces any, and the faster it grows the more it consumes.

What raises the cash requirementWhy
Longer payment lagEvery dollar billed sits longer before arriving
Higher retainageA larger share of each payment is deferred to the end
Front-loaded costsMaterials bought early are paid before the work is billed
Paying suppliers faster than you are paidThe gap between your terms and theirs is your money
More jobs running at onceThe holes add rather than offset

The controllable items on that list are the last three. Supplier terms are negotiable and often more negotiable than customer terms. Material can sometimes be scheduled to arrive nearer to installation. And how many jobs you take at once is a decision, even when it does not feel like one.

The release is the payment most likely to slip

Progress payments have a rhythm and people expect them. The retainage release does not; it happens once, at the end, when everyone has moved on to other work and the person who has to approve it is not thinking about your job. It is also the payment most easily held up, because it is commonly conditioned on completing a punch list, providing waivers or releases from your own suppliers and subcontractors, or supplying closeout documentation nobody discussed at the start.

The practical response is to find out at signing exactly what the release requires and to assemble it as you go rather than at the end. What those conditions may lawfully be, what deadlines apply to a claim if the release does not come, and what lien or bond rights stand behind the money are all matters of state law, they vary considerably, and they change. Mechanics lien rights in particular carry strict deadlines that are unforgiving of a contractor who waits. Nothing on this page tells you what those rules are where you work, and no calculator can. That belongs with a construction attorney in your state, and a CPA who works with contractors should be setting up the cash flow forecasting that turns one job model like this into a picture of the whole business. Our guide to contract terms covers the general shape of what an agreement should settle, without being a substitute for either.

Questions people ask

How is retainage different from a payment lag?

A lag delays the whole payment; retainage removes part of it until much later. Both cost you cash but they behave differently. A thirty day lag on a six month job means you are always about a month of work ahead of your money, and the gap stays roughly constant. Retainage accumulates: every billing adds to a pile that does not come back until the end, so the amount you are financing grows through the job and peaks near completion. That is why the deepest hole in the model above usually sits late rather than early.

Can I hold retainage from my own subcontractors?

Contractors commonly pass a holdback down the chain, and doing so is one way the cash burden is shared rather than absorbed entirely at one level. Whether you may, at what percentage, on what timing, and what you must disclose are contract terms and in many places are also regulated, differently in different states, with different rules again for public and private work. Do not copy a percentage from your prime contract on the assumption that it is permitted downstream. Ask a construction attorney in your state what applies to your contracts, and have the terms drafted rather than adapted from something you found.

What does the cost of money field actually calculate?

It applies your annual rate to the negative balance over the days it is negative, which approximates the interest on a line of credit used to bridge the gap. It is a simple day-weighted calculation rather than a compounding one, so treat it as an order of magnitude. The point it makes is that carrying cost is a real reduction in the margin of the job, and on thin-margin work with a long cycle it can consume a noticeable share of what you thought you were making. If you are borrowing to fund jobs, the true cost also includes fees and the opportunity cost of the facility being committed.

Should I bid a higher price on a job with heavy retainage and slow payment?

It is a defensible position, because the terms genuinely cost you money and the cost is calculable rather than hypothetical. The model above gives you the number. Whether the market lets you price it in depends on how competitive the work is and on whether the other bidders have understood their own cash cycle, which many have not. The alternative response is to decline work whose terms you cannot fund, which is a legitimate business decision and a much better one than taking it and discovering mid-job that you cannot pay your suppliers.

Does a deposit solve this?

It helps, sometimes substantially, because money at the start offsets exactly the front-loaded costs that create the early part of the hole. It does not touch the retainage, which still accumulates and still releases at the end. In the model above a deposit is credited against the billings, so it moves cash earlier without changing the contract value or the total held back. What deposits are customary or permitted for your kind of work is again a matter of contract and state law rather than something to assume, and for residential work in particular some states regulate it.

Related