4. Holistic model for financial analysis

Chapter 4


by: josavere


The strategic planning which is prepared with interdisciplinary groups and must be quantified, begins with a key question: where are we, and we continued with two more questions: where do we go? How did we do?
Determining where we are requires a careful evaluation supported by quantitative indicators that are representative and solid enough to allow a clear idea of ​​the trend and facilitate the estimation of a possible future value, as a basis for defining the variables to be involved in the strategic plan. , to which now with the Digital Revolution, using Artificial Intelligence (AI) that is designed to identify contexts and scenarios, work with some predictive models and make autonomous decisions and BigData with the capacity to process huge volumes of information, design is greatly facilitated of models following the outlines presented in this chapter, complemented by the pronouncement of the Davos Forum in January/2020, speaking of CONSCIOUS CAPITALISM that defined the purpose of a company of the fourth industrial revolution: "involve all interest groups in the generation of shared value and sustained including local communities and society" and whose manifesto set out a single objective: to build a more sustainable and inclusive world.
Business Intelligence with ETL operations (extraction, transformation and load) to extract data from a source and place it in a destination base, combining them load information. Starting with auto-refreshing dashboard metric builder templates, keeping all reports and dashboards up-to-date with high-impact visuals for reporting,

The strongest criticism of the financial data makes it corresponds to what happened and the decisions relating to the future, a matter that can improve using statistics, looking for trends via simple linear regression, in the event that the behavior of the data allows. If the linear correlation coefficient of the variable under study is greater than 0.9, states that positive correlation exists and if everything continues as it is, the predictable future value, which becomes a basis for analyzing how to improve it through a proper strategy and good execution. For this purpose, we deal with the most representative items of the balance sheet, the income statement, and equity.

The model is constructed to " TALK " using vertical analysis, which allows us to see the relative importance of all items of assets, liabilities, and equity (financial structure) and blue ink marking the areas of greater relative importance for the particular company because they are the priority that should be addressed to improve performance. Based on the horizontal analysis, we mark with red the areas that have increased less than proportionally, which have become brakes.

Subsequently, we developed a matrix with the financial indicators of liquidity, activity, debt coverage, and profitability, calculated based on the above figure and especially, the EVAC and (corrected value generation and projected) which includes investments in CSR ( corporate social responsibility).

We conclude with a cash flow projected to see availability after attending the priority commitments to keep the company generating unit value, namely:
1) Fiscal, where all taxes both national, municipal, and departmental clusters.
2) Labor, has priority legislation. Includes everything that has to do with legal and contractual aspects.
3) Operation, where all expenses are necessary to keep the business going.
4) Suppliers, partners in practice members of the value chain.
5) Financial institutions with which relations support must be in strict compliance with the obligations.

The sum of these expenditures, broken down by month and totaled to Dec / 31, allows us to calculate what percentage of the total corresponds to each group and to determine the value of a day of the treasury, greatly facilitating decision-making. Deducting the total monthly expenses from the expected income, the availability to attend to matters related to CORPORATE SOCIAL RESPONSIBILITY and SUSTAINABILITY is calculated, which includes dividend payments to shareholders, a group that deserves priority and equitable treatment that encourages it to keep your investment.
Copyright © 2020