Simple investment portfolio excel

Document Sample
Simple investment portfolio excel Powered By Docstoc
					                                                                                            Total cost of accounts                                         $18,770.00
Portfolio Analysis                                                                          Value of accounts                                              $19,553.50
                                                                                            Unrealized gain/loss $                                            $783.50
10/7/2012
                                                                                             Unrealized gain/loss %                                              4.17%
                                                                     Purchase                Total Cost
                                                                     Price Per    Trade      (Purchase Price Current                                       Gain/Loss
Investment Name       Account Name or Number   Symbol   Quantity     Share        Fees       + Fees)          Quote      Market Value     Gain/Loss ($)    (%)
A Datum Corporation   Woodgrove Bank           AAAA              100 $      49.00 $    29.00 $       4,929.00 $    56.99 $       5,699.00   $      770.00       15.62%
Adventure Works       Woodgrove Bank           AWAW              250 $      21.56 $    13.00 $       5,403.00 $    19.13 $       4,782.50   $     (620.50)     -11.48%
Wingtip Toys          Woodgrove Bank           WWTT            1200 $        7.01 $    26.00 $       8,438.00 $     7.56 $       9,072.00   $      634.00        7.51%
Total                                                                                         $     18,770.00            $     19,553.50    $      783.50        4.17%
      Percentage based on market value




                            29%


46%




                                         A Datum Corporation
                                         Adventure Works
                                         Wingtip Toys
                           25%

				
DOCUMENT INFO
Shared By:
Stats:
views:78
posted:10/7/2012
language:English
pages:2
Description: Just a simple investment portfolio to input your investments and see weights