Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 08-23-2003, 10:49 PM
Michael Gordon, MVP
Guest
 
Posts: n/a
Default Re: Interest and return of principal on US Treasury bills

Do it as a sale rather than a redemption. -- Money will (erroneously)
report a Capital Gain transaction (but it will be zero) and will also
(correctly) report a Schedule B transaction. There's a KB article on this
which will be out soon.

--
Michael Gordon - MVP


"Baldwin Maull" <bmaull[at]worldnet.att.net> wrote in message
news:00ad01c369a7$d63d91c0$a501280a[at]phx.gbl...
- quote -

> 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. The bill is payable
> on 4/24/03 at par, $50,000.00.
> On that day the estate recorded the $50,000.00 payment as
> follows: return of purchase price $49,622.96, and $377.04
> as interest under investment income. The two numbers add
> up to $50,000.00. I chose "Redeem C/D Bond" as the
> activity for the $49,622.96 return of the amount paid
> and "Accrued Interest" for the interest portion, $377.04.
> The Money program posts the entire $50,000.00 as "Interest
> Income," an obvious error.
> 1.) Is the posting to "Accrued Interest" wrong? If so, how
> should the payment of interest at maturity be recorded?
> 2.) Is the activity, "Redeem CD/Bond" in error? If so, how
> is that activity employed by Money? Should the payment of
> the $49.622.96 be recorded as "Return of Principal?"
> 3.) Are two postings necessary, one to record payment of
> principal and the other as investment interest.
> Thank you for your help.
> Baldwin Maull
> bmaull[at]worldnet.att.net



 
Old 08-23-2003, 09:07 PM
Matthew Fricke
Guest
 
Posts: n/a
Default Interest and return of principal on US Treasury bills

Using "return of principal" solves the interest income
problem.

It does have another problem though. When you record a
bond being called or maturing with "return of principal"
cash is added to your investment account in the value of
the bond (as would be expected) but the bond being
redeemed is not removed from your investments or reduced
in value. This is particularly annoying for GNMAs where
principal is returned monthly but money does not reduce
the value of the bond accordingly.

Each time a bond matures or is called I have to manually
add a remove shares event on the bond involved.

It's very annoying.

Someone should fix both these bugs.

- quote -

> -----Original Message-----
> 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. The bill is

payable
> on 4/24/03 at par, $50,000.00.
> On that day the estate recorded the $50,000.00 payment

as
> follows: return of purchase price $49,622.96, and

$377.04
> as interest under investment income. The two numbers add
> up to $50,000.00. I chose "Redeem C/D Bond" as the
> activity for the $49,622.96 return of the amount paid
> and "Accrued Interest" for the interest portion, $377.04.
> The Money program posts the entire $50,000.00

as "Interest
> Income," an obvious error.
> 1.) Is the posting to "Accrued Interest" wrong? If so,

how
> should the payment of interest at maturity be recorded?
> 2.) Is the activity, "Redeem CD/Bond" in error? If so,

how
> is that activity employed by Money? Should the payment

of
> the $49.622.96 be recorded as "Return of Principal?"
> 3.) Are two postings necessary, one to record payment of
> principal and the other as investment interest.
> Thank you for your help.
> Baldwin Maull
> bmaull[at]worldnet.att.net
> .

  #-1  
Old 08-23-2003, 06:53 PM
Baldwin Maull
Guest
 
Posts: n/a
Default Interest and return of principal on US Treasury bills

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. The bill is payable
on 4/24/03 at par, $50,000.00.

On that day the estate recorded the $50,000.00 payment as
follows: return of purchase price $49,622.96, and $377.04
as interest under investment income. The two numbers add
up to $50,000.00. I chose "Redeem C/D Bond" as the
activity for the $49,622.96 return of the amount paid
and "Accrued Interest" for the interest portion, $377.04.

The Money program posts the entire $50,000.00 as "Interest
Income," an obvious error.

1.) Is the posting to "Accrued Interest" wrong? If so, how
should the payment of interest at maturity be recorded?

2.) Is the activity, "Redeem CD/Bond" in error? If so, how
is that activity employed by Money? Should the payment of
the $49.622.96 be recorded as "Return of Principal?"

3.) Are two postings necessary, one to record payment of
principal and the other as investment interest.

Thank you for your help.

Baldwin Maull
bmaull[at]worldnet.att.net
 

Tags
bills, interest, principal, return, treasury
Similar Threads
Thread Forum Replies Last Post
Return of capital
Paul: How does a return of capital transaction affect the cost (or basis) of stock? It appears to me that it does not have an effect on the basis and...
Microsoft Money 1 08-16-2003 08:29 PM
Scheduled Bills & Deposits, MSN Bill Pay, e-Bills
Retired Coal Miner: I can't figure out how to get M03 to recognize a scheduled bill (setup in Scheduled Bills & Deposits), as being paid when I have the bill setup as...
Microsoft Money 2 07-21-2003 01:17 PM
Return of Capital for Stock Investments
Bill M.: I'm not sure if Microsoft looks at this bulletin board or not, but I think they should. They seem to have a few flaws in their software. I have...
Microsoft Money 1 07-01-2003 01:24 AM



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 01:32 PM.