Civic Intelligence

Master Sheet Metal Inc.

Plan context: MASTER SHEET METAL, INC. 401(K) PROFIT SHARING PLAN

EIN 99-0144725 • Honolulu, HI • 47 filings • 4 plans

1648 Auiki StreetHonolulu, HI 96819-3901
Current Snapshot

Latest Year

2024

2024 Participants

10

2024 Assets

$5,969,201

2024 Contributions

$275,586

Historical Graphs

Total Assets Over Time

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

$5,969,201$2,984,601$0200320162024YearValue
$5,969,201Latest year 2024

Participants Over Time

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

1470200020122024YearValue
10Latest 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
2024210$5,969,201$275,586$27,559iApproximate average salary by contribution assumption: employee only about $688,965 at 4% or $459,310 at 6%; with 50% employer match about $459,310 at 4% or $306,207 at 6%; with 100% employer match about $344,483 at 4% or $229,655 at 6%.
MASTER SHEET METAL, INC. 401(K) PROFIT SHARING PLAN-10$5,549,413$275,586$27,559iApproximate average salary by contribution assumption: employee only about $688,965 at 4% or $459,310 at 6%; with 50% employer match about $459,310 at 4% or $306,207 at 6%; with 100% employer match about $344,483 at 4% or $229,655 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-3$419,788--
2023210$5,098,357$208,613$20,861iApproximate average salary by contribution assumption: employee only about $521,533 at 4% or $347,688 at 6%; with 50% employer match about $347,688 at 4% or $231,792 at 6%; with 100% employer match about $260,766 at 4% or $173,844 at 6%.
MASTER SHEET METAL, INC. 401(K) PROFIT SHARING PLAN-10$4,678,569$208,613$20,861iApproximate average salary by contribution assumption: employee only about $521,533 at 4% or $347,688 at 6%; with 50% employer match about $347,688 at 4% or $231,792 at 6%; with 100% employer match about $260,766 at 4% or $173,844 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-3$419,788--
202229$3,973,897$378,784$42,087iApproximate average salary by contribution assumption: employee only about $1,052,178 at 4% or $701,452 at 6%; with 50% employer match about $701,452 at 4% or $467,635 at 6%; with 100% employer match about $526,089 at 4% or $350,726 at 6%.
MASTER SHEET METAL, INC. 401(K) PROFIT SHARING PLAN-9$3,717,951$378,784$42,087iApproximate average salary by contribution assumption: employee only about $1,052,178 at 4% or $701,452 at 6%; with 50% employer match about $701,452 at 4% or $467,635 at 6%; with 100% employer match about $526,089 at 4% or $350,726 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-3$255,946--
202128$3,717,530$100,847$12,606iApproximate average salary by contribution assumption: employee only about $315,147 at 4% or $210,098 at 6%; with 50% employer match about $210,098 at 4% or $140,065 at 6%; with 100% employer match about $157,573 at 4% or $105,049 at 6%.
MASTER SHEET METAL, INC. 401(K) PROFIT SHARING PLAN-8$3,373,585$100,847$12,606iApproximate average salary by contribution assumption: employee only about $315,147 at 4% or $210,098 at 6%; with 50% employer match about $210,098 at 4% or $140,065 at 6%; with 100% employer match about $157,573 at 4% or $105,049 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-4$343,945--
202028$4,108,188$185,242$23,155iApproximate average salary by contribution assumption: employee only about $578,881 at 4% or $385,921 at 6%; with 50% employer match about $385,921 at 4% or $257,281 at 6%; with 100% employer match about $289,441 at 4% or $192,960 at 6%.
MASTER SHEET METAL, INC. 401(K) PROFIT SHARING PLAN-8$3,773,253$185,242$23,155iApproximate average salary by contribution assumption: employee only about $578,881 at 4% or $385,921 at 6%; with 50% employer match about $385,921 at 4% or $257,281 at 6%; with 100% employer match about $289,441 at 4% or $192,960 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-4$334,935--
201928$3,400,336$331,327$41,416iApproximate average salary by contribution assumption: employee only about $1,035,397 at 4% or $690,265 at 6%; with 50% employer match about $690,265 at 4% or $460,176 at 6%; with 100% employer match about $517,698 at 4% or $345,132 at 6%.
MASTER SHEET METAL, INC. 401(K) PROFIT SHARING PLAN-8$3,023,578$331,327$41,416iApproximate average salary by contribution assumption: employee only about $1,035,397 at 4% or $690,265 at 6%; with 50% employer match about $690,265 at 4% or $460,176 at 6%; with 100% employer match about $517,698 at 4% or $345,132 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-4$376,758--
201828$3,020,443$165,135$20,642iApproximate average salary by contribution assumption: employee only about $516,047 at 4% or $344,031 at 6%; with 50% employer match about $344,031 at 4% or $229,354 at 6%; with 100% employer match about $258,023 at 4% or $172,016 at 6%.
MASTER SHEET METAL, INC. 401(K) PROFIT SHARING PLAN-8$2,601,130$165,135$20,642iApproximate average salary by contribution assumption: employee only about $516,047 at 4% or $344,031 at 6%; with 50% employer match about $344,031 at 4% or $229,354 at 6%; with 100% employer match about $258,023 at 4% or $172,016 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-5$419,313--
201728$2,746,858$202,860$25,358iApproximate average salary by contribution assumption: employee only about $633,938 at 4% or $422,625 at 6%; with 50% employer match about $422,625 at 4% or $281,750 at 6%; with 100% employer match about $316,969 at 4% or $211,313 at 6%.
MASTER SHEET METAL, INC. 401(K) PROFIT SHARING PLAN-8$2,249,239$141,104$17,638iApproximate average salary by contribution assumption: employee only about $440,950 at 4% or $293,967 at 6%; with 50% employer match about $293,967 at 4% or $195,978 at 6%; with 100% employer match about $220,475 at 4% or $146,983 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-5$497,619$61,756$12,351iApproximate average salary by contribution assumption: employee only about $308,780 at 4% or $205,853 at 6%; with 50% employer match about $205,853 at 4% or $137,236 at 6%; with 100% employer match about $154,390 at 4% or $102,927 at 6%.
201628$2,635,181$248,078$31,010iApproximate average salary by contribution assumption: employee only about $775,244 at 4% or $516,829 at 6%; with 50% employer match about $516,829 at 4% or $344,553 at 6%; with 100% employer match about $387,622 at 4% or $258,415 at 6%.
MASTER SHEET METAL, INC. 401(K) PROFIT SHARING PLAN-8$2,097,916$186,322$23,290iApproximate average salary by contribution assumption: employee only about $582,256 at 4% or $388,171 at 6%; with 50% employer match about $388,171 at 4% or $258,781 at 6%; with 100% employer match about $291,128 at 4% or $194,085 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-6$537,265$61,756$10,293iApproximate average salary by contribution assumption: employee only about $257,317 at 4% or $171,544 at 6%; with 50% employer match about $171,544 at 4% or $114,363 at 6%; with 100% employer match about $128,658 at 4% or $85,772 at 6%.
201529$2,815,997$152,096$16,900iApproximate average salary by contribution assumption: employee only about $422,489 at 4% or $281,659 at 6%; with 50% employer match about $281,659 at 4% or $187,773 at 6%; with 100% employer match about $211,244 at 4% or $140,830 at 6%.
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-9$2,381,112$114,252$12,695iApproximate average salary by contribution assumption: employee only about $317,367 at 4% or $211,578 at 6%; with 50% employer match about $211,578 at 4% or $141,052 at 6%; with 100% employer match about $158,683 at 4% or $105,789 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-6$434,885$37,844$6,307iApproximate average salary by contribution assumption: employee only about $157,683 at 4% or $105,122 at 6%; with 50% employer match about $105,122 at 4% or $70,081 at 6%; with 100% employer match about $78,842 at 4% or $52,561 at 6%.
2014210$2,711,456$154,470$15,447iApproximate average salary by contribution assumption: employee only about $386,175 at 4% or $257,450 at 6%; with 50% employer match about $257,450 at 4% or $171,633 at 6%; with 100% employer match about $193,088 at 4% or $128,725 at 6%.
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-10$2,236,054$92,714$9,271iApproximate average salary by contribution assumption: employee only about $231,785 at 4% or $154,523 at 6%; with 50% employer match about $154,523 at 4% or $103,016 at 6%; with 100% employer match about $115,893 at 4% or $77,262 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-7$475,402$61,756$8,822iApproximate average salary by contribution assumption: employee only about $220,557 at 4% or $147,038 at 6%; with 50% employer match about $147,038 at 4% or $98,025 at 6%; with 100% employer match about $110,279 at 4% or $73,519 at 6%.
201329$2,609,025$68,069$7,563iApproximate average salary by contribution assumption: employee only about $189,081 at 4% or $126,054 at 6%; with 50% employer match about $126,054 at 4% or $84,036 at 6%; with 100% employer match about $94,540 at 4% or $63,027 at 6%.
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-9$2,133,623$6,313$701iApproximate average salary by contribution assumption: employee only about $17,536 at 4% or $11,691 at 6%; with 50% employer match about $11,691 at 4% or $7,794 at 6%; with 100% employer match about $8,768 at 4% or $5,845 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-6$475,402$61,756$10,293iApproximate average salary by contribution assumption: employee only about $257,317 at 4% or $171,544 at 6%; with 50% employer match about $171,544 at 4% or $114,363 at 6%; with 100% employer match about $128,658 at 4% or $85,772 at 6%.
2012210$2,460,507$105,682$10,568iApproximate average salary by contribution assumption: employee only about $264,205 at 4% or $176,137 at 6%; with 50% employer match about $176,137 at 4% or $117,424 at 6%; with 100% employer match about $132,103 at 4% or $88,068 at 6%.
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-10$2,040,519$43,926$4,393iApproximate average salary by contribution assumption: employee only about $109,815 at 4% or $73,210 at 6%; with 50% employer match about $73,210 at 4% or $48,807 at 6%; with 100% employer match about $54,908 at 4% or $36,605 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-8$419,988$61,756$7,720iApproximate average salary by contribution assumption: employee only about $192,988 at 4% or $128,658 at 6%; with 50% employer match about $128,658 at 4% or $85,772 at 6%; with 100% employer match about $96,494 at 4% or $64,329 at 6%.
2011210$2,246,636$61,756$6,176iApproximate average salary by contribution assumption: employee only about $154,390 at 4% or $102,927 at 6%; with 50% employer match about $102,927 at 4% or $68,618 at 6%; with 100% employer match about $77,195 at 4% or $51,463 at 6%.
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-9$1,811,768--
Master Sheet Metal Inc. Employee Stock Ownership Plan-10$434,868$61,756$6,176iApproximate average salary by contribution assumption: employee only about $154,390 at 4% or $102,927 at 6%; with 50% employer match about $102,927 at 4% or $68,618 at 6%; with 100% employer match about $77,195 at 4% or $51,463 at 6%.
2010211$2,258,569$61,756$5,614iApproximate average salary by contribution assumption: employee only about $140,355 at 4% or $93,570 at 6%; with 50% employer match about $93,570 at 4% or $62,380 at 6%; with 100% employer match about $70,177 at 4% or $46,785 at 6%.
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-11$1,763,437--
Master Sheet Metal Inc. Employee Stock Ownership Plan-9$495,132$61,756$6,862iApproximate average salary by contribution assumption: employee only about $171,544 at 4% or $114,363 at 6%; with 50% employer match about $114,363 at 4% or $76,242 at 6%; with 100% employer match about $85,772 at 4% or $57,181 at 6%.
2009314$3,991,004$149,588$10,685iApproximate average salary by contribution assumption: employee only about $267,121 at 4% or $178,081 at 6%; with 50% employer match about $178,081 at 4% or $118,721 at 6%; with 100% employer match about $133,561 at 4% or $89,040 at 6%.
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-14$2,536,004$26,076$1,863iApproximate average salary by contribution assumption: employee only about $46,564 at 4% or $31,043 at 6%; with 50% employer match about $31,043 at 4% or $20,695 at 6%; with 100% employer match about $23,282 at 4% or $15,521 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-9$900,000$61,756$6,862iApproximate average salary by contribution assumption: employee only about $171,544 at 4% or $114,363 at 6%; with 50% employer match about $114,363 at 4% or $76,242 at 6%; with 100% employer match about $85,772 at 4% or $57,181 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-12$555,000$61,756$5,146iApproximate average salary by contribution assumption: employee only about $128,658 at 4% or $85,772 at 6%; with 50% employer match about $85,772 at 4% or $57,181 at 6%; with 100% employer match about $64,329 at 4% or $42,886 at 6%.
200819$0$0-
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-9---
200729$0$0-
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-9---
Master Sheet Metal Inc. Employee Stock Ownership Plan-8---
2006210$0$0-
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-10---
Master Sheet Metal Inc. Employee Stock Ownership Plan-10---
200529$2,325,800$33,506$3,723iApproximate average salary by contribution assumption: employee only about $93,072 at 4% or $62,048 at 6%; with 50% employer match about $62,048 at 4% or $41,365 at 6%; with 100% employer match about $46,536 at 4% or $31,024 at 6%.
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-9$2,325,800$33,506$3,723iApproximate average salary by contribution assumption: employee only about $93,072 at 4% or $62,048 at 6%; with 50% employer match about $62,048 at 4% or $41,365 at 6%; with 100% employer match about $46,536 at 4% or $31,024 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-9---
2004210$0$0-
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-10---
Master Sheet Metal Inc. Employee Stock Ownership Plan-10---
2003210$2,226,930$218,772$21,877iApproximate average salary by contribution assumption: employee only about $546,930 at 4% or $364,620 at 6%; with 50% employer match about $364,620 at 4% or $243,080 at 6%; with 100% employer match about $273,465 at 4% or $182,310 at 6%.
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-10$2,226,930$218,772$21,877iApproximate average salary by contribution assumption: employee only about $546,930 at 4% or $364,620 at 6%; with 50% employer match about $364,620 at 4% or $243,080 at 6%; with 100% employer match about $273,465 at 4% or $182,310 at 6%.
Master Sheet Metal Inc. Employee Stock Ownership Plan-10---
200219$0$0-
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-9---
200118$0$0-
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-8---
200017$0$0-
MASTER SHEET METAL, INC. PROFIT SHARING PLAN-7---