Filetype Excel XLSX | Posted on 16 Aug 2022 | 3 years ago
Authentication
digital resources
178x 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.
