Companion files · The Private Markets Career Guides
How to Run a Profitable Independent Financial Advisor Practice and RIA: Fee Schedules, Quarterly Billing, Market Swings, Client Flows, Capacity, Team Pay, Compliance, Cash and Succession.
These are the companion files of the book. Six workbooks follow Ostervane Wealth Advisors, the fictional advisory firm of the case, across two fiscal years: households and fees, billing and markets, flows and clients, team and capacity, cash and decisions, and profit and value. Each keeps the case’s figures on an inputs tab, with empty cells for yours. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 4 and 5
The fee schedule in marginal bands, the minimum and the grandfathered households, and each household’s annual, quarterly and effective fee, sorted by size. Sheets: Inputs, Schedule, Households, Size. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 139 KBChapters 6 and 7
One row for each household and each quarter billed in advance, the refunds, the same quarters billed in arrears, and the assumed quarterly return. Sheets: Inputs, Billing, Refunds, Comparison, Markets. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 2271 KBChapters 8 and 9
The assets roll-forward with the market effect on its own line, the estates, and the cost of a household won through each channel. Sheets: Inputs, Roll-forward, Channels. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 316 KBChapters 10 and 11
Service hours against each advisor’s hours available, the hours the households need, and people costs from W-2 pay to the contractor. Sheets: Inputs, Hours, People costs. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 417 KBChapters 13, 14 and 15
Quarterly cash and the line of credit, the acquisition and its retention ratio, then four decisions of year two, each a projection. Sheets: Inputs, Cash, Acquisition, Decisions. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 522 KBChapters 12 and 16
Both income statements, EBITDA, seller’s discretionary earnings, the founder’s pay, and the founder’s planning range. Sheets: Inputs, Income statement, Earnings, Planning range. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 617 KBAppendix B
Opening a household and its advisory agreement; The quarterly billing review; The annual compliance review, in the conditional; The annual Form ADV update, in the conditional; Hiring and onboarding an advisor; A household’s departure; The founder’s monthly review; Preparing a succession or a sale.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| The fee | $1,000,000 x 1.00 percent + $500,000 x 0.80 percent = $14,000 a year for a household of $1,500,000, an effective fee of 0.93 percent |
| The down quarter | $231,676 billed in advance - $219,075 in arrears = $12,601 in January to March 2025 |
| The firm’s earnings | $441,989 + $170,000 + $30,600 = $642,589 of SDE in FY2026 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Ostervane Wealth Advisors, Corrowmere, the founder, the advisors, the compliance consultant, the bank, the landlord, the retiring advisor and every party are fictional, and the fee schedules, minimums, returns, flows, salaries, costs, prices and multiples are the book’s assumptions, not market terms or the practice of any real firm. A household here is an account value, a fee, a flow, hours of service and a date: no investment, product or strategy is described or recommended. Registration, custody and worker classification depend on your regulator and your agreements: ask counsel, your compliance consultant and your outside CPA.