| Literature DB >> 35392396 |
Monroy-Perdomo Leonardo1, Cardozo-Munar Carlos Eduardo2, Torres-Hernández Ana María3, Tena-Galeano José Luis4, López-Rodríguez Campo Elias5.
Abstract
As a financial indicator, Tobin's Q is related to making investment decisions based on the organization's market value related to the organization's replacement costs. The purpose of this study is to develop a methodology for predicting the trend of stock value based on the relationship between the fluctuation of Tobin's Q by sector as a trend index and the stock price variation of the Columbia stock market. To this end, a quantitative quasi-experimental survey will be conducted on shares traded by December 30, 2019. This is at least 90% of the time we have traded in the last 5 years. From the average Q value of the relevant economic sector, the value of each company's stock is adjusted to calculate the estimated price of the company's stock. If there is a disparity between the estimated value of the stock and the value at time t, you can forecast the stock price transition. If the computation yields a more significant result than what is now witnessed in the market, the next period's development will be positive; if it yields a lower result, its development will be negative. The results allow us to establish a significant influence of industry results on the performance of corporate Tobin's Q at the individual level. The significance level is greater than 50% in all cases, and profitability does not go below 30% in any sector, even reaching 100%. The methodology used in this study is essential to all investors tiny firms because it uses publicly available, freely available information, providing tremendous potential for safer non-business revenue.Entities:
Keywords: Capital markets; Competitiveness; Corporate valuation; Financial markets; Innovation; Tobin's Q; Trend analysis
Year: 2022 PMID: 35392396 PMCID: PMC8980755 DOI: 10.1016/j.heliyon.2022.e09210
Source DB: PubMed Journal: Heliyon ISSN: 2405-8440
Companies participating in the development of the methodological strategy.
| Name | Class | Country HQ | Type of Asset | Active/Canceled | Code | Economática | Presence |
|---|---|---|---|---|---|---|---|
| Banco Bogotá | Ord | CO | Stock | Active | Bogotá | Non-stock financial and credit intermediation institutions | 98 |
| Banco Davivienda | Pref | CO | Stock | Active | PFDAVVNDA | Non-stock financial and credit intermediation institutions | 100 |
| Bancolombia | Pref | CO | Stock | Active | PFBCOLOM | Non-stock financial and credit intermediation institutions | 100 |
| Corporación Financiera Colombiana S.A. | Ord | CO | Stock | Active | CORFICOLCF | Non-stock financial and credit intermediation institutions | 92 |
| Éxito | Ord | CO | Stock | Active | EXITO | Miscellaneous merchandise store | 100 |
| Celsia S.A Esp | Ord | CO | Stock | Active | Celsia | Electricity, gas and water companies | 100 |
| Grupo de Energía de Bogotá | Ord | CO | Stock | Active | GEB | Electricity, gas and water companies | 99,8 |
| Interconexión Eléctrica S.A. Esp | Ord | CO | Stock | Active | ISA | Non-stock financial and credit intermediation institutions | 99,8 |
Source: Own elaboration from Economática (n.d.).
Exito S.A.
| Percentage Variation of Market Price per-Share Projected (t - t+1) | Percentage change in Market Price per-Share (t+1 - t+2) | Model Backtesting | Simulation of Monetary Profitability (4,000,000 COP) |
|---|---|---|---|
| 31/03/2015–30/06/2015: -0,4545% | 30/06/2015–30/09/2015: -0,4127% | 1 - Success. Disposition: Do not invest | 4,000,000 COP |
| 30/06/2015–30/09/2015: -6,4672% | 30/09/2015–31/12/2015: 2,9692% | 0 - Failure. Disposition: Do Not Invest | 4,000,000 COP |
| 30/09/2015–31/12/2015: 3,789% | 31/12/2015–31/03/2016: 17,4624% | 1 - Success. Disposition: Invest | 4,698,496 COP |
| 31/12/2015–31/03/2016: 4,7625% | 31/03/2016–30/06/2016: -8,4575% | 0 - Failure. Disposition: Invest | 4,301,119 COP |
| 31/03/2016–30/06/2016: 1,9650% | 30/06/2016–30/09/2016: 4,7855% | 1 - Success. Disposition: Invest | 4,506,950 COP |
| 30/06/2016–30/09/2016: 16,5154% | 30/09/2016–31/12/2016: 2,5357 % | 1 - Success. Disposition: Invest | 4,621,231 COP |
| 30/09/2016–31/12/2016: -15,3468% | 31/12/2016–31/03/2017: 3,9821% | 0 - Failure. Disposition: Do Not Invest | 4,621,231 COP |
| 31/12/2016–31/03/2017: -11,2346% | 31/03/2017–30/06/2017: 0,2101% | 0 - Failure. Disposition: Do Not Invest | 4,621,231 COP |
| 31/03/2017–30/06/2017: -0,6458% | 30/06/2017–30/09/2017: 0,8619% | 0 - Failure. Disposition: Do Not Invest | 4,621,231 COP |
| 30/06/2017–30/09/2017: 32,4498% | 30/09/2017–31/12/2017: 7,1993% | 1 - Success. Disposition: Invest | 4,953,929 COP |
| 30/09/2017–31/12/2017: -21,7716% | 31/12/2017–31/03/2018: -0,4090% | 1 - Success. Disposition: Do not invest | 4,953,929 COP |
| 31/12/2017–31/03/2018: -1,3761% | 31/03/2018–30/06/2018: -1,3212% | 1 - Success. Disposition: Do not invest | 4,953,929 COP |
| 31/03/2018–30/06/2018: -6,6378% | 30/06/2018–30/09/2018: -9,6605% | 1 - Success. Disposition: Do not invest | 4,953,929 COP |
| 30/06/2018–30/09/2018: -9,4806% | 30/09/2018–31/12/2018: -14,5934% | 1 - Success. Disposition: Do not invest | 4,953,929 COP |
| 30/09/2018–31/12/2018: 31,3354% | 31/12/2018–31/03/2019: 35,8927% | 1 - Success. Disposition: Invest | 6,732,029 COP |
| 31/12/2018–31/03/2019: -11,8398% | 31/03/2019–30/06/2019: -13,4130% | 1 - Success. Disposition: Do not invest | 6,732,029 COP |
| 31/03/2019–30/06/2019: -2,1627% | 30/06/2019–30/09/2019: 22,5719% | 0 - Failure. Disposition: Do Not Invest | 6,732,029 COP |
| 30/06/2019–30/09/2019: 13,9807% | 30/09/2019–31/12/2019: -20,8755% | 0 - Failure. Disposition: Invest | 5,326,686 COP |
Source: Own elaboration from Economatica (n.d.).
Model certainty: 61.11%.
Final Profitability: 33.1672%.
Banco Bogotá S.A.
| Percentage change in projected market price per-share (tn:tn+1) | Market price per-share percentage change (tn+1:tn+2) | Model Backtesting | Simulation of Monetary Profitability (1,000,000 COP) |
|---|---|---|---|
| 31/03/2015–30/06/2015: 0,9416% | 30/06/2015–30/09/2015: -0,9449% | 0 - Failure. Disposition: Invest | 990,551 COP |
| 30/06/2015–30/09/2015: -10,2143% | 30/09/2015–31/12/2015: 1,9842% | 0 - Failure. Disposition: Do Not Invest | 990,551 COP |
| 30/09/2015–31/12/2015: 16,5243% | 31/12/2015–31/03/2016: 3,5355% | 1 - Success. Disposition: Invest | 1,025,552 COP |
| 31/12/2015–31/03/2016: 4,4982% | 31/03/2016–30/06/2016: -2,4548% | 0 - Failure. Disposition: Invest | 1,000,377 COP |
| 31/03/2016–30/06/2016: 19,0917% | 30/06/2016–30/09/2016: 8,2740% | 1 - Success. Disposition: Invest | 1,083,148 COP |
| 30/06/2016–30/09/2016: 5,9443% | 30/09/2016–31/12/2016: -2,6430% | 0 - Failure. Disposition: Invest | 1,054,521 COP |
| 30/09/2016–31/12/2016: 0,5332% | 31/12/2016–31/03/2017: -0,3301% | 0 - Failure. Disposition: Invest | 1,051,040 COP |
| 31/12/2016–31/03/2017: 2,0581% | 31/03/2017–30/06/2017: 7,6660% | 1 - Success. Disposition: Invest | 1,131,612, COP |
| 31/03/2017–30/06/2017: 2,8167% | 30/06/2017–30/09/2017: 10,7944% | 1 - Success. Disposition: Invest | 1,253,763 COP |
| 30/06/2017–30/09/2017: 8,4570% | 30/09/2017–31/12/2017: -1,0753% | 0 - Failure. Disposition: Invest | 1,240,282 COP |
| 30/09/2017–31/12/2017: 7,0207% | 31/12/2017–31/03/2018: 1,8707% | 1 - Success. Disposition: Invest | 1,263,484 COP |
| 31/12/2017–31/03/2018: -5,2425% | 31/03/2018–30/06/2018: 1,4452% | 0 - Failure. Disposition: Do Not Invest | 1,263,484 COP |
| 31/03/2018–30/06/2018: -13,9716 | 30/06/2018–30/09/2018: -1,1615% | 1 - Success. Disposition: Do not invest | 1,263,484 COP |
| 30/06/2018–30/09/2018: 7,1271% | 30/09/2018–31/12/2018: -14,9800% | 0 - Failure. Disposition: Invest | 1,074,215 COP |
| 30/09/2018–31/12/2018: 5,1261% | 31/12/2018–31/03/2019: 23,8815% | 1 - Success. Disposition: Invest | 1,330,753 COP |
| 31/12/2018–31/03/2019: -0,8770% | 31/03/2019–30/06/2019: -3,6764% | 1 - Success. Disposition: Do not invest | 1,330,753 COP |
| 31/03/2019–30/06/2019: 13,5502% | 30/06/2019–30/09/2019: 25,8196% | 1 - Success. Disposition: Invest | 1,674,349 COP |
| 30/06/2019–30/09/2019: -12,4939% | 30/09/2019–31/12/2019: 7,0919% | 0 - Failure. Disposition: Do Not Invest | 1,674,349 COP |
Source: Own elaboration from Economática (n.d.).
Model certainty: 50.00%.
Final Profitability: 67.4349%.
Banco Davivienda S.A.
| Percentage change in projected market price per-share (tn:tn+1) | Market price per-share percentage change (tn+1:tn+2) | Model Backtesting | Simulation of Monetary Profitability (1,000,000 COP) |
|---|---|---|---|
| 31/03/2015–30/06/2015: -1,7389% | 30/06/2015–30/09/2015: -10,3216% | 1 - Success. Disposition: Do not invest | 1,000,000 COP |
| 30/06/2015–30/09/2015: -6,8458% | 30/09/2015–31/12/2015: -9,0909% | 1 - Success. Disposition: Do not invest | 1,000,000 COP |
| 30/09/2015–31/12/2015: 12,6829% | 31/12/2015–31/03/2016: 28,1932% | 1 - Success. Disposition: Do not invest | 1,281,932 COP |
| 31/12/2015–31/03/2016: 6,3690% | 31/03/2016–30/06/2016: -2,1834% | 0 - Failure. Disposition: Invest | 1,253,943 COP |
| 31/03/2016–30/06/2016: 4,1001% | 30/06/2016–30/09/2016: 11,4008% | 1 - Success. Disposition: Invest | 1,396,902 COP |
| 30/06/2016–30/09/2016: 9,9249% | 30/09/2016–31/12/2016: 1,6949% | 1 - Success. Disposition: Invest | 1,420,579 COP |
| 30/09/2016–31/12/2016: 3,40405% | 31/12/2016–31/03/2017: 1,3206% | 1 - Success. Disposition: Invest | 1,439,339 COP |
| 31/12/2016–31/03/2017: 4,1916% | 31/03/2017–30/06/2017: 12,5668% | 1 - Success. Disposition: Invest | 1,620,219 COP |
| 31/03/2017–30/06/2017: 2,7358% | 30/06/2017–30/09/2017: 0,1837% | 1 - Success. Disposition: Invest | 1,623,196 COP |
| 30/06/2017–30/09/2017: 8,8372% | 30/09/2017–31/12/2017: -9,9820% | 0 - Failure. Disposition: Invest | 1,461,169 COP |
| 30/09/2017–31/12/2017: 8,4641% | 31/12/2017–31/03/2018: 1,9534% | 1 - Success. Disposition: Invest | 1,489,711 COP |
| 31/12/2017–31/03/2018: -2,6061% | 31/03/2018–30/06/2018: 22,8420% | 0 - Failure. Disposition: Do Not Invest | 1,489,711 COP |
| 31/03/2018–30/06/2018: -14,7445% | 30/06/2018–30/09/2018: -6,4499% | 1 - Success. Disposition: Do not invest | 1,489,711 COP |
| 30/06/2018–30/09/2018: 4,3477% | 30/09/2018–31/12/2018: -9,5906% | 0 - Failure. Disposition: Invest | 1,346,838 COP |
| 30/09/2018–31/12/2018: 3,0288% | 31/12/2018–31/03/2019: 32,4054% | 1 - Success. Disposition: Invest | 1,783,287 COP |
| 31/12/2018–31/03/2019: 1,8066% | 31/03/2019–30/06/2019: -7,6087% | 0 - Failure. Disposition: Invest | 1,647,602 COP |
| 31/03/2019–30/06/2019: 12,0427% | 30/06/2019–30/09/2019: 14,7820% | 1 - Success. Disposition: Invest | 1,891,150 COP |
| 30/06/2019–30/09/2019: -13,4025% | 30/09/2019–31/12/2019: 8,1882% | 0 - Failure. Disposition: Do Not Invest | 1,891,150 COP |
Source: Own elaboration from Economática (n.d.).
Model certainty: 66.67%.
Final Profitability: 89.1150%.
Bancolombia S.A.
| Percentage change in projected market price per-share (tn:tn+1) | Market price per-share percentage change (tn+1:tn+2) | Model Backtesting | Simulation of Monetary Profitability (1,000,000 COP) |
|---|---|---|---|
| 31/03/2015–30/06/2015: -1,6920% | 30/06/2015–30/09/2015: -9,6313% | 1 - Success. Disposition: I do not invest | 1,000,000 COP |
| 30/06/2015–30/09/2015: -7,4316% | 30/09/2015–31/12/2015: -11,2564% | 1 - Success. Disposition: I do not invest | 1,000,000 COP |
| 30/09/2015–31/12/2015: 7,8915% | 31/12/2015–31/03/2016: 19,8780% | 1 - Success. Disposition: Invest | 1,198,780 COP |
| 31/12/2015–31/03/2016: 3,1433% | 31/03/2016–30/06/2016: -1,6721% | 0 - Failure. Disposition: Invest | 1,178,735 COP |
| 31/03/2016–30/06/2016: 3,3273% | 30/06/2016–30/09/2016: 10,5972% | 1 - Success. Disposition: Invest | 1,303,649 COP |
| 30/06/2016–30/09/2016: 9,5100% | 30/09/2016–31/12/2016: -2,2027% | 0 - Failure. Disposition: Invest | 1,274,934 COP |
| 30/09/2016–31/12/2016: 3,1068% | 31/12/2016–31/03/2017: 5,7922% | 1 - Success. Disposition: Invest | 1,348,780 COP |
| 31/12/2016–31/03/2017: 4,2405% | 31/03/2017–30/06/2017: 20,4085% | 1 - Success. Disposition: Invest | 1,624,046 COP |
| 31/03/2017–30/06/2017: 3,1491% | 30/06/2017–30/09/2017: 2,0069% | 1 - Success. Disposition: Invest | 1,656,046 COP |
| 30/06/2017–30/09/2017: 7,9951% | 30/09/2017–31/12/2017: -9,2210% | 0 - Failure. Disposition: Invest | 1,503,881 COP |
| 30/09/2017–31/12/2017: 9,0801% | 31/12/2017–31/03/2018: 0,1855% | 1 - Success. Disposition: Invest | 1,506,672 COP |
| 31/12/2017–31/03/2018: -2,3432% | 31/03/2018–30/06/2018: 20,2964% | 0 - Failure. Disposition: No Investment | 1,506,672 COP |
| 31/03/2018–30/06/2018: -14,5564% | 30/06/2018–30/09/2018: -10,3112% | 1 - Success. Disposition: I do not invest | 1,506,672 COP |
| 30/06/2018–30/09/2018: 3,4962% | 30/09/2018–31/12/2018: -1,3976% | 0 - Failure. Disposition: Invest | 1,485,615 COP |
| 30/09/2018–31/12/2018: 6,0193% | 31/12/2018–31/03/2019: 30,3178% | 1 - Success. Disposition: I do not invest | 1,936,020 COP |
| 31/12/2018–31/03/2019: -0,0162% | 31/03/2019–30/06/2019: 0,0092% | 0 - Failure. Disposition: No Investment | 1,936,020 COP |
| 31/03/2019–30/06/2019: 12,1931% | 30/06/2019–30/09/2019: 4,5168% | 1 - Success. Disposition: Invest | 2,023,466 COP |
| 30/06/2019–30/09/2019: -11,8518% | 30/09/2019–31/12/2019: 9,5169% | 0 - Failure. Disposition: No Investment | 2,023,466 COP |
Source: Own elaboration from Economática (n.d.).
Model certainty: 61.11%.
Final Profitability: 102,347%.
Celsia S.A. E.S.P.
| Percentage change in projected market price per-share (tn:tn+1) | Market price per-share percentage change (tn+1:tn+2) | Model Backtesting | Simulation of Monetary Profitability (1,000,000 COP) |
|---|---|---|---|
| 31/03/2015–30/06/2015: -9,0744% | 30/06/2015–30/09/2015: -15,1046% | 1 - Success. Disposition: I do not invest | 1,000,000 COP |
| 30/06/2015–30/09/2015: -14,4884% | 30/09/2015–31/12/2015: -20,9086% | 1 - Success. Disposition: I do not invest | 1,000,000 COP |
| 30/09/2015–31/12/2015: 56,4705% | 31/12/2015–31/03/2016: 40,3319% | 1 - Success. Disposition: Invest | 1,403,319 COP |
| 31/12/2015–31/03/2016: 226,6724% | 31/03/2016–30/06/2016: 2,1220% | 1 - Success. Disposition: Invest | 1,433,098 COP |
| 31/03/2016–30/06/2016: -49,7499% | 30/06/2016–30/09/2016: 2,5974% | 0 - Failure. Disposition: No Investment | 1,433,098 COP |
| 30/06/2016–30/09/2016: 26,3556% | 30/09/2016–31/12/2016: 1,8987% | 1 - Success. Disposition: Invest | 1,460,308 COP |
| 30/09/2016–31/12/2016: 31,0140% | 31/12/2016–31/03/2017: 8,8199% | 1 - Success. Disposition: Invest | 1,589,106 COP |
| 31/12/2016–31/03/2017: -38,7361% | 31/03/2017–30/06/2017: 5,8061% | 0 - Failure. Disposition: No Investment | 1,589,106 COP |
| 31/03/2017–30/06/2017: 17,6627% | 30/06/2017–30/09/2017: 2,5694% | 1 - Success. Disposition: Invest | 1,629,936 COP |
| 30/06/2017–30/09/2017: -2,9683% | 30/09/2017–31/12/2017: 2,3113% | 0 - Failure. Disposition: No Investment | 1,629,936 COP |
| 30/09/2017–31/12/2017: -20,3104% | 31/12/2017–31/03/2018: -4,4866% | 1 - Success. Disposition: I do not invest | 1,629,936 COP |
| 31/12/2017–31/03/2018: 0,5741% | 31/03/2018–30/06/2018: 3,8387% | 1 - Success. Disposition: Invest | 1,692,503 COP |
| 31/03/2018–30/06/2018: -10,5135% | 30/06/2018–30/09/2018: -5,6930% | 1 - Success. Disposition: I do not invest | 1,692,503 COP |
| 30/06/2018–30/09/2018: 11,3146% | 30/09/2018–31/12/2018: -6,8711% | 0 - Failure. Disposition: Invest | 1,576,210 COP |
| 30/09/2018–31/12/2018: -45,5910% | 31/12/2018–31/03/2019: 10,9322% | 0 - Failure. Disposition: No Investment | 1,576,210 COP |
| 31/12/2018–31/03/2019: 1,3816% | 31/03/2019–30/06/2019: 0,9244% | 1 - Success. Disposition: Invest | 1,590,780 COP |
| 31/03/2019–30/06/2019: 5,1000% | 30/06/2019–30/09/2019: 0,2203% | 1 - Success. Disposition: Invest | 1,594,285 COP |
| 30/06/2019–30/09/2019: 5,4499% | 30/09/2019–31/12/2019: 2,4743% | 1 - Success. Disposition: Invest | 1,633,732 COP |
Source: Own elaboration from Economática (n.d.).
Model certainty: 72.22%.
Final Profitability: 63.37%.
Electric interconnection S.A. E.S.P.
| Percentage change in projected market price per-share (tn:tn+1) | Market price per-share percentage change (tn+1:tn+2) | Model Backtesting | Simulation of Monetary Profitability (1,000,000 COP) |
|---|---|---|---|
| 31/03/2015–30/06/2015: -4,6458% | 30/06/2015–30/09/2015: -1,8074% | 1 - Success. Disposition: I do not invest | 1,000,000 COP |
| 30/06/2015–30/09/2015:-8,0485% | 30/09/2015–31/12/2015: 5,2828% | 0 - Failure. Disposition: No Investment | 1,000,000 COP |
| 30/09/2015–31/12/2015: 63,1939% | 31/12/2015–31/03/2016: 17,2087% | 1 - Success. Disposition: Invest | 1,172,087 COP |
| 31/12/2015–31/03/2016: 235,9427% | 31/03/2016–30/06/2016: 3,3526% | 1 - Success. Disposition: Invest | 1,211,382 COP |
| 31/03/2016–30/06/2016: -48,4361% | 30/06/2016–30/09/2016: 10,7965% | 0 - Failure. Disposition: No Investment | 1,211,382 COP |
| 30/06/2016–30/09/2016: 51,7350% | 30/09/2016–31/12/2016: 3,8277% | 1 - Success. Disposition: Invest | 1,257,750 COP |
| 30/09/2016–31/12/2016: 35,4355% | 31/12/2016–31/03/2017: 16,2325% | 1 - Success. Disposition: Invest | 1,461,913 COP |
| 31/12/2016–31/03/2017: -40,1268% | 31/03/2017–30/06/2017: 15,0000% | 0 - Failure. Disposition: No Investment | 1,461,913 COP |
| 31/03/2017–30/06/2017: 24,8831% | 30/06/2017–30/09/2017: 4,0595% | 1 - Success. Disposition: Invest | 1,521,260 COP |
| 30/06/2017–30/09/2017: 0,5658% | 30/09/2017–31/12/2017: 5,2901% | 1 - Success. Disposition: Invest | 1,601,737 COP |
| 30/09/2017–31/12/2017: -18,9737% | 31/12/2017–31/03/2018: -6,1972% | 1 - Success. Disposition: I do not invest | 1,601,737 COP |
| 31/12/2017–31/03/2018: -27,2073% | 31/03/2018–30/06/2018: 8,8589% | 0 - Failure. Disposition: No Investment | 1,601,737 COP |
| 31/03/2018–30/06/2018: -12,9590% | 30/06/2018–30/09/2018: -5,9211% | 1 - Success. Disposition: I do not invest | 1,601,737 COP |
| 30/06/2018–30/09/2018: 13,6145% | 30/09/2018–31/12/2018: 6,7193% | 1 - Success. Disposition: I do not invest | 1,709,362 COP |
| 30/09/2018–31/12/2018: -40,8563% | 31/12/2018–31/03/2019: 27,7539% | 0 - Failure. Disposition: No Investment | 1,709,362 COP |
| 31/12/2018–31/03/2019: 3,4287% | 31/03/2019–30/06/2019: -10,6383% | 0 - Failure. Disposition: Invest | 1,527,515 COP |
| 31/03/2019–30/06/2019: 8,8688% | 30/06/2019–30/09/2019: 15,9525% | 1 - Success. Disposition: Invest | 1,771,192 COP |
| 30/06/2019–30/09/2019: 0,7035% | 30/09/2019–31/12/2019: 9,0694% | 1 - Success. Disposition: Invest | 1,931,829 COP |
Source: Own elaboration from Economática (n.d.).
Model certainty: 66.67%.
Final Profitability: 93.18%.