Adjusting Summary Financial Analysis Page

This page explains how to interpret, adjust and change the summary financial analysis page of the financial database. This page has summary statistics including returns, market values, valuation ratios, credit ratios, forecast earnings and other data. After reading in the data I often go to this page to make sure the financial ratios have been correctly established. If you are reading in data for one industry you can also scan ratios such as the price to book ratio, the return on equity, EBITDA trends and other items across different companies. The financial ratios and other summary information is in the sheet named “Single Company Graph”. This webpage illustrates how the Single Company Graph can be used in financial analysis and it also explains how you can modify the sheet to do things like add more financial ratios and also how you can trace the analysis to make sure the numbers are correct.

The Single Company Graph includes three different graphs. The top graph is primarily used for equity analysis with data like ROE, P/E, Net Income and the Price to Book ratio. The graph is primarily from the free cash flow perspective.  I have include a few graphs that illustrate the types of ratios you can use once you have the data loaded.  This analysis of graphs can be more effective if you compare graphs within and industry.  You could also work through the calculations and create your own ratios.

The third graph shows how to evaluate quarterly data as well as annual data. The quarterly graph has annual numbers divided by four for the first periods and then quarterly data taken from the quarterly statements. There are a few different ways to use the quarterly data and some of these are illustrated in the page.

The idea is that you can push the spinner box up and down to find the same ratio for different companies. The second concept is that you can quickly look at different comparisons to get a story about what is happening with the company. The forecasts allow you to quickly evaluate the forecast relative to the history.

Note that when you are looking at data that does not have forecasts, many of the items will be FALSE or zero. The screenshot below illustrates the Single Company page for Air Asia.

Tracing the Location of the Item that is Graphed

The data is extracted from a very long CHOOSE Function that is implemented either in the Equity Trend Analysis, the EBITDA Trend Analysis or the Quarterly Analysis. The CHOOSE function is used because the companies and the different items must be selected. The CHOOSE function is computed on the This makes a simple INDEX function difficult to use. The CHOOSE function is way too long and I hate that I did not do this in a more elegant manner. But if you want to find the items you can go to the page named “Equity Trend Analysis” for the first graph and “EBITDA Trend Analysis” for the second graph. The list in the “Equity Trend Analysis” shown in the screenshot below demonstrates how the long CHOOSE function can be adjusted. The cell reference column demonstrates how you can go to the relevant sheet and then further trace the data.

Once you go to the relevant cell reference you can then see where the data comes from.