Total Return Formula

What is the Total Return Formula?

The term “Total Return” refers to the sum of the difference between the opening and closing value of all the assets over a particular period of time and the returns thereon. To put it simply, the changes in opening and closing values of assets plus the number of returns earned thereof is the Total Return of the entity over a period of time.

The total return calculation is generally done to check the percentage total return formula we earn on the investments made during the particular period. Every single penny has its own opportunity costOpportunity CostThe difference between the chosen plan of action and the next best plan is known as the opportunity cost. It's essentially the cost of the next best alternative that has been forgiven.read more, which means that if the money was not invested in one opportunity, then it will earn some other income such as interest incomeInterest IncomeInterest Income is the amount of revenue generated by interest-yielding investments like certificates of deposit, savings accounts, or other investments & it is reported in the Company’s income statement. read more if deposited in every investor wants to maximize the return on their investments by optimally using the available funds.

The Total Return can be calculated using two methods –

  • By taking the difference of closing value and opening value plus returns therefrom.
  • By adding the returns to their respective investments and then taking the difference between the opening and closing values.

In this article, we will focus on the Total Return Formula, which is expressed as the difference between the opening and closing date values plus the number of incomes earned therefrom.

Total Return Formula

Total Return Formula is represented as below:

Total Return Formula = (Closing Value – Opening Value of Investments) + Earnings therefrom

Then by dividing the amount of total return calculated above by the amount of investment made or opening value multiplied by 100 (as the total return is always calculated in percentage), we got the total return earned over a specified period.

Percentage (%) of Total Return formula is represented as below:

% of Total Return = Total Return / Amount Invested * 100
Total-Return-Formula

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Total Return Formula (wallstreetmojo.com)

Explanation of the Total Return Formula

The total return equation can be derived by using the following steps:

  1. Firstly, determine the opening or invested value of total assets, which is the sum of all the investments purchased or the value of the investment at the start of the selected interval.

  2. Then, determine the closing or present value of total assetsTotal AssetsTotal Assets is the sum of a company's current and noncurrent assets. Total assets also equals to the sum of total liabilities and total shareholder funds. Total Assets = Liabilities + Shareholder Equityread more, which is the sum of all the investments purchased or the value of the investment at the end of the selected interval.

  3. Then, take the sum of earnings from such investments or assets during the selected interval.

  4. Finally, the amount of Total Return is expressed as the difference between the total of the opening and closing value of assets plus earnings made therefrom during the selected interval.

    Total Return = (Closing Value – Opening Value) of Investments + Earnings therefrom

  5. Finally, to calculate the percentage total return formula, we have to divide it with the amount invested or opening value thereafter multiplied with 100.

    % of Total Return = Total Return/ Amount Invested * 100

Examples of Total Return Formula

Let’s see some simple to advanced practical examples of the total return equation to understand it better.

You can download this Total Return Formula Excel Template here – Total Return Formula Excel Template

Total Return Formula – Example #1

Suppose Mr. A has invested a sum of $100,000 in the 9% debentures of XYZ Inc. on 01.04.2019, and the value of invested money on the closing date is $150,000. The period of investment is 90 days. During the said period, the company has paid the due interest on their debentures.

Given,

  • Amount invested on date 01.04.2019 = $100,000
  • Value of Investment on closing date = $150,000
  • Period of Investment = 90 days
Total Return Formula Example 1

Calculation of Amount Interest Earned

Total Return Formula Example 1.1

Amount of Interest Earned = Principal Amount * Number of days/365 * Rate of Interest/100

  • =($100,000*90)/365*(9/100)
  • Amount of Interest Earned =$2219

Now, Total Return can be calculated by using the above Formula as,

Example 1.2
  • = ($150,000-$100,000)+$2219

The total return will be –

Example 1.3
  • Total Return = $52219

Calculation of  percentage (%) Total Return 

Example 1.4
  • =$52219/$100000*100%

Percentage (%) Total Return will be – 

Total Return Formula Example 1.5
  • = $52219/100000 * 100
  • = 52.22%

Total Return Formula – Example #2

Suppose Mr. A has invested a sum of $100,000 in the 9% debentures of XYZ Inc. on 01.04.2019, purchased 1000 shares of PQR Ltd @ 500/- per share, and has made a fixed deposit of $250,000 earning interest @ 10% p.a. for a period of 6 months. The value of invested money on maturity date is:

  • The value per share of PQR Ltd is $ 700
  • Value of 9% Debentures is $ 90,000.

Now for calculation of Total Return and % of Total Return, the following steps are to be taken:

Given,

  • Amount invested on date 01.04.2019 = $100,000 + $(1000*500) + $250,000

= $850,000

  • Value of Investment after 6 months = $90,000 + $(1000*700) + $250,000

= $1,040,000

Example 2

Amount of Interest Earned on Fixed Deposits and Debentures

Calculation of the Amount of Interest Earned on Debentures

Total Return Formula Example 2.1

Amount of Interest Earned on Debentures in 6 Months = Principal Amount * Number of months/12 * Rate of Interest/100

  • =100,000 * 6/12 * 9/100
  • =4500

Calculation of the Amount of Interest Earned on Fixed Deposits

Total Return Formula Example 2.2

Amount of Interest Earned on Fixed Deposits in 6 Months = Principal Amount * Number of months/12 * Rate of Interest/100

  • =250,000 * 6/12 * 10/100
  • =12,500

Now, Total Return can be calculated by using the above Formula as,

Total Return Formula Example 2.3

=(1040000.00-850000.00)+17000.00

The total return will be –

Total Return Formula Example 2.4
  • Total Return = 207000.00

Calculation of  percentage (%) Total Return 

Example 2.5
  • =207000.00/850000.00*100%

Percentage (%) Total Return will be – 

Total Return Formula Example 2.6
  • = 24.35%

Relevance and Uses

By timely calculating the total return equation on investments, we could plan the time of redemption of money invested. Sometimes we have liquid funds to be invested for a short span of time then for calculating the total return of the entity in which we are planning to invest the money, the concept of Total Return comes into the picture.

For example, ABC Ltd is a company whose share at present is trading at $50 per share, and three months ago, the shares were trading at $45 per share then; by applying the above concept, we got a value of 44.44% as the total return. It helps us in making the right decision by considering the history of the entity.

Recommended Articles

This has been a guide to the Total Return Formula. Here we provide step by step calculation of total return along with practical examples and a downloadable excel template. You can learn more about accounting and budgeting from the following articles –