Civic Intelligence

John Duncan Inc.

Plan context: I & a Excavating Profit Sharing Plan and Trust

EIN 36-3535610 • Winfield, IL • 26 filings • 3 plans

28w421 Garys Mill RoadWinfield, IL 60190
Current Snapshot

Latest Year

2024

2024 Participants

6

2024 Assets

$4,306,501

2024 Contributions

$239,741

Historical Graphs

Total Assets Over Time

Aggregate end-of-year assets by filing year, excluding zero-asset years

$4,306,501$2,153,251$0199920122024YearValue
$4,306,501Latest year 2024

Participants Over Time

Largest reported end-of-year plan headcount by filing year, used to avoid double-counting participants across overlapping plans

740199920122024YearValue
6Latest year 2024

Company Timeline

Year summaries and individual filings are combined here so you can stay in one place while moving across years and plan filings.

Year / FilingFilingsParticipantsAssetsContributionsContrib./Participant
202416$4,306,501$239,741$39,957iApproximate average salary by contribution assumption: employee only about $998,921 at 4% or $665,947 at 6%; with 50% employer match about $665,947 at 4% or $443,965 at 6%; with 100% employer match about $499,460 at 4% or $332,974 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$4,306,501$239,741$39,957iApproximate average salary by contribution assumption: employee only about $998,921 at 4% or $665,947 at 6%; with 50% employer match about $665,947 at 4% or $443,965 at 6%; with 100% employer match about $499,460 at 4% or $332,974 at 6%.
202316$3,727,490$241,884$40,314iApproximate average salary by contribution assumption: employee only about $1,007,850 at 4% or $671,900 at 6%; with 50% employer match about $671,900 at 4% or $447,933 at 6%; with 100% employer match about $503,925 at 4% or $335,950 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$3,727,490$241,884$40,314iApproximate average salary by contribution assumption: employee only about $1,007,850 at 4% or $671,900 at 6%; with 50% employer match about $671,900 at 4% or $447,933 at 6%; with 100% employer match about $503,925 at 4% or $335,950 at 6%.
202216$2,996,451$207,413$34,569iApproximate average salary by contribution assumption: employee only about $864,221 at 4% or $576,147 at 6%; with 50% employer match about $576,147 at 4% or $384,098 at 6%; with 100% employer match about $432,110 at 4% or $288,074 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$2,996,451$207,413$34,569iApproximate average salary by contribution assumption: employee only about $864,221 at 4% or $576,147 at 6%; with 50% employer match about $576,147 at 4% or $384,098 at 6%; with 100% employer match about $432,110 at 4% or $288,074 at 6%.
202116$3,254,688$195,548$32,591iApproximate average salary by contribution assumption: employee only about $814,783 at 4% or $543,189 at 6%; with 50% employer match about $543,189 at 4% or $362,126 at 6%; with 100% employer match about $407,392 at 4% or $271,594 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$3,254,688$195,548$32,591iApproximate average salary by contribution assumption: employee only about $814,783 at 4% or $543,189 at 6%; with 50% employer match about $543,189 at 4% or $362,126 at 6%; with 100% employer match about $407,392 at 4% or $271,594 at 6%.
202016$2,757,606$162,522$27,087iApproximate average salary by contribution assumption: employee only about $677,175 at 4% or $451,450 at 6%; with 50% employer match about $451,450 at 4% or $300,967 at 6%; with 100% employer match about $338,588 at 4% or $225,725 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$2,757,606$162,522$27,087iApproximate average salary by contribution assumption: employee only about $677,175 at 4% or $451,450 at 6%; with 50% employer match about $451,450 at 4% or $300,967 at 6%; with 100% employer match about $338,588 at 4% or $225,725 at 6%.
201916$2,870,399$160,533$26,756iApproximate average salary by contribution assumption: employee only about $668,888 at 4% or $445,925 at 6%; with 50% employer match about $445,925 at 4% or $297,283 at 6%; with 100% employer match about $334,444 at 4% or $222,963 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$2,870,399$160,533$26,756iApproximate average salary by contribution assumption: employee only about $668,888 at 4% or $445,925 at 6%; with 50% employer match about $445,925 at 4% or $297,283 at 6%; with 100% employer match about $334,444 at 4% or $222,963 at 6%.
201815$2,290,334$138,933$27,787iApproximate average salary by contribution assumption: employee only about $694,665 at 4% or $463,110 at 6%; with 50% employer match about $463,110 at 4% or $308,740 at 6%; with 100% employer match about $347,333 at 4% or $231,555 at 6%.
I & a Excavating Profit Sharing Plan and Trust-5$2,290,334$138,933$27,787iApproximate average salary by contribution assumption: employee only about $694,665 at 4% or $463,110 at 6%; with 50% employer match about $463,110 at 4% or $308,740 at 6%; with 100% employer match about $347,333 at 4% or $231,555 at 6%.
201714$2,321,133$113,140$28,285iApproximate average salary by contribution assumption: employee only about $707,125 at 4% or $471,417 at 6%; with 50% employer match about $471,417 at 4% or $314,278 at 6%; with 100% employer match about $353,563 at 4% or $235,708 at 6%.
I & a Excavating Profit Sharing Plan and Trust-4$2,321,133$113,140$28,285iApproximate average salary by contribution assumption: employee only about $707,125 at 4% or $471,417 at 6%; with 50% employer match about $471,417 at 4% or $314,278 at 6%; with 100% employer match about $353,563 at 4% or $235,708 at 6%.
201615$2,090,332$94,611$18,922iApproximate average salary by contribution assumption: employee only about $473,055 at 4% or $315,370 at 6%; with 50% employer match about $315,370 at 4% or $210,247 at 6%; with 100% employer match about $236,528 at 4% or $157,685 at 6%.
I & a Excavating Profit Sharing Plan and Trust-5$2,090,332$94,611$18,922iApproximate average salary by contribution assumption: employee only about $473,055 at 4% or $315,370 at 6%; with 50% employer match about $315,370 at 4% or $210,247 at 6%; with 100% employer match about $236,528 at 4% or $157,685 at 6%.
201515$1,857,775$74,247$14,849iApproximate average salary by contribution assumption: employee only about $371,235 at 4% or $247,490 at 6%; with 50% employer match about $247,490 at 4% or $164,993 at 6%; with 100% employer match about $185,618 at 4% or $123,745 at 6%.
I & a Excavating Profit Sharing Plan and Trust-5$1,857,775$74,247$14,849iApproximate average salary by contribution assumption: employee only about $371,235 at 4% or $247,490 at 6%; with 50% employer match about $247,490 at 4% or $164,993 at 6%; with 100% employer match about $185,618 at 4% or $123,745 at 6%.
201415$1,830,399$93,443$18,689iApproximate average salary by contribution assumption: employee only about $467,215 at 4% or $311,477 at 6%; with 50% employer match about $311,477 at 4% or $207,651 at 6%; with 100% employer match about $233,607 at 4% or $155,738 at 6%.
I & a Excavating Profit Sharing Plan and Trust-5$1,830,399$93,443$18,689iApproximate average salary by contribution assumption: employee only about $467,215 at 4% or $311,477 at 6%; with 50% employer match about $311,477 at 4% or $207,651 at 6%; with 100% employer match about $233,607 at 4% or $155,738 at 6%.
201315$1,684,671$47,136$9,427iApproximate average salary by contribution assumption: employee only about $235,680 at 4% or $157,120 at 6%; with 50% employer match about $157,120 at 4% or $104,747 at 6%; with 100% employer match about $117,840 at 4% or $78,560 at 6%.
I & a Excavating Profit Sharing Plan and Trust-5$1,684,671$47,136$9,427iApproximate average salary by contribution assumption: employee only about $235,680 at 4% or $157,120 at 6%; with 50% employer match about $157,120 at 4% or $104,747 at 6%; with 100% employer match about $117,840 at 4% or $78,560 at 6%.
201215$1,440,254$15,000$3,000iApproximate average salary by contribution assumption: employee only about $75,000 at 4% or $50,000 at 6%; with 50% employer match about $50,000 at 4% or $33,333 at 6%; with 100% employer match about $37,500 at 4% or $25,000 at 6%.
I & a Excavating Profit Sharing Plan and Trust-5$1,440,254$15,000$3,000iApproximate average salary by contribution assumption: employee only about $75,000 at 4% or $50,000 at 6%; with 50% employer match about $50,000 at 4% or $33,333 at 6%; with 100% employer match about $37,500 at 4% or $25,000 at 6%.
201115$1,245,666$0-
I & a Excavating Profit Sharing Plan and Trust-5$1,245,666$0-
201015$1,307,654$835$167iApproximate average salary by contribution assumption: employee only about $4,175 at 4% or $2,783 at 6%; with 50% employer match about $2,783 at 4% or $1,856 at 6%; with 100% employer match about $2,088 at 4% or $1,392 at 6%.
I & a Excavating Profit Sharing Plan and Trust-5$1,307,654$835$167iApproximate average salary by contribution assumption: employee only about $4,175 at 4% or $2,783 at 6%; with 50% employer match about $2,783 at 4% or $1,856 at 6%; with 100% employer match about $2,088 at 4% or $1,392 at 6%.
200915$1,141,669$2,159$432iApproximate average salary by contribution assumption: employee only about $10,795 at 4% or $7,197 at 6%; with 50% employer match about $7,197 at 4% or $4,798 at 6%; with 100% employer match about $5,398 at 4% or $3,598 at 6%.
I & a Excavating Profit Sharing Plan and Trust-5$1,141,669$2,159$432iApproximate average salary by contribution assumption: employee only about $10,795 at 4% or $7,197 at 6%; with 50% employer match about $7,197 at 4% or $4,798 at 6%; with 100% employer match about $5,398 at 4% or $3,598 at 6%.
200816$929,261$71,288$11,881iApproximate average salary by contribution assumption: employee only about $297,033 at 4% or $198,022 at 6%; with 50% employer match about $198,022 at 4% or $132,015 at 6%; with 100% employer match about $148,517 at 4% or $99,011 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$929,261$71,288$11,881iApproximate average salary by contribution assumption: employee only about $297,033 at 4% or $198,022 at 6%; with 50% employer match about $198,022 at 4% or $132,015 at 6%; with 100% employer match about $148,517 at 4% or $99,011 at 6%.
200716$1,443,058$103,675$17,279iApproximate average salary by contribution assumption: employee only about $431,979 at 4% or $287,986 at 6%; with 50% employer match about $287,986 at 4% or $191,991 at 6%; with 100% employer match about $215,990 at 4% or $143,993 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$1,443,058$103,675$17,279iApproximate average salary by contribution assumption: employee only about $431,979 at 4% or $287,986 at 6%; with 50% employer match about $287,986 at 4% or $191,991 at 6%; with 100% employer match about $215,990 at 4% or $143,993 at 6%.
200616$1,294,352$125,881$20,980iApproximate average salary by contribution assumption: employee only about $524,504 at 4% or $349,669 at 6%; with 50% employer match about $349,669 at 4% or $233,113 at 6%; with 100% employer match about $262,252 at 4% or $174,835 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$1,294,352$125,881$20,980iApproximate average salary by contribution assumption: employee only about $524,504 at 4% or $349,669 at 6%; with 50% employer match about $349,669 at 4% or $233,113 at 6%; with 100% employer match about $262,252 at 4% or $174,835 at 6%.
200516$1,091,977$164,284$27,381iApproximate average salary by contribution assumption: employee only about $684,517 at 4% or $456,344 at 6%; with 50% employer match about $456,344 at 4% or $304,230 at 6%; with 100% employer match about $342,258 at 4% or $228,172 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$1,091,977$164,284$27,381iApproximate average salary by contribution assumption: employee only about $684,517 at 4% or $456,344 at 6%; with 50% employer match about $456,344 at 4% or $304,230 at 6%; with 100% employer match about $342,258 at 4% or $228,172 at 6%.
200415$884,937$156,889$31,378iApproximate average salary by contribution assumption: employee only about $784,445 at 4% or $522,963 at 6%; with 50% employer match about $522,963 at 4% or $348,642 at 6%; with 100% employer match about $392,223 at 4% or $261,482 at 6%.
I & a Excavating Profit Sharing Plan and Trust-5$884,937$156,889$31,378iApproximate average salary by contribution assumption: employee only about $784,445 at 4% or $522,963 at 6%; with 50% employer match about $522,963 at 4% or $348,642 at 6%; with 100% employer match about $392,223 at 4% or $261,482 at 6%.
200317$619,044$159,164$22,738iApproximate average salary by contribution assumption: employee only about $568,443 at 4% or $378,962 at 6%; with 50% employer match about $378,962 at 4% or $252,641 at 6%; with 100% employer match about $284,221 at 4% or $189,481 at 6%.
I & a Excavating Profit Sharing Plan and Trust-7$619,044$159,164$22,738iApproximate average salary by contribution assumption: employee only about $568,443 at 4% or $378,962 at 6%; with 50% employer match about $378,962 at 4% or $252,641 at 6%; with 100% employer match about $284,221 at 4% or $189,481 at 6%.
200216$367,185$148,611$24,769iApproximate average salary by contribution assumption: employee only about $619,213 at 4% or $412,808 at 6%; with 50% employer match about $412,808 at 4% or $275,206 at 6%; with 100% employer match about $309,606 at 4% or $206,404 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$367,185$148,611$24,769iApproximate average salary by contribution assumption: employee only about $619,213 at 4% or $412,808 at 6%; with 50% employer match about $412,808 at 4% or $275,206 at 6%; with 100% employer match about $309,606 at 4% or $206,404 at 6%.
200117$0$0-
I & a Excavating Profit Sharing Plan and Trust-7---
200016$212,980$64,612$10,769iApproximate average salary by contribution assumption: employee only about $269,217 at 4% or $179,478 at 6%; with 50% employer match about $179,478 at 4% or $119,652 at 6%; with 100% employer match about $134,608 at 4% or $89,739 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$212,980$64,612$10,769iApproximate average salary by contribution assumption: employee only about $269,217 at 4% or $179,478 at 6%; with 50% employer match about $179,478 at 4% or $119,652 at 6%; with 100% employer match about $134,608 at 4% or $89,739 at 6%.
199916$186,947$52,950$8,825iApproximate average salary by contribution assumption: employee only about $220,625 at 4% or $147,083 at 6%; with 50% employer match about $147,083 at 4% or $98,056 at 6%; with 100% employer match about $110,313 at 4% or $73,542 at 6%.
I & a Excavating Profit Sharing Plan and Trust-6$186,947$52,950$8,825iApproximate average salary by contribution assumption: employee only about $220,625 at 4% or $147,083 at 6%; with 50% employer match about $147,083 at 4% or $98,056 at 6%; with 100% employer match about $110,313 at 4% or $73,542 at 6%.