Free Excel templates

A free Davis-Bacon fringe calculator in Excel: annualize your health, paid leave, 401(k) and training credit and find the cash in lieu

Basic rates and fringe amounts of the wage determination, plan costs and the hours worked in the plan year in; the annualized credit per hour, the cash in lieu, the cash rate and the error of dividing by Davis-Bacon hours out: one sheet of inputs, live formulas and five checks.

In the worked case a plumber's plans are worth $15.92 per Davis-Bacon hour against a fringe of $19.85, so $3.93 is paid in cash; dividing the costs by Davis-Bacon hours only would claim $24.47 and leave $4,519.50 unpaid over the year.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 212 free models.

Davis_Bacon_Fringe_Calculator.xlsx (11 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Davis-Bacon Handbook, which explains the method behind it, chapter by chapter.

Get the PDF edition → See the book

Want every model at once?

The Financial Model Library: all 213 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

3 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Inputs
Basic rate, fringe amount and private rate for three classifications; health premium, paid vacation and holiday hours, 401(k) per Davis-Bacon hour, training per hour; hours worked in the plan year and Davis-Bacon hours.
Credit
Annual costs, then for each classification the annualized credit by benefit, the total, the cash in lieu and the cash rate; the surplus of a laborer's credit; the divisor error and the shortfall it leaves.
Checks
Five tests on hours, rates, private rates and the sum of the credits, and an All checks cell.

What the worked case returns

MeasureValue
Plumber: health credit per hour$9.12
Plumber: paid leave credit per hour$2.45
Plumber: total plan credit per hour$15.92
Plumber: cash in lieu per hour$3.93
Plumber: cash rate on Davis-Bacon hours$46.43
Sheet metal worker: total credit per hour$15.78
Sheet metal worker: cash in lieu per hour$1.82
Laborer: credit above the fringe amount$5.93
Error: credit claimed when dividing by Davis-Bacon hours$24.47
Error: shortfall per worker over the year$4,519.50

Every figure is a teaching assumption of the book's fictional case, and the wage determination lines are illustrative: replace them with the rates of your contract. Whether a plan is bona fide or qualifies for the 401(k) exception is a question for counsel and the plan's administrator. Not legal, payroll or benefits advice.

How to use it on your own case

  1. Type the basic rate and fringe amount of each classification from your wage determination, and your private cash rates.
  2. Enter the annual cost of each plan: health premium, paid leave hours, 401(k) and training contributions.
  3. Enter the hours the worker is projected to work in the plan year, private and Davis-Bacon, and the Davis-Bacon hours.
  4. Read the credit per hour, the cash in lieu, the cash rate and the checks.

Questions people ask about it

Why divide by all hours worked, not Davis-Bacon hours?

Because 29 CFR 5.25(c) requires it: a benefit that covers the worker all year is credited at its cost per hour worked over the whole period.

Does the calculator annualize the 401(k)?

No. It assumes the plan meets the exception for immediate participation and vesting within the first 500 hours; if yours does not, annualize it like the health plan.

What if the credit exceeds the fringe amount?

No cash in lieu is owed, and the surplus cannot reduce the basic rate. The calculator shows it for the laborer.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Davis-Bacon Handbook go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Davis-Bacon Handbook. See the book.