⚡ Get All Content for 20% Off ⚡

How To Calculate ROI (Return On Investment) Learn to calculate ROI in seven steps--increasing your chances of landing an investor and dusting the competition.

entrepreneur daily

The Gotham Gal and I make a fair number of non-tech angel investments. Things like media, food products, restaurants, music, local businesses. In these investments we are usually backing an entrepreneur we've gotten to know who delivers products to the market that we use and love. The Gotham Gal runs this part of our investment portfolio with some involvement by me.

As I look over the business plans and projections that these entrepreneurs share with us, one thing I constantly see is a lack of sophistication in calculating the investor's return.

The entrepreneur needs $400k to start the business, believes he/she can return to the investors $100k per year, and therefore will generate a 25 percent return on investment. That is correct if the business lasts forever and produces $100k for the investors year after year after year.

But many businesses, probably most businesses, have a finite life. A restaurant may have a few good years but then lose its clientele and go out of business. A media product might do well for a decade but then lose its way and fold.

And most businesses are unlikely to produce exactly $100k every year to the investors. Some businesses will grow the profits year after year. Others might see the profits decline as the business matures and heads out of business.

So the proper way to calculate a return is using the "cash flow method."

Here's how you do it.

  1. Get a spreadsheet, excel will do, although increasingly I recommend Google docs spreadsheet because it's simpler to share with others.
  2. Lay out along a single row a number of years. I would suggest ten years to start.
  3. In the first year show the total investment required as a negative number (because the investors are sending their money to you).
  4. In the first through tenth years, show the returns to the investors (after your share). This should be a positive number.
  5. Then add those two rows together to get a "net cash flow" number.
  6. Sum up the totals of all ten years to get total money in, total money back, and net profit.
  7. Then calculate two numbers. The "multiple" is the total money back divided by the total money in. And then using the "IRR" function, calculate an annual return number.

Here's a link to Google docs where I've posted this example. It is public so everyone can play around with it and see how the formulas work.

It's worth looking for a minute at the theoretical example. The investors put in $400k, get $100k back for four years in a row (which gets them their money back), but then the business declines and eventually goes out of business in its seventh year. The annual rate of return or ROI (return on investment) on the $400k turns out to be 14 percent and the total multiple is 1.3x.

That's not a bad outcome for a personal investment in a local business you want to support. It sure beats the returns you'll get on a money market fund. But it is not a 25 percent return and should not be marketed as such.

I hope this helps. You don't need to get a finance MBA to be able to do this kind of thing. It's actually not that hard once you do it a few times.

Fred Wilson is a partner at Union Square Ventures. He writes the influential A VC, where this post was originally published.

Want to be an Entrepreneur Leadership Network contributor? Apply now to join.

Side Hustle

The Remote Side Hustle a 43-Year-Old Musician Works on for 1 Hour a Day Earns Nearly $3,000 a Month: 'All From the Comfort of Home'

Sam Ziegler wanted to supplement his income as a professional drummer — then his tech skills and desire to help people came together.

Business News

Costco CFO Reveals Uncertain Fate of $1.50 Hot Dog and Soda Combo

CFO Richard Galanti reveals that the price will stay the same — but only "for a while."

Business News

The Most Unexpectedly Popular Side Hustle of the Decade Has Low Startup Costs and High Markups

A new report shows that vending machines are a popular investment — and the industry is set to grow up to $3 billion by 2031.

Marketing

Ever Wonder Why Certain Websites Rank Higher Than Yours? This SEO Expert Reveals The Secret to Dominating Search Results

It's often the smart use of SEO, now supercharged with AI, particularly in keyword optimization.

Business News

AI Is Impacting Jobs. Here Are the Gigs Affected the Most, According to an Analysis of 5 Million Upwork Postings

The researcher said in the report that freelance jobs were analyzed first because that market will likely see AI's immediate impact.

Leadership

Former Interrogator Shares 5 Behaviors Liars Exhibit and How to Handle Them

Five deceptive behaviors to look for and how to respond to those behaviors when you encounter them.