Equity FAQ | Fund FAQ | Equity Glossary | Fund Glossary | Methodology Documents | Corporate Website![]()
Solutions |
Equity FAQFinAnalysis FAQQ: Are historical annual balance dates available in FinAnalysis “Historical Data Search”? This is only available under “current data search”. However, this can be arranged as a special one off feed - our helpdesk can put you in touch with our sales team regarding pricing. Keywords: balance dates Q: How do I find the market capitalisation for a company as at the balance date in FinAnalysis? In FinAnalysis, perform the following: 1. Select category: Annual Ratio Analysis At the bottom of this, there is a darker blue box (Search Scope) where you can enter the code that you would like to search for. Enter the code in the space provided. 6. Click on Run Query This would give you the annual market capitalisation for the balance date of the company that you are searching for. Keywords: Searching, Market capitalisation Q: How is the one-year growth in total asset calculated under historical data search function? (TAyr2-TAyr1)/TAyr1 where TA is Total assets Keywords: growth, total asset Q: I am trying to perform a search in FinAnalysis for companies’ pre-tax profits. I can’t seem to find this item. Where can I find it? Pre-tax profit is classified in FinAnalysis as “EBT Before Abs.” (i.e. Earnings Before Tax and Abnormals). Keywords: Pre-tax profit DatAnalysis FAQQ: I am receiving email alerts from DatAnalysis which I would like to cease. How can I do that? You can modify alerts which you receive from within DatAnalysis. Simply go to the “Alerting Tool” link on the home page to add, remove and edit alerts. Keywords: Email Alerts Q: When I try to download search results, it cuts off the last 100 or so companies. How can I download the whole list of companies? The issue is that when the search is performed and the result exceeds 2500 entries the download truncates at the 2500th entry. You can either: Keywords: Download limit Q. How can I get the market capitalisation for the ASX200 companies as at a certain date, for example: 20/08/2009? In DatAnalysis, run the following Advanced search: First query: Second query: Click on Search Keywords: Market capitalisation Q: How far does DatAnalysis go back in its historical records? DatAnalysis has data going back to September 1989. Keywords: Historical records Q: In DatAnalysis, I want to search for the capital history of all companies which are headquartered in Queensland. How can I do this? Using the Advanced Search function (which you will find a link to on the Home page), perform the following: The following screen will contain the necessary capital history information. Keywords: searching, head office state Q: I am trying to obtain the quarterly earnings reports for a company in DatAnalysis. How may I obtain them? We do not keep a display of quarterly reports as we do for interim and annual reports but you may obtain quarterly earnings reports in the form of announcements from Imagesignal search (which is linked to on the DatAnalysis home page). Under Imagesignal search, type in the ASX Code for the company you are after and then choose "Periodic Reports" as Announcement Type. Choose the date range you are after then click on “SUBMIT”. You will have to manually filter through the results to obtain quarterly reports as this will contain all types of reports. Keywords: Searching, Financial reports Q: I am trying to download the head office address, telephone, fax, email and the internet address for a list of companies. How do I do that? In DatAnalysis, go to Advanced Search and perform the following: 1.Select category: Corporate Details Select the companies that you want to search on the left hand side of the page under Search Scope. There is a field where you can type in the ASX code of the companies that you want. Alternatively, you can also select companies by sectors. In the search result page, check the box for SELECT ALL. Click on the "Create Report From Selected Companies" button. Please note that there is a limitation of selecting 335 companies at a time to create this report. In the Reporting Tool page, choose the following options: 1.Select Section: Corporate Details Click on Add Query and then on Run Query. The next page will load up with the details. There is a download function on the top of the page that allows you to export the information into an excel spreadsheet. Keywords: Corporate details Q: I am trying to perform a search with the wild card operator in DatAnalysis however this returns me an error message. What is the problem? Sometimes you may need to narrow your search, especially if it is a field which would return results for all companies in our database. DatAnalysis is not capable of performing such a search. We suggest that you use the create report function. This will effectively narrow the scope of your search closer to what you are looking for. If you are still looking for a particular piece of information on every company in our database, try to split the search up into smaller parts. Keywords: Searching, Wild card Q: How can I find the issue price of a share in DatAnalysis? The issue price is shown under Company History & Listing Details in DatAnalysis. Keywords: Issue price ResearchLink FAQQ: On the Comsec website, we have 2 conflicting information of the high and low prices during the 52 week period, one under Market Depth and the other in the Research page. Which one is correct? The data showing on the Research Page is from Morningstar/AspectHuntley while the price under Market Depth is sourced from another data provider. Keywords: high low price Q: Would you please clarify how the Huntley narrative of 9/6/09 (for CSL) refers to an estimated value of the shares at $40/43, whilst the value shown in the "Tools" section is shown as $24.59? The “tools” section is designed for the users to work out the stock valuation by inputting all relevant factors in and it also allows the users to see the impact when each factor is changed. Therefore, the valuation in this section can be varied depending on how the users will change the factors. Keywords: Value Model Q: How are value ranks determined? What does a value rank of 4 mean in comparison to 3 and so on? Value rank is based on our determination of intrinsic value. We first determine a value for a share using our valuation models and then divide it by the current share price. This ratio is an indication of potential temporary mispricing in the market: A figure lower than one suggests that the stock is overvalued, a rank higher than one suggests it is undervalued. Keywords: value rank Q: Why are there no "Forecast" earnings and dividends for some stocks in the Key Measures page? Companies that are not covered by our consensus estimates contributors are not available for display in the Forecast page or in the Earnings and Dividends table. Keywords: Forecast, dividend Q: Why does the dividend yield in Research snapshot and in Historical Financials differ significantly? In the Snapshot, the current dividend yield reflects the historical dividend and current market price, which was calculated by taking "historical DPS"/Yesterday's close price. Keywords: dividend yield Licensed Datafeed FAQQ: We have not received an ASX Code Change in the file. Can you advise why this is missing? Sometimes there are delays in getting code change details from the ASX We endeavor to process code changes as they arrive from the ASX however if delays are encountered the code changes will appear in subsequent files once the data is received. Keywords: Code change Q: We are receiving old warrant codes in the data file you are sending us. Can you please stop sending them? We do not remove old codes from the securitymaster/warrants table until we get a remove record indicator from the ASX. The old code and new code will always be present in the securitymaster/warrants file, unless it is removed (which can happen only if ASX initiates it). Keywords: Warrant codes Q: We seem to have missed downloading the zip file which contains AspectASXFinancial.csv on one day. Does this file contain incremental changes or are they full replace files? The data contained in AspectASXFinancials.csv is incremental in nature. Hence if you miss downloading the file for one day, you will need to go back and process that before processing files from days after. Keywords: Financials data file Q: With regard to your financial data files, can you tell me how you deal with the re-use of an old ASX code by a new company? When an ASX code is reused, a “1” is appended at the end of the ASX code for the old company. A new entry without the “1” is created to represent the new company. We next update historical ASXFinancials data for the old ASX code. Keywords: Financial data file, ASX codes Q: Why is there only 6 years’ worth of data displayed in charts for NZ stocks? We only have data for NZ stocks going back to 2003. Thus the charts can only display 6 years at the moment. We are in discussions with another party to obtain more history and therefore back fill the database. Keywords: Historical data, New Zealand AlertsQ: I have some alerts set up but they are not showing on the drop down list under Saved Alerts - I need to edit the alerts but cannot access them. Let us know what the IP (external IP) address the user is using to try to modify the alerts. It's possible that the user is attempting to view the alerts using a different computer - this could be the reason the user is not seeing the correct list of alerts. If you don’t know what the external IP address is, please visit the following link: http://www.whatsmyip.org/ to see if you get back a different (i.e. EXTERNAL) IP address. Keywords: Alert Q: How many companies can I track on the one alert? That is, how many ASX codes can I monitor? I just tried 200 and that didn't work - could you let me know the ideal number thanks. Can we run these alerts on the ASX 200? Try lots of 50. You can also refine each alert for specific types of announcements. Keywords: Alert Announcements FAQQ: We believe we’re experiencing a delay in receiving Signal G articles. Can you please tell us what time you usually start sending them? Do you have a start-of-day or end-of-day notification for it? There is no fixed time for Signal G articles, as they are sourced from market sensitive company announcements. If there are no market sensitive announcements for the day yet, there will be no Signal G articles. We can however experience server issues which may delay the delivery of articles. There are currently no SOD or EOD notifications for Signal G. There are for Comnews (they come through with ASXCode: ZOR). These come through directly from the ASX and may come through at any time between 07:30 and 08:30. Keywords: Signal G Q: I cannot see any announcements coming through for company XYZ which is currently suspended from trading. Why? Companies suspended longer than 3 months will not have announcements flowing through the data feed. Keywords: Announcements, Suspended from trading Charts FAQQ: Why is it that for some companies the charts are not up to date, while for others they are? Often the problem is due to charts/other graphics being stored in cache by your graphic server. You will need to clear the cache to display the latest charts. Keywords: Outdated charts Reporting Financials FAQQ: Although the reporting season is over, there are a number of companies for which the financial reports are not yet available. When can I expect these? The reporting deadline for mining exploration entities is usually 2 weeks after the deadline for other companies. Many do not report until the last week before the deadline. Quite often, some of these companies report after the deadline. We will endeavor to complete reports as soon as they are released by companies. Keywords: Reports, Outstanding Q: Your company profile on my online broker's website has ceased under the previous ASX code and without continuity being transferred to the new code. It seems like the issue is on the broker's website end. If we display previous announcements on any of our websites then the issue is not with Morningstar. You may want to raise this with the broker via their helpdesk and request them to refresh the data feed that we provide. Any charting issues on broker websites should be redirected to the broker themselves - Morningstar does not develop or distribute charting software. Keywords: code change, chart Q: How would you treat Commodity related risk management activities and Net foreign exchange hedging gains (loss)? Aren't these significant items? I don't think they have been reflected in the Dec08, June09 and Dec09 figures. According to our analysts those items should not be treated as significant items as they have been part of the business as recurring items. Q: Market cap for Cape Alumina (CBX) is $36million based on a price of $0.50/share which implies outstanding shares of 72million. CBX's latest quarterly report indicated about 129milllion shares outstanding (with 9.2m unlisted options) which would imply a market cap of closer $64.5million. Are other warrants/options/etc you may be taking into account? (Still, is 'market cap' not defined as price x shares outstanding? with any other options/warrants or other liabilities/contingencies reflected already in the share 'price'?) In Australia the definition of outstanding shares is just the quoted shares that's being traded on market excluding treasury stocks. The figure 129,050,803 that's provided in the latest quarterly is the total shares on issue, and that is a different figure from the total shares outstanding, which is 72,709,274 as provided to us by the ASX. Q:The EPS on your website compared to what was in the announcement for CSL seems quite different. How is this explained? Or is it a typo on our end? The figure on the Website has been "normalised" – The Analyst removed $159m of what he considered extraordinary items to get to $1,020m NPAT and then he used the weighted number of outstanding shares to derive an EPS of $1.71, rather than the basic EPS which is reported and is calculated using NPAT divided by the number of outstanding shares as at the balance date. Q: The interim dividend from BHP is in your system as $0.301267 whereas we have it recorded as $0.319376. Why the discrepancy? For companies which pay dividends not in Australian dollars, we will record the Australian dollar value of the dividend as at balance date and not as at payment date. The exchange rate is sourced from the Reserve Bank of Australia. Keywords: Foreign currency, Dividends Financial CalculationsQ: How is total shareholder return calculated? Total shareholder return is calculated by taking into account all price changes and reinvestment of dividends. It includes the effect of bonus issues and splits. This figure is calculated pre-tax and is annualised. Keywords: Total shareholder return Q: What does the “Current” figure refer to in the set of Forecasts generated for EPS, DPS, PE and Yield? Is it the current forecast for this year? The current figure refers to the actual figure as at the moment. Reflecting the latest Annual figures released. Keywords: Forecasts Q: How is dividend stability calculated? Dividend stability is based on two factors: 1. the number of times in the last 10 years (or less, if data is not available), in which the annual dividend has been cut. This is converted to a percentage. For example consider a company with 10 years of dividend payment with 3 years of dividend cut. Say that the three dividend cuts were of magnitude 50%, 40% and 30%. Keywords: Dividend stability Q: Why is the 52-Week High displaying $1.54 when the stock closed at $1.70 three months ago? The High price is calculated as an intra-day high adjusted for dilutions over the past 52 weeks. The Last Trade Price may well be above the 52-Week High without changing the 52-Week High price. Keywords: 52-week high/low Q: Why is there a negative debt to equity ratio for company XYZ? If there is negative shareholder equity present in the accounts, then the resulting debt to equity ratio will also be negative. Keywords: Debt to equity ratio, Negative Q: Why is the debt to equity ratio so high for company XYZ? If a company has a heavily debt-laden structure and/or has recently experienced equity erosion, then it is quite feasible for the debt to equity ratio to well exceed 200%. Keywords: Debt to equity ratio, High Q: How is the average analyst recommendation calculated for consensus forecasts? For example, if there are 17 analysts who are rating a stock: 5 analysts with a strong buy rating, 8 with a moderate buy, 2 with a hold and 1 each with a moderate sell and strong sell, the average figure would be given by the following: Strong buy: = 5 x 1 = 5 Sum = 5 + 16 + 6 + 4 + 5 = 36 Average rating = 36 / 17 = 2.12 Keywords: Consensus forecasts, Average analyst recommendation Q: Why don’t you show a figure for Total Current Assets for companies in the banking industry? This is due to the reporting style of banking industry. Assets and liabilities are not broken down into current and non-current items. Keywords: Total current assets, banks Q: I see that for companies that have Investments in Joint Venture Entities, you list only a net asset value for those investments (i.e. you do not separate into assets and liabilities). This will surely affect various ratios. Where can I find the complete assets and liabilities totals? We only provide the consolidated net asset figure for Investments in Joint Ventures. If you require a breakdown of the net assets, it is able to be found by reading the relevant financial report. Keywords: Investments in joint venture entities Q: There seem to be quite a few companies for which the NTA figure is displayed as $0.00. Is this an error? We calculate a NTA figure ourselves from the data we gather from a company’s balance sheet, this is item # 9540. However there is also a reported NTA figure (item # 9530), which is the company’s own calculation of its net tangible assets per share. As a large number of companies have not reported a figure themselves, this displays as $0.00. Keywords: NTA, Unreported (Zero dollar) Q: I have been doing my own calculations for a company with respect to a financial report and obtain a Net Profit before Tax and Abnormals different from yours. Why? This will usually be due to our treatment of abnormals being different from yours. If some items are classed by us as abnormal, and they are not by you, or vice-versa, the figures for Net Profit before Tax and Abnormals will differ. Keywords: Abnormals Q: The consensus estimates which you have provided seem quite unreasonable. Can you please explain how you obtained them? As of 1 September 2009, Morningstar replaced Thomson consensus estimates with Morningstar's consensus estimate data. The contributing brokers are listed below: JP Morgan CBA Institutional Equities Austock Securities Limited E.L. & C. Baillieu Stockbroking Ltd Foresight Securities Pty Ltd Hartleys Limited Morningstar Australasia Pty Limited Ord Minnett Patersons Securities Shaw Stockbroking Southern Cross Equities BMO Capital Markets We are in discussions with a number of other brokers to contribute to the product and will add them as soon as we have agreements in place. Keywords: Consensus forecasts Q: What is the methodology behind your calculation of beta? Is it with reference to the Australian market? We adjust the beta for a company by using the beta for the industry that the company is in. We do this as r-squared (the predictive power) is very low if using the company beta alone. It is indeed with reference to the Australian market and the calculations are performed by the Australian Graduate School of Management in Sydney. Keywords: Beta Q: How do you calculate the value of a stock in your value model? There isn’t a direct formula to that valuation. The system runs through many iterations of a query to find the valuation. Keywords: Value model Q: Can you tell me how you calculate the tax-adjusted dividend yield? The tax-adjusted dividend yield is calculated by including the effect of imputation credits from franked dividends. For the purposes of the calculation, it is assumed the shareholder is on the top marginal tax rate of 45 percent. Shareholders on a lower tax rate will have a higher after-tax dividend yield. Assume for a certain stock a DPS of $1.36 and a price of $16.29. Hence Yield = 1.36 / 16.29 = 8.4%. Now assume franking of 100%. Imputation credit = DPS * (company tax rate / (1 - company tax rate))* % franking Tax-adjusted dividend yield = (DPS - ((DPS + imputation credit) * personal tax rate - imputation credit)|DPS - ((DPS + imputation credit) * personal tax rate - imputation credit)) / Price _Keywords: Dividend, Tax-adjusted yield of Q: How do you calculate the earnings surprise figure? The system compares the consensus EPS forecast and reported EPS. If say for a company the consensus EPS forecast was 5.80 cents per share; however, the actual EPS was 5.31 cents per share. Earnings surprise = (5.31 / 5.80) - 1 = -8.4%. Keywords: Earnings surprise Q: Can you tell me how you calculate your NTA figure? Our NTA figure (which should not be confused with the NTA figure as reported by the company) can be calculated approximately by the following: First, calculate Net Tangible Assets: NB: If the EPS is not supplied, then it may be replaced with the total number of shares outstanding to arrive at the approximate figure. Keywords: NTA, calculation Q: I can’t seem to get your Return on Capital (ROC) figure. How do you calculate it? ROC = Net profit after tax + (Net interest expense * (1- Corporate tax rate)) / (Long term As seen, the addition of net interest expense back to the net profit after tax has incorporated the tax shield. Keywords: Return on Capital Q: Why do I see a PEG ratio of 10 for so many companies? And why is it that many companies which display a high rate of growth in the PEG ratio are also classified as lowest in growth? PEG = (Price / EPS) / Growth Hence a high (> 1) PEG ratio is generally interpreted as a stock is overvalued relative to it its future growth prospects while it is undervalued for a low (< 1) ratio. The ratio is capped at 10 in our system, hence why many companies have a PEG ratio displayed of 10. Note that earnings per share growth used to calculate the PEG ratio is purely prospective earnings growth. However EPS growth that we used to rate the stock for growth is based on the company's historical performance and the consensus estimates of future EPS growth. This rank is designed to highlight companies which have both a demonstrated track record in EPS growth, as well as good future prospects. Keywords: PEG ratio Q: I can’t seem to obtain your free cash flow figure. Can you tell me how you calculate it? The free cash flow figure we provide under item # 9000 is an after-dividend version: Keywords: Free cash flow Q: I would like to know how you calculate ROE and ROA for an annual report. Are they performed on end-of-year assets and equity or are they an average of the two half-years? The ratios are based on actual end of the year assets and equity. Below are the formulas for ROE and ROA: Keywords: Return calculations (ROA and ROE) Q: Can you tell me what is generally included in “Other Financing Cash Flows”? Would share buybacks be classified within there? Share buybacks would usually be classified under "Other Financing Cash Flows" in our database. Generally, "Other Financing Cash Flows" will cover items other than proceeds from issues, proceeds from borrowing, repayment from borrowing and dividend paid. Keywords: Other Financing Cash Flows Methodology to calculate Spread, Cost to Income ratio and Cash per share 1) Spread = Rate of interest earned on interest-bearing assets minus the rate of interest expense on interest-bearing liabilities 2) Cost to Income ratio = Non-interest costs / Total operating income 3) Cash per share = Cash (use Short Term Money to calculated in FinAnalysis)/ Number of shares outstanding at the end of the period Keywords: spread, cost to income ratio, cash per share Q: How is total capital invested and gross investment derived? Operating Invested Capital is calculated by adding operating working capital, net PP&E, intangibles and other operating assets net of other operating liabilities. Gross Investment is the increase in Working Capital + Capital expenditure Keywords: capital, investment Q: Is extraordinary items figures before or after tax? Extraordinary items are provided After tax. Keywords: Extraordinary items Non-Financial FAQQ: How did Substantial Shareholder X come to have Y number of shares in a company? Our data on substantial shareholders is based on what is released in annual reports. We however capture announcements released to the market in regards to changes in holdings. If there has not been such an announcement made, we will not be able to account for changes in holdings between financial years, after an annual report is released. Keywords: Substantial shareholder Q: Does Morningstar have data on foreign ownership levels in different Australian companies? Unfortunately no, Morningstar does not have information pertaining to foreign ownership in Australian companies. We do have the lists and transactions of substantial shareholders and top 20 shareholders; however, listed companies do not disclose the nationality of their shareholders. Keywords: Foreign ownership Q: Some of the dates in your corporate calendar, for company reporting, differ from those displaying on company websites. Can you please update your calendar? Reporting dates are estimates which are received directly from the ASX. Unless there is an official announcement by a company to the ASX regarding a date change, we will not change reporting dates. Keywords: Corporate calendar Q: Do you provide restated figures and if so how do you indicate it? Unfortunately we do not provide restated figures in our database hence all figures are as such in the report announced to the market on release date. Keywords: Restatement of figures Q: What does “base metal” refer to? Base metal refers to industrial non-ferrous metals excluding precious metals. This includes copper, aluminum, lead, nickel and zinc. Base metals do not include iron ore. Iron ore is classified under bulk commodity. Keywords: base metal Do you have any questions and or comments? use our feedback
|
New Product Features Announcements 13-01-2011 Upcoming fund performance release dates can be found in our Fund Performance Data Release Schedule page.
|