Investment

Weighted Average Expense Ratio Calculator

A portfolio’s real expense ratio is weighted by how much sits in each fund, not the average of their published figures.

Each fund, its balance and its expense ratio

How many funds

First and second fund

Money in fund 1 (local currency).

%
%

Third and fourth fund

%

Leave at 0 if unused.

%

Weighted average expense ratio

0.350%

Blended annual fee across all funds.

Formula verified 25 September 2026

Annual fee cost

350.00

The blended fee applied to your total.

Total invested

100,000

Sum of all fund amounts.

Report an issue

Projection only — not investment advice; returns are not guaranteed. Read the full disclaimer ↓

Annual fee cost by fund

Add your numbers to see the visual breakdown.

Estimates only — not financial, tax, or professional advice.

Calculated in your browser — the numbers you enter are never sent to our servers.

What it calculates: Weighted average expense ratio, Annual fee cost, Total invested.

Updated 25 September 2026 · 3,840 automated cases pass

A cheap fund holding most of the money dominates an expensive small one

Averaging the published ratios treats a holding of 500 and a holding of 50,000 as equals. The real cost is each fund’s ratio weighted by its balance, which is usually far closer to the largest holding’s figure than to the simple average.

Weighted ER = Σ(amount × expense ratio) / total amount

This cuts both ways. A portfolio that looks expensive because one small satellite fund charges 1.5% may in fact be cheap overall — and one that looks cheap can hide a high ratio on the fund holding most of the money.

For more than four funds, the same blend in Excel is =SUMPRODUCT(balances, ratios)/SUM(balances): each ratio weighted by its balance, divided by the total balance.

A ratio is abstract; the money leaving each year is not

The calculator reports the annual cost in currency alongside the percentage, because 0.6% does not feel like anything while a number of rupees or dollars does. On a large portfolio that figure is often a noticeable fraction of a year’s contributions.

It is also deducted from the fund’s returns rather than billed, so it never appears on a statement as a charge. That invisibility is precisely why it goes unexamined for years at a time.

Half a point sounds small and is not, over thirty years

An expense ratio does not only take its percentage each year — it takes the growth that percentage would have earned for the remaining term. Over thirty years a difference of half a percentage point commonly consumes something in the region of a seventh of the final balance.

This is the strongest argument for checking a portfolio’s weighted ratio at all. It is one of the very few inputs to a long-term outcome that you control directly and completely.

Trading costs, platform fees and taxes sit outside it

The published ratio covers the fund’s management and operating costs. It excludes the fund’s own transaction costs from trading its portfolio, any entry or exit load, brokerage or platform charges, and the tax drag from distributions.

A high-turnover fund can therefore cost more than its ratio implies, while a platform fee charged separately on the whole account adds to every holding equally. Treat this figure as the largest single component of cost, not the total.

Frequently Asked Questions

Why does the amount in each fund matter for fees?

Expense ratios are charged on assets, so a high fee on a small balance costs little while a modest fee on a large balance costs a lot. Weighting by amount shows the fee you actually pay overall.

Is a lower weighted expense ratio always better?

A lower ratio means less drag on returns, all else equal. But fees are only one factor; a fund’s strategy, tracking quality, and after-fee return all matter, so do not judge on cost alone.

How much do small differences in expense ratio cost?

Over decades, even a few tenths of a percent compound into large sums because the fee is paid every year on a growing balance. Use a fund cost calculator to project the long-run impact.

What is a typical expense ratio?

Broad index funds often charge well under 0.20%, while actively managed funds commonly charge 0.50% to over 1%. Ranges vary by market and fund type, so check each fund’s current figure.

Should I include cash in the calculation?

If you want the fee as a share of your total portfolio including cash, add cash as a holding with a 0% ratio. To measure only the fund sleeve, leave cash out.

Sources & References

Figures on this page are checked against primary, authoritative sources. Links open in a new tab.

What the calculation assumes

  • Expense ratios are entered as the fund’s stated annual percentage.
  • Amounts represent current holdings; the annual cost is an estimate at today’s balances.
  • Trading costs, loads, and platform fees are excluded unless folded into the ratios.
  • For educational and general reference use.

Where it stops

  • Expense ratios are charged on assets that change daily, so the actual fee drifts as balances move.
  • It captures fund-level fees only, not advisory, custody, or transaction costs.
  • Up to four funds are supported here; combine larger portfolios in stages.

Related Calculators

Portfolio ValueWhat your holdings are worth at current prices, and how much of that sits in the single largest position.
Portfolio ReturnWeighted return across holdings, with the weights checked to 100% and the largest contribution identified.
InvestmentProject lump-sum and regular-contribution growth, plan a goal, and solve future vs present value, with fees and inflation.
Annualized ReturnThe compound annual rate behind a total return, with the growth multiple alongside it.
Regular InvestmentProject how regular monthly contributions grow over time — SIP-style investing, dollar-cost averaging, inflation-adjusted value, and long-term goals.
Retirement WithdrawalEstimate how long savings last under regular withdrawals (SWP) — drawdown, safe withdrawal rate, inflation, and a year-by-year schedule.
ROISimple, date-based, and net ROI with annualised ROI (CAGR), a reverse target solver, and a two-investment comparison.
Dividend ReinvestmentModel DRIP vs cash dividends, after-tax reinvestment, yield on cost, and a dividend income goal solver.

More in Investing, or browse all calculators.

Investment disclaimer

Returns are assumptions, not guarantees. Actual results may vary because of market performance, taxes, fees, inflation, and timing. This is an educational projection, not investment advice.

How we calculate · Found an error? email us

Authorship & verification

Built and maintained by .

How this calculator is tested

3,840 automated cases pass, run against the engine this calculator shares with 4 related calculators; last run 14 November 2026.

Test cases by kind
Independent cross-check44expected values published elsewhere, or reached by a second method
Golden14worked by hand, the arithmetic written into the test
Boundary9zero, negative, extreme and invalid inputs
Property3,750rules that must hold for any input
Structural23every output present and finite

Full verification report for this calculator

What's changed (5 updates)

Published 13 September 2026

  1. Published the calculator with its formula, worked example, assumptions, limitations and a bespoke guide, and added an automated formula test suite covering it.
  2. Tested the balance-weighted ratio across up to four funds against a hand-computed total cost over total assets.
  3. Tested that the weighted ratio always falls between the cheapest and dearest fund in use, and equals a single fund when only one holds money.
  4. Added the Excel SUMPRODUCT formula for portfolios with more than four funds.
  5. Frequently Asked Questions now show on the page: 5 answers, checked in a page-by-page audit.

Add this calculator to your site

Responsive embed — and private: nothing your visitors type leaves their browser.