By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated November 17, 2026
A services pricing model in Excel works in four layers: an inputs sheet with your costs and billable hours, a floor-rate calculation, a services sheet that turns hours into prices, and a rate card your team quotes from. Build it in that order and every price traces back to a number you can change in one cell. Skip the first layer and the prices become guesses.
This guide walks through each layer with formulas and one worked example. It is written for owners of service businesses, founders and managers who already live in spreadsheets and want prices that cover costs and leave a profit.
TL;DR
- Start with the revenue you need (owner pay, benefits, overhead, taxes), then divide by realistic billable hours to get a floor rate.
- Price packages as estimated hours, times a buffer, times the floor rate, then round to a number clients accept.
- Know the difference between markup and margin. A 40% markup is not a 40% margin.
- Keep inputs on one sheet, the calculator on another and the rate card as a read-only output, so quotes stay consistent.
- Add three checks: a total reconciliation, a margin flag and a locked rate card.
Table of Contents
- What a services pricing model has to answer
- Step 1: Build the inputs sheet
- Step 2: Calculate your floor rate
- Step 3: Price each service from hours
- Step 4: Use the right formulas for cost, markup and margin
- Step 5: Turn it into a pricing calculator
- Step 6: Design the rate card
- Step 7: Check the model for errors
- Common mistakes to avoid
- Where we can help
- Our view on pricing in a spreadsheet
- FAQ
- Sources
What a services pricing model has to answer
A product business can price off the cost of goods. A service business sells time, skill and attention, so the cost is mostly people, and the main risk is selling hours you never get paid for.
Your model should answer four questions:
- What revenue must the business earn to pay you, cover benefits, overhead and taxes?
- How many hours can you realistically bill in a year?
- What does each service cost to deliver, and what should it sell for?
- If you change an assumption (hours, pay, margin), what happens to every price?
Excel handles all four because formulas recalculate when an input changes. That is the whole advantage of a model over a price list typed into a document.
Step 1: Build the inputs sheet
Create a sheet named Inputs. Every assumption lives here, once, in a labeled cell with a consistent color (blue text for inputs is a common convention). Nothing on this sheet is calculated.
Include these rows:
| Input | Example value | Notes |
|---|---|---|
| Desired owner pay (annual) | $150,000 | What you want to take home |
| Benefits (annual) | $30,000 | Health coverage, retirement, other |
| Overhead (annual) | $15,000 | Software, insurance, marketing, accounting |
| Tax buffer (annual) | $11,475 | Set aside for taxes on the business |
| Working weeks per year | 48 | After vacation and holidays |
| Billable hours per week | 20 | Hours you invoice, not hours you work |
| Delivery buffer | 1.5 | Multiplier on time estimates |
| Target gross margin | 40% | Used for team-delivered services |
The numbers above follow a consultant rate example published by the Council on Pharmacy Standards, a professional association. The logic applies to any professional service, so swap in your own values.
Why billable hours are the input people get wrong
The most common mistake is assuming you will bill 35 or 40 hours a week. You will not. Administration, sales calls, proposals, marketing and managing people all take time that no client pays for. The same Council guidance notes that mature practices typically bill 40 to 60% of their time, which means the hourly rate has to sit well above what a simple salary-to-hourly conversion suggests.

If you are new, start at 50% and adjust after a quarter of real timesheet data.
Step 2: Calculate your floor rate
The floor rate is the lowest hourly rate at which the business covers all its costs and pays you what you set. Below it, you are working at a loss against your own plan.
On a sheet named Rate, build three formulas:
- Revenue needed:
=SUM(owner pay, benefits, overhead, tax buffer) - Billable hours per year:
=weeks * billable hours per week - Floor rate:
=revenue needed / billable hours
With the example inputs, revenue needed is $150,000 + $30,000 + $15,000 + $11,475 = $206,475. Billable hours are 48 weeks times 20 hours, which is 960. The floor rate is $206,475 divided by 960, or about $215 per hour, matching the Council’s worked example.
Notice what happens if you assumed 30 billable hours a week instead of 20. The rate drops to roughly $143, and you would underprice by about a third whenever your real week looks like 20. This is why the billable-hours cell deserves the most scrutiny in the whole workbook.
Step 3: Price each service from hours
Now a sheet named Services. One row per service, with these columns:
| Column | What it holds |
|---|---|
| Service | Name of the offer |
| Estimated hours | Your honest time estimate |
| Buffered hours | =Estimated hours * Inputs!Buffer |
| Cost price | =Buffered hours * Floor rate |
| Rounded price | =MROUND(Cost price, 50) or =CEILING(Cost price, 100) |
| Effective hourly rate | =Rounded price / Estimated hours |
The flat-fee method is the one the Council describes: estimate the time, multiply by a 1.5 buffer, apply the floor rate and round to a market-friendly number.
A worked example
Suppose you sell a monthly reporting package and estimate 12 hours of work.
- Buffered hours: 12 × 1.5 = 18
- Cost price: 18 × $215 = $3,870
- Rounded to a clean number: $3,900
If the work really takes 12 hours, you earn about $325 per hour on that job. If it takes 18, you earn the floor rate. The buffer is not padding for the client. It protects you from the scope creep, revisions and back-and-forth that estimates leave out.
The effective hourly rate column is the quiet hero. If a package you thought was healthy shows an effective rate below the floor, the model tells you before you sign the client.
Step 4: Use the right formulas for cost, markup and margin
If you deliver with contractors or employees, hourly rate alone is not enough. You need to price on top of what delivery costs you. The two terms below are mixed up constantly.
| Term | Formula | Example (cost $2,000) |
|---|---|---|
| Break-even price | =Total cost |
$2,000 |
| Price with markup % | =Cost * (1 + markup) |
40% markup gives $2,800 |
| Gross margin on that price | =(Price - Cost) / Price |
$800 / $2,800 = 28.6% |
| Price for a target margin | =Cost / (1 - margin) |
40% margin gives $3,333 |
A 40% markup yields only a 28.6% margin. If your plan says you need a 40% margin, use the last formula, not the markup one. This single swap is behind many underpriced quotes.
In the model, put the target margin on the Inputs sheet and have the Services sheet calculate price with =Cost / (1 - Inputs!Margin). For solo work, the floor-rate method above already includes your pay, so use margin only for the parts of a package others deliver.
If you want a deeper look at fitting formulas to your pricing, our guide on Excel pricing models, two formulas and Solver only as needed goes further.

Step 5: Turn it into a pricing calculator
A pricing calculator is the same model with a front end: a sheet where someone picks a service, enters a quantity and gets a price without touching the formulas.
A simple version needs three pieces:
- A dropdown. Use Data Validation to list the service names from the Services sheet.
- A lookup.
=XLOOKUP(selected service, Services!A:A, Services!E:E)pulls the price. Older versions of Excel can useINDEXwithMATCH. - Add-ons. Rush fees, extra revisions or additional locations as separate rows with their own unit prices, multiplied by quantity.
The calculator total is =SUM(base price, add-ons) * (1 - discount). Put the discount in an input cell with a cap so nobody can quote a price below the floor.
Testing assumptions
The reason to use a model is to ask what-if questions. Try these:
- Drop billable hours from 20 to 16 a week. How far does the floor rate rise?
- Raise owner pay by 10%. Which packages fall below target margin?
- Cut the buffer from 1.5 to 1.2. Which services stop being profitable if the work runs long?
For a fast side-by-side, build a small data table with billable hours down the side and the buffer across the top, and let it show the floor rate or margin for each pair. You see in one view how fragile a price is.
Step 6: Design the rate card
The rate card is the client-facing output. It should read like a menu, with no formulas visible and no room for improvisation.
Good rate cards share a few features:
- Service name and a one-line description of what is included.
- A unit: per hour, per project, per month or per deliverable. Pick one unit per line.
- The rate pulled by formula from the Services sheet, never typed in.
- Package tiers side by side, such as Basic, Standard and Premium, with the differences shown as rows of what each includes.
- Add-ons and exclusions listed under the packages.
- A validity note, such as the date the rates were last reviewed.
A layout that works:
| Service | Unit | Basic | Standard | Premium |
|---|---|---|---|---|
| Monthly reporting | Per month | $1,900 | $3,900 | $6,200 |
| Cash flow review | Per project | $1,200 | $2,400 | $4,000 |
| Extra revision round | Per round | $150 | $150 | Included |
The figures here are placeholders to show the structure. Yours come from your own floor rate and estimates.
Three tiers are easy to compare, and the middle tier is usually the one you want most clients to pick. Build the tiers so the Standard package has the best effective hourly rate for you, not the cheapest sticker price for them.
Step 7: Check the model for errors
A pricing model is only useful if people trust it. Build the checks in before you share it.
- Reconcile the totals. Add a cell that checks that revenue needed equals floor rate times billable hours. If it returns anything other than zero difference, something broke.
- Flag low margins. Use conditional formatting on the effective-rate and margin columns so any row below the floor turns red.
- Remove hard-coded numbers. Press Ctrl+` (grave accent) to show formulas, or use Go To Special, Constants, to find typed numbers sitting where formulas should be.
- Lock the rate card. Protect the sheet so only the Inputs sheet can be edited. Quotes then always come from the same source.
- Version it. Save a dated copy each time you change a rate, so you can explain an old quote later.
- Test the extremes. Enter zero hours, a huge quantity and a 100% discount. A good model returns something sensible or a clear error message, not a negative price.
Consistency is the real prize. When every quote comes from the same rate card, two people on your team cannot quote the same job at two different prices.
Common mistakes to avoid
- Using take-home salary divided by 2,080 hours as your hourly rate. That ignores overhead, taxes and unbilled time.
- Counting every working hour as billable.
- Treating markup and margin as the same number.
- Pricing once and never revisiting. Review the inputs at least once a year, or when your costs change.
- Letting discounts float. Set a floor and a maximum discount in the model.
Where we can help
If you would rather not build this from scratch, our Excel templates are made for businesses that want to stay in Excel and Google Sheets. Our Profitability and Pricing Analysis product is built for exactly this question: what each service really earns and what it should sell for.
For a tailored build, our one-time finance projects include a Pricing Analysis, a Break-Even Analysis and a Profitability Review. If you want ongoing help keeping prices current as costs change, our fractional CFO plans start with Starter at $600 per month or $7,200 per year, and our Launch Kit is a one-off $650. Our onboarding is hands-on and email support is included.
Once your prices are set, it helps to see which clients actually deliver the margin you planned. Our guide to client profitability analysis in Excel shows how.
Our view on pricing in a spreadsheet
We focus on spreadsheet-based finance because many small and midsize businesses do not need a new platform to price well. They need the numbers they already have, organized so they tell a story.
A pricing model in Excel or Google Sheets gives you something software often hides: you can see every assumption, change it and understand why a price moved. You keep full control and understanding of your financial data with tools you already use.
Our approach is to start from the business’s real costs and hours, build the model around them, and connect it to cash flow forecasting, profitability analysis and KPI dashboards, so pricing is not a one-time exercise but part of how you manage the business. Whether you start with a template, a one-time project or an ongoing fractional CFO engagement, the goal is the same: prices you can defend and a business that earns what you planned.
frac
FAQ
What should a services pricing model in Excel include?
At minimum: an inputs sheet (owner pay, benefits, overhead, taxes, weeks worked, billable hours), a floor-rate calculation, a services sheet that converts hours to prices, and a rate card. Add a margin check and a lookup-based calculator as you grow.
How do I calculate an hourly rate for my services?
Add the annual revenue you need to cover owner pay, benefits, overhead and a tax buffer, then divide by your realistic billable hours per year. In the worked example above, $206,475 divided by 960 hours gives about $215 per hour.
What is the difference between markup and margin?
Markup is the percentage added to cost, while margin is the share of the price that is profit. A 40% markup on a $2,000 cost gives a $2,800 price and a 28.6% margin. To hit a 40% margin, divide cost by 0.6, which gives $3,333.
Should I charge hourly or by package?
Packages are easier for clients to compare and let you earn more when you work efficiently. Estimate the hours, apply a buffer, price at your floor rate and round. Keep an hourly rate on the rate card for work outside the package scope.
About the author
Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.

