Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #24  
Old 07-26-2007, 03:58 AM
honka
Guest
 
Posts: n/a
Default Re: Problems with cost basis

I don't expect Roshlin is reading this, but I'm having the same problem in
Money 2005.
I have one purchase in a mutual fund and even when I enter today's date and
1500 units at $3, it shows an average cost of $2.91 and a gain of $128.56. I
have entered 0% commission and the investment is tax exempt. My base
currency is US$ but the investment is in Australian $'s. However, the
problem is not just an exchange rate difference as the current rate is about
A$1=US$0.85 and that ratio doesn't explain the difference.
  #23  
Old 07-12-2007, 10:40 AM
DB Rusted
Guest
 
Posts: n/a
Default Re: Problems with cost basis

Sad to say, I don't think MSN Money has figured out that a cost in a currency
needs to stay at that cost in that currency. Conversions can be done for
market values or for gain/loss calculations. Multiple currencies are
challenging enough without added difficulties from software.

"Chris Cowles" wrote:

- quote -

> "Roshlin" <Roshlin[at]discussions.microsoft.com> wrote in message
> news:0C6242F8-B7B1-4512-A7A3-3091FB8B30CA[at]microsoft.com...
> > > What I realize is that I have this problem when the purchase is in another

> > currency that ?uro my default currency.
> > > I tried the same opertaion with 2000? on different dates and it works

> > well.
> > > I would really like to use the other currencies as well, thats why I'm

> > trying to use money. And the exchange rate has to do something with the
> > gain
> > or loss the money is showing.

> Not having investments denominated in anything but USD, I've never played
> with that. But I think Money always expresses returns in terms of the native
> currency. Considering that, does it explain the difference?
> --
> Chris Cowles
> Gainesville, FL

  #22  
Old 03-29-2006, 04:39 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Problems with cost basis

In microsoft.public.money, Roshlin wrote:

- quote -

> I guess I'll have to reinstall Money and give it a fresh start, if you have
> any better suggeston please let me know, it'll save my weekend ;-)
> Thanks for your time


Sorry I did not respond earlier. I suggest creating a new test file
and see if you reproduce the symptom there. The difference could be
in our versions, or my test could have been faulty.
  #21  
Old 03-22-2006, 08:56 PM
Roshlin
Guest
 
Posts: n/a
Default Re: Problems with cost basis

Hi Cal Learner--,

I guess I'll have to reinstall Money and give it a fresh start, if you have
any better suggeston please let me know, it'll save my weekend ;-)
Thanks for your time

"Cal Learner-- MVP" escribió:

- quote -

> In microsoft.public.money, Roshlin wrote:
> > Hi Cal Learner,
> > > 1. base currency euro and country spain

> > 2. account currency US$
> > 3. Investment symbol, currency, US$, if you me type and Cd, stock , bond all
> > give the same problem
> > 4. Investment country US
> > and I have put tax exempt to simplify

> I tried to replicate the problem with a buy using today's date. I
> could not. I set up a file in US Money 2006, with Euro base
> currency, but US$ account and US security. The performance view just
> showed that I was down by the amount of the commission.
> > > Thanks
> > > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, Roshlin wrote:
> > > > > > > > > Hi Cal Learner,
> > > > Thanks for your interest,
> > > > The last price is 15$, qty is 199, market value is 2985$, till here perfect
> > > > (+15$ commision would give the 3000) and GAIN is 755.14 HOW???????
> > > > > > > CLICKING + activity buy, price 15, qty 199, amount 3.000,00 US$ (EVERYTHING
> > > > PERFECT)
> > > > > > > I removed the cost basis column in the valuation view now it doesn't show
> > > > the cost basis but values for gain don't change , as espected.
> > > > > > > Really can't figure out what could be causing this. Please help
> > > > > If I try to replicate this,
> > > > > 1. What is the base currency?
> > > > > 2. What is the "account currency"? You can find that in the account
> > > settings.
> > > > > 3. What is the investment symbol?
> > > > > 4. What is the investment "country/region"? You can find that in the
> > > Details for the investment.
> > > > > > > > > > > > > > > > Thanks
> > > > "Cal Learner-- MVP" wrote:
> > > > > > > > In microsoft.public.money, Roshlin wrote:
> > > > > > > > > > I've done it the way Arthur sugested , making a cash transaction and the
> > > > > > transferring to the investment
> > > > > > And it does it with any type of investment. even with stock
> > > > > > It has to do ith the exchange rates in the cost basis.
> > > > > > Just to try different values, I made a cash deposit of 3000$ today, and
> > > > > > bought a stock, 199 [at] 15$ each and 15$ commision, and it is showing me a
> > > > > > gain of $755.14.
> > > > > > > > > You are looking at the Portfolio Manager. What does the LastPrice
> > > > > column indicate? Is there a symbol in front of the price? If so,
> > > > > what is it?
> > > > > > > > > Click the [+] in front of the investment name to expand the
> > > > > transactions. What does it show for the Amount? What is the symbol
> > > > > in front of the amount?
> > > > > > > > > > > > > > > > > > In the valuation view I can see that the difference comes from the cost
> > > > > > basis field whis is showing 2229.86 + 15$ of commission and you get the
> > > > > > difference.
> > > > > > Why is the cost basis showing the figure, when I have just made the purchase
> > > > > > today and the exchange rate has not changed. I even checked the value in
> > > > > > euros for this transaction is 2473,61 which has nothing to do with the
> > > > > > figure in the cost basis.
> > > > > > > > > > > Is there any way to desavtivate the cost basis feature
> > > > > > > > > You could remove the Cost Basis column by customizing any view.
> > > > > >
  #20  
Old 03-22-2006, 04:27 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Problems with cost basis

In microsoft.public.money, Roshlin wrote:

- quote -

> Hi Cal Learner,
> 1. base currency euro and country spain
> 2. account currency US$
> 3. Investment symbol, currency, US$, if you me type and Cd, stock , bond all
> give the same problem
> 4. Investment country US
> and I have put tax exempt to simplify


I tried to replicate the problem with a buy using today's date. I
could not. I set up a file in US Money 2006, with Euro base
currency, but US$ account and US security. The performance view just
showed that I was down by the amount of the commission.




- quote -

> Thanks
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Roshlin wrote:
> > > > > > Hi Cal Learner,
> > > Thanks for your interest,
> > > The last price is 15$, qty is 199, market value is 2985$, till here perfect
> > > (+15$ commision would give the 3000) and GAIN is 755.14 HOW???????
> > > > > CLICKING + activity buy, price 15, qty 199, amount 3.000,00 US$ (EVERYTHING
> > > PERFECT)
> > > > > I removed the cost basis column in the valuation view now it doesn't show
> > > the cost basis but values for gain don't change , as espected.
> > > > > Really can't figure out what could be causing this. Please help
> > > If I try to replicate this,
> > > 1. What is the base currency?
> > > 2. What is the "account currency"? You can find that in the account

> > settings.
> > > 3. What is the investment symbol?
> > > 4. What is the investment "country/region"? You can find that in the

> > Details for the investment.
> > > > > > > > > Thanks
> > > "Cal Learner-- MVP" wrote:
> > > > > > In microsoft.public.money, Roshlin wrote:
> > > > > > > > I've done it the way Arthur sugested , making a cash transaction and the
> > > > > transferring to the investment
> > > > > And it does it with any type of investment. even with stock
> > > > > It has to do ith the exchange rates in the cost basis.
> > > > > Just to try different values, I made a cash deposit of 3000$ today, and
> > > > > bought a stock, 199 [at] 15$ each and 15$ commision, and it is showing me a
> > > > > gain of $755.14.
> > > > > > > You are looking at the Portfolio Manager. What does the LastPrice
> > > > column indicate? Is there a symbol in front of the price? If so,
> > > > what is it?
> > > > > > > Click the [+] in front of the investment name to expand the
> > > > transactions. What does it show for the Amount? What is the symbol
> > > > in front of the amount?
> > > > > > > > > > > > > > In the valuation view I can see that the difference comes from the cost
> > > > > basis field whis is showing 2229.86 + 15$ of commission and you get the
> > > > > difference.
> > > > > Why is the cost basis showing the figure, when I have just made the purchase
> > > > > today and the exchange rate has not changed. I even checked the value in
> > > > > euros for this transaction is 2473,61 which has nothing to do with the
> > > > > figure in the cost basis.
> > > > > > > > > Is there any way to desavtivate the cost basis feature
> > > > > > > You could remove the Cost Basis column by customizing any view.
> > > >
  #19  
Old 03-22-2006, 07:36 AM
Roshlin
Guest
 
Posts: n/a
Default Re: Problems with cost basis

Hi Cal Learner,

1. base currency euro and country spain
2. account currency US$
3. Investment symbol, currency, US$, if you me type and Cd, stock , bond all
give the same problem
4. Investment country US
and I have put tax exempt to simplify

Thanks


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Roshlin wrote:
> > > Hi Cal Learner,

> > Thanks for your interest,
> > The last price is 15$, qty is 199, market value is 2985$, till here perfect
> > (+15$ commision would give the 3000) and GAIN is 755.14 HOW???????
> > > CLICKING + activity buy, price 15, qty 199, amount 3.000,00 US$ (EVERYTHING

> > PERFECT)
> > > I removed the cost basis column in the valuation view now it doesn't show

> > the cost basis but values for gain don't change , as espected.
> > > Really can't figure out what could be causing this. Please help

> If I try to replicate this,
> 1. What is the base currency?
> 2. What is the "account currency"? You can find that in the account
> settings.
> 3. What is the investment symbol?
> 4. What is the investment "country/region"? You can find that in the
> Details for the investment.
> > Thanks
> > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, Roshlin wrote:
> > > > > > I've done it the way Arthur sugested , making a cash transaction and the
> > > > transferring to the investment
> > > > And it does it with any type of investment. even with stock
> > > > It has to do ith the exchange rates in the cost basis.
> > > > Just to try different values, I made a cash deposit of 3000$ today, and
> > > > bought a stock, 199 [at] 15$ each and 15$ commision, and it is showing me a
> > > > gain of $755.14.
> > > > > You are looking at the Portfolio Manager. What does the LastPrice
> > > column indicate? Is there a symbol in front of the price? If so,
> > > what is it?
> > > > > Click the [+] in front of the investment name to expand the
> > > transactions. What does it show for the Amount? What is the symbol
> > > in front of the amount?
> > > > > > > > > > In the valuation view I can see that the difference comes from the cost
> > > > basis field whis is showing 2229.86 + 15$ of commission and you get the
> > > > difference.
> > > > Why is the cost basis showing the figure, when I have just made the purchase
> > > > today and the exchange rate has not changed. I even checked the value in
> > > > euros for this transaction is 2473,61 which has nothing to do with the
> > > > figure in the cost basis.
> > > > > > > Is there any way to desavtivate the cost basis feature
> > > > > You could remove the Cost Basis column by customizing any view.

> >
  #18  
Old 03-21-2006, 11:32 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Problems with cost basis

In microsoft.public.money, Roshlin wrote:

- quote -

> Hi Cal Learner,
> Thanks for your interest,
> The last price is 15$, qty is 199, market value is 2985$, till here perfect
> (+15$ commision would give the 3000) and GAIN is 755.14 HOW???????
> CLICKING + activity buy, price 15, qty 199, amount 3.000,00 US$ (EVERYTHING
> PERFECT)
> I removed the cost basis column in the valuation view now it doesn't show
> the cost basis but values for gain don't change , as espected.
> Really can't figure out what could be causing this. Please help


If I try to replicate this,

1. What is the base currency?

2. What is the "account currency"? You can find that in the account
settings.

3. What is the investment symbol?

4. What is the investment "country/region"? You can find that in the
Details for the investment.






- quote -

> Thanks
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Roshlin wrote:
> > > > I've done it the way Arthur sugested , making a cash transaction and the
> > > transferring to the investment
> > > And it does it with any type of investment. even with stock
> > > It has to do ith the exchange rates in the cost basis.
> > > Just to try different values, I made a cash deposit of 3000$ today, and
> > > bought a stock, 199 [at] 15$ each and 15$ commision, and it is showing me a
> > > gain of $755.14.
> > > You are looking at the Portfolio Manager. What does the LastPrice

> > column indicate? Is there a symbol in front of the price? If so,
> > what is it?
> > > Click the [+] in front of the investment name to expand the

> > transactions. What does it show for the Amount? What is the symbol
> > in front of the amount?
> > > > > > In the valuation view I can see that the difference comes from the cost
> > > basis field whis is showing 2229.86 + 15$ of commission and you get the
> > > difference.
> > > Why is the cost basis showing the figure, when I have just made the purchase
> > > today and the exchange rate has not changed. I even checked the value in
> > > euros for this transaction is 2473,61 which has nothing to do with the
> > > figure in the cost basis.
> > > > > Is there any way to desavtivate the cost basis feature
> > > You could remove the Cost Basis column by customizing any view.

>
  #17  
Old 03-21-2006, 08:15 PM
Roshlin
Guest
 
Posts: n/a
Default Re: Problems with cost basis


Hi Cal Learner,
Thanks for your interest,
The last price is 15$, qty is 199, market value is 2985$, till here perfect
(+15$ commision would give the 3000) and GAIN is 755.14 HOW???????

CLICKING + activity buy, price 15, qty 199, amount 3.000,00 US$ (EVERYTHING
PERFECT)

I removed the cost basis column in the valuation view now it doesn't show
the cost basis but values for gain don't change , as espected.

Really can't figure out what could be causing this. Please help
Thanks
"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Roshlin wrote:
> > I've done it the way Arthur sugested , making a cash transaction and the
> > transferring to the investment
> > And it does it with any type of investment. even with stock
> > It has to do ith the exchange rates in the cost basis.
> > Just to try different values, I made a cash deposit of 3000$ today, and
> > bought a stock, 199 [at] 15$ each and 15$ commision, and it is showing me a
> > gain of $755.14.

> You are looking at the Portfolio Manager. What does the LastPrice
> column indicate? Is there a symbol in front of the price? If so,
> what is it?
> Click the [+] in front of the investment name to expand the
> transactions. What does it show for the Amount? What is the symbol
> in front of the amount?
> > In the valuation view I can see that the difference comes from the cost
> > basis field whis is showing 2229.86 + 15$ of commission and you get the
> > difference.
> > Why is the cost basis showing the figure, when I have just made the purchase
> > today and the exchange rate has not changed. I even checked the value in
> > euros for this transaction is 2473,61 which has nothing to do with the
> > figure in the cost basis.
> > > Is there any way to desavtivate the cost basis feature

> You could remove the Cost Basis column by customizing any view.

  #16  
Old 03-21-2006, 02:24 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Problems with cost basis

In microsoft.public.money, Roshlin wrote:

- quote -

> I've done it the way Arthur sugested , making a cash transaction and the
> transferring to the investment
> And it does it with any type of investment. even with stock
> It has to do ith the exchange rates in the cost basis.
> Just to try different values, I made a cash deposit of 3000$ today, and
> bought a stock, 199 [at] 15$ each and 15$ commision, and it is showing me a
> gain of $755.14.


You are looking at the Portfolio Manager. What does the LastPrice
column indicate? Is there a symbol in front of the price? If so,
what is it?

Click the [+] in front of the investment name to expand the
transactions. What does it show for the Amount? What is the symbol
in front of the amount?



- quote -

> In the valuation view I can see that the difference comes from the cost
> basis field whis is showing 2229.86 + 15$ of commission and you get the
> difference.
> Why is the cost basis showing the figure, when I have just made the purchase
> today and the exchange rate has not changed. I even checked the value in
> euros for this transaction is 2473,61 which has nothing to do with the
> figure in the cost basis.
> Is there any way to desavtivate the cost basis feature


You could remove the Cost Basis column by customizing any view.
  #15  
Old 03-21-2006, 01:41 PM
Roshlin
Guest
 
Posts: n/a
Default Re: Problems with cost basis

I've done it the way Arthur sugested , making a cash transaction and the
transferring to the investment
And it does it with any type of investment. even with stock
It has to do ith the exchange rates in the cost basis.
Just to try different values, I made a cash deposit of 3000$ today, and
bought a stock, 199 [at] 15$ each and 15$ commision, and it is showing me a
gain of $755.14.
In the valuation view I can see that the difference comes from the cost
basis field whis is showing 2229.86 + 15$ of commission and you get the
difference.
Why is the cost basis showing the figure, when I have just made the purchase
today and the exchange rate has not changed. I even checked the value in
euros for this transaction is 2473,61 which has nothing to do with the
figure in the cost basis.

Is there any way to desavtivate the cost basis feature

Thanks

"arthur" escribió:

- quote -

> An investment account should have 2 parts:
> Cash and Investment ... access from left panel of account.
> After setting up the account it should have zero cash and no
> investments. Now go to your bank account and transfer 2000 to the new
> investment account. The investment account should now have Cash 2000
> in the Cash page. Next go to the Investment page and buy a, what we
> call, Certificate of Deposit ( CD ) and fill in the form. In Spain
> you might call it something else.
> I can not help you further, so hope this helps.
> cheers
> arthur
> ==
> On Mon, 20 Mar 2006 08:11:30 -0800, Roshlin
> <Roshlin[at]discussions.microsoft.com> wrote:
> > Hi friends,
> > You both have me right but the problem conitnues,
> > I have opened a investment account bought a CD for 2000$ on 08/05/2002 int
> > rate 2.35% and maturity after a year, the gain should be $47 but money shows
> > -0.07$
> > > And If I enter the same operation for 2000$ with identical int but change

> > the purchase date to 15/03/2005 and maturity 15/03/2006 same 1 yr my gain is
> > $633.15$ instead otf $47
> > > In the valuation view of the portfolio manager the cost basis for the first

> > operation is $2000.07 and for the second 1366.85$ hence the difference, the
> > market value and quantity for both is shown as 2000, is there any way that i
> > could attach a screenshot.
> > > Thanks Chris and Arthur
> > > Roshlin

  #14  
Old 03-21-2006, 12:12 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Problems with cost basis

"Roshlin" <Roshlin[at]discussions.microsoft.com> wrote in message
news:0C6242F8-B7B1-4512-A7A3-3091FB8B30CA[at]microsoft.com...
- quote -

> What I realize is that I have this problem when the purchase is in another
> currency that ?uro my default currency.
> I tried the same opertaion with 2000? on different dates and it works
> well.
> I would really like to use the other currencies as well, thats why I'm
> trying to use money. And the exchange rate has to do something with the
> gain
> or loss the money is showing.


Not having investments denominated in anything but USD, I've never played
with that. But I think Money always expresses returns in terms of the native
currency. Considering that, does it explain the difference?
--
Chris Cowles
Gainesville, FL



  #13  
Old 03-20-2006, 10:40 PM
arthur
Guest
 
Posts: n/a
Default Re: Problems with cost basis

An investment account should have 2 parts:
Cash and Investment ... access from left panel of account.

After setting up the account it should have zero cash and no
investments. Now go to your bank account and transfer 2000 to the new
investment account. The investment account should now have Cash 2000
in the Cash page. Next go to the Investment page and buy a, what we
call, Certificate of Deposit ( CD ) and fill in the form. In Spain
you might call it something else.

I can not help you further, so hope this helps.

cheers
arthur
==

On Mon, 20 Mar 2006 08:11:30 -0800, Roshlin
<Roshlin[at]discussions.microsoft.com> wrote:

- quote -

> Hi friends,
> You both have me right but the problem conitnues,
> I have opened a investment account bought a CD for 2000$ on 08/05/2002 int
> rate 2.35% and maturity after a year, the gain should be $47 but money shows
> -0.07$
> And If I enter the same operation for 2000$ with identical int but change
> the purchase date to 15/03/2005 and maturity 15/03/2006 same 1 yr my gain is
> $633.15$ instead otf $47
> In the valuation view of the portfolio manager the cost basis for the first
> operation is $2000.07 and for the second 1366.85$ hence the difference, the
> market value and quantity for both is shown as 2000, is there any way that i
> could attach a screenshot.
> Thanks Chris and Arthur
> Roshlin

  #12  
Old 03-20-2006, 08:38 PM
Roshlin
Guest
 
Posts: n/a
Default Re: Problems with cost basis



"Roshlin" escribió:

- quote -

> Hi friends,
> You both have me right but the problem conitnues,
> I have opened a investment account bought a CD for 2000$ on 08/05/2002 int
> rate 2.35% and maturity after a year, the gain should be $47 but money shows
> -0.07$
> And If I enter the same operation for 2000$ with identical int but change
> the purchase date to 15/03/2005 and maturity 15/03/2006 same 1 yr my gain is
> $633.15$ instead otf $47
> In the valuation view of the portfolio manager the cost basis for the first
> operation is $2000.07 and for the second 1366.85$ hence the difference, the
> market value and quantity for both is shown as 2000, is there any way that i
> could attach a screenshot.

What I realize is that I have this problem when the purchase is in another
currency that €uro my default currency.

I tried the same opertaion with 2000€ on different dates and it works well.

I would really like to use the other currencies as well, thats why I'm
trying to use money. And the exchange rate has to do something with the gain
or loss the money is showing.

- quote -

> Thanks Chris and Arthur
> Roshlin
> "arthur" escribió:
> > Not the expert and I think you are saying you purchased a 3yr CD from
> > a bank. Correct? The interest is only "accrued" (accounting jargon)
> > and you should receive a 1099-INT (assuming USA) each January. At
> > that time you can add the interest as a 12/31/200y entry.
> > > We are speaking small change here ... $47 more or less in 12 months.
> > > arthur

> > ==
> > > On Sun, 19 Mar 2006 16:56:27 -0800, Roshlin

> > <Roshlin[at]discussions.microsoft.com> wrote:
> > > > Hi Arthur,
> > > I have invested 2000$ in a fixed deposit [at] 2.35% per annum for a period of 3
> > > yrs
> > > I have entered it as an investment, as a buy option in the money market. I
> > > dont get a monthly staement only a receipt that says the interest rate and
> > > the amount on maturity.
> > > The gain money is showing me is after adding the buy transaction I haven't
> > > added the interest as there is no option for it, my idea was to add the
> > > maturity amount was by updating the price manually. But for that I want the
> > > buy option not showing any gian, which is coming from the cost basis.
> > > > > Thanks for your hel, is there any way I could copy and post the transaction
> > > for you to see???
> > > > > "arthur" escribió:
> > > > > > I think that 2.2 is not the interest rate but rather the APY, which
> > > > for many, is the daily compound effective annual rate. It is as
> > > > though you made 1% on xyz today and claim your annual gain is 365%.
> > > > > > > I assume it is not a Bond so don't expect Mny to know that you are
> > > > lying.
> > > > > > > arthur
> > > > =
> > > > On Sun, 19 Mar 2006 03:46:27 -0800, Roshlin
> > > > <Roshlin[at]discussions.microsoft.com> wrote:
> > > > > > > > I invested $2000 on 2/5/2002 [at] 2.2% interest, in what type of account do I
> > > > > enter this transaction so that it show me the interes gained till today.
> > > >
  #11  
Old 03-20-2006, 03:11 PM
Roshlin
Guest
 
Posts: n/a
Default Re: Problems with cost basis

Hi friends,
You both have me right but the problem conitnues,
I have opened a investment account bought a CD for 2000$ on 08/05/2002 int
rate 2.35% and maturity after a year, the gain should be $47 but money shows
-0.07$

And If I enter the same operation for 2000$ with identical int but change
the purchase date to 15/03/2005 and maturity 15/03/2006 same 1 yr my gain is
$633.15$ instead otf $47

In the valuation view of the portfolio manager the cost basis for the first
operation is $2000.07 and for the second 1366.85$ hence the difference, the
market value and quantity for both is shown as 2000, is there any way that i
could attach a screenshot.

Thanks Chris and Arthur

Roshlin
"arthur" escribió:

- quote -

> Not the expert and I think you are saying you purchased a 3yr CD from
> a bank. Correct? The interest is only "accrued" (accounting jargon)
> and you should receive a 1099-INT (assuming USA) each January. At
> that time you can add the interest as a 12/31/200y entry.
> We are speaking small change here ... $47 more or less in 12 months.
> arthur
> ==
> On Sun, 19 Mar 2006 16:56:27 -0800, Roshlin
> <Roshlin[at]discussions.microsoft.com> wrote:
> > Hi Arthur,
> > I have invested 2000$ in a fixed deposit [at] 2.35% per annum for a period of 3
> > yrs
> > I have entered it as an investment, as a buy option in the money market. I
> > dont get a monthly staement only a receipt that says the interest rate and
> > the amount on maturity.
> > The gain money is showing me is after adding the buy transaction I haven't
> > added the interest as there is no option for it, my idea was to add the
> > maturity amount was by updating the price manually. But for that I want the
> > buy option not showing any gian, which is coming from the cost basis.
> > > Thanks for your hel, is there any way I could copy and post the transaction

> > for you to see???
> > > "arthur" escribió:
> > > > I think that 2.2 is not the interest rate but rather the APY, which
> > > for many, is the daily compound effective annual rate. It is as
> > > though you made 1% on xyz today and claim your annual gain is 365%.
> > > > > I assume it is not a Bond so don't expect Mny to know that you are
> > > lying.
> > > > > arthur
> > > =
> > > On Sun, 19 Mar 2006 03:46:27 -0800, Roshlin
> > > <Roshlin[at]discussions.microsoft.com> wrote:
> > > > > > I invested $2000 on 2/5/2002 [at] 2.2% interest, in what type of account do I
> > > > enter this transaction so that it show me the interes gained till today.

> >
  #10  
Old 03-20-2006, 03:34 AM
arthur
Guest
 
Posts: n/a
Default Re: Problems with cost basis

Spain. Good catch.

I should have checked arin / ripe before answering. Oh well ...

arthur
==

On Sun, 19 Mar 2006 20:10:53 -0500, "Chris Cowles"
<spam_magnet[at]remove-me-bellsouth.net> wrote:
- quote -

> From the non-English content of your replies, I infer you are not in the US.
> In the US, we refer to that as a CD, i.e., Certificate of Deposit. Fixed
> duration, fixed interest.
> In Money, CDs are investments. They are held in accounts. Create an
> investment account, name it what you want. Add a new investment called "CD 3
> yr 2.35%" or something to your liking. Pick CD as investment type (I'm
> assuming that's a choice in the version you're using.) Fill in the details
> as prompted.
> Post back with your experience.

  #9  
Old 03-20-2006, 03:30 AM
arthur
Guest
 
Posts: n/a
Default Re: Problems with cost basis

Not the expert and I think you are saying you purchased a 3yr CD from
a bank. Correct? The interest is only "accrued" (accounting jargon)
and you should receive a 1099-INT (assuming USA) each January. At
that time you can add the interest as a 12/31/200y entry.

We are speaking small change here ... $47 more or less in 12 months.

arthur
==

On Sun, 19 Mar 2006 16:56:27 -0800, Roshlin
<Roshlin[at]discussions.microsoft.com> wrote:

- quote -

> Hi Arthur,
> I have invested 2000$ in a fixed deposit [at] 2.35% per annum for a period of 3
> yrs
> I have entered it as an investment, as a buy option in the money market. I
> dont get a monthly staement only a receipt that says the interest rate and
> the amount on maturity.
> The gain money is showing me is after adding the buy transaction I haven't
> added the interest as there is no option for it, my idea was to add the
> maturity amount was by updating the price manually. But for that I want the
> buy option not showing any gian, which is coming from the cost basis.
> Thanks for your hel, is there any way I could copy and post the transaction
> for you to see???
> "arthur" escribió:
> > I think that 2.2 is not the interest rate but rather the APY, which
> > for many, is the daily compound effective annual rate. It is as
> > though you made 1% on xyz today and claim your annual gain is 365%.
> > > I assume it is not a Bond so don't expect Mny to know that you are

> > lying.
> > > arthur

> > =
> > On Sun, 19 Mar 2006 03:46:27 -0800, Roshlin
> > <Roshlin[at]discussions.microsoft.com> wrote:
> > > > I invested $2000 on 2/5/2002 [at] 2.2% interest, in what type of account do I
> > > enter this transaction so that it show me the interes gained till today.

>
  #8  
Old 03-20-2006, 12:10 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Problems with cost basis

"Roshlin" <Roshlin[at]discussions.microsoft.com> wrote in message
news:7B632341-8EC6-4A47-92DD-846AD89ECCE7[at]microsoft.com...
- quote -

> Hi Arthur,
> I have invested 2000$ in a fixed deposit [at] 2.35% per annum for a period of
> 3
> yrs
> I have entered it as an investment, as a buy option in the money market. I
> dont get a monthly staement only a receipt that says the interest rate and
> the amount on maturity.
> The gain money is showing me is after adding the buy transaction I haven't
> added the interest as there is no option for it, my idea was to add the
> maturity amount was by updating the price manually. But for that I want
> the
> buy option not showing any gian, which is coming from the cost basis.
> Thanks for your hel, is there any way I could copy and post the
> transaction
> for you to see???


From the non-English content of your replies, I infer you are not in the US.
In the US, we refer to that as a CD, i.e., Certificate of Deposit. Fixed
duration, fixed interest.

In Money, CDs are investments. They are held in accounts. Create an
investment account, name it what you want. Add a new investment called "CD 3
yr 2.35%" or something to your liking. Pick CD as investment type (I'm
assuming that's a choice in the version you're using.) Fill in the details
as prompted.

Post back with your experience.
--
Chris Cowles
Gainesville, FL



  #7  
Old 03-19-2006, 11:56 PM
Roshlin
Guest
 
Posts: n/a
Default Re: Problems with cost basis

Hi Arthur,
I have invested 2000$ in a fixed deposit [at] 2.35% per annum for a period of 3
yrs
I have entered it as an investment, as a buy option in the money market. I
dont get a monthly staement only a receipt that says the interest rate and
the amount on maturity.
The gain money is showing me is after adding the buy transaction I haven't
added the interest as there is no option for it, my idea was to add the
maturity amount was by updating the price manually. But for that I want the
buy option not showing any gian, which is coming from the cost basis.

Thanks for your hel, is there any way I could copy and post the transaction
for you to see???

"arthur" escribió:

- quote -

> I think that 2.2 is not the interest rate but rather the APY, which
> for many, is the daily compound effective annual rate. It is as
> though you made 1% on xyz today and claim your annual gain is 365%.
> I assume it is not a Bond so don't expect Mny to know that you are
> lying.
> arthur
> =
> On Sun, 19 Mar 2006 03:46:27 -0800, Roshlin
> <Roshlin[at]discussions.microsoft.com> wrote:
> > I invested $2000 on 2/5/2002 [at] 2.2% interest, in what type of account do I
> > enter this transaction so that it show me the interes gained till today.

  #6  
Old 03-19-2006, 09:57 PM
arthur
Guest
 
Posts: n/a
Default Re: Problems with cost basis

What is it you really invested 2000 in? A CD or Savings Account or MM
or ??? Do you get a monthly statement online or mail?

arthur
==

On Sun, 19 Mar 2006 11:07:26 -0800, Roshlin
<Roshlin[at]discussions.microsoft.com> wrote:

- quote -

> Hi Chris,
> Sorry but it does not work the cost basis keeps interfering it was just that
> particular transaction that was neearly ok so I mentioned earlier that it was
> working, entering the same transaction with different dates guves the same
> problem. there is always some addition or subtraction which varies with the
> amount or price or exchange. I'm working in euros and my investments are in $.

  #5  
Old 03-19-2006, 09:53 PM
arthur
Guest
 
Posts: n/a
Default Re: Problems with cost basis

I think that 2.2 is not the interest rate but rather the APY, which
for many, is the daily compound effective annual rate. It is as
though you made 1% on xyz today and claim your annual gain is 365%.

I assume it is not a Bond so don't expect Mny to know that you are
lying.

arthur
=
On Sun, 19 Mar 2006 03:46:27 -0800, Roshlin
<Roshlin[at]discussions.microsoft.com> wrote:

- quote -

> I invested $2000 on 2/5/2002 [at] 2.2% interest, in what type of account do I
> enter this transaction so that it show me the interes gained till today.

 

Tags
basis, cost, problems
Similar Threads
Thread Forum Replies Last Post
Cost Basis of IRA
Pleonasm: Microsoft Money 2005 Deluxe appears to add reinvested dividends and capital gains to the initial purchase price of a mutal fund when computing the...
Microsoft Money 1 01-17-2005 03:30 PM
IRA Cost Basis
Tom: I established a new Money (2004) account to track an IRA. How do I set the cost basis of the account (without entering all of the transactions...
Microsoft Money 2 08-06-2004 08:53 PM
cost basis/avg cost per share
David: I've got 2 accounts (mutual funds) set up under a single financial institution. In Portfolio, using Valuations view, Money calculates the cost...
Microsoft Money 2 03-03-2004 11:00 AM
cost basis/avg cost per share
David: I've got 2 accounts (mutual funds) set up under a single financial institution. In Portfolio, using Valuations view, Money calculates the cost...
Microsoft Money 1 03-01-2004 11:26 AM
Re: cost basis
Cal Learner-- MVP: In microsoft.public.money, - Bobb - wrote: >Accounting aside, (since it's in my IRA account), any way to easily do this >? >I buy $25,000 of...
Microsoft Money 1 07-27-2003 02:38 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 05:56 PM.