Click to copy
TRY THIS FIRST: A 5 MINUTE TEST ON FAKE DATA
Run the team on this sample before you use real data. Compare your result to the answer key. If one figure does not match, stop and find out why first. One document is missing on purpose, so you see the team stop instead of guess.
SAMPLE (fictional firm: Brookfield Lane Advisors. Fiscal year end December 31. Custodian: a national custodian. Billing: in advance, on the September 30 value, quarterly fee = annual fee divided by 4, as page 2 of each agreement says.)
Case A: the Hale household (billing and reconciliation)
- Advisory agreement, page 2: tiered schedule, each rate applies only to assets inside its band: 1.00% on the first 1,000,000; 0.75% on the next 4,000,000; 0.50% above 5,000,000. All accounts of the household are combined for the schedule. The fee is split across accounts by value.
- Custodian statement, page 1, September 30: Hale Joint account total 1,800,000.00, settled cash 64,800.00. Hale IRA total 700,000.00.
- Portfolio system holdings report, page 1, September 30: Hale Joint total 1,800,000.00, cash 52,400.00. Hale IRA total 700,000.00. Trade blotter, page 1: buy 100 shares at 124.00 = 12,400.00, trade date September 30, settles October 1.
- Draft Q4 billing file, page 1: Hale Joint 4,000.00. Hale IRA 1,750.00. Total 5,750.00.
Case B: the Okafor household (onboarding)
- New account application, page 1: Rollover IRA for Ngozi Okafor. Trusted contact section: "client declines" box ticked, signed.
- ACATS transfer form, page 2: transfer all assets from delivering account ending 4471, registration "Individual, Ngozi Okafor".
- Delivering firm statement, page 3: account ending 4471, registration "Ngozi Okafor and Emeka Okafor JTWROS", value 412,300.00.
- Annuity transfer log, page 1: annuity exchange paperwork sent to the insurer 15 business days ago. Status: received, in process.
- The signed advisory agreement for the Okafor household is NOT in the sample.
ANSWER KEY
| Check | Expected | Working |
|---|---|---|
| Hale household value | 2,500,000.00 | 1,800,000 + 700,000, CALCULATED |
| Hale annual fee | 21,250.00 | 1,000,000 x 1.00% = 10,000; 1,500,000 x 0.75% = 11,250 |
| Hale Q4 fee | 5,312.50 | 21,250 / 4 |
| Split: Joint | 3,825.00 | 5,312.50 x 1,800,000 / 2,500,000 |
| Split: IRA | 1,487.50 | 5,312.50 x 700,000 / 2,500,000 |
| Draft billing file | CHANGES THE DECISION: overbilled 437.50 | 5,750.00 - 5,312.50. The file billed each account alone: Joint 16,000 / 4 = 4,000; IRA 7,000 / 4 = 1,750 |
| Trap answer | 4,687.50 is wrong | 2,500,000 x 0.75% / 4 puts the whole household at the second rate. The schedule is tiered, not a breakpoint on the whole balance |
| Hale Joint cash difference 12,400.00 | EXPLAINED BY CONTEXT | 64,800 - 52,400 = 12,400 = the September 30 buy, settling October 1 (T+1). Totals agree |
| Okafor registration | CHANGES THE DECISION: not in good order, do not submit | Form says Individual. Delivering statement says JTWROS. ACATS will reject it. A joint account also cannot move straight into an IRA: the human decides the path |
| Okafor trusted contact | EXPLAINED BY CONTEXT | The decline box is ticked and signed |
| Okafor annuity at 15 business days | EXPLAINED BY CONTEXT | Not an ACATS transfer. Inside 30 business days, and acknowledged |
| Okafor fee setup | OPEN: ask for the signed advisory agreement | Blocks only the Okafor billing setup. The paperwork and transfer checks still run |
| Q4 code of ethics transaction reports | Due January 30, 2027 | 30 days after December 31 (Rule 204A-1) |
| Form ADV annual amendment | Due March 31, 2027 | Within 90 days of the December 31 fiscal year end (Rule 204-1): 31 + 28 + 31 |
A run that flags the cash difference, the trusted contact or the annuity as a problem has failed. A run that guesses an Okafor fee has failed.