Revenue and Calc
Set advisor capacity, utilization, the five service allocations, hourly prices, and launch timing. Calc builds monthly revenue from one shared sold-hour pool.

The Financial Advisor Financial Model is an Excel-based planning template for a US independent, hourly, fee-only financial advice practice. It calculates revenue from one advisor-hour capacity pool, service mix, billable utilization, and realized hourly rates, then connects operating expenses and staffing to projected EBITDA.
The 2026–2030 case has one lead advisor and a part-time-to-full-time associate. It excludes AUM fees, commissions, custody, and owner personal taxes; figures are illustrative planning assumptions.
The workbook links practice assumptions and monthly calculations to statements and decision reports.
Set advisor capacity, utilization, the five service allocations, hourly prices, and launch timing. Calc builds monthly revenue from one shared sold-hour pool.
Plan specialist costs, revenue-linked charges, fixed overhead, and role-based compensation without counting advisor salaries twice.
Record equipment, owner equity, and Dashboard-controlled financing separately from operating earnings.
Review income-statement lines, cash movements, and financial position. The documented numeric case ends at EBITDA.
Compare Low, Base, and High sensitivities, break-even and investment returns, charts, and checks using selected inputs.
The revenue forecast uses monthly advisor hours multiplied by billable utilization, then assigns the resulting sold hours across five hourly advice services.
Available advisor time starts at 160 hours per month. Utilization rises from 45% in 2026 to 70% in 2030, and each of the five realized hourly prices increases from $250 to $290 over those years.
Sold hours are allocated 40% to comprehensive planning, 25% to retirement planning, 15% to investment advice, and 10% each to equity compensation and cash flow/debt planning. The shares total 100%.
The Revenue Forecast shows the capacity, utilization, service-hour allocations, and realized prices that drive monthly and annual advice fees. Changes to the input mix redistribute advisor time among services without creating extra billable hours.
160 available hours/month × 45% utilization = 72 sold hours/month; 72 × $250/hour × 12 months = $216,000 annual revenue.
Four expense groups flow into the forecast: outsourced direct work, revenue-linked variable costs, monthly fixed overhead, and separately planned payroll.
Outsourced specialist planning is 2% of revenue. Payment processing is 1% and cash client-acquisition marketing is 5%, so direct and variable expenses rise with billed advice fees while fixed office and professional costs follow annual monthly budgets.
The COGS and Operating Expenses forecast separates specialist planning, processing fees, acquisition marketing, and fixed practice overhead. It connects expense assumptions and timing to monthly costs rather than applying one undifferentiated operating margin.
| Cost category | 2026 | 2030 |
|---|---|---|
| COGS | $4,320 | $7,795 |
| Variable expenses | $12,960 | $23,386 |
| Fixed expenses | $60,600 | $68,196 |
| Payroll | $127,500 | $155,000 |
2026 and 2030 case amounts, independently rounded to whole dollars; totals are shown in the annual forecast below.
Payroll starts with a $100,000 lead advisor and a 0.5-FTE associate at $55,000 per full-time equivalent. The associate reaches 1.0 FTE in 2028; employer taxes and benefits are excluded.
The Payroll Forecast organizes staffing by role, annual-average FTE, compensation, and scheduling inputs. It helps test whether additional client-service support is affordable as advisor utilization rises, without duplicating salaries in outsourced specialist COGS.
Startup equipment, one-time launch payments, working capital, and owner funding are tracked apart from recurring operating expense and EBITDA.
The opening equipment list totals $7,400: two business laptops ($4,000), displays and docks ($1,600), network and backup hardware ($1,000), and meeting/video equipment ($800). Other opening cash items include formation help, a refundable office deposit, branding, prelaunch marketing, and preopening base payroll.
The Capital Expenditure Plan records equipment purchases, expenditure timing, and depreciation treatment in a separate investment schedule. These outlays are not automatically equivalent to the recurring operating expenses used to calculate EBITDA.
Working-capital controls set 15 receivable days, zero payable days, and zero inventory days. They affect cash timing, not sales, and cannot establish cash adequacy.
Sources and Uses of Funds organizes money raised and the cash allocated to operating, investment, and financing needs. The case estimates $88,247 of initial owner funding, including opening working capital and a policy reserve, with no confirmed external financing.
The case calculates increasing annual advice revenue and EBITDA as utilization and realized hourly pricing rise, while operating costs follow the specified staffing and expense inputs.
| Year | Revenue | Operating expenses | EBITDA |
|---|---|---|---|
| 2026 | $216,000 | $205,380 | $10,620 |
| 2027 | $274,560 | $225,627 | $48,933 |
| 2028 | $311,040 | $244,167 | $66,873 |
| 2029 | $349,440 | $249,183 | $100,257 |
| 2030 | $389,760 | $254,377 | $135,383 |
Forecast case only, not observed results. Original calculations retain cents; displayed annual amounts are rounded to whole dollars.
Revenue rises from $216,000 to $389,760 as monthly sold hours grow from 72 to 112 and hourly prices from $250 to $290. EBITDA increases from $10,620 to $135,383.
EBITDA deducts direct, variable, fixed, and payroll expenses. It is neither net profit after depreciation, interest, and taxes nor an available-cash amount.
The Projected Income Statement presents monthly profit-and-loss categories from revenue and direct costs through EBITDA and downstream accounting lines. The documented case supplies numeric operating results only through EBITDA, so no net-income amount is claimed here.
The companion Cash Flow and Balance Sheet reports provide tools to examine collections, equipment purchases, capital injections, debt, and cash positions. Their functions are included in the workbook, but this page does not assert unprovided liquidity, balance-sheet, or financing results.
The Cash Flow Forecast tracks operating, investing, and financing cash movements and reconciles opening to closing cash. Use it to evaluate the timing implications of 15-day receivables, startup purchases, owner funding, and any financing entered into the model.
The workbook supports comparisons of operating performance and investment recovery, but EBITDA alone cannot determine cash break-even, payback, or returns on invested capital.
Dashboard Low, Base, and High controls adjust revenue, direct costs, variable costs, fixed costs, and payroll. Compare EBITDA sensitivity without assuming scenario probabilities.
The Returns report distinguishes revenue break-even, cash break-even timing, investment payback, and annual return on invested capital. Each answers a different question and requires its relevant cost, cash-flow, and invested-capital calculations rather than a guessed EBITDA-based date or percentage.
Break-even evaluates required sales; payback uses cumulative project cash flow; ROIC relates returns to invested capital. Other reports include valuation and benchmarks.
It is intended for operators evaluating an independently run, fee-only hourly advice practice rather than an asset-based wealth-management or commission-selling business.
Test advisor availability, pricing, service mix, associate staffing, overhead, and opening capital. Inputs are assumptions rather than established industry norms or demand evidence.
AUM, commission, or custody-related revenue requires a different or customized revenue engine.
These answers clarify the template’s operating assumptions, editable inputs, and the difference between financial projections and proven business outcomes.
No. The modeled firm bills for hourly advice only, without assets-under-management fees, commissions, or custody.
Yes. The Revenue assumptions include monthly advisor capacity, annual billable utilization, service-hour allocation, and annual realized hourly prices.
No. All five services share one advisor-hour pool, and their percentages allocate total sold hours once.
The Payroll schedule plans role-based salaries and FTE, including the lead advisor and the client service associate.
No. EBITDA excludes depreciation, financing and tax effects and cannot be treated as net earnings or available cash.
No. It is an estimated opening owner-funding requirement in the example, not evidence of committed funds or future cash adequacy.
Yes. Returns reports cover break-even, cash payback, and ROIC, while the Dashboard supports Low, Base, and High scenarios; results depend on entered assumptions.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
I used to feel stuck on the formulas, but this template made the advanced parts easy to follow. I built the model without outside help and had a clean draft ready the same day.
Building the forecast by hand was taking forever, and this template cut that work down fast. I finished the full five-year plan in a few hours instead of spreading it across several days.
Everything was scattered across tabs and files before, so sharing updates was a mess. With this model, my statements and charts were in one place, and I had a cleaner deck for my meeting.