Caso Empresa SUEÑO SAC
Caso Empresa SUEÑO SAC
Caso Empresa SUEÑO SAC
AUTORES:
ASESOR
TARAPOTO – PERÚ
2024
CASO ANALISIS PROYECCIÓN DE ESTADOS FINANCIEROS
La Empresa SUEÑO SAC, cuenta con la siguiente información en los EEFF
correspondiente a los ejercicios 2020_2023, información base para la proyección
de los Estados Financieros (Proforma) de Situación Financiera y Estado de
Resultados para el ejercicio 2024 y 2025:
SUEÑO SAC
(Expresado en miles de soles)
Ventas 4,000,000.00 4,680,000.00 4,661,600.00 4,777,760.00 680,000.00 - 18,400.00 116,160.00 17.00% -0.39% 2.49% -0.39% 6.37% 17.00%
Costo de ventas 2,200,000.00 2,400,000.00 2,496,960.00 2,829,060.00 200,000.00 96,960.00 332,100.00 9.09% 4.04% 13.30%
UTILIDAD BRUTA 1,800,000.00 2,280,000.00 2,164,640.00 1,948,700.00 480,000.00 - 115,360.00 - 215,940.00 26.67% -5.06% -9.98%
Gastos Administrativos 1,089,770.00 1,197,770.00 1,122,460.00 1,156,131.00 108,000.00 - 75,310.00 33,671.00 9.91% -6.29% 3.00% 9.91% 2.21% -6.29%
Gastos de Ventas 400,000.00 408,000.00 416,160.00 274,666.00 8,000.00 8,160.00 - 141,494.00 2.00% 2.00% -34.00%
RESULTADO OPERATIVO 310,230.00 674,230.00 626,020.00 517,903.00 364,000.00 - 48,210.00 - 108,117.00 117.33% -7.15% -17.27%
Intereses 57,600.00 54,720.00 57,600.00 143,143.00 - 2,880.00 2,880.00 85,543.00 -5.00% 5.26% 148.51%
UTILIDAD ANTES DE
252,630.00 619,510.00 568,420.00 374,760.00 366,880.00 - 51,090.00 - 193,660.00 145.22% -8.25% -34.07%
IMPUESTOS
Impuestos 74,525.85 182,755.45 167,683.90 110,554.20 108,229.60 - 15,071.55 - 57,129.70 145.22% -8.25% -34.07%
RESULTADO DEL PERIODO 178,104.15 436,754.55 400,736.10 264,205.80 258,650.40 - 36,018.45 - 136,530.30 145.22% -8.25% -34.07%
ANALIS VERTICAL:
DETALLE 2020 2021 2022 2023 2020 2021 2022 2023 PESIMISTA MAS PROBABLEOPTIMISTA
Costo de ventas 2,200,000.00 2,400,000.00 2,496,960.00 2,829,060.00 55.00% 60.00% 62.42% 70.73% 70.73% 62.04% 55.00%
UTILIDAD BRUTA 1,800,000.00 2,280,000.00 2,164,640.00 1,948,700.00 45.00% 57.00% 54.12% 48.72%
Gastos Administrativos 1,089,770.00 1,197,770.00 1,122,460.00 1,156,131.00 27.24% 29.94% 28.06% 28.90%
Gastos de Ventas 400,000.00 408,000.00 416,160.00 274,666.00 10.00% 10.20% 10.40% 6.87% 10.40% 9.37% 6.87%
RESULTADO OPERATIVO 310,230.00 674,230.00 626,020.00 517,903.00 7.76% 16.86% 15.65% 12.95%
RESULTADO DEL PERIODO 178,104.15 436,754.55 400,736.10 264,205.80 4.45% 10.92% 10.02% 6.61%
ANALISIS HORIZONTAL ESTADO DE SITUACION FINANCIERA:
ACTIVO 2020 2021 2022 2023 2021 2022 2023 2021 2022 2023
ACTIVO CORRIENTE 1,536,381.00 1,627,604.00 1,285,582.00 1,947,027.00 91,223.00 - 342,022.00 661,445.00 5.94% -21.01% 51.45%
Efectivo y Equiv. Efectivo 355,714.00 355,604.00 278,782.00 490,808.00 - 110.00 - 76,822.00 212,026.00 -0.03% -21.60% 76.05%
Cuentas por Cobrar 666,667.00 680,000.00 513,200.00 513,200.00 13,333.00 - 166,800.00 - 2.00% -24.53% 0.00%
Inventario 514,000.00 592,000.00 493,600.00 943,019.00 78,000.00 - 98,400.00 449,419.00 15.18% -16.62% 91.05%
ACTIVO NO CORRIENTE 760,000.00 728,000.00 592,000.00 590,000.00 - 32,000.00 - 136,000.00 - 2,000.00 -4.21% -18.68% -0.34%
Activo Fijo Bruto 800,000.00 800,000.00 800,000.00 800,000.00 - - - 0.00% 0.00% 0.00%
Depreciación Acumulada 40,000.00 72,000.00 208,000.00 210,000.00 32,000.00 136,000.00 2,000.00 80.00% 188.89% 0.96%
TOTAL ACTIVO 2,296,381.00 2,355,604.00 1,877,582.00 2,537,027.00 59,223.00 - 478,022.00 659,445.00 2.58% -20.29% 35.12%
0 0 0 #¡DIV/0! #¡DIV/0! #¡DIV/0!
PASIVO CORRIENTE 402,667.00 444,000.00 550,584.00 537,436.00 41,333.00 106,584.00 - 13,148.00 10.26% 24.01% -2.39%
Cuentas por Pagar 366,667.00 408,000.00 478,584.00 478,584.00 41,333.00 70,584.00 - 11.27% 17.30% 0.00%
Deudas Bancarias C/P 36,000.00 36,000.00 72,000.00 58,852.00 - 36,000.00 - 13,148.00 0.00% 100.00% -18.26%
PASIVO NO CORRIENTE 648,000.00 648,000.00 648,000.00 648,000.00 - - - 0.00% 0.00% 0.00%
Deudas Bancarias L/P 648,000.00 648,000.00 648,000.00 648,000.00 - - - 0.00% 0.00% 0.00%
TOTAL PASIVO 1,050,667.00 1,092,000.00 1,198,584.00 1,185,436.00 41,333.00 106,584.00 - 13,148.00 3.93% 9.76% -1.10%
0 0 0 #¡DIV/0! #¡DIV/0! #¡DIV/0!
Capital 1,038,095.00 1,038,095.00 1,038,095.00 1,038,095.00 - - - 0.00% 0.00% 0.00%
Resultado Acumulado 207,619.00 225,509.00 240,903.00 313,496.00 17,890.00 15,394.00 72,593.00 8.62% 6.83% 30.13%
TOTAL PATRIMONIO 1,245,714.00 1,263,604.00 1,278,998.00 1,351,591.00 17,890.00 15,394.00 72,593.00 1.44% 1.22% 5.68%
TOTAL PASIVO Y PATRIMONIO2,296,381.00 2,355,604.00 2,477,582.00 2,537,027.00 59,223.00 121,978.00 59,445.00 2.58% 5.18% 2.40%
ANALISIS VERTICAL ESTADO DE SITUACION FINANCIERA:
PASIVO CORRIENTE 402,667.00 444,000.00 550,584.00 537,436.00 17.53% 18.85% 22.22% 21.18%
Cuentas por Pagar 366,667.00 408,000.00 478,584.00 478,584.00 15.97% 17.32% 19.32% 18.86%
Deudas Bancarias C/P 36,000.00 36,000.00 72,000.00 58,852.00 1.57% 1.53% 2.91% 2.32%
PASIVO NO CORRIENTE 648,000.00 648,000.00 648,000.00 648,000.00 28.22% 27.51% 26.15% 25.54%
Deudas Bancarias L/P 648,000.00 648,000.00 648,000.00 648,000.00 28.22% 27.51% 26.15% 25.54%
TOTAL PASIVO 1,050,667.00 1,092,000.00 1,198,584.00 1,185,436.00 45.75% 46.36% 48.38% 46.73%
0.00% 0.00% 0.00% 0.00%
Capital 1,038,095.00 1,038,095.00 1,038,095.00 1,038,095.00 45.21% 44.07% 41.90% 40.92%
Resultado Acumulado 207,619.00 225,509.00 240,903.00 313,496.00 9.04% 9.57% 9.72% 12.36%
TOTAL PATRIMONIO 1,245,714.00 1,263,604.00 1,278,998.00 1,351,591.00 54.25% 53.64% 51.62% 53.27%
2,296,381.00 2,355,604.00 2,477,582.00 2,537,027.00 100.00% 100.00% 100.00% 100.00%
RATIOS DE LIQUIDEZ:
N° Detalle 2020 2021 2022 2023 2024 2025 Mini Grafico PESIMISTA MAS PROBABLE OPTMISTA
3.82 3.67 2.33 3.62 3.92 3.55
1 Liquidez Corriente 2.33 3.36 3.82
2.54 2.33 1.44 1.87 2.03 1.73
2 Liquidez Acida 1.44 2.04 2.54
1,133,714.00 1,183,604.00 734,998.00 1,409,591.00 1,549,686.16 1,483,797.09
3 Capital de Trabajo 734,998.00 1,115,476.75 1,409,591.00
ANALISIS:
RATIOS DE GESTION:
Detalle 2020 2021 2022 2023 2024 2025 Mini Grafico PESIMISTA MAS PROBABLE OPTMISTA
Rotación de Activos 1.74 1.99 2.48 1.88 1.90 2.02 1.74 2.02 2.48
Periodo Promedio de Cobro 60.00 52.31 39.63 38.67 47.65 47.65 60.00 47.65 38.67
Periodo Promedio de Inventario 84.11 88.80 71.16 120.00 114.78 114.78 120.00 91.02 71.16
Periodo Promedio de Pago 60.00 61.20 69.00 60.90 33.52 35.09 60.00 62.78 69.00
Ciclo de Conversión del Efectivo 84.11 79.91 41.80 97.77 128.92 127.34 41.80 93.31 128.92
ANALISIS:
RATIOS DE RENTABILIDAD:
Detalle 2020 2021 2022 2023 2024 2025 Mini Grafico
Interpretación:
INTERPRETACION:
INTERPRETACION:
DATOS DE ENTRADA:
DATOS DE SALIDA:
Pol. Distribución Dividendos 20.11% 58.58% 50.42% 23.27% 20.11% 38.09% 58.58%
Costo de productos
517,903.00 ventas 2,829,060.00
Vendidos