Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 12-31-2004, 08:33 AM
RalphWDW
Guest
 
Posts: n/a
Default Re: calculation method?? Avg. cost

Is cost basis averaged across accounts in Canadian version of Money 2005? If
so, are there any workarounds? I'm using Money 2004 and wish to avoid
cumbersome side calcs for IRR.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Footman wrote:
> > I don't get how money calculates average cost. Check this out:
> > > I purchased 3000 shares of ABCD for 0.34, then purchased 3000 more shares

> > for 0.335. Each purchase is 29.00 commission (Canada). Money says my
> > average share price is 0.322.
> > > My math says that my average cost should be .347
> > > I'd appreciate any input on this matter.

> Check to see if you have any other holdings of this fund in a
> different account in that Money file. Canada is a special case in
> Money in that it computes the average across accounts. Canada has
> different basis rules. Money is attempting to follow those rules,
> altho it may be averaging too many together in some situations.
> One way to see the transactions for that fund are to go to
> Investment Transactions for that fund by right-clicking a reference
> to that fund and go to the Investment Transactions.

 
Old 11-27-2004, 02:37 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: calculation method?? Avg. cost

In microsoft.public.money, Footman wrote:

- quote -

> I don't get how money calculates average cost. Check this out:
> I purchased 3000 shares of ABCD for 0.34, then purchased 3000 more shares
> for 0.335. Each purchase is 29.00 commission (Canada). Money says my
> average share price is 0.322.
> My math says that my average cost should be .347
> I'd appreciate any input on this matter.


Check to see if you have any other holdings of this fund in a
different account in that Money file. Canada is a special case in
Money in that it computes the average across accounts. Canada has
different basis rules. Money is attempting to follow those rules,
altho it may be averaging too many together in some situations.

One way to see the transactions for that fund are to go to
Investment Transactions for that fund by right-clicking a reference
to that fund and go to the Investment Transactions.


  #-1  
Old 11-27-2004, 01:35 PM
Footman
Guest
 
Posts: n/a
Default calculation method?? Avg. cost

I don't get how money calculates average cost. Check this out:

I purchased 3000 shares of ABCD for 0.34, then purchased 3000 more shares
for 0.335. Each purchase is 29.00 commission (Canada). Money says my
average share price is 0.322.

My math says that my average cost should be .347

I'd appreciate any input on this matter.
Cheers,
CBall
 

Tags
avg, calculation, cost, method
Similar Threads
Thread Forum Replies Last Post
Cost basis calculation is wrong
Andrew: Microsoft Money calculates the cost basis of my shares wrongly. When I multiply the number of shares x purchase price and I add the commissions...
Microsoft Money 3 07-25-2004 05:26 PM
Faulty cost basis calculation
: I just re-installed Money 2003 Delux afyter a hardware problem, and am using a backup copy of the Money file. I hav eone investment that shows the...
Microsoft Money 1 11-10-2003 06:56 PM
Cannot change cost basis calculation method
Paul Galbraith: The online help for Money 2003 says that I should be able to change the method used to calculate the cost basis of a mutual fund. However, when I...
Microsoft Money 1 09-05-2003 08:12 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 02:41 AM.