Modified Dietz Method

August 24, 2024 Portfolio Management

The Modified Dietz method estimates period return by weighting each external cash flow according to how long it was invested during the period.

On this page

The Modified Dietz method estimates a portfolio’s period return by adjusting investment gain for external cash flows and weighting each flow according to how long it was available for investment. It is useful when beginning and ending values and cash-flow dates are known but the portfolio was not valued at every external flow.

Modified Dietz does not eliminate the economic effect of cash-flow timing in the same way as an exact time-weighted return. It produces a money-weighted period return. Linking short-period Modified Dietz returns can approximate time-weighted performance.

Key Takeaways

The numerator removes net external flows from the change in portfolio value.
The denominator estimates average invested capital using time weights.
A flow near the beginning receives more weight than a flow near the end.
Beginning- versus end-of-day conventions change the weights and must be applied consistently.
The method is less accurate when cash flows are large and returns are volatile around them.
A single long-period Modified Dietz return should not be labeled exact TWR.
Reliable beginning, ending, and cash-flow values remain essential, especially for illiquid assets.

Formula

R_{MD} = \frac{ V_E-V_B-\sum_{i=1}^{n}CF_i }{ V_B+\sum_{i=1}^{n}w_iCF_i }

where:

(V_B) is beginning portfolio value
(V_E) is ending portfolio value
(CF_i) is external cash flow (i), positive for contributions and negative for withdrawals under the portfolio convention
(w_i) is the fraction of the measurement period that cash flow (i) was invested

Under an end-of-day cash-flow assumption using calendar days:

w_i = \frac{D-D_i}{D}

where (D) is total days in the period and (D_i) is days from the beginning to the flow date under the selected convention. A beginning-of-day policy can add one day to the invested portion. Systems should document their rule.

Worked Example

Use the same one-year account path as the time- and money-weighted examples:

Event	Amount or value
Beginning value	`$100`
Contribution halfway through period	`+$100`
Ending value	`$189`

The halfway contribution has weight 0.50. Investment gain after removing the contribution is:

\text{Gain} = 189-100-100 = -11

The weighted capital base is:

\text{Weighted Capital} = 100+0.50(100) = 150

Modified Dietz return is:

R_{MD} = \frac{-11}{150} = -7.33\%

For the same dates and values:

Measure	Result	Cash-flow treatment
Exact TWR	`-1.00%`	Links `+10%` and `-10%` subperiod returns
Exact annual MWRR	approximately `-7.29%`	Solves the dated IRR equation
Modified Dietz	`-7.33%`	Uses a `0.50` flow weight

Modified Dietz is close to MWRR in this example because it approximates the average capital exposed. It differs materially from exact TWR because the investor added a large amount before the losing subperiod.

Original Versus Modified Dietz

Method	Cash-flow assumption
Original Dietz	Treats aggregate net flow as if invested for half the period
Modified Dietz	Gives each flow its own time weight

If all flows occur near the midpoint, the results can be similar. If a large contribution arrives near the start or a large withdrawal occurs near the end, the original method’s midpoint assumption can be poor.

Why the Denominator Matters

The denominator approximates the capital available to earn return during the period.

A beginning-of-period contribution has a weight near 1.
A midpoint contribution has a weight near 0.5.
An end-of-period contribution has a weight near 0 under an end-of-day convention.
Withdrawals are negative and reduce weighted capital for the period after withdrawal.

A denominator near zero can create an extreme or undefined result. This can occur with large withdrawals, short positions, leverage, or unusual flow patterns. The output should be reviewed rather than accepted mechanically.

Cash-Flow Classification

External flows generally arise from the portfolio owner rather than investment performance:

contributions and deposits
withdrawals and transfers out
owner-directed capital additions or distributions

Security purchases and sales inside the portfolio are not external flows. Dividends and interest retained in the account are investment income, not client contributions. Fees and taxes require a stated gross or net reporting policy.

Modified Dietz and Time-Weighted Return

Exact TWR values the portfolio at each external flow and links the resulting subperiod returns. Modified Dietz uses time-weighted capital instead.

If performance is calculated for short intervals, such as daily or monthly periods, and those Modified Dietz returns are geometrically linked, the result can approximate TWR. Approximation error can accumulate or become material when:

one flow is large relative to portfolio value
markets move sharply around the flow
the portfolio contains nonlinear derivatives
valuation is stale or model-based
leverage changes during the period

Revaluing at a large cash flow can reduce the distortion by creating a new subperiod.

Modified Dietz and Money-Weighted Return

MWRR solves the dated cash-flow equation for an annualized IRR. Modified Dietz uses a linear time-weighted capital approximation for one measurement period.

Feature	Modified Dietz	MWRR / IRR
Calculation	Closed-form ratio	Root-finding equation
Cash-flow timing	Linear period weights	Compounded date exponents
Output period	Return for selected period	Often annualized since inception
Multiple solutions	No IRR root issue, but denominator can fail	Multiple or missing IRR solutions possible
Accuracy	Approximation	Exact for stated cash-flow equation

The results can be close over short periods with moderate flows but should not be assumed identical.

Practical Calculation Checklist

Confirm beginning and ending valuation timestamps.
Identify every external cash flow.
Apply one sign convention consistently.
Select calendar-day or other approved time weights.
State beginning- or end-of-day treatment.
Remove external flows from the value change in the numerator.
Add time-weighted flows to beginning capital in the denominator.
Review large flows and denominator stability.
State gross or net fee and tax treatment.
Link subperiod returns geometrically if reporting a longer horizon.

Risks and Limitations

Flow sensitivity: approximation error increases with large flows and volatile returns.
Valuation risk: uncertain asset values directly affect the result.
Linear weighting: return is assumed to accrue sufficiently smoothly within the period.
Convention risk: cash-flow day and timing choices change weights.
Denominator instability: large withdrawals can create extreme results.
Classification: incorrect treatment of fees or income as external flows distorts return.
False precision: a detailed percentage cannot overcome stale underlying values.

Common Mistakes

Saying Modified Dietz removes cash-flow timing rather than weighting it.
Using one aggregate flow weight when individual dates are available.
Reversing contribution and withdrawal signs mid-calculation.
Counting internal security trades as external flows.
Omitting fees or taxes without labeling the return gross.
Using one long-period result as exact TWR.
Averaging monthly returns instead of geometrically linking them.
Ignoring a denominator close to zero.
Assuming the method is equally reliable for liquid and stale-valued assets.

Authoritative Context

The GIPS Standards Handbook for Firms explains the Modified Dietz formula, daily weighting, beginning- and end-of-day assumptions, and its lower accuracy relative to valuation at each external cash flow. The GIPS asset-owner calculation guidance likewise describes Modified Dietz as weighting each flow by the time it is held in the portfolio.

Time-Weighted Rate of Return: Geometrically links returns between external cash flows.
Money-Weighted Rate of Return: Solves for the return earned by dated investor cash flows.
Rate of Return: The broader family of investment performance measures.
Return on Investment: A simpler net-benefit ratio that generally omits cash-flow timing.
Investment Performance: Encompasses return methodology, risk, fees, benchmark, and attribution.

FAQs

Is Modified Dietz a time-weighted or money-weighted return?

A single Modified Dietz period return is money-weighted because cash flows affect the weighted capital base. Geometrically linking short-period Modified Dietz returns can approximate TWR.

When is Modified Dietz less accurate?

It is less accurate when large external cash flows occur during volatile periods, because linear time weights cannot capture the actual return path around the flows.

Why use Modified Dietz instead of exact TWR?

It does not require a portfolio valuation at every external cash flow. That lowers data demands, but the tradeoff is approximation error.

Educational Use

This article provides general financial education. It is not personalized investment, performance-reporting, tax, accounting, legal, or fiduciary advice.

Money-Weighted Rate of Return