Skip to content
QuantCalc Tools
Directory

Cagr Irr Drawdown Compounding

Simple vs Modified Dietz Return Formula: Sub-Period Cashflow Weighting Math

When daily pre-flow portfolio valuations are unavailable on private credit or multi-custodian wealth accounts, Modified Dietz approximates True TWRR by day-weighting external cashflows.

By Elena Rostova, FRM, CQFReview not recorded · Updated
Simple vs Modified Dietz Return Formula: Sub-Period Cashflow Weighting Math — QuantCalc Tools 2026 quantitative & supervisory data card
QuantCalc Tools (CAGR vs IRR, Volatility Drag, Sharpe/Sortino & Drawdown Recovery): Day-weighted w_k = (D - d_k)/D cashflow math, 10% reval gates, and denominator traps.Source: QuantCalc Tools Institutional Research DeskLicense: CC-BY-4.0

How do institutional custodians, family offices, and pension consultants calculate Time-Weighted Rates of Return (TWRR) on accounts containing corporate bonds, private placements, or syndicated loans that are only priced at month-end while external client deposits and withdrawals arrive on Day 4, Day 11, and Day 26? Without intra-month portfolio valuations $V_k^{-}$ on the exact cashflow dates, exact geometric sub-period linking is impossible! Peter Dietz (1966) introduced the Simple Dietz midpoint approximation, which institutional custody systems refined into the Modified Dietz day-weighted return formula—historically embedded across CFA GIPS transition rules. Benchmark multi-year compounding in our CAGR Calculator and anchor in our CAGR, IRR & Drawdown Hub.

Exact Simple Dietz vs Modified Dietz Equations & Day-Weight Conventions#

Let $V0$ be beginning-of-month market value (including accrued income!), $V1$ be end-of-month market value across a $D$-day calendar month (e.g., $D = 30$ or $31$), and $CFk$ be external net cashflows arriving on day $dk \in [1, D]$. Notice the crucial difference between Simple Dietz (which blindly assumes every cashflow arrived at exact mid-month $wk = 0.50$) and Modified Dietz (which weights each cashflow by the exact fraction of the month $wk$ it sat invested in the portfolio):

Formula or model from the articleNot independently verified
Simple Dietz vs Modified Dietz Monthly Portfolio Return Formulas:
  • Net Investment Gain (Numerator for BOTH!) : Gain = V1 - V0 - Sum{k=1..M} CFk
  • 1. Simple Dietz Return (Midpoint w = 0.5) : RSimple = Gain / [ V0 + 0.5 * Sum{k=1..M} CFk ]
  • 2. Modified Dietz Return (Day-Weighted) : RMod = Gain / [ V0 + Sum{k=1..M} (wk * CF_k) ]
  • End-of-Day Flow Convention : wk = (D - dk) / D
  • Start-of-Day Flow Convention : wk = (D - dk + 1) / D (Must stay consistent across firm!)
  • 3. Chain-Linked Annualized Modified Dietz : CAGRMod = [ Product{m=1..12} (1 + R_Mod,m) ]^(1/T) - 1
  • Worked Intra-Month Crash Distortion Audit (30-Day April, V_0 = $10,000,000):
  • Market rallies +10.0% from Day 0 to Day 6 (VDay6pre = $11,000,000), client wires +$5,000,000 on Day 6 EOD
  • ($16,000,000 invested), then market crashes -15.0% from Day 6 to Day 30 -> Ending V_1 = $13,600,000!
  • True Exact Sub-Period TWRR = (1 + 0.10) * (1 - 0.15) - 1 = 1.10 * 0.85 - 1 = -6.50%!
  • Net Dollar Gain Numerator = $13,600,000 - $10,000,000 - $5,000,000 = -$1,400,000
  • 1. Simple Dietz (w = 0.50) : -$1,400,000 / ($10.0M + 0.5*$5.0M) = -$1.40M / $12.50M = -11.20%! (-470 bps error!)
  • 2. Modified Dietz (d_k = 6, EOD w = (30-6)/30 = 0.80):
  • R_Mod = -$1,400,000 / ($10.0M + 0.80*$5.0M) = -$1.40M / $14.00M = -10.00%! (-350 bps error vs True -6.50% TWRR!)

Pause and inspect why even Modified Dietz (-10.00%) missed True TWRR (-6.50%) by $-350\text{ bps}$ in that worked example! Modified Dietz is actually a first-order linear approximation to Money-Weighted IRR within that single month—implicitly assuming the portfolio returned a constant linear rate per day across all 30 days. When a large external cashflow ($+50\%$ of $V_0$) lands right at an intra-month market peak ($+10\%$ followed by $-15\%$), dollar-weighted intra-month loss leaks directly into Modified Dietz!

Decision tree for GIPS portfolio return calculation choosing between Exact Daily TWRR, Modified Dietz with 10 percent large-cashflow revaluations, and Simple Dietz
Decision tree for GIPS portfolio return calculation choosing between Exact Daily TWRR, Modified Dietz with 10 percent large-cashflow revaluations, and Simple DietzVerified Exhibit

Exact Mathematical Error Bound of Modified Dietz: $\text{Error} \approx w(1-w)\,\frac{CF}{V0 + w\cdot CF}\,(R{\text{post}} - R_{\text{pre}})$#

Let $Ra$ be the pre-flow return on $[0, dk]$ and $Rb$ be the post-flow return on $[dk, D]$, with $c = CF / V_0$. Algebraic expansion proves that Modified Dietz equals Exact TWRR (Error = 0.00 bps) whenever ANY ONE of three conditions holds:

  1. External cashflow is zero ($c = 0$), OR cashflow occurs strictly at Day 0 ($w = 1$) or Day $D$ EOD ($w = 0$).
  2. Intra-month return rate was uniform (consistent with linear accrual, e.g., SOFR cash sweep).
  3. Both $|c|$ (% cashflow size) and $|Rb - Ra|$ (intra-month volatility reversal) are small—because the approximation error is multiplicative in Flow Size x Intra-Month Return Reversal!

Modified Dietz vs True Daily TWRR Error Benchmarks by Cashflow Size#

Audit basis-point tracking gaps and redemption denominator hazards across escalating intra-month external cashflows:

Cashflow Size ($CF / V_0$)Intra-Month Regime ($R{\text{pre}}$ then $R{\text{post}}$)True Exact TWRRModified Dietz ($d_k = 10/30$)Simple Dietz ($w=0.5$)Mod Dietz Error
$+2.0\%$ (Dividend / Fee)$+2.0\%$ then $+1.0\%$ (Calm)$+3.02\%$$+3.01\%$$+3.01\%$$-1\text{ bp}$ (Negligible)
$+8.0\%$ (Routine Inflow)$+4.0\%$ then $-3.0\%$ (Mild)$+0.88\%$$+0.69\%$$+0.73\%$$-19\text{ bps}$
$+25.0\%$ (Large Allocation)$+8.0\%$ then $-10.0\%$ (Whip)$-2.80\%$$-4.44\%$$-4.71\%$$-164\text{ bps}$ (Breach!)
$+50.0\%$ (Major Mandate)$+10.0\%$ then $-15.0\%$ (Crash)$-6.50\%$$-10.00\%$$-11.20\%$$-350\text{ bps}$ (Severe!)
$-92.0\%$ (Near-Full Exit)$-5.0\%$ then $+12.0\%$ (Snap)$+6.40\%$Denominator Collapse!Negative Denom!Fails if $V_0 + w\cdot CF \le 0$!
Absolute tracking error in basis points between Modified Dietz and Exact Daily TWRR across external cashflow sizes from 2 percent to 50 percent of NAV
Absolute tracking error in basis points between Modified Dietz and Exact Daily TWRR across external cashflow sizes from 2 percent to 50 percent of NAVVerified Exhibit

Look at Row 5 of the Table: The Catastrophic Denominator Trap on Large Redemptions!#

Suppose an account starts the month at $V0 = \$10.0\text{M}$, surges $+25\%$ to $\$12.5\text{M}$ on Day 3 (`wk = 0.90), and the client **withdraws $-\$11.5\text{M}$** (CF = -$11.5M), leaving $\$1.0\text{M}$ invested! Look at what happens to the Modified Dietz denominator: $$V_0 + w_k \cdot CF = \$10.0\text{M} + 0.90(-\$11.5\text{M}) = -\$0.35\text{M} < 0$$ Because the withdrawal exceeded $V_0 / w_k$ thanks to early intra-month profits, **the Modified Dietz denominator turns NEGATIVE**, printing an absurd **$-714\%$ return** on a month that made **$+25\%$**! Production portfolio engines MUST guard against V0 + Sum(wk * CFk) <= 0.10 * V0` by falling back to exact pre-flow revaluation or log-space XIRR!

GIPS Compliance Best Practices & Cross-Checks#

Compare Modified Dietz sub-period linking directly against TWRR vs XIRR cashflow attribution, verify fee-deducted net series using hedge-fund 2-and-20 net CAGR math, and check institutional verification protocols in verify and UK FCA guidance.

Frequently asked questions

Should Modified Dietz use start-of-day (D - d_k + 1)/D or end-of-day (D - d_k)/D cashflow weights?

Under GIPS, either convention (or exact timestamped intraday hour fraction) is valid PROVIDED it matches when capital actually enters market risk: subscription wires invested at the 4:00 PM market close earn zero return on day d_k (use (D - d_k)/D), whereas morning futures margin transfers trade all day d_k (use (D - d_k + 1)/D). Never mix conventions to cherry-pick returns!

Is Modified Dietz a Time-Weighted Return or a Money-Weighted Return?

Strictly speaking, WITHIN a single month, Modified Dietz is a linear approximation to Money-Weighted IRR! It becomes an approximation to Time-Weighted Return ONLY when you chain-link monthly (or weekly) Modified Dietz sub-periods geometrically: (1 + R_Jan)*(1 + R_Feb)*... - 1.

How must bond accrued interest and equity ex-dividends be treated in V_0 and V_1?

GIPS mandates trade-date accounting with full "dirty" market values (clean price PLUS accrued bond interest and declared ex-date dividends receivable) in BOTH V_0 and V_1! Omitting accrued interest causes artificial return spikes on coupon payment dates.

How does Modified Dietz support multi-currency Brinson attribution (Campisi / Ankrim-Hensel)?

Asset-segment Modified Dietz applies the exact same w_k denominator formula to each equity sector or bond bucket (treating internal buys/sells between sectors as segment cashflows!), guaranteeing that weighted sector Modified Dietz returns sum additively to exact total portfolio Modified Dietz return!

Publication record

Published
13 November 2026
Updated
14 November 2026
Author
Elena Rostova, FRM, CQF
Review
Review not recorded
Automated fact check
Passed in the stored pipeline record
Source URLs
4 recorded

AI assistance recorded: anthropic/claude-opus-4.6. This field does not establish human review or source verification.

Academic & Institutional Attribution

Cite This Research & Embed Live Data Card

Open Attribution License (CC BY 4.0)

Standard academic & institutional research paper citation format.

Elena Rostova, FRM, CQF. (2026, November 14). Simple vs Modified Dietz Return Formula: Sub-Period Cashflow Weighting Math. QuantCalc Tools. https://quantcalctools.com/guides/simple-vs-modified-dietz-sub-period-cashflow-weighting-accuracy
Explore Cagr Irr Drawdown Compounding Hub (20) →

QuantCalc Tools Data, Benchmarks & Contributor Records

Simple vs Modified Dietz Return Formula & GIPS Error Bounds | QuantCalc Tools