Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 05-31-2005, 01:20 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Not public traded mutual funds... how to enter/maintain in Money?

Enter an investment description, but no symbol. Make sure, if you have
multiple accounts (eg, 403b + 401a) you create the investment only once. If
the investment exists in multiple accounts, don't create multiple instances
of the investment - just pick it from the drop-down list while adding it to
the account. By not creating multiple instances of the investment, updating
the price once will update it in all accounts.

Update the price manually from time to time using data provided by the
broker. You'll find that function under 'Common Tasks' on the left side of
the investment account register. As this is a retirement account, and I
assume you're not trading it actively, there's no particular benefit in
updating more than about once a month, anyway.

You may be able to get investment distribution information from them that
describes it in terms of large, mid, small, bond, cash, or other. You can
enter that on the details page of the investment. Click the 'Change...'
button next to 'Change Asset Allocation: on that page. (Unfortunately, Money
never has had an international category.)

If you want to use the asset allocation tool (different from asset
allocation on the investment details page), that tool allows only a single
classification per investment. For mutual funds invested in a variety of
investment types, you'll have to arbitrarily pick one.


"Tom" <tom[at]nospam.com> wrote in message
news:%23qWfSVXZFHA.3840[at]tk2msftngp13.phx.gbl...
- quote -

> My new company's 401k funds show up with the following in the
> description... 'This fund is not a publicly traded fund and is not
> listed in any business periodicals'... I am assuming that this means
> there is no stock symbol to track nor download (at least, looking
> through the overviews of each fund there was nothing anywhere
> indicating what the mutual fund symbol was). Some of these funds are,
> like, International Equity Fund, Agressive Portfolio, Small Cap Fund,
> etc etc.
> What does this mean for these kind of funds? Is there, then, no stock
> symbol to track? If so, then how would be the way to enter and track
> these funds in Money 2005? (Again, this is a company 401k) When should
> I enter ending stock prices, then?
> Tom



  #1  
Old 05-31-2005, 01:17 AM
Scott Tyler
Guest
 
Posts: n/a
Default Re: Not public traded mutual funds... how to enter/maintain in Money?


"Tom" <tom[at]nospam.com> wrote in message
news:%23qWfSVXZFHA.3840[at]tk2msftngp13.phx.gbl...
- quote -

> My new company's 401k funds show up with the following in the
> description... 'This fund is not a publicly traded fund and is not
> listed in any business periodicals'... I am assuming that this means
> there is no stock symbol to track nor download (at least, looking
> through the overviews of each fund there was nothing anywhere
> indicating what the mutual fund symbol was). Some of these funds are,
> like, International Equity Fund, Agressive Portfolio, Small Cap Fund,
> etc etc.
> What does this mean for these kind of funds? Is there, then, no stock
> symbol to track? If so, then how would be the way to enter and track
> these funds in Money 2005? (Again, this is a company 401k) When should
> I enter ending stock prices, then?
> Tom


My last employer had a 401k like that. Although they didn't maintain a
price history on their website, they did post the prices for the previous
business day.

Every night I would log on to the 401k website, then copy and paste the
previous day's prices into "Update Prices > manually".

Every two weeks when I got paid, I'd pull up the transaction history from
the 401k website, then manually enter the buys.

Dividends were posted quarterly. A few days after dividends were paid, I'd
pull up the transaction history, then manually enter the dividend
reinvestments.

In my case, employer matching was also posted quarterly. Sometimes I'd have
to wait a week or two for the transactions to finalize, then I was able to
input it.

As the company stock was actually a mutual fund for which no details were
available (not even online), I'd input it as a stock, let Money download the
daily price, then periodically use add/remove shares to bring the market
value in Money in line with the market value on the 401k website.

--
Scott Tyler
agent_scotty-at-hotmail-dot-com


 
Old 05-31-2005, 01:16 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Not public traded mutual funds... how to enter/maintain in Money?

The short answer is "it depends". Some plans that do this quote everything,
(Buys, Sells, earnings), in terms of unit values with associated unit
prices. If yours is one of these plans, track it per the statements and use
their units and total dollar values for each transaction--Money can figure
the price given this data. You can create the investments you have as
"Mutual Funds" without symbol. This is about as good as it gets.

Many plans don't provide unit/unit price information. The best of a series
of compromised answers for this case seems to be using $1 shares for
everything. Contribute $250? Buy 250 $1 shares. Reallocate $400? Sell 400
shares at $1, buy 400 shares at $1. Periodically (based on quarterly
statements or whatever works for you) do an Account Update (it's a link at
the bottom of the Investment Account Account Summary page) and let it enter
Add/Remove shares transactions as required to reflect investment performance
to get your Money data back in balance with the plan's data.

401(k)s are one of the two most complicated things to model in Money.
Someday I'm hoping to finish a 401(k) primer page. It just hasn't happened
yet. You might find some good nuggets at
http://umpmfaq.info/faqdb.php?cat=10 in the interim.

"Tom" <tom[at]nospam.com> wrote in message
news:%23qWfSVXZFHA.3840[at]tk2msftngp13.phx.gbl...
- quote -

> My new company's 401k funds show up with the following in the
> description... 'This fund is not a publicly traded fund and is not
> listed in any business periodicals'... I am assuming that this means
> there is no stock symbol to track nor download (at least, looking
> through the overviews of each fund there was nothing anywhere
> indicating what the mutual fund symbol was). Some of these funds are,
> like, International Equity Fund, Agressive Portfolio, Small Cap Fund,
> etc etc.
> What does this mean for these kind of funds? Is there, then, no stock
> symbol to track? If so, then how would be the way to enter and track
> these funds in Money 2005? (Again, this is a company 401k) When should
> I enter ending stock prices, then?



  #-1  
Old 05-31-2005, 12:11 AM
Tom
Guest
 
Posts: n/a
Default Not public traded mutual funds... how to enter/maintain in Money?

My new company's 401k funds show up with the following in the
description... 'This fund is not a publicly traded fund and is not
listed in any business periodicals'... I am assuming that this means
there is no stock symbol to track nor download (at least, looking
through the overviews of each fund there was nothing anywhere
indicating what the mutual fund symbol was). Some of these funds are,
like, International Equity Fund, Agressive Portfolio, Small Cap Fund,
etc etc.

What does this mean for these kind of funds? Is there, then, no stock
symbol to track? If so, then how would be the way to enter and track
these funds in Money 2005? (Again, this is a company 401k) When should
I enter ending stock prices, then?

Tom
 

Tags
enter or maintain, funds, money, mutual, public, traded
Similar Threads
Thread Forum Replies Last Post
Tracking Mutual Funds
Chris Veal: I have some mutual funds that I get updates on daily as to what amount of interest they are gaining me towards my retirement. Is there a way to...
Microsoft Money 1 05-11-2005 07:48 PM
How to enter Malaysian retirement funds in Money 2004?
Mansuriatus Shahrir Amir: I'm from Malaysia and very new to Money 2004. I have some problems in trying to tailor Money to requirements unique to Malaysia, which I believe...
Microsoft Money 1 04-07-2004 02:21 AM
Mutual funds merging with other mutual funds
Rod: In Money 2000 Deluxe, how do you record when a mutual fund company combines with another mutual fund? I had 200 shares of fund a, which was...
Microsoft Money 1 12-09-2003 12:28 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 11:35 AM.