Civic Intelligence
Filing

Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.

Phelps Program Management, L.L.C. • EIN 84-1304708 • Plan year 2007

Filing Insights

Participants

Down

44 → 7

-37 • -84.09%

Assets

No comparison

- → -

No earlier value available.

Investment Management Fee

-

Admin expenses - • Total expenses -

Filing Details

Context
Pension payor EIN
42-0127290

Status Flags

Fidelity bond in place

Not reported

Limited-scope audit performed

Not reported

Contributions transmitted on time

Not reported

Participant loans in default

Not reported

Leases in default

Not reported

Reportable party-in-interest issues

Not reported

Loss discovered during year

Not reported

Assets with undetermined value

Not reported

Non-cash contributions

Not reported

Assets held for investment

Not reported

5% transactions reported

Not reported

All plan assets distributed

Not reported

Benefits paid when due

Not reported

Plan blackout period

Not reported

Plan termination resolution adopted

Not reported

Counterparties

Company Timeline

This filing is highlighted inside the broader sponsor history.

Year / FilingFilingsParticipantsAssetsContributionsContrib./Participant
201520$0$0-
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-0$0$0-
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-0$0$0-
2014214$524,679$0-
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-14$271,709$0-
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-8$252,970$0-
2013214$520,074$0-
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-14$269,638$0-
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-8$250,436$0-
2012214$442,419$0-
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-14$227,160$0-
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-8$215,259$0-
2011216$543,204$0-
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-10$284,566$0-
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-16$258,638$0-
2010219$702,832$0-
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-19$354,303$0-
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-13$348,529$0-
2009219$644,088$0-
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-19$324,447$0-
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-13$319,641$0-
200827$541,479$0-
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-5$272,176--
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-7$269,303--
200728$0$0-
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.Current7---
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-8---
2006357$1,808,220$34,481$605iApproximate average salary by contribution assumption: employee only about $15,123 at 4% or $10,082 at 6%; with 50% employer match about $10,082 at 4% or $6,721 at 6%; with 100% employer match about $7,562 at 4% or $5,041 at 6%.
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-14$929,334$23,916$1,708iApproximate average salary by contribution assumption: employee only about $42,707 at 4% or $28,471 at 6%; with 50% employer match about $28,471 at 4% or $18,981 at 6%; with 100% employer match about $21,354 at 4% or $14,236 at 6%.
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-57$878,886$10,565$185iApproximate average salary by contribution assumption: employee only about $4,634 at 4% or $3,089 at 6%; with 50% employer match about $3,089 at 4% or $2,059 at 6%; with 100% employer match about $2,317 at 4% or $1,545 at 6%.
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-57---
20052122$4,233,455$606,378$4,970iApproximate average salary by contribution assumption: employee only about $124,258 at 4% or $82,839 at 6%; with 50% employer match about $82,839 at 4% or $55,226 at 6%; with 100% employer match about $62,129 at 4% or $41,419 at 6%.
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-122$2,166,782$290,659$2,382iApproximate average salary by contribution assumption: employee only about $59,561 at 4% or $39,708 at 6%; with 50% employer match about $39,708 at 4% or $26,472 at 6%; with 100% employer match about $29,781 at 4% or $19,854 at 6%.
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-70$2,066,673$315,719$4,510iApproximate average salary by contribution assumption: employee only about $112,757 at 4% or $75,171 at 6%; with 50% employer match about $75,171 at 4% or $50,114 at 6%; with 100% employer match about $56,378 at 4% or $37,586 at 6%.
20042140$3,729,349$657,909$4,699iApproximate average salary by contribution assumption: employee only about $117,484 at 4% or $78,323 at 6%; with 50% employer match about $78,323 at 4% or $52,215 at 6%; with 100% employer match about $58,742 at 4% or $39,161 at 6%.
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-140$1,924,456$337,981$2,414iApproximate average salary by contribution assumption: employee only about $60,354 at 4% or $40,236 at 6%; with 50% employer match about $40,236 at 4% or $26,824 at 6%; with 100% employer match about $30,177 at 4% or $20,118 at 6%.
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-98$1,804,893$319,928$3,265iApproximate average salary by contribution assumption: employee only about $81,614 at 4% or $54,410 at 6%; with 50% employer match about $54,410 at 4% or $36,273 at 6%; with 100% employer match about $40,807 at 4% or $27,205 at 6%.
20032153$3,239,133$729,514$4,768iApproximate average salary by contribution assumption: employee only about $119,202 at 4% or $79,468 at 6%; with 50% employer match about $79,468 at 4% or $52,979 at 6%; with 100% employer match about $59,601 at 4% or $39,734 at 6%.
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-153$1,642,990$393,984$2,575iApproximate average salary by contribution assumption: employee only about $64,376 at 4% or $42,918 at 6%; with 50% employer match about $42,918 at 4% or $28,612 at 6%; with 100% employer match about $32,188 at 4% or $21,459 at 6%.
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-130$1,596,143$335,530$2,581iApproximate average salary by contribution assumption: employee only about $64,525 at 4% or $43,017 at 6%; with 50% employer match about $43,017 at 4% or $28,678 at 6%; with 100% employer match about $32,263 at 4% or $21,508 at 6%.
20022108$1,198,351$299,135$2,770iApproximate average salary by contribution assumption: employee only about $69,244 at 4% or $46,163 at 6%; with 50% employer match about $46,163 at 4% or $30,775 at 6%; with 100% employer match about $34,622 at 4% or $23,081 at 6%.
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-73$1,198,351$299,135$4,098iApproximate average salary by contribution assumption: employee only about $102,443 at 4% or $68,296 at 6%; with 50% employer match about $68,296 at 4% or $45,530 at 6%; with 100% employer match about $51,222 at 4% or $34,148 at 6%.
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-108---
2001293$973,262$67,520$726iApproximate average salary by contribution assumption: employee only about $18,151 at 4% or $12,100 at 6%; with 50% employer match about $12,100 at 4% or $8,067 at 6%; with 100% employer match about $9,075 at 4% or $6,050 at 6%.
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-93$973,262$67,520$726iApproximate average salary by contribution assumption: employee only about $18,151 at 4% or $12,100 at 6%; with 50% employer match about $12,100 at 4% or $8,067 at 6%; with 100% employer match about $9,075 at 4% or $6,050 at 6%.
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-64---
20002101$0$0-
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-57---
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-101---
1999293$2,080,569$464,378$4,993iApproximate average salary by contribution assumption: employee only about $124,833 at 4% or $83,222 at 6%; with 50% employer match about $83,222 at 4% or $55,481 at 6%; with 100% employer match about $62,416 at 4% or $41,611 at 6%.
Csa Master 401K Proft Sharing Plan & Trust as Adopted by Phelps Program Management LLC-93$1,139,595$265,440$2,854iApproximate average salary by contribution assumption: employee only about $71,355 at 4% or $47,570 at 6%; with 50% employer match about $47,570 at 4% or $31,713 at 6%; with 100% employer match about $35,677 at 4% or $23,785 at 6%.
Csa Master Money Purchase Pension Plan & Trust as Adopted by Phelps Program Management, L.L.C.-85$940,974$198,938$2,340iApproximate average salary by contribution assumption: employee only about $58,511 at 4% or $39,007 at 6%; with 50% employer match about $39,007 at 4% or $26,005 at 6%; with 100% employer match about $29,256 at 4% or $19,504 at 6%.
Schedule Details

Schedule A

Row 1
Filing Id
84037255197068
Form Id
90219866
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7010378255197060002
Ins Broker 01 Name
THE BOON INSURANCE AGENCY INC
Ins Broker 01 Street Addr
6300 BRIDGEPOINT PKWY
Ins Broker 01 City
AUSTIN
Ins Broker 01 State
TX
Ins Broker 01 ZIP Code
787300000
Ins Broker Comm Pd 01 Amount
$11,823
Ins Broker Fees Pd 01 Amount
$0
Ins Broker 01 Code
3
Row 2
Filing Id
84037255197068
Form Id
90219867
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7010378255197060003
Ins Broker Comm Pd 01 Amount
$0
Ins Broker Fees Pd 01 Amount
$0
Row 3
Ins Carrier Name: PRINCIPAL LIFE INSURANCE COMPANY
Filing Id
84037255197068
Form Id
90219866
Schedule A EIN
84-1304708
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2007-01-01
Schedule A Tax Period
20071231
Ins Carrier Name
PRINCIPAL LIFE INSURANCE COMPANY
Ins Carrier EIN
42-0127290
Ins Carrier Naic Code
61271
Ins Contract Num
5-18114
Ins Prsn Covered End of year Count
28
Ins Policy From Date
2007-01-01
Ins Policy To Date
2007-12-31
Ins Broker Comm Total Amount
$11,823
Ins Broker Fees Total Amount
$0
Pension End of year Gen Account Amount
$0
Pension End of year Sep Account Amount
$219,754
Pension Prem Paid Total Amount
$0
Pension Unpaid Premium Amount
$0
Pension Contract Cost Amount
$0
Pension End Prev Bal Amount
$0
Pension Contribution Dep Amount
$0
Pension Divnd Cr Dep Amount
$0
Pension Interest Cr Dur Yr Amount
$0
Pension Transfer From Amount
$0
Pension Other Amount
$0
Pension Total Additions Amount
$0
Pension Total Bal Addn Amount
$0
Pension Bnfts Dsbrsd Amount
$0
Pension Admin Chrg Amount
$0
Pension Transfer To Amount
$0
Pension Oth Ded Amount
$0
Pension Total Ded Amount
$0
Pension End of year Bal Amount
$0
Wlfr Premium Rcvd Amount
$0
Wlfr Unpaid Due Amount
$0
Wlfr Reserve Amount
$0
Wlfr Total Earned Prem Amount
$0
Wlfr Claims Paid Amount
$0
Wlfr Incr Reserve Amount
$0
Wlfr Incurred Claim Amount
$0
Wlfr Claims Chrgd Amount
$0
Wlfr Ret Commissions Amount
$0
Wlfr Ret Admin Amount
$0
Wlfr Ret Oth Cost Amount
$0
Wlfr Ret Oth Expense Amount
$0
Wlfr Ret Taxes Amount
$0
Wlfr Ret Charges Amount
$0
Wlfr Ret Oth Chrgs Amount
$0
Wlfr Ret Total Amount
$0
Wlfr Refund Amount
$0
Wlfr Held Bnfts Amount
$0
Wlfr Claims Reserve Amount
$0
Wlfr Oth Reserve Amount
$0
Wlfr Divnds Due Amount
$0
Wlfr Total Charges Paid Amount
$0
Wlfr Acquis Cost Amount
$0
Row 4
Ins Carrier Name: PRINCIPAL LIFE INSURANCE COMPANY
Filing Id
84037255197068
Form Id
90219867
Schedule A EIN
84-1304708
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2007-01-01
Schedule A Tax Period
20071231
Ins Carrier Name
PRINCIPAL LIFE INSURANCE COMPANY
Ins Carrier EIN
42-0127290
Ins Carrier Naic Code
61271
Ins Contract Num
4-41462
Ins Prsn Covered End of year Count
28
Ins Policy From Date
2007-01-01
Ins Policy To Date
2007-12-31
Ins Broker Comm Total Amount
$0
Ins Broker Fees Total Amount
$0
Pension End of year Gen Account Amount
$0
Pension End of year Sep Account Amount
$0
Pension Prem Paid Total Amount
$0
Pension Unpaid Premium Amount
$0
Pension Contract Cost Amount
$0
Pnsn Type Unalloc Cntrct I
4
Pension Oth Unalloc Type Text
CUSTODIAL GUA FUND GR ANN CONTRACT
Pension End Prev Bal Amount
$349,710
Pension Contribution Dep Amount
$0
Pension Divnd Cr Dep Amount
$0
Pension Interest Cr Dur Yr Amount
$8,292
Pension Transfer From Amount
$0
Pension Other Amount
$18,406
Pension Other Text
MKT VL CHANG
Pension Total Additions Amount
$26,698
Pension Total Bal Addn Amount
$376,408
Pension Bnfts Dsbrsd Amount
$169,629
Pension Admin Chrg Amount
$5,387
Pension Transfer To Amount
$0
Pension Oth Ded Amount
$0
Pension Total Ded Amount
$175,016
Pension End of year Bal Amount
$201,392
Wlfr Premium Rcvd Amount
$0
Wlfr Unpaid Due Amount
$0
Wlfr Reserve Amount
$0
Wlfr Total Earned Prem Amount
$0
Wlfr Claims Paid Amount
$0
Wlfr Incr Reserve Amount
$0
Wlfr Incurred Claim Amount
$0
Wlfr Claims Chrgd Amount
$0
Wlfr Ret Commissions Amount
$0
Wlfr Ret Admin Amount
$0
Wlfr Ret Oth Cost Amount
$0
Wlfr Ret Oth Expense Amount
$0
Wlfr Ret Taxes Amount
$0
Wlfr Ret Charges Amount
$0
Wlfr Ret Oth Chrgs Amount
$0
Wlfr Ret Total Amount
$0
Wlfr Refund Amount
$0
Wlfr Held Bnfts Amount
$0
Wlfr Claims Reserve Amount
$0
Wlfr Oth Reserve Amount
$0
Wlfr Divnds Due Amount
$0
Wlfr Total Charges Paid Amount
$0
Wlfr Acquis Cost Amount
$0

Schedule D

Row 1
Filing Id
84037255197068
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRINCIPAL MONEY MKT SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290024
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$0
Row 2
Filing Id
84037255197068
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7010378255197060004
Row 3
Filing Id
84037255197068
Page Id
1
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRINCIPAL SM CO VALUE SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290031
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$1,570
Row 4
Filing Id
84037255197068
Page Id
2
Page Seq
1
Page Row Num
1
Row Num
10
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRINCIPAL LIFETM 2040 SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290078
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$6,430
Row 5
Filing Id
84037255197068
Page Id
2
Page Seq
1
Page Row Num
2
Row Num
11
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRINCIPAL LIFETM 2050 SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290079
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$0
Row 6
Filing Id
84037255197068
Page Id
1
Page Seq
0
Page Row Num
3
Row Num
2
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRINCIPAL U.S. PROPERTY SEPACT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290027
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$1,585
Row 7
Filing Id
84037255197068
Page Id
1
Page Seq
0
Page Row Num
4
Row Num
3
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRINCIPAL BOND AND MTG SEP ACC
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290005
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$330
Row 8
Filing Id
84037255197068
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
4
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRIN LG CP STK IDX SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290016
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$78,051
Row 9
Filing Id
84037255197068
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
5
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRIN PTR MD-CP GROWTH SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290026
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$298
Row 10
Filing Id
84037255197068
Page Id
2
Page Seq
0
Page Row Num
3
Row Num
6
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRIN PTR LG-CAP GR I SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290066
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$35,449
Row 11
Filing Id
84037255197068
Page Id
2
Page Seq
0
Page Row Num
4
Row Num
7
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRIN PTR LG-CAP VALUE SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290068
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$52,177
Row 12
Filing Id
84037255197068
Page Id
2
Page Seq
0
Page Row Num
5
Row Num
8
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRIN PTR SM-CP GR II SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290071
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$6,936
Row 13
Filing Id
84037255197068
Page Id
2
Page Seq
0
Page Row Num
6
Row Num
9
Image Form Id
7010378255197060004
DFE P1 Entity 01 Name
PRINCIPAL LIFETM 2030 SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290077
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$36,928
Row 14
Filing Id
84037255197068
Schedule D EIN
84-1304708
Schedule D Plan number
001
Schedule D Plan Year Begin Date
2007-01-01
Schedule D Tax Period
20071231

Schedule R

Schedule R Pension Information

Retirement plan characteristics

Testing, payor, opinion-letter, and transfer information reported with the filing.

Pension & Payor

Payor EIN42-0127290

Transfers

Distributed property value$0
Schedule R source fields
Payor 42-0127290
Filing Id
84037255197068
Schedule R EIN
84-1304708
Schedule R Plan number
001
Schedule R Plan Year Begin Date
2007-01-01
Schedule R Tax Period
20071231
Pension Value Dstrb Pd Property Amount
$0
Pension payor EIN
42-0127290
Pension Bnft Distribution Sngl Sum Count
18
Pension Elec Satisfy Code 412 Indicator
No
Pension Employer Contribution Rqr Amount
$0
Pension Employer Contribution Paid Amount
$0
Pension Funding Deficiency Amount
$0