Stock Portfolio and Asset Management Software
Enables investment and portfolio management!
Stock portfolio and asset management software in the form of a Portfolio Summary Worksheet is available from me as part of the IRR Calculations Worksheets
The portfolio Summary Worksheet allows me to undertake efficient investment and portfolio management. Contact me directly to request a virus-protected FREE COPY of the worksheets.
An Excel worksheet request from you will not result in your email address being stored in a distribution list nor be used by me for unsolicited communication with you.
My online stock broker also provides a facility to maintain an online investment portfolio which I use to monitor stock prices for the portfolio in real time.
The facility is also useful to view the current profit or loss for each share holding based on current stock prices.
However, it doesn't allow for calculation of the internal rate of return for the portfolio and for individual stocks.
It would be best to obtain and either print out the free Portfolio Summary Worksheet example, or open up the worksheet when you get it, in order to follow this discussion.
Alternatively, you may wish to use the information here to construct your own worksheet.
Purpose of the Portfolio Summary Worksheet
The worksheet allows me to undertake portfolio performance monitoring by updating share prices weekly so that the total share portfolio dollar value can be calculated.
It is also used to update the current date so that the internal rate of return (IRR) for each share and for the whole portfolio can be re-calculated for the latest date. Time is money - as they say!
This is what I mean by efficient portfolio and asset management.
The Portfolio Summary Worksheet Explained
The current share prices in this spreadsheet and the current date are linked to the share-price cells and current-date cells in each of the Share A, Share B and Share C worksheets containing the individual share information.
The Portfolio Summary Worksheet records the balance of the investment account together with any (negative) balance of the portfolio loans account when calculating the total share portfolio value.
In this fictitious example $5,000 of a margin loan line of credit of $20,000 has been used to purchase some of the shares.
The Portfolio Summary Worksheet also calculates in column E the percentage contribution of each share in the portfolio. It also displays the percentage of the cash balance in the investment account to the total portfolio value.
The net portfolio value represents the equity that the investor has contributed to the portfolio. It equals the total portfolio value minus the portion of the margin loan currently used.
The number of shares for each share holding listed in the Portfolio Summary worksheet is obtained by linking cells B5, B7 and B9 in the Portfolio Summary worksheet to the cell containing the total shares in each of the share worksheet holdings using the formula: ='Share A'!C26 etc ...
Current share prices are entered directly into the Portfolio Summary and are shared by each of the Share worksheets.
The current market values for each share are obtained by multiplying the number of shares by the current share price using the formula: =B5*C5 etc ...
The current date is entered directly into the Portfolio Summary Worksheet in cell D17 and shared with each of the Share worksheets.
Maintaining a stock portfolio and asset management system in the form of record keeping worksheets is an important aspect of maintaining efficient portfolio management.
Should you find this portfolio management system useful, your task is to replace the fictitious stock data in this worksheet with the information relating your share holdings.
Return from Portfolio and Asset Management to Internal Rate of Return
Return to Value Investing Home Page