Prevailing Wage and Fringe Calculator (Davis-Bacon): Annualization and Cash Owed (Free Excel)

David Gul · Last updated November 16, 2026

A Davis-Bacon prevailing wage is the base rate plus the fringe in the wage determination, and every hour worked must be paid at least that total, in cash, in contributions to bona fide benefit plans, or both. A plan’s hourly credit is its cost for a period divided by every hour the worker worked in that period, private jobs included: a health plan that costs 4,160 a year over 2,080 hours is 2.00 an hour. The calculator below works out that credit, the cash still owed for one worker’s week, the overtime premium and WH-347 columns 6B and 6C. The free workbook does the same for a whole crew, and EG Certified Payroll (WH-347) checks every line of the weekly certified payroll before you sign it.

ExcelGurus is not affiliated with, endorsed by, or acting for the U.S. Department of Labor or any other federal agency. The calculator and the workbook give estimates and checks; they are not legal advice.

Check one worker’s week

Type the wage determination’s rates, one benefit plan’s cost and hours, and one week’s pay. The calculator runs in your browser and sends nothing you type.

If the calculator does not show, the free workbook below runs the same check.

Worked examples

A health plan spread over the year

Two laborers on a wage determination of 22.50 plus 8.10 fringe, each with a family health plan that costs the employer 4,160 a year. The credit depends on how many hours share that cost.

WorkerPlan cost for the yearHours worked that year, all jobsHourly creditFringe still owed per hour
A4,160.002,0802.006.10
B4,160.002,6001.606.50

B works more hours, so each hour gets less of the plan. Paying B the same 6.10 cash in lieu as A leaves B 0.40 an hour short, 17.60 for a 44-hour week. The rule is 29 CFR 5.25(c): divide the plan’s cost by every hour worked in the period it pays for, private work and Davis-Bacon work together, and work it out for each worker on their own.

Private work in the same year

The Department of Labor’s Field Operations Handbook gives this one (15f14(f)(3)): an employer pays 2,000 a year into a benefit plan for a worker who works 1,500 hours on Davis-Bacon jobs and 500 hours on private jobs. The credit is 2,000 over all 2,000 hours, 1.00 an hour, so only 1,500 of the 2,000 counts toward the Davis-Bacon fringe; the other 500 pays for the private hours. Dividing by the 1,500 Davis-Bacon hours alone would claim 1.3333 an hour, and the difference would be fringe still owed in cash.

A week with overtime

Worker A from the first table, as the workbook’s example row: a laborer paid 22.50 an hour with the 2.00 health plan credit and 6.10 cash in lieu, 30.60 an hour in all, which meets 22.50 plus 8.10. A works 44 hours, 4 of them over 40.

  • Fringe: owed on all 44 hours at the straight amount, never times one and a half.
  • Overtime premium: half of 22.50 for each of the 4 hours, 45.00, so the overtime rate is 33.75.
  • WH-347 column 6B: 44 hours times the 2.00 credit, 88.00. Column 6C: 44 times 6.10, 268.40.

Of A’s 2,080 hours that year, 1,560 were on Davis-Bacon jobs, so 1,040 of the 4,160 pays for private work. Press Fill in the example in the calculator to see each figure.

Free Davis-Bacon Fringe Calculator workbook (Excel)

Your classifications from the wage determination, every worker’s plans with their credit spread over all hours, and one row per worker per week for a whole crew: cash owed, overtime premium, and WH-347 6B and 6C, with totals. It also takes a plan’s waiting period. Formulas only: no macros, no sign-up, and nothing leaves the file.

Download the free workbook (.xlsx)

Version 1.0.1, with the examples above filled in. It uses only functions Excel 2016 has, and it is tested in Excel for Microsoft 365 on Windows and Excel for Mac (version 16.89); uploaded to Google Sheets, it gives the same results.

The workbook's Weekly check sheet with its two example rows. Riley Torres, Laborer: rate paid 22.50, cash in lieu 6.10, 40 straight-time and 4 overtime hours, overtime paid at 33.75, plan credit 2.00, owed and paid 30.60 an hour, overtime premium 45.00, 6B 88.00, 6C 268.40, result OK. Marisol Vega, Carpenter: paid 36.00 with a 3.00 pension credit against 49.50 owed, short 10.50 an hour and 420.00 cash owed, result Short. Tiles above show cash owed 420.00, overtime premium short 0.00 and one row short.

The Weekly check of the free workbook, with its sample rows: Marisol’s pension covers 3.00 of the 13.50 fringe, so 10.50 an hour is owed in cash.

What the calculator counts

  • Owed per hour: the wage determination’s base rate plus its fringe, for every hour worked, overtime hours included (29 CFR 5.5(a)(1)). Any mix of cash, plan contributions and cash in lieu that reaches the total meets it (29 CFR 5.31).
  • Hourly credit: the employer’s cost for the period over every hour worked in that period, on all jobs, to four decimals (29 CFR 5.25(c)). Use the period the cost pays for: a monthly premium over that month’s hours, a yearly cost over the year’s. A yearly cost paid in advance may use the hours of the year before (Field Operations Handbook 15f12). Employee contributions never count.
  • Exempt DC pension: a defined contribution pension plan with immediate participation and vesting within the first 500 hours worked, whose benefit is not continuous and does not pay for both private and Davis-Bacon work, is not annualized (29 CFR 5.25(c)(2) and (c)(3)). Its credit is the contribution per Davis-Bacon hour, so type the Davis-Bacon hours it was paid on as the hours.
  • Short per hour: owed per hour minus the rate paid, the plan credit and cash in lieu, when that leaves more than half a cent. Cash owed this week is that times every hour, straight time and overtime.
  • Overtime premium: half of the higher of the wage determination’s base rate and the cash rate paid, for each hour over 40 in the workweek, never on fringe or cash in lieu (FAR 22.406-2(c), 29 CFR 5.32). Type the overtime rate paid to check it.
  • WH-347 6B and 6C: the week’s hours times the plan credit, and times the cash in lieu.

Each worker and each classification stands on its own: one worker’s surplus never covers another’s shortfall. The prevailing wage and fringe guide explains each part of the obligation, and the overtime guide the premium.

What it leaves out

The calculator takes one worker, one plan and one classification for one week. The workbook adds a crew, several plans per worker and waiting periods. Neither covers a worker in two classifications in the same week, apprentices and trainees, unfunded plans (they need the Department of Labor’s approval under 29 CFR 5.28), deductions and net pay, daily overtime or collective bargaining rules, or state prevailing wage laws, which set their own rates and sometimes their own annualization rules.

Common questions

Do I divide a plan’s cost by all hours or only Davis-Bacon hours?

By all hours. Under 29 CFR 5.25(c), a plan’s cost for a period is divided by every hour the worker worked in that period, on private and Davis-Bacon work together, and the result is the hourly credit against the fringe. Dividing by the Davis-Bacon hours alone overstates the credit, and the difference is fringe still owed in cash. Where the plan costs different amounts for different workers, the credit is worked out for each worker.

Is fringe owed on overtime hours?

Yes, on every hour worked, overtime included, at the straight fringe amount, never times one and a half. The overtime premium is half of the higher of the base rate in the wage determination and the cash rate paid, for each hour over 40 in the workweek, and it is never figured on fringe or cash in lieu (FAR 22.406-2(c)).

Can a 401(k) skip annualization?

Only when it meets every condition of 29 CFR 5.25(c)(2) and (c)(3): it is a defined contribution pension plan with immediate participation, the benefit vests within the first 500 hours worked, the benefit is not continuous in nature, and it does not pay for both private and Davis-Bacon work. Then no exception request is needed, and the credit is the contribution per Davis-Bacon hour. Otherwise it is annualized like any other plan, and any other exception needs a written request granted by the Wage and Hour Division.

Every line, every week

EG Certified Payroll (WH-347) keeps each worker’s plans with their annual cost and hours and works out the hourly credit every week. It figures the overtime from the base rate, keeps fringe at the straight amount on every hour, fills columns 6B and 6C and page 2’s hourly credit table, and checks base plus fringe on every line, showing you every finding before you approve the payroll.

See EG Certified Payroll (WH-347)

Free trial, the full product; every printed page carries a TRIAL COPY mark until a license is activated. Excel for Windows or Mac.

Sources

Read on November 16, 2026; the regulations as the eCFR showed them, current to November 12, 2026.

More in this series: Prevailing Wage and Fringe Benefits on Certified Payroll · Overtime on Certified Payroll: The Rate, the Base and the Hours · All certified payroll guides

★★★★★

“Most likely one of the best freelancers I’ve had the opportunity of working with. I would highly recommend David for any complex VBA coding. We’ll be working with him again in the future.”

VBA Development Client · via Upwork, 2020

5.0★ across 230+ client reviews · 100% Job Success on Upwork · Building Excel tools since 2010 · Read the reviews →

Scroll to Top