This template serves as a review and an inventory of your current investments. Begin by entering your name and the date for which the figures are current. Then enter the type of asset and the purchase details, including the date the asset was acquired, the number of shares (or other units) acquired, the price per share (or unit), and the broker fee, if any. Finally, when you enter the current per unit quote, the template will calculate all gains and losses.
To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.