Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #23  
Old 01-23-2006, 05:00 AM
harrelsonesq
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

1979, IIRC, or rather, if my remaining brain cells RC.

Susan

"Farnk" <Farnk[at]discussions.microsoft.com> wrote in message
news:E5303025-C8E5-4A92-B8B0-B495616E6B37[at]microsoft.com...
- quote -

> Wow! You guys are wonderful. All from a lack of understanding. Thank
> You!!
> And all this time I thought I couldn't get it to work because of... well,
> let's just say I had a little too much fun at Pink Floyd's The Wall
> concert
> back in 1982(?).
> Big thanks to both Cal and Dick. I'm on my merry way. :-)
> "Dick Watson" wrote:
> > A Money Market fund is a special class of mutual fund that pegs the price
> > at
> > $1. They do this since their goal is to distribute all of their earnings
> > on-the-fly after expenses. So the value of a share stays at $1 since the
> > gains are distributed. Yes, when creating an investment, there are
> > separate
> > choices between Money Market Fund and Mutual Fund.
> > > You can change from one type of investment to another. See

> > http://umpmfaq.info/faqdb.php?q=81. Whether you really want to do this
> > for
> > investments in a 401(k) depends on the nature of your 401(k). Some plans
> > really have the individuals holding share in the underlying fund. Many
> > more
> > are really having the individuals holding units in a private, non-traded,
> > not market priced, fund that holds some underlying fund and some cash for
> > liquidity and pays some expenses over and above what the underlying fund
> > has. My 401(k), for instance, has a Vanguard Windsor fund--but you can't
> > track it with symbol VWNDX.
> > > "Farnk" <Farnk[at]discussions.microsoft.com> wrote in message

> > news:9210B320-639A-4F4B-8F09-BAF05766DE3C[at]microsoft.com...
> > > Forgive my ignorance - inveting is relatively new to me - but is there
> > > a
> > > difference between a money market fund and a mutual fund? From what
> > > I've
> > > read, a money market fund appears to be short term. And can I change
> > > the
> > > way
> > > this mutual fund is, as you said, set up? I mean, can I have an
> > > account
> > > detail set up as a MM fund as opposed to a mutual fund? I tried to set
> > > up
> > > a
> > > new investment account and a new 401(k) account, but neither seem to
> > > give
> > > me
> > > an ability to specify which kind of fund this is.
> > > > > I ask these questions because your statement hits the nail on the head;
> > > price is LOCKED at $1!!
> > >


  #22  
Old 01-22-2006, 06:01 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

"Farnk" <Farnk[at]discussions.microsoft.com> wrote in message
news:E5303025-C8E5-4A92-B8B0-B495616E6B37[at]microsoft.com...
- quote -

> Wow! You guys are wonderful. All from a lack of understanding. Thank
> You!!
> And all this time I thought I couldn't get it to work because of... well,
> let's just say I had a little too much fun at Pink Floyd's The Wall
> concert
> back in 1982(?).


I attribute my hearing loss to a particular Iron Butterfly concert but have
plenty of spare brain cells, even though I've fried a few.
--
Chris Cowles
Gainesville, FL



  #21  
Old 01-22-2006, 05:22 PM
Farnk
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

Wow! You guys are wonderful. All from a lack of understanding. Thank You!!
And all this time I thought I couldn't get it to work because of... well,
let's just say I had a little too much fun at Pink Floyd's The Wall concert
back in 1982(?).

Big thanks to both Cal and Dick. I'm on my merry way. :-)

"Dick Watson" wrote:

- quote -

> A Money Market fund is a special class of mutual fund that pegs the price at
> $1. They do this since their goal is to distribute all of their earnings
> on-the-fly after expenses. So the value of a share stays at $1 since the
> gains are distributed. Yes, when creating an investment, there are separate
> choices between Money Market Fund and Mutual Fund.
> You can change from one type of investment to another. See
> http://umpmfaq.info/faqdb.php?q=81. Whether you really want to do this for
> investments in a 401(k) depends on the nature of your 401(k). Some plans
> really have the individuals holding share in the underlying fund. Many more
> are really having the individuals holding units in a private, non-traded,
> not market priced, fund that holds some underlying fund and some cash for
> liquidity and pays some expenses over and above what the underlying fund
> has. My 401(k), for instance, has a Vanguard Windsor fund--but you can't
> track it with symbol VWNDX.
> "Farnk" <Farnk[at]discussions.microsoft.com> wrote in message
> news:9210B320-639A-4F4B-8F09-BAF05766DE3C[at]microsoft.com...
> > Forgive my ignorance - inveting is relatively new to me - but is there a
> > difference between a money market fund and a mutual fund? From what I've
> > read, a money market fund appears to be short term. And can I change the
> > way
> > this mutual fund is, as you said, set up? I mean, can I have an account
> > detail set up as a MM fund as opposed to a mutual fund? I tried to set up
> > a
> > new investment account and a new 401(k) account, but neither seem to give
> > me
> > an ability to specify which kind of fund this is.
> > > I ask these questions because your statement hits the nail on the head;

> > price is LOCKED at $1!!

  #20  
Old 01-22-2006, 04:23 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

A Money Market fund is a special class of mutual fund that pegs the price at
$1. They do this since their goal is to distribute all of their earnings
on-the-fly after expenses. So the value of a share stays at $1 since the
gains are distributed. Yes, when creating an investment, there are separate
choices between Money Market Fund and Mutual Fund.

You can change from one type of investment to another. See
http://umpmfaq.info/faqdb.php?q=81. Whether you really want to do this for
investments in a 401(k) depends on the nature of your 401(k). Some plans
really have the individuals holding share in the underlying fund. Many more
are really having the individuals holding units in a private, non-traded,
not market priced, fund that holds some underlying fund and some cash for
liquidity and pays some expenses over and above what the underlying fund
has. My 401(k), for instance, has a Vanguard Windsor fund--but you can't
track it with symbol VWNDX.

"Farnk" <Farnk[at]discussions.microsoft.com> wrote in message
news:9210B320-639A-4F4B-8F09-BAF05766DE3C[at]microsoft.com...
- quote -

> Forgive my ignorance - inveting is relatively new to me - but is there a
> difference between a money market fund and a mutual fund? From what I've
> read, a money market fund appears to be short term. And can I change the
> way
> this mutual fund is, as you said, set up? I mean, can I have an account
> detail set up as a MM fund as opposed to a mutual fund? I tried to set up
> a
> new investment account and a new 401(k) account, but neither seem to give
> me
> an ability to specify which kind of fund this is.
> I ask these questions because your statement hits the nail on the head;
> price is LOCKED at $1!!



  #19  
Old 01-22-2006, 04:14 PM
Farnk
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

- quote -

> > I can enter Quantity and Price and have the Total calculated. But if I try
> > entering the Quantity and Total, when I tab over (or hit enter), Price is
> > changed to 1 and Quantity changes to what I entered for Total.

> If the investment is set up as a Money Market Fund, the price will
> be locked at $1.


Forgive my ignorance - inveting is relatively new to me - but is there a
difference between a money market fund and a mutual fund? From what I've
read, a money market fund appears to be short term. And can I change the way
this mutual fund is, as you said, set up? I mean, can I have an account
detail set up as a MM fund as opposed to a mutual fund? I tried to set up a
new investment account and a new 401(k) account, but neither seem to give me
an ability to specify which kind of fund this is.

I ask these questions because your statement hits the nail on the head;
price is LOCKED at $1!!
  #18  
Old 01-22-2006, 04:20 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

In microsoft.public.money, Farnk wrote:

- quote -

> I can enter Quantity and Price and have the Total calculated. But if I try
> entering the Quantity and Total, when I tab over (or hit enter), Price is
> changed to 1 and Quantity changes to what I entered for Total.


If the investment is set up as a Money Market Fund, the price will
be locked at $1.

  #17  
Old 01-22-2006, 03:31 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

"Farnk" <Farnk[at]discussions.microsoft.com> wrote in message
news:11632C01-E566-48FD-8263-C6AB6E51BDF1[at]microsoft.com...
- quote -

> Cal - seems like I did not make myself clear; no matter how hard I try, I
> cannot successfully enter a total amount at all.
> I can enter Quantity and Price and have the Total calculated. But if I
> try
> entering the Quantity and Total, when I tab over (or hit enter), Price is
> changed to 1 and Quantity changes to what I entered for Total.


Delete the total. Tab backwards to price. Delete price. Tab backwards to
quantity. Enter the quantity. Tab twice to total, enter it. Press enter.
Price will calculate.
--
Chris Cowles
Gainesville, FL



  #16  
Old 01-22-2006, 02:37 AM
Farnk
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

Cal - seems like I did not make myself clear; no matter how hard I try, I
cannot successfully enter a total amount at all.

I can enter Quantity and Price and have the Total calculated. But if I try
entering the Quantity and Total, when I tab over (or hit enter), Price is
changed to 1 and Quantity changes to what I entered for Total. If I try
entering the Price and Total, when I tab over (or hit enter), again, Price is
changed to 1 and Quantity changes to what I entered for Total. So, if I try
to enter Total at all, it is never accepted.

It's also important to note that my statement comes with the Quantity to 3
decimal places, Price to 3 decimal places and Total to 2 decimal places. As
is, these numbers don't jive - they are always off by a few cents. The only
way to get the precision I need is to "un-round" one of the numbers. I will
not change the Total from two decimals, and Price is acceptable at 3
decimals, so Quantity is the big loser that gets higher precision.

I didn't know Google groups and the other resources existed, so off I go to
learn as much as I can.

Frank
  #15  
Old 01-22-2006, 01:51 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

"harrelsonesq" <harrelsonesq2[at]yahoo.com> wrote in message
news:ewpLlhuHGHA.3944[at]tk2msftngp13.phx.gbl...
- quote -

> That's why I thought that Quantity was the one to let Money calculate.
> Because you won't get it right if you enter it yourself. Now I am
> thoroughly confused. Again.


The problem is at disposal. If you let it calculate the quantity, it might
do so out to 5 decimal places. Then your broker says you sold XX.003 shares,
which you enter. If the previous amount held was XX.00301, you'll have
0.00001 shares remaining, but they won't show up because it's so small. But
Money will continue to report that you own it, and you can't delete the
stock.

Better to enter the quantities the broker states, and let Money calculate
the price. The price difference will be nominal, and will not affect the
quantities bought or sold, nor the total revenue.

If you ever do have a ghost holding, do an add shares for 1. Then go to the
account summary and update it to 0. The resulting remove shares will be
1.000xx, where .000xx is the hidden holding. Revise that to a remove of
0.000xx and save, then delete the add shares of 1. The result will be an
actual holding of exactly 0. I've had to do that to enable deleting a stock
symbol.
--
Chris Cowles
Gainesville, FL



  #14  
Old 01-21-2006, 11:09 PM
harrelsonesq
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

That's why I thought that Quantity was the one to let Money calculate.
Because you won't get it right if you enter it yourself. Now I am thoroughly
confused. Again.

Susan

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:eI4r8PlHGHA.2696[at]TK2MSFTNGP14.phx.gbl...
- quote -

> too.
> "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
> message news:%23%23qqCMlHGHA.3448[at]TK2MSFTNGP10.phx.gbl...
> > No broker uses a finite number of decimal places in quantity.If you want
> > the share balance to match, you should to.
> > > "harrelsonesq" <harrelsonesq2[at]yahoo.com> wrote in message

> > news:ecf$DCkHGHA.344[at]TK2MSFTNGP11.phx.gbl...
> > > I thought it was the other way around, because Quantity is the term that
> > > has the stupid infinite decimal places in it. Since I switched to
> > > entering Price and Total, my investments have been much more accurate.

> >


  #13  
Old 01-21-2006, 08:39 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

One of our 401Ks is in real investments. Actual shares to 3 decimal places
work there. Mine is in bogus units that aren't reported for all transactions
but just on quarterly summaries, etc. I use $1 shares there.

"Chris Cowles" <spam_magnet[at]remove-me-bellsouth.net> wrote in message
news:OnehWCtHGHA.528[at]TK2MSFTNGP12.phx.gbl...
- quote -

> I've had a broker (401k manager) that only printed 2 (or 3?) decimal
> places on the paper statement, but listed 4 or 5 on their web site. So
> they were actually keeping higher-precision records but not publishing
> them on paper.



  #12  
Old 01-21-2006, 08:21 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

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

> If you don't know the quantity--say you only know a closing price and a
> total quantity for a scheduled purchase of a fund--you can enter price and
> total, let Money calculate units. Then you can delete price and round the
> units the direction your fund does. All of them I've ever had round to the
> nearest three decimal places. No calculator involved here, either.


I've had a broker (401k manager) that only printed 2 (or 3?) decimal places
on the paper statement, but listed 4 or 5 on their web site. So they were
actually keeping higher-precision records but not publishing them on paper.


  #11  
Old 01-21-2006, 08:17 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

"harrelsonesq" <harrelsonesq2[at]yahoo.com> wrote in message
news:ecf$DCkHGHA.344[at]TK2MSFTNGP11.phx.gbl...
- quote -

> I thought it was the other way around, because Quantity is the term that
> has the stupid infinite decimal places in it. Since I switched to entering
> Price and Total, my investments have been much more accurate.


Sales transactions will be a perpetual problem if you do that. You'll end up
with some 6-digit decimal remainder of a holding that you can't find.


  #10  
Old 01-21-2006, 08:12 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

In microsoft.public.money, Dick Watson wrote:

- quote -

> If you don't know the quantity--say you only know a closing price and a
> total quantity for a scheduled purchase of a fund--you can enter price and
> total, let Money calculate units. Then you can delete price and round the
> units the direction your fund does. All of them I've ever had round to the
> nearest three decimal places. No calculator involved here, either.


I guess I was badly mis-reading the posts. Sorry. The person is
saying that the number of shares purchased was not provided.
Entering the only data that you have, even if it is just Total and
Price, makes sense then.

Your technique of forcing the quantity to 3-decimal makes sense
then, but it assumes that the per-share price value was correct for
the actual class of shares, and that there was no hidden fee.






- quote -

> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:hks4t159godn4094l9s79idqjpu1uii92p[at]4ax.com...
> > 1. enter Total and Quantity, and leave Price blank for Money to
> > calculate

  #9  
Old 01-21-2006, 07:47 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

If you don't know the quantity--say you only know a closing price and a
total quantity for a scheduled purchase of a fund--you can enter price and
total, let Money calculate units. Then you can delete price and round the
units the direction your fund does. All of them I've ever had round to the
nearest three decimal places. No calculator involved here, either.

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:hks4t159godn4094l9s79idqjpu1uii92p[at]4ax.com...
- quote -

> 1. enter Total and Quantity, and leave Price blank for Money to
> calculate



  #8  
Old 01-21-2006, 05:14 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

In microsoft.public.money, Farnk wrote:

- quote -

> > When you have Quantity, Price, and Total fields, it is usually best
> > to fill in the Quantity and Total. Let Money compute Price.
> > Thanks for the thoughts, guys. I believe when it comes right down to it,

> the Market Value is most important. The decimal places in Quantity is least
> significant and will "even itself out" over time. When you get right down to
> it, it's the dollar$ and cent$ that you will be spending. Once
> sold/withdrawn you will care about neither the quantity nor price. It’s the
> dollar amount.


That's the point under discussion. The downside of your method is
that Money thinks you have a different amount of shares than what
the mutual fund company thinks. The mutual fund company and the IRS
do not care what your per-share price was. They do care about what
you paid and what you got for that money.


- quote -

> So tell me, is there anyone who believes this an issue?

Yes, but ....

- quote -

> I mean, don’t
> others get tired of having to do the manual calculation with a calculator and
> then retro-fit the quantiy?


.... nobody is suggesting that you need to use a manual calculation
with a calculator. The difference in opinion is whether to

1. enter Total and Quantity, and leave Price blank for Money to
calculate

2. enter Total and Price, and leave Quantity blank for Money to
calculate

Here are some considerations:

a. Mutual funds commonly total up how many shares you have to three
decimal places. That becomes the actual amount-- not a rounded
version.

b. Mutual funds commonly total up the amounts to $0.01. That becomes
the actual amount. I don't know if they round unbiased or to their
favor. It may well vary.

My thought that #1 is the best way is in no way original with me. It
was commonly pointed out before I ever heard of Microsoft Money.

Here are some vintage examples:
http://groups.google.com/group/micro...47aef2b5ce63c7
http://groups.google.com/group/micro...4879ea0a6ec4c7
http://groups.google.com/group/micro...96a2a789d2c362

I am confident there would be earlier examples if the data base went
back farther.


- quote -

> Frank
> P.S. This is my first ever post on a newsgroup. This is cool - a wealth of
> information!


A really neat way to find prior postings in this group is to use the
Google Usenet Groups archive.

http://groups.google.com/advanced_group_search enter words that you
think would be in relevant posts into the "all of the words" box.
Enter microsoft.public.money into the newsgroup box. Consider
selecting Sort By Date.
  #7  
Old 01-21-2006, 02:41 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

p.s., welcome to the NG. One resource for questions frequently asked here is
at http://umpmfaq.info.

"Farnk" <Farnk[at]discussions.microsoft.com> wrote in message
news:779BBFA5-31D6-4B77-9181-722889CD59CE[at]microsoft.com...
- quote -

> P.S. This is my first ever post on a newsgroup. This is cool - a wealth
> of
> information!



  #6  
Old 01-21-2006, 02:40 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

I disagree. Money is very finicky about the number of units of investments
held. If you don't get it right, it will be complicated in the future to
sell the entire position.

"Farnk" <Farnk[at]discussions.microsoft.com> wrote in message
news:779BBFA5-31D6-4B77-9181-722889CD59CE[at]microsoft.com...
- quote -

> The decimal places in Quantity is least
> significant and will "even itself out" over time.



  #5  
Old 01-21-2006, 12:46 PM
Farnk
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

- quote -

> When you have Quantity, Price, and Total fields, it is usually best
> to fill in the Quantity and Total. Let Money compute Price.

Thanks for the thoughts, guys. I believe when it comes right down to it,
the Market Value is most important. The decimal places in Quantity is least
significant and will "even itself out" over time. When you get right down to
it, it's the dollar$ and cent$ that you will be spending. Once
sold/withdrawn you will care about neither the quantity nor price. It’s the
dollar amount.

So tell me, is there anyone who believes this an issue? I mean, don’t
others get tired of having to do the manual calculation with a calculator and
then retro-fit the quantiy?

Frank

P.S. This is my first ever post on a newsgroup. This is cool - a wealth of
information!
  #4  
Old 01-21-2006, 05:29 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401(k) Manager Calculations

too.

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:%23%23qqCMlHGHA.3448[at]TK2MSFTNGP10.phx.gbl...
- quote -

> No broker uses a finite number of decimal places in quantity.If you want
> the share balance to match, you should to.
> "harrelsonesq" <harrelsonesq2[at]yahoo.com> wrote in message
> news:ecf$DCkHGHA.344[at]TK2MSFTNGP11.phx.gbl...
> > I thought it was the other way around, because Quantity is the term that
> > has the stupid infinite decimal places in it. Since I switched to entering
> > Price and Total, my investments have been much more accurate.



 

Tags
401k, calculations, manager
Similar Threads
Thread Forum Replies Last Post
Mortgage Calculations
Money User: Can anyone tell/show me how Money calculates the mortgage principal and interest amounts? I've been pulling (what's left) my hair out the last...
Microsoft Money 6 02-06-2005 02:42 PM
Mortgage calculations
Brenda \(au\): Recently I created a mortgage account in MS-Money (ver: standard, 2003, International apparently) as per bank statements. However none of the...
Microsoft Money 7 08-11-2004 05:02 PM
erroneous roi calculations
cmgilldh: What causes this? I have a mutual fund for which the 3 month and ytd calc is obviously wrong. During this period I transferred the shares from one...
Microsoft Money 1 03-01-2004 06:48 PM
Invoice calculations
Bill: I reported to MS Tier I tech service that there was a bug in MS Money Sm Business 2004 in the invoicing area. Specifically, while MsMo allows a...
Microsoft Money 1 02-10-2004 09:31 PM
Share price calculations
Ian: Hi, When I create a share account and then download the prices from the net the calculation seems to go wrong. The share price download is in...
Microsoft Money 1 08-20-2003 05:01 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 04:11 PM.