• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer

Optimized Portfolio

Investing and Personal Finance

  • Beginners Start Here
  • Investing 101
    • Beginners Start Here – 10 Steps To Start Building Wealth
    • What Is the Stock Market? How It Works & How to Invest in It
    • How To Invest in an Index Fund – The Best Index Funds
    • Portfolio Asset Allocation by Age
    • How To Invest Your Emergency Fund
    • Portfolio Diversification – How To Diversify Your Portfolio
    • Dollar Cost Averaging vs. Lump Sum Investing (DCA vs. LSI)
    • How To Invest Your HSA (Health Savings Account)
    • Factor Investing and Factor ETFs – The Ultimate Guide
    • more…
  • Lazy Portfolios
    • All Weather Portfolio
    • Bogleheads 3 Fund Portfolio
    • HEDGEFUNDIE’s Excellent Adventure
    • Warren Buffett Portfolio
    • Golden Butterfly Portfolio
    • Paul Merriman Ultimate Buy and Hold Portfolio
    • Ben Felix Model Portfolio
    • Permanent Portfolio
    • David Swensen Portfolio
    • 60/40 Portfolio
    • more…
  • Funds
    • VOO vs. VTI – Vanguard S&P 500 or Total Stock Market ETF?
    • The 7 Best International ETFs
    • The 8 Best Small Cap ETFs (4 From Vanguard)
    • The 5 Best REIT ETFs
    • The 5 Best EV ETFs – Electric Vehicles ETFs
    • VIG vs. VYM – Comparing Vanguard’s 2 Popular Dividend ETF’s
    • The Best Vanguard Dividend Funds – 4 Popular ETFs
    • The 5 Best Tech ETFs
    • The 7 Best Small Cap Value ETFs
    • The 6 Best ETFs for Taxable Accounts
    • The 5 Best Emerging Markets ETFs (1 From Vanguard) for 2023
    • more…
  • Leverage
    • What Is a Leveraged ETF and How Do They Work?
    • How To Beat the Market Using Leverage and Index Investing
    • The 9 Best Leveraged ETFs
    • Hedgefundie’s Excellent Adventure
    • Leveraged All Weather Portfolio
    • Leveraged Permanent Portfolio
    • Leveraged Golden Butterfly Portfolio
    • NTSX – Review and Summary
    • TQQQ – Is It A Good Investment?
    • PSLDX – A Review
    • SWAN – A Review
    • RPAR Risk Parity ETF Review
    • more…
  • Dividends
    • The Best M1 Finance Dividend Pie
    • The 11 Best Dividend ETFs
    • The Best Vanguard Dividend Funds – 4 Popular ETFs
    • VIG vs. VYM – Comparing Vanguard’s 2 Popular Dividend ETF’s
    • 8 Reasons Why I’m Not a Dividend Income Investor
    • QYLD – A Harsh Review
    • more…
  • Broker Reviews
    • The 5 Best Stock Brokers
    • The 4 Best Investing Apps
    • M1 Finance Review
    • Brokers with the Lowest Margin Rates
    • M1 Finance vs. Fidelity
    • M1 Finance vs. Vanguard
    • Webull vs. Robinhood
    • Stash vs. Robinhood
    • M1 Borrow Review (How M1’s Margin Loan Works)
    • more…
  • Retirement
    • The 10 Best ETFs for Retirement Portfolios in 2023
    • The 4% Rule for Retirement Withdrawal Rate – A Revisitation
    • Sequence of Return Risk in Retirement Explained
    • Traditional IRA Explained
    • Roth IRA Explained
    • 401k vs. Roth IRA
    • Roth IRA vs. Traditional IRA
    • Backdoor Roth IRA Explained
    • more…

How To Calculate Investment Returns (ROI and CAGR)

Last Updated: March 22, 2022 No Comments – 3 min. read

Here’s how to calculate investment returns (known as return on investment, or ROI for short) to see your portfolio’s performance.

Disclosure:  Some of the links on this page are referral links. At no additional cost to you, if you choose to make a purchase or sign up for a service after clicking through those links, I may receive a small commission. This allows me to continue producing high-quality, ad-free content on this site and pays for the occasional cup of coffee. I have first-hand experience with every product or service I recommend, and I recommend them because I genuinely believe they are useful, not because of the commission I get if you decide to purchase through my links. Read more here.

Contents

  • Introduction – Return on Investment
  • How To Calculate Return on Investment – Formulas
  • How To Calculate Annualized Return aka Compound Annual Growth Rate (CAGR)
  • How To Calculate CAGR in Excel and Google Sheets
  • CAGR vs. Average Annual Return
  • Shortcomings of the Return on Investment (ROI) Metric

Introduction – Return on Investment

Return on Investment (ROI) measures the gain or loss of an investment, as a percentage, relative to its cost. ROI is used in business to evaluate revenue performance, such as the return from marketing efforts. In the context of investing, we’re talking about the investment returns of an asset or, more likely, of the portfolio as a whole.

The metric has a few shortcomings and a corollary that we’ll explore further down.

How To Calculate Return on Investment – Formulas

The calculation for return on investment is very simple. It’s just the ratio of the change in value to the original value. If we use CV to mean the current value of the investment and OV to mean the investment’s original value, we can calculate the investment return, expressed as a percentage, using the following formula:

(CV ➖ OV) ➗ OV ✖️ 100 = ROI

We can simplify this somewhat to:

CV ➗ OV ➖ 1 ✖️ 100 = ROI

To calculate your return for a single year, for example, use the portfolio value on January 1 as OV and the value on December 31 as CV.

Here’s an example. Let’s assume you bought 100 shares of ABC at $10/share for a total cost basis of $1,000. The share price of ABC has since increased to $12.50 per share for a total value of $1,250 for your 100 shares. We can calculate the investment return like this:

$1,250 ➗ $1,000 ➖ 1 ✖️ 100 = 25%

So your ROI was 25%. This is usually simply called the “return.” If this number is positive, you gained money. If it’s negative, you lost money.

How To Calculate Annualized Return aka Compound Annual Growth Rate (CAGR)

There’s a glaring problem with ROI. ROI doesn’t factor in the time period that the investment is held. Investors are likely more interested in annualized return, a measurement of the annual rate of return required for the investment to grow to its final value over a number of years. This is also called the compound annual growth rate, or CAGR for short. Here’s the formula for CAGR using our variables above:

CAGR = (CV ➗ OV)1/n ➖ 1

where n is the number of years the investment is held. Suppose in our example above that you held ABC for 2 years:

CAGR = ($1,250 ➗ $1,000)1/2 ➖ 1 = 11.8%

If you’ve already calculated your ROI, you can also just use that in the calculation for annualized return:

CAGR = [(1 + ROI)1/n ➖ 1] ✖️ 100

[(1 + .25)1/2 ➖ 1] ✖️ 100 = 11.8%

Unlike pure ROI, CAGR does allow us to compare different investments, because it factors in the amount of time the investment is held.

How To Calculate CAGR in Excel and Google Sheets

There’s no direct CAGR function in Excel or Google Sheets, but we can use the RRI function as follows to measure CAGR:

RRI(number_of_periods, present_value, future_value)

The arguments are:

number_of_periods: number of years the investment is held.
present_value: the initial value of the investment.
future_value: the final value of the investment.

Using our example from earlier would look like this:

RRI(2,1000,1250)

CAGR vs. Average Annual Return

While the wording may be confusing, note that CAGR should always be preferred over average annual return, which is simply the mean value of returns over a certain time period. Brokers and advisors like to use the latter because it usually looks more impressive. In short, the average return is not the actual return. An example will make this distinction more clear.

Suppose an investment of $5,000 grows by 100% in the first year to $10,000 and then drops by 50% the next year back down to $5,000. Over the 2 years, your CAGR was zero; you have neither gained nor lost money. But your average annual return was 25%. Obviously this is very misleading.

So always ask your advisor what your CAGR was; tell them you’re not interested in your average annual return.

Shortcomings of the Return on Investment (ROI) Metric

ROI has a few shortcomings as a standalone metric.

First, as we saw, it doesn’t take into account the amount of time the investment is held. Comparing an Investment A with a 10% return to Investment B with a 20% return isn’t an apples-to-apples comparison, as Investment A may have yielded that return in one year while Investment B took 10 years. We can solve this using annualized ROI aka CAGR.

Secondly, neither ROI nor CAGR per se tells us anything about the risk of the investment(s). In the example above in which Investment A returned 10% and Investment B returned 20%, Investment B may have been much riskier and could have been outside the risk tolerance of the investor.


Interested in more Lazy Portfolios? See the full list here.

Disclaimer:  While I love diving into investing-related data and playing around with backtests, I am in no way a certified expert. I have no formal financial education. I am not a financial advisor, portfolio manager, or accountant. This is not financial advice, investing advice, or tax advice. The information on this website is for informational and recreational purposes only. Investment products discussed (ETFs, mutual funds, etc.) are for illustrative purposes only. It is not a recommendation to buy, sell, or otherwise transact in any of the products mentioned. Do your own due diligence. Past performance does not guarantee future returns. Read my lengthier disclaimer here.

m1 finance get started


Don't want to do all this investing stuff yourself or feel overwhelmed? Check out my flat-fee-only fiduciary friends over at Advisor.com.

77 percent of millenials report their finances are a source of anxiety

Related Posts

  • Fidelity ZERO Funds Review – What’s the Catch?
  • JPST vs. NEAR vs. MINT – Which Active Short Maturity Income ETF?
  • M1 Finance vs. TD Ameritrade Brokerage Comparison (2023)
  • The 4 Best Fintech ETFs for 2023 (Financial Technology)
  • AOK ETF Review – iShares Core Conservative Allocation ETF

About John Williamson

Analytical and entrepreneurial-minded data nerd, usability enthusiast, Boglehead, and Oxford comma advocate. I lead the Paid Search marketing efforts at Gild Group. I'm not a big fan of social media, but you can find me on LinkedIn and Reddit.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Sign up to receive email updates when a new post is published.

Don't worry, I hate spam too. No ads.

  • Facebook
  • Instagram
  • Reddit
  • Twitter
  • YouTube
  • Patreon

Most Popular

Ray Dalio All Weather Portfolio Review, ETFs, & Leverage (2023)

HEDGEFUNDIE’s Excellent Adventure (UPRO/TMF) – A Summary

Golden Butterfly Portfolio Review and M1 Finance ETF Pie

David Swensen Portfolio (Yale Model) Review and ETFs To Use

Harry Browne Permanent Portfolio Review, ETFs, & Leverage (2023)

Corporate Bonds vs. Government Bonds (Treasuries) – The Showdown

VIG vs. VYM – Vanguard’s 2 Popular Dividend ETFs (Review)

Warren Buffett ETF Portfolio (90/10) Review and ETFs (2023)

The 60/40 Portfolio Review and ETF Pie for M1 Finance

Bogleheads 3 Fund Portfolio Review and Vanguard ETFs (2023)

m1 sidebar

visor sidebar

Paul Merriman Ultimate Buy and Hold Portfolio Review, M1 Pie (2023)

Lowest Margin Rates Brokers (2023 Comparison)

M1 Finance vs. Vanguard Brokerage Comparison [2023 Review]

M1 Finance vs. Fidelity Brokerage Comparison [2023 Review]

The Best M1 Finance Dividend Pie for FIRE & Income Investors

Portfolio Asset Allocation by Age – Beginners To Retirees

The 5 Best Stock Brokers Online for Investing (2023 Review)

The 4 Best Investing Apps for Beginners (2023 Review)

The 7 Best Small Cap ETFs (3 From Vanguard) for 2023

The 6 Best REIT ETFs To Invest in Real Estate for 2023

The 6 Best Tech ETFs To Buy Tech Stocks in 2023

9 Best Clean Energy ETFs To Go Green in Your Portfolio (2023)

The 13 Best Small Cap Value ETFs (3 From Vanguard) for 2023

Why, How, & Where To Invest Your Emergency Fund To Beat Inflation

VOO vs. VTI – Vanguard’s S&P 500 and Total Stock Market ETFs

9 Best International ETFs To Buy (6 From Vanguard) in 2023

Ben Felix Model Portfolio (Rational Reminder, PWL) ETFs & Review

Factor Investing and Factor ETFs – The Ultimate Guide

Gone Fishin’ Portfolio Review (Alexander Green) & ETFs (2023)

TQQQ – Is It A Good Investment for a Long Term Hold Strategy?

Recent Posts

Roth IRA vs. Traditional IRA – Which Is Better for You? (2023)

VXUS vs. IXUS – Vanguard or iShares International ETF?

Tail Risk – What It Is and How To Hedge Against It

I Bonds Explained (US Savings Bonds) – Ultimate Guide (2023)

JEPI ETF Review – JPMorgan Equity Premium Income ETF

Sharpe Ratio vs. Sortino vs. Calmar – Risk Adjusted Return

Investing Risk Explained (My Take on Portfolio Risk & Volatility)

HNDL ETF Review – Is HNDL a Good Investment? (7HANDL™ ETF)

NUSI ETF Review – Is NUSI a Good Investment?

3 Best SPAC ETFs To Invest in SPACs in 2023 – But Should You?

VOO vs. VOOV vs. VOOG – Vanguard S&P 500, Value, or Growth?

VXUS vs. VEU – Which Vanguard Total International ETF?

VT vs. VTI – Global Stock Market vs. Total U.S. Stock Market

RPAR Risk Parity ETF Review – An All Weather Portfolio ETF?

PSLDX – A Review of the PIMCO StocksPLUS® Long Duration Fund

View All...

Footer

  • Facebook
  • Instagram
  • Reddit
  • Twitter
  • YouTube
  • Patreon

Amazon Affiliate Disclosure

OptimizedPortfolio.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Email Newsletter

Sign up to receive email updates when a new post is published.

Don't worry, I hate spam too. No ads.

About - My Toolbox - Privacy - Terms - Contact


Copyright © 2023 OptimizedPortfolio.com

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Ok, Got ItReject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT