Retirement plan

PUEBLO OF SANDIA COMMERCIAL ENTERPRISES 401(K) PROFIT SHARING PLAN AND TRUST

Name: PUEBLO OF SANDIA - PUEBLO OF SANDIA COMMERCIAL ENTERPRISES 401(K) PROFIT SHARING PLAN AND TRUST (2023) Form 5500
Creator: PUEBLO OF SANDIA
License: https://www.dol.gov/general/disclaim
Keywords: Form 5500, ERISA, retirement plan, PUEBLO OF SANDIA COMMERCIAL ENTERPRISES 401(K) PROFIT SHARING PLAN AND TRUST, PUEBLO OF SANDIA

PUEBLO OF SANDIAEIN 85-0223706Plan #003PY 2023

CONNIE TRUJILLO, HR DEPT 30 RAINBOW - ALBUQUERQUE, NM 87113505-867-3317LinkedIn51-200 employeeshigher education

Prospect flagsLow participation

How to read this page

Total assets (EOY)

$45.3M

+19.8% from 2022

Total participants

1,531

-3.2% from 2022

Average account balance

$47,476

+32.5% from 2022

Annual return

15.86%

+30.74 pp from 2022

Benchmarks

See 8,002 peers

Peer group

Industryany (size+type match)

Plan typeDefined contribution

Participants1,000-4,999

Cohort8,002 peers

Snapshot2023

Free accounts unlock saves, downloads, and 3-year history.

Analytics

Total assets (EOY)

Plan-year ending balance

$51.94M

Not enough data

1 years with asset history on file

Average account balance

Total assets / participants with a balance (line 6g)

$56K

Not enough data

1 years with per-participant data

Participants with account balance

Stacked by status: active / separated vested / retired or beneficiary. Total = line 6g.

920

Not enough data

1 years with headcount on file

Eligible Participants and Participation

Bars: eligible actives (line 6a). Line: derived rate = active employees with a balance / 6a.

56.3%

Not enough data

1 years with eligibility data

Contributions (total)

Employer and participant dollars contributed each year

$5.25M

Not enough data

1 years with contributions on file

Contributions per participant

Average employer and participant contribution per enrolled participant

$4K

Not enough data

1 years with per-participant contribution data

Asset flow

BOY + contributions + return - distributions = EOY

Year

Annual return

Diverging bars; negative years highlighted

+12.34%

Not enough data

1 years with return on file

Admin fee / account holder

Total admin expenses / participants with a balance (line 6g)

$225

Not enough data

1 years with admin cost on file

Asset composition

Cash / stocks / bonds / mutual funds / real estate / loans over time

Not enough data

1 years with F_SCH_H allocation on file

Free accounts unlock saves, downloads, and 3-year history.

Service providers

Top 4 by compensation

Provider	Service type	Compensation
REDW STANLEY FINANCIAL ADVISORS LLC4 years Filed as: REDW WEALTH FINANCIAL ADVISORS LLC Service code 26 · EIN 85-0467977	Advisory (Participants)	$109,659
SENTINEL PENSION ADVISORS1 year Filed as: SENTINEL BENEFITS GROUP, LLC Service code 15 · EIN 20-5916766	Recordkeeping	$63,722
LOFTIS & LOVATO GROUP4 years Service code 10 · EIN 84-3463346	Accounting	$19,373
ALLIANCE BENEFIT GROUP9+ years Filed as: ALLIANCE BENEFIT GROUP SOUTHWEST LL Service code 15 · EIN 38-3944313	Recordkeeping	$18,929

Plan features & details

Pension benefit codes2E2F2G2J2K2T

Plan features

2E
Profit-sharing
Profit-sharing plan.
2F
ERISA section 404(c) plan
This plan or any part of it is intended to meet the conditions of 29 CFR 2550.404c-1 (shifting investment responsibility to participants).
2G
Total participant-directed account plan
Participants have the opportunity to direct the investment of all of the assets allocated to their individual accounts regardless of whether 29 CFR 2550.404c-1 is intended to be met.
2J
Code section 401(k) feature
Cash or deferred arrangement described in Code section 401(k) that is part of a qualified defined contribution plan under which employees may elect to defer part of their compensation or receive these amounts in cash.
2K
Code section 401(m) arrangement
Employee contributions are allocated to separate accounts under the plan or employer contributions are based in whole or in part on employee deferrals or contributions to the plan. Not applicable to 401(k) plans with only QNECs and/or QMACs or to 403(b)(1) 403(b)(7) or 408 arrangements.
2T
Default investment account
Total or partial participant-directed account plan where plan uses a default investment account for participants who fail to direct assets in their account.

Opportunity flags

1 tripped

OpportunityLow participation
Participation rate is below 70% (account-balance holders / active employees) - enrollment or auto-enroll opportunity.

Expense breakdown

Schedule H Part II

Admin total

$212K

$162 / participant

Recordkeeping$83K39.0%
Investment mgmt$110K51.8%
Other / not subdivided$19K9.2%

% of EOY assets

0.467%

all-in expense ratio

Categories reported

2 / 9

subdivided buckets used

Audit opinion

Schedule H Part III

Unqualified opinion

Auditor signed off without reservation - the cleanest possible opinion.

Auditor firm: LOFTIS & LOVATO GROUP
Auditor EIN: 843463346
Audit fees: $19,373
Opinion code: Unqualified

Metric

This plan

Peer set

Industry

Size

Avg account balance

$47,476

$80,157-40.8%

$70,160-32.3%

$80,157-40.8%

Participation rate

55.8%

72.9%-17.1pp

78.8%-23.0pp

72.9%-17.1pp

Annual return

15.86%

40.39%-24.5pp

19.08%-3.2pp

40.39%-24.5pp

Employer contribution / active EE

$1,213

$2,977-59.3%

$4,285-71.7%

$2,977-59.3%

Participant deferral / active EE

$2,429

$5,015-51.6%

$5,394-55.0%

$5,015-51.6%

Admin fee / account holder

$222

$145+52.9%

$4,582-95.2%

$145+52.9%

Provider

Service type

Compensation

REDW STANLEY FINANCIAL ADVISORS LLC4 years

Filed as: REDW WEALTH FINANCIAL ADVISORS LLC

Service code 26 · EIN 85-0467977

Advisory (Participants)

$109,659

SENTINEL PENSION ADVISORS1 year

Filed as: SENTINEL BENEFITS GROUP, LLC

Service code 15 · EIN 20-5916766

Recordkeeping

$63,722

LOFTIS & LOVATO GROUP4 years

Service code 10 · EIN 84-3463346

Accounting

$19,373

ALLIANCE BENEFIT GROUP9+ years

Filed as: ALLIANCE BENEFIT GROUP SOUTHWEST LL

Service code 15 · EIN 38-3944313

Recordkeeping

$18,929

PUEBLO OF SANDIA COMMERCIAL ENTERPRISES 401(K) PROFIT SHARING PLAN AND TRUST

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

PUEBLO OF SANDIA COMMERCIAL ENTERPRISES 401(K) PROFIT SHARING PLAN AND TRUST

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

Benchmarks

Service providers

Opportunity flags

Expense breakdown

Audit opinion

Benchmarks

Service providers

Opportunity flags

Expense breakdown

Audit opinion