WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Average Rate of Return

Average Rate of Return

What is the Average Rate of Return?

Average Rate of Return (ARR) refers to the percentage rate of return expected on investment or asset is the initial investment cost or average investment over the life of the project. The formula for an average rate of return is derived by dividing the average annual net earnings after taxes or return on the investment by the original investment or the average investment during the life of the project and then expressed in terms of percentage.

Average Rate of Return Formula

Mathematically, it is represented as,

Average Rate of Return formula = Average Annual Net Earnings After Taxes / Initial investment * 100%

or

Average Rate of Return formula = Average annual net earnings after taxes / Average investment over the life of the project * 100%

Average Rate of Return Formula

Explanation

The formula for the calculation of the average return can be obtained by using the following steps:

Step 1: Firstly, determine the earnings from an investment, say stock, options, etc., for a significant time, say five years. Now, calculate the average annual return by dividing the summation of the earnings by the no. of years considered.

Step 2: Next, in case of a one-time investment, determine the initial investment in the asset. In the case of regular investments, the average investment over life is captured.

Step 3: Finally, the calculation of the average return is done by dividing the average annual return (step 1) by initial investment in the asset (step 2). It can also be derived by dividing the average annual return by average investment in the asset and then expressed in terms of percentage, as shown above.

Examples

Let’s see some simple to advanced examples for calculating the Average Return Formula to understand it better.

You can download this Average Rate of Return Formula Excel Template here – Average Rate of Return Formula Excel Template

Example #1

Let us take the example of real estate investment that is likely to generate returns of $25,000 in Year 1, $30,000 in Year 2, and $35,000 in Year 3. The initial investment is $350,000, with a salvage value of $50,000 and estimated life of 3 years. Do the Calculation the Avg rate of return of the investment based on the given information.

Average Rate of Return Formula example 1.1

Average annual earnings of the real estate investment can be calculated as,

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Average Rate of Return Formula example 1.2

Average annual return = Sum of earnings in Year 1, Year 2 and Year 3 / Estimated life

= ($25,000 + $30,000 + $35,000) / 3

= $30,000

Therefore, the calculation of the average rate of return of the real estate investment will be as follows,

Average Rate of Return Formula example 1.3

  • Average return = = $30,000 / ($350,000 – $50,000) * 100%

Average Rate of Return Formula example 1.4

  • Average return= 10.00%

Therefore, the ARR of the real estate investment is 10.00%.

Example #2

Let us take an example of an investor who is considering two securities of a comparable risk level to include one of them in his portfolio. Determine which security should be selected based on the following information:

arr formula example 2.1

Average annual earnings for security A can be calculated as,

arr formula example 2.2

Average annual earnings A = Sum of earnings in Year 1, Year 2 and Year 3 / Estimated life

                                                  = ($5,000 + $10,000 + $12,000) / 3

                                                 = $9,000

The calculation of ARR of Stock A can be done as follows,

arr formula example 2.3

  • Avg return A = $9,000 / $50,000 * 100%

ARR for Stock A

arr formula example 2.4

  • Average return = 18.00%

Average annual earnings for security B can be calculated as,

arr formula example 2.5

Average annual earnings B = ($7,000 + $12,000 + $14,000) / 3

                                                 = $11,000

The calculation of the average rate of return for Stock B can be done as follows,

arr formula example 2.6

  • Average return B = $11,000 / $65,000 * 100%

Average Return for Stock B will be –

arr formula example 2.7

  • Average return for security B = 16.92%

Based on the given information, Security A should be preferred for the portfolio because of its higher average return than Security B.

Calculator

You can use the following Calculator.

Average Annual Net Earnings After Taxes
Initial Investment
Average Rate of Return Formula =
 

Average Rate of Return Formula ==
Average Annual Net Earnings After Taxes
X100
Initial Investment
0
X100= 0
0

Relevance and Use

It is important to understand the concept of the average rate of return as it is used by investors to make decisions based on the likely amount of return expected from an investment. Based on this, an investor can decide whether to enter into an investment or not. Further, investors use this return for ranking the assets and eventually make the investment as per the ranking and include them in the portfolio.

In projects, an investor uses the metric to check whether or not the average rate of return is higher than the required rate of return, which is a positive signal for the investment. Again, for mutually exclusive projects, an investor accepts the one with the highest return. In short, the higher the return, the better is the asset.

Recommended Articles

This has been a guide to what is the Average Rate of Return. Here we discuss how to calculate the Average Rate of Return and its formula and practical examples and a downloadable excel template. You can learn more about Accounting from the following articles –

  • Nominal Rate of Return
  • Calculate Rate of Return
  • Alpha Formula
  • Expected Return Formula
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Average Rate of Return Formula Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More