ࡱ> FE `\pChandler Joseph Lutz Ba==$%8X@"1Arial1Arial1Arial1Arial1Arial1@Arial1Arial1QTahoma1QTahoma1QTahoma1QTahoma1@Arial1.Times New Roman1 Arial1$Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)$[$-409]dddd\,\ mmmm\ dd\,\ yyyy mmm\-yyyy 0.0%                + ) , *        ( ( (0    ,!(0 ,!( ,! ,!  ,!(    ,!  ,Q   ( !( !   ,!( (8 ,!(8 ,!*8 *8  a   a(    ` BUY WORKSHEET/DIVIDEND WORKSHEET1=SELL WORKSHEET"jb(3 A@@  $*!Brokerage Firm:Brokerage Frim: Company Name (symbol)Year: Yield (at time of payment) Dollar AmountReinvested (Y/N)Gross Sale AmountNet Sale AmountGains (+) and Losses (-) Short Term Long Term2Total # of Shares Currently Held at this Buy Price Date of SaleDate of Purchase Date Div Paid# of Shares Sold# of shares boughtStockBoxFinancial.com StockBoxFinancial 2007+Sell price/share (includes sell Commission)Sell Comission AmountBuy DateFrom Buy WorksheetSELL WORKSHEET - BetaDIVIDEND WORKSHEET - BetaBUY WORKSHEET - Betaprice per shareTotal Comission Amount+Total Cost Per Share (including commission)%Total Dollar Cost Including CommisionPrice per Share-Buy price per share (includes buy commission)*\ Sj Hcc   U  dMbP?_*+%MAdobe PDFS odLetterPRIV ''''0\KhCFF0EBDAStandard"d??U} 8}  }  }  }  }  } } q                    $  #     * * * *  *%? )D  @DDBE/D  @DDDB( %  ?  )D   @D D B  9  /L  @LLLB )?  )D   @D D B    )?  )D   @D D B    )?  )D   @D D B    )? )D   @D D B    )?)D  @DDB )?)D  @DDB )?)D  @DDB )?)D  @DDB )? y)D  @DDB )?)D  @DDBE/D  @DDDB)?)D  @DDBE/D  @DDDB)? )D  @DDBE/D  @DDDB)))%6  zlllllllll     (     Bx>' XPP? Z]4@x>'P . q.eUFH <This column is extremely important because if you buy a stock at different prices and then sell it later you can pick the "buy price" for your stock and calculate your gains and losses on the individual transaction (i.e., if you bought GE at 10 and 12 dollars and then decided to sell the stock you could choose either to sell the shares bought at 10 or the shares bought at 12 and then calculate gains or losses). Note that you must still own shares at a certain buy price in order to use that price in your gains and losses calculations for tax purposes. For example, let's say you bought 100 shares of GE at $12 and another 100 shares at $10. If you sell all 100 shares you bought at $12 and you wanted to sell more shares, then you would have to use the buy price of $10. We strongly recommend you keep this column accurate and current. Also, always double check to make sure you still own shares at a given buy price before selling and never sell more shares at a given buy price than you have previously purchased. For tax reporting purposes, this method for calculating gains and losses is called specific identification. If you are using the "first in first out" method for calculating gains and losses this column is not as important but we still recommend that you keep it up to date.< >%  B>' XPP?d  ]4@>' . r1Gh <The total cost (of the buy) including commission equals the # of shares bought (column C) times the price per share (Column D) plus the total commission amount (Column E)< tm  B?' XPP?h  ]4@?' . Zc`?REI%mwE u<vThis is the Price per share when you encorporate the commision. The Price per Share (including commission) equals the total cost with commission divided by the # of shares bought. For example, if the total cost with commission is $1000 (from column G) and the # of shares bought is 100 (from column C) then the price per share including commission (Column F) equals 10. < u~~  <'XPP?m]4@'#. %7nh LJYt .</The Price per Share when the stock is bought. <f.~~  <H'XPP?{]4@H'*. Mc{%MI m<nThe total commission paid to buy the stock (note that this does not include the commission to sell the stock)< (mTd   Chandler Joseph Lutzu Chandler Joseph Lutzu Chandler Joseph Lutzu Chandler Joseph Lutzu Chandler Joseph Lutzu>@7yK StockBoxFinancial.comyK \http://www.stockboxfinancial.com/yX;H,]ą'cggD   57  dMbP?_*+%MAdobe PDFS odLetterPRIV ''''0\KhCFF0EBDAStandard"d??U} } q } /}  } q      $  #    0 * *%  %  1%  && F` H(    B@7yK StockBoxFinancial.comyK \http://www.stockboxfinancial.com/yX;H,]ą'cggD   CV  dMbP?_*+%&?'?MAdobe PDFS odLetterPRIV ''''0\KhCFF0EBDAStandard"d??U} U }  } 8 } q } 8 } 8 }  } }  } } q} }          (                         " $  #     --*****  .  . + , , + + , , , ,  ,  ,  , !'& LL : 0L  @LLLB !$y  LLLD  .DDm  @$  @BD .DDm  @$  @B '&     !     8  .LLm  @, @B   8  .LLm  @, @B '     !         '     !         '     !         '     !       '  !       '  !       '  !       '  !        ' LL :0L  @LLLB !  LLL      '  !       '  !       '  !       '  !       '  !       ' !' !' !' !' !' !' !' !DBlDD6"""Dt!    .0 (    Bn' XPP?  Q i]4@n'4. ` I".s <Total dollar amount sold i.e., if price/share=$10 (from column G) and # of shares=5 (from column E) then Gross Sale Amount=5*10=50 dollars<+  Bdn' XPP? i ]4@dn'. 'f/-Hfb  <Total amount of dollars made or lossed after the cost of buying the stock including the buy and sell commission. Note that this number is reported to the IRS on the form 1099B as gross proceeds< '' &, ^  Bn' XPP?w]4@n'. v?@CX4ҢO $<%The price per share including commission in which you bought the stock. This number is found in Column F of the Buy Worksheet. If you bought the stock multiple times make sure you properly specify the correct "buy" price; and make sure you still own the shares bought at that "buy" price. <}$  B,o' XPP?  ]4@,o'. ѵ@| <"Short Term" Gains and losses are for stocks held for less than or equal to one year and are taxed as normal income. Note that these gains and losses are calculated incorporating commission<   Bo' XPP? s ]4@o'4. .٥HoM <"Long Term" gains and losses are for stocks held for more than one year and are taxed at a lower rate (either 5% or 15%, depending on your income) than stocks held for the "short term"<q=~~  <o'XPP?  ]4@o' . nG!DC;( @<APrice per Share at the Date of Sale not including the commission< @    BXp' XPP? /]4 @Xp'|. b,^JLn2O <Chandler & Joseph: This is the Sell Price/Share incorporating the sell commission. To calculate the sell price/share with commission add the Gross Sale Amount (Column H) and the Sell Commission Amount (Column F) and take the sum and divide it by the number of shares Sold (column E). For Example, if the Gross Sale Amount is $510 and the Commission is $10 and the number of shares sold is 50; then the Sell Price/Share including the commission is (510-10)/50=10 dollars per share<     Bp' XPP?8J]4 @p'`. &Xm @C)  R<SThe date you bought the stock which can be found in column B of the Buy Worksheet < uQR   B q' XPP? ]]4 @ q'. )ֱ8KU+G <The information for these 2 columns can be found on the Buy Worksheet. Remember that if you bought the stock in a different year then the necessary information will be in a different excel file.<    Chandler Joseph Lutzl Chandler Joseph Lutzl  Chandler Joseph Lutzl Chandler Joseph Lutzl Chandler Joseph Lutzl  Chandler Joseph Lutzl  Chandler Joseph Lutzl  Chandler Joseph Lutzl  Chandler Joseph Lutzl>@   7yK StockBoxFinancial.comyK \http://www.stockboxfinancial.com/yX;H,]ą'c Oh+'0HPp Chandler Joseph LutzChandler Joseph LutzMicrosoft Excel@=+@X5@iQk՜.+,D՜.+,< PXh px Student BUY WORKSHEETDIVIDEND WORKSHEETSELL WORKSHEET  Worksheets 8@ _PID_HLINKSAl^"http://www.stockboxfinancial.com/^"http://www.stockboxfinancial.com/^"http://www.stockboxfinancial.com/  !"#$%&'()*+,-./012346789:;<>?@ABCDRoot Entry FWorkbookiSummaryInformation(5DocumentSummaryInformation8=