Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 05-25-2007, 09:41 PM
Michael Gordon
Guest
 
Posts: n/a
Default Re: How to track Zero-Coupon Bonds or U.S. Treasury Bills

On the date you purchased the bond, the price should be what you paid for
it -- not par, but (in your case) 97.4773. How are you computing the
accrued interest in order to reprice the security? The difference between
that and the market price should -- I think -- be minimal. You'll still run
into problems when the bill matures, as Money isn't sure whether you've
earned interest or a ST capital gain. You are identifying the security as a
Treasury Bill, right?

--
Michael Gordon


"Sebastian" <Sebastian[at]discussions.microsoft.com> wrote in message
news2D58A81-EFAE-438C-A61E-89C46490D69A[at]microsoft.com...
- quote -

> I've looked all over the internet for the answer to this one, and the only
> one I found was that you could create entries for reinvested interest;
> however, doing that would affect your tax calculations and wouldn't
> accurately reflect your income.
> I'm glad to say, I've figured out a better way that will really track the
> performance and correctly state your portfolio value without affecting the
> tax calculations. So on to sharing the wealth:
> Say you buy a $10,000 6 month Treasury Bill at the discount rate of
> 97.4773.
> You would make an entry into your portfolio account for a bond purchase
> with
> the quantity of 10,000 and a price of 97.4773.
> Now, this is what you really need to do to properly track this bond. Go to
> the investment screen of this bond (usually by right-clicking and
> selecting
> go to investment : ). Under common tasks, go to Update prices and select
> manual update. For the date that you purchased the bond (it is probably
> set
> to 1.000) change the price to 97.4773. Now, for each month upto the
> maturity
> month, you will need to enter a price based on the accrued interest. The
> maturity date price will be 100.
> For this example, the following prices would be entered:
> 8/10/2006 97.477
> 9/10/2006 97.902
> 10/10/2006 98.325
> 11/10/2006 98.750
> 12/10/2006 99.177
> 1/10/2007 99.606
> 2/8/2007 100.000
> That will do it. Now when you run your reports you will accurately see the
> rate of return for that bond for any given period.
> The only downfall I see is that it doesn't track the real market price in
> case you want to sell your bond on the secondary...



  #-1  
Old 05-25-2007, 04:51 AM
Sebastian
Guest
 
Posts: n/a
Default How to track Zero-Coupon Bonds or U.S. Treasury Bills

I've looked all over the internet for the answer to this one, and the only
one I found was that you could create entries for reinvested interest;
however, doing that would affect your tax calculations and wouldn't
accurately reflect your income.

I'm glad to say, I've figured out a better way that will really track the
performance and correctly state your portfolio value without affecting the
tax calculations. So on to sharing the wealth:

Say you buy a $10,000 6 month Treasury Bill at the discount rate of 97.4773.
You would make an entry into your portfolio account for a bond purchase with
the quantity of 10,000 and a price of 97.4773.

Now, this is what you really need to do to properly track this bond. Go to
the investment screen of this bond (usually by right-clicking and selecting
go to investment : ). Under common tasks, go to Update prices and select
manual update. For the date that you purchased the bond (it is probably set
to 1.000) change the price to 97.4773. Now, for each month upto the maturity
month, you will need to enter a price based on the accrued interest. The
maturity date price will be 100.

For this example, the following prices would be entered:

8/10/2006 97.477
9/10/2006 97.902
10/10/2006 98.325
11/10/2006 98.750
12/10/2006 99.177
1/10/2007 99.606
2/8/2007 100.000

That will do it. Now when you run your reports you will accurately see the
rate of return for that bond for any given period.

The only downfall I see is that it doesn't track the real market price in
case you want to sell your bond on the secondary...
 

Tags
bills, bonds, track, treasury, zerocoupon
Similar Threads
Thread Forum Replies Last Post
How to handle a Treasury Bill
alocksley: MS Money 2005 I record the purchase of a 10K 6-mo T-Bill with the number of shares (10000) and the auction price (say 97.55). as a buy with a...
Microsoft Money 2 12-04-2006 02:54 PM
Treasury Direct email and replies
Lena: Did any other acount holders get an email from Treasury Direct asking to update your email and home addresses and phone number, and then get a...
Microsoft Money 4 09-19-2006 03:18 PM
zero coupon bonds
Claire Oberhausen: I am thinking of transfering from Quicken and imported my database and am trying out Money. I can't figure out how to book the yearly implied...
Microsoft Money 2 12-24-2003 10:27 PM
Coupon Invoice Line Item
Brian W: Hello Everyone; I'm using Money Deluxe and Small Business. When doing up an invoice, is there a way to enter a discount or a coupon as a line...
Microsoft Money 1 11-10-2003 03:10 AM
Interest and return of principal on US Treasury bills
Baldwin Maull: An estate bought a US Treasury bill at a discount on 10/21/02 at a price of 99.148 less commission of $43.96 for a total cash outlay of $49,626.96....
Microsoft Money 2 08-23-2003 10:49 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 10:56 PM.