Howdo you use the ROI formula on Excel?to calculate ROI in Excel (with formulas and examples)

ROI Formula In Excel: How To Calculate Returns Accurately (2026)Every finance team has been there: a dozen spreadsheets open, formulas referencing the wrong cells, and a stakeholder asking for updated ROI numbers by end of day. Calculating return on investment is straightforward when you have the right formula — and Excel makes it easy to build a reusable setup for any project, campaign, or purchase.

Skip to main contentSkip to footer

• monday.com

• English

  Español

  Português

  Français

  Deutsch

  日本語

  한국어

• Get started

• Topics

  • Project management

  • CRM and sales

  • Product development life cycle

  • Service management

  • AI Agents

  • Marketing

  • Construction management

  • monday campaigns

  • monday.com updates

Get started

Task management

[

monday.com](https://monday.com/blog/author/the-monday-com-team/)

•Jan 9, 2025 •6 min read

Get startedContact sales

Link Copied!

What is an ROI formula in Excel?

Why use an ROI formula in Excel?

What are some examples of ROI formulas in Excel?

monday.com’s ROI formula template for Excel alternative

Related templates

Staying on top of your company’s finances is absolutely critical. Regardless of industry or what sort of goods or services you’re selling, you need to know how much money is going into and out of the business because that’s going to tell you how worthwhile everything you’re doing is.

This is often called “working out your ROI” (Return on Investment), and it can be done using a fairly simple calculationROI — return on investment — is one of the most straightforward ways to measure whether a project, campaign, or purchase was worth the spend. And Excel remains the go-to for running those calculations because it’s familiar, flexible, and already sitting on most company laptops. In this guide, we’ll explain the importance of ROI, how to use it in Excel, and most importantly how to supercharge those calculations and avoid wasted manual time with monday.com’s ROI formula templateKnowing how to set up an ROI formula in Excel gives you a repeatable way to evaluate any investment in minutes.

What is an ROI formula in Excel?

Before we talk ROI formulas, let’s pump the brakes and cover what ROI isBelow, you’ll find the core ROI formula, 4 common variations with worked examples, a step-by-step guide to building your own ROI calculator spreadsheet, and a look at where Excel falls short for ongoing tracking. We’ll also explore how a connected platform can automate the tracking process so your numbers stay accurate without the manual upkeep.

Key takeaways:

Here’s a snapshot of what this article covers — from the core formula to advanced variations and where Excel reaches its limits. Whether you’re new to ROI calculations or refining your spreadsheet setup, these points give you the essentials at a glance.

• The basic ROI formula is (Net Profit / Cost of Investment) x 100 — it gives you a percentage that shows how much return you earned relative to what you spent.

• You can build a functional ROI calculator in Excel in 5 steps — from labeling columns to adding conditional formatting that color-codes profitable and unprofitable investments.

• 4 ROI formula variations cover different scenarios: net income ROI, capital gain ROI, total return ROI, and annualized ROI each answer a slightly different financial question.

• ROI has real limitations: it doesn’t account for the time value of money, ignores risk, and provides a static snapshot that can become outdated fast.

• A connected platform replaces manual Excel ROI tracking with formula columns that auto-calculate, dashboards that display live metrics, and automations that update figures whenever project data changes.

What is return on investment (ROI)?

So how do you know whether a project was worth the spend? That’s exactly what ROI answers. Return on investment is a performance metric that measures how much profit — or loss — an investment generates relative to its cost. It’s expressed as a percentage, making it straightforward to compare across different projects, campaigns, or assets.

ROI matters because it simplifies complex financial decisions into a single, comparable number. Whether you’re evaluating a marketing campaign’s return, a new piece of equipment, or a software subscription, ROI tells you if the dollars you put in generated more dollars coming out. Teams use it to prioritize investments, justify budgets, and communicate results to stakeholders who need fast answers, not lengthy financial reports.

The basic formula looks like this: ROI = (Net Profit / Cost of Investment) x 100. If you invested $10,000 and earned $12,500 back, your net profit is $2,500 and your ROI is 25%. Simple enough — but there’s a catch. Standard ROI doesn’t account for the time value of money, meaning a 25% return over 1 year looks identical to a 25% return over 5 years. We’ll cover that limitation — and how to handle it — later in this article.

The basic ROI formula and how it works

What is the simple equation for ROI? At its core, the ROI formula has two variables and one operation:

ROI = (Net Profit / Cost of Investment) x 100

Return on investment (ROI) is a key business performance metric that companies and individuals use to calculate how efficient or profitable their investment isHere’s what each part means. Net profit is the difference between what you earned and what you spent. Cost of investment is the total amount you originally put in. It can also be used to compare different types of investments to figure out your net profit for each investment optionMultiplying by 100 converts the decimal into a percentage so you can compare it across investments without reaching for a calculator.

Download Excel templateLet’s walk through a quick example. Suppose your team spends $10,000 on a paid advertising campaign. At the end of the quarter, that campaign generated $12,500 in revenue directly attributed to those ads. Here’s the math:

• Net Profit: $12,500 – $10,000 = $2,500

• ROI: ($2,500 / $10,000) x 100 = 25%

A positive ROI — anything above 0% — means the investment returned more than it cost. A negative ROI means you lost money. The higher the percentage, the more profitable the investment relative to its cost. Keep in mind that this basic formula gives you a total return figure regardless of how long the investment took to pay off. For time-adjusted comparisons, you’ll want the annualized ROI variation covered below.

4 common ROI formula variations in Excel

The basic ROI formula works for quick, one-off calculations. But different financial scenarios call for different approaches. Each of the 4 variations below answers a slightly different question, and each one translates neatly into an Excel formula with specific cell references. Which one is right for your situation? That depends on what you’re measuring and how precise you need to be.

Net income ROI

You can also compare your ROI over multiple time periods to calculate the growth rate at which your returns may have changed. To calculate your team’s ROI, you’d use a basic ROIThis is the most common version and the closest to the basic formula. That calculation is just the return — or net income — your investment has generated dividedNet income ROI divides your net income (revenue minus all expenses) by the cost of that investment. The resulting ratio or percentage will tell you how profitable that investment, project, or product really is.

Formula: ROI = Net Income / Cost of Investment

In Excel, if your net income sits in cell B2 and your cost of investment is in B3, the formula is simply =B2/B3. Format the result as a percentage. For example, if a product launch generated $45,000 in net income on a $30,000 investment, your ROI is 150% — meaning you earned $1.50 for every $1 spent.

Capital gain ROI

Capital gain ROI measures the profit from selling an asset relative to what you originally paid for it. It’s most common in stock portfolios and real estate.

Formula: ROI = (Sale Price – Purchase Price) / Purchase Price

In Excel: =(B2-B3)/B3 where B2 is the sale price and B3 is the purchase price. If you purchased a property for $200,000 and sold it for $260,000, your capital gain ROI is 30%.

Total return ROI

Total return is similar to capital gain but includes additional income generated by the investment — dividends, interest payments, or rental income on top of the price change.

Formula: ROI = (Ending Value – Starting Value) / Cost of Investment

In Excel: =(B2-B3)/B4 where B2 is your ending value (including all income received), B3 is your starting value, and B4 is your original cost. Total return gives a fuller picture because it captures every dollar the investment produced, not just the sale price.

Annualized ROI

Here’s where things get more interesting. Standard ROI ignores time, which makes it unreliable for comparing investments held over different periods. A 60% return over 2 years sounds impressive — but is it more impressive than a 40% return over 1 year? Annualized ROI answers that question by normalizing returns to a per-year basis.

Formula: Annualized ROI = (Ending Value / Starting Value) ^ (1 / Number of Years) – 1

In Excel: =(B2/B3)^(1/B4)-1 where B2 is your ending value, B3 is your starting value, and B4 is the number of years. Alternatively, you can use Excel’s built-in RATE function for more complex scenarios involving periodic payments. For the example above: a $10,000 investment that grows to $16,000 over 2 years has a total ROI of 60%, but an annualized ROI of about 26.5%. Compare that to a $10,000 investment returning $14,000 in 1 year — a 40% annualized ROI that significantly outperforms the two-year option on a per-year basis.

How to build an ROI calculator in Excel (5 steps)

Ready to move from theory to practice? Building a reusable ROI calculator in Excel takes about 10 minutes and saves hours of ad-hoc calculations down the road. Follow these 5 steps to create a spreadsheet you can use for any investment — marketing campaigns, capital expenditures, software purchases, or project evaluations. You can also download our free Excel template to get a head start.

Step 1: set up your spreadsheet columns

Open a new Excel workbook and create 4 column headers in row 1: Investment Name (column A), Cost of Investment (column B), Net Return (column C), and ROI (column D). Select the entire range and format it as an Excel Table (Ctrl+T) — this makes it easier to add new rows later without breaking your formulas.

Step 2: enter your investment data

Starting in row 2, enter each investment on its own row. Type the name in column A, the total cost in column B, and the net return (total revenue or ending value) in column C. Use consistent currency formatting across both financial columns: select columns B and C, right-click, choose “Format Cells,” and select Currency with 2 decimal places.

Step 3: write the ROI formula

Click into cell D2 and type the formula: =(C2-B2)/B2. This subtracts your cost from your return, then divides by the cost to give you ROI as a decimal. Select Enter. If you formatted your data as a Table in Step 1, Excel will automatically fill the formula down for every row you add.

Step 4: format the result as a percentage

Select column D, right-click, and choose “Format Cells.” Under the Number tab, select Percentage and set decimal places to 1 or 2 — whatever precision your stakeholders prefer. Your ROI values will now display as readable percentages instead of raw decimals.

Step 5: add conditional formatting for quick analysis

Highlight the ROI column, go to Home > Conditional Formatting, and create two rules. First: format cells greater than 0 with a green fill and dark green text. Second: format cells less than 0 with a red fill and dark red text. Now every positive ROI glows green and every loss stands out in red — making it easy to scan dozens of investments at a glance. You can also add Data Bars or Icon Sets for a more visual comparison across rows.

What ROI does and doesn’t measure

It’s important to note that ROI doesn’t generally considerROI is powerful precisely because it’s simple. But that simplicity comes with trade-offs. Understanding where the formula needs support helps you make more accurate decisions — and know when to bring in additional metrics. Does ROI account for the time value of money (TVM), which is the popular accounting theory that an amount of money you get today will be worth more than receiving the exact same amount at some point in the future? No, and that’s just one of several gaps worth knowing about. ROI treats every dollar the same — no matter when your business has earned it.

Here are the key limitations to consider before relying on ROI as your only measure:

• Does not account for the time value of money: A 50% return over 1 year is far more valuable than a 50% return over 10 years. The basic ROI formula treats both identically. For time-adjusted analysis, use annualized ROI or net present value (NPV).

• Ignores risk: Two investments can show identical ROI numbers while carrying vastly different risk profiles. A government bond and a startup investment might both return 15%, but the probability of achieving that return differs dramatically.

• Can be manipulated by cost allocation: Different teams may define “cost of investment” differently. Include only direct costs, and your ROI looks stellar. Include overhead, labor, and opportunity costs, and the picture changes.

• No standardized definition across organizations: Marketing teams, finance teams, and operations teams often calculate ROI using slightly different inputs — which makes cross-departmental comparisons unreliable without agreed-upon definitions.

• Provides a static snapshot: A single ROI calculation captures one moment in time. It won’t tell you if returns are trending up or down, or if a project that looked profitable last quarter is now underperforming.

What if your ROI calculations could update automatically as new data comes in? That’s exactly the shift from static spreadsheets to live, connected platforms — and we’ll cover how that works shortly.

What is a good ROI percentage?

In Microsoft Office, you can use a built-in Excel calculator to figure out your ROI. All you have to do is complete a spreadsheet with the numbers you’d like to compare“Good” ROI isn’t a fixed number — it depends entirely on context. The formula to calculate your true ROI is pretty simple. You just divide your returns in one cell by your cost in another cellindustry you’re in, the risk you’re taking, the time horizon of the investment, and the opportunity cost of putting that money elsewhere all shape what counts as a worthwhile return. A 10% annual return might be outstanding for a low-risk bond portfolio but underwhelming for a high-growth marketing campaign.

Here are some general benchmarks to use as reference points:

• Stock market: ~7-10% annually after inflation is the long-term historical average for diversified portfolios.

• Real estate: 8-12% annual return is generally considered strong, though it varies by market and property type.

• Marketing campaigns: A 5:1 return ratio (500% ROI) is a common benchmark, meaning $5 earned for every $1 spent.

• Business projects: Any positive ROI may be worthwhile if it exceeds the company’s cost of capital — the minimum return needed to justify the investment.

( Image Source )How do you calculate a 10% ROI? Rearrange the formula: if you need a 10% return on a $50,000 investment, you need $5,000 in net profit. The required return equals (Target ROI% / 100) x Cost of Investment. This works for setting performance targets — you can calculate exactly how much revenue a campaign or project needs to generate to hit your threshold.

When comparing ROI across investments with different holding periods, always annualize the returns first. A 30% total return over 3 years is roughly 9.1% annualized — which you can then compare directly against a 12% annual return on a 1-year investment.

Why use an ROI formula in Excel?Make your Excel ROI calculator dynamic

A basic ROI spreadsheet gets the job done for one-off calculations, but it becomes more powerful when you add interactive features. These enhancements turn a static table into a flexible analysis dashboard — all within Excel.

Here are 4 features that add real analytical depth:

• IF formulas for instant labels: Add a column with =IF(D2>=0.1,”Meets Target”,”Below Target”) to instantly flag which investments hit your ROI threshold. Change the 0.1 to whatever target percentage your team has set.

• Dropdown menus for categorization: Use Data Validation to create a dropdown in a “Category” column (marketing, operations, capital expenditure). This lets you filter and compare ROI by investment type without building separate spreadsheets.

• SUM and AVERAGE for portfolio-level metrics: Add summary rows using =AVERAGE(D2:D20) for your portfolio’s average ROI and =SUM(C2:C20)-SUM(B2:B20) for total net profit across all investments.

• Charts for visual comparison: Select your Investment Name and ROI columns, insert a bar chart, and you’ve got a visual ranking of your strongest and weakest investments. Add a reference line at your target ROI to see which investments clear the bar.

These Excel enhancements help — but they still require manual updates every time your data changes. Every new expense entry, revenue adjustment, or project milestone means opening the spreadsheet, updating cells, and re-checking formulas. For teams tracking ROI across more than a handful of projects, that manual loop becomes the bottleneck.

How monday AI Work Platform replaces manual ROI tracking

Excel works for one-time ROI calculations. Tracking return on investment across multiple projects, departments, or quarters reveals the limits of a static spreadsheet. Version control issues, broken formulas, and the constant need to re-enter data are the real costs of manual tracking. Anyone doing project cost tracking manually knows these friction points don’t show up in any ROI formula.

monday AI Work Platform eliminates those friction points by connecting your financial data to live, auto-updating calculations. Here’s how the platform replaces each piece of the Excel workflow:

•  Formula columns and dashboards: Replace manual Excel formulas with formula columns that auto-calculate ROI, net profit, and return ratios across every row. Portfolio-level dashboards display live metrics for stakeholders — no one needs to request an updated spreadsheet.

• Automations: When project costs or revenue figures change, ROI recalculates instantly. Set up automations to notify your team when an investment drops below a target threshold or when a project hits a milestone that impacts its return.

• monday vibe: Need a custom ROI calculator app? Describe what you want in plain language and monday vibe builds it for you — no coding, no complex spreadsheet macros. You get a tailored financial tracking interface in minutes.

• monday agents: AI agents generate financial reports on schedule, surface at-risk investments so teams can act early, and track metrics progress against goals automatically. Instead of pulling numbers into a quarterly deck, the data is already waiting for you.

• Excel import and integrations: Already have years of ROI data in spreadsheets? Import existing Excel files directly into the platform. Integrations with Salesforce, HubSpot, and other revenue sources mean your data flows in automatically — no copy-paste required.

The results speak for themselves. Customers report an average 8x ROI from using the platform, with $250,000 saved annually to reinvest elsewhere. An independent Forrester Total Economic Impact study found a payback period of less than 4 months. Whether you’re tracking campaign performance with an expense tracking template or monitoring departmental budgets with a budget tracker template, the platform keeps every number current without the manual overhead.

Track every dollar and measure what matters

ROI is one of the most fundamental business metrics out there. Why? Because it’s simple and super straightforward. You don’t have to be a professional financial analyst to work out your team’s ROI on a project, and it’s a decent gauge of an investment’s profitability that you can easily communicate to other stakeholders. More importantly, ROI can tell you a net gain or loss.essential metrics in business — and now you have the formulas, variations, and step-by-step instructions to calculate it confidently in Excel. From basic net profit calculations to annualized returns and dynamic spreadsheet features, you’re equipped to evaluate any investment and present the numbers that drive decisions.

If your ROI is positive, it means your investment was probably worthwhile. If your ROI is negative, it means there’s likely some room for improvement. From there, your team can brainstorm what efficiencies could be made or where costs could be shaved.

That’s why it makes sense to use an ROI formula in Excel. Excel’s calculator doesn’t lie, and the formulas you enter automatically turn your data into ratios or percentages that will better inform your business choices said, Excel has a ceiling. When your team is tracking ROI across dozens of projects, campaigns, and departments, a connected platform keeps everything accurate and accessible in real time. monday AI Work Platform brings your ROI formula, financial data, and stakeholder reporting into one workspace — with live dashboards, automated recalculations, and AI-powered insights that replace the manual spreadsheet cycle entirely.