A fundamental research process forms the foundation for a large proportion of global fund managers. All managers that adopt a fundamental research methodology in their investment process however, suffer from the same technical challenges or malady – Excel®.
Don’t get me wrong, I truly believe Excel to be one of the most useful and powerful tools in the computing era and particularly the financial markets. The fact is Excel has allowed everyone to become a developer. And I do not agree with CTOs that claim to want to get Excel out of their research process. So what is this technical challenge or malady that I am talking about?
A fundamental investment process differentiates itself from say a purely quantitative or passive process in that heavy lifting needs to happen before one can compare the companies in a fund’s investable universe. The universe can comprise of various geographical regions (emerging and developed markets) and sectors (resources, IT and retail). A fundamental analyst therefore needs to consider multiple aspects in their research report, particularly
The goal of the analyst is to estimate the future profit outlook of the said company. Models vary, but most fundamental analysts produce a forecasted EPS, DPS and Forward PE for at least the next 3 years. This information allows the analysts to estimate the expected total returns for the company over the next couple of years. Consolidating all the fundamental research allows the manager to establish a ranking model on the investable universe.
The ranking model is a powerful tool for the fund manager. The ranking model provides various views such as
The ranking model drives, constrains and focuses the conversations held every morning in the investment meetings and around coffee tables. It is the pivotal key to all fundamental research processes.
If one asks a fundamental analyst to produce a research report on a copper mining operation in Angola or a retail company in the UK, they would immediately reach for Excel. Excel provides the framework with which the analyst can navigate and model the effect of a particular strategy on the company’s financial statements. Furthermore, a spreadsheet provides all the tools required to come up with a model to forecast the EPS, DPS and Forward PE. The one fact that you can be certain about is that the spreadsheets used to model the mining and retail companies mentioned above will look very different. And it is here that the malady arises. How does a fund manager access and combine the relevant output from these myriad of differing spreadsheets into a single ranking model? And how can this be seamlessly maintained going forward?
This is where Quintessence steps in. I have written articles on this generic problem statement and how Quintessence technically solves this problem. In short, we allow analysts to continue working in spreadsheets yet ensure that all common information, such as that required to generate a ranking table, is warehoused centrally.
Quintessence allows analysts to continue using Excel in their unique way and at the same time ensures that the outputs from their models are centrally accessible by other systems and users. This allows for the dynamic creation of ranking models and other reports required by the fundamental investment process.