Proyecto de Evaluación Financiera la Textilería
algonzalez3Práctica o problema4 de Mayo de 2022
1.493 Palabras (6 Páginas)99 Visitas
LA TEXTILERÍA S.A. DE C.V.
AÑO | VENTAS | COSSTOS Y GASTOS |
1 1,100,000.00 | 43% | |
2 900,000.00 | 37% | |
3 1,000,050.00 | 39% | |
4 1,230,000.00 | 40% |
POLÍTICA DE COBRO 40% EFECTIVO
60% A 30 DÍAS
POLÍTICA DE PAGO 50% EFECTIVO
50% A 30 DÍAS
INVERSIÓN: 3.5 MILLONES A UN PLAZO DE 4 AÑOS, i=12.5% LA CAJA FINAL ES DEL 30%
LOS COSTOS Y GASTOS YA INCLUYEN INTERÉS, AMORTIZACIÓN DEL CRÉDITO Y DEPRECIACIONE
SE PIDE:
- DETERMINAR EL ER PROFORMA
- DETERMINAR EL FLUJO DE CAJA
- EVALUAR LA DECISIÓN
TIR VAN PRI
C/B
- 5 CONCLUSIONES Y/O RECOMENDACIONES GENERALES
S
ESTADO DE RESULTADOS
1 2 3 4
VENTAS 1,100,000.00 900,000.00 1,000,050.00 1,230,000.00 COSTOS Y GASTOS 473,000.00 333,000.00 390,019.50 492,000.00
UTILIDAD ANTES DE IMPUESTOS | 627,000.00 | 567,000.00 | 610,030.50 | 738,000.00 |
IMPUESTOS 188,100.00 170,100.00 183,009.15 221,400.00 | ||||
UTILIDAD NETA | 438,900.00 | 396,900.00 | 427,021.35 | 516,600.00 |
1,100,000.00 | 900,000.00 | 1,000,050.00 | 1,230,000.00 | |
12 | 12 | 12 | 12 | |
91,666.67 | 75,000.00 | 83,337.50 | 102,500.00 | |
11.4 | 11.4 | 11.4 | 11.4 | |
EFECTIVO | 1,045,000.00 | 855,000.00 | 950,047.50 | 1,168,500.00 |
CRÉDITO | 55,000.00 | 45,000.00 | 50,002.50 | 61,500.00 |
TOTAL ING | 1,045,000.00 | 910,000.00 | 995,047.50 | 1,218,502.50 |
473,000.00 | 333,000.00 | 390,019.50 | 492,000.00 | |
12 | 12 | 12 | 12 | |
39,416.67 | 27,750.00 | 32,501.63 | 41,000.00 | |
11.5 | 11.5 | 11.5 | 11.5 | |
EFECTIVO | 453,291.67 | 319,125.00 | 373,768.69 | 471,500.00 |
CRÉDITO | 19,708.33 | 13,875.00 | 16,250.81 | 20,500.00 |
TOTAL EG | 453,291.67 | 338,833.33 | 387,643.69 | 487,750.81 |
FLUJO DE EFECTIVO
INGRESOS | 1 | 2 | 3 | 4 |
VENTAS | 1,045,000.00 | 910,000.00 | 995,047.50 | 1,218,502.50 |
EGRESOS COSTOS Y GASTOS | 453,291.67 | 338,833.33 | 387,643.69 | 487,750.81 |
IMPUESTOS 188,100.00 170,100.00 183,009.15 | ||||
TOTAL EGRESOS | 453,291.67 | 526,933.33 | 557,743.69 | 670,759.96 |
FLUJO DE CAJA | 591,708.33 | 383,066.67 | 437,303.81 | 547,742.54 |
SALDO INICIAL 591,708.33 974,775.00 1,412,078.81 |
FLUJO EFECTIVO NETO 591,708.33 974,775.00 1,412,078.81 1,959,821.35
CAPITAL | 3,500,000.00 |
TASA | 12.5% 0.010416667 |
PLAZO | 48 MESES |
PAGO | $93,030.00 |
[pic 1]
CUADRO DE AMORTIZACIÓN | |||||
AÑO | NUM | PRÉSTAMO | INTERES | PAGO A CAPITAL | PAGO TOTAL |
1 | 1 | $ 3,500,000.00 | $ 36,458.33 | $ 56,571.66 | $93,030.00 |
2 | $ 3,443,428.34 | $ 35,869.05 | $ 57,160.95 | $93,030.00 | |
3 | $ 3,386,267.39 | $ 35,273.62 | $ 57,756.38 | $93,030.00 | |
4 | $ 3,328,511.01 | $ 34,671.99 | $ 58,358.01 | $93,030.00 | |
5 | $ 3,270,153.00 | $ 34,064.09 | $ 58,965.90 | $93,030.00 | |
6 | $ 3,211,187.10 | $ 33,449.87 | $ 59,580.13 | $93,030.00 | |
7 | $ 3,151,606.97 | $ 32,829.24 | $ 60,200.76 | $93,030.00 | |
8 | $ 3,091,406.21 | $ 32,202.15 | $ 60,827.85 | $93,030.00 | |
9 | $ 3,030,578.36 | $ 31,568.52 | $ 61,461.47 | $93,030.00 | |
10 | $ 2,969,116.89 | $ 30,928.30 | $ 62,101.70 | $93,030.00 | |
11 | $ 2,907,015.20 | $ 30,281.41 | $ 62,748.59 | $93,030.00 | |
12 | $ 2,844,266.61 | $ 29,627.78 | $ 63,402.22 | $93,030.00 | |
SUMAS | $ 397,224.34 | $ 719,135.61 | $ 1,116,359.95 | ||
2 | 13 | $ 2,780,864.39 | $ 28,967.34 | $ 64,062.66 | $93,030.00 |
14 | $ 2,716,801.73 | $ 28,300.02 | $ 64,729.98 | $93,030.00 | |
15 | $ 2,652,071.75 | $ 27,625.75 | $ 65,404.25 | $93,030.00 | |
16 | $ 2,586,667.51 | $ 26,944.45 | $ 66,085.54 | $93,030.00 | |
17 | $ 2,520,581.96 | $ 26,256.06 | $ 66,773.93 | $93,030.00 | |
18 | $ 2,453,808.03 | $ 25,560.50 | $ 67,469.50 | $93,030.00 | |
19 | $ 2,386,338.53 | $ 24,857.69 | $ 68,172.30 | $93,030.00 | |
20 | $ 2,318,166.23 | $ 24,147.56 | $ 68,882.43 | $93,030.00 | |
21 | $ 2,249,283.80 | $ 23,430.04 | $ 69,599.96 | $93,030.00 | |
22 | $ 2,179,683.84 | $ 22,705.04 | $ 70,324.96 | $93,030.00 | |
23 | $ 2,109,358.89 | $ 21,972.49 | $ 71,057.51 | $93,030.00 | |
24 | $ 2,038,301.38 | $ 21,232.31 | $ 71,797.69 | $93,030.00 | |
SUMAS | $ 301,999.25 | $ 814,360.70 | $ 1,116,359.95 | ||
3 | 25 | $ 1,966,503.69 | $ 20,484.41 | $ 72,545.58 | $93,030.00 |
26 | $ 1,893,958.11 | $ 19,728.73 | $ 73,301.27 | $93,030.00 | |
27 | $ 1,820,656.84 | $ 18,965.18 | $ 74,064.82 | $93,030.00 | |
28 | $ 1,746,592.02 | $ 18,193.67 | $ 74,836.33 | $93,030.00 | |
29 | $ 1,671,755.69 | $ 17,414.12 | $ 75,615.87 | $93,030.00 | |
30 | $ 1,596,139.82 | $ 16,626.46 | $ 76,403.54 | $93,030.00 | |
31 | $ 1,519,736.28 | $ 15,830.59 | $ 77,199.41 | $93,030.00 | |
32 | $ 1,442,536.87 | $ 15,026.43 | $ 78,003.57 | $93,030.00 | |
33 | $ 1,364,533.30 | $ 14,213.89 | $ 78,816.11 | $93,030.00 | |
34 | $ 1,285,717.19 | $ 13,392.89 | $ 79,637.11 | $93,030.00 | |
35 | $ 1,206,080.08 | $ 12,563.33 | $ 80,466.66 | $93,030.00 | |
36 | $ 1,125,613.42 | $ 11,725.14 | $ 81,304.86 | $93,030.00 | |
SUMAS | $ 194,164.83 | $ 922,195.13 | $ 1,116,359.95 | ||
4 | 37 | $ 1,044,308.56 | $ 10,878.21 | $ 82,151.78 | $93,030.00 |
38 | $ 962,156.78 | $ 10,022.47 | $ 83,007.53 | $93,030.00 | |
39 | $ 879,149.25 | $ 9,157.80 | $ 83,872.19 | $93,030.00 | |
40 | $ 795,277.06 | $ 8,284.14 | $ 84,745.86 | $93,030.00 | |
41 | $ 710,531.20 | $ 7,401.37 | $ 85,628.63 | $93,030.00 | |
42 | $ 624,902.57 | $ 6,509.40 | $ 86,520.59 | $93,030.00 | |
43 | $ 538,381.97 | $ 5,608.15 | $ 87,421.85 | $93,030.00 | |
44 | $ 450,960.12 | $ 4,697.50 | $ 88,332.49 | $93,030.00 | |
45 | $ 362,627.63 | $ 3,777.37 | $ 89,252.62 | $93,030.00 | |
46 | $ 273,375.00 | $ 2,847.66 | $ 90,182.34 | $93,030.00 | |
47 | $ 183,192.66 | $ 1,908.26 | $ 91,121.74 | $93,030.00 | |
48 | $ 92,070.92 | $ 959.07 | $ 92,070.92 | $93,030.00 | |
SUMAS | $ 72,051.39 | $ 1,044,308.56 | $ 1,116,359.95 |
...