presentacion simulacion de finanzas

25

Upload: kornly85

Post on 09-Jul-2015

603 views

Category:

Economy & Finance


1 download

DESCRIPTION

Materia Financiera

TRANSCRIPT

Page 1: Presentacion simulacion de finanzas
Page 2: Presentacion simulacion de finanzas

Estado de ResultadosAño 1o 2o 3o 4o 5o 6o 7o 8o 9o 10o

Ventas 10,800,000.00$ 13,500,000.00$ 16,200,000.00$ 16,200,000.00$ 16,200,000.00$ 16,200,000.00$ 16,200,000.00$ 16,200,000.00$ 16,200,000.00$ 16,200,000.00$

Costo de Ventas 9,134,080.00$ 11,190,850.00$ 13,247,620.00$ 13,247,620.00$ 13,247,620.00$ 13,247,620.00$ 13,247,620.00$ 13,247,620.00$ 13,247,620.00$ 13,247,620.00$

Utilidad Bruta 1,665,920.00$ 2,309,150.00$ 2,952,380.00$ 2,952,380.00$ 2,952,380.00$ 2,952,380.00$ 2,952,380.00$ 2,952,380.00$ 2,952,380.00$ 2,952,380.00$

Gtos de Admón 645,000.00$ 645,000.00$ 645,000.00$ 645,000.00$ 645,000.00$ 645,000.00$ 645,000.00$ 645,000.00$ 645,000.00$ 645,000.00$

Depresación 62,200.00$ 62,200.00$ 62,200.00$ 62,200.00$ 62,200.00$ 62,200.00$ 62,200.00$ 62,200.00$ 62,200.00$ 62,200.00$

Gastos de Operación 707,200.00$ 707,200.00$ 707,200.00$ 707,200.00$ 707,200.00$ 707,200.00$ 707,200.00$ 707,200.00$ 707,200.00$ 707,200.00$

Utilidad Antes de Imp. 958,720.00$ 1,601,950.00$ 2,245,180.00$ 2,245,180.00$ 2,245,180.00$ 2,245,180.00$ 2,245,180.00$ 2,245,180.00$ 2,245,180.00$ 2,245,180.00$

ISR -$ 480,585.00$ 673,554.00$ 673,554.00$ 673,554.00$ 673,554.00$ 673,554.00$ 673,554.00$ 673,554.00$ 673,554.00$

PTU -$ 160,195.00$ 224,518.00$ 224,518.00$ 224,518.00$ 224,518.00$ 224,518.00$ 224,518.00$ 224,518.00$ 224,518.00$

Impuestos -$ 640,780.00$ 898,072.00$ 898,072.00$ 898,072.00$ 898,072.00$ 898,072.00$ 898,072.00$ 898,072.00$ 898,072.00$

Utilidad Neta 958,720.00$ 961,170.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$

Utilidad Acum. 0 958,720.00$ 1,919,890.00$ 3,266,998.00$ 4,614,106.00$ 5,961,214.00$ 7,308,322.00$ 8,655,430.00$ 10,002,538.00$ 11,349,646.00$

Page 3: Presentacion simulacion de finanzas

Balance GeneralAño 1o 2o 3o 4o 5o 6o 7o 8o 9o 10o

Activo

Bancos 1,235,920.00$ 2,961,070.00$ 4,688,670.00$ 6,158,978.00$ 7,629,286.00$ 9,099,594.00$ 10,569,902.00$ 12,040,210.00$ 13,510,518.00$ 14,980,826.00$

Mobiliario y Equipo 610,000.00$ 610,000.00$ 610,000.00$ 610,000.00$ 610,000.00$ 610,000.00$ 610,000.00$ 610,000.00$ 610,000.00$ 610,000.00$

Gastos de Instalacion 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$

Equipo de Oficina 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$

Equipo de Computo 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00$

Equipo de Transporte 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$

Gastos de Constitución 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$ 50,000.00$

Depreciacion 62,200.00-$ 62,200.00-$ 62,200.00-$ 62,200.00-$ 62,200.00-$ 62,200.00-$ 62,200.00-$ 62,200.00-$ 62,200.00-$ 62,200.00-$

Dep. mob. 61,000.00-$ 61,000.00-$ 61,000.00-$ 61,000.00-$ 61,000.00-$ 61,000.00-$ 61,000.00-$ 61,000.00-$ 61,000.00-$ 61,000.00-$

Dep Acum. -$ 123,200.00-$ 246,400.00-$ 369,600.00-$ 492,800.00-$ 616,000.00-$ 739,200.00-$ 862,400.00-$ 985,600.00-$ 1,108,800.00-$

Total Activo 2,058,720.00$ 3,660,670.00$ 5,265,070.00$ 6,612,178.00$ 7,959,286.00$ 9,306,394.00$ 10,653,502.00$ 12,000,610.00$ 13,347,718.00$ 14,694,826.00$

Pasivo

ISR -$ 480,585.00$ 673,554.00$ 673,554.00$ 673,554.00$ 673,554.00$ 673,554.00$ 673,554.00$ 673,554.00$ 673,554.00$

PTU -$ 160,195.00$ 224,518.00$ 224,518.00$ 224,518.00$ 224,518.00$ 224,518.00$ 224,518.00$ 224,518.00$ 224,518.00$

Total Pasivo -$ 640,780.00$ 898,072.00$ 898,072.00$ 898,072.00$ 898,072.00$ 898,072.00$ 898,072.00$ 898,072.00$ 898,072.00$

Capital

Capital Social 1,100,000.00$ 1,100,000.00$ 1,100,000.00$ 1,100,000.00$ 1,100,000.00$ 1,100,000.00$ 1,100,000.00$ 1,100,000.00$ 1,100,000.00$ 1,100,000.00$

Utilidad del Ejerccio 958,720.00$ 961,170.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$ 1,347,108.00$

Utilidad Acum. -$ 958,720.00$ 1,919,890.00$ 3,266,998.00$ 4,614,106.00$ 5,961,214.00$ 7,308,322.00$ 8,655,430.00$ 10,002,538.00$ 11,349,646.00$

Total Capital 2,058,720.00$ 3,019,890.00$ 4,366,998.00$ 5,714,106.00$ 7,061,214.00$ 8,408,322.00$ 9,755,430.00$ 11,102,538.00$ 12,449,646.00$ 13,796,754.00$

Total P + C 2,058,720.00$ 3,660,670.00$ 5,265,070.00$ 6,612,178.00$ 7,959,286.00$ 9,306,394.00$ 10,653,502.00$ 12,000,610.00$ 13,347,718.00$ 14,694,826.00$

Page 4: Presentacion simulacion de finanzas
Page 5: Presentacion simulacion de finanzas
Page 6: Presentacion simulacion de finanzas
Page 7: Presentacion simulacion de finanzas
Page 8: Presentacion simulacion de finanzas
Page 9: Presentacion simulacion de finanzas
Page 10: Presentacion simulacion de finanzas
Page 11: Presentacion simulacion de finanzas
Page 12: Presentacion simulacion de finanzas
Page 13: Presentacion simulacion de finanzas
Page 14: Presentacion simulacion de finanzas
Page 15: Presentacion simulacion de finanzas
Page 16: Presentacion simulacion de finanzas
Page 17: Presentacion simulacion de finanzas

ENTRADAS

Saldo inicial $ 154,000.00

Ventas $ 5,400,000.00

$ 5,554,000.00

SALIDAS

Materia prima $ 4,113,540.00

Mano de obra $ 722,000.00

Gastos indirectos $ 124,000.00

Gastos de admón. $ 645,000.00

Impuestos $ -

$ 5,604,540.00

SOBRANTE O FALTANTE -$ 50,540.00

Page 18: Presentacion simulacion de finanzas

ENTRADAS

Saldo inicial $ 154,000.00 -$ 50,540.00

Ventas $ 5,400,000.00 $ 6,300,000.00

$ 5,554,000.00 $ 6,249,460.00

SALIDAS

Materia prima $ 4,113,540.00 $ 4,799,130.00

Mano de obra $ 722,000.00 $ 722,000.00

Gastos indirectos $ 124,000.00 $ 124,000.00

Gastos de admón. $ 645,000.00 $ 645,000.00

Impuestos $ - $ -

$ 5,604,540.00 $ 6,290,130.00

SOBRANTE O FALTANTE -$ 50,540.00 -$ 40,670.00

Page 19: Presentacion simulacion de finanzas

Entradas

Saldo inicial $ 154,000.00 -$ 50,540.00 -$ 40,670.00

Ventas $ 5,400,000.00 $ 6,300,000.00 $ 16,200,000.00

$ 5,554,000.00 $ 6,249,460.00 $ 16,159,330.00

SALIDAS

Materia prima $ 4,113,540.00 $ 4,799,130.00 $ 12,340,620.00

Mano de obra $ 722,000.00 $ 722,000.00 $ 722,000.00

Gastos indirectos $ 124,000.00 $ 124,000.00 $ 124,000.00

Gastos de admón. $ 645,000.00 $ 645,000.00 $ 645,000.00

Impuestos $ - $ - $ 148,161.33

$ 5,604,540.00 $ 6,290,130.00 $ 13,979,781.33

SOBRANTE O FALTANTE -$ 50,540.00 -$ 40,670.00 $ 2,179,548.67

Page 20: Presentacion simulacion de finanzas

1200 1500 1800

VTAS EN % -20% 100% 180+

-80 BASE 80+

36000 45000 54000

27423.6 54000

8576.9 41135.4

124000 124000 124000

(-11542310) (-113279.50) (-111135.40)

(-101.89) 100% (-98.11)

-189 BASE (-1.98)

IGUAL A LA UTILIDAD DE OPERACIÓN

UTIDAD EN %

VARIACION EN %

UDS VENDIDAS

VARIACION EN %

VTAS NETAS EN %

MENOS CTO VARIABLE

IGUL CONTRIBUCION MARGINAL

MENOS CTOS FIJOS

Page 21: Presentacion simulacion de finanzas
Page 22: Presentacion simulacion de finanzas
Page 23: Presentacion simulacion de finanzas
Page 24: Presentacion simulacion de finanzas
Page 25: Presentacion simulacion de finanzas