Free Excel templates

A free fractional CFO pricing calculator in Excel: the real hourly rate of each retainer, clients per CFO and the margin of a contractor-delivered client

Retainer prices, scope hours, client-months, creep, working weeks and utilization, the contract CFO rate and the funnel in; the paper and worked rate of each tier, profit per hour, the clients one CFO can carry, the margin of each tier delivered by a contractor, a creep stress test, the price increase and the leads growth needs out: one sheet of inputs, live formulas and six checks.

The worked case sold retainers at $317 an hour on paper and $276 per hour actually worked; one CFO can deliver 1,408 client hours a year, and a Growth client delivered by a contract CFO earns $44,484 of margin.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 212 free models.

FCFO_Pricing_Calculator.xlsx (13 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Fractional CFO, which explains the method behind it, chapter by chapter.

Get the PDF edition → See the book

Want every model at once?

The Financial Model Library: all 213 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

3 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Inputs
Retainer prices, scope hours, client-months and clients by tier; creep, projects, selling hours and overhead; working weeks, hours and utilization; 2027 prices, creep, a stress-test creep, the contract CFO rate and review time; the funnel, tenure and the liability cap.
Pricing
The year's revenue, profit and hours; the paper and worked rate of each tier; capacity and clients per CFO; the margin of one client of each tier delivered by a contractor, at the expected and the stress-test creep; the price increase, the pipeline and the liability caps.
Checks
Six tests on prices, creep, utilization, weeks and hours, conversion rates and counts, and an All checks cell.

What the worked case returns

MeasureValue
Retainer revenue per hour of scope (paper rate)$317
Retainer revenue per hour worked$276
Profit per hour of the owner's time$196
Client hours a year for one CFO1,408
Growth clients one CFO can carry4.8
Growth client margin, delivered by a contract CFO$44,484
Growth client margin at the stress-test creep$37,950
Creep at which a Strategic client earns nothing103.7%
Revenue that can leave after the price increase9.1%
Qualified leads needed for the wins wanted50

Every figure is a teaching assumption of the book's fictional practice, not a market rate or a quote. Whether a contractor is an employee and how a practice should be taxed are questions for counsel and a CPA. Not legal, tax or accounting advice.

How to use it on your own case

  1. Type your retainer tiers: price a month, scope hours and the client-months billed last year.
  2. Enter the hours you really worked above scope, your working weeks and the share of time on clients.
  3. Enter next year's prices, the contract CFO rate and the creep you expect.
  4. Read the worked rate, the clients one CFO can carry and each tier's margin, then the checks.

Questions people ask about it

How do I know my real fractional CFO hourly rate?

Divide the retainer revenue by the hours you actually worked on it, not by the scope hours; in the worked case the gap is about forty dollars an hour.

How many clients can one fractional CFO carry?

Divide the client hours you can deliver in a year by each client's scope hours times twelve, plus creep; the calculator does it for each tier.

Does the calculator include taxes?

No. It covers pricing, capacity and margins; the book's third workbook compares a sole proprietorship and an S corporation.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Fractional CFO go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Fractional CFO. See the book.