WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Tax Equivalent Yield

Tax Equivalent Yield

What is Tax Equivalent Yield?

Tax Equivalent Yield means how much yield (pre-tax returns) you would earn if you need to pay taxes on your tax-free investments. This will help you compare the yield between a tax-free investment and a taxed investment, and you would be able to find out whether the taxed investment is a good deal or not.

Tax Equivalent Yield Formula

Here’s the formula –

Tax-Equivalent-Yield-Formula

As you can see, the formula compares between the tax-free yield and the taxed yield. In the formula, there are thus two components.

  • The first component is the tax-free yield. To find out the tax-free yield, all you need to do is to look at the yield of municipal bonds. These bonds are generally issued by the government, and you don’t need to pay any tax for the return you earn from your investment.
  • The second component of the formula is (1 – Tax rate). (1 – Tax rate) would help you find out the yield if it is being taxed. The reason we use this in the denominator is to find out how beneficial it is to invest in taxed investments.

Examples

You can download this Tax Equivalent Yield Excel Template here – Tax Equivalent Yield Excel Template

Mrs. Olivia is new in the investment world. She wants to find out whether she should go for taxed investments or tax-free investments. She finds out that the taxed investments pay out the yield of 12% on an average. On the other hand, tax-free investments pay 8% on average. The prevalent tax rate is 35%. You need to guide Mrs. Olivia by choosing which investment would be more beneficial for her.

By using the formula, we get –

  • Tax Equivalent Yield = Tax Free Yield / (1 – Tax Rate)
  • Or, Tax Yield = 8% / (1 – 35%)
  • Or, Tax Yield = 0.08 / (1 – 0.35)
  • Or, Tax Yield = 0.08 / 0.65 = 0.1230 = 12.3%.

From the above calculation, we are clear that Mrs. Olivia certainly needs to invest in tax-free investments and not taxed investments.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Uses of Tax Yield Equivalent

Investors should use this formula to find out whether it is prudent to pay higher taxes for investing in taxed investments.

Let’s understand this by using a simple example.

Let’s say that Mr. Ramesh has decided to look at both taxed investments and tax-free investments. The idea is to reduce the tax payment as much as he can.

He finds out that the taxed investment offers a 9% yield. And a tax-free investment offers him a 6% yield. And let’s say that the tax rate is 40%.

To find out, he uses the tax yield.

By using the formula, he gets –

  • Tax Yield = Tax Free Yield / (1 – Tax Rate)
  • Or, Tax Yield = 6% / (1 – 40%)
  • Or, Tax Yield = 0.06 / (1 – 0.40)
  • Or, Tax Yield = 0.06 / 0.60 = 0.1 = 10%.

So, Mr. Ramesh finds out that taxed investment isn’t a good deal, and he should go for tax-free investments.

Tax Equivalent Yield Calculator

You can use the following Calculator.

Tax Free Yield
Tax Rate
Tax Equivalent Yield Formula =
 

Tax Equivalent Yield Formula =
Tax Free Yield
=
(1 − Tax Rate)
0
= 0
(1 − 0)

Tax Equivalent Yield Formula in Excel (with excel template)

Let us now do the same example above in Excel.

This is very simple. You need to provide the two inputs of Tax Yield and Tax Rate.

You can easily find out the tax-equivalent in the template provided.

Tax Equivalent Yield in Excel

Tax Equivalent Yield Formula Video

Recommended Articles

This has been a guide to Tax Equivalent Yield and its meaning. Here we discuss the formula to calculate tax-equivalent yield, its uses along with practical examples. Here we also provide you with Tax Yield Equivalent Calculator with a downloadable excel template. Here are the other suggested articles –

  • Equity Multiplier Formula
  • Tax Shield Formula
  • Yield Function in Excel
  • NOPAT
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

WallStreetMojo

Download Tax Equivalent Yield Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More