EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Total Expense Ratio Formula
Secondary Sidebar
Finance Blog
  • Accounting Fundamentals Resources (720+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Resources (374+)
  • Credit Research Fundamentals (6+)
  • Economics (104+)
  • Finance Formula (384+)
  • Financial Modeling in Excel (16+)
  • Investment Banking Resources (142+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • valuation basics (26+)
  • Insurance Resources (15+)
  • Top Finance Books (33+)
Finance Blog Courses
  • Investment Banking Course
  • Investment Banking Online Course
  • Financial Modeling Certification

Total Expense Ratio Formula

By Madhuri ThakurMadhuri Thakur

Total Expense Ratio (TER) Formula

Total Expense Ratio Formula (Table of Contents)

  • Formula
  • Example
  • Calculator

What is the Total Expense Ratio Formula?

Total expense ratio is extensively used in the Mutual Fund industry which correlates between total costs of a Mutual Fund organization required for its operations in respect with the Total Fund managed by the organization. In other words, expenses related to Research, Distribution, Commissions and administrative expenses which are directly operational in nature are taken into consideration. The general psychology which drives this particular ratio is that the higher the ratio, the lower the return. The rising operating cost for any kind of business is considered as lower efficiency by that particular business.

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

Formula For TER is represented as:

Total Expense Ratio (TER) = Total Fund Costs / Total Fund Assets

Where, costs of funds include all management fees, trading expenses, research fees, and legal fees along with auditor’s fees and marketing and distribution expenses, etc.

Examples of Total Expense Ratio Formula (With Excel Template)

Let’s take an example to understand the calculation of the Total Expense Ratio in a better manner.

You can download this Total Expense Ratio Formula Excel Template here – Total Expense Ratio Formula Excel Template

Suppose Firm A is managing INR 4 Crore AUM and it has an annual expense of INR 2 lacs and the fund has given a return of INR 12.5 Crore (12.5%) annually. Calculate the Total Expense Ratio.

Total Expense Ratio Example 1-1

Total Expense Ratio (TER) is calculated using the formula given below

Total Expense Ratio (TER) = Total Fund Costs / Total Fund Assets

Total Expense Ratio Example 1-2

  • Total Expense Ratio (TER) = INR 2,00,000 / INR 4,00,00,000
  • Total Expense Ratio (TER) = 1%

Suppose firm X has AUM of INR 300 crore and has a return on investment of -10% and the expense ratio is 0.5%. Thus we observe that the expense ratio is lower in percentage terms compared to the first example. So one might have an opinion that firm X is a better choice for investment in compared to firm A. But in practice, we have noticed that firm X has given a 10% negative return that is INR 30 crore losses on the capital of INR 300 crore. So, if the total expense of the fund is added back then the total loss comes to INR 3.5 crore which is a loss of 10.5% on an investment of INR 300 Crore for the clients.

Thus in the above two examples, the first one seems to be the right option for an investor considering that in both cases the investor has the same appetite for risk.

Explanation of TER Formula

  • Total Funds is the overall Asset managed by the company on behalf of its clients. AUM is the summation of total assets invested by their clients in Mutual Funds or Fund managing.
  • Total costs as a percentage of the total invested amount are calculated by each and every Fund house as it helps to determine the operational efficiency of that particular firm or an organization with respect to its peers. Thus, the fund house with the lower operational expense and higher return would be in focus for the Investors depending upon the investor’s risk appetite.
  • In most cases, the total costs are being deducted from the profit generated from that fund. Thus, the Net Profit = Total Return from the Fund – Total Expense (direct and indirect).
  • Certain operational and indirect expenses which are charged twice are not included depending on the type of Assets class the Investment firm or mutual fund house is catering to. Expenses such as stockbroker fees, securities transfer taxes, advisory fees, etc might be incurred more than one time.

Relevance and Use of TER Formula

  • Total return and total expense are calculated on the AUM individually and the Net returned is derived after deducting the TER from Total Return.
  • In the case of the big players within the mutual fund industry, one can segregate between an average performer and an excellent performance by means of the total expense ratio. This is one of the controls that I had written on capital that would suggest a lower expense ratio after a stipulated time period. So if a point is not performing well the return will be comparatively less and the ratio would be higher in comparison with the fund having a higher return.
  • TER also helps a mutual fund to determine its weakness in terms of cost control. In many cases, a mutual fund manager might have expertise in the fundamentals of the companies in which the pool funds have been invested. But there may be a contradiction regarding the earning performance of the companies and their price movements. Show the management has to balance in between fundamentals and as well as the price chart of the companies. This is because the evaluation of a good mutual fund scheme is based upon early or quarterly returns.
  • In the case of balanced funds, the rate of return in most cases can be negative as a certain part of the fund is invested in debt or liquid funds. So apparently the funds are less risky than 100% equity-based funds. There might be a difference between the little from both of these funds. In this case, the ratio will not work properly as the risk-bearing capacity of the clients is different.
  • In the current scenario, SEBI has instructed all the mutual fund companies to lower and their commissions and distribution expenses so that the total expense ratio becomes less compared to earlier schemes. In the modern environment because of the increasing demand for mutual fund schemes, the AUM has increased substantially resulting in a lower total expense ratio because the cost of commissions and distributions along with research costs has remained the same. So percentage-wise the total expense ratio has lowered. Thus it gives a brief idea that in spite of a lower total expense ratio one cannot guarantee the quality of a particular scheme in the mutual fund segment.

Conclusion

Apparently, the Total Ratio used to be one of the ways of evaluating a particular scheme, but with the intervention of SEBI, the TER has decreased substantially because of lower costs and higher AUM. Thus, the parameter of evaluation has to change on the basis of peer group analysis. As all the Schemes primarily the Equity-based one would reflect a lower Total Expense Ratio.

TER Formula Calculator

You can use the following TER Calculator

Total Fund Costs
Total Fund Assets
Total Expense Ratio (TER)
 

Total Expense Ratio (TER) =
Total Fund Costs =
Total Fund Assets
0 = 0
0

Recommended Articles

This is a guide to the Total Expense Ratio Formula. Here we discuss How to Calculate the Total Expense Ratio along with practical examples. We also provide a TER Calculator with a downloadable excel template. You may also look at the following articles to learn more –

  1. What is Return on Total Assets Formula?
  2. Calculator For Interest Expense Formula
  3. Examples to Calculate Depreciation Expenses
  4. How to Calculate Net Asset Value Using Formula?
Popular Course in this category
Financial Analyst Masters Training Program
  250+ Online Courses |  1000+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Investment Banking Training4.9
Investment Banking Training4.8
Financial Modeling Training4.7
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

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

Download Total Expense Ratio Formula Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Total Expense Ratio Formula Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more