Investment Tracker - [Account Nickname]
Total Invested: 1,750 Gain (Loss): 70 Annualized Return: 8.3%
Total Value: 1,820 % Gain (Loss): 3.98% (using XIRR) Current Cash: -
$2,000 Total Invested Total Value NOTES
$1,800
$1,600
$1,400
$1,200
$1,000
$800
$600
$400
$200
$-
Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16
Amount Total Gain Total % Change in % Gain(Loss)
Date Total Value Total Invested XIRR To-Date 6-Period XIRR Comments
Invested (Loss) Gain(Loss) Gain(Loss) This Period
1-Dec-15 1,000 1,000 1,000 0 0
1-Jan-16 150 1,160 1,150 10 0.9% 10.00 1.0% 12.4%
1-Feb-16 150 1,298 1,300 (2) -0.1% (11.60) -1.0% -0.9%
1-Mar-16 (200) 1,137 1,100 37 3.4% 38.95 3.0% 13.7%
1-Apr-16 150 1,310 1,250 60 4.8% 22.75 2.0% 16.7%
1-May-16 150 1,421 1,400 21 1.5% (39.30) -3.0% 4.4% 4.4%
1-Jun-16 1,492 1,400 92 6.6% 71.04 5.0% 15.9% 16.5%
1-Jul-16 200 1,687 1,600 87 5.4% (5.24) -0.4% 12.4% 17.4%
1-Aug-16 150 1,820 1,750 70 4.0% (16.87) -1.0% 8.3% 5.7%
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
Insert new rows above this one, then copy formulas down
1-Aug-16 (1,820) ◄ Used for the XIRR formula
Summary
Tab Name Total Invested Total Value Gain (Loss) % Gain (Loss) XIRR
Account1 1,750 1,820 70 3.98% 8.3%
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
TOTAL 1,750 1,820 70 3.98%
Tracking Multiple Accounts
After duplicating the Account worksheet, you can rename
the tab and enter the name of the tab into this table.
HELP
About This Template
A Few Instructions
Tips
bout This Template
This template was designed to provide a simplified way to track an investment account. It boils
everything down to tracking only what you have invested and the current value of that investment. It
doesn't track cost basis and should not be used for tax purposes.
Although some explanation is provided, the spreadsheet does not define every term and every
calculation in detail. It is up to the user to make sure they understand what is being calculated. For
example, this spreadsheet does not distinguish between realized or unrealized gains.
Few Instructions
Read the comments in the table header cells for information about each column.
The columns under "Other Information" are just examples of how you might expand this template if
you wanted to track other information. They are not used elsewhere in the spreadsheet.
Adding More Rows
Insert new rows above the last row in the table (the gray one) and then copy the previous row down
so that all formulas are copied down to the new row(s) that you inserted.
Withdrawn Principal
You can enter a negative value in the Amount Invested column to record investment principal
withdrawn from your account.
Tracking Investment Income Withdrawn From the Account
Instead of entering the Total Value in column C, you can use the blank columns to the right of the
table to track whatever numbers you want and then calculate the Total Value. For example, the total
value could be calculated as the current market value of the account plus the total income withdrawn
from the account.
Tracking Multiple Accounts
You can duplicate the Account1 tab and rename the tabs if you want to track different accounts. The
Summary worksheets allows you to enter the names of the tabs, and uses the INDIRECT function to
reference the summary information from those worksheets.
If tracking multiple accounts, you may also want to use one copy of the Account tab for tracking your
entire investment portfolio as a whole.
Using Freeze Panes
You can use the Freeze Panes option in the View tab to make it easier to scroll down to add new data
into the table while still viewing the chart and table headings.
Removing the Annoying Green Triangles
Some of the cells may have green triangles, which are supposedly meant to help you identify possible
errors. Most of the time they are just annoying.
You can customize the error checking options in Excel to avoid showing green triangles for conditions
such as "Formula Omits Adjacent Cells" by going to File > Options > Formulas and unchecking the
Error Checking Rules that you want to ignore.
