| Author |
Message |
songli
Guest
|
 Posted:
Tue Nov 08, 2005 8:28 am Post subject:
T-Bill recording |
|
|
I'm using Money2006. I bought $50k worth of 13-week T-Bills.
I defined 13wkTBill as a security.
When I try to enter this transaction, I put in Quantity 1, Price $50,000,
and it calculates the total as $500. ????
If I enter quantity 100, price $50k, then the total is $50k.
I can't figure out the math. Why is the total only 1% of what I'd expect?
Thanks
|
|
| Back to top |
|
 |
Cal Learner
Guest
|
| Posted:
Tue Nov 08, 2005 9:02 am Post subject:
Re: T-Bill recording |
|
|
In microsoft.public.money, songli wrote:
| Quote: | I'm using Money2006. I bought $50k worth of 13-week T-Bills.
I defined 13wkTBill as a security.
|
"security" is not one of the Money types. I suspect you chose
"bond".
| Quote: |
When I try to enter this transaction, I put in Quantity 1, Price $50,000,
and it calculates the total as $500. ????
If I enter quantity 100, price $50k, then the total is $50k.
|
Bonds are priced as a percent of par/face value. If you keep that as
a bond, and you paid par, the total is $50,000 and the price is
100(%). Quantity is 50000.
See http://support.microsoft.com/default.aspx?scid=kb;en-us;240555
http://support.microsoft.com/default.aspx?scid=kb;en-us;823031 could
also be of interest -- no pun intended.
| Quote: |
I can't figure out the math. Why is the total only 1% of what I'd expect? |
|
|
| Back to top |
|
|
songli
Guest
|
| Posted:
Tue Nov 08, 2005 9:02 am Post subject:
Re: T-Bill recording |
|
|
"Cal Learner" <NoMailTnx@please.com> wrote in message
news:la60n19ni2afs59qj803bflm9m3ijr8ncl@4ax.com...
| Quote: | In microsoft.public.money, songli wrote:
I'm using Money2006. I bought $50k worth of 13-week T-Bills.
I defined 13wkTBill as a security.
"security" is not one of the Money types. I suspect you chose
"bond".
|
You're right, the type is "Bond", sub-type "Treasury Bill"
| Quote: | Bonds are priced as a percent of par/face value. If you keep that as
a bond, and you paid par, the total is $50,000 and the price is
100(%). Quantity is 50000.
|
Great, thanks!
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in