Is there a function on Excel--Vista--where I can compare the interest rates
(coupon rate) on tax free municipal bonds vs taxable corporate bonds?

Thanks

One of two ways:

1) simply divide the tax-exempt rate by (1-effective tax rate), to make it
taxable equivalent, or
2) multiply the the taxable rate by (1-effective tax rate), to make it
after-tax

Effective tax rate means the total of your marginal Federal, state, and
local income tax rates. Keep in mind that some tax-exempt bonds are only
Federally exempt, others are Federally AND State exempt, and a few are triple
tax-exempt - Fed/State/local. Typically, the more 'exempt' a bond is, the
lower its coupon


"Vince" wrote:


Is there a function on Excel--Vista--where I can compare the interest rates
(coupon rate) on tax free municipal bonds vs taxable corporate bonds?

Thanks

Is there a function on Excel--Vista--where I can compare the interest
rates (coupon rate) on tax free municipal bonds vs taxable corporate
bonds?

One of two ways:

1) simply divide the tax-exempt rate by (1-effective tax rate), to
make it taxable equivalent, or
2) multiply the the taxable rate by (1-effective tax rate), to make it
after-tax

Effective tax rate means the total of your marginal Federal, state,
and local income tax rates. Keep in mind that some tax-exempt bonds
are only Federally exempt, others are Federally AND State exempt, and
a few are triple tax-exempt - Fed/State/local. Typically, the more
'exempt' a bond is, the lower its coupon

Also keep in mind:

Treasury security interest is taxable federally, but not by the state
(these securities weren't mentioned in the original post).

Interest on out-of state municipal bonds is taxed by the state (at least
here in California).

The state income tax paid on corporate bond interest is deductible on one's
federal return, slightly reducing the effective federal tax rate.

I know: picky, picky. ;-)