Software to Track Master Limited Partnership Basis?

Discussion in 'Tax' started by W, Nov 7, 2009.

  1. W

    W Guest

    Is there any Excel template, or commercial software, that would help to
    track cost basis and tax issues related to master limited partnerships? I
    would also like to be able to simulate multi-year holding scenarios and try
    to understand the tax effects in different scenarios.

    In general, if you hold an MLP:

    * The earnings are taxed at your highest marginal tax rate and increase your
    cost basis?
    * The distributions in excess of basis are not taxed and reduce your basis?
    * Any pass through of interest or capital gains is taxed in those income
    categories, but do they also increase your basis?
    * If your cost basis ever goes to zero, then any distributions in excess of
    earnings are taxed as long term capital gains?
    * After several years of holding the investment, with your basis adjusted
    down, when you sell the investment are you paying long term capital gains on
    the sale price minus the adjusted basis?

    Final thought: if the holder is a non US resident:

    * The tax on earnings is at the maximum marginal rate of 35%?
    * Will the MLP withhold that tax for a non US resident automatically, and
    avoid the need to file a tax return?
    * Distributions in excess of basis are not taxed?
    * If the cost basis goes down to zero, then distributions are still not
    taxed (since capital gains is not taxed)?
    * When a non US resident sells the investment after many years, there is no
    tax on gain from the sale price minus the adjusted basis?

    If I had to track multiple positions in such investments, for both US and
    non US residents, it would be nice to have some software that is dedicated
    to that purpose.

    --
    W

    --
    << ------------------------------------------------------- >>
    << The foregoing was not intended or written to be used, >>
    << nor can it used, for the purpose of avoiding penalties >>
    << that may be imposed upon the taxpayer. >>
    << >>
    << The Charter and the Guidelines for submitting posts >>
    << to this newsgroup as well as our anti-spamming policy >>
    << are at www.asktax.org. >>
    << Copyright (2007) - All rights reserved. >>
    << ------------------------------------------------------- >>
     
    W, Nov 7, 2009
    #1
    1. Advertisements

  2. W

    W Guest

    "W" <> wrote in message
    news:...
    > Is there any Excel template, or commercial software, that would help to
    > track cost basis and tax issues related to master limited partnerships?

    I
    > would also like to be able to simulate multi-year holding scenarios and

    try
    > to understand the tax effects in different scenarios.
    >
    > In general, if you hold an MLP:
    >
    > * The earnings are taxed at your highest marginal tax rate and increase

    your
    > cost basis?
    > * The distributions in excess of basis are not taxed and reduce your

    basis?

    This should have read

    "The distributions in excess of *earnings* are not taxed and reduce your
    basis?"

    --
    W

    --
    << ------------------------------------------------------- >>
    << The foregoing was not intended or written to be used, >>
    << nor can it used, for the purpose of avoiding penalties >>
    << that may be imposed upon the taxpayer. >>
    << >>
    << The Charter and the Guidelines for submitting posts >>
    << to this newsgroup as well as our anti-spamming policy >>
    << are at www.asktax.org. >>
    << Copyright (2007) - All rights reserved. >>
    << ------------------------------------------------------- >>
     
    W, Nov 7, 2009
    #2
    1. Advertisements

  3. W

    LoTax Guest

    Template? Commercial software?

    ....to track basis in a partnership...

    A sheet of columnar paper has served me quite well for over fifty
    years. Is there supposed to be something better on the market now?

    --
    << ------------------------------------------------------- >>
    << The foregoing was not intended or written to be used, >>
    << nor can it used, for the purpose of avoiding penalties >>
    << that may be imposed upon the taxpayer. >>
    << >>
    << The Charter and the Guidelines for submitting posts >>
    << to this newsgroup as well as our anti-spamming policy >>
    << are at www.asktax.org. >>
    << Copyright (2007) - All rights reserved. >>
    << ------------------------------------------------------- >>
     
    LoTax, Nov 9, 2009
    #3
  4. W

    DF2 Guest

    In misc.taxes.moderated, LoTax wrote:

    >Template? Commercial software?
    >
    >...to track basis in a partnership...
    >
    >A sheet of columnar paper has served me quite well for over fifty
    >years. Is there supposed to be something better on the market now?


    Yes, there should be. It should be smart enough to generate the
    numbers that would be put onto (or approximate what would go onto)
    your income tax forms if you were to sell now. With the splitting of
    sale proceeds into ordinary income and capital gain/loss it's very
    complex. Reading Instructions for Form 4797 doesn't make things
    clear.

    I suspect that over your 50 years your technique evolved with the
    tax code. I have not seen a clear explanation of what a pencil
    should do to the columnar paper. If you are trying to figure out the
    effect of the sale beforehand, it seems very complex without waiting
    to see what the final K-1 actually looks like.

    --
    << ------------------------------------------------------- >>
    << The foregoing was not intended or written to be used, >>
    << nor can it used, for the purpose of avoiding penalties >>
    << that may be imposed upon the taxpayer. >>
    << >>
    << The Charter and the Guidelines for submitting posts >>
    << to this newsgroup as well as our anti-spamming policy >>
    << are at www.asktax.org. >>
    << Copyright (2007) - All rights reserved. >>
    << ------------------------------------------------------- >>
     
    DF2, Nov 9, 2009
    #4
  5. W

    LoTax Guest

    >>"I have not seen a clear explanation of what a pencil should do to the columnar paper."

    That's where my experience and professional acumen separate me from
    the "tax preparers" who enter numbers into a box and then sell the
    result to their awed clients.

    And you proudly claim to have never found an explanation of how to
    compute the gain or loss on the sale of a partnership interest, an
    explanation that you can understand. Why do you trust the programmer
    of some purchased software to know how to do it *and* to have captured
    that in the software?

    --
    << ------------------------------------------------------- >>
    << The foregoing was not intended or written to be used, >>
    << nor can it used, for the purpose of avoiding penalties >>
    << that may be imposed upon the taxpayer. >>
    << >>
    << The Charter and the Guidelines for submitting posts >>
    << to this newsgroup as well as our anti-spamming policy >>
    << are at www.asktax.org. >>
    << Copyright (2007) - All rights reserved. >>
    << ------------------------------------------------------- >>
     
    LoTax, Nov 10, 2009
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. SteveJ
    Replies:
    0
    Views:
    1,652
    SteveJ
    Jan 12, 2006
  2. Arnie Goetchius
    Replies:
    0
    Views:
    2,003
    Arnie Goetchius
    Mar 12, 2006
  3. Peter
    Replies:
    1
    Views:
    1,037
    R. C. White
    Jan 3, 2004
  4. W
    Replies:
    4
    Views:
    1,280
  5. dman81
    Replies:
    2
    Views:
    1,847
    dman81
    Feb 19, 2010
Loading...

Share This Page