Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #7  
Old 01-07-2004, 03:10 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Incorrect Profit Calculation of Stock Sale

In microsoft.public.money, Jeff wrote:

- quote -

> I appreciate your assistance! I was successful in getting
> the desired results.


Good to hear.

- quote -

> By chance, is there a way to set the
> Investment Details default to be the Actual Cost Basis?
> That would be nice. The default currently seems to be the
> Double Cost Averaging.


No, but changing it is not that hard. It is not as if you buy
different funds every day. While looking at the details of one
security, you can choose the details for another security by using
the drop-down down-arrow to the left of the big blue investment name
heading.


  #6  
Old 01-07-2004, 12:53 PM
Jeff
Guest
 
Posts: n/a
Default Re: Incorrect Profit Calculation of Stock Sale


- quote -

> -----Original Message-----
> In microsoft.public.money, Jeff wrote:
> > > > My expectation was to use the actual cost basis. How do

I
> > accomplish this with mutual funds in Money.

> In the investment details choose Cost Basis: Actual Cost

Basis. Then
> Reallocate Lots. I believe had said that.
> To Reallocate Lots, right-click the Sell transaction.
> .



I appreciate your assistance! I was successful in getting
the desired results. By chance, is there a way to set the
Investment Details default to be the Actual Cost Basis?
That would be nice. The default currently seems to be the
Double Cost Averaging.
  #5  
Old 01-06-2004, 07:03 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Incorrect Profit Calculation of Stock Sale

In microsoft.public.money, Jeff wrote:

- quote -

> My expectation was to use the actual cost basis. How do I
> accomplish this with mutual funds in Money.


In the investment details choose Cost Basis: Actual Cost Basis. Then
Reallocate Lots. I believe had said that.

To Reallocate Lots, right-click the Sell transaction.
  #4  
Old 01-06-2004, 06:30 PM
Jeff
Guest
 
Posts: n/a
Default Re: Incorrect Profit Calculation of Stock Sale


- quote -

> -----Original Message-----
> In microsoft.public.money,

<anonymous[at]discussions.microsoft.com> wrote:
> > > > > Answers to your questions:

> > 1. As I recall, the additional purchases were more
> > expensive.

> Now that does not fit my hypothesis. I was postulating

that the
> other purchases were cheaper bringing down your average

to the
> number Money was using.
> > > 2. Yes, I do live in the US (midwest) and bought it from

> > an Office Supply chain store.

> The basis rules are country-specific.
> > > 3. Yes, you are correct that this is a stock mutual

fund.
> > What difference does this make for Money?

> Only funds use single or double basis averaging. Stocks

use actual
> cost always.
> > > 4. This was the first sale from this fund. I don't

recall
> > seeing the term Actual Cost Basis during the entry of

this
> > sale. What are the other options and when should I

expect
> > to select this option. I know from the IRS rules, one
> > should not change the cost basis of sales. Are there
> > other rules you are referencing?

> The US permits single or double basis averaging for

funds. Most
> people use single basis for simplicity. Some get that

info from
> their fund companies. It sounds as if you will want to

use actual
> cost basis.
> .


My expectation was to use the actual cost basis. How do I
accomplish this with mutual funds in Money.
  #3  
Old 01-06-2004, 05:56 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Incorrect Profit Calculation of Stock Sale

In microsoft.public.money, <anonymous[at]discussions.microsoft.comwrote:

- quote -

> > Answers to your questions:
> 1. As I recall, the additional purchases were more
> expensive.


Now that does not fit my hypothesis. I was postulating that the
other purchases were cheaper bringing down your average to the
number Money was using.

- quote -

> 2. Yes, I do live in the US (midwest) and bought it from
> an Office Supply chain store.


The basis rules are country-specific.

- quote -

> 3. Yes, you are correct that this is a stock mutual fund.
> What difference does this make for Money?


Only funds use single or double basis averaging. Stocks use actual
cost always.


- quote -

> 4. This was the first sale from this fund. I don't recall
> seeing the term Actual Cost Basis during the entry of this
> sale. What are the other options and when should I expect
> to select this option. I know from the IRS rules, one
> should not change the cost basis of sales. Are there
> other rules you are referencing?


The US permits single or double basis averaging for funds. Most
people use single basis for simplicity. Some get that info from
their fund companies. It sounds as if you will want to use actual
cost basis.

  #2  
Old 01-06-2004, 05:48 PM
Guest
 
Posts: n/a
Default Re: Incorrect Profit Calculation of Stock Sale


- quote -

> -----Original Message-----
> In microsoft.public.money, Jeff wrote:
> > > In this example, there is a difference in the computed

> > cost ($9,480) versus the actual cost of ($10,000)
> > > What can I do about this?

> May we assume that
> you have more (cheaper) purchases that you did not show?
> you are in the US?
> this is a mutual fund and not a stock?
> in the account details for the fund your Cost Basis is

NOT set to
> Actual Cost Basis?
> You could set things up for Actual Cost Basis and

Reallocate Lots if
> this is your first sale of that fund. Otherwise you are

required to
> stick with the averaging method, if I read the rules

correctly.
> .

Answers to your questions:
1. As I recall, the additional purchases were more
expensive.

2. Yes, I do live in the US (midwest) and bought it from
an Office Supply chain store.

3. Yes, you are correct that this is a stock mutual fund.
What difference does this make for Money?

4. This was the first sale from this fund. I don't recall
seeing the term Actual Cost Basis during the entry of this
sale. What are the other options and when should I expect
to select this option. I know from the IRS rules, one
should not change the cost basis of sales. Are there
other rules you are referencing?
  #1  
Old 01-06-2004, 03:17 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Incorrect Profit Calculation of Stock Sale

In microsoft.public.money, Jeff wrote:


- quote -

> In this example, there is a difference in the computed
> cost ($9,480) versus the actual cost of ($10,000)
> What can I do about this?


May we assume that

you have more (cheaper) purchases that you did not show?

you are in the US?

this is a mutual fund and not a stock?

in the account details for the fund your Cost Basis is NOT set to
Actual Cost Basis?



You could set things up for Actual Cost Basis and Reallocate Lots if
this is your first sale of that fund. Otherwise you are required to
stick with the averaging method, if I read the rules correctly.

 
Old 01-06-2004, 02:19 PM
Jeff
Guest
 
Posts: n/a
Default Incorrect Profit Calculation of Stock Sale

Sorry for the previous incomplete post.


Just started using Money 2003 last year. I was attempting
to get the profit of a couple of stock sales I made last
year in support of preparing my tax return. When entering
the sale, I specified the shares as the original purchased
shares. The situation is similar to the following:

DATE TRANSACTION SHARES COST/SHARE TOTAL
02-02-2001 BUY 2,500 4.00 10,000
12-15-2001 Reinvest Div 50 4.50 225
12-01-2003 SELL 1,000 5.00 5,000
12-10-2003 SELL 1,000 5.10 5,100
12-15-2003 SELL 500 5.00 2,500

The Tax Report-Capital Gains for the Previous Year
indicates the following:

DATE TRANSACTION SHARES TOTAL COST PROFIT
12-01-2003 SELL 1,000 5,000 3,750 1,250
12-10-2003 SELL 1,000 5,100 3,750 1,350
12-15-2003 SELL 500 2,500 1,980 520
TOTAL 2,500 12,600 9,480 3,120

In this example, there is a difference in the computed
cost ($9,480) versus the actual cost of ($10,000)

What can I do about this?







  #-1  
Old 01-06-2004, 02:00 PM
Jeff
Guest
 
Posts: n/a
Default Incorrect Profit Calculation of Stock Sale

Just started using Money 2003 last year. I was attempting
to get the profit of a couple of stock sales I made last
year in support of preparing my tax return. The situation
is similar to the following:

DATE SHARES COST/SHARE TOTAL
2-2-2001
 

Tags
calculation, incorrect, profit, sale, stock
Similar Threads
Thread Forum Replies Last Post
Profit & Loss Statement
Stuck: I just want to print a simple profit and loss statement. Surley money can do this function with a click
Microsoft Money 1 10-27-2003 06:57 PM
Delete stock pricing after sale?
Pat: Hi, I am unable to remove a stock from the "update stock prices" list, even after it is sold and zero balance. The stock is gone from my...
Microsoft Money 1 08-29-2003 11:57 PM



Thread Tools
Display Modes

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 Off
Refbacks are Off

All times are GMT. The time now is 06:38 AM.