# The Financial Advisor Practice Owner: companion files

Julian R. Sterling

## What is here

- FAPO_1_Households_and_Fees.xlsx (Chapters 4 and 5; Households and Fees workbook of Appendix A): sheets Inputs, Schedule, Households, Size, then Checks. The fee schedule in marginal bands, the minimum and the grandfathered households, the example households of the chapters, and the 113 households of 30 June 2026 with their annual, quarterly and effective fees, sorted by size ($143,009,476 of assets, $1,284,935 of annual asset-based fees on that day's values).
- FAPO_2_Billing_and_Markets.xlsx (Chapters 6 and 7; Billing and Markets workbook): sheets Inputs, Billing, Refunds, Comparison, Markets, then Checks. One row for each household and each quarter, billed in advance ($895,276 then $1,172,442 of fees billed), the refunds of the households that left, the same quarters billed in arrears ($12,601 more in advance in the down quarter of January to March 2025), and the case's assumed quarterly return.
- FAPO_3_Flows_and_Clients.xlsx (Chapters 8 and 9; Flows and Clients workbook): sheets Inputs, Roll-forward, Channels, then Checks. The assets roll-forward of each year with the market effect on its own line (net flows $4,351,654 then $31,099,952), the estates, and the cost of a household won through each channel.
- FAPO_4_Team_and_Capacity.xlsx (Chapters 10 and 11; Team and Capacity workbook): sheets Inputs, Hours, People costs, then Checks. Service hours against hours available (the founder at 106.8 percent in FY2026), the hours the households of 30 June 2026 need, and people costs ($392,907 then $530,449).
- FAPO_5_Cash_and_Decisions.xlsx (Chapters 13, 14 and 15; Cash and Decisions workbook): sheets Inputs, Cash, Acquisition, Decisions, then Checks. Quarterly cash, the distributions and the line of credit (drawn once in October to December 2025, a balance of $70,381 at 31 December 2025), the acquisition and its retention ratio (90.02 percent), then the decisions of November 2026, all projections: a higher minimum ($1,158 a year), a second associate advisor, compliance in or out, a network of independent advisers.
- FAPO_6_Profit_and_Value.xlsx (Chapters 12 and 16; Profit and Value workbook): sheets Inputs, Income statement, Earnings, Planning range, then Checks. Both income statements ($307,814 then $424,916 of net income), EBITDA, seller's discretionary earnings ($500,614 then $642,589), the founder's pay and the founder's planning range ($2,327,945 to $3,259,123).
- FAPO_Financial_Advisor_Practice_Owner_Checklists.docx: the 8 check-lists of Appendix B, editable (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).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input: the case's figures in blue on a light blue background, and an empty yellow cell beside each figure you are likely to replace. The calculation takes your figure when you type one and the case figure otherwise, and every other sheet reads from Inputs. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow cells are empty. Each of the 15 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In FAPO_1_Households_and_Fees.xlsx, on Inputs, type your own bands and rates: the fee, the quarterly fee and the effective fee of the example households move at once.
2. In FAPO_2_Billing_and_Markets.xlsx, on Inputs, type your own refund terms (months refunded out of a quarter): every refund and the quarter's net fees follow.

To use a workbook on your own firm, fill the yellow cells from your custodian's quarter-end values, your billing file, your advisory agreements, your timesheets, your payroll, the bank statements and the accounting system, in the order Appendix A gives, and keep a copy with the case for comparison. Date every input. Keep the fiscal year aligned: the case runs from 1 July to 30 June. Set your conventions with your outside CPA first: when a quarter's fee becomes revenue, and how a refund is booked. The workbooks are separate files with no link between them.

## A word of caution

Ostervane Wealth Advisors, LLC, the town of Corrowmere, its founder, advisors and staff, the compliance consultant, the bank, the landlord, the retiring advisor and the firm that approached the founder are fictional. Fee schedules, minimums, returns, flows, salaries, costs, prices and multiples are teaching assumptions, not market norms or benchmarks. The quarterly returns are assumptions that move account values, never a market history and never a forecast. A household in these files 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, advisory agreements, worker classification, an acquisition's terms and taxes are questions for counsel, your compliance consultant, your outside CPA and your insurance broker. No real adviser, custodian, network, platform or software is described or recommended. Nothing here is investment, legal, tax, insurance or accounting advice.
