tablas amortización1

31
Pre Pl Pre Pl Pre Pl

Upload: omaar-mustaine-rattlehead

Post on 05-Nov-2015

1 views

Category:

Documents


0 download

DESCRIPTION

k

TRANSCRIPT

DatosBIEN 1

DatosPrecio de Venta$600,000.00Tasa0.119Plazo en Dias360

BIEN 2

DatosPrecio de Venta$100,000.00Tasa0.117Plazo en Dias360

BIEN 3

DatosPrecio de Venta$500,000.00Tasa0.099Plazo en Dias360

Bien1Esquema de Pagos Decrecientes # De PagosCapital InicialAmortizacinInteresPagoCapital Final1$600,000.00$50,000.00$71,400.00$121,400.00$550,000.002$550,000.00$50,000.00$65,450.00$115,450.00$500,000.003$500,000.00$50,000.00$59,500.00$109,500.00$450,000.004$450,000.00$50,000.00$53,550.00$103,550.00$400,000.005$400,000.00$50,000.00$47,600.00$97,600.00$350,000.006$350,000.00$50,000.00$41,650.00$91,650.00$300,000.007$300,000.00$50,000.00$35,700.00$85,700.00$250,000.008$250,000.00$50,000.00$29,750.00$79,750.00$200,000.009$200,000.00$50,000.00$23,800.00$73,800.00$150,000.0010$150,000.00$50,000.00$17,850.00$67,850.00$100,000.0011$100,000.00$50,000.00$11,900.00$61,900.00$50,000.0012$50,000.00$50,000.00$5,950.00$55,950.000.0

Esquema Tipo Bullet# De PagosCapital InicialAmortizacinInteresPagoCapital Final1$600,000.000.0$71,400.00$71,400.00$600,000.002$600,000.000.0$71,400.00$71,400.00$600,000.003$600,000.000.0$71,400.00$71,400.00$600,000.004$600,000.000.0$71,400.00$71,400.00$600,000.005$600,000.000.0$71,400.00$71,400.00$600,000.006$600,000.000.0$71,400.00$71,400.00$600,000.007$600,000.000.0$71,400.00$71,400.00$600,000.008$600,000.000.0$71,400.00$71,400.00$600,000.009$600,000.000.0$71,400.00$71,400.00$600,000.0010$600,000.000.0$71,400.00$71,400.00$600,000.0011$600,000.000.0$71,400.00$71,400.00$600,000.0012$600,000.00$600,000.00$71,400.00$671,400.000.0

Esquema De Pagos Crecientes# De PagosCapital InicialAmortizacinInteresPagoCapital Final1$600,000.000.0$71,400.00$55,950.00$600,000.002$600,000.000.0$71,400.00$62,608.05$600,000.003$600,000.000.0$71,400.00$70,058.41$600,000.004$600,000.000.0$71,400.00$78,395.36$600,000.005$600,000.000.0$71,400.00$87,724.41$600,000.006$600,000.000.0$71,400.00$98,163.61$600,000.007$600,000.000.0$71,400.00$109,845.08$600,000.008$600,000.000.0$71,400.00$122,916.64$600,000.009$600,000.000.0$71,400.00$137,543.73$600,000.0010$600,000.000.0$71,400.00$153,911.43$600,000.0011$600,000.000.0$71,400.00$172,226.89$600,000.0012$600,000.00$600,000.00$71,400.00$192,721.890.0

Esquema De Pagos Iguales# De PagosCapital InicialAmortizacinInteresPagoCapital Final1$600,000.000.0$71,400.00$84,264.73$600,000.002$600,000.000.0$71,400.00$84,264.73$600,000.003$600,000.000.0$71,400.00$84,264.73$600,000.004$600,000.000.0$71,400.00$84,264.73$600,000.005$600,000.000.0$71,400.00$84,264.73$600,000.006$600,000.000.0$71,400.00$84,264.73$600,000.007$600,000.000.0$71,400.00$84,264.73$600,000.008$600,000.000.0$71,400.00$84,264.73$600,000.009$600,000.000.0$71,400.00$84,264.73$600,000.0010$600,000.000.0$71,400.00$84,264.73$600,000.0011$600,000.000.0$71,400.00$84,264.73$600,000.0012$600,000.00$600,000.00$71,400.00$84,264.730.0

Bien2

Bien3

TablasEmpresa A

Unidades Vendidas20000400006000080000100000120000200000Ingreso Neto Por Ventas$12,000,000,000.00$24,000,000,000.00$36,000,000,000.00$48,000,000,000.00$60,000,000,000.00$72,000,000,000.00$120,000,000,000.00-Costo Variable Total$7,200,000.00$14,400,000.00$21,600,000.00$28,800,000.00$36,000,000.00$43,200,000.00$72,000,000.00Margen de Contribucin$11,992,800,000.00$23,985,600,000.00$35,978,400,000.00$47,971,200,000.00$59,964,000,000.00$71,956,800,000.00$119,928,000,000.00-Costos Fijos$0.12$0.12$0.12$0.12$0.12$0.12$0.12Ingresos Netos En Operacin$11,992,799,999.88$23,985,599,999.88$35,978,399,999.88$47,971,199,999.88$59,963,999,999.88$71,956,799,999.88$119,927,999,999.88Empresa B

Unidades Vendidas20000400006000080000100000120000200000Ingreso Neto Por Ventas$2,000,000,000.00$4,000,000,000.00$6,000,000,000.00$8,000,000,000.00$10,000,000,000.00$12,000,000,000.00$20,000,000,000.00-Costo Variable Total$7,200,000.00$14,400,000.00$21,600,000.00$28,800,000.00$36,000,000.00$43,200,000.00$72,000,000.00Margen de Contribucin$1,992,800,000.00$3,985,600,000.00$5,978,400,000.00$7,971,200,000.00$9,964,000,000.00$11,956,800,000.00$19,928,000,000.00-Costos Fijos$0.12$0.12$0.12$0.12$0.12$0.12$0.12Ingresos Netos En Operacin$1,992,799,999.88$3,985,599,999.88$5,978,399,999.88$7,971,199,999.88$9,963,999,999.88$11,956,799,999.88$19,927,999,999.88Empresa C

Unidades Vendidas20000400006000080000100000120000200000Ingreso Neto Por Ventas$10,000,000,000.00$20,000,000,000.00$30,000,000,000.00$40,000,000,000.00$50,000,000,000.00$60,000,000,000.00$100,000,000,000.00-Costo Variable Total$7,200,000.00$14,400,000.00$21,600,000.00$28,800,000.00$36,000,000.00$43,200,000.00$72,000,000.00Margen de Contribucin$9,992,800,000.00$19,985,600,000.00$29,978,400,000.00$39,971,200,000.00$49,964,000,000.00$59,956,800,000.00$99,928,000,000.00-Costos Fijos$0.10$0.10$0.10$0.10$0.10$0.10$0.10Ingresos Netos En Operacin$9,992,799,999.90$19,985,599,999.90$29,978,399,999.90$39,971,199,999.90$49,963,999,999.90$59,956,799,999.90$99,927,999,999.90

Graficas

GrficasEMPRESA APrecio de Equilibrio$0.12Unidades VendidasCostos TotalesCostos FijosIngreso TotalCantidad del Punto de Equilibrio$0.000$0.12$0.120.0020000$7,200,000.12$0.12$12,000,000,000.0040000$14,400,000.12$0.12$24,000,000,000.0060000$21,600,000.12$0.12$36,000,000,000.0080000$28,800,000.12$0.12$48,000,000,000.00100000$36,000,000.12$0.12$60,000,000,000.00120000$43,200,000.12$0.12$72,000,000,000.00200000$72,000,000.12$0.12$120,000,000,000.00

EMPRESA BUnidades VendidasCostos TotalesCostos FijosIngreso TotalPrecio de Equilibrio$0.120$0.12$0.120.00Cantidad del Punto de Equilibrio0.000001174220000$7,200,000.12$0.12$2,000,000,000.0040000$14,400,000.12$0.12$4,000,000,000.0060000$21,600,000.12$0.12$6,000,000,000.0080000$28,800,000.12$0.12$8,000,000,000.00100000$36,000,000.12$0.12$10,000,000,000.00120000$43,200,000.12$0.12$12,000,000,000.00200000$72,000,000.12$0.12$20,000,000,000.00

EMPRESA CUnidades VendidasCostos TotalesCostos FijosIngreso Total0$0.10$0.100.00Precio de Equilibrio$0.1020000$7,200,000.10$0.10$10,000,000,000.00Cantidad del Punto de Equilibrio0.000000198140000$14,400,000.10$0.10$20,000,000,000.0060000$21,600,000.10$0.10$30,000,000,000.0080000$28,800,000.10$0.10$40,000,000,000.00100000$36,000,000.10$0.10$50,000,000,000.00120000$43,200,000.10$0.10$60,000,000,000.00200000$72,000,000.10$0.10$100,000,000,000.00

GAO

Grados de Apalancamiento OperativoGAO20000400006000080000100000120000200000EMPRESA A1.000.001.001.001.001.001.00EMPRESA B1.001.001.001.001.001.001.00EMPRESA C1.001.000.001.001.001.001.00

Preguntas

PreguntasA) Calcular Ingreso Neto En Operacin para Ventas de 20,000 , 40,000 ,60,000 ,80,000 ,100,000 ,120,000 & 200,000INGRESO NETO EN OPERACIN20000400006000080000100000120000200000EMPRESA A$11,992,799,999.88$23,985,599,999.88$35,978,399,999.88$47,971,199,999.88$59,963,999,999.88$71,956,799,999.88$119,927,999,999.88EMPRESA B$1,992,799,999.88$3,985,599,999.88$5,978,399,999.88$7,971,199,999.88$9,963,999,999.88$11,956,799,999.88$19,927,999,999.88EMPRESA C$9,992,799,999.90$19,985,599,999.90$29,978,399,999.90$39,971,199,999.90$49,963,999,999.90$59,956,799,999.90$99,927,999,999.90B) Calcular El Punto de EquilibrioPUNTOS DE EQUILIBRIOEMPRESA AEMPRESA BEMPRESA CPrecio De Equilibrio$0.12$0.12$0.10Cantidad del Punto de Equilibrio0.00000019850.00000117420.0000001981

C) Determine el Costo Promedio por unidad de cada empresa a un nivel de 200000 unidadesCOSTO PROMEDIOEMPRESA AEMPRESA BEMPRESA C$360.00$360.00$360.00D) Cul de las 3 empresas soportara bajar su precio de venta a 1.5 por unidad & seguir generando ganancias? Cuntas?Como se puede observar,al menos que se produzcan 200,000 unidades,ninguna empresa generar ganancia alguna. Al producir dichas unidades,la ganancia generada por la Empresa C es mayor a la de la empresa B

E) Qu empresa no soportara bajar su precio de venta a 1.5 por unidad ? Porqu?Es fcil observar que el margen de Contribucin de la empresa A en dicho precio es completamente nulo,esto ocasionar un estancamiento fijo de $20,000 en las perdidas de la empresa.

F) Cul de las 3 empresas obtiene los mejores rendimientos a un nivel de 100000 unidades ?

GAO100000EMPRESA A$1.00EMPRESA B$1.00EMPRESA C$1.00 G) Con la informacin que tiene,haga una descripcin de las caracteristicas de cada una de las empresas H) Conclusin