How to calculate average maturity including cash?

Discussion of the Bond portion of the Permanent Portfolio

Moderator: Global Moderator

thisisallen
Senior Member Posts: 106
Joined: Sat Sep 24, 2016 5:39 pm
Location: NJ and India

How to calculate average maturity including cash?

Sometimes a person will post that they are using/including cash in their calculation of the average maturity of the bond portion of the PP. For example, the person says that he has a barbell of LTT and cash that equals a intermediate term bond maturity. Is there a formula to calculate the average maturity when cash, having a maturity of 0, is included?

This is from Investopedia:
“How Weighted Average Maturity Is Computed
Assume, for example, that an investor owns a \$30,000 portfolio, which includes three bond holdings. Bond A is a \$5,000 bond (16.7% of the total portfolio) and matures in 10 years, and bond B is a \$10,000 investment (33.3%) that matures in six years. The investor also owns bond C, a \$15,000 bond (50%) with a maturity of four years. To compute WAM, each of the percentages is multiplied by the years until maturity, so the investor can use this formula: (16.7% X 10 years) + (33.3% X 6 years) + (50% X 4 years) = 5.67 years, or about five years, eight months.”

If a % of cash is used in the formula then that part of the formula will always be 0. In that case the average maturity will no5 be calculated properly, would it?

Is the question clear?
ochotona
Executive Member Posts: 2463
Joined: Fri Jan 30, 2015 5:54 am

Re: How to calculate average maturity including cash?

My understanding is that you care about duration, not maturity. They are related but not the same. Furthermore, my understanding is that you can take a weighted average of durations to find the bond portfolio duration. Duration of bond funds is published by the issuers.
buddtholomew
Executive Member Posts: 2048
Joined: Fri May 21, 2010 4:16 pm

Re: How to calculate average maturity including cash?

Yes, TLT publishes effective duration daily on iShares.com

Use this formula to calculate weighted duration (% of total * duration). For example:

TLT - \$1500, duration 17.40
Cash - \$3500, duration 0 (cash has 0 duration in my calcs)
Total - \$5000

TLT = \$1500/\$5000 or .30*17.40 = 5.22
Cash = \$3500/\$5000 or .70*0 = 0 (yes x*0 = 0)

5.22 + 0 = 5.22 (weighted duration)
Or
5.22 + .7 = 5.92 (if you assign cash a duration of 1.00)
Xan Posts: 2162
Joined: Tue Mar 13, 2012 1:51 pm

Re: How to calculate average maturity including cash?

Allen,

I believe maturity would be calculated correctly if you used zero in the formula you gave. You're right that "that part" of the formula will always be zero, but the amount that's zero will be the percentage of your portfolio that's in cash. That's exactly what you're looking for!
thisisallen
Senior Member Posts: 106
Joined: Sat Sep 24, 2016 5:39 pm
Location: NJ and India

Re: How to calculate average maturity including cash?

Many thx for the replies and understandings and example.

Fortunately iShares provides the duration of TLT at their site. I have individual bonds so a special formula is required for calculating the duration of a single bond. I saw that there are online calculators for this and it can likely be done in Excel.

Thx again