Civic Intelligence

PRESCRIPTION COMPOUNDING SPECIALISTS, INC.

Plan context: PRESCRIPTION COMPOUNDING SPECI 401(K) PROFIT SHARING PLAN & TRUST

EIN 20-0099450 • Aiea, HI • 28 filings • 5 plans

99-115 Aiea Heights Dr Ste 301Aiea, HI 96701-3915
Current Snapshot

Latest Year

2024

2024 Participants

7

2024 Assets

$1,273,425

2024 Contributions

$64,994

Historical Graphs

Total Assets Over Time

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

$1,448,199$724,100$0200520152024YearValue
$1,273,425Latest year 2024

Participants Over Time

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

1160200520152024YearValue
7Latest 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
202417$1,273,425$64,994$9,285iApproximate average salary by contribution assumption: employee only about $232,121 at 4% or $154,748 at 6%; with 50% employer match about $154,748 at 4% or $103,165 at 6%; with 100% employer match about $116,061 at 4% or $77,374 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401(K) PROFIT SHARING PLAN & TRUST-7$1,273,425$64,994$9,285iApproximate average salary by contribution assumption: employee only about $232,121 at 4% or $154,748 at 6%; with 50% employer match about $154,748 at 4% or $103,165 at 6%; with 100% employer match about $116,061 at 4% or $77,374 at 6%.
202318$1,448,199$103,073$12,884iApproximate average salary by contribution assumption: employee only about $322,103 at 4% or $214,735 at 6%; with 50% employer match about $214,735 at 4% or $143,157 at 6%; with 100% employer match about $161,052 at 4% or $107,368 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401(K) PROFIT SHARING PLAN & TRUST-8$1,448,199$103,073$12,884iApproximate average salary by contribution assumption: employee only about $322,103 at 4% or $214,735 at 6%; with 50% employer match about $214,735 at 4% or $143,157 at 6%; with 100% employer match about $161,052 at 4% or $107,368 at 6%.
202219$1,272,906$96,459$10,718iApproximate average salary by contribution assumption: employee only about $267,942 at 4% or $178,628 at 6%; with 50% employer match about $178,628 at 4% or $119,085 at 6%; with 100% employer match about $133,971 at 4% or $89,314 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401(K) PROFIT SHARING PLAN & TRUST-9$1,272,906$96,459$10,718iApproximate average salary by contribution assumption: employee only about $267,942 at 4% or $178,628 at 6%; with 50% employer match about $178,628 at 4% or $119,085 at 6%; with 100% employer match about $133,971 at 4% or $89,314 at 6%.
202119$1,441,556$101,659$11,295iApproximate average salary by contribution assumption: employee only about $282,386 at 4% or $188,257 at 6%; with 50% employer match about $188,257 at 4% or $125,505 at 6%; with 100% employer match about $141,193 at 4% or $94,129 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401(K) PROFIT SHARING PLAN & TRUST-9$1,441,556$101,659$11,295iApproximate average salary by contribution assumption: employee only about $282,386 at 4% or $188,257 at 6%; with 50% employer match about $188,257 at 4% or $125,505 at 6%; with 100% employer match about $141,193 at 4% or $94,129 at 6%.
202019$1,232,654$97,300$10,811iApproximate average salary by contribution assumption: employee only about $270,278 at 4% or $180,185 at 6%; with 50% employer match about $180,185 at 4% or $120,123 at 6%; with 100% employer match about $135,139 at 4% or $90,093 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401(K) PROFIT SHARING PLAN & TRUST-9$1,232,654$97,300$10,811iApproximate average salary by contribution assumption: employee only about $270,278 at 4% or $180,185 at 6%; with 50% employer match about $180,185 at 4% or $120,123 at 6%; with 100% employer match about $135,139 at 4% or $90,093 at 6%.
2019110$1,136,672$362,049$36,205iApproximate average salary by contribution assumption: employee only about $905,123 at 4% or $603,415 at 6%; with 50% employer match about $603,415 at 4% or $402,277 at 6%; with 100% employer match about $452,561 at 4% or $301,708 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401(K) PROFIT SHARING PLAN & TRUST-10$1,136,672$362,049$36,205iApproximate average salary by contribution assumption: employee only about $905,123 at 4% or $603,415 at 6%; with 50% employer match about $603,415 at 4% or $402,277 at 6%; with 100% employer match about $452,561 at 4% or $301,708 at 6%.
2018110$706,784$117,100$11,710iApproximate average salary by contribution assumption: employee only about $292,750 at 4% or $195,167 at 6%; with 50% employer match about $195,167 at 4% or $130,111 at 6%; with 100% employer match about $146,375 at 4% or $97,583 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401(K) PROFIT SHARING PLAN & TRUST-10$706,784$117,100$11,710iApproximate average salary by contribution assumption: employee only about $292,750 at 4% or $195,167 at 6%; with 50% employer match about $195,167 at 4% or $130,111 at 6%; with 100% employer match about $146,375 at 4% or $97,583 at 6%.
201718$658,817$87,958$10,995iApproximate average salary by contribution assumption: employee only about $274,869 at 4% or $183,246 at 6%; with 50% employer match about $183,246 at 4% or $122,164 at 6%; with 100% employer match about $137,434 at 4% or $91,623 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401 K PROFIT SHARING PLAN TRUST-8$658,817$87,958$10,995iApproximate average salary by contribution assumption: employee only about $274,869 at 4% or $183,246 at 6%; with 50% employer match about $183,246 at 4% or $122,164 at 6%; with 100% employer match about $137,434 at 4% or $91,623 at 6%.
2016111$548,170$105,088$9,553iApproximate average salary by contribution assumption: employee only about $238,836 at 4% or $159,224 at 6%; with 50% employer match about $159,224 at 4% or $106,149 at 6%; with 100% employer match about $119,418 at 4% or $79,612 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401 K PROFIT SHARING PLAN TRUST-11$548,170$105,088$9,553iApproximate average salary by contribution assumption: employee only about $238,836 at 4% or $159,224 at 6%; with 50% employer match about $159,224 at 4% or $106,149 at 6%; with 100% employer match about $119,418 at 4% or $79,612 at 6%.
201519$568,706$90,924$10,103iApproximate average salary by contribution assumption: employee only about $252,567 at 4% or $168,378 at 6%; with 50% employer match about $168,378 at 4% or $112,252 at 6%; with 100% employer match about $126,283 at 4% or $84,189 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401 K PROFIT SHARING PLAN TRUST-9$568,706$90,924$10,103iApproximate average salary by contribution assumption: employee only about $252,567 at 4% or $168,378 at 6%; with 50% employer match about $168,378 at 4% or $112,252 at 6%; with 100% employer match about $126,283 at 4% or $84,189 at 6%.
201419$507,112$54,356$6,040iApproximate average salary by contribution assumption: employee only about $150,989 at 4% or $100,659 at 6%; with 50% employer match about $100,659 at 4% or $67,106 at 6%; with 100% employer match about $75,494 at 4% or $50,330 at 6%.
PRESCRIPTION COMPOUNDING SPECI 401(K) PROFIT SHARING PLAN & TRUST-9$507,112$54,356$6,040iApproximate average salary by contribution assumption: employee only about $150,989 at 4% or $100,659 at 6%; with 50% employer match about $100,659 at 4% or $67,106 at 6%; with 100% employer match about $75,494 at 4% or $50,330 at 6%.
201318$518,964$55,038$6,880iApproximate average salary by contribution assumption: employee only about $171,994 at 4% or $114,663 at 6%; with 50% employer match about $114,663 at 4% or $76,442 at 6%; with 100% employer match about $85,997 at 4% or $57,331 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. 401(K) PSP-8$518,964$55,038$6,880iApproximate average salary by contribution assumption: employee only about $171,994 at 4% or $114,663 at 6%; with 50% employer match about $114,663 at 4% or $76,442 at 6%; with 100% employer match about $85,997 at 4% or $57,331 at 6%.
201228$390,227$59,277$7,410iApproximate average salary by contribution assumption: employee only about $185,241 at 4% or $123,494 at 6%; with 50% employer match about $123,494 at 4% or $82,329 at 6%; with 100% employer match about $92,620 at 4% or $61,747 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. 401(K) PSP-8$390,227$59,277$7,410iApproximate average salary by contribution assumption: employee only about $185,241 at 4% or $123,494 at 6%; with 50% employer match about $123,494 at 4% or $82,329 at 6%; with 100% employer match about $92,620 at 4% or $61,747 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. FLEXIBLE BENEFITS PLAN-3---
201128$291,550$59,463$7,433iApproximate average salary by contribution assumption: employee only about $185,822 at 4% or $123,881 at 6%; with 50% employer match about $123,881 at 4% or $82,588 at 6%; with 100% employer match about $92,911 at 4% or $61,941 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. 401(K) PSP-8$291,550$59,463$7,433iApproximate average salary by contribution assumption: employee only about $185,822 at 4% or $123,881 at 6%; with 50% employer match about $123,881 at 4% or $82,588 at 6%; with 100% employer match about $92,911 at 4% or $61,941 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. FLEXIBLE BENEFITS PLAN-1---
201027$256,477$49,234$7,033iApproximate average salary by contribution assumption: employee only about $175,836 at 4% or $117,224 at 6%; with 50% employer match about $117,224 at 4% or $78,149 at 6%; with 100% employer match about $87,918 at 4% or $58,612 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. 401(K) PSP-7$256,477$49,234$7,033iApproximate average salary by contribution assumption: employee only about $175,836 at 4% or $117,224 at 6%; with 50% employer match about $117,224 at 4% or $78,149 at 6%; with 100% employer match about $87,918 at 4% or $58,612 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. FLEXIBLE BENEFITS PLAN-1---
200928$182,655$48,515$6,064iApproximate average salary by contribution assumption: employee only about $151,609 at 4% or $101,073 at 6%; with 50% employer match about $101,073 at 4% or $67,382 at 6%; with 100% employer match about $75,805 at 4% or $50,536 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. 401(K) PSP-8$182,655$48,515$6,064iApproximate average salary by contribution assumption: employee only about $151,609 at 4% or $101,073 at 6%; with 50% employer match about $101,073 at 4% or $67,382 at 6%; with 100% employer match about $75,805 at 4% or $50,536 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. FLEXIBLE BENEFITS PLAN-1---
200827$96,268$44,619$6,374iApproximate average salary by contribution assumption: employee only about $159,354 at 4% or $106,236 at 6%; with 50% employer match about $106,236 at 4% or $70,824 at 6%; with 100% employer match about $79,677 at 4% or $53,118 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. 401K PSP-7$96,268$44,619$6,374iApproximate average salary by contribution assumption: employee only about $159,354 at 4% or $106,236 at 6%; with 50% employer match about $106,236 at 4% or $70,824 at 6%; with 100% employer match about $79,677 at 4% or $53,118 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. FLEXIBLE BENEFITS PLAN-1---
200725$0$0-
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. FLEXIBLE BENEFITS PLAN-2---
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. 401K PSP-5---
200625$65,781$34,846$6,969iApproximate average salary by contribution assumption: employee only about $174,230 at 4% or $116,153 at 6%; with 50% employer match about $116,153 at 4% or $77,436 at 6%; with 100% employer match about $87,115 at 4% or $58,077 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. 401K PSP-5$65,781$34,846$6,969iApproximate average salary by contribution assumption: employee only about $174,230 at 4% or $116,153 at 6%; with 50% employer match about $116,153 at 4% or $77,436 at 6%; with 100% employer match about $87,115 at 4% or $58,077 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. FLEXIBLE BENEFITS PLAN-2---
200526$24,568$24,051$4,009iApproximate average salary by contribution assumption: employee only about $100,213 at 4% or $66,808 at 6%; with 50% employer match about $66,808 at 4% or $44,539 at 6%; with 100% employer match about $50,106 at 4% or $33,404 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. 401K PSP-6$24,568$24,051$4,009iApproximate average salary by contribution assumption: employee only about $100,213 at 4% or $66,808 at 6%; with 50% employer match about $66,808 at 4% or $44,539 at 6%; with 100% employer match about $50,106 at 4% or $33,404 at 6%.
PRESCRIPTION COMPOUNDING SPECIALISTS, INC. FLEXIBLE BENEFITS PLAN-1---