Invest €500+ & Win Big! Guaranteed Bonuses
+ A Massive Raffle →
Back to Blog

How to Calculate Investment Returns: IRR, ROI, ROE, and ROIC

To most people, understanding investing acronyms, such as ROE or IRR, feels reminiscent of deciphering hieroglyphics while drunk on wine, and it's easy to get lost in the alphabet soup. 

Don’t kid yourself though – financial acronyms like ROIC and IRR are more than just cold equations. Rather, these are often stories of risk and triumph made possible by converting Excel sheets into cold, bristling cash.

Get ready to kick back with your favorite blend, and let's unravel these enigmatic acronyms.

In This Article

ROI (Return on Investment): the Universal Yardstick

An illustration of a man writing the ROI formula on a whiteboard while standing on a rising bar chart.
Investopedia

Return on investment is a cut-and-dry roadmap to financial gains. It provides a sure-fire response to how much you’ll get back after spending X money. Suppose you decide to start up a shoe company, and to get your business off the ground, you had to give up $10,000 in total. Now imagine that you generate $13,500 in doing so. Subtract your up-front investment from what you made overall and then divide it by your investment. Finally, multiply by a hundred. There you have it – 35%.

When it comes in handy

Suppose you’re thinking about launching a variety of different businesses and can’t decide which to pull the trigger on. One may generate a lot of money, such as an online casino, but you have to picture the licensing fees, the software, and the many other burdens that go along with it. Suppose you want to branch off and add an adjacent product or go house flipping. ROI can help tell you if it’s worth it.

It has major draws, no doubt. It's simple, self-explanatory, as well as being universally applicable.  It demands no Pythagoras-level math abilities. Be that as it may, there’s an important detail being left out. Making a 20% return over just a year and making the same thing after 5 years is night and day. Another thing it ignores is your risk and timing.

As far as achieving a big ROI is concerned, P2P crowdlending is among the heights of money-making gambits. People no longer have to go in person to stuffy banks and wait for credit applications to process that their business may not have a shot in the world of getting. 

Instead, P2P credit scoring innovation has allowed people’s ability to pay to be thoroughly vetted by much more relevant factors. A lot of innovative projects nowadays are backing up digital loans coming from numerous investor sources with collateral, such as Maclear’s 8lends.

IRR

The formula for calculating the Internal Rate of Return (IRR).

One question business owners often ponder is at how much money they’re going to earn back and how quickly, seeing as we’re all aware that time is money. Internal rate of return tells you at what annual percentage rate the present value of every future cash flow would exactly equal the amount we put in. That percentage is known as the discount rate that zeroes out the net present value. It’s basically a financial GPS, if you will. It gives you a heads up of how fast you’re going to need to floor it to get to your goal while avoiding cratering in the potholes on the way..  

While solving the IRR is most practical to accomplish with tools like Google Sheets, one can simplify the math like so:

IRR\approx\frac{Annual Cash Inflow}{Initial Investment} + g

In this formula:   

  • The annual cash inflow = yearly return on investment median.
  • The out-the-gate investment = overall investment cost.
  • G = estimated adjustment of growth from reinvesting revenues.

Let's also use an example of how you’d arrive at it:

Example

Let’s say you sink 50 grand into a project with the following cash flows:  

  • Year 0: -$50,000 (initial investment)  
  • Year 1: +$10,000  
  • Year 2: +$15,000  
  • Year 3: +$20,000  
  • Year 4: +$60,000  

To calculate IRR in Microsoft Excel:  

  1. Enter the following cash flows in a column (A1 to A5):  
  •    -50000  
  •    10000  
  •    15000  
  •    20000  
  •    60000

IRR ≈ 15% (using Excel's `=IRR()` function).

A 15% IRR means your project produces a yearly revenue equivalent to 15%, considering the timing of all cash put in and outflows. 

Applications

Instances where IRR may apply are, say when you’re evaluating investments with uneven cash flows (e.g., private equity or real estate) or in comparing projects that span different durations.  

Let’s say you’re looking at pursuing some revenue for subscribing to your website visitor tracking service. Here you would compare your up-front development cost to how much you’d make off your customers paying you for using your service for years. As they say, money today is worth two tomorrow. You want to know how quickly that money is going to be in your hand. Though no doubt handy, it doesn’t take into consideration that investments come at different rates. Mint recently covered how to assess your insurance company this way.

ROE

The formula for calculating Return on Equity (ROE).

This one is particularly relevant to shareholders. Return on equity is all about providing to them whether the people running a corporation are making good on the hopes they enticed investors with. First, you have the sum equity capital of the stock participants began with at the start of the year and then you measure where it ended up. These are added up and divided by two for the denominator. 

When it comes in handy

The bottom line of any corporation is to churn out revenue on an accelerated scale. That revenue minus the expenditures is calculated and that is divided by the shareholders' equity. As a result, you end up with a score for the company's leadership, and whether or not they might need a change. Some fields are supposed to churn out bigger profit margins. Take AI for example. Then there are others, which tend to be slower and don’t have the same expectations, like sugar manufacturing. The Globe and Mail recently broke down the top stocks to invest in under this metric.

Unfortunately, it can be manipulated by cooking the books, and a high REO is frequently short-lived. On top of that, there are more relevant figures than just net income.

ROIC

An illustration of the formula for Return on Invested Capital (ROIC).

Return on invested capital goes even further by converting all long-term capital – both equity and interest-bearing debt – into operating profit. You have to account for taxes too, and the objective is to count every single cent you sunk into the project and then come up with your post-tax operating income. The latter is divided by the former to tell you the all-important, resulting figure.

Example ROIC: ($2,000,000 net operating profit after tax (NOPAT)/ $10,000,000 in invested capital) × 100 = 20% 

Scenarios

It’s just what you want for evaluating a business that demands eating up lots of capital, such as manufacturing or telecom, or identifying firms that create value beyond just what their capital costs.  There are lots of variable adjustments for NOPAT and capital though. Digital outfits find less utility in it. 

On an interesting note, Apple's in 2023 was about 35%. Translation: They print money better than the Fed. 

The Toolkit: How to Crunch These Numbers without Losing Your Soul 

Google Sheets and Yahoo Finance are free gambits guaranteed to make calculating ROI, IRR, ROE, along with ROIC seamless: 

A Yahoo Finance stock chart showing a "Continuation Wedge (Bullish)" technical pattern for SMART Global Holdings (SGH).

Below are paid tools one can also use to calculate success figures:  

  • QuickBooks: Track ROI on side hustles (e.g., your Etsy sticker empire).  
  • Carta: For private equity nerds who dream of IRR.  

Tip: Always double-check NOPAT because companies tend to hide "funny money" in footnotes like toddlers hiding broccoli.  

Conclusion 

Investment indicators are not facts; they are tools. As an investor, you shouldn't rely on a single formula, just as a carpenter doesn't use a hammer for every task. 

When pitching to astute investors, use ROIC and IRR.  Remember – ROIC and ROE distinguish the cream of the crop in stocks. ROI, meanwhile, changes the game for real estate transactions or crowdsourcing easier. Numbers are the metaphorical notes played by you – the composer.  Let these formulas guide you, not rule you.

If you're interested in gaining a major way to optimize your figures, consider the 8lends crowdfunding project, which requires minimal risk with major upside for profit.

If you’re interested in upping your investment returns, consider signing up for 8lends today.

FAQ

What is the best metric for investing in stocks?

ROE and ROIC are the answers. While ROIC indicates if the company is outperforming its cost of capital, ROE demonstrates how well management spends shareholder funds.

Why is IRR a source of obsession for venture capitalists?

Venture capitalists obsess over IRR because startups have very erratic cash flow, with large upfront losses and clumpy exits. IRR effectively reflects the time-sensitive "moonshot" nature of these wagers. A five-year IRR of 30% equals a 3.7x return.

Is it possible for ROI to exceed 100%?

Definitely! But keep in mind that ROI disregards time. A ten-year return of 200% is around 11.6% annually.

Why may a high ROE occasionally be harmful?

Debt can inflate ROE. Consider the example of a company that makes $500K in net income with $1M in equity and $9M in debt. The debt-to-equity ratio is 9:1, which is dangerous, even while ROE is 50%!

What is the most common error made by novices while using ROIC?

The most common ROIC error is using book value for invested capital. Always account for items not on the balance sheet, such as pensions and leases.

Share Article