Microsoft Money Investment Recordkeeping Tricks

-- End Ad Box --->treat the purchase and sale of any stock. If you
Microsoft Money provides powerful investmentmake money, you realize a gain. If you lose money,
record-keeping tools for individual investors.you realize a loss.
Unfortunately, once you step beyond investmentsIf you buy or sell a put or call and hold the option
like stocks, bonds, and mutual funds, the mechanicsuntil it expires, things work almost the same way.
can get a little tricky. Here are some tips for handlingHowever, in this special case, you do need to record
common investments in Money.a Final Sale transaction, and the sales price is zero.
Certificate of depositsObviously, if you hold a put or call until it expires, you
If you purchase a certificate of deposit, you candon’t actually sell the derivative. But you need
treat it in the same way that you treat a bondto record a sale transaction to reflect the fact that
purchase. Basically, certificates of deposits, or CDs,the option is no longer worth anything.
are just bonds issued by banks or financial institutionsThese are the basic techniques you need to know
often for a shorter period of time. For example, youfor put and call record keeping—and record keeping
can think of a two-year CD as equivalent to afor similar derivatives—but there are two special
two-year bond.circumstances in which more complicated record
Zero coupon bondskeeping is required.
If you invest in bonds, you may know that someSelling Puts and Calls
bonds don’t actually pay periodic interest.If you sell puts and calls—note that the earlier
Instead, these bonds, called zero coupon bonds, paydiscussion involves you in investing puts and
their interest when the bond matures. For zerocalls—you need to record the option as a regular
coupon bonds, you need to annually accrue thebuy or sell transaction. In other words, if you sell a
interest on the bonds. The annual interest needs toput and the person to whom you sell it exercises the
be accrued because, by convention, you report theput, you record this transaction as a regular sales
annual increase in the zero coupon bond’stransaction. Similarly, if you sell a call, you record the
value as interest earned.transaction as a regular buy transaction.
To record accrued interest on a zero coupon bond,If you sell a put or call option and the option never
record bond interest that accrues in the normal way.gets exercised, you record the amount of money
In other words, whatever amount shows as beingthe buyer pays you as Other Income.
accrued—this should appear on the statement fromExercising Puts and Calls
your broker—record it as bond interest income.Typically, individual investors don’t actually
After you record the bond interest that’sexercise puts and calls that they buy. Instead, they
accrued, you need to record a return of capitalsimply sell the option back to the broker. However,
transaction that adds this accrued interest back toyou might end up exercising a put or call, and in this
the value of the bond. The amount of this capitalcase, you need to perform special record keeping.
transaction, obviously, needs to equal the accruedTo record the exercise of a put option, record the
interest amount. But there is a twist here: You needsale of the put option at a price equal to zero. This
to specify the return of capital amount as a negativezero-value sale is how you record the expiration of
value. For example, if you accrue $100 of interest onthe option. After you have recorded the expiration
a zero coupon bond, you also need to record aof the option, you record the sale of the stock in the
return of capital transaction for the bond equal tosame way that you record the sale of any stock.
—$100.(Remember that a put is an option to sell stock.)
By recording the return of capital transaction, you inTo record the exercise of a call option, record the
effect transfer the bond interest money from thesale of the call option at a price equal to zero. This
associated cash account and add it back to the zerozero-value price lets you record the expiration of the
coupon bond’s value. In this way theoption. After you have recorded the expiration, you
associated cash account shows the correct cashrecord a regular buy transaction. (Remember that a
balance and the zero-coupon bond shows the correctcall option is an option to buy a security.)
cost basis. The zero coupon bond’s cash basisPrecious metals and commodities
equals the original purchase price plus all the accruedYou can treat investments in gold and other precious
interest that’s been recorded to date.metals, gold coins, agricultural items, and other
Derivativescommodities in the same way that you treat shares
Derivatives are securities that derive their value fromof stock. Rather than entering a share price, you
some underlying security. For example, an option toenter a price per ounce or a price per bushel. And
sell a stock, called a put, is a derivative. It derives itsrather than recording a specific number of shares,
value from the underlying security. Another derivativeyou enter a specific number of whatever unit of
is an option to buy a stock, called a call. You can usemeasure is used to describe the commodity.
Money to keep records of derivatives, such as putsIn the case of gold, for example, you might enter
and calls you buy.the number of ounces. In the case of an agricultural
In general, derivative record-keeping is quiteitem, you might enter the number of bushels.
straightforward. If you buy a derivative, say a put orYou can treat options to buy or sell commodities in
a call, and later sell the derivative, you simply have athe same way that you treat options to buy or sell
normal investment transaction. You treat thesecurities.
purchase and later the sale in the same way that you