Calculating Bond ETF Returns with Distributions
Summary
The document addresses why monthly returns calculated from a bond fund’s month-end NAV can differ from its published performance figure when the fund makes cash distributions. It emphasizes using the prior month-end value and the current month’s final trading-day value, while accounting for the payout as an external withdrawal from the investment.
It presents the Simple Dietz method, which adjusts the return denominator for the timing of the cash flow. In the example, the distribution is entered as a negative flow; the adjusted calculation reproduces the reported monthly return. A second answer points to adjusted historical prices as a way to obtain total returns without manually adding distributions. These are practical reconciliation approaches, but the example covers a particular monthly period and does not discuss the fund provider’s exact accounting conventions or how to handle multiple flows and their timing in general.
Key ideas
- Monthly fund returns compare the last trading day of one month with the last trading day of the next.
- Cash distributions must be included to calculate total return from unadjusted NAV values.
- The Simple Dietz method accounts for a distribution as a weighted cash flow in the return calculation.
- A fund distribution is treated as a withdrawal when calculating the investor’s return.
- Adjusted historical prices can provide a total-return series without separately adding each payout.
Tags
Full text
# How are returns on Bond Funds (or ETFs) calculated?
# How are returns on Bond Funds (or ETFs) calculated?
For example, if we consider the fund "iShares Core U.S. Aggregate Bond ETF (AGG)", I am trying to figure out how the yearly/Monthly returns are being calculated.
I extracted the historical NAV values from the site: https://www.ishares.com/us/products/239458/ishares-core-total-us-bond-market-etf#/, where I click on Download on the top right of the page.
I am trying to reconcile the returns by calculating them from the Historical tab values and matching it with the monthly performance values in the Performance tab.
If we consider the month of October 2003, I calculate the end of month return as shown:
The resulting value is -0.96%, which matches with the return in the Performance tab.
But if we consider the month of November 2003, calculating the return the same way does not match with the performance return in the Performance tab (0.22%).
My question is, how does one calculate the returns of bond funds, taking into account the regular monthly payouts?
## Answer by Alex C (score 0, accepted)
https://quant.stackexchange.com/a/47585
The return for November should be calculated from Oct 31, 2003 to Nov 28, 2003. From last day of month to last day of month. And the payout should be included.
The simplest method that includes the payout is the Simple Dietz Method, which gives the following for November 2003:
$$R=\frac{B - A - C}{A +C/2}$$
In this case the Cash Flow C is a withdrawal from the protfolio, so it is negative:
$$R=\frac{101.13-101.27-(-0.36)}{101.27-0.36/2}=0.0021762$$ or approx 0.22%
## Answer by Edward Watson (score 1)
https://quant.stackexchange.com/a/48611
yahoo finance has downloadable price history for this and others. They include the adjusted price which can be used to calculate the total return without any adjustments.Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)
This summary was written by Stratmill's research agent from the original; it is not a copy of the source.