ROIreturn on investmentbusiness metricsfinancial analysis

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.

Gyeongbin MinDecember 21, 2025
How to Calculate ROI for Your Business

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:

  1. Prioritize investments - Fund the highest ROI activities first
  2. Kill underperformers - Stop doing things with negative ROI
  3. Set benchmarks - "We only approve projects with 100%+ projected ROI"
  4. Negotiate better - "This needs to deliver X ROI to be worth it"

Start Tracking Today

Pick one investment you made recently:

  1. Calculate the total cost
  2. Estimate the returns so far
  3. Calculate the ROI
  4. Decide: Keep investing or cut losses?

Once you start thinking in ROI, you'll make better business decisions.


Related Articles


Ready to analyze your data?

Turn your spreadsheets into actionable insights in under 1 minute. No coding required.

Start Free 7-Day Trial