RIA & Wealth Management Practice Acquisition Model   Excel template (XLSX)
$99.00

RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
Flevy is the marketplace for business best practices.
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
RIA & Wealth Management Practice Acquisition Model (Excel template (XLSX)) Preview Image
Arrow   Click main image to view in full screen.

RIA & Wealth Management Practice Acquisition Model – Excel XLSX

Excel (XLSX) + supplemental PDF

$99.00
Prices an advisory book on cash flow instead of 2.2x recurring revenue: an AUM roll-forward, the advisor hired to replace the owner's production, and a -20% market drawdown read at the DSCR.
Add to Cart
  


Immediate download
Fully editable Excel
Free lifetime updates

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

  1. See the broker's revenue-multiple price of $4.18M and the cash-flow price of $2.19M in one panel, each with its own DSCR, so you can show a seller exactly where the two methods diverge.
  2. Model the risk that is specific to fee-based advice: a 20% market drawdown, damped by the fee-billing lag and stacked on transition attrition, pushes the DSCR to 0.80x.
  3. Use the seller note as a coverage lever, switching between full standby and amortising, with the loan sized to DSCR rather than to collateral, since a client book is collateral-light.

WEALTH MANAGEMENT EXCEL DESCRIPTION

RIA & Wealth Management Practice Acquisition Model is an Excel template (XLSX) with a supplemental PDF document available for immediate download upon purchase.

This model is for a solo or junior buyer, or an aggregator making an add-on, acquiring a registered investment advisor or wealth-management practice with an SBA 7(a) loan. It is the file you hand the lender.

The valuation error it intercepts is the multiple itself. A broker prices a retiring advisor's $200M book on a revenue multiple: at 2.2x recurring revenue that is $4.18M. A bank prices the same book on the cash flow that survives after a real advisor replaces the owner's own production, at about $275,000 of compensation. Underwritten that way the practice pencils at $2.19M, which is 6.0x Adjusted EBITDA. The model shows the two prices side by side with the DSCR at each, and the roughly $2.0M gap is the whole decision.

How the engine works. AUM of $200M runs through a graduated fee schedule to a blended rate near 0.95%, producing recurring advisory revenue, with planning and retainer fees and any transactional business added on their own lines; the recurring share is 92%. A retention and transition roll-forward carries client attrition explicitly, at 90-95% when a custodian move is handled well and 78-82% when it is botched, and an earnout can be tied to a 95%-at-month-24 benchmark. Because advisory fees are AUM-linked, the down-case is a market drawdown rather than a generic haircut: a 20% fall, damped by the fee-billing lag and combined with transition attrition, drives the DSCR to 0.80x, below a 1.25x floor. The base case shows a true DSCR of 1.40x against a naive broker-style 2.52x. The SBA 7(a) stack combines buyer equity, a seller note with a full-standby or amortising toggle used as a DSCR lever, and a loan sized to coverage; leverage lands near 66%, which the model states plainly, because a wealth book is goodwill-heavy and collateral-light, so a lender sizes to cash flow rather than to loan-to-value.

Inside are 11 tabs over a five-year horizon: the AUM roll-forward and blended-fee engine, revenue mix, retention and transition, valuation with both prices, the capital stack, a DSCR and debt gate with recurring-fee coverage and debt yield, the market-drawdown down-case, returns, three profiles ranging from transactional and hybrid-heavy at 5.0x to fee-only recurring-forward at 7.0x, and a dashboard. Every assumption is editable and highlighted, with no macros, so the file also opens in Google Sheets, and a 24-page PDF guide explains what each number means.

What it does not claim. SDE near 31% and Adjusted EBITDA near 18% are deliberately unflattering. There is no live IRR by design, and MOIC is flagged as leverage-amplified. It is an educational planning tool, not investment or financial advice.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Wealth Management, Integrated Financial Model Excel: RIA & Wealth Management Practice Acquisition Model Excel (XLSX) Spreadsheet, ProformaWorks


$99.00
Prices an advisory book on cash flow instead of 2.2x recurring revenue: an AUM roll-forward, the advisor hired to replace the owner's production, and a -20% market drawdown read at the DSCR.
Add to Cart
  

ABOUT THE AUTHOR

Author image
Author: ProformaWorks
Additional documents from author: 43

ProformaWorks builds acquisition-grade financial models for Main Street and lower-middle-market businesses - the kind of deal financed with an SBA 7(a) loan or a small commercial facility.

Every model answers one question: does this deal pencil at the bank? That means SDE or NOI rebuilt from the seller's own numbers, the add-backs a lender will and will not accept, a debt-service ... [read more]

Ask the Author a Question

You must be logged in to contact the author.

Click here to log in Click here register

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided business templates to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab





Read Customer Testimonials

 
"Flevy is our 'go to' resource for management material, at an affordable cost. The Flevy library is comprehensive and the content deep, and typically provides a great foundation for us to further develop and tailor our own service offer."

– Chris McCann, Founder at Resilient.World
 
"I have found Flevy to be an amazing resource and library of useful presentations for lean sigma, change management and so many other topics. This has reduced the time I need to spend on preparing for my performance consultation. The library is easily accessible and updates are regularly provided. A wealth of great information."

– Cynthia Howard RN, PhD, Executive Coach at Ei Leadership
 
"I am extremely grateful for the proactiveness and eagerness to help and I would gladly recommend the Flevy team if you are looking for data and toolkits to help you work through business solutions."

– Trevor Booth, Partner, Fast Forward Consulting
 
"As an Independent Management Consultant, I find Flevy to add great value as a source of best practices, templates and information on new trends. Flevy has matured and the quality and quantity of the library is excellent. Lastly the price charged is reasonable, creating a win-win value for "

– Jim Schoen, Principal at FRC Group
 
"As a niche strategic consulting firm, Flevy and FlevyPro frameworks and documents are an on-going reference to help us structure our findings and recommendations to our clients as well as improve their clarity, strength, and visual power. For us, it is an invaluable resource to increase our impact and value."

– David Coloma, Consulting Area Manager at Cynertia Consulting
 
"My FlevyPro subscription provides me with the most popular frameworks and decks in demand in today’s market. They not only augment my existing consulting and coaching offerings and delivery, but also keep me abreast of the latest trends, inspire new products and service offerings for my practice, and educate me "

– Bill Branson, Founder at Strategic Business Architects
 
"One of the great discoveries that I have made for my business is the Flevy library of training materials.

As a Lean Transformation Expert, I am always making presentations to clients on a variety of topics: Training, Transformation, Total Productive Maintenance, Culture, Coaching, Tools, Leadership Behavior, etc. Flevy "

– Ed Kemmerling, Senior Lean Transformation Expert at PMG
 
"I have used Flevy services for a number of years and have never, ever been disappointed. As a matter of fact, David and his team continue, time after time, to impress me with their willingness to assist and in the real sense of the word. I have concluded in fact "

– Roberto Pelliccia, Senior Executive in International Hospitality



Customers Also Like These Documents

Explore Templates on Related Management Topics



Your Recently Viewed Documents
Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more.