I have an investment in a mix of VWIUX/VWLUX (intermediate and long-term non-AMT muni bonds), which are mutual funds. I've been eyeing switching some of the allocation (or new incoming money) to VTEB instead as ETF vs. mutual fund has some conveniences that come with it.
However, there is one thing that has held me back and that I can't quite understand, so I thought I'd ask the experts: why is the distribution yield/distributions on VTEB so much lower than on VWIUX/VWLUX? They have a slightly different mix, but the difference is shocking - ~1.90%-2.1% on VWIUX and ~1.60%-1.80% for VTEB.
If one looks at the Vanguard's website for YTM, they look almost the same across the board:
- VWLUX: 4.4%
- VWIUX: 4.0%
- VTEB: 4.1%
But if you compute the real distribution yields with an annualized trailing average, you can an extremely different picture:
- VWLUX: 2.6%-2.75%
- VWIUX: 1.8%-2.15%
- VTEB: 1.6%-1.8%
For simplification, this ignores the EOY cap gains for the mutual funds, which would make their distributions even higher and further away from VTEB, so I don't see taking the cap gains into account helping in understanding why the distribution yields are so far apart.
At first, I thought maybe that's because the ETF doesn't make cap gain distributions and its price is driven up instead, but comparing their price over the past 5Y I don't personally see VTEB's price significantly deviating upwards over time like one would expect if its distributions were instead built into a higher price.
Any experts can enlighten me?
Data tables:
Code: Select all
VTEB
Type $/Share Payable date Record date Ex-dividend date Distribution yield Price on record date Distribution yield computed Trailing total/avg, annualized
Dividend $0.093200 11/04/2022 11/02/2022 11/01/2022 — $47.76 2.34% 1.77%
Dividend $0.098000 10/06/2022 10/04/2022 10/03/2022 — $48.58 2.42% 1.74%
Dividend $0.093100 09/07/2022 09/02/2022 09/01/2022 — $49.56 2.25% 1.71%
Dividend $0.087000 08/04/2022 08/02/2022 08/01/2022 — $51.06 2.04% 1.67%
Dividend $0.081300 07/07/2022 07/05/2022 07/01/2022 — $50.18 1.94% 1.65%
Dividend $0.076000 06/06/2022 06/02/2022 06/01/2022 — $50.84 1.79% 1.63%
Dividend $0.070400 05/05/2022 05/03/2022 05/02/2022 — $49.91 1.69% 1.62%
Dividend $0.068200 04/06/2022 04/04/2022 04/01/2022 — $51.51 1.59% 1.61%
Dividend $0.079800 03/04/2022 03/02/2022 03/01/2022 — $53.13 1.80% 1.62%
Dividend $0.070300 02/04/2022 02/02/2022 02/01/2022 — $53.68 1.57% 1.60%
Dividend $0.069400 12/29/2021 12/27/2021 12/23/2021 — $54.96 1.52% 1.60%
Dividend $0.074500 12/06/2021 12/02/2021 12/01/2021 — $54.92 1.63% 1.61%
Dividend $0.071500 11/04/2021 11/02/2021 11/01/2021 — $54.60 1.57% 1.61%
Dividend $0.074900 10/06/2021 10/04/2021 10/01/2021 — $54.68 1.64% 1.62%
Dividend $0.072100 09/07/2021 09/02/2021 09/01/2021 — $55.18 1.57% 1.61%
Dividend $0.071600 08/05/2021 08/03/2021 08/02/2021 — $55.49 1.55% 1.62%
Dividend $0.074700 07/07/2021 07/02/2021 07/01/2021 — $55.27 1.62% 1.64%
Dividend $0.074000 06/04/2021 06/02/2021 06/01/2021 — $55.13 1.61% 1.65%
Dividend $0.077800 05/06/2021 05/04/2021 05/03/2021 — $54.94 1.70% 1.70%
VWIUX
Type $/Share Payable date Record date Reinvest date Reinvest price Price on record date Distribution yield computed Trailing total/avg, annualized
Dividend $0.0294110 11/01/2022 10/31/2022 10/31/2022 $12.87 $12.87 2.74% 2.28%
Dividend $0.0291340 10/03/2022 09/30/2022 09/30/2022 $12.96 $12.96 2.70% 2.26%
Dividend $0.0284880 09/01/2022 08/31/2022 08/31/2022 $13.41 $13.41 2.55% 2.23%
Dividend $0.0279540 08/01/2022 07/29/2022 07/29/2022 $13.70 $13.70 2.45% 2.21%
Dividend $0.0283520 07/01/2022 06/30/2022 06/30/2022 $13.41 $13.41 2.54% 2.19%
Dividend $0.0274570 06/01/2022 05/31/2022 05/31/2022 $13.62 $13.62 2.42% 2.17%
Dividend $0.0272070 05/02/2022 04/29/2022 04/29/2022 $13.47 $13.47 2.42% 2.15%
Dividend $0.0258140 04/01/2022 03/31/2022 03/31/2022 $13.83 $13.83 2.24% 2.13%
Dividend $0.0270950 03/01/2022 02/28/2022 02/28/2022 $14.24 $14.24 2.28% 2.12%
Dividend $0.0247750 02/01/2022 01/31/2022 01/31/2022 $14.32 $14.32 2.08% 2.10%
Dividend $0.0252250 01/03/2022 12/31/2021 12/31/2021 $14.70 $14.70 2.06% 2.10%
Dividend $0.0259010 12/01/2021 11/30/2021 11/30/2021 $14.73 $14.73 2.11% 2.11%
Dividend $0.0255200 11/01/2021 10/29/2021 10/29/2021 $14.66 $14.66 2.09% 2.11%
Dividend $0.0261100 10/01/2021 09/30/2021 09/30/2021 $14.71 $14.71 2.13% 2.11%
Dividend $0.0254760 09/01/2021 08/31/2021 08/31/2021 $14.84 $14.84 2.06% 2.11%
Dividend $0.0257340 08/02/2021 07/30/2021 07/30/2021 $14.90 $14.90 2.07% 2.12%
Dividend $0.0266620 07/01/2021 06/30/2021 06/30/2021 $14.83 $14.83 2.16% 2.15%
Dividend $0.0264040 06/01/2021 05/28/2021 05/28/2021 $14.83 $14.83 2.14% 2.14%
VWLUX
Type $/Share Payable date Record date Reinvest date Reinvest price Price on record date Distribution yield computed Trailing total/avg, annualized
Dividend $0.0270330 11/01/2022 10/31/2022 10/31/2022 $10.04 $10.04 3.23% 2.74%
Dividend $0.0266790 10/03/2022 09/30/2022 09/30/2022 $10.17 $10.17 3.15% 2.72%
Dividend $0.0262410 09/01/2022 08/31/2022 08/31/2022 $10.65 $10.65 2.96% 2.69%
Dividend $0.0259460 08/01/2022 07/29/2022 07/29/2022 $10.98 $10.98 2.84% 2.68%
Dividend $0.0262570 07/01/2022 06/30/2022 06/30/2022 $10.67 $10.67 2.95% 2.67%
Dividend $0.0259320 06/01/2022 05/31/2022 05/31/2022 $10.98 $10.98 2.83% 2.65%
Dividend $0.0260650 05/02/2022 04/29/2022 04/29/2022 $10.83 $10.83 2.89% 2.63%
Dividend $0.0257370 04/01/2022 03/31/2022 03/31/2022 $11.25 $11.25 2.75% 2.61%
Dividend $0.0264860 03/01/2022 02/28/2022 02/28/2022 $11.67 $11.67 2.72% 2.60%
Dividend $0.0252450 02/01/2022 01/31/2022 01/31/2022 $11.77 $11.77 2.57% 2.59%
Dividend $0.0258380 01/03/2022 12/31/2021 12/31/2021 $12.13 $12.13 2.56% 2.59%
Dividend $0.0263490 12/01/2021 11/30/2021 11/30/2021 $12.20 $12.20 2.59% 2.59%
Dividend $0.0260720 11/01/2021 10/29/2021 10/29/2021 $12.10 $12.10 2.59% 2.59%
Dividend $0.0263790 10/01/2021 09/30/2021 09/30/2021 $12.14 $12.14 2.61% 2.59%
Dividend $0.0261830 09/01/2021 08/31/2021 08/31/2021 $12.27 $12.27 2.56% 2.59%
Dividend $0.0263930 08/02/2021 07/30/2021 07/30/2021 $12.35 $12.35 2.56% 2.60%
Dividend $0.0267770 07/01/2021 06/30/2021 06/30/2021 $12.27 $12.27 2.62% 2.62%
Dividend $0.0267190 06/01/2021 05/28/2021 05/28/2021 $12.25 $12.25 2.62% 2.62%
Code: Select all
VTEB
Type $/Share Payable date Record date Ex-dividend date Distribution yield Price on record date Distribution yield computed Trailing total/avg, annualized
Dividend $0.093200 11/04/2022 11/02/2022 11/01/2022 — =INDEX(GOOGLEFINANCE($A$1, "close", D3), 2, 2) =B3/G3*12 =SUM(B3:B$21)/AVERAGE(G3:G$21)*12/COUNT(B3:B$21)
Dividend $0.098000 10/06/2022 10/04/2022 10/03/2022 — =INDEX(GOOGLEFINANCE($A$1, "close", D4), 2, 2) =B4/G4*12 =SUM(B4:B$21)/AVERAGE(G4:G$21)*12/COUNT(B4:B$21)
Dividend $0.093100 09/07/2022 09/02/2022 09/01/2022 — =INDEX(GOOGLEFINANCE($A$1, "close", D5), 2, 2) =B5/G5*12 =SUM(B5:B$21)/AVERAGE(G5:G$21)*12/COUNT(B5:B$21)
Dividend $0.087000 08/04/2022 08/02/2022 08/01/2022 — =INDEX(GOOGLEFINANCE($A$1, "close", D6), 2, 2) =B6/G6*12 =SUM(B6:B$21)/AVERAGE(G6:G$21)*12/COUNT(B6:B$21)
Dividend $0.081300 07/07/2022 07/05/2022 07/01/2022 — =INDEX(GOOGLEFINANCE($A$1, "close", D7), 2, 2) =B7/G7*12 =SUM(B7:B$21)/AVERAGE(G7:G$21)*12/COUNT(B7:B$21)
Dividend $0.076000 06/06/2022 06/02/2022 06/01/2022 — =INDEX(GOOGLEFINANCE($A$1, "close", D8), 2, 2) =B8/G8*12 =SUM(B8:B$21)/AVERAGE(G8:G$21)*12/COUNT(B8:B$21)
Dividend $0.070400 05/05/2022 05/03/2022 05/02/2022 — =INDEX(GOOGLEFINANCE($A$1, "close", D9), 2, 2) =B9/G9*12 =SUM(B9:B$21)/AVERAGE(G9:G$21)*12/COUNT(B9:B$21)
Dividend $0.068200 04/06/2022 04/04/2022 04/01/2022 — =INDEX(GOOGLEFINANCE($A$1, "close", D10), 2, 2) =B10/G10*12 =SUM(B10:B$21)/AVERAGE(G10:G$21)*12/COUNT(B10:B$21)
Dividend $0.079800 03/04/2022 03/02/2022 03/01/2022 — =INDEX(GOOGLEFINANCE($A$1, "close", D11), 2, 2) =B11/G11*12 =SUM(B11:B$21)/AVERAGE(G11:G$21)*12/COUNT(B11:B$21)
Dividend $0.070300 02/04/2022 02/02/2022 02/01/2022 — =INDEX(GOOGLEFINANCE($A$1, "close", D12), 2, 2) =B12/G12*12 =SUM(B12:B$21)/AVERAGE(G12:G$21)*12/COUNT(B12:B$21)
Dividend $0.069400 12/29/2021 12/27/2021 12/23/2021 — =INDEX(GOOGLEFINANCE($A$1, "close", D13), 2, 2) =B13/G13*12 =SUM(B13:B$21)/AVERAGE(G13:G$21)*12/COUNT(B13:B$21)
Dividend $0.074500 12/06/2021 12/02/2021 12/01/2021 — =INDEX(GOOGLEFINANCE($A$1, "close", D14), 2, 2) =B14/G14*12 =SUM(B14:B$21)/AVERAGE(G14:G$21)*12/COUNT(B14:B$21)
Dividend $0.071500 11/04/2021 11/02/2021 11/01/2021 — =INDEX(GOOGLEFINANCE($A$1, "close", D15), 2, 2) =B15/G15*12 =SUM(B15:B$21)/AVERAGE(G15:G$21)*12/COUNT(B15:B$21)
Dividend $0.074900 10/06/2021 10/04/2021 10/01/2021 — =INDEX(GOOGLEFINANCE($A$1, "close", D16), 2, 2) =B16/G16*12 =SUM(B16:B$21)/AVERAGE(G16:G$21)*12/COUNT(B16:B$21)
Dividend $0.072100 09/07/2021 09/02/2021 09/01/2021 — =INDEX(GOOGLEFINANCE($A$1, "close", D17), 2, 2) =B17/G17*12 =SUM(B17:B$21)/AVERAGE(G17:G$21)*12/COUNT(B17:B$21)
Dividend $0.071600 08/05/2021 08/03/2021 08/02/2021 — =INDEX(GOOGLEFINANCE($A$1, "close", D18), 2, 2) =B18/G18*12 =SUM(B18:B$21)/AVERAGE(G18:G$21)*12/COUNT(B18:B$21)
Dividend $0.074700 07/07/2021 07/02/2021 07/01/2021 — =INDEX(GOOGLEFINANCE($A$1, "close", D19), 2, 2) =B19/G19*12 =SUM(B19:B$21)/AVERAGE(G19:G$21)*12/COUNT(B19:B$21)
Dividend $0.074000 06/04/2021 06/02/2021 06/01/2021 — =INDEX(GOOGLEFINANCE($A$1, "close", D20), 2, 2) =B20/G20*12 =SUM(B20:B$21)/AVERAGE(G20:G$21)*12/COUNT(B20:B$21)
Dividend $0.077800 05/06/2021 05/04/2021 05/03/2021 — =INDEX(GOOGLEFINANCE($A$1, "close", D21), 2, 2) =B21/G21*12 =SUM(B21:B$21)/AVERAGE(G21:G$21)*12/COUNT(B21:B$21)
VWIUX
Type $/Share Payable date Record date Reinvest date Reinvest price Price on record date Distribution yield computed Trailing total/avg, annualized
Dividend $0.0294110 11/01/2022 10/31/2022 10/31/2022 $12.87 =INDEX(GOOGLEFINANCE($A$23, "close", D25), 2, 2) =B25/G25*12 =SUM(B25:B$42)/AVERAGE(G25:G$42)*12/COUNT(B25:B$42)
Dividend $0.0291340 10/03/2022 09/30/2022 09/30/2022 $12.96 =INDEX(GOOGLEFINANCE($A$23, "close", D26), 2, 2) =B26/G26*12 =SUM(B26:B$42)/AVERAGE(G26:G$42)*12/COUNT(B26:B$42)
Dividend $0.0284880 09/01/2022 08/31/2022 08/31/2022 $13.41 =INDEX(GOOGLEFINANCE($A$23, "close", D27), 2, 2) =B27/G27*12 =SUM(B27:B$42)/AVERAGE(G27:G$42)*12/COUNT(B27:B$42)
Dividend $0.0279540 08/01/2022 07/29/2022 07/29/2022 $13.70 =INDEX(GOOGLEFINANCE($A$23, "close", D28), 2, 2) =B28/G28*12 =SUM(B28:B$42)/AVERAGE(G28:G$42)*12/COUNT(B28:B$42)
Dividend $0.0283520 07/01/2022 06/30/2022 06/30/2022 $13.41 =INDEX(GOOGLEFINANCE($A$23, "close", D29), 2, 2) =B29/G29*12 =SUM(B29:B$42)/AVERAGE(G29:G$42)*12/COUNT(B29:B$42)
Dividend $0.0274570 06/01/2022 05/31/2022 05/31/2022 $13.62 =INDEX(GOOGLEFINANCE($A$23, "close", D30), 2, 2) =B30/G30*12 =SUM(B30:B$42)/AVERAGE(G30:G$42)*12/COUNT(B30:B$42)
Dividend $0.0272070 05/02/2022 04/29/2022 04/29/2022 $13.47 =INDEX(GOOGLEFINANCE($A$23, "close", D31), 2, 2) =B31/G31*12 =SUM(B31:B$42)/AVERAGE(G31:G$42)*12/COUNT(B31:B$42)
Dividend $0.0258140 04/01/2022 03/31/2022 03/31/2022 $13.83 =INDEX(GOOGLEFINANCE($A$23, "close", D32), 2, 2) =B32/G32*12 =SUM(B32:B$42)/AVERAGE(G32:G$42)*12/COUNT(B32:B$42)
Dividend $0.0270950 03/01/2022 02/28/2022 02/28/2022 $14.24 =INDEX(GOOGLEFINANCE($A$23, "close", D33), 2, 2) =B33/G33*12 =SUM(B33:B$42)/AVERAGE(G33:G$42)*12/COUNT(B33:B$42)
Dividend $0.0247750 02/01/2022 01/31/2022 01/31/2022 $14.32 =INDEX(GOOGLEFINANCE($A$23, "close", D34), 2, 2) =B34/G34*12 =SUM(B34:B$42)/AVERAGE(G34:G$42)*12/COUNT(B34:B$42)
Dividend $0.0252250 01/03/2022 12/31/2021 12/31/2021 $14.70 =INDEX(GOOGLEFINANCE($A$23, "close", D35), 2, 2) =B35/G35*12 =SUM(B35:B$42)/AVERAGE(G35:G$42)*12/COUNT(B35:B$42)
Dividend $0.0259010 12/01/2021 11/30/2021 11/30/2021 $14.73 =INDEX(GOOGLEFINANCE($A$23, "close", D36), 2, 2) =B36/G36*12 =SUM(B36:B$42)/AVERAGE(G36:G$42)*12/COUNT(B36:B$42)
Dividend $0.0255200 11/01/2021 10/29/2021 10/29/2021 $14.66 =INDEX(GOOGLEFINANCE($A$23, "close", D37), 2, 2) =B37/G37*12 =SUM(B37:B$42)/AVERAGE(G37:G$42)*12/COUNT(B37:B$42)
Dividend $0.0261100 10/01/2021 09/30/2021 09/30/2021 $14.71 =INDEX(GOOGLEFINANCE($A$23, "close", D38), 2, 2) =B38/G38*12 =SUM(B38:B$42)/AVERAGE(G38:G$42)*12/COUNT(B38:B$42)
Dividend $0.0254760 09/01/2021 08/31/2021 08/31/2021 $14.84 =INDEX(GOOGLEFINANCE($A$23, "close", D39), 2, 2) =B39/G39*12 =SUM(B39:B$42)/AVERAGE(G39:G$42)*12/COUNT(B39:B$42)
Dividend $0.0257340 08/02/2021 07/30/2021 07/30/2021 $14.90 =INDEX(GOOGLEFINANCE($A$23, "close", D40), 2, 2) =B40/G40*12 =SUM(B40:B$42)/AVERAGE(G40:G$42)*12/COUNT(B40:B$42)
Dividend $0.0266620 07/01/2021 06/30/2021 06/30/2021 $14.83 =INDEX(GOOGLEFINANCE($A$23, "close", D41), 2, 2) =B41/G41*12 =SUM(B41:B$42)/AVERAGE(G41:G$42)*12/COUNT(B41:B$42)
Dividend $0.0264040 06/01/2021 05/28/2021 05/28/2021 $14.83 =INDEX(GOOGLEFINANCE($A$23, "close", D42), 2, 2) =B42/G42*12 =SUM(B42:B$42)/AVERAGE(G42:G$42)*12/COUNT(B42:B$42)
VWLUX
Type $/Share Payable date Record date Reinvest date Reinvest price Price on record date Distribution yield computed Trailing total/avg, annualized
Dividend $0.0270330 11/01/2022 10/31/2022 10/31/2022 $10.04 =INDEX(GOOGLEFINANCE($A$44, "close", D46), 2, 2) =B46/G46*12 =SUM(B46:B$63)/AVERAGE(G46:G$63)*12/COUNT(B46:B$63)
Dividend $0.0266790 10/03/2022 09/30/2022 09/30/2022 $10.17 =INDEX(GOOGLEFINANCE($A$44, "close", D47), 2, 2) =B47/G47*12 =SUM(B47:B$63)/AVERAGE(G47:G$63)*12/COUNT(B47:B$63)
Dividend $0.0262410 09/01/2022 08/31/2022 08/31/2022 $10.65 =INDEX(GOOGLEFINANCE($A$44, "close", D48), 2, 2) =B48/G48*12 =SUM(B48:B$63)/AVERAGE(G48:G$63)*12/COUNT(B48:B$63)
Dividend $0.0259460 08/01/2022 07/29/2022 07/29/2022 $10.98 =INDEX(GOOGLEFINANCE($A$44, "close", D49), 2, 2) =B49/G49*12 =SUM(B49:B$63)/AVERAGE(G49:G$63)*12/COUNT(B49:B$63)
Dividend $0.0262570 07/01/2022 06/30/2022 06/30/2022 $10.67 =INDEX(GOOGLEFINANCE($A$44, "close", D50), 2, 2) =B50/G50*12 =SUM(B50:B$63)/AVERAGE(G50:G$63)*12/COUNT(B50:B$63)
Dividend $0.0259320 06/01/2022 05/31/2022 05/31/2022 $10.98 =INDEX(GOOGLEFINANCE($A$44, "close", D51), 2, 2) =B51/G51*12 =SUM(B51:B$63)/AVERAGE(G51:G$63)*12/COUNT(B51:B$63)
Dividend $0.0260650 05/02/2022 04/29/2022 04/29/2022 $10.83 =INDEX(GOOGLEFINANCE($A$44, "close", D52), 2, 2) =B52/G52*12 =SUM(B52:B$63)/AVERAGE(G52:G$63)*12/COUNT(B52:B$63)
Dividend $0.0257370 04/01/2022 03/31/2022 03/31/2022 $11.25 =INDEX(GOOGLEFINANCE($A$44, "close", D53), 2, 2) =B53/G53*12 =SUM(B53:B$63)/AVERAGE(G53:G$63)*12/COUNT(B53:B$63)
Dividend $0.0264860 03/01/2022 02/28/2022 02/28/2022 $11.67 =INDEX(GOOGLEFINANCE($A$44, "close", D54), 2, 2) =B54/G54*12 =SUM(B54:B$63)/AVERAGE(G54:G$63)*12/COUNT(B54:B$63)
Dividend $0.0252450 02/01/2022 01/31/2022 01/31/2022 $11.77 =INDEX(GOOGLEFINANCE($A$44, "close", D55), 2, 2) =B55/G55*12 =SUM(B55:B$63)/AVERAGE(G55:G$63)*12/COUNT(B55:B$63)
Dividend $0.0258380 01/03/2022 12/31/2021 12/31/2021 $12.13 =INDEX(GOOGLEFINANCE($A$44, "close", D56), 2, 2) =B56/G56*12 =SUM(B56:B$63)/AVERAGE(G56:G$63)*12/COUNT(B56:B$63)
Dividend $0.0263490 12/01/2021 11/30/2021 11/30/2021 $12.20 =INDEX(GOOGLEFINANCE($A$44, "close", D57), 2, 2) =B57/G57*12 =SUM(B57:B$63)/AVERAGE(G57:G$63)*12/COUNT(B57:B$63)
Dividend $0.0260720 11/01/2021 10/29/2021 10/29/2021 $12.10 =INDEX(GOOGLEFINANCE($A$44, "close", D58), 2, 2) =B58/G58*12 =SUM(B58:B$63)/AVERAGE(G58:G$63)*12/COUNT(B58:B$63)
Dividend $0.0263790 10/01/2021 09/30/2021 09/30/2021 $12.14 =INDEX(GOOGLEFINANCE($A$44, "close", D59), 2, 2) =B59/G59*12 =SUM(B59:B$63)/AVERAGE(G59:G$63)*12/COUNT(B59:B$63)
Dividend $0.0261830 09/01/2021 08/31/2021 08/31/2021 $12.27 =INDEX(GOOGLEFINANCE($A$44, "close", D60), 2, 2) =B60/G60*12 =SUM(B60:B$63)/AVERAGE(G60:G$63)*12/COUNT(B60:B$63)
Dividend $0.0263930 08/02/2021 07/30/2021 07/30/2021 $12.35 =INDEX(GOOGLEFINANCE($A$44, "close", D61), 2, 2) =B61/G61*12 =SUM(B61:B$63)/AVERAGE(G61:G$63)*12/COUNT(B61:B$63)
Dividend $0.0267770 07/01/2021 06/30/2021 06/30/2021 $12.27 =INDEX(GOOGLEFINANCE($A$44, "close", D62), 2, 2) =B62/G62*12 =SUM(B62:B$63)/AVERAGE(G62:G$63)*12/COUNT(B62:B$63)
Dividend $0.0267190 06/01/2021 05/28/2021 05/28/2021 $12.25 =INDEX(GOOGLEFINANCE($A$44, "close", D63), 2, 2) =B63/G63*12 =SUM(B63:B$63)/AVERAGE(G63:G$63)*12/COUNT(B63:B$63)