Gastos

Periodo Ventas Costos % Costo Margen Bruto

Operativos
Jan-17 1,524,389 1,005,487 65.96% 518,892 389,200
Feb-17 1,412,655 932,352 66.00% 480,303 378,500
Mar-17 1,847,322 1,218,033 65.93% 629,289 382,500
Apr-17 1,632,455 1,091,704 66.88% 540,751 367,200
May-17 1,715,888 1,147,118 66.85% 568,770 364,200
Jun-17 1,892,334 1,253,876 66.26% 638,458 403,500
Jul-17 1,956,773 1,278,576 65.34% 678,197 412,800
Aug-17 1,834,567 1,178,912 64.25% 655,655 396,200
Sep-17 1,754,721 1,158,115 66.00% 596,606 424,600
Oct-17 1,639,797 1,082,265 66.00% 557,532 413,100
Nov-17 1,245,671 912,983 73.29% 332,688 318,700
Dec-17 2,398,712 1,562,489 65.14% 836,223 478,900
Jan-18 1,602,145 1,057,416 66.00% 544,729 395,800
Feb-18 1,487,221 981,565 66.00% 505,656 384,300
Mar-18 1,932,788 1,275,640 66.00% 657,148 412,000
Apr-18 1,723,456 1,132,901 65.73% 590,555 375,100
May-18 1,792,344 1,148,102 64.06% 644,242 387,400
Jun-18 2,123,789 1,352,621 63.69% 771,168 442,600
Jul-18 2,587,443 1,632,090 63.08% 955,353 512,300
Aug-18 1,831,009 1,208,466 66.00% 622,543 438,900
Sep-18 1,754,721 1,158,115 66.00% 596,606 424,600
Oct-18 1,639,797 1,082,265 66.00% 557,532 413,100
Nov-18 1,245,671 912,983 73.29% 332,688 318,700
Dec-18 2,398,712 1,562,489 65.14% 836,223 478,900
Jan-19 1,678,433 1,107,765 66.00% 570,668 410,200
Feb-19 1,563,509 1,031,915 66.00% 531,594 398,700
Mar-19 2,009,076 1,325,990 66.00% 683,086 426,400
Apr-19 1,754,721 1,158,115 66.00% 596,606 424,600
May-19 1,639,797 1,082,265 66.00% 557,532 413,100
Jun-19 1,892,334 1,253,876 66.26% 638,458 403,500
Jul-19 1,956,773 1,278,576 65.34% 678,197 412,800
Aug-19 1,834,567 1,178,912 64.25% 655,655 396,200
Sep-19 1,754,721 1,158,115 66.00% 596,606 424,600
Oct-19 2,145,678 1,416,147 66.00% 729,531 463,800
Nov-19 1,987,543 1,311,778 66.00% 675,765 432,600
Dec-19 2,587,443 1,632,090 63.08% 955,353 512,300
Jan-20 1,754,721 1,158,115 66.00% 596,606 424,600
Feb-20 1,639,797 1,082,265 66.00% 557,532 413,100
Mar-20 1,245,671 912,983 73.29% 332,688 318,700
Apr-20 1,087,654 812,987 74.75% 274,667 305,800
May-20 1,325,789 928,052 70.00% 397,737 372,600
Jun-20 1,523,456 1,066,419 70.00% 457,037 426,500
Jul-20 1,756,832 1,229,782 70.00% 527,050 492,000
Aug-20 1,892,344 1,324,641 70.00% 567,703 529,800
Sep-20 2,009,076 1,406,353 70.00% 602,723 562,500
Oct-20 2,145,678 1,501,975 70.00% 643,703 600,800
Nov-20 2,312,543 1,618,780 70.00% 693,763 647,500
Dec-20 2,498,765 1,749,135 70.00% 749,630 699,600
Jan-21 1,892,344 1,148,102 60.68% 744,242 529,800
Feb-21 1,987,543 1,205,358 60.65% 782,185 556,500
Mar-21 2,312,543 1,387,526 60.00% 925,017 647,500
Apr-21 2,145,678 1,287,407 60.00% 858,271 600,800
May-21 2,009,076 1,205,446 60.00% 803,630 562,500
Jun-21 2,312,543 1,387,526 60.00% 925,017 647,500
Jul-21 2,498,765 1,499,259 60.00% 999,506 699,600
Aug-21 2,712,876 1,627,726 60.00% 1,085,150 759,600
Sep-21 2,845,678 1,707,407 60.00% 1,138,271 796,800
Oct-21 3,012,543 1,807,526 60.00% 1,205,017 843,500
 Nov-21 3,189,765 1,913,859 60.00% 1,275,906 893,100
Dec-21 3,498,765 2,099,259 60.00% 1,399,506 979,600

Desviaciones del
valor observado
Cod Fecha Ingreso Mensual Tendencia MM12
respecto a la
tendencia
1 Jan-17 1,524,389 $ 1,520,892.97 $ 3,496.03 1,956,490
2 Feb-17 1,412,655 $ 1,535,658.98 $ (123,003.98)
3 Mar-17 1,847,322 $ 1,550,425.00 $ 296,897.00
4 Apr-17 1,632,455 $ 1,565,191.01 $ 67,263.99
5 May-17 1,715,888 $ 1,579,957.02 $ 135,930.98
6 Jun-17 1,892,334 $ 1,594,723.03 $ 297,610.97
7 Jul-17 1,956,773 $ 1,609,489.05 $ 347,283.95
8 Aug-17 1,834,567 $ 1,624,255.06 $ 210,311.94
9 Sep-17 1,754,721 $ 1,639,021.07 $ 115,699.93
10 Oct-17 1,639,797 $ 1,653,787.08 $ (13,990.08)
11 Nov-17 1,245,671 $ 1,668,553.09 $ (422,882.09)
12 Dec-17 2,398,712 $ 1,683,319.11 $ 715,392.89
13 Jan-18 1,602,145 $ 1,698,085.12 $ (95,940.12)
14 Feb-18 1,487,221 $ 1,712,851.13 $ (225,630.13)
15 Mar-18 1,932,788 $ 1,727,617.14 $ 205,170.86
16 Apr-18 1,723,456 $ 1,742,383.16 $ (18,927.16)
17 May-18 1,792,344 $ 1,757,149.17 $ 35,194.83
18 Jun-18 2,123,789 $ 1,771,915.18 $ 351,873.82
19 Jul-18 2,587,443 $ 1,786,681.19 $ 800,761.81
20 Aug-18 1,831,009 $ 1,801,447.20 $ 29,561.80
21 Sep-18 1,754,721 $ 1,816,213.22 $ (61,492.22)
22 Oct-18 1,639,797 $ 1,830,979.23 $ (191,182.23)
23 Nov-18 1,245,671 $ 1,845,745.24 $ (600,074.24)
24 Dec-18 2,398,712 $ 1,860,511.25 $ 538,200.75
25 Jan-19 1,678,433 $ 1,875,277.27 $ (196,844.27)
26 Feb-19 1,563,509 $ 1,890,043.28 $ (326,534.28)
27 Mar-19 2,009,076 $ 1,904,809.29 $ 104,266.71
28 Apr-19 1,754,721 $ 1,919,575.30 $ (164,854.30)
29 May-19 1,639,797 $ 1,934,341.31 $ (294,544.31)
30 Jun-19 1,892,334 $ 1,949,107.33 $ (56,773.33)
31 Jul-19 1,956,773 $ 1,963,873.34 $ (7,100.34)
32 Aug-19 1,834,567 $ 1,978,639.35 $ (144,072.35)
33 Sep-19 1,754,721 $ 1,993,405.36 $ (238,684.36)
34 Oct-19 2,145,678 $ 2,008,171.38 $ 137,506.62
35 Nov-19 1,987,543 $ 2,022,937.39 $ (35,394.39)
36 Dec-19 2,587,443 $ 2,037,703.40 $ 549,739.60
37 Jan-20 1,754,721 $ 2,052,469.41 $ (297,748.41)
38 Feb-20 1,639,797 $ 2,067,235.43 $ (427,438.43)
39 Mar-20 1,245,671 $ 2,082,001.44 $ (836,330.44)
40 Apr-20 1,087,654 $ 2,096,767.45 $ (1,009,113.45)
41 May-20 1,325,789 $ 2,111,533.46 $ (785,744.46)
42 Jun-20 1,523,456 $ 2,126,299.47 $ (602,843.47)
43 Jul-20 1,756,832 $ 2,141,065.49 $ (384,233.49)
44 Aug-20 1,892,344 $ 2,155,831.50 $ (263,487.50)
45 Sep-20 2,009,076 $ 2,170,597.51 $ (161,521.51)
46 Oct-20 2,145,678 $ 2,185,363.52 $ (39,685.52)
47 Nov-20 2,312,543 $ 2,200,129.54 $ 112,413.46
48 Dec-20 2,498,765 $ 2,214,895.55 $ 283,869.45
49 Jan-21 1,892,344 $ 2,229,661.56 $ (337,317.56)
50 Feb-21 1,987,543 $ 2,244,427.57 $ (256,884.57)
51 Mar-21 2,312,543 $ 2,259,193.58 $ 53,349.42
52 Apr-21 2,145,678 $ 2,273,959.60 $ (128,281.60)
53 May-21 2,009,076 $ 2,288,725.61 $ (279,649.61)
54 Jun-21 2,312,543 $ 2,303,491.62 $ 9,051.38
55 Jul-21 2,498,765 $ 2,318,257.63 $ 180,507.37
56 Aug-21 2,712,876 $ 2,333,023.65 $ 379,852.35
57 Sep-21 2,845,678 $ 2,347,789.66 $ 497,888.34
58 Oct-21 3,012,543 $ 2,362,555.67 $ 649,987.33
59 Nov-21 3,189,765 $ 2,377,321.68 $ 812,443.32
60 Dec-21 3,498,765 $ 2,392,087.69 $ 1,106,677.31
61 Jan-22
62 Feb-22
63 Mar-22
64 Apr-22
65 May-22
66 Jun-22
67 Jul-22
68 Aug-22
69 Sep-22
70 Oct-22
71 Nov-22
72 Dec-22

Desviaciones del
valor observado
Cod Fecha Costo Mensual Tendencia MM12
respecto a la
tendencia
1 Jan-17 1,005,487 $ 1,040,536.87 $ (35,049.89) 1,272,167
2 Feb-17 932,352 $ 1,048,388.73 $ (116,036.43)
3 Mar-17 1,218,033 $ 1,056,240.58 $ 161,792.42
4 Apr-17 1,091,704 $ 1,064,092.44 $ 27,611.56
5 May-17 1,147,118 $ 1,071,944.29 $ 75,173.71
6 Jun-17 1,253,876 $ 1,079,796.15 $ 174,079.85
7 Jul-17 1,278,576 $ 1,087,648.00 $ 190,928.00
8 Aug-17 1,178,912 $ 1,095,499.86 $ 83,412.14
9 Sep-17 1,158,115 $ 1,103,351.71 $ 54,763.29
10 Oct-17 1,082,265 $ 1,111,203.57 $ (28,938.57)
11 Nov-17 912,983 $ 1,119,055.42 $ (206,072.42)
12 Dec-17 1,562,489 $ 1,126,907.28 $ 435,581.72
13 Jan-18 1,057,416 $ 1,134,759.13 $ (77,343.13)
14 Feb-18 981,565 $ 1,142,610.99 $ (161,045.99)
15 Mar-18 1,275,640 $ 1,150,462.84 $ 125,177.16
16 Apr-18 1,132,901 $ 1,158,314.69 $ (25,413.69)
17 May-18 1,148,102 $ 1,166,166.55 $ (18,064.55)
18 Jun-18 1,352,621 $ 1,174,018.40 $ 178,602.60
19 Jul-18 1,632,090 $ 1,181,870.26 $ 450,219.74
20 Aug-18 1,208,466 $ 1,189,722.11 $ 18,743.89
21 Sep-18 1,158,115 $ 1,197,573.97 $ (39,458.97)
22 Oct-18 1,082,265 $ 1,205,425.82 $ (123,160.82)
23 Nov-18 912,983 $ 1,213,277.68 $ (300,294.68)
24 Dec-18 1,562,489 $ 1,221,129.53 $ 341,359.47
25 Jan-19 1,107,765 $ 1,228,981.39 $ (121,216.39)
26 Feb-19 1,031,915 $ 1,236,833.24 $ (204,918.24)
27 Mar-19 1,325,990 $ 1,244,685.10 $ 81,304.90
28 Apr-19 1,158,115 $ 1,252,536.95 $ (94,421.95)
29 May-19 1,082,265 $ 1,260,388.81 $ (178,123.81)
30 Jun-19 1,253,876 $ 1,268,240.66 $ (14,364.66)
31 Jul-19 1,278,576 $ 1,276,092.52 $ 2,483.48
32 Aug-19 1,178,912 $ 1,283,944.37 $ (105,032.37)
33 Sep-19 1,158,115 $ 1,291,796.22 $ (133,681.22)
34 Oct-19 1,416,147 $ 1,299,648.08 $ 116,498.92
35 Nov-19 1,311,778 $ 1,307,499.93 $ 4,278.07
36 Dec-19 1,632,090 $ 1,315,351.79 $ 316,738.21
37 Jan-20 1,158,115 $ 1,323,203.64 $ (165,088.64)
38 Feb-20 1,082,265 $ 1,331,055.50 $ (248,790.50)
39 Mar-20 912,983 $ 1,338,907.35 $ (425,924.35)
40 Apr-20 812,987 $ 1,346,759.21 $ (533,772.21)
41 May-20 928,052 $ 1,354,611.06 $ (426,559.06)
42 Jun-20 1,066,419 $ 1,362,462.92 $ (296,043.92)
43 Jul-20 1,229,782 $ 1,370,314.77 $ (140,532.77)
44 Aug-20 1,324,641 $ 1,378,166.63 $ (53,525.63)
45 Sep-20 1,406,353 $ 1,386,018.48 $ 20,334.52
46 Oct-20 1,501,975 $ 1,393,870.34 $ 108,104.66
47 Nov-20 1,618,780 $ 1,401,722.19 $ 217,057.81
48 Dec-20 1,749,135 $ 1,409,574.05 $ 339,560.95
49 Jan-21 1,148,102 $ 1,417,425.90 $ (269,323.90)
50 Feb-21 1,205,358 $ 1,425,277.75 $ (219,919.75)
51 Mar-21 1,387,526 $ 1,433,129.61 $ (45,603.61)
52 Apr-21 1,287,407 $ 1,440,981.46 $ (153,574.46)
53 May-21 1,205,446 $ 1,448,833.32 $ (243,387.32)
54 Jun-21 1,387,526 $ 1,456,685.17 $ (69,159.17)
55 Jul-21 1,499,259 $ 1,464,537.03 $ 34,721.97
56 Aug-21 1,627,726 $ 1,472,388.88 $ 155,337.12
57 Sep-21 1,707,407 $ 1,480,240.74 $ 227,166.26
58 Oct-21 1,807,526 $ 1,488,092.59 $ 319,433.41
59 Nov-21 1,913,859 $ 1,495,944.45 $ 417,914.55
60 Dec-21 2,099,259 $ 1,503,796.30 $ 595,462.70
61 Jan-22
62 Feb-22
63 Mar-22
64 Apr-22
65 May-22
66 Jun-22
67 Jul-22
68 Aug-22
69 Sep-22
70 Oct-22
71 Nov-22
72 Dec-22

Desviaciones del
valor observado
Cod Fecha Gasto Mensual Tendencia MM12
respecto a la
tendencia
1 Jan-17 389,200 $ 301,572.51 $ 87,627.49 485,703
2 Feb-17 378,500 $ 307,814.24 $ 70,685.76
3 Mar-17 382,500 $ 314,055.96 $ 68,444.04
4 Apr-17 367,200 $ 320,297.68 $ 46,902.32
5 May-17 364,200 $ 326,539.40 $ 37,660.60
6 Jun-17 403,500 $ 332,781.13 $ 70,718.87
7 Jul-17 412,800 $ 339,022.85 $ 73,777.15
8 Aug-17 396,200 $ 345,264.57 $ 50,935.43
9 Sep-17 424,600 $ 351,506.30 $ 73,093.70
10 Oct-17 413,100 $ 357,748.02 $ 55,351.98
11 Nov-17 318,700 $ 363,989.74 $ (45,289.74)
12 Dec-17 478,900 $ 370,231.46 $ 108,668.54
13 Jan-18 395,800 $ 376,473.19 $ 19,326.81
14 Feb-18 384,300 $ 382,714.91 $ 1,585.09
15 Mar-18 412,000 $ 388,956.63 $ 23,043.37
16 Apr-18 375,100 $ 395,198.35 $ (20,098.35)
17 May-18 387,400 $ 401,440.08 $ (14,040.08)
18 Jun-18 442,600 $ 407,681.80 $ 34,918.20
19 Jul-18 512,300 $ 413,923.52 $ 98,376.48
20 Aug-18 438,900 $ 420,165.24 $ 18,734.76
21 Sep-18 424,600 $ 426,406.97 $ (1,806.97)
22 Oct-18 413,100 $ 432,648.69 $ (19,548.69)
23 Nov-18 318,700 $ 438,890.41 $ (120,190.41)
24 Dec-18 478,900 $ 445,132.14 $ 33,767.86
25 Jan-19 410,200 $ 451,373.86 $ (41,173.86)
26 Feb-19 398,700 $ 457,615.58 $ (58,915.58)
27 Mar-19 426,400 $ 463,857.30 $ (37,457.30)
28 Apr-19 424,600 $ 470,099.03 $ (45,499.03)
29 May-19 413,100 $ 476,340.75 $ (63,240.75)
30 Jun-19 403,500 $ 482,582.47 $ (79,082.47)
31 Jul-19 412,800 $ 488,824.19 $ (76,024.19)
32 Aug-19 396,200 $ 495,065.92 $ (98,865.92)
33 Sep-19 424,600 $ 501,307.64 $ (76,707.64)
34 Oct-19 463,800 $ 507,549.36 $ (43,749.36)
35 Nov-19 432,600 $ 513,791.09 $ (81,191.09)
36 Dec-19 512,300 $ 520,032.81 $ (7,732.81)
37 Jan-20 424,600 $ 526,274.53 $ (101,674.53)
38 Feb-20 413,100 $ 532,516.25 $ (119,416.25)
39 Mar-20 318,700 $ 538,757.98 $ (220,057.98)
40 Apr-20 305,800 $ 544,999.70 $ (239,199.70)
41 May-20 372,600 $ 551,241.42 $ (178,641.42)
42 Jun-20 426,500 $ 557,483.14 $ (130,983.14)
43 Jul-20 492,000 $ 563,724.87 $ (71,724.87)
44 Aug-20 529,800 $ 569,966.59 $ (40,166.59)
45 Sep-20 562,500 $ 576,208.31 $ (13,708.31)
46 Oct-20 600,800 $ 582,450.04 $ 18,349.96
47 Nov-20 647,500 $ 588,691.76 $ 58,808.24
48 Dec-20 699,600 $ 594,933.48 $ 104,666.52
49 Jan-21 529,800 $ 601,175.20 $ (71,375.20)
50 Feb-21 556,500 $ 607,416.93 $ (50,916.93)
51 Mar-21 647,500 $ 613,658.65 $ 33,841.35
52 Apr-21 600,800 $ 619,900.37 $ (19,100.37)
53 May-21 562,500 $ 626,142.09 $ (63,642.09)
54 Jun-21 647,500 $ 632,383.82 $ 15,116.18
55 Jul-21 699,600 $ 638,625.54 $ 60,974.46
56 Aug-21 759,600 $ 644,867.26 $ 114,732.74
57 Sep-21 796,800 $ 651,108.98 $ 145,691.02
58 Oct-21 843,500 $ 657,350.71 $ 186,149.29
59 Nov-21 893,100 $ 663,592.43 $ 229,507.57
60 Dec-21 979,600 $ 669,834.15 $ 309,765.85
61 Jan-22
62 Feb-22
63 Mar-22
64 Apr-22
65 May-22
66 Jun-22
67 Jul-22
68 Aug-22
69 Sep-22
70 Oct-22
71 Nov-22
72 Dec-22

Proyeccion
 Gastos
Periodo Ventas Costos % Costo Margen Bruto
Operativos
61 ### $ 1,194,766.91 60.00% $ 680,520.31 $ 541,747.84
62 ### $ 1,113,619.35 60.00% $ 634,875.46 $ 531,718.01
63 ### $ 1,462,359.56 60.00% $ 838,080.61 $ 542,252.69
64 ### $ 1,317,428.12 60.00% $ 727,762.11 $ 525,281.43
65 ### $ 1,391,379.75 60.00% $ 771,288.07 $ 525,670.21
66 ### $ 1,528,609.24 60.00% $ 870,729.08 $ 587,579.44
67 ### $ 1,566,612.60 60.00% $ 929,197.71 $ 606,427.01
68 ### $ 1,451,772.66 60.00% $ 902,013.08 $ 587,132.18
69 ### $ 1,433,310.09 60.00% $ 831,274.87 $ 634,674.87
70 ### $ 1,346,116.14 60.00% $ 782,527.57 $ 622,793.84
71 ### $ 1,141,198.94 60.00% $ 485,225.55 $ 484,571.00
72 ### $ 1,962,703.97 60.00% $ 1,187,305.14 $ 734,303.19

Ventas $ 26,550,677 Activos circul

Costos 16,909,877 Activos Fijos
Gastos 6,924,152
D&A 576,000
Interes 270,000
Ingreso tributable $ 1,870,648 Total
Impuestos 561,194
Lngresos netos $ 1,309,453

Tasa impuesto 30%

Estado de resultados BG
Ventas $26,550,676.93 Activos circul
Costos $18,585,473.85 70% Activos Fijos
Gastos $ 7,434,189.54 28%
D&A $ 576,000.00 Total
Interes $ 270,000.00
Ingreso tributable $ (314,986)
Impuestos $ -
Lngresos netos -$ 314,986.46
Dividendos $ -
Añadir. [Link] - 314,986.46

Rentabilidad de lo 8.81%
Relación de retenc 70%
Tasa de crecimient 6.57%

Estado de resultados BG
Ventas $32,460,892.79 Activos circul
Costos $20,674,038.46 Activos Fijos
Ingreso tributable $11,786,854.32
Impuestos 3,536,056.30 Total
Ingresos netos $ 8,250,798.03
Dividendos $ -
Añadir. [Link] 8,250,798.03
Rentabilidad sobre 26.01%
Relacion de retenc 70.00%
Tasa de crecimient 22.26%
 Utilidad Antes Impuestos % Margen
Depreciación Intereses Utilidad Neta
Imp. (30%) Neto
42,000 21,600 66,092 19,828 46,264 3.03% 4.48%
42,000 21,600 38,203 11,461 26,742 1.89%
42,000 21,600 183,189 54,957 128,232 6.94%
42,000 21,600 109,951 32,985 76,966 4.71%
42,000 21,600 140,970 42,291 98,679 5.75%
42,000 21,600 171,358 51,407 119,951 6.34%
42,000 21,600 196,997 59,099 137,898 7.05%
42,000 21,600 191,055 57,317 133,738 7.29%
42,000 21,600 98,806 29,642 69,164 3.94%
42,000 21,600 71,232 21,370 49,862 3.04%
42,000 21,600 -59,212 - -59,212 -4.75%
42,000 21,600 293,723 88,117 205,606 8.57%
42,000 21,600 85,329 25,599 59,730 3.73%
42,000 21,600 57,756 17,327 40,429 2.72%
42,000 21,600 181,548 54,464 127,084 6.58%
42,000 21,600 142,255 42,677 99,578 5.78%
42,000 21,600 184,842 55,453 129,389 7.22%
42,000 21,600 256,568 76,970 179,598 8.46%
42,000 21,600 371,053 111,316 259,737 10.04%
45,000 23,400 111,643 33,493 78,150 4.27%
45,000 23,400 98,806 29,642 69,164 3.94%
45,000 23,400 71,232 21,370 49,862 3.04%
45,000 23,400 -59,212 - -59,212 -4.75%
45,000 23,400 293,723 88,117 205,606 8.57%
45,000 23,400 92,068 27,620 64,448 3.84%
45,000 23,400 64,494 19,348 45,146 2.89%
45,000 23,400 188,286 56,486 131,800 6.56%
45,000 23,400 98,806 29,642 69,164 3.94%
45,000 23,400 71,232 21,370 49,862 3.04%
45,000 23,400 171,358 51,407 119,951 6.34%
45,000 23,400 196,997 59,099 137,898 7.05%
45,000 23,400 191,055 57,317 133,738 7.29%
45,000 23,400 98,806 29,642 69,164 3.94%
45,000 23,400 197,331 59,199 138,132 6.44%
45,000 23,400 174,765 52,430 122,335 6.16%
45,000 23,400 371,053 111,316 259,737 10.04%
48,000 25,200 98,806 29,642 69,164 3.94%
48,000 25,200 71,232 21,370 49,862 3.04%
48,000 25,200 -59,212 - -59,212 -4.75%
48,000 25,200 -104,333 - -104,333 -9.59%
48,000 25,200 -48,063 - -48,063 -3.63%
48,000 25,200 -42,663 - -42,663 -2.80%
48,000 25,200 -38,150 - -38,150 -2.17%
48,000 25,200 -35,297 - -35,297 -1.87%
48,000 25,200 -32,977 - -32,977 -1.64%
48,000 25,200 -30,297 - -30,297 -1.41%
48,000 25,200 -26,937 - -26,937 -1.16%
48,000 25,200 -23,170 - -23,170 -0.93%
48,000 24,000 142,442 42,733 99,709 5.27%
48,000 24,000 153,685 46,106 107,579 5.41%
48,000 24,000 205,517 61,655 143,862 6.22%
48,000 24,000 185,471 55,641 129,830 6.05%
48,000 24,000 169,130 50,739 118,391 5.89%
48,000 24,000 205,517 61,655 143,862 6.22%
48,000 24,000 227,906 68,372 159,534 6.38%
48,000 24,000 253,550 76,065 177,485 6.54%
48,000 24,000 269,471 80,841 188,630 6.63%
48,000 24,000 289,517 86,855 202,662 6.73%
 48,000 24,000 310,806 93,242 217,564 6.82%
48,000 24,000 347,906 104,372 243,534 6.96%

Pronostico de
Tendencia para ventas,
Indice estacional Indice estacional Periodos Ventas y
los proximos 12 tomando en
por mes total pronosticados pronosctivo
meses cuenta
estacionalidad
0.78 1.00 $ 2,406,853.71 $1,875,287.22 61 $1,524,389.00
0.72 $ 2,421,619.72 $1,748,494.81 62 $1,412,655.00
0.94 $ 2,436,385.73 $2,300,440.17 63 $1,847,322.00
0.83 $ 2,451,151.74 $2,045,190.23 64 $1,632,455.00
0.88 $ 2,465,917.76 $2,162,667.82 65 $1,715,888.00
0.97 $ 2,480,683.77 $2,399,338.32 66 $1,892,334.00
1.00 $ 2,495,449.78 $2,495,810.31 67 $1,956,773.00
0.94 $ 2,510,215.79 $2,353,785.74 68 $1,834,567.00
0.90 $ 2,524,981.80 $2,264,584.97 69 $1,754,721.00
0.84 $ 2,539,747.82 $2,128,643.71 70 $1,639,797.00
0.64 $ 2,554,513.83 $1,626,424.49 71 $1,245,671.00
1.23 $ 2,569,279.84 $3,150,009.12 72 $2,398,712.00
0.82 $1,602,145.00
0.76 $1,487,221.00
0.99 $1,932,788.00
0.88 $1,723,456.00
0.92 $1,792,344.00
1.09 $2,123,789.00
1.32 $2,587,443.00
0.94 $1,831,009.00
0.90 $1,754,721.00
0.84 $1,639,797.00
0.64 $1,245,671.00
1.23 $2,398,712.00
0.86 $1,678,433.00
0.80 $1,563,509.00
1.03 $2,009,076.00
0.90 $1,754,721.00
0.84 $1,639,797.00
0.97 $1,892,334.00
1.00 $1,956,773.00
0.94 $1,834,567.00
0.90 $1,754,721.00
1.10 $2,145,678.00
1.02 $1,987,543.00
1.32 $2,587,443.00
0.90 $1,754,721.00
0.84 $1,639,797.00
0.64 $1,245,671.00
0.56 $1,087,654.00
0.68 $1,325,789.00
0.78 $1,523,456.00
0.90 $1,756,832.00
0.97 $1,892,344.00
1.03 $2,009,076.00
1.10 $2,145,678.00
1.18 $2,312,543.00
1.28 $2,498,765.00
0.97 $1,892,344.00
1.02 $1,987,543.00
1.18 $2,312,543.00
1.10 $2,145,678.00
 1.03 $2,009,076.00
1.18 $2,312,543.00
1.28 $2,498,765.00
1.39 $2,712,876.00
1.45 $2,845,678.00
1.54 $3,012,543.00
1.63 $3,189,765.00
1.79 $3,498,765.00
$1,875,287.22
$1,748,494.81
$2,300,440.17
$2,045,190.23
$2,162,667.82
$2,399,338.32
Proyectado
$2,495,810.31
$2,353,785.74
$2,264,584.97
$2,128,643.71
$1,626,424.49
$3,150,009.12

Pronostico de
Tendencia para ventas,
Indice estacional Indice estacional Periodos Ventas y
los proximos 12 tomando en
por mes total pronosticados pronosctivo
meses cuenta
estacionalidad
0.79 1.00 $ 1,511,648.16 $1,194,766.91 61 $1,040,536.87
0.73 $ 1,519,500.01 $1,113,619.35 62 $1,048,388.73
0.96 $ 1,527,351.87 $1,462,359.56 63 $1,056,240.58
0.86 $ 1,535,203.72 $1,317,428.12 64 $1,064,092.44
0.90 $ 1,543,055.58 $1,391,379.75 65 $1,071,944.29
0.99 $ 1,550,907.43 $1,528,609.24 66 $1,079,796.15
1.01 $ 1,558,759.28 $1,566,612.60 67 $1,087,648.00
0.93 $ 1,566,611.14 $1,451,772.66 68 $1,095,499.86
0.91 $ 1,574,462.99 $1,433,310.09 69 $1,103,351.71
0.85 $ 1,582,314.85 $1,346,116.14 70 $1,111,203.57
0.72 $ 1,590,166.70 $1,141,198.94 71 $1,119,055.42
1.23 $ 1,598,018.56 $1,962,703.97 72 $1,126,907.28
0.83 $1,134,759.13
0.77 $1,142,610.99
1.00 $1,150,462.84
0.89 $1,158,314.69
0.90 $1,166,166.55
1.06 $1,174,018.40
1.28 $1,181,870.26
0.95 $1,189,722.11
0.91 $1,197,573.97
0.85 $1,205,425.82
0.72 $1,213,277.68
1.23 $1,221,129.53
0.87 $1,228,981.39
0.81 $1,236,833.24
1.04 $1,244,685.10
0.91 $1,252,536.95
0.85 $1,260,388.81
0.99 $1,268,240.66
1.01 $1,276,092.52
0.93 $1,283,944.37
0.91 $1,291,796.22
1.11 $1,299,648.08
 1.03 $1,307,499.93
1.28 $1,315,351.79
0.91 $1,323,203.64
0.85 $1,331,055.50
0.72 $1,338,907.35
0.64 $1,346,759.21
0.73 $1,354,611.06
0.84 $1,362,462.92
0.97 $1,370,314.77
1.04 $1,378,166.63
1.11 $1,386,018.48
1.18 $1,393,870.34
1.27 $1,401,722.19
1.37 $1,409,574.05
0.90 $1,417,425.90
0.95 $1,425,277.75
1.09 $1,433,129.61
1.01 $1,440,981.46
0.95 $1,448,833.32
1.09 $1,456,685.17
1.18 $1,464,537.03
1.28 $1,472,388.88
1.34 $1,480,240.74
1.42 $1,488,092.59
1.50 $1,495,944.45
1.65 $1,503,796.30
$1,194,766.91
$1,113,619.35
$1,462,359.56
$1,317,428.12
$1,391,379.75
$1,528,609.24
Proyectado
$1,566,612.60
$1,451,772.66
$1,433,310.09
$1,346,116.14
$1,141,198.94
$1,962,703.97

Pronostico de
Tendencia para ventas,
Indice estacional Indice estacional Periodos Ventas y
los proximos 12 tomando en
por mes total pronosticados pronosctivo
meses cuenta
estacionalidad
0.80 1.00 $ 676,075.88 $ 541,747.84 61 $ 301,572.51
0.78 $ 682,317.60 $ 531,718.01 62 $ 307,814.24
0.79 $ 688,559.32 $ 542,252.69 63 $ 314,055.96
0.76 $ 694,801.04 $ 525,281.43 64 $ 320,297.68
0.75 $ 701,042.77 $ 525,670.21 65 $ 326,539.40
0.83 $ 707,284.49 $ 587,579.44 66 $ 332,781.13
0.85 $ 713,526.21 $ 606,427.01 67 $ 339,022.85
0.82 $ 719,767.93 $ 587,132.18 68 $ 345,264.57
0.87 $ 726,009.66 $ 634,674.87 69 $ 351,506.30
0.85 $ 732,251.38 $ 622,793.84 70 $ 357,748.02
0.66 $ 738,493.10 $ 484,571.00 71 $ 363,989.74
0.99 $ 744,734.83 $ 734,303.19 72 $ 370,231.46
0.81 $ 376,473.19
0.79 $ 382,714.91
0.85 $ 388,956.63
0.77 $ 395,198.35
 0.80 $ 401,440.08
0.91 $ 407,681.80
1.05 $ 413,923.52
0.90 $ 420,165.24
0.87 $ 426,406.97
0.85 $ 432,648.69
0.66 $ 438,890.41
0.99 $ 445,132.14
0.84 $ 451,373.86
0.82 $ 457,615.58
0.88 $ 463,857.30
0.87 $ 470,099.03
0.85 $ 476,340.75
0.83 $ 482,582.47
0.85 $ 488,824.19
0.82 $ 495,065.92
0.87 $ 501,307.64
0.95 $ 507,549.36
0.89 $ 513,791.09
1.05 $ 520,032.81
0.87 $ 526,274.53
0.85 $ 532,516.25
0.66 $ 538,757.98
0.63 $ 544,999.70
0.77 $ 551,241.42
0.88 $ 557,483.14
1.01 $ 563,724.87
1.09 $ 569,966.59
1.16 $ 576,208.31
1.24 $ 582,450.04
1.33 $ 588,691.76
1.44 $ 594,933.48
1.09 $ 601,175.20
1.15 $ 607,416.93
1.33 $ 613,658.65
1.24 $ 619,900.37
1.16 $ 626,142.09
1.33 $ 632,383.82
1.44 $ 638,625.54
1.56 $ 644,867.26
1.64 $ 651,108.98
1.74 $ 657,350.71
1.84 $ 663,592.43
2.02 $ 669,834.15
$ 541,747.84
$ 531,718.01
$ 542,252.69
$ 525,281.43
$ 525,670.21
$ 587,579.44
Proyectado
$ 606,427.01
$ 587,132.18
$ 634,674.87
$ 622,793.84
$ 484,571.00
$ 734,303.19

Proyeccion
 Utilidad Antes Impuestos % Margen
Depreciación Intereses Utilidad Neta
Imp. (30%) Neto
$ 48,000.00 $ 22,500.00 $ 68,272.47 $ 20,481.74 $ 47,790.73 2.5%
$ 48,000.00 $ 22,500.00 $ 32,657.45 $ 9,797.24 $ 22,860.22 1.3%
$ 48,000.00 $ 22,500.00 $ 225,327.92 $ 67,598.38 $ 157,729.54 6.9%
$ 48,000.00 $ 22,500.00 $ 131,980.67 $ 39,594.20 $ 92,386.47 4.5%
$ 48,000.00 $ 22,500.00 $ 175,117.86 $ 52,535.36 $ 122,582.50 5.7%
$ 48,000.00 $ 22,500.00 $ 212,649.64 $ 63,794.89 $ 148,854.75 6.2%
$ 48,000.00 $ 22,500.00 $ 252,270.70 $ 75,681.21 $ 176,589.49 7.1%
$ 48,000.00 $ 22,500.00 $ 244,380.91 $ 73,314.27 $ 171,066.63 7.3%
$ 48,000.00 $ 22,500.00 $ 126,100.00 $ 37,830.00 $ 88,270.00 3.9%
$ 48,000.00 $ 22,500.00 $ 89,233.73 $ 26,770.12 $ 62,463.61 2.9%
$ 48,000.00 $ 22,500.00 -$ 69,845.46 -$ 20,953.64 -$ 48,891.82 -3.0%
$ 48,000.00 $ 22,500.00 $ 382,501.95 $ 114,750.58 $ 267,751.36 8.5%

$ 7,618,865 Pasivo correinte $ 5,144,083

7,250,179 Pasivo no corrien 4,690,590 66%
Patrimonio 5,034,371 34%

$ 14,869,044 Total $ 14,869,044

FER $ -

$ 8,119,393 Deuda $ 9,834,673

$ 7,726,487 Patrimonio $ 4,525,604

$ 15,845,880 Total $ 14,360,277

$ 9,314,834 Deuda $ 6,289,162

$ 8,864,079 Patrimonio $ 5,734,722

$ 18,178,913 Total $ 12,023,884

FER $ 1,145,080
Resumen

Estadísticas de la regresión
Coeficiente de correla 0.5379478845323
Coeficiente de deter 0.2893879264727
R^2 ajustado 0.2771359941705
Error típico 407569.08967481
Observaciones 60

ANÁLISIS DE VARIANZA
Grados de libertad Suma de cuadrados
Promedio de los cuadrados F Valor crítico de F
Regresión 1 3923541931262.69 3923541931262.69 23.6197784426955 9.3040154E-06
Residuos 58 9634528645784.64 166112562858.356
Total 59 13558070577047.3

Coeficientes Error típico Estadístico t Probabilidad Inferior 95%

Intercepción 1506126.960452 106563.20928882 14.133648662644 1.93103629922E-20 1292817.52125
Variable X 1 14766.012225618 3038.26264369967 4.86001835826733 9.304015375539E-06 8684.2687703

y=bx+a $ 1,506,126.96
$ 14,766.01
Resumen

Estadísticas de la regresión
Coeficiente de correla 0.5163345492507
Coeficiente de deter 0.2666013667499
R^2 ajustado 0.2539565627284
Error típico 229389.2416558
Observaciones 60

ANÁLISIS DE VARIANZA
Grados de libertad Suma de cuadrados
Promedio de los cuadrados F Valor crítico de F
Regresión 1 1109420943341.67 1109420943341.67 21.0838670410004 2.4110548E-05
Residuos 58 3051926602870.66 52619424187.4251
Total 59 4161347546212.33

Coeficientes Error típico Estadístico t Probabilidad Inferior 95%

Intercepción 1032685.0195815 59976.2209314613 17.2182408885279 1.808976462728E-24 912629.56951
Variable X 1 7851.8547046513 1710.00397587928 4.59171722136723 2.411054812787E-05 4428.90984818

y=bx+a $ 1,032,685.02
$ 7,851.85
Resumen

Estadísticas de la regresión
Coeficiente de correla 0.7427352726155
Coeficiente de deter 0.5516556851872
R^2 ajustado 0.5439256107938
Error típico 99114.725751804
Observaciones 60
ANÁLISIS DE VARIANZA
Grados de libertad Suma de cuadrados
Promedio de los cuadrados F Valor crítico de F
Regresión 1 701069045403.723 701069045403.723 71.3648610760498 1.0928393E-11
Residuos 58 569776273929.61 9823728860.85535
Total 59 1270845319333.33

Coeficientes Error típico Estadístico t Probabilidad Inferior 95%

Intercepción 295330.79096045 25914.5836410719 11.3963162615657 1.961061430099E-16 243457.115792
Variable X 1 6241.7227007502 738.860174436957 8.44777255115512 1.092839342645E-11 4762.73337124

y=bx+a $ 295,330.79
$ 6,241.72
or crítico de F

Superior 95% Inferior 95.0% Superior 95.0%

1719436.3997 1292817.5213 1719436.3997
20847.755681 8684.2687703 20847.755681
or crítico de F

Superior 95% Inferior 95.0% Superior 95.0%

1152740.4697 912629.56951 1152740.4697
11274.799561 4428.9098482 11274.799561
or crítico de F

Superior 95% Inferior 95.0% Superior 95.0%

347204.46613 243457.11579 347204.46613
7720.7120303 4762.7333712 7720.7120303
 Balance General al 31/12/2021

(Cifras en USD)

Activos
Cuenta Monto (USD)
Activos Corrientes
- Efectivo y equivalentes 387,650.25
- Cuentas por cobrar 2,887,423.71
- Inventarios 4,215,339.88
- Gastos pagados por anticipado 128,450.90
Total Activos Corrientes 7,618,864.74

Activos No Corrientes

Maquinaria y equipo (bruto) 9,750,000.00

Depreciación acumulada -3,287,500.75
Equipos de tecnología 1,175,330.45
Amortización acumulada -387,650.25
Total Activos No Corrientes 7,250,179.45
Total Activos 14,869,044.19
Balance General al 31/12/2021

(Cifras en USD)

Pasivos
Cuenta Monto (USD)
Pasivos Corrientes
- Proveedores 2,587,423.71
- Impuestos por pagar 543,678.10
- Deuda a corto plazo 1,725,330.45
- Acreedores varios 287,650.25
Total Pasivos Corrientes 5,144,082.51

Pasivos No Corrientes

- Deuda a largo plazo 4,215,339.88

- Provisiones 475,250.60
Total Pasivos No Corrientes 4,690,590.48
Total Pasivos 9,834,672.99

Patrimonio
- Capital social 2,887,423.71
- Utilidades retenidas 2,146,947.49
Total Patrimonio 5,034,371.20
Total Pasivos + Patrimonio 14,869,044.19
 Indice de
Mes Volumen de ventas estacional
idad

Jan-21 $ 1,892,344.00
Feb-21 $ 1,987,543.00
Mar-21
Apr-21
$
$
2,312,543.00
2,145,678.00
ESTACIONALIDAD
May-21 $ 2,009,076.00 10.50
Jun-21 $ 2,312,543.00
9.50
Jul-21 $ 2,498,765.00
Aug-21 $ 2,712,876.00 8.50
Sep-21 $ 2,845,678.00 7.50
Oct-21 $ 3,012,543.00 6.50
Nov-21 $ 3,189,765.00
5.50
Dec-21 $ 3,498,765.00
Jan-22 $ 1,875,287.22 4.50
Feb-22 $ 1,748,494.81 3.50
Mar-22 $ 2,300,440.17 2.50
Apr-22 $ 2,045,190.23
1.50
May-22 $ 2,162,667.82
Jun-22 $ 2,399,338.32 0.50
21 21 21 21 21 21 21 21 21 21 21 21 22 22 22 22 22 22 2
Jul-22 $ 2,495,810.31
a n- eb- ar- pr- ay- un- Jul- ug- ep- ct- ov- ec- an- eb- ar- pr- ay- un- Jul-
Aug-22 $ 2,353,785.74 J F M A M J A S O N D J F M A M J
Sep-22 $ 2,264,584.97
Oct-22 $ 2,128,643.71
Nov-22 $ 1,626,424.49
Dec-22 $ 3,150,009.12
 ESTACIONALIDAD $4,000,000.00

10.50 $3,500,000.00
9.50 $3,000,000.00
8.50
$2,500,000.00
7.50
6.50 $2,000,000.00
5.50 $1,500,000.00
4.50
$1,000,000.00
3.50
2.50 $500,000.00
1.50 $-
0.50 21 21 21 21 21 21 21 2
n- eb- ar- pr- ay- un- Jul- ug-
21 21 21 21 21 21 21 21 21 21 21 21 22 22 22 22 22 22 22 22 22 22 22 22 Ja F M A M J A
a n- eb- ar- pr- ay- un- Jul- ug- ep- ct- ov- ec- an- eb- ar- pr- ay- un- Jul- ug- ep- ct- ov- ec-
J F M A M J A S O N D J F M A M J A S O N D
0.00 VENTAS
0.00

0.00

0.00

0.00

0.00

0.00

0.00

$-
21 21 21 21 21 21 21 21 21 21 21 21 22 22 22 22 22 22 22 22 22 22 22 22
n- eb- ar- pr- ay- un- Jul- ug- ep- ct- ov- ec- an- eb- ar- pr- ay- un- Jul- ug- ep- ct- ov- ec-
Ja F M A M J A S O N D J F M A M J A S O N D
Características Clave de la información
Ventas:
Crecimiento anual promedio: 3.2% entre 2017 y 2021.
Excepción en 2020: Caída del 1.7% debido a la pandemia de COVID-19, que afectó las ventas y generó pérdidas en varios meses (especialm
Recuperación en 2021: Las ventas superaron los niveles pre-pandemia, con un margen bruto mejorado (60% vs. ~66% en años anteriores)
Meses altos: Marzo (primavera) y octubre-diciembre (temporada alta). Destacan diciembre (cierre fiscal) y julio-agosto (récords históricos en
Meses bajos: Febrero (post-navidad) y abril (transición). Noviembre también suele ser débil, con pérdidas en algunos años.

Costos:
Eventos externos: Alza en costos de algodón (2017), huelgas logísticas (2019), COVID-19 (2020), y pedidos internacionales ([Link]. en 2019
en varios meses (especialmente marzo a diciembre).
~66% en años anteriores) gracias a la nueva maquinaria y eficiencias.
gosto (récords históricos en 2018 y 2021).

nacionales ([Link]. en 2019 y 2021).