EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula 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

Expense Ratio Formula

By Madhuri ThakurMadhuri Thakur

Expense Ratio Formula

Expense Ratio Formula (Table of Contents)

  • Formula
  • Examples
  • Calculator

What is the Expense Ratio Formula?

The term “expense ratio” refers to the efficiency ratio that measures the expenses incurred to manage the fund as a proportion of the total investment made in the fund, such as mutual fund, equity fund, exchange-traded fund, etc. In other words, the ratio indicates what percentage of the total investment made in the fund goes into compensating for the management fees. The management fees include (not exhaustive) audit cost, transactional cost, legal fees, fund manager fees, transfer fees, marketing fees, and other miscellaneous expenses.

Start Your Free Investment Banking Course

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

The formula for expense ratio is expressed as the management fees incurred for the fund divided by the overall asset size of the investment fund. Mathematically, it is represented as,

Expense Ratio = Management Fees / Total Investment in the Fund

Example of Expense Ratio Formula (With Excel Template)

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

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

Expense Ratio Formula – Example #1

Let us take the example of a mutual fund to illustrate the computation of expense ratio. During FY2019, the fund incurred total management fees of $15 million and the asset under management for the fund stood at $1,000 million as on December 31, 2019. Determine the expense ratio of the fund for the year 2019.

mutual fund

Solution:

Expense Ratio is calculated using the formula given below

Expense Ratio = Management Fees / Total Investment in the Fund

Expense Ratio Formula - 2

  • Expense Ratio = $15 million / $1,000 million
  • Expense Ratio = 1.5%

Therefore, the expense ratio of the mutual fund was 1.5% for the year 2019.

Expense Ratio Formula – Example #2

Let us take the example of a mutual fund with a more detailed expense break-up. During FY2019, the fund incurred the following expenses. Calculate the expense ratio of the fund if the asset under management for the fund stood at $1,000 million as on December 31, 2019.

Expense Ratio Formula - 3

Solution:

Management Fees is calculated using the formula given below

Management Fees = Audit Cost + Transactional Cost + Legal Fees + Fund Manager Fees + Transfer Fees + Marketing Fees

Management Fees

  • Management Fees = $1.2 million + $1.5 million + $1.3 million + $5.0 million + $0.5 million + $1.0 million
  • Management Fees = $10.5 million

Expense Ratio is calculated using the formula given below

Expense Ratio = Management Fees / Total Investment in the Fund

Expense Ratio Formula - 5

  • Expense Ratio = $10.5 million / $1,000 million
  • Expense Ratio = 1.05%

Therefore, the expense ratio of the mutual fund was 1.05% for the year 2019.

Explanation

The formula for Expense Ratio can be calculated by using the following steps:

Step 1: Firstly, determine all the costs incurred for operating and managing the investment fund and that primarily includes audit cost, transactional cost, legal fees, fund manager fees, transfer fees, marketing fees along with other miscellaneous expenses.

Step 2: Next, determine the size of investment made in the fund which is also known as an asset under management.

Step 3: Finally, the formula for expense ratio is expressed as the management fees (step 1) incurred for the fund divided by the overall asset size of the investment fund (step 2) as shown below.

Expense Ratio = Management Fees / Total Investment in the Fund

Relevance and Use of Expense Ratio Formula

The concept of expense ratio is very important for investors and analysts assessing such investment funds. All investment fund management involves various operating costs that go into creating, managing and maintaining it. So, all these costs are clubbed under a single head of management fees or fund costs and then eventually the expense ratio is computed. Now, it is quintessential to check whether or not the fund is generating returns higher than that of the expense ratio. If not, it means that the investors are losing money in that fund at the end of the investment period. Further, this metric also helps in comparing different investment funds that have different investment styles and cater to different risk appetite.

One of the most striking comparisons of expense ratio can be seen between index funds (aka passive funds) and actively-managed funds. Both these types of funds charge different expense ratios owing to the difference in their style of managing the investment portfolio. In index funds, the fund manager only tracks whether or not the portfolio is in sync with the benchmark index with which it is mapped. As such, these funds don’t require any active management team resulting in lower expense ratio. For instance, T. Rowe Price Equity Index 500 Fund is an index fund and it mimics S&P 500 Index. Its gross expense ratio and net expense ratio are 0.23% and 0.21% respectively. On the other hand, actively-managed funds require a strong portfolio management team of analysts who identify and analyze potential investment opportunities that can generate high returns. As such, these funds incur a higher cost of operation which are then passed on to the investors which are captured under expense ratio. For instance, AB Large Cap Growth Fund is an example of the actively-managed fund and its gross expense ratio and net expense ratio are 1.02% and 1.00% respectively.

Expense Ratio Formula Calculator

You can use the following Expense Ratio Formula Calculator

Management Fees
Total Investment in the Fund
Expense Ratio
 

Expense Ratio = Management Fees /Total Investment in the Fund
= 0 /0 = 0

Recommended Articles

This is a guide to the Expense Ratio Formula. Here we discuss how to calculate the Expense Ratio along with practical examples. We also provide an Expense Ratio calculator with a downloadable excel template. You may also look at the following articles to learn more –

  1. What is Total Expense Ratio?
  2. How to calculate Total Cost?
  3. Total Variable Cost Formula
  4. Calculation of Return on Total Assets
Popular Course in this category
Investment Banking Training
  124 Online Courses |  25 Hands-on Projects |   600+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Financial Modeling Training4.9
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 Expense Ratio Formula Excel Template

EDUCBA Login

Forgot Password?

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

EDUCBA

डाउनलोड 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