Civic Intelligence

Rose Excavating Inc.

Plan context: Rose Excavating Inc. Profit Sharing Trust

EIN 25-1539975 • Johnstown, PA • 18 filings • 2 plans

197 Bracken StreetJohnstown, PA 15909
Current Snapshot

Latest Year

2017

2017 Participants

2

2017 Assets

$676,831

2017 Contributions

$10,000

Historical Graphs

Total Assets Over Time

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

$707,047$353,524$0199920092016YearValue
$676,831Latest year 2016

Participants Over Time

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

320199920082016YearValue
2Latest year 2016

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
201710$0$0-
Rose Excavating Inc. Profit Sharing Trust-0$0--
201612$676,831$0-
Rose Excavating Inc. Profit Sharing Trust-2$676,831--
201512$656,525$0-
Rose Excavating Inc. Profit Sharing Trust-2$656,525--
201412$707,047$10,000$5,000iApproximate average salary by contribution assumption: employee only about $125,000 at 4% or $83,333 at 6%; with 50% employer match about $83,333 at 4% or $55,556 at 6%; with 100% employer match about $62,500 at 4% or $41,667 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$707,047$10,000$5,000iApproximate average salary by contribution assumption: employee only about $125,000 at 4% or $83,333 at 6%; with 50% employer match about $83,333 at 4% or $55,556 at 6%; with 100% employer match about $62,500 at 4% or $41,667 at 6%.
201312$652,312$17,181$8,591iApproximate average salary by contribution assumption: employee only about $214,763 at 4% or $143,175 at 6%; with 50% employer match about $143,175 at 4% or $95,450 at 6%; with 100% employer match about $107,381 at 4% or $71,588 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$652,312$17,181$8,591iApproximate average salary by contribution assumption: employee only about $214,763 at 4% or $143,175 at 6%; with 50% employer match about $143,175 at 4% or $95,450 at 6%; with 100% employer match about $107,381 at 4% or $71,588 at 6%.
201212$551,529$17,320$8,660iApproximate average salary by contribution assumption: employee only about $216,500 at 4% or $144,333 at 6%; with 50% employer match about $144,333 at 4% or $96,222 at 6%; with 100% employer match about $108,250 at 4% or $72,167 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$551,529$17,320$8,660iApproximate average salary by contribution assumption: employee only about $216,500 at 4% or $144,333 at 6%; with 50% employer match about $144,333 at 4% or $96,222 at 6%; with 100% employer match about $108,250 at 4% or $72,167 at 6%.
201112$477,983$17,123$8,562iApproximate average salary by contribution assumption: employee only about $214,038 at 4% or $142,692 at 6%; with 50% employer match about $142,692 at 4% or $95,128 at 6%; with 100% employer match about $107,019 at 4% or $71,346 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$477,983$17,123$8,562iApproximate average salary by contribution assumption: employee only about $214,038 at 4% or $142,692 at 6%; with 50% employer match about $142,692 at 4% or $95,128 at 6%; with 100% employer match about $107,019 at 4% or $71,346 at 6%.
201012$469,646$24,438$12,219iApproximate average salary by contribution assumption: employee only about $305,475 at 4% or $203,650 at 6%; with 50% employer match about $203,650 at 4% or $135,767 at 6%; with 100% employer match about $152,738 at 4% or $101,825 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$469,646$24,438$12,219iApproximate average salary by contribution assumption: employee only about $305,475 at 4% or $203,650 at 6%; with 50% employer match about $203,650 at 4% or $135,767 at 6%; with 100% employer match about $152,738 at 4% or $101,825 at 6%.
200912$409,416$17,838$8,919iApproximate average salary by contribution assumption: employee only about $222,975 at 4% or $148,650 at 6%; with 50% employer match about $148,650 at 4% or $99,100 at 6%; with 100% employer match about $111,488 at 4% or $74,325 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$409,416$17,838$8,919iApproximate average salary by contribution assumption: employee only about $222,975 at 4% or $148,650 at 6%; with 50% employer match about $148,650 at 4% or $99,100 at 6%; with 100% employer match about $111,488 at 4% or $74,325 at 6%.
200812$298,003$18,138$9,069iApproximate average salary by contribution assumption: employee only about $226,725 at 4% or $151,150 at 6%; with 50% employer match about $151,150 at 4% or $100,767 at 6%; with 100% employer match about $113,363 at 4% or $75,575 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$298,003$18,138$9,069iApproximate average salary by contribution assumption: employee only about $226,725 at 4% or $151,150 at 6%; with 50% employer match about $151,150 at 4% or $100,767 at 6%; with 100% employer match about $113,363 at 4% or $75,575 at 6%.
200712$0$0-
Rose Excavating Inc. Profit Sharing Trust-2---
200612$376,692$27,425$13,713iApproximate average salary by contribution assumption: employee only about $342,813 at 4% or $228,542 at 6%; with 50% employer match about $228,542 at 4% or $152,361 at 6%; with 100% employer match about $171,406 at 4% or $114,271 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$376,692$27,425$13,713iApproximate average salary by contribution assumption: employee only about $342,813 at 4% or $228,542 at 6%; with 50% employer match about $228,542 at 4% or $152,361 at 6%; with 100% employer match about $171,406 at 4% or $114,271 at 6%.
200512$308,683$40,925$20,463iApproximate average salary by contribution assumption: employee only about $511,563 at 4% or $341,042 at 6%; with 50% employer match about $341,042 at 4% or $227,361 at 6%; with 100% employer match about $255,781 at 4% or $170,521 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$308,683$40,925$20,463iApproximate average salary by contribution assumption: employee only about $511,563 at 4% or $341,042 at 6%; with 50% employer match about $341,042 at 4% or $227,361 at 6%; with 100% employer match about $255,781 at 4% or $170,521 at 6%.
200412$248,609$22,650$11,325iApproximate average salary by contribution assumption: employee only about $283,125 at 4% or $188,750 at 6%; with 50% employer match about $188,750 at 4% or $125,833 at 6%; with 100% employer match about $141,563 at 4% or $94,375 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$248,609$22,650$11,325iApproximate average salary by contribution assumption: employee only about $283,125 at 4% or $188,750 at 6%; with 50% employer match about $188,750 at 4% or $125,833 at 6%; with 100% employer match about $141,563 at 4% or $94,375 at 6%.
200312$212,502$44,565$22,283iApproximate average salary by contribution assumption: employee only about $557,063 at 4% or $371,375 at 6%; with 50% employer match about $371,375 at 4% or $247,583 at 6%; with 100% employer match about $278,531 at 4% or $185,688 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$212,502$44,565$22,283iApproximate average salary by contribution assumption: employee only about $557,063 at 4% or $371,375 at 6%; with 50% employer match about $371,375 at 4% or $247,583 at 6%; with 100% employer match about $278,531 at 4% or $185,688 at 6%.
200212$138,233$26,265$13,133iApproximate average salary by contribution assumption: employee only about $328,313 at 4% or $218,875 at 6%; with 50% employer match about $218,875 at 4% or $145,917 at 6%; with 100% employer match about $164,156 at 4% or $109,438 at 6%.
Rose Excavating Inc. Profit Sharing Trust-2$138,233$26,265$13,133iApproximate average salary by contribution assumption: employee only about $328,313 at 4% or $218,875 at 6%; with 50% employer match about $218,875 at 4% or $145,917 at 6%; with 100% employer match about $164,156 at 4% or $109,438 at 6%.
200013$178,630$11,213$3,738iApproximate average salary by contribution assumption: employee only about $93,442 at 4% or $62,294 at 6%; with 50% employer match about $62,294 at 4% or $41,530 at 6%; with 100% employer match about $46,721 at 4% or $31,147 at 6%.
Rose Excavating Inc. Profit Sharing Trust-3$178,630$11,213$3,738iApproximate average salary by contribution assumption: employee only about $93,442 at 4% or $62,294 at 6%; with 50% employer match about $62,294 at 4% or $41,530 at 6%; with 100% employer match about $46,721 at 4% or $31,147 at 6%.
199913$205,514$13,938$4,646iApproximate average salary by contribution assumption: employee only about $116,150 at 4% or $77,433 at 6%; with 50% employer match about $77,433 at 4% or $51,622 at 6%; with 100% employer match about $58,075 at 4% or $38,717 at 6%.
Rose Excavating Inc. Profit Sharing Trust-3$205,514$13,938$4,646iApproximate average salary by contribution assumption: employee only about $116,150 at 4% or $77,433 at 6%; with 50% employer match about $77,433 at 4% or $51,622 at 6%; with 100% employer match about $58,075 at 4% or $38,717 at 6%.