Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #11  
Old 10-12-2004, 07:51 AM
William L. Oppenheim, M.D.
Guest
 
Posts: n/a
Default Re: Bond valuations

I should have started a new thread. I will under investing account totals
incorrect. Look for it.
"Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
news:%2350kTnAsEHA.3520[at]TK2MSFTNGP11.phx.gbl...
- quote -

> I'd be glad to provide ideas if I had a better sense of the problem: are
> you saying that in some views the Bonds are valued correctly and in other
> view they aren"t? If so, can you be more specific about the views,
> accounts, etc.?
> --
> Michael Gordon
> MVP
> "William L. Oppenheim, M.D." <woppenhe[at]ucla.edu> wrote in message
> news:ORBbuj$rEHA.3244[at]tk2msftngp13.phx.gbl...
> > Thank you Michael. I believe you may have posted a potential solution to
> > the issue that the Invest page accounts do not total correctly. I have
> > the same accounts displayed in the portfolio with the same cash balances.
> > The portfolio is correct but not the Investment page totals. Any ideas
> > on this. I have run the file fix a few times, but it reports no errors
> > with my data.
> > > "Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message

> > news:e420UHurEHA.2580[at]TK2MSFTNGP15.phx.gbl...
> > > Yes, I remember seeing your posts over the years. I can't remember the
> > > year the method changed, but what you need to do now is enter the price
> > > the way it's quoted to you - as a percentage of par, where par is 100.
> > > So, in the situation you spelled out, the price would be 92.976. The
> > > quantity of bonds is entered as, not the number of bonds, but as the
> > > face value. So, if the bonds, when they mature, would be worth 30,000,
> > > then you should enter 30,000. Money will do the math (that par is 100,
> > > but bonds are soldin multiples of 1000 internally). Take a look at
> > > http://support.microsoft.com/default...b;en-us;121903.
> > > --
> > > Michael Gordon
> > > MVP
> > > > > > > "William L. Oppenheim, M.D." <woppenhe[at]ucla.edu> wrote in message
> > > news:e9xk2qarEHA.736[at]tk2msftngp13.phx.gbl...
> > > > M05, but I have been a user right from the first verstion.
> > > > "Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
> > > > news:%23tuNHQOrEHA.3080[at]TK2MSFTNGP15.phx.gbl...
> > > > > Which version of Money? The method changed a couple of years ago.
> > > > > > > > > --
> > > > > Michael Gordon
> > > > > MVP
> > > > > > > > > > > > > "w_oppenheim" <woppenhe[at]ucla.edu> wrote in message
> > > > > news:ck3qco$kff$1[at]daisy.noc.ucla.edu...
> > > > > > Anyone having trouble with this. In portfolio view the price of 1000
> > > > > > bonds
> > > > > > is given as 9297.60 and totals 337,944.27. Given the math, it is
> > > > > > hard to
> > > > > > tell what I should correct--the number of bonds, or the price of the
> > > > > > idividual bonds. This sytem has never worked well for me, but
> > > > > > previously
> > > > > > the math was at least correct.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > >


  #10  
Old 10-12-2004, 03:16 AM
Michael Gordon, MVP
Guest
 
Posts: n/a
Default Re: Bond valuations

I'd be glad to provide ideas if I had a better sense of the problem: are you
saying that in some views the Bonds are valued correctly and in other view
they aren"t? If so, can you be more specific about the views, accounts,
etc.?

--
Michael Gordon
MVP


"William L. Oppenheim, M.D." <woppenhe[at]ucla.edu> wrote in message
news:ORBbuj$rEHA.3244[at]tk2msftngp13.phx.gbl...
- quote -

> Thank you Michael. I believe you may have posted a potential solution to
> the issue that the Invest page accounts do not total correctly. I have
> the same accounts displayed in the portfolio with the same cash balances.
> The portfolio is correct but not the Investment page totals. Any ideas on
> this. I have run the file fix a few times, but it reports no errors with
> my data.
> "Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
> news:e420UHurEHA.2580[at]TK2MSFTNGP15.phx.gbl...
> > Yes, I remember seeing your posts over the years. I can't remember the
> > year the method changed, but what you need to do now is enter the price
> > the way it's quoted to you - as a percentage of par, where par is 100.
> > So, in the situation you spelled out, the price would be 92.976. The
> > quantity of bonds is entered as, not the number of bonds, but as the face
> > value. So, if the bonds, when they mature, would be worth 30,000, then
> > you should enter 30,000. Money will do the math (that par is 100, but
> > bonds are soldin multiples of 1000 internally). Take a look at
> > http://support.microsoft.com/default...b;en-us;121903.
> > --
> > Michael Gordon
> > MVP
> > > > "William L. Oppenheim, M.D." <woppenhe[at]ucla.edu> wrote in message

> > news:e9xk2qarEHA.736[at]tk2msftngp13.phx.gbl...
> > > M05, but I have been a user right from the first verstion.
> > > "Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
> > > news:%23tuNHQOrEHA.3080[at]TK2MSFTNGP15.phx.gbl...
> > > > Which version of Money? The method changed a couple of years ago.
> > > > > > > --
> > > > Michael Gordon
> > > > MVP
> > > > > > > > > > "w_oppenheim" <woppenhe[at]ucla.edu> wrote in message
> > > > news:ck3qco$kff$1[at]daisy.noc.ucla.edu...
> > > > > Anyone having trouble with this. In portfolio view the price of 1000
> > > > > bonds
> > > > > is given as 9297.60 and totals 337,944.27. Given the math, it is hard
> > > > > to
> > > > > tell what I should correct--the number of bonds, or the price of the
> > > > > idividual bonds. This sytem has never worked well for me, but
> > > > > previously
> > > > > the math was at least correct.
> > > > > > > > > > > > > > > > > > > >


  #9  
Old 10-12-2004, 01:15 AM
William L. Oppenheim, M.D.
Guest
 
Posts: n/a
Default Re: Bond valuations

Thank you Michael. I believe you may have posted a potential solution to
the issue that the Invest page accounts do not total correctly. I have the
same accounts displayed in the portfolio with the same cash balances. The
portfolio is correct but not the Investment page totals. Any ideas on this.
I have run the file fix a few times, but it reports no errors with my data.

"Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
news:e420UHurEHA.2580[at]TK2MSFTNGP15.phx.gbl...
- quote -

> Yes, I remember seeing your posts over the years. I can't remember the
> year the method changed, but what you need to do now is enter the price
> the way it's quoted to you - as a percentage of par, where par is 100. So,
> in the situation you spelled out, the price would be 92.976. The quantity
> of bonds is entered as, not the number of bonds, but as the face value.
> So, if the bonds, when they mature, would be worth 30,000, then you should
> enter 30,000. Money will do the math (that par is 100, but bonds are
> soldin multiples of 1000 internally). Take a look at
> http://support.microsoft.com/default...b;en-us;121903.
> --
> Michael Gordon
> MVP
> "William L. Oppenheim, M.D." <woppenhe[at]ucla.edu> wrote in message
> news:e9xk2qarEHA.736[at]tk2msftngp13.phx.gbl...
> > M05, but I have been a user right from the first verstion.
> > "Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
> > news:%23tuNHQOrEHA.3080[at]TK2MSFTNGP15.phx.gbl...
> > > Which version of Money? The method changed a couple of years ago.
> > > > > --
> > > Michael Gordon
> > > MVP
> > > > > > > "w_oppenheim" <woppenhe[at]ucla.edu> wrote in message
> > > news:ck3qco$kff$1[at]daisy.noc.ucla.edu...
> > > > Anyone having trouble with this. In portfolio view the price of 1000
> > > > bonds
> > > > is given as 9297.60 and totals 337,944.27. Given the math, it is hard
> > > > to
> > > > tell what I should correct--the number of bonds, or the price of the
> > > > idividual bonds. This sytem has never worked well for me, but
> > > > previously
> > > > the math was at least correct.
> > > > > > > > > > > >


  #8  
Old 10-10-2004, 03:57 PM
Michael Gordon, MVP
Guest
 
Posts: n/a
Default Re: Bond valuations

Yes, I remember seeing your posts over the years. I can't remember the year
the method changed, but what you need to do now is enter the price the way
it's quoted to you - as a percentage of par, where par is 100. So, in the
situation you spelled out, the price would be 92.976. The quantity of bonds
is entered as, not the number of bonds, but as the face value. So, if the
bonds, when they mature, would be worth 30,000, then you should enter
30,000. Money will do the math (that par is 100, but bonds are soldin
multiples of 1000 internally). Take a look at
http://support.microsoft.com/default...b;en-us;121903.
--
Michael Gordon
MVP


"William L. Oppenheim, M.D." <woppenhe[at]ucla.edu> wrote in message
news:e9xk2qarEHA.736[at]tk2msftngp13.phx.gbl...
- quote -

> M05, but I have been a user right from the first verstion.
> "Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
> news:%23tuNHQOrEHA.3080[at]TK2MSFTNGP15.phx.gbl...
> > Which version of Money? The method changed a couple of years ago.
> > > --

> > Michael Gordon
> > MVP
> > > > "w_oppenheim" <woppenhe[at]ucla.edu> wrote in message

> > news:ck3qco$kff$1[at]daisy.noc.ucla.edu...
> > > Anyone having trouble with this. In portfolio view the price of 1000
> > > bonds
> > > is given as 9297.60 and totals 337,944.27. Given the math, it is hard
> > > to
> > > tell what I should correct--the number of bonds, or the price of the
> > > idividual bonds. This sytem has never worked well for me, but
> > > previously
> > > the math was at least correct.
> > > > > >


  #7  
Old 10-09-2004, 02:50 AM
William L. Oppenheim, M.D.
Guest
 
Posts: n/a
Default Re: Bond valuations

M05, but I have been a user right from the first verstion.
"Michael Gordon, MVP" <gordonm[at]denison.edu> wrote in message
news:%23tuNHQOrEHA.3080[at]TK2MSFTNGP15.phx.gbl...
- quote -

> Which version of Money? The method changed a couple of years ago.
> --
> Michael Gordon
> MVP
> "w_oppenheim" <woppenhe[at]ucla.edu> wrote in message
> news:ck3qco$kff$1[at]daisy.noc.ucla.edu...
> > Anyone having trouble with this. In portfolio view the price of 1000
> > bonds
> > is given as 9297.60 and totals 337,944.27. Given the math, it is hard to
> > tell what I should correct--the number of bonds, or the price of the
> > idividual bonds. This sytem has never worked well for me, but previously
> > the math was at least correct.
> >


  #6  
Old 10-08-2004, 03:08 AM
Michael Gordon, MVP
Guest
 
Posts: n/a
Default Re: Bond valuations

Which version of Money? The method changed a couple of years ago.

--
Michael Gordon
MVP


"w_oppenheim" <woppenhe[at]ucla.edu> wrote in message
news:ck3qco$kff$1[at]daisy.noc.ucla.edu...
- quote -

> Anyone having trouble with this. In portfolio view the price of 1000
> bonds
> is given as 9297.60 and totals 337,944.27. Given the math, it is hard to
> tell what I should correct--the number of bonds, or the price of the
> idividual bonds. This sytem has never worked well for me, but previously
> the math was at least correct.



  #5  
Old 10-07-2004, 08:02 PM
w_oppenheim
Guest
 
Posts: n/a
Default Re: Bond valuations

Yes, you have interpreted correctly. I assume thta this is not a problem for
most of the users. I have run the fix standard menu item as well. The
totals on the Invensting page as opposed to the portfolio manager are also
off. The same figures for each individual investment account is shown in
each area. However the total is wrong for the investment home page. It is
a simply matter of adding up what is displayed and not arriving at the same
figure the program calculates.


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

> In microsoft.public.money, w_oppenheim wrote:
> > I did the changes you suggested. The total portfolio value remains
> > accurate, but the total value of the bonds as displayed on portfolio

summary
> > page is way off as I originally stated.

> But now you are confident what the problem is.
> > On the accounts summary, the totals
> > are correct. On the positions summary page, the errors remain.

> I think you are saying that on Group By :Account Name on the
> portfolio view, you don't see any problems with the Market Value
> column, but when you Group By : Position, you see a problem with
> the Market Value column.
> > Seems like
> > a bug to me. One screen shows them acurately, the alternate screen shows
> > the same assets with a different value. Same underlying entry data.



  #4  
Old 10-07-2004, 07:18 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Bond valuations

In microsoft.public.money, w_oppenheim wrote:

- quote -

> I did the changes you suggested. The total portfolio value remains
> accurate, but the total value of the bonds as displayed on portfolio summary
> page is way off as I originally stated.


But now you are confident what the problem is.

- quote -

> On the accounts summary, the totals
> are correct. On the positions summary page, the errors remain.


I think you are saying that on Group By :Account Name on the
portfolio view, you don't see any problems with the Market Value
column, but when you Group By : Position, you see a problem with
the Market Value column.



- quote -

> Seems like
> a bug to me. One screen shows them acurately, the alternate screen shows
> the same assets with a different value. Same underlying entry data.


  #3  
Old 10-07-2004, 07:07 PM
w_oppenheim
Guest
 
Posts: n/a
Default Re: Bond valuations

I did the changes you suggested. The total portfolio value remains
accurate, but the total value of the bonds as displayed on portfolio summary
page is way off as I originally stated. On the accounts summary, the totals
are correct. On the positions summary page, the errors remain. Seems like
a bug to me. One screen shows them acurately, the alternate screen shows
the same assets with a different value. Same underlying entry data.

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

> In microsoft.public.money, w_oppenheim wrote:
> > Does this mean that I should use 1000 as the par value of the bond, and
> > 0.92976 as the price? If I have 10 bonds should I use 10,000 as the par
> > value and enter it into qualtity

> For one $1000 bond that you paid $929.76, the Quantity would be
> 1000, the Price would be 92.976 (%) and the Total would be 929.76 .
> For ten such bonds, yes, the Quantity (face/par) would be 10000, the
> Price would be 92.976 (%) and the Total would be 9297.60 .
> Note that when bond prices are published, they are listed as a
> percent of par.
> Note (to others) that savings bonds are done differently.



  #2  
Old 10-07-2004, 05:04 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Bond valuations

In microsoft.public.money, w_oppenheim wrote:

- quote -

> Does this mean that I should use 1000 as the par value of the bond, and
> 0.92976 as the price? If I have 10 bonds should I use 10,000 as the par
> value and enter it into qualtity


For one $1000 bond that you paid $929.76, the Quantity would be
1000, the Price would be 92.976 (%) and the Total would be 929.76 .


For ten such bonds, yes, the Quantity (face/par) would be 10000, the
Price would be 92.976 (%) and the Total would be 9297.60 .

Note that when bond prices are published, they are listed as a
percent of par.

Note (to others) that savings bonds are done differently.

  #1  
Old 10-07-2004, 04:57 PM
w_oppenheim
Guest
 
Posts: n/a
Default Re: Bond valuations

Does this mean that I should use 1000 as the par value of the bond, and
0.92976 as the price? If I have 10 bonds should I use 10,000 as the par
value and enter it into qualtity

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

> In microsoft.public.money, w_oppenheim wrote:
> > Anyone having trouble with this. In portfolio view the price of 1000

bonds
> > is given as 9297.60 and totals 337,944.27. Given the math, it is hard to
> > tell what I should correct--the number of bonds, or the price of the
> > idividual bonds. This sytem has never worked well for me, but previously
> > the math was at least correct.

> Enter the total face/par value into Quantity. Price is a percent of
> par/face. It is usually best to tab thru Price to the Total field,
> and Money will calculate price.



 
Old 10-07-2004, 04:27 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Bond valuations

In microsoft.public.money, w_oppenheim wrote:

- quote -

> Anyone having trouble with this. In portfolio view the price of 1000 bonds
> is given as 9297.60 and totals 337,944.27. Given the math, it is hard to
> tell what I should correct--the number of bonds, or the price of the
> idividual bonds. This sytem has never worked well for me, but previously
> the math was at least correct.


Enter the total face/par value into Quantity. Price is a percent of
par/face. It is usually best to tab thru Price to the Total field,
and Money will calculate price.

  #-1  
Old 10-07-2004, 04:20 PM
w_oppenheim
Guest
 
Posts: n/a
Default Bond valuations

Anyone having trouble with this. In portfolio view the price of 1000 bonds
is given as 9297.60 and totals 337,944.27. Given the math, it is hard to
tell what I should correct--the number of bonds, or the price of the
idividual bonds. This sytem has never worked well for me, but previously
the math was at least correct.


 

Tags
bond, valuations
Similar Threads
Thread Forum Replies Last Post
Entering Savings Bond as CD versus zero-coupon bond
Bob: Why doesn't Money recommend entering a US Savings Bond as a zero-coupon bond type of investment where the quantity is the face value and the price...
Microsoft Money 4 07-21-2004 04:43 PM
how to change a stock to a bond
matt o: I have a bond (REIT) called Boston Properties (BXP). I downloaded my statement from my broker. My broker classifies it as a REIT, but Money 2004...
Microsoft Money 6 02-26-2004 07:47 PM
Serious Bug Importing 401(k) Bond Investment
Brian Champagne: Hello, I don't know if Microsoft actually checks this newsgroup but I found a serious bug in Money 2004. Through my company I have a 401(k)...
Microsoft Money 9 12-20-2003 05:50 AM
bond transactions
Dave: I purchased a commercial bond at a premium because the coupon rate is higher than current interest rates. As interest is received, I need to...
Microsoft Money 2 07-12-2003 09:16 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:03 PM.