171x Filetype XLSX File size 0.03 MB Source: www.asx200list.com
Sheet 1: DISCLAIMER
Portfolio management spreadsheet. | |||||||||||||||||||||||||||
Some basic Excel knowledge is required to use this spreadsheet. | |||||||||||||||||||||||||||
Three Tabs | |||||||||||||||||||||||||||
1) Open Positions | |||||||||||||||||||||||||||
2) Dividends | |||||||||||||||||||||||||||
3) Closed Trades & Tax Summary | |||||||||||||||||||||||||||
Instructions | |||||||||||||||||||||||||||
1) Enter data into any white box | |||||||||||||||||||||||||||
2) If an additional line is required - click the number in the left column of the lowest blank line > right click > Insert | |||||||||||||||||||||||||||
3) A new blank line will appear above | |||||||||||||||||||||||||||
4) To ensure the spreadsheet's formula applies to the new cell - click a yellow cell above the new one (it contains the formula) | |||||||||||||||||||||||||||
5) A "square" will appear in the bottom right. Drag it down to your new cell. | |||||||||||||||||||||||||||
Disclaimer | |||||||||||||||||||||||||||
* This is not commercial software so please understand that you use it at your own risk | |||||||||||||||||||||||||||
* I don't offer support | |||||||||||||||||||||||||||
* ALWAYS CONSULT AN ACCOUNTANT PRIOR TO LODGING A TAX RETURN | |||||||||||||||||||||||||||
* Feel free to modify this speadsheet | |||||||||||||||||||||||||||
* Please don't upload this to any website. Direct people to this website to download the latest version. | |||||||||||||||||||||||||||
OPEN POSITIONS | ||||||||||
Stock | Date | Units | Price | Brokerage | Net Cost | Ave Price | Cash in Bank | |||
DGD | 2/1/2009 | 334 | $34.00 | $19.95 | $11,375.95 | $34.06 | $76,392.00 | |||
REW | 5/13/2010 | 4,555 | $7.45 | $88.00 | $34,022.75 | $7.47 | ||||
OKI | 12/11/2010 | 40,000 | $1.56 | $234.00 | $62,634.00 | $1.57 | ||||
TYH | 3/1/2011 | 8,000 | $2.56 | $455.00 | $20,935.00 | $2.62 | Position Size Calc. | |||
BVB | 5/13/2011 | 1,300 | $7.45 | $88.00 | $9,773.00 | $7.52 | Dollars | $12,000 | ||
SRE | 12/11/2011 | 30,000 | $1.56 | $234.00 | $47,034.00 | $1.57 | Price | $1.60 | ||
MKL | 3/1/2013 | 12,000 | $2.56 | $455.00 | $31,175.00 | $2.60 | Units | 7,500 | ||
Net Total Cost | $216,949.70 | |||||||||
Dividends | |||||||
Stock | Payment Date | Unfranked Amount | Franked Amount | Franking Credit | Net Dividend | ||
GFG | 8/13/2013 | $100.00 | $300.00 | $350.00 | $400.00 | ||
TOTAL | $300.00 | $350.00 | $400.00 | ||||
Net Dividend | $400.00 | ||||||
Franking Credits | $350.00 | ||||||
TAXABLE DIVIDENDS | $750.00 | ||||||
Dividend Taxation is complicated. | |||||||
Visit the ATO website for examples. | |||||||
no reviews yet
Please Login to review.