Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 05-02-2006, 01:25 PM
CU879
Guest
 
Posts: n/a
Default RE: Average Cost in Multi-Currency Investments Accounts


It looks like the designers did not give any thought to this issue at all.
I have the same issue, but I noticed that in some cases it calculates the
revenue based on historical exchange rates, and in other cases it does it in
the original currency without converting. The last case is probably when the
transaction was downloaded automatically, and no exchange rate was recorded
with it. I even managed to "ruin" this cases by re-entering the transaction
manually.
Here is how Microsoft should have designed it:
- If the transaction/investment is in a foreign currency, but the account is
in local currency, than all transactions should be calculated at the local
currency by using the historical exchange rate.
- If the transaction/investment is in foreign currency, and the account is
in foreign currency than all transactions should be shown and calculated in
their original foreign currency values. Only when preparing the tax report,
and assuming that the tax report is in the local currency, each transaction
should be presented at the local currency value based on the historic
exchange rate. If the tax report is in foreign currency (probably done for
paying taxed abroad) than – even then the values should be left at the
original foreign currency values.
I hope someone from the Microsoft Money development team reads this, and
implements my suggestion.

"Fads":

- quote -

> I am using Money 2005 (US Version). I am using the base currency as the US
> Dollar. I have 2 investment accounts which are USD & Euro.
> I have several transaction in both accounts that include Stock, Mutual
> Funds, & Other investments.
> The problem is reporting the average cost of the Euro denominated
> investments. When i recorded a Euro stock i have also recorded the Euro
> Exchange Rate at that time ( as an example, in december 2003 Buy 100 shares
> at Euro 10 - exchange rate 1.1)... The pertfolio manager indicates that the
> average cost of this investment is 9.24 Euro, and not 10 Euro.... It seems
> that the Portfolio manager is also considering the gain in the exchange rate
> (The euro was at 1.1 in 2003 and is 1.19 now) as part pf the average cost...
> The problem is that i want to keep the exchange rate profit/loss seperate...
> Each of the investment account is independent.... i tried to fix it in the
> Portfolio Manager setting (extend the value of the transaction in the
> investment currency) but it does not make any difference...
> Is there a way to fix this?
> Thanx for any suggestion or help...

  #1  
Old 02-10-2006, 02:31 PM
Marilyn & Bob
Guest
 
Posts: n/a
Default Re: Average Cost in Multi-Currency Investments Accounts

I haven't thought this out, but it seems to me the only workaround would be
keep your Euro denominated investments also in dollars, without any
conversion (i.e. pretend they are in dollars, not Euros and ?1= $1). This
should work for all calculations internal to the investments. For your net
worth reports (in real $), you could exclude these accounts and include a
separate asset account that you manually set to the real dollar value of
your Euro investments each time you run your Net worth report. Or you could
keep two parallel accounts (one with the real conversion value and one with
fixed 1:1 conversion) and selectively use one or the other for the relevant
reports.

[Note, if this makes no sense, please refer to the first five words of this
post].
--
Peace,
BobJ

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:eIaLctkLGHA.1532[at]TK2MSFTNGP12.phx.gbl...
- quote -

> I haven't played with this, but I suspect there is no easy way around what
> you are seeing. I suspect that what you are seeing is a result of it
> converting the individual transactions to the default currency (dollars)
> and then converting the average dollar cost back to Euros to display it.
> Money's model for multi-currency support appears to be very simplistic.
> "Fads" <Fads[at]discussions.microsoft.com> wrote in message
> news:3A5CF7E5-6826-4B42-9607-37944D38162A[at]microsoft.com...
> > I am using Money 2005 (US Version). I am using the base currency as the
> > US
> > Dollar. I have 2 investment accounts which are USD & Euro.
> > > I have several transaction in both accounts that include Stock, Mutual

> > Funds, & Other investments.
> > > The problem is reporting the average cost of the Euro denominated

> > investments. When i recorded a Euro stock i have also recorded the Euro
> > Exchange Rate at that time ( as an example, in december 2003 Buy 100
> > shares
> > at Euro 10 - exchange rate 1.1)... The pertfolio manager indicates that
> > the
> > average cost of this investment is 9.24 Euro, and not 10 Euro.... It
> > seems
> > that the Portfolio manager is also considering the gain in the exchange
> > rate
> > (The euro was at 1.1 in 2003 and is 1.19 now) as part pf the average
> > cost...
> > > The problem is that i want to keep the exchange rate profit/loss

> > seperate...
> > Each of the investment account is independent.... i tried to fix it in
> > the
> > Portfolio Manager setting (extend the value of the transaction in the
> > investment currency) but it does not make any difference...
> > > Is there a way to fix this?


 
Old 02-10-2006, 01:05 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Average Cost in Multi-Currency Investments Accounts

I haven't played with this, but I suspect there is no easy way around what
you are seeing. I suspect that what you are seeing is a result of it
converting the individual transactions to the default currency (dollars) and
then converting the average dollar cost back to Euros to display it. Money's
model for multi-currency support appears to be very simplistic.

"Fads" <Fads[at]discussions.microsoft.com> wrote in message
news:3A5CF7E5-6826-4B42-9607-37944D38162A[at]microsoft.com...
- quote -

> I am using Money 2005 (US Version). I am using the base currency as the US
> Dollar. I have 2 investment accounts which are USD & Euro.
> I have several transaction in both accounts that include Stock, Mutual
> Funds, & Other investments.
> The problem is reporting the average cost of the Euro denominated
> investments. When i recorded a Euro stock i have also recorded the Euro
> Exchange Rate at that time ( as an example, in december 2003 Buy 100
> shares
> at Euro 10 - exchange rate 1.1)... The pertfolio manager indicates that
> the
> average cost of this investment is 9.24 Euro, and not 10 Euro.... It seems
> that the Portfolio manager is also considering the gain in the exchange
> rate
> (The euro was at 1.1 in 2003 and is 1.19 now) as part pf the average
> cost...
> The problem is that i want to keep the exchange rate profit/loss
> seperate...
> Each of the investment account is independent.... i tried to fix it in the
> Portfolio Manager setting (extend the value of the transaction in the
> investment currency) but it does not make any difference...
> Is there a way to fix this?



  #-1  
Old 02-10-2006, 07:17 AM
Fads
Guest
 
Posts: n/a
Default Average Cost in Multi-Currency Investments Accounts

I am using Money 2005 (US Version). I am using the base currency as the US
Dollar. I have 2 investment accounts which are USD & Euro.

I have several transaction in both accounts that include Stock, Mutual
Funds, & Other investments.

The problem is reporting the average cost of the Euro denominated
investments. When i recorded a Euro stock i have also recorded the Euro
Exchange Rate at that time ( as an example, in december 2003 Buy 100 shares
at Euro 10 - exchange rate 1.1)... The pertfolio manager indicates that the
average cost of this investment is 9.24 Euro, and not 10 Euro.... It seems
that the Portfolio manager is also considering the gain in the exchange rate
(The euro was at 1.1 in 2003 and is 1.19 now) as part pf the average cost...

The problem is that i want to keep the exchange rate profit/loss seperate...
Each of the investment account is independent.... i tried to fix it in the
Portfolio Manager setting (extend the value of the transaction in the
investment currency) but it does not make any difference...

Is there a way to fix this?

Thanx for any suggestion or help...

 

Tags
accounts, average, cost, investments, multicurrency
Similar Threads
Thread Forum Replies Last Post
Multi-Currency Investment Accounts!
Fads: I am using Money 2005 (US Version). I am using the base currency as the US Dollar. I have 2 investment accounts which are USD & Euro. I have...
Microsoft Money 1 02-10-2006 02:27 AM
weighted average cost
Thomas: My home page shows that one of my investments is 'the poorest performing investment in your portfolio. It's down 84.88% from a weighted average...
Microsoft Money 2 01-16-2004 12:58 PM
weighted cost average
Brian Jusseaume: Good evening all, Question concerning Money's investment reports. I used the add shares function to enter some older investments that I had. I...
Microsoft Money 2 10-05-2003 02:10 AM



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 04:41 PM.