|#||Symbol||Company Name||Date Purchased||# Shares||Purchase Price||Purchase Value||Current Price||Current Value||Price Change||Value Change||% Change||% of Portfolio|
To import a portfolio the file or files must be in the format of CSV. The file must contain a header with the following columns (the sublists are acceptable variations of the respective column header; column headers are not case sensitive). The order of the columns does not matter. The header must at minimum contain the Symbol column.
Contact us if you have any questions firstname.lastname@example.org
The Portfolio Valuation Section is used to run all of your portfolio companies though the Valuation models we have in Stockcalc so you can make a more informed valuation decision about the companies you own or are watching. Each of the models are described here:
Overall Valuation (this is our valuation/share for the company) this is the weighted average valuation we have calculated using the models shown and based on a number of components including industry, size and other company specific factors.
Discounted Cash Flow (DCF) valuation model is used to discount future cash flow projections back to the present to calculate value per share. DCF is a common valuation technique especially for companies undergoing irregular cash flows such as resource companies (mining, forestry, oil and gas) going though price cycles or smaller companies about to generate cash flow (junior exploration companies, junior pharma, technology firms…).
The Price Comparables valuation is the result of valuing the company we are looking at on the basis of different ratios from selected comparable companies: Price to Earnings, Price to Book, Price to Sales, Price to Cash Flow, Enterprise Value (EV) to EBITDA Each of these ratios for the selected comparable companies are averaged and multiplied by the values for the company we are interested in to calculate a value per share for our selected company.
We have included the Other Comparables as a way to value companies that cannot be valued using Earnings based ratios. This technique is very useful for companies still experiencing negative cash flows such as mining exploration firms. We use Cash/Share, Book Value/Share, MarketCap, 1 Year Return, NetPPE as the ratios here Each of these ratios for the selected comparable companies are averaged and multiplied by the values for the company we are interested in to calculate a value per share for our selected company.
Multiples are similar in thinking to Price comparables where we can look at current or historic multiples to assess what a stock should be worth.
We use the same 5 ratios as used in the price comparables and value the company against its average historic values Price to Earnings, Price to Book, Price to Sales, Price to Cash Flow, Enterprise Value (EV) to EBITDA.
Adjusted Book Value (ABV) is a common valuation technique where we can adjust the balance sheet to reflect market value of the assets as opposed to using the book values represented on the balance sheet. We then multiply the adjusted book vaue per share by its historical price to book ratio to calculate a value per share.
If we have Analyst coverage for the company we show the consensus target price here.
|Symbol||Name||# Shares||Price Paid||Current Price||Overall Valuation||DCF Value||Price Comps||Other Comps||Multiples||Adjusted Book||Analyst Value|