Bond valuations


W

w_oppenheim

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.
 
Ad

Advertisements

C

Cal Learner-- MVP

In said:
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.
 
W

w_oppenheim

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
 
C

Cal Learner-- MVP

In said:
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.
 
W

w_oppenheim

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.
 
C

Cal Learner-- MVP

In said:
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.
 
Ad

Advertisements

W

w_oppenheim

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.
 
M

Michael Gordon, MVP

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

William L. Oppenheim, M.D.

M05, but I have been a user right from the first verstion.
 
M

Michael Gordon, MVP

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.aspx?scid=kb;en-us;121903.
 
W

William L. Oppenheim, M.D.

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.
 
Ad

Advertisements

M

Michael Gordon, MVP

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.?
 
Ad

Advertisements

W

William L. Oppenheim, M.D.

I should have started a new thread. I will under investing account totals
incorrect. Look for it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Valuating present value of I Bond? 3
USA Questions on valuating a business for divorce 0
Auto Valuation 1
Ballpark valuation 5
Endowment valuation 4
Inventory valuation 4
Home Valuation 4
UK Stock valuation 1

Top