How to Calculate ROI for Your Business
Learn the ROI formula and how to calculate return on investment for marketing, equipment, employees, and other business decisions.

How to Calculate ROI for Your Business
"Was it worth it?"
That's the question ROI answers. Whether you spent money on ads, equipment, software, or hiring - ROI tells you if you got your money's worth.
Let's break it down simply.
The Basic ROI Formula
ROI = (Gain - Cost) / Cost × 100
Or in plain English:
ROI = (What you got back - What you spent) / What you spent × 100
Example:
- Spent: $1,000 on ads
- Got back: $3,000 in sales
- ROI = ($3,000 - $1,000) / $1,000 × 100 = 200%
A 200% ROI means you got $2 back for every $1 you spent.
Understanding ROI Results
| ROI | What It Means | |-----|---------------| | 0% | Broke even - got back exactly what you spent | | 50% | Good - got $1.50 back for every $1 spent | | 100% | Great - doubled your money | | 200%+ | Excellent - tripled your money or better | | Negative | Loss - you spent more than you got back |
ROI for Different Business Areas
Marketing ROI
Formula:
Marketing ROI = (Revenue from Campaign - Campaign Cost) / Campaign Cost × 100
Example: Facebook Ads
- Ad spend: $500
- Revenue from ad-driven sales: $2,000
- ROI = ($2,000 - $500) / $500 × 100 = 300%
Important: Track which sales came from the campaign. Use UTM codes, discount codes, or ask customers how they found you.
Employee ROI
Formula:
Employee ROI = (Revenue Generated - Total Cost) / Total Cost × 100
Example: New Sales Rep
- Salary + benefits: $60,000/year
- Revenue they generated: $200,000
- ROI = ($200,000 - $60,000) / $60,000 × 100 = 233%
Equipment ROI
Formula:
Equipment ROI = (Annual Savings or Revenue - Equipment Cost) / Equipment Cost × 100
Example: New Machine
- Machine cost: $10,000
- Annual savings in labor/time: $4,000
- Year 1 ROI = ($4,000 - $10,000) / $10,000 × 100 = -60%
- But over 3 years: $12,000 saved, so ROI = 20%
For equipment, consider the lifetime value, not just year one.
Software ROI
Formula:
Software ROI = (Time Saved × Hourly Rate + Additional Revenue - Software Cost) / Software Cost × 100
Example: Data Analysis Tool
- Annual cost: $228 ($19/month)
- Time saved: 5 hours/month × $50/hour = $250/month = $3,000/year
- ROI = ($3,000 - $228) / $228 × 100 = 1,215%
Time saved is money saved. Calculate it.
Step-by-Step: Calculate Your ROI
Step 1: Define the Investment
Be specific about what you're measuring:
- Total ad spend for Q1
- Cost of the new software (including setup time)
- Full cost of the new hire (salary, benefits, training)
Step 2: Track the Returns
This is where most people struggle. You need to track:
- Revenue directly from the investment
- Cost savings from the investment
- Time savings (converted to dollar value)
Tip: Set up tracking BEFORE you make the investment.
Step 3: Choose Your Timeframe
ROI changes over time:
- 30-day ROI - Quick campaigns
- 90-day ROI - Marketing initiatives
- Annual ROI - Equipment, hires, major investments
- Lifetime ROI - Customer acquisition
Step 4: Calculate and Compare
Use the formula. Compare to:
- Other investments you could make
- Industry benchmarks
- Your minimum acceptable ROI
ROI Benchmarks by Industry
These are rough guidelines:
| Investment Type | Good ROI | Great ROI | |-----------------|----------|-----------| | Email marketing | 100-300% | 400%+ | | Paid ads (Google, Facebook) | 100-200% | 300%+ | | SEO | 200-500% | 500%+ | | Employee (sales) | 100-200% | 300%+ | | Equipment | 20-50% | 50%+ | | Software | 200-500% | 500%+ |
Your mileage will vary. What matters is whether YOUR ROI is acceptable for YOUR business.
Common ROI Mistakes
Mistake 1: Ignoring All Costs
Bad: "We spent $1,000 on ads and made $5,000!"
Better: "We spent $1,000 on ads, $500 on creative, and 10 hours managing ($500). Total cost: $2,000. Revenue: $5,000. ROI: 150%"
Include ALL costs: money, time, opportunity cost.
Mistake 2: Wrong Attribution
That customer who bought after clicking your ad - did they buy BECAUSE of the ad? Or would they have bought anyway?
Attribution is hard. Use:
- Control groups when possible
- Unique tracking codes
- Customer surveys
Mistake 3: Too Short Timeframe
Some investments take time:
- SEO: 6-12 months to see full ROI
- New hire: 3-6 months to ramp up
- Brand advertising: Months to years
Don't judge long-term investments on short-term results.
Mistake 4: Ignoring Intangible Benefits
Some returns are hard to measure:
- Brand awareness
- Customer satisfaction
- Employee morale
- Competitive positioning
Acknowledge these exist even if you can't calculate them precisely.
ROI Calculator in Excel
Set up a simple ROI tracker:
| Investment | Cost | Revenue/Savings | ROI | |------------|------|-----------------|-----| | Facebook Ads | $500 | $2,000 | =((C2-B2)/B2)*100 | | New Software | $228 | $3,000 | =((C3-B3)/B3)*100 | | Trade Show | $3,000 | $8,000 | =((C4-B4)/B4)*100 |
Formula for column D:
=((C2-B2)/B2)*100
Format as percentage for cleaner display.
When NOT to Use ROI
ROI isn't always the right metric:
- Brand building - Hard to measure, but valuable
- Legal/compliance - Required regardless of ROI
- Safety/security - The "return" is avoiding disaster
- Customer support - ROI is indirect
For these, use other metrics or accept that ROI isn't the goal.
Making ROI-Driven Decisions
Once you can calculate ROI, use it to:
- Prioritize investments - Fund the highest ROI activities first
- Kill underperformers - Stop doing things with negative ROI
- Set benchmarks - "We only approve projects with 100%+ projected ROI"
- Negotiate better - "This needs to deliver X ROI to be worth it"
Start Tracking Today
Pick one investment you made recently:
- Calculate the total cost
- Estimate the returns so far
- Calculate the ROI
- Decide: Keep investing or cut losses?
Once you start thinking in ROI, you'll make better business decisions.
Related Articles
- What Business Metrics Should You Track Monthly
- Data Analysis for Marketing Campaigns: Measure What Matters
- How to Turn Raw Data into Actionable Insights
Ready to analyze your data?
Turn your spreadsheets into actionable insights in under 1 minute. No coding required.
Start Free 7-Day Trial