Heads Up: The Fed continues to raise rates — up 3% this year — making credit card debt even costlier.
Pay it off today with a low fixed-rate personal loan. View your rate —>

Rate of Return (RoR): Formula and Calculation Examples

By Kenny Zhu · December 14, 2022 · 8 minute read

We’re here to help! First and foremost, SoFi Learn strives to be a beneficial resource to you as you navigate your financial journey. Read more We develop content that covers a variety of financial topics. Sometimes, that content may include information about products, features, or services that SoFi does not provide. We aim to break down complicated concepts, loop you in on the latest trends, and keep you up-to-date on the stuff you can use to help get your money right. Read less

Rate of Return (RoR): Formula and Calculation Examples

What Is Rate of Return?

Rate of return is a measure of an investment’s gain or loss, expressed as a percentage of its initial value, over a given period of time.

If calculated correctly, your rate of return will be expressed as a percentage of your initial investment. Positive rate of return calculations indicate a net gain on your investment, while negative results will indicate a loss.

Don’t confuse this with the expected rate of return, which forecasts your expected returns using probability and historical performance.

When using the rate of return formula, your chosen time period is referred to as your “holding period.” Regardless of whether your holding period lasts days, months, or even years. It’s important that you keep the time periods consistent when comparing investment performance.

How to Calculate Rate of Return

You can calculate the rate of return on your investment by comparing the difference between its current value and its initial value, and then dividing the result by its initial value.

Multiplying the result of that rate of return formula by 100 will net you your rate of return as a percentage. You’ll know whether you made money on your investment depending on whether your result comes in as positive or negative.

We’ll do a detailed run through of how to calculate your rate of return, what you should include in the calculation, and what the resulting value means.

Rate of Return Formula

The standard rate of return formula can be represented as follows:

R = [ ( Ve – Vb ) / Vb ] x 100

Where,

R = Rate of return

Ve = End of period value

Vb = Beginning of period value

The aforementioned formula can be applied to any holding period to find your rate of return “R” over that timespan.

“Ve,” your end of period value, should represent the value of your investment, including any interest or dividends earned over your holding period.

Finally “Vb” should represent the value of your initial investment. It will be used as the relative basis on which your investment returns are calculated.

Example of Calculating Rate of Return

To help you understand how to calculate the rate of return, we’ll walk you through an example. The formula is restated below to help you follow along.

R = [ ( Ve – Vb ) / Vb ] x 100

Let’s say an investor buys an investment for $125 a share which pays no dividends. This $125 investment will be your beginning of period value (“Vb”).

After one year, the value of the investment rises to $150 and the investor chooses to sell it. Given that $150 represents the value of the investment at the end of the holding period, $150 will be your end of period value (“Ve”).

To calculate the rate of return, enter the values for Vb and Ve into the rate of return formula. With the correct values in place, your equation should look like this:

R = [ ( $150 – $125 ) / $125 ] X 100

Solving out this formula using order of operations, your calculations should proceed as follows:

R = [ $25 / $125 ] X 100

R = 0.2 X 100

R = 20%

If done correctly, the formula should calculate a one year rate of return of 20%, based on the beginning and end of period values provided.

Best Investment App of 2022

– Motley Fool

Trade stocks, ETFs, and crypto – or start an IRA.
Get up to $1k when you fund an account today.


**Customer must fund their Active Invest account with at least $10 within 30 days of opening the account.
Probability of customer receiving $1,000 is 0.028%. See full terms and conditions.

How to Calculate Rate of Return Using Excel

Calculating the rate of return in Excel simply requires you to enter the right inputs in a few cells; then tie those cells together using a few simple equations.

Excel is a powerful purpose-built application designed to crunch numbers and is a go-to-standard when making investment calculations.

While you can enter these inputs anywhere you want on the spreadsheet, we’ll walk you through an example to get you started. We’ve also restated the rate of return formula here to help you follow along.

R = [ ( Ve – Vb ) / Vb ] x 100

After opening a blank excel spreadsheet on your desktop, start by entering the beginning and of period investment values using the following inputs in the corresponding cells.

Cell B2: End of period value of investment (“Ve”)

Cell B3: Beginning of period value of investment (“Vb”)

It’s a good idea to enter a description of what each cell represents in the corresponding column “A” cells, to help you remember what each value means.

Now that we have all the necessary inputs for our formula, it’s time to tie them together. We’ve broken this step into several cells for ease of understanding.

Cell B4: Type in “=B2-B3”

This cell calculates the difference in value between your end of period (“Ve”) and beginning of period (“Vb”) investment.

Cell B5: Type in “=B4/B3”

This cell will divide the difference in value (Cell B5), by the beginning of period value (Cell B3), to obtain a decimal measure of your rate of return.

Cell B6: Type in “=B5*100”

Multiplying the decimal metric from cell B5 by 100 will calculate your resulting rate of return as a percentage.

If done correctly, cell B6 should show your rate of return.

Note: For more advanced Excel users, the same result can be obtained by entering: “=(B2-B3)/B3*100” within a single cell. You can try this in any blank cell to double check your work.

Considerations When Using Rate of Return

The main advantages of the rate of return calculation is that it’s simple and easy to calculate. It gives you a straightforward method to measure the profitability of an investment over any time period.

However, its simplicity does result in some shortcomings, particularly when it comes to more complex investments with numerous cash flows. We dive into these limitations below.

💡 Recommended: What Is a Good Rate of Return?

What are the Limitations of Simple Rate of Return?

The main limitations of the simple rate of return calculation are that it ignores the time value of money and timing of cash flows.

The time value of money is an important concept when it comes to finance, as it explains that money today is always worth more than the same sum of money paid in the future. This is due to the inherent earnings potential of cash held now.

In tandem with the concept above, the simple rate of return calculation also fails to account for the timing of cash flows.

Cash flows are particularly important when dealing with more complex portfolios or investments that might have multiple reinvestment periods over time or multiple dividend payouts.

The simple rate of return calculation, in some ways, oversimplifies the rate of return into a simple accounting measure over an arbitrary amount of time. To address these shortcomings, professionals typically use alternate measures like internal rate of rate (IRR) and annualized rate of return.

Annualized Rate of Return

The annualized rate of return is a slightly more complicated formula that solves the compatibility issues of the simple rate of return calculation by standardizing all calculations over an annual period.

Formula

The annualized rate of return formula can be exhibited as follows.

Ra = ( Ve / Vb ) 1 / n – 1 X 100

Where,

Ra = Annualized Rate of Return

Ve = End of period value

Vb = Beginning of period value

n = number of years in holding period

Annualized rate of return (Ra) standardizes your rate of return on an annual basis; this allows you to make fair comparisons with other annualized performance figures.

“Ve,” your end of period value, represents the value of your investment at the end of the holding period, including any interest or dividends earned.

“Vb” represents the value of your initial investment.

Other Types of Return Formulas

There are a multitude of other return metrics that can help you evaluate performance.

While the calculations for these metrics fall outside the scope of this reading, we touch on some of the most commonly used ones and why they’re used.

•   Internal Rate of Return (IRR): This represents the expected annual compound growth rate of a specific investment and is usually used to help determine whether an investment is worthwhile.

•   Return on Invested Capital (ROIC): Measures a firm’s profitability in relation to the total debt and equity invested by stakeholders.

•   Return on Equity (ROE): Measures a firm’s net income in relation to the total value of its shareholder’s equity.

How Investors Can Use Rate of Return

Retail investors, institutional investors, and even corporate decision makers use the rate of return to gauge the performance of their investments over time.

It’s useful when compared against a benchmark index, return expectations, or other investment options to gauge how your investment performed on a relative basis.

When comparing investment returns, it’s important to make sure you’re making fair comparisons to ensure you’re making apples-to-apples comparisons.

For example, the S&P 500 might not serve as a fair benchmark for a portfolio invested 100% in international equities, as these are substantially different investment types.

Benchmark comparisons give meaning to your rate of return and help you evaluate whether you’re outperforming on a relative basis.

The Takeaway

Knowing how to calculate your rate of return gives you a useful tool for evaluating your investments’ performance. The best part about the rate of return calculation is that it can be done over almost any timespan, provided the returns you’re trying to compare have the same holding period.

It’s easy to calculate rate of return by hand, or by using an online spreadsheet. The same is true for annualized rate of return — which helps to standardize return rates over longer periods. Those are fairly simple ways to gauge investment returns, but there are a number of other metrics that help you assess and compare investment returns, so be sure to use the tool that aligns best with what you need to know.

If you want to start investing or are looking for ways to improve on your investments, SoFi’s online investing app is a great way for you to start building up your portfolio. SoFi’s award-winning app is secure, convenient, and easy to use.

SoFi invest gives you access to a wide array of stocks, ETFs, and even cryptocurrencies. You can even gain access to IPO shares, and automated investing strategies, all at a competitive cost, all from the convenience of your phone or laptop.

For a limited time, opening and funding an account gives you the opportunity to win up to $1,000 in the stock of your choice.


Photo credit: iStock/AleksandarNakic

SoFi Invest®
The information provided is not meant to provide investment or financial advice. Also, past performance is no guarantee of future results.
Investment decisions should be based on an individual’s specific financial needs, goals, and risk profile. SoFi can’t guarantee future financial performance. Advisory services offered through SoFi Wealth, LLC. SoFi Securities, LLC, member FINRA / SIPC . SoFi Invest refers to the three investment and trading platforms operated by Social Finance, Inc. and its affiliates (described below). Individual customer accounts may be subject to the terms applicable to one or more of the platforms below.
1) Automated Investing—The Automated Investing platform is owned by SoFi Wealth LLC, an SEC registered investment advisor (“Sofi Wealth“). Brokerage services are provided to SoFi Wealth LLC by SoFi Securities LLC, an affiliated SEC registered broker dealer and member FINRA/SIPC, (“Sofi Securities).
2) Active Investing—The Active Investing platform is owned by SoFi Securities LLC. Clearing and custody of all securities are provided by APEX Clearing Corporation.
3) Cryptocurrency is offered by SoFi Digital Assets, LLC, a FinCEN registered Money Service Business.
For additional disclosures related to the SoFi Invest platforms described above, including state licensure of Sofi Digital Assets, LLC, please visit www.sofi.com/legal. Neither the Investment Advisor Representatives of SoFi Wealth, nor the Registered Representatives of SoFi Securities are compensated for the sale of any product or service sold through any SoFi Invest platform. Information related to lending products contained herein should not be construed as an offer or prequalification for any loan product offered by SoFi Bank, N.A.
Financial Tips & Strategies: The tips provided on this website are of a general nature and do not take into account your specific objectives, financial situation, and needs. You should always consider their appropriateness given your own circumstances.
Claw Promotion: Customer must fund their Active Invest account with at least $10 within 30 days of opening the account. Probability of customer receiving $1,000 is 0.028%. See full terms and conditions.
SOIN0722054

All your finances.
All in one app.

SoFi QR code, Download now, scan this with your phone’s camera

All your finances.
All in one app.

App Store rating

SoFi iOS App, Download on the App Store
SoFi Android App, Get it on Google Play

TLS 1.2 Encrypted
Equal Housing Lender