WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Rate of Return Formula

Rate of Return Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is the Rate of Return?

The rate of return is the return that an investor expects from his investment and it is basically calculated as a percentage with a numerator of average returns (or profits) on an investment and denominator of the related investment on the same.

Rate of Return Formula

The formula can be derived as below:

Rate of Return = Average Return / Initial Investment

Rate of Return Formula

It is a very dynamic concept for understanding investment returns; hence it can be modified and tweaked a little to calculate returns from various avenues.

  • Average Return: Return measured after inputting all costs during the holding period, including admin charges, the premium paid (if any), other operating expenses, etc. All returns and costs should relate to only the asset in question; else, it may deviate from accurate results.
  • Initial Investment: Investment was initially made to purchase the asset at the 0th period.

Examples

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

Example #1

Anna owns a produce truck, invested $700 in purchasing the truck, some other initial admin related and insurance expenses of $1500 to get the business going, and has now a day to day expense of $500. Let’s consider hypothetically that her everyday profit is $550 (ideally, it will be based on sales). At the end of 6 months, Anna takes up her accounts and calculates her rate of return. 

  • Total Initial Investment: $2,200
  • Everyday Expenses: $500
  • Total Expenses for 6 months: $3,000
  • Everyday Returns: $550
  • Total Returns for 6 months: $3,300

So, we have the following data for the calculation of the Rate of Return:

Rate of Return formula eg 1

Rate of Return =((Total Returns -Total Expenses )/Total Initial Investment )* 100

= ($3,300 – $3,000) /$2,200 X 100

Rate of Return formula eg 1.2png

Hence, the Rate of Return will be :

Rate of Return formula eg 1.3png

Example #2

Joe has invested equally in 2 securities A & B. He wishes to determine which security will promise higher returns after 2 years. Likewise, he wants to decide whether he should hold the other security or liquidate such a position.

Let us first find out returns from each security at the end of 1 year.

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

Return calculated for compounded interest is as below:

Below are the statistics related to his investment:

Security A:

Investment: $10,000

Interest Rate: 5% paid annually, compounded basis

Term to maturity: 10 years

A = PX [1 + R/n]^(nT)

where:

  • A = Amount (or Return) after a particular period of calculation
  • P = Principal
  • R = Rate of Interest
  • n = Interest payment frequency
  • T = Period of calculation

So, the calculation of Rate of Return for Security A(A1) will be as follows –

A = PX [1 + R/n]^(nT)

Therefore, Return after 2 years for Security A (A1) = $10,000 X [(1 + 0.05)^2]

Rate of Return formula eg 2 .1png

So, Return after 2 years for Security A (A1) will be:

eg 2 png

Return after 2 years for Security A(A1)=$11,025.

Security B:

Investment: $10,000

Interest Rate: 5% paid semi-annually, compounded basis

Term to maturity: 10 years

Therefore, calculation of Return after 2 years for Security B (A2) = $10,000 X [(1 + 0.05/2)^4]

eg 2 .2png

So,Return after 2 years for Security B(A2)= $11,038.13

Analysis:

It is determined that although the returns are similar, yet Security B gives a little return. However, it is not required to completely liquidate the other position, as the difference between the two returns is minimal; as such, Joe is not harmed by holding Security A.

Example #3

Joe wants to now calculate returns after the 10th year and wants to assess his investment.

Based on the returns calculated from the compound interest formula, we can calculate for 10 years as below:

So, the Calculation of Rate of Return for Security A(A1) for 10 years will be as follows –

A = PX [1 + R/n]^(nT)

Therefore,Calculation of Return for 10 years for Security A (A1) = $10,000 X [(1+ 0.05)^10]

Examples= 3

So, Return for 10 years for Security A (A1) for 10 years will be:

Rate of Return eg 3.1 png

Return for 10 years for Security A (A1)=  $16,288.95.

Therefore,Return after 10 years for Security B (A2) = $10,000 X  [(1 + 0.05/2)^20]

Rate of Return eg 3.2 png

Return after 10 years for Security B(A2)= $16,386.16

Relevance and Use

  • Every investor is exposed to risk and returns. The returns offered by an avenue may or may not be the actual returns over a period of time on the riskiness of the asset in markets. Hence it is extremely important to understand the actual rate of return for the investment.
  • It helps in capital budgeting decisions. It helps in identifying whether investing in a particular project is beneficial over a period of time and choose between options by comparing and identifying the best venture.
  • It suggests the trends prevalent in the market and sometimes may even suggest futuristic views.
  • A rate of Return is a simple calculation of suggestive investment for particular gains. One can make tweaks in their inputs and try to understand the amount to invest in order to earn particular returns.
  • It is used to compare different investments and understand the background of such investment or benefits of the same.
  • It gives the financial standing of the respective individual or firm as a whole.

Conclusion

The rate of return forms a pivotal terminology for all the analyses related to investments and their returns. It helps in various ways, as we have seen above, however, only when calculated right. Although it seems like a simple formula, it gives results that are required for making some major decisions – be it in finances or other return related decisions. Hence, it is very important to arrive at the accurate calculation, as it forms the basis of entire investments, future planning, and other economic-related decisions.

Recommended Articles

This has been a guide to the Rate of Return and its definition. Here we discuss how to calculate the rate of return using its formula along with practical examples and downloadable excel templates. You may learn more about Financial Analysis from the following articles –

  • Calculate Cash on Cash Return
  • Formula of Annualized Rate of Return
  • Accounting Rate of Return
  • Calculate Rate of Return
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

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
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 Rate of Return Formula Excel Template

Coursera IPO Financial Model & Valuation Free Download