Civic Intelligence

ARUN GUPTA MD PC

Plan context: ARUN GUPTA, MD CASH BALANCE PLAN

EIN 38-3334007 • Monroe, MI • 27 filings • 5 plans

1094 N Monroe St.Monroe, MI 48162
Current Snapshot

Latest Year

2024

2024 Participants

6

2024 Assets

$207,258

2024 Contributions

$207,256

Historical Graphs

Total Assets Over Time

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

$207,258$103,629$0200120132024YearValue
$207,258Latest year 2024

Participants Over Time

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

740200120122024YearValue
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
202426$207,258$207,256$34,543iApproximate average salary by contribution assumption: employee only about $863,567 at 4% or $575,711 at 6%; with 50% employer match about $575,711 at 4% or $383,807 at 6%; with 100% employer match about $431,783 at 4% or $287,856 at 6%.
ARUN GUPTA, MD CASH BALANCE PLAN-5$207,258$207,256$41,451iApproximate average salary by contribution assumption: employee only about $1,036,280 at 4% or $690,853 at 6%; with 50% employer match about $690,853 at 4% or $460,569 at 6%; with 100% employer match about $518,140 at 4% or $345,427 at 6%.
ARUN GUPTA, MD 401(K) PLAN-6$0$0-
202211$49,737$29,100$29,100iApproximate average salary by contribution assumption: employee only about $727,500 at 4% or $485,000 at 6%; with 50% employer match about $485,000 at 4% or $323,333 at 6%; with 100% employer match about $363,750 at 4% or $242,500 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-1$49,737$29,100$29,100iApproximate average salary by contribution assumption: employee only about $727,500 at 4% or $485,000 at 6%; with 50% employer match about $485,000 at 4% or $323,333 at 6%; with 100% employer match about $363,750 at 4% or $242,500 at 6%.
202112$63,906$29,100$14,550iApproximate average salary by contribution assumption: employee only about $363,750 at 4% or $242,500 at 6%; with 50% employer match about $242,500 at 4% or $161,667 at 6%; with 100% employer match about $181,875 at 4% or $121,250 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-2$63,906$29,100$14,550iApproximate average salary by contribution assumption: employee only about $363,750 at 4% or $242,500 at 6%; with 50% employer match about $242,500 at 4% or $161,667 at 6%; with 100% employer match about $181,875 at 4% or $121,250 at 6%.
202017$54,017$17,961$2,566iApproximate average salary by contribution assumption: employee only about $64,146 at 4% or $42,764 at 6%; with 50% employer match about $42,764 at 4% or $28,510 at 6%; with 100% employer match about $32,073 at 4% or $21,382 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-7$54,017$17,961$2,566iApproximate average salary by contribution assumption: employee only about $64,146 at 4% or $42,764 at 6%; with 50% employer match about $42,764 at 4% or $28,510 at 6%; with 100% employer match about $32,073 at 4% or $21,382 at 6%.
201915$55,756$22,154$4,431iApproximate average salary by contribution assumption: employee only about $110,770 at 4% or $73,847 at 6%; with 50% employer match about $73,847 at 4% or $49,231 at 6%; with 100% employer match about $55,385 at 4% or $36,923 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-5$55,756$22,154$4,431iApproximate average salary by contribution assumption: employee only about $110,770 at 4% or $73,847 at 6%; with 50% employer match about $73,847 at 4% or $49,231 at 6%; with 100% employer match about $55,385 at 4% or $36,923 at 6%.
201815$31,602$22,747$4,549iApproximate average salary by contribution assumption: employee only about $113,735 at 4% or $75,823 at 6%; with 50% employer match about $75,823 at 4% or $50,549 at 6%; with 100% employer match about $56,867 at 4% or $37,912 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-5$31,602$22,747$4,549iApproximate average salary by contribution assumption: employee only about $113,735 at 4% or $75,823 at 6%; with 50% employer match about $75,823 at 4% or $50,549 at 6%; with 100% employer match about $56,867 at 4% or $37,912 at 6%.
201711$6,939$6,800$6,800iApproximate average salary by contribution assumption: employee only about $170,000 at 4% or $113,333 at 6%; with 50% employer match about $113,333 at 4% or $75,556 at 6%; with 100% employer match about $85,000 at 4% or $56,667 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-1$6,939$6,800$6,800iApproximate average salary by contribution assumption: employee only about $170,000 at 4% or $113,333 at 6%; with 50% employer match about $113,333 at 4% or $75,556 at 6%; with 100% employer match about $85,000 at 4% or $56,667 at 6%.
201613$15,911$0-
ARUN GUPTA MD PC RETIREMENT PLAN-3$15,911--
201513$13,621$0-
ARUN GUPTA MD PC RETIREMENT PLAN-3$13,621--
201413$34,008$0-
ARUN GUPTA MD PC RETIREMENT PLAN-3$34,008$0-
201315$36,737$26,712$5,342iApproximate average salary by contribution assumption: employee only about $133,560 at 4% or $89,040 at 6%; with 50% employer match about $89,040 at 4% or $59,360 at 6%; with 100% employer match about $66,780 at 4% or $44,520 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-5$36,737$26,712$5,342iApproximate average salary by contribution assumption: employee only about $133,560 at 4% or $89,040 at 6%; with 50% employer match about $89,040 at 4% or $59,360 at 6%; with 100% employer match about $66,780 at 4% or $44,520 at 6%.
201216$43,881$0-
ARUN GUPTA MD PC RETIREMENT PLAN-6$43,881$0-
201116$107,958$17,855$2,976iApproximate average salary by contribution assumption: employee only about $74,396 at 4% or $49,597 at 6%; with 50% employer match about $49,597 at 4% or $33,065 at 6%; with 100% employer match about $37,198 at 4% or $24,799 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-6$107,958$17,855$2,976iApproximate average salary by contribution assumption: employee only about $74,396 at 4% or $49,597 at 6%; with 50% employer match about $49,597 at 4% or $33,065 at 6%; with 100% employer match about $37,198 at 4% or $24,799 at 6%.
201016$31,711$15,778$2,630iApproximate average salary by contribution assumption: employee only about $65,742 at 4% or $43,828 at 6%; with 50% employer match about $43,828 at 4% or $29,219 at 6%; with 100% employer match about $32,871 at 4% or $21,914 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-6$31,711$15,778$2,630iApproximate average salary by contribution assumption: employee only about $65,742 at 4% or $43,828 at 6%; with 50% employer match about $43,828 at 4% or $29,219 at 6%; with 100% employer match about $32,871 at 4% or $21,914 at 6%.
200916$15,757$12,438$2,073iApproximate average salary by contribution assumption: employee only about $51,825 at 4% or $34,550 at 6%; with 50% employer match about $34,550 at 4% or $23,033 at 6%; with 100% employer match about $25,913 at 4% or $17,275 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-6$15,757$12,438$2,073iApproximate average salary by contribution assumption: employee only about $51,825 at 4% or $34,550 at 6%; with 50% employer match about $34,550 at 4% or $23,033 at 6%; with 100% employer match about $25,913 at 4% or $17,275 at 6%.
200811$2,494$0-
ARUN GUPTA MD PC RETIREMENT PLAN-1$2,494--
200712$0$0-
ARUN GUPTA MD PC RETIREMENT PLAN-2---
200614$104,002$0-
ARUN GUPTA MD PC RETIREMENT PLAN-4$104,002--
200513$95,254$0-
ARUN GUPTA MD PC RETIREMENT PLAN-3$95,254--
200417$98,794$36,541$5,220iApproximate average salary by contribution assumption: employee only about $130,504 at 4% or $87,002 at 6%; with 50% employer match about $87,002 at 4% or $58,002 at 6%; with 100% employer match about $65,252 at 4% or $43,501 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-7$98,794$36,541$5,220iApproximate average salary by contribution assumption: employee only about $130,504 at 4% or $87,002 at 6%; with 50% employer match about $87,002 at 4% or $58,002 at 6%; with 100% employer match about $65,252 at 4% or $43,501 at 6%.
200317$64,733$45,489$6,498iApproximate average salary by contribution assumption: employee only about $162,461 at 4% or $108,307 at 6%; with 50% employer match about $108,307 at 4% or $72,205 at 6%; with 100% employer match about $81,230 at 4% or $54,154 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-7$64,733$45,489$6,498iApproximate average salary by contribution assumption: employee only about $162,461 at 4% or $108,307 at 6%; with 50% employer match about $108,307 at 4% or $72,205 at 6%; with 100% employer match about $81,230 at 4% or $54,154 at 6%.
200233$18,986$18,986$6,329iApproximate average salary by contribution assumption: employee only about $158,217 at 4% or $105,478 at 6%; with 50% employer match about $105,478 at 4% or $70,319 at 6%; with 100% employer match about $79,108 at 4% or $52,739 at 6%.
ARUN GUPTA MD PC RETIREMENT PLAN-3$18,986$18,986$6,329iApproximate average salary by contribution assumption: employee only about $158,217 at 4% or $105,478 at 6%; with 50% employer match about $105,478 at 4% or $70,319 at 6%; with 100% employer match about $79,108 at 4% or $52,739 at 6%.
ARUN GUPTA MD PC MONEY PURCHASE PENSION PLAN-0---
ARUN GUPTA MD PC PROFIT SHARING PLAN-0---
200124$46,099$46,099$11,525iApproximate average salary by contribution assumption: employee only about $288,119 at 4% or $192,079 at 6%; with 50% employer match about $192,079 at 4% or $128,053 at 6%; with 100% employer match about $144,059 at 4% or $96,040 at 6%.
ARUN GUPTA MD PC PROFIT SHARING PLAN-4$25,025$25,025$6,256iApproximate average salary by contribution assumption: employee only about $156,406 at 4% or $104,271 at 6%; with 50% employer match about $104,271 at 4% or $69,514 at 6%; with 100% employer match about $78,203 at 4% or $52,135 at 6%.
ARUN GUPTA MD PC MONEY PURCHASE PENSION PLAN-4$21,074$21,074$5,269iApproximate average salary by contribution assumption: employee only about $131,713 at 4% or $87,808 at 6%; with 50% employer match about $87,808 at 4% or $58,539 at 6%; with 100% employer match about $65,856 at 4% or $43,904 at 6%.