Accountant Forums


Reply
Thread Tools

Software to Track Master Limited Partnership Basis?

 
 
W
Guest
Posts: n/a
Thanked:
 
      11-07-2009, 08:34 PM
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. >>
<< ------------------------------------------------------- >>
 
Reply With Quote
 
 
 
 
W
Guest
Posts: n/a
Thanked:
 
      11-07-2009, 09:52 PM
"W" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed) ...
> 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. >>
<< ------------------------------------------------------- >>
 
Reply With Quote
 
 
 
 
LoTax
Guest
Posts: n/a
Thanked:
 
      11-09-2009, 01:43 PM
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. >>
<< ------------------------------------------------------- >>
 
Reply With Quote
 
DF2
Guest
Posts: n/a
Thanked:
 
      11-09-2009, 04:11 PM
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. >>
<< ------------------------------------------------------- >>
 
Reply With Quote
 
LoTax
Guest
Posts: n/a
Thanked:
 
      11-10-2009, 02:41 PM
>>"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. >>
<< ------------------------------------------------------- >>
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reporting income from a MLP (Master Limited Partnership) income??? dman81 Tax 2 02-19-2010 06:11 AM
Question on Master Limited Partnership W Tax 4 04-06-2009 10:51 PM
K-1 from Master Ltd Partnership 0b3hks001@sneakemail.com Tax 1 03-25-2008 01:00 AM
How to Report Sale of All Units of Master Limited Partnership? Arnie Goetchius Tax 0 03-12-2006 09:06 AM
How do I track this limited partnership?? Peter Quicken 1 01-03-2004 03:13 PM


All times are GMT. The time now is 10:23 PM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.