Tax Equivalent Yield Calculator For Savings Bonds, Treasury Bills, and Tax-Exempt Money Market Funds
There are many investments out there that are exempt from certain taxes. For example, U.S. Savings Bonds and Treasury Bonds are exempt from state and local income taxes. In addition, there are money market funds available that are exempt from federal income tax and others that are even exempt from a specific state or city’s income taxes.
Therefore, it is desirable to know what the equivalent fully-taxable rate is for one of these investments. For example, is it more profitable to earn a federal tax-exempt interest rate of 3.8% or a fully taxable 5.0%? How about a Treasury Bill paying 4.8%? Several variables affect this rate, including your marginal tax brackets for each area, as well as if you itemize your state and local taxes on your federal tax return. I could not find a calculator that accurately captured all of this, so I made my own.
Example
Let’s say you live in California, and your marginal federal tax rate is 25%, your state rate is 9.3%, and you have no local income taxes. You do not itemize your taxes. You are trying to compare the taxable Vanguard Prime Money Market Fund (VMMXX, yielding 5.08%), the federally exempt Vanguard Tax-Exempt Money Market Fund (VMSXX, yielding 3.48%), and the state and federal tax-exempt Vanguard California Tax-Exempt Money Market Fund (VCTXX, yielding 3.38%).
With that profile, the tax equivalent 7-day yields would be 4.804% for VMSXX, and 5.145% for VCTXX, making the California Tax-Exempt Fund the best bet currently for this specific situation.
How It Works (Warning: Math Ahead!)
The calculator computes the tax-equivalent rates by comparing after-tax returns. That is:
Using the California Tax-Exempt Fund example above:
So earning 3.38% free from federal and state taxes is the same as earning 5.145% in a fully taxable account.
Note that itemizing deductions means that you deduct your state income taxes from your federal taxable income. The effect is that your overall tax liability is reduced, which lowers the benefit of any tax-exemptions and thus the equivalent rates. That would change the previous equation to:
The inclusion of this option may give different results from some of the other online calculators out there, but I believe it makes the results more complete. Another fully-worked-out example can be found here for savings bonds.
Finally, it may be handy to use this in conjunction with my Ultimate Interest Rate Chaser Calculator. Be sure to compare APRs to APRs and APYs to APYs.
Useful Resources
2007 Federal Tax Rates
State Income Tax Rates
Recent Treasury Bill Auction Results
Savings Bonds Rates
Find more in Banking, Savings Bonds, Tools & Calculators, Treasury Bills and Bonds | 3/13/07, 8:45pm | Trackback
March 14th, 2007 at 2:51 am
Have you had to deal with how you handle these with your taxes yet? I have my 1099, but I am assuming somewhere on your state return you deal with this correct?
March 14th, 2007 at 10:32 am
I dealt with it last year, as I recall there are simply different portions of the 1099s that indicate in which areas they are exempt from taxes.
March 14th, 2007 at 12:03 pm
Don you still have your T-bill ladder?
March 14th, 2007 at 5:44 pm
[...] showing a 5.267% investment rate. Using my 28-Day T-Bill Equivalent-APY calculator with my new Tax Equivalent Yield Calculator, along with an assumed 25% federal/9% state tax bracket, that is the equivalent of a taxable [...]
March 15th, 2007 at 1:42 pm
Love the calculator, with one request: could you increase the size of the little windows? On my mac, I can only view about one digit at a time. It may be a Mac/PC text size thingy. Now if you could only help me know how much tax-free money I can earn without triggering AMT, I’d be eternally greatful.
March 22nd, 2007 at 5:37 pm
Your calculator doesn’t seem to work for your example of 5.376apy, 28% fed, and 9% tax. The calculator gives 6.144% when it should be 5.908% (you were off by 1 basis pt in the example in your blog, perhaps from rounding). It should simply be Eqiv rate = Tbill rate/ (1- state tax). Since Tbills are subject to federal taxes, they don’t factor into the calculation at all. Am i missing something?
March 22nd, 2007 at 9:53 pm
I’ve seen that formula, but it really only works well if you are subject to, and exempt, from one tax (like federal tax). The effect of taxes also changes if you itemize and deduct your state income taxes paid from your income. Please see the “How It Works” section above for the derivation of the formula that I use.
My example was 5.367 (not 5.376), 28% fed, 9% tax, plus “yes” on itemizing – which still gives me 5.898%.
March 23rd, 2007 at 1:56 pm
5.367. You’re right. I did look at the how it works section, but even using 5.367 doesn’t get you the right number using the calculator.
Btw, your formula simplifies to mine for Tbills.
TR = ER x (1-F-S+FS)/(1-F)
= ER x [(1-F)+(-S+FS)]/(1-F)
= ER x [1 + S x (-1+F)/(1-F)]
= ER x (1-S)
hence, ER = TR/(1-S)
Basically the Federal tax cancels out as it should.
My real question is whether the calculator on this page is based on a different formula.
Thanks.
March 23rd, 2007 at 2:48 pm
Yes, if you itemize, the state tax cancels out. If you don’t itemize, it doesn’t cancel out.
Using your formula, which is the same as the calculator formula, you get
5.367 / (1-.09) = 5.367 / .91 = 5.898%.
I’m confused – doesn’t that agree with what I wrote previously?
April 9th, 2007 at 10:14 am
I guess I have the same question as rob. 5.898 is the correct equivalent yield using that formula, but that formula is for NON-itemized. If you were to itemize, wouldn’t it be:
5.367 / (1-.09 +.28*.09) = 5.739
Your calculator appears to give the non-itemized result when itemized is selected, and some other number (6.134) when non-itemized is selected. Perhaps you could explain how you are getting that number.
April 17th, 2007 at 8:31 am
Jonathan???
April 19th, 2007 at 7:53 am
Sorry, Jonathan. I looked at your javascript and found my mistake.
August 22nd, 2007 at 3:13 pm
the buttons are backwards for state and federal tax exemptions.
August 22nd, 2007 at 5:31 pm
backwards?
December 11th, 2007 at 10:08 am
FYI – you calculator is wrong. If you are subject to both State and Federal, you do not simply divide by 1- the sum of Fed and State. Who know how many people you haev mislead. Please correct
December 12th, 2007 at 6:52 pm
What is the correct answer, Tim?
March 23rd, 2008 at 6:30 am
[...] Interest from savings bonds are subject to federal income tax, but are exempt from local and state income taxes. For people that live in states with high income taxes, this can make them more attractive. They also have some special exemptions when used for educational purposes. See this Tax-equivalent Yield Calculator. [...]
November 4th, 2008 at 6:14 am
[...] an effective 3.54% APY for the minimum 11-month hold. Even if this is exempt from state taxes, the tax-equivalent yield won’t be far above 4%. You can do better with bank [...]
June 15th, 2009 at 10:13 pm
[...] Tax Equivalent Yield Calculator Find your true interest rate after you factor in your tax rate using this calculator. [...]