How to get the Receivable turnover with the previous information ?

Razones Financieras Frmula 2015 2016 2017 2018 2019 2020 2021 Profit margin 0.12297409 0.135674770361 0.23235139 0.12069400 0.07456618 0.32952447 0.15885130 Return on Assets 0.04279984 0.04721169743 0.07923429 0.039863170.02481437 0.10041508 0.05376151 Return on Equity Utilidad neta / Ventas Utilidad neta / Total de activos Utilidad neta / Capital contable Ventas (Crdito) / Cuentas por cobrar 0.07523317 0.08560984771 0.13579582 0.07522786 0.04732816 0.18212170 0.09364476 Receivable turnover 2015 2016 2017 2018 2019 2020 2021 BALANCE SHEET Total Current Assets Assets % Total Fixed Assets Activos % Total Assets Activos % 33,336.89 29.98 77,845.11 70.02 111,182.00 100.00 34,919.01 31,723.65 28,225.74 32,492.23 41,303.39 34,901.51 31.63 26.44 22.12 25.67 29.50 25.49 75,478.55 88,271.54 99,358.70 94,099.02 98,708.32 102,006.04 68.37 73.56 77.88 74.33 70.50 74.51 110,397.56 119,995.19 127,584.44126,591.25140,011.70136,907.54 100.00 100.00 100.00 100.00 100.00 100.00 Total current liabilities Activos % Total Fixed Liabilities Activos % Total liabilities Activos % Capital 19,350.17 17.40 28,580.84 25.71 47,931.01 43.11 63,250.99 18,593.31 16.84 30,922.75 28.01 49,516.06 44.85 60,881.50 18,589.62 15.49 31,390.64 26.16 49,980.26 41.65 70,014.93 19,899.00 22,892.56 23,569.80 24,246.49 15.60 18.08 16.83 17.71 40,078.56 37,326.32 39,244.70 34,062.36 31.41 29.49 28.03 24.88 59,977.56 60,218.88 62,814.50 58,308.85 47.01 47.57 44.86 42.59 67,606.88 66,372.37 77,197.21 78,598.70 ESTADO DE RESULTADOS Total net sales Activos % Gross profit Activos % Utility operation Activos % Net profit 38,695.73 100.00 26,575.64 68. 68 7,864.35 20.32 4,758.57 38,415.81 100.00 26,570.53 69. 17 8,289.04 21.58 5,212.06 40,919.64 42,138.97 42,127.45 42,665.38 46,334.88 100.00 100.00 100.00 100.00 100.00 27,800.18 28,632.82 28,720.46 28,785.35 31,840.08 67.94 67.95 68.18 67.47 68.72 8,034.58 6,903.67 7,799.47 8,661.18 10,818.77 19.64 16.38 18.51 20.30 23.35 9,507.73 5,085.92 3,141.28 14,059.29 7,360.36 FLUJO DE EFECTIVO transaction flows investment flows financing flows net cash flows 9,901.21 -3,615.27 -3,997.11 2,031.30 9,058.29 -2,918.71 -4,416.25 1,611.54 8,336.21 721.89 -8,927.06 47.45 6,551.70 8,669.318,504.76 |-15,203.43 -1,184.42 4,096.53 4,646.54 -4,694.01 -7,404.13 -4,004.01 2,800.96 5,124.09 Razones Financieras Frmula 2015 2016 2017 2018 2019 2020 2021 Profit margin 0.12297409 0.135674770361 0.23235139 0.12069400 0.07456618 0.32952447 0.15885130 Return on Assets 0.04279984 0.04721169743 0.07923429 0.039863170.02481437 0.10041508 0.05376151 Return on Equity Utilidad neta / Ventas Utilidad neta / Total de activos Utilidad neta / Capital contable Ventas (Crdito) / Cuentas por cobrar 0.07523317 0.08560984771 0.13579582 0.07522786 0.04732816 0.18212170 0.09364476 Receivable turnover 2015 2016 2017 2018 2019 2020 2021 BALANCE SHEET Total Current Assets Assets % Total Fixed Assets Activos % Total Assets Activos % 33,336.89 29.98 77,845.11 70.02 111,182.00 100.00 34,919.01 31,723.65 28,225.74 32,492.23 41,303.39 34,901.51 31.63 26.44 22.12 25.67 29.50 25.49 75,478.55 88,271.54 99,358.70 94,099.02 98,708.32 102,006.04 68.37 73.56 77.88 74.33 70.50 74.51 110,397.56 119,995.19 127,584.44126,591.25140,011.70136,907.54 100.00 100.00 100.00 100.00 100.00 100.00 Total current liabilities Activos % Total Fixed Liabilities Activos % Total liabilities Activos % Capital 19,350.17 17.40 28,580.84 25.71 47,931.01 43.11 63,250.99 18,593.31 16.84 30,922.75 28.01 49,516.06 44.85 60,881.50 18,589.62 15.49 31,390.64 26.16 49,980.26 41.65 70,014.93 19,899.00 22,892.56 23,569.80 24,246.49 15.60 18.08 16.83 17.71 40,078.56 37,326.32 39,244.70 34,062.36 31.41 29.49 28.03 24.88 59,977.56 60,218.88 62,814.50 58,308.85 47.01 47.57 44.86 42.59 67,606.88 66,372.37 77,197.21 78,598.70 ESTADO DE RESULTADOS Total net sales Activos % Gross profit Activos % Utility operation Activos % Net profit 38,695.73 100.00 26,575.64 68. 68 7,864.35 20.32 4,758.57 38,415.81 100.00 26,570.53 69. 17 8,289.04 21.58 5,212.06 40,919.64 42,138.97 42,127.45 42,665.38 46,334.88 100.00 100.00 100.00 100.00 100.00 27,800.18 28,632.82 28,720.46 28,785.35 31,840.08 67.94 67.95 68.18 67.47 68.72 8,034.58 6,903.67 7,799.47 8,661.18 10,818.77 19.64 16.38 18.51 20.30 23.35 9,507.73 5,085.92 3,141.28 14,059.29 7,360.36 FLUJO DE EFECTIVO transaction flows investment flows financing flows net cash flows 9,901.21 -3,615.27 -3,997.11 2,031.30 9,058.29 -2,918.71 -4,416.25 1,611.54 8,336.21 721.89 -8,927.06 47.45 6,551.70 8,669.318,504.76 |-15,203.43 -1,184.42 4,096.53 4,646.54 -4,694.01 -7,404.13 -4,004.01 2,800.96 5,124.09