calculos y eeff
DESCRIPTION
ee.ffTRANSCRIPT
-
PROGRAMA INTERACTIVOPROYECCIONES FINANCIERAS
-
PROGRAMA INTERACTIVOPROYECCIONES FINANCIERAS
-
UNIDAD Gr
250
1
PRODUCTOS COMPETENCIA PRECIOMAYONESAMAYONESA MAGGI VIDRIO 220 1.6 0.007272727MAYONESA MAGGI LIGHT VIDRIO 220 1.5 0.006818182MAYONESA MAGGI SACHET 350 3.35 0.009571429MAYONESA MAGGI SACHET 100 0.6 0.006MAYONESA GUSTADINA SACHET 200 0.95 0.00475MAYONESA GUSTADINA SQUIZ 300 1.65 0.0055MAYONESA GUSTADINA LIGHT SQUIZ 310 1.95 0.006290323MAYONESA KRAFT VIDRIO 227 1.5 0.00660793MAYONESA KRAFT VIDRIO 284 2.1 0.007394366MAYONESA LOS ANDES FCO PLAST 330 1.8 0.005454545S TOMATE GUSTADINA SQUIZ 360 1.3 0.003611111S TOMATE GUSTADINA LIGHT SQUIZ 360 1.5 0.004166667GUSTADINA GOLF SQUIZ 340 1.6 0.004705882SALSA AJI INDIO BRAVO FCO PLAST (PRONACA) 100 0.65 0.0065SALSA CESAR FCO PLAST (TERRAFERTIL) 320 3.5 0.0109375MOSTAZA MAGGI VIDRIO 240 0.92 0.003833333SALSA GUACAMOLE PACOSE SACHET 235 1.62 0.006893617
promedio 0.006253389varianza 3.7078E-006Desviacion Estandar 0.001925577
PRECIO SUGERIDO
DETALLE MEDIDA UNIDADCantidad gr 250PVP Sugerido Unidad 2.05PV Minorista Unidad 1.64PV Mayorista Unidad 1.48Costo de Venta Unidad 0.52Margen Ganancia Unidad 0.96
TAMAO DE UNIDADVECES DE DESVIACION DEL PRECIO
CANTIDAD X UNIDAD
PRECIO X UNIDAD
PRECIO X GRAMO
-
1.8181818181.7045454552.392857143
1.51.1875
1.3751.5725806451.6519823791.8485915491.3636363640.9027777781.0416666671.176470588
1.6252.734375
0.9583333331.723404255
1.5633472340.0009269620.481394232
PRECIO SUGERIDO
600049.2039.3635.4212.4822.94
PRECIO A UNIDAD PROPIA
PRECIO A 250 GR
CAJA (24 Uni)
-
CALCULO DE LA DEMANDAunidades
consumo promedio 24 veces x mesConsumo x porcion 14 grVeces consumo x frasco 18 vecesfrascos necesario x mes 1.33 frascos
Numero de familias Gye 550000% Clase social 15%% Consumo aderezos 96.67%Intencion de compra 82.67%% participacion de mercado 65%% cobertura de mercado 85%
DEMANDA CUBIERTA 36426
DEMANDA CUBIERTA FRASCOS 48447
-
De acuerdo a tus datos, tus ventas mensuales para los tres primeros aos seran:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 $-
$20,000.00 $40,000.00 $60,000.00 $80,000.00
$100,000.00 $120,000.00 $140,000.00 $160,000.00 $180,000.00
Ventas Mensuales 3 Aos
-
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 $-
$20,000.00 $40,000.00 $60,000.00 $80,000.00
$100,000.00 $120,000.00 $140,000.00 $160,000.00 $180,000.00
Ventas Mensuales 3 Aos
-
Sueldos y Salarios:
Selecciona puesto: Sueldo Anual Total Nmina
1 $ 650.00 $ 7,800.00 $ 7,800.00 0.00% $ 650.00
1 $ 450.00 $ 5,400.00 $ 5,400.00 0.00% $ 450.00
5 $ 300.00 $ 3,600.00 $ 18,000.00 0.00% $ 1,500.00
Nmero de puestos
Sueldo Mensual Nominal
Comisin Mensual Nominal por
puesto (% de ventas)
Sueldo base + comisiones
-
PRESUPUESTO MERCADEO MENSUALRubro Detalle COSTO UNI CANT/MES TOTAL MESDIARIOS Fines de semana 1250 4 5000REVISTAS hogar, fucsia, vanidades, otras 2800 2 5600TELEVISION COMERCIALES programas de cocina y familiares 234 88 20592TELEVISION MENCIONES programas de cocina y familiares 20000 1 20000MATERIAL PUBLICITARIO Material POP 15000 1 15000TOTAL MENSUAL DE PUBLICIDAD Y PROMOCION 66192
PRESUPUESTO MERCADEO ANUALRubro AO 1 AO 2 AO 3 AO 4 AO 5DIARIOS 60000 48000 38400 30720 24576REVISTAS 67200 53760 43008 34406 27525TELEVISION COMERCIALES 247104 197683 158147 126517 101214TELEVISION MENCIONES 240000 192000 153600 122880 98304MATERIAL PUBLICITARIO 180000 144000 115200 92160 73728TOTAL DE MERCADEO 794304 635443 508355 406684 325347
-
GASTOS PRE-OPERATIVOSRUBRO VALORSUELDOS 3000MOVILIZACION 200COMUNICACIONES 100SUMINISTROS 250GASTOS VARIOS 500TOTAL DE GASTOS DE ORGANIZACIN 4050
GASTOS LEGALES 2000GASTOS DE INVESTIGACION 2500TOTAL DE GASTOS PREOPERATIVOS 8550
-
PRESUPUESTO DE INVERSION EN ACTIVOS FIJOS
RUBRO CANTIDAD PRECIO TOTALMUEBLES Y ENSERESMATERIALES DE OFICINA 1 250 250TOTAL MUEBLES Y ENSERES 250TOTAL EQUIPOS DE COMPUTO 0TOTAL REDES Y EQUIPOS DE COMUNICACIN 0OTROS ACTIVOS 1 500 500
TOTAL DE ACTIVOS FIJOS 750
-
Renta (m) $ 250.00 Luz $ 250.00 Agua $ 100.00 Comunicaciones $ 300.00 Seguros y fianzas $ 100.00 Seguridad $ 150.00 Papelera y gastos de oficina $ 250.00 Otros $ 200.00
SubTotal gastos fijos $ 1,600.00
Gastos variables de produccin para el primer mes:Costos Unitarios
Naturezzo Aderezo de Yogurt $ 0.52
5%
Total Gastos Variables $ 26,452.06
Gastos de instalacin oficinas corporativas: Necesitas hacer ms gastos de instalacin? OPCIONAL
Primer mes:
Terreno $ - $ - $ - $ - Edificio $ - $ - $ - $ - Comunicaciones $ - $ - $ - $ - Mobiliario y enseres $ 250 $ - $ - $ - Acondicionamiento (m) $ - $ - $ - $ - Equipos de computacion $ - $ - $ - Otros $ 500 $ - $ - $ -
Total gastos de instalacin $ 750 $ - $ - $ -
Total Mensual Gastos fijos
corporativa.
Inventario requerido para el segundo mes, % de ventas estimadas
-
Si tus ingresos son por comisin, puedes saltarte esta hoja y pasar a Financiamiento.
Cuentas por Cobrar:
Determina tus ventas a crdito:
Del total de tus ventas, qu porcentaje se vende a crdito? 50%
Con estos datos, tus ventas a contado son: 50%
Determina el plazo promedio de cobro:
Del total de tus ventas a crdito, a qu plazo estas vendiendo?
Se asume constante para todos los periodos, productos, servicios y puntos de venta.
Inventarios:
Determina el monto de inventarios requeridos para cada periodo:
Tu inventario para el siguiente periodo es del 5.0% de las ventas.Viene de la hoja de "Gastos"Se asume constante para todos los meses, para todos los prductos, para todos los servicios
Cuentas por Pagar:
Determina tus compras a crdito:
Del total de tus compras, qu porcentaje se compra a crdito? 75%
Con estos datos, tus compras a contado son: 25%
Determina el plazo promedio de pago:
Del total de tus compras a crdito, a qu plazo estas pagando?
Se asume constante para todos los periodos.
-
Esta hoja describe tus fuentes de financiamiento:
De acuerdo a tus datos, para el primer mes:
Tu empresa: REQUIERE financiamiento.
El monto de la inversin inicial es: $208,118 Asume un 10% adicional.
Es importante determinar de donde se obtienen los fondos.
Existen dos fuentes principales, deuda y capital. Deuda se divide en deuda de corto plazo y de largo plazo. Capital se divide en capital propio y capital externo.
Determina, del total de la inversin inicial requerida:
Inversin que se debe conseguir: $0 Cunto se financia con capital propio? $250,000 Cunto se financia con capital externo? $0 Cunto se financia con deuda a corto plazo? $0 Cunto se financia con deuda a largo plazo? $0
TOTAL: $250,000
-
Asume un 10% adicional.
-
AMORTIZACION DEUDA Corto PlazoImporte del prstamo 0.00
Nro. de Cuotas 0Comisin de Apertura 0.00Comisin de Mnima 0.00
Tasa de interes 0%T.E.M 0.00%
Tasa Cobrada 0.00%
N de Cuota Deuda Cap. Inters Cuota Amortizacin Cap. Cancel.
-
AMORTIZACION DEUDA Largo PlazoImporte del prstamo 0.00
Nro. de Cuotas 0Comisin de Apertura 0.00Comisin de Mnima 0.00
Tasa de interes 0%T.E.M 0.00%
Tasa Cobrada 0.00%
N de Cuota Deuda Cap. Inters Cuota Amortizacin Cap. Cancel.
-
NATUREZZO TONI Estado de Resultados:
Ingresos:Nacional:
Ingresos por productos $71,508 $72,728 $73,970 $76,722 $79,577 $82,538 $86,441 $90,528Total Ingresos $71,508 $72,728 $73,970 $76,722 $79,577 $82,538 $86,441 $90,528
Costo de Venta $26,452 $26,904 $27,363 $28,381 $29,437 $30,532 $31,976 $33,488
Utilidad Bruta $45,056 $45,825 $46,607 $48,341 $50,140 $52,006 $54,465 $57,040
Gastos operativos:Gastos fijos $1,600 $1,611 $1,622 $1,634 $1,645 $1,657 $1,668 $1,680Sueldos y salarios $3,260 $3,260 $3,260 $3,260 $3,260 $3,260 $3,260 $3,260Comisiones $0 $0 $0 $0 $0 $0 $0 $0Gastos de Promocion y Publicidad $66,192 $66,192 $66,192 $66,192 $66,192 $66,192 $66,192 $66,192Otros Gastos $100 $100 $100 $100 $100 $100 $100 $100
Total gastos operativos $71,152 $71,163 $71,174 $71,186 $71,197 $71,209 $71,220 $71,232
Ebitda -$26,096 -$25,338 -$24,567 -$22,845 -$21,057 -$19,203 -$16,756 -$14,192Depreciacin y Amortizacin -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6Utilidad (perdida) de Operacin -$26,103 -$25,345 -$24,574 -$22,851 -$21,063 -$19,209 -$16,762 -$14,199Gastos financieros corto plazo $0 $0 $0 $0 $0 $0 $0 $0Gastos financieros largo plazo $0 $0 $0 $0 $0 $0 $0 $0
Utilidad antes de impuestos -$26,103 -$25,345 -$24,574 -$22,851 -$21,063 -$19,209 -$16,762 -$14,199ISR (25%) $0 $0 $0 $0 $0 $0 $0 $0PTU (15%) $0 $0 $0 $0 $0 $0 $0 $0
Utilidad (prdida neta) -$26,103 -$25,345 -$24,574 -$22,851 -$21,063 -$19,209 -$16,762 -$14,199Margen de utilidades netas: -36.50% -34.85% -33.22% -29.78% -26.47% -23.27% -19.39% -15.68%
NATUREZZO TONI Balance General
Activo circulanteCaja y bancos $211,560 $177,322 $152,358 $128,736 $106,873 $86,807 $68,948 $53,600Clientes $17,877 $18,182 $18,492 $19,181 $19,894 $20,635 $21,610 $22,632Inventarios. $3,636 $3,698 $3,836 $3,979 $4,127 $4,322 $4,526 $4,740
-
Total activo circulante $233,073 $199,202 $174,686 $151,895 $130,894 $111,764 $95,085 $80,973
Activo FijoTerreno $0 $0 $0 $0 $0 $0 $0 $0Edificio $0 $0 $0 $0 $0 $0 $0 $0Comunicaciones $0 $0 $0 $0 $0 $0 $0 $0Mobiliario y enseres $248 $246 $244 $242 $240 $238 $235 $233Acondicionamiento (m) $0 $0 $0 $0 $0 $0 $0 $0Equipos de computacion $0 $0 $0 $0 $0 $0 $0 $0Otros $496 $492 $488 $483 $479 $475 $471 $467Depreciacin acumulada: -$6 -$12 -$19 -$25 -$31 -$37 -$44 -$50
Total activo fijo $744 $738 $731 $725 $719 $713 $706 $700
Activo total $233,817 $199,940 $175,418 $152,621 $131,613 $112,477 $95,791 $81,673
Pasivo CirculanteProveedores $9,920 $1,387 $1,439 $1,492 $1,548 $1,621 $1,697 $1,778Crditos bancarios $0 $0 $0 $0 $0 $0 $0 $0
Total pasivo circulante $9,920 $1,387 $1,439 $1,492 $1,548 $1,621 $1,697 $1,778
Pasivo largo plazo $0 $0 $0 $0 $0 $0 $0 $0
Pasivo total $9,920 $1,387 $1,439 $1,492 $1,548 $1,621 $1,697 $1,778
Capital ContableCapital social $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000Resultados de ejercicios anteriores $0 -$26,103 -$51,447 -$76,021 -$98,872 -$119,935 -$139,144 -$155,906Resultado del ejercicio -$26,103 -$25,345 -$24,574 -$22,851 -$21,063 -$19,209 -$16,762 -$14,199
Total Capital Contable $223,897 $198,553 $173,979 $151,128 $130,065 $110,856 $94,094 $79,895
Pasivo + Capital $233,817 $199,940 $175,418 $152,621 $131,613 $112,477 $95,791 $81,673
NATUREZZO TONI Flujo de Efectivo
Utilidad neta -$26,103 -$25,345 -$24,574 -$22,851 -$21,063 -$19,209 -$16,762 -$14,199+ depreciacin y amortizacin -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6
-
Generacin bruta de efectivo -$26,096 -$25,338 -$24,567 -$22,845 -$21,057 -$19,203 -$16,756 -$14,192
Usos OperativosFinanciamiento a cuentas por cobrar -$17,877 -$305 -$310 -$688 -$714 -$740 -$976 -$1,022Financiamiento a inventarios -$3,636 -$62 -$138 -$143 -$148 -$195 -$204 -$214
Total usos operativos -$21,513 -$367 -$448 -$831 -$862 -$935 -$1,180 -$1,236
Fuentes OperativasFinanciamiento (amort.) proveedores $9,920 -$8,533 $52 $54 $56 $73 $77 $80
Total fuentes operativas $9,920 -$8,533 $52 $54 $56 $73 $77 $80
Generacin Neta Operativa -$37,690 -$34,238 -$24,964 -$23,622 -$21,863 -$20,065 -$17,859 -$15,348
Fuentes de Instituciones de CrditoFinanc. (amort.) crditos bancarios corto plazo $0 $0 $0 $0 $0 $0 $0 $0Financ. (amort.) crditos bancarios largo plazo $0 $0 $0 $0 $0 $0 $0 $0
Financiamiento neto con costo $0 $0 $0 $0 $0 $0 $0 $0
Usos no operativosVenta (inversin) en activos fijos -$750 $0 $0 $0 $0 $0 $0 $0Venta (inversin) en activos diferidos $0 $0 $0 $0 $0 $0 $0 $0Pago de dividendos $0 $0 $0 $0 $0 $0 $0 $0
Total de usos no operativos -$750 $0 $0 $0 $0 $0 $0 $0
Fuentes no operativas Aportaciones (retiros) de capital $250,000 $0 $0 $0 $0 $0 $0 $0
Total fuentes no operativas $250,000 $0 $0 $0 $0 $0 $0 $0
Generacin de flujo no operativa $249,250 $0 $0 $0 $0 $0 $0 $0
Generacin Neta de Flujo de Efectivo $211,560 -$34,238 -$24,964 -$23,622 -$21,863 -$20,065 -$17,859 -$15,348
Caja inicial $0 $211,560 $177,322 $152,358 $128,736 $106,873 $86,807 $68,948Caja final $211,560 $177,322 $152,358 $128,736 $106,873 $86,807 $68,948 $53,600
Razones Financieras
ActividadVentas netas a activos fijos 9614.17% 9860.81% 10114.50% 10580.93% 11069.68% 11581.87% 12236.35% 12928.81%
-
Ventas netas a capital contable 31.94% 36.63% 42.52% 50.77% 61.18% 74.46% 91.87% 113.31%Gastos a ventas netas 99.50% 97.85% 96.22% 92.78% 89.47% 86.27% 82.39% 78.69%Costo de Ventas a ventas netas 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99%
LiquidezActivo circulante a pasivo a corto plazo 2349.64% 14362.76% 12143.29% 10180.17% 8457.90% 6895.76% 5601.82% 4555.05%Activo total a pasivo total 2357.14% 14415.94% 12194.12% 10228.77% 8504.35% 6939.73% 5643.44% 4594.44%Das clientes 15 15 15 15 15 15 15 15Das proveedores 15 15 15 15 15 15 15 15
ApalancamientoPasivo total a capital contable 4.43% 0.70% 0.83% 0.99% 1.19% 1.46% 1.80% 2.22%Productividad
Utilidad de operacin a ventas netas -36.49% -34.84% -33.21% -29.78% -26.46% -23.27% -19.38% -15.68%Utilidad neta a ventas netas -36.50% -34.85% -33.22% -29.78% -26.47% -23.27% -19.39% -15.68%
CrecimientoEn ventas netas N.A.En utilidad de operacin N.A.En utilidad neta N.A.
Integracin de activos fijos
1. Valor de activos fijosTerreno $0 $0 $0 $0 $0 $0 $0 $0Edificio $0 $0 $0 $0 $0 $0 $0 $0Comunicaciones $0 $0 $0 $0 $0 $0 $0 $0Mobiliario y enseres $248 $246 $244 $242 $240 $238 $235 $233Acondicionamiento (m) $0 $0 $0 $0 $0 $0 $0 $0Equipos de computacion $0 $0 $0 $0 $0 $0 $0 $0Otros $496 $492 $488 $483 $479 $475 $471 $467Propiedades, planta y equipo $744 $738 $731 $725 $719 $713 $706 $700
2. Inversin ($) en activos fijosTerreno $0 $0 $0 $0 $0 $0 $0 $0Edificio $0 $0 $0 $0 $0 $0 $0 $0Comunicaciones $0 $0 $0 $0 $0 $0 $0 $0Mobiliario y enseres $250 $0 $0 $0 $0 $0 $0 $0Acondicionamiento (m) $0 $0 $0 $0 $0 $0 $0 $0Equipos de Computacion $0 $0 $0 $0 $0 $0 $0 $0Otros $500 $0 $0 $0 $0 $0 $0 $0Inversin total $750 $0 $0 $0 $0 $0 $0 $0
-
Depreciacin activos fijos ($)Terreno $0 $0 $0 $0 $0 $0 $0 $0Edificio $0 $0 $0 $0 $0 $0 $0 $0Comunicaciones $0 $0 $0 $0 $0 $0 $0 $0Mobiliario y enseres -$2 -$2 -$2 -$2 -$2 -$2 -$2 -$2Acondicionamiento (m) $0 $0 $0 $0 $0 $0 $0 $0Equipos de Computacion $0 $0 $0 $0 $0 $0 $0 $0Otros -$4 -$4 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15Depreciacin acumulada -$6 -$12.45 -$18.68 -$24.90 -$31.13 -$37.35 -$43.58 -$49.80Depreciacin Mensual -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6
Depreciacin (%)Terreno 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%Edificio 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%Comunicaciones 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78%Mobiliario y enseres 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%Acondicionamiento (m) 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%Equipos de Computacion 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01%Otros 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%
Inflacin mensual 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70%
-
AO 1
$94,808 $99,290 $103,985 $108,901 $1,040,995 $111,857 $114,892 $118,011 $120,025 $122,074 $124,158 $126,277$94,808 $99,290 $103,985 $108,901 $1,040,995 $111,857 $114,892 $118,011 $120,025 $122,074 $124,158 $126,277
$35,071 $36,729 $38,466 $40,285 $385,084 $41,378 $42,501 $43,654 $44,399 $45,157 $45,928 $46,712
$59,737 $62,561 $65,519 $68,616 $655,912 $70,479 $72,392 $74,356 $75,625 $76,916 $78,229 $79,565
$1,692 $1,704 $1,716 $1,728 $19,957 $1,740 $1,752 $1,764 $1,776 $1,789 $1,801 $1,814$3,260 $3,260 $3,260 $3,260 $39,120 $3,545 $3,545 $3,545 $3,545 $3,545 $3,545 $3,545
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$66,192 $66,192 $66,192 $66,192 $794,304 $52,954 $52,954 $52,954 $52,954 $52,954 $52,954 $52,954
$100 $100 $100 $100 $1,200 $100 $100 $100 $100 $100 $100 $100$71,244 $71,256 $71,268 $71,280 $854,581 $58,338 $58,350 $58,362 $58,375 $58,387 $58,400 $58,412
-$11,507 -$8,695 -$5,749 -$2,663 -$198,669 $12,141 $14,041 $15,994 $17,251 $18,529 $19,830 $21,152-$6 -$6 -$6 -$6 -$75 -$6 -$6 -$6 -$6 -$6 -$6 -$6
-$11,514 -$8,701 -$5,755 -$2,669 -$198,744 $12,135 $14,035 $15,988 $17,245 $18,523 $19,823 $21,146$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$11,514 -$8,701 -$5,755 -$2,669 -$198,744 $12,135 $14,035 $15,988 $17,245 $18,523 $19,823 $21,146$0 $0 $0 $0 $0 $3,034 $3,509 $3,997 $4,311 $4,631 $4,956 $5,287$0 $0 $0 $0 $0 $1,820 $2,105 $2,398 $2,587 $2,778 $2,974 $3,172
-$11,514 -$8,701 -$5,755 -$2,669 -$198,744 $7,281 $8,421 $9,593 $10,347 $11,114 $11,894 $12,688-12.14% -8.76% -5.53% -2.45% -19.09% 6.51% 7.33% 8.13% 8.62% 9.10% 9.58% 10.05%
$40,883 $30,921 $23,845 $19,860 $19,860 $26,313 $33,884 $42,641 $52,426 $62,969 $74,282 $86,379$23,702 $24,823 $25,996 $27,225 $27,225 $27,964 $28,723 $29,503 $30,006 $30,518 $31,039 $31,569
$4,965 $5,199 $5,445 $5,593 $5,593 $5,745 $5,901 $6,001 $6,104 $6,208 $6,314 $6,422
-
$69,549 $60,943 $55,286 $52,678 $52,678 $60,022 $68,508 $78,145 $88,536 $99,695 $111,635 $124,369
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$231 $229 $227 $225 $225 $223 $221 $219 $217 $215 $213 $211$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$463 $459 $454 $450 $450 $446 $442 $438 $434 $429 $425 $421-$56 -$62 -$68 -$75 -$75 -$81 -$87 -$93 -$100 -$106 -$112 -$118$694 $688 $682 $675 $675 $669 $663 $657 $650 $644 $638 $632
$70,243 $61,630 $55,967 $53,354 $53,354 $60,691 $69,171 $78,801 $89,186 $100,339 $112,273 $125,001
$1,862 $1,950 $2,042 $2,097 $2,097 $2,154 $2,213 $2,250 $2,289 $2,328 $2,368 $2,408$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$1,862 $1,950 $2,042 $2,097 $2,097 $2,154 $2,213 $2,250 $2,289 $2,328 $2,368 $2,408
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$1,862 $1,950 $2,042 $2,097 $2,097 $2,154 $2,213 $2,250 $2,289 $2,328 $2,368 $2,408
$250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000-$170,105 -$181,618 -$190,319 -$196,074 -$196,074 -$198,744 -$191,463 -$183,042 -$173,449 -$163,103 -$151,989 -$140,095
-$11,514 -$8,701 -$5,755 -$2,669 -$2,669 $7,281 $8,421 $9,593 $10,347 $11,114 $11,894 $12,688$68,382 $59,681 $53,926 $51,256 $51,256 $58,537 $66,958 $76,551 $86,897 $98,011 $109,905 $122,593
$70,243 $61,630 $55,967 $53,354 $53,354 $60,691 $69,171 $78,801 $89,186 $100,339 $112,273 $125,001
-$11,514 -$8,701 -$5,755 -$2,669 -$198,744 $7,281 $8,421 $9,593 $10,347 $11,114 $11,894 $12,688-$6 -$6 -$6 -$6 -$75 -$6 -$6 -$6 -$6 -$6 -$6 -$6
-
-$11,507 -$8,695 -$5,749 -$2,663 -$198,669 $7,287 $8,427 $9,599 $10,353 $11,120 $11,900 $12,694
-$1,070 -$1,121 -$1,174 -$1,229 $0 -$739 -$759 -$780 -$504 -$512 -$521 -$530-$224 -$235 -$246 -$148 $0 -$152 -$156 -$101 -$102 -$104 -$106 -$108
-$1,294 -$1,355 -$1,419 -$1,377 $0 -$891 -$915 -$880 -$606 -$616 -$627 -$638
$84 $88 $92 $55 $0 $57 $58 $38 $38 $39 $40 $40$84 $88 $92 $55 $0 $57 $58 $38 $38 $39 $40 $40
-$12,717 -$9,962 -$7,076 -$3,985 -$198,669 $6,453 $7,571 $8,756 $9,785 $10,543 $11,313 $12,097
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 -$750 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 -$750 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $250,000 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $250,000 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $249,250 $0 $0 $0 $0 $0 $0 $0
-$12,717 -$9,962 -$7,076 -$3,985 $50,581 $6,453 $7,571 $8,756 $9,785 $10,543 $11,313 $12,097
$53,600 $40,883 $30,921 $23,845 $19,860 $19,860 $26,313 $33,884 $42,641 $52,426 $62,969 $74,282$40,883 $30,921 $23,845 $19,860 $70,441 $26,313 $33,884 $42,641 $52,426 $62,969 $74,282 $86,379
13661.54% 14436.96% 15257.64% 16126.31% 154153.01% 16718.09% 17333.09% 17972.29% 18454.03% 18950.41% 19461.97% 19989.23%
-
138.64% 166.37% 192.83% 212.46% 2030.96% 191.09% 171.59% 154.16% 138.12% 124.55% 112.97% 103.00%75.15% 71.77% 68.54% 65.45% 82.09% 52.15% 50.79% 49.46% 48.64% 47.83% 47.04% 46.26%36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99%
3735.82% 3125.72% 2707.58% 2511.70% 2511.70% 2786.24% 3096.13% 3472.37% 3868.08% 4282.52% 4714.93% 5164.61%3773.09% 3161.00% 2740.96% 2543.90% 2543.90% 2817.30% 3126.09% 3501.55% 3896.50% 4310.19% 4741.87% 5190.84%
15 15 15 15 15 15 15 15 15 15 15 1515 15 15 15 15 15 15 15 15 15 15 15
2.72% 3.27% 3.79% 4.09% 4.09% 3.68% 3.30% 2.94% 2.63% 2.38% 2.15% 1.96%
-12.14% -8.76% -5.53% -2.45% -19.08% 10.85% 12.22% 13.55% 14.37% 15.18% 15.97% 16.75%-12.14% -8.76% -5.53% -2.45% -19.09% 6.51% 7.33% 8.13% 8.62% 9.10% 9.58% 10.05%
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$231 $229 $227 $225 $225 $223 $221 $219 $217 $215 $213 $211$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$463 $459 $454 $450 $450 $446 $442 $438 $434 $429 $425 $421$694 $688 $682 $675 $675 $669 $663 $657 $650 $644 $638 $632
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $250 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $500 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $750 $0 $0 $0 $0 $0 $0 $0
-
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$2 -$2 -$2 -$2 -$25 -$2 -$2 -$2 -$2 -$2 -$2 -$2$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$4.15 -$4.15 -$4.15 -$4.15 -$50 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15-$56.03 -$62.25 -$68.48 -$74.70 -$74.70 -$80.93 -$87.15 -$93.38 -$99.60 -$105.83 -$112.05 -$118.28
-$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78%0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01%0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%
0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70%
-
AO 2
$128,433 $130,625 $132,855 $135,122 $137,429 $1,501,756 $139,775 $142,161 $144,588 $147,056 $149,566$128,433 $130,625 $132,855 $135,122 $137,429 $1,501,756 $139,775 $142,161 $144,588 $147,056 $149,566
$47,510 $48,321 $49,145 $49,984 $50,838 $555,528 $51,705 $52,588 $53,486 $54,399 $55,327
$80,923 $82,304 $83,709 $85,138 $86,591 $946,229 $88,070 $89,573 $91,102 $92,657 $94,239
$1,827 $1,840 $1,852 $1,865 $1,878 $21,699 $1,892 $1,905 $1,918 $1,932 $1,945$3,545 $3,545 $3,545 $3,545 $3,545 $42,536 $3,854 $3,854 $3,854 $3,854 $3,854
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$52,954 $52,954 $52,954 $52,954 $52,954 $635,443 $42,363 $42,363 $42,363 $42,363 $42,363
$100 $100 $100 $100 $100 $1,200 $100 $100 $100 $100 $100$58,425 $58,438 $58,451 $58,464 $58,477 $700,878 $48,209 $48,222 $48,235 $48,249 $48,262
$22,498 $23,867 $25,259 $26,675 $28,115 $245,351 $39,861 $41,351 $42,867 $44,408 $45,977-$6 -$6 -$6 -$6 -$6 -$75 -$6 -$6 -$6 -$6 -$6
$22,492 $23,860 $25,252 $26,668 $28,109 $245,276 $39,855 $41,345 $42,861 $44,402 $45,970$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$22,492 $23,860 $25,252 $26,668 $28,109 $245,276 $39,855 $41,345 $42,861 $44,402 $45,970$5,623 $5,965 $6,313 $6,667 $7,027 $61,319 $9,964 $10,336 $10,715 $11,101 $11,493$3,374 $3,579 $3,788 $4,000 $4,216 $36,791 $5,978 $6,202 $6,429 $6,660 $6,896
$13,495 $14,316 $15,151 $16,001 $16,865 $147,166 $23,913 $24,807 $25,716 $26,641 $27,58210.51% 10.96% 11.40% 11.84% 12.27% 9.80% 17.11% 17.45% 17.79% 18.12% 18.44%
$99,272 $112,977 $127,506 $142,875 $159,096 $159,096 $182,354 $206,495 $231,534 $257,486 $284,367$32,108 $32,656 $33,214 $33,781 $34,357 $34,357 $34,944 $35,540 $36,147 $36,764 $37,391
$6,531 $6,643 $6,756 $6,871 $6,989 $6,989 $7,108 $7,229 $7,353 $7,478 $7,606
-
$137,912 $152,276 $167,476 $183,527 $200,442 $200,442 $224,406 $249,264 $275,033 $301,728 $329,364
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$209 $206 $204 $202 $200 $200 $198 $196 $194 $192 $190$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$417 $413 $409 $405 $400 $400 $396 $392 $388 $384 $380-$125 -$131 -$137 -$143 -$149 -$149 -$156 -$162 -$168 -$174 -$181$626 $619 $613 $607 $601 $601 $594 $588 $582 $576 $569
$138,537 $152,895 $168,089 $184,133 $201,043 $201,043 $225,000 $249,853 $275,615 $302,304 $329,934
$2,449 $2,491 $2,534 $2,577 $2,621 $2,621 $2,666 $2,711 $2,757 $2,804 $2,852$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$2,449 $2,491 $2,534 $2,577 $2,621 $2,621 $2,666 $2,711 $2,757 $2,804 $2,852
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$2,449 $2,491 $2,534 $2,577 $2,621 $2,621 $2,666 $2,711 $2,757 $2,804 $2,852
$250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000-$127,407 -$113,912 -$99,596 -$84,444 -$68,443 -$68,443 -$51,578 -$27,665 -$2,858 $22,858 $49,499
$13,495 $14,316 $15,151 $16,001 $16,865 $16,865 $23,913 $24,807 $25,716 $26,641 $27,582$136,088 $150,404 $165,556 $181,557 $198,422 $198,422 $222,335 $247,142 $272,858 $299,499 $327,081
$138,537 $152,895 $168,089 $184,133 $201,043 $201,043 $225,000 $249,853 $275,615 $302,304 $329,934
$13,495 $14,316 $15,151 $16,001 $16,865 $147,166 $23,913 $24,807 $25,716 $26,641 $27,582-$6 -$6 -$6 -$6 -$6 -$75 -$6 -$6 -$6 -$6 -$6
-
$13,501 $14,322 $15,158 $16,007 $16,871 $147,240 $23,919 $24,813 $25,723 $26,648 $27,588
-$539 -$548 -$557 -$567 -$577 $0 -$586 -$596 -$607 -$617 -$628-$110 -$111 -$113 -$115 -$117 $0 -$119 -$121 -$123 -$126 -$128-$649 -$660 -$671 -$682 -$694 $0 -$706 -$718 -$730 -$743 -$755
$41 $42 $43 $43 $44 $0 $45 $46 $46 $47 $48$41 $42 $43 $43 $44 $0 $45 $46 $46 $47 $48
$12,894 $13,705 $14,529 $15,368 $16,221 $147,240 $23,258 $24,141 $25,039 $25,952 $26,881
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$12,894 $13,705 $14,529 $15,368 $16,221 $147,240 $23,258 $24,141 $25,039 $25,952 $26,881
$86,379 $99,272 $112,977 $127,506 $142,875 $159,096 $159,096 $182,354 $206,495 $231,534 $257,486$99,272 $112,977 $127,506 $142,875 $159,096 $306,336 $182,354 $206,495 $231,534 $257,486 $284,367
20532.78% 21093.19% 21671.09% 22267.12% 22881.95% 250042.69% 23516.29% 24170.85% 24846.43% 25543.80% 26263.82%
-
94.37% 86.85% 80.25% 74.42% 69.26% 756.85% 62.87% 57.52% 52.99% 49.10% 45.73%45.49% 44.74% 44.00% 43.27% 42.55% 46.67% 34.49% 33.92% 33.36% 32.81% 32.27%36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99%
5630.86% 6112.99% 6610.35% 7122.29% 7648.18% 7648.18% 8418.85% 9194.50% 9974.75% 10759.24% 11547.60%5656.40% 6137.85% 6634.54% 7145.84% 7671.10% 7671.10% 8441.15% 9216.20% 9995.86% 10779.77% 11567.56%
15 15 15 15 15 15 15 15 15 15 1515 15 15 15 15 15 15 15 15 15 15
1.80% 1.66% 1.53% 1.42% 1.32% 1.32% 1.20% 1.10% 1.01% 0.94% 0.87%
17.52% 18.27% 19.01% 19.74% 20.46% 16.34% 28.52% 29.09% 29.65% 30.20% 30.74%10.51% 10.96% 11.40% 11.84% 12.27% 9.80% 17.11% 17.45% 17.79% 18.12% 18.44%
N.A. $0 $0 $0 $0 $0 $0 $0 $0N.A. -$3 -$4 -$6 -$16 $2 $2 $2 $2N.A. -$2 -$3 -$4 -$10 $2 $2 $2 $2
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$209 $206 $204 $202 $200 $200 $198 $196 $194 $192 $190$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$417 $413 $409 $405 $400 $400 $396 $392 $388 $384 $380$626 $619 $613 $607 $601 $601 $594 $588 $582 $576 $569
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$2 -$2 -$2 -$2 -$2 -$25 -$2 -$2 -$2 -$2 -$2$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$50 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15-$124.50 -$130.73 -$136.95 -$143.18 -$149.40 -$149.40 -$155.63 -$161.85 -$168.08 -$174.30 -$180.53
-$6 -$6 -$6 -$6 -$6 -$12 -$6 -$6 -$6 -$6 -$6
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78%0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01%0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%
0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70%
-
AO 3
$152,119 $154,716 $157,357 $160,043 $162,775 $165,553 $168,379 $1,844,086 $169,081 $169,785 $170,493$152,119 $154,716 $157,357 $160,043 $162,775 $165,553 $168,379 $1,844,086 $169,081 $169,785 $170,493
$56,272 $57,232 $58,209 $59,203 $60,213 $61,241 $62,287 $682,162 $62,546 $62,807 $63,069
$95,847 $97,483 $99,147 $100,840 $102,561 $104,312 $106,093 $1,161,924 $106,535 $106,979 $107,424
$1,959 $1,972 $1,986 $2,000 $2,014 $2,028 $2,042 $23,594 $2,057 $2,071 $2,086$3,854 $3,854 $3,854 $3,854 $3,854 $3,854 $3,854 $46,249 $4,191 $4,191 $4,191
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$42,363 $42,363 $42,363 $42,363 $42,363 $42,363 $42,363 $508,355 $33,890 $33,890 $33,890
$100 $100 $100 $100 $100 $100 $100 $1,200 $100 $100 $100$48,276 $48,289 $48,303 $48,317 $48,331 $48,345 $48,359 $579,398 $40,238 $40,252 $40,267
$47,572 $49,194 $50,844 $52,523 $54,230 $55,967 $57,733 $582,527 $66,297 $66,727 $67,158-$6 -$6 -$6 -$6 -$6 -$6 -$6 -$75 -$6 -$6 -$6
$47,565 $49,188 $50,838 $52,517 $54,224 $55,961 $57,727 $582,452 $66,291 $66,720 $67,152$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$47,565 $49,188 $50,838 $52,517 $54,224 $55,961 $57,727 $582,452 $66,291 $66,720 $67,152$11,891 $12,297 $12,710 $13,129 $13,556 $13,990 $14,432 $145,613 $16,573 $16,680 $16,788
$7,135 $7,378 $7,626 $7,877 $8,134 $8,394 $8,659 $87,368 $9,944 $10,008 $10,073$28,539 $29,513 $30,503 $31,510 $32,534 $33,576 $34,636 $349,471 $39,774 $40,032 $40,29118.76% 19.08% 19.38% 19.69% 19.99% 20.28% 20.57% 18.95% 23.52% 23.58% 23.63%
$312,193 $340,980 $370,745 $401,504 $433,275 $466,074 $499,988 $499,988 $539,572 $579,412 $619,510$38,030 $38,679 $39,339 $40,011 $40,694 $41,388 $42,095 $42,095 $42,270 $42,446 $42,623
$7,736 $7,868 $8,002 $8,139 $8,278 $8,419 $8,454 $8,454 $8,489 $8,525 $8,560
-
$357,958 $387,527 $418,086 $449,654 $482,246 $515,882 $550,537 $550,537 $590,331 $630,383 $670,693
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$188 $186 $184 $182 $179 $177 $175 $175 $173 $171 $169$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$376 $371 $367 $363 $359 $355 $351 $351 $346 $342 $338-$187 -$193 -$199 -$205 -$212 -$218 -$224 -$224 -$230 -$237 -$243$563 $557 $551 $545 $538 $532 $526 $526 $520 $513 $507
$358,522 $388,084 $418,637 $450,198 $482,785 $516,414 $551,063 $551,063 $590,851 $630,896 $671,201
$2,901 $2,950 $3,001 $3,052 $3,104 $3,157 $3,170 $3,170 $3,183 $3,197 $3,210$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$2,901 $2,950 $3,001 $3,052 $3,104 $3,157 $3,170 $3,170 $3,183 $3,197 $3,210
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$2,901 $2,950 $3,001 $3,052 $3,104 $3,157 $3,170 $3,170 $3,183 $3,197 $3,210
$250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000$77,081 $105,621 $135,133 $165,636 $197,146 $229,680 $263,257 $263,257 $297,893 $337,667 $377,700$28,539 $29,513 $30,503 $31,510 $32,534 $33,576 $34,636 $34,636 $39,774 $40,032 $40,291
$355,621 $385,133 $415,636 $447,146 $479,680 $513,257 $547,893 $547,893 $587,667 $627,700 $667,991
$358,522 $388,084 $418,637 $450,198 $482,785 $516,414 $551,063 $551,063 $590,851 $630,896 $671,201
$28,539 $29,513 $30,503 $31,510 $32,534 $33,576 $34,636 $349,471 $39,774 $40,032 $40,291-$6 -$6 -$6 -$6 -$6 -$6 -$6 -$75 -$6 -$6 -$6
-
$28,545 $29,519 $30,509 $31,516 $32,541 $33,583 $34,642 $349,546 $39,781 $40,038 $40,297
-$638 -$649 -$660 -$672 -$683 -$695 -$706 $0 -$175 -$176 -$177-$130 -$132 -$134 -$137 -$139 -$141 -$35 $0 -$35 -$35 -$36-$768 -$781 -$795 -$808 -$822 -$836 -$742 $0 -$211 -$212 -$212
$49 $50 $50 $51 $52 $53 $13 $0 $13 $13 $13$49 $50 $50 $51 $52 $53 $13 $0 $13 $13 $13
$27,826 $28,787 $29,765 $30,759 $31,771 $32,800 $33,914 $349,546 $39,583 $39,840 $40,098
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$27,826 $28,787 $29,765 $30,759 $31,771 $32,800 $33,914 $349,546 $39,583 $39,840 $40,098
$284,367 $312,193 $340,980 $370,745 $401,504 $433,275 $466,074 $499,988 $499,988 $539,572 $579,412$312,193 $340,980 $370,745 $401,504 $433,275 $466,074 $499,988 $849,534 $539,572 $579,412 $619,510
27007.37% 27775.36% 28568.75% 29388.56% 30235.85% 31111.72% 32017.35% 350653.40% 32535.89% 33067.57% 33612.88%
-
42.78% 40.17% 37.86% 35.79% 33.93% 32.26% 30.73% 336.58% 28.77% 27.05% 25.52%31.74% 31.21% 30.70% 30.19% 29.69% 29.20% 28.72% 31.42% 23.80% 23.71% 23.62%36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99%
12339.48% 13134.55% 13932.48% 14732.96% 15535.67% 16340.31% 17365.65% 17365.65% 18543.60% 19719.54% 20893.46%12358.90% 13153.43% 13950.84% 14750.80% 15553.01% 16357.17% 17382.24% 17382.24% 18559.92% 19735.60% 20909.27%
15 15 15 15 15 15 15 15 15 15 1515 15 15 15 15 15 15 15 15 15 15
0.82% 0.77% 0.72% 0.68% 0.65% 0.62% 0.58% 0.58% 0.54% 0.51% 0.48%
31.27% 31.80% 32.31% 32.82% 33.32% 33.81% 34.29% 31.59% 39.21% 39.30% 39.39%18.76% 19.08% 19.38% 19.69% 19.99% 20.28% 20.57% 18.95% 23.52% 23.58% 23.63%
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0$2 $1 $1 $1 $1 $1 $1 $1 $1 $1$2 $1 $1 $1 $1 $1 $1 $1 $1 $1
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$188 $186 $184 $182 $179 $177 $175 $175 $173 $171 $169$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$376 $371 $367 $363 $359 $355 $351 $351 $346 $342 $338$563 $557 $551 $545 $538 $532 $526 $526 $520 $513 $507
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$2 -$2 -$2 -$2 -$2 -$2 -$2 -$25 -$2 -$2 -$2$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$50 -$4.15 -$4.15 -$4.15-$186.75 -$192.98 -$199.20 -$205.43 -$211.65 -$217.88 -$224.10 -$224.10 -$230.33 -$236.55 -$242.78
-$6 -$6 -$6 -$6 -$6 -$6 -$6 -$19 -$6 -$6 -$6
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78%0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01%0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%
0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70%
-
AO 4
$171,203 $171,917 $172,633 $173,353 $174,075 $174,800 $175,529 $176,260 $176,995 $2,076,123 $177,732$171,203 $171,917 $172,633 $173,353 $174,075 $174,800 $175,529 $176,260 $176,995 $2,076,123 $177,732
$63,331 $63,595 $63,860 $64,126 $64,394 $64,662 $64,931 $65,202 $65,474 $767,997 $65,746
$107,872 $108,322 $108,773 $109,226 $109,681 $110,138 $110,597 $111,058 $111,521 $1,308,127 $111,986
$2,100 $2,115 $2,130 $2,145 $2,160 $2,175 $2,190 $2,205 $2,221 $25,654 $2,236$4,191 $4,191 $4,191 $4,191 $4,191 $4,191 $4,191 $4,191 $4,191 $50,287 $4,557
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$33,890 $33,890 $33,890 $33,890 $33,890 $33,890 $33,890 $33,890 $33,890 $406,684 $27,112
$100 $100 $100 $100 $100 $100 $100 $100 $100 $1,200 $100$40,281 $40,296 $40,311 $40,326 $40,341 $40,356 $40,371 $40,386 $40,402 $483,825 $34,005
$67,591 $68,026 $68,462 $68,901 $69,341 $69,783 $70,226 $70,672 $71,119 $824,302 $77,981-$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$75 -$6
$67,585 $68,019 $68,456 $68,894 $69,335 $69,776 $70,220 $70,666 $71,113 $824,227 $77,974$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$67,585 $68,019 $68,456 $68,894 $69,335 $69,776 $70,220 $70,666 $71,113 $824,227 $77,974$16,896 $17,005 $17,114 $17,224 $17,334 $17,444 $17,555 $17,666 $17,778 $206,057 $19,494$10,138 $10,203 $10,268 $10,334 $10,400 $10,466 $10,533 $10,600 $10,667 $123,634 $11,696
$40,551 $40,812 $41,074 $41,337 $41,601 $41,866 $42,132 $42,399 $42,668 $494,536 $46,78523.69% 23.74% 23.79% 23.85% 23.90% 23.95% 24.00% 24.06% 24.11% 23.82% 26.32%
$659,867 $700,484 $741,363 $782,503 $823,907 $865,575 $907,508 $949,708 $992,175 $992,175 $1,038,758$42,801 $42,979 $43,158 $43,338 $43,519 $43,700 $43,882 $44,065 $44,249 $44,249 $44,433
$8,596 $8,632 $8,668 $8,704 $8,740 $8,776 $8,813 $8,850 $8,887 $8,887 $8,924
-
$711,264 $752,095 $793,188 $834,545 $876,165 $918,051 $960,203 $1,002,623 $1,045,310 $1,045,310 $1,092,115
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$167 $165 $163 $161 $159 $157 $155 $152 $150 $150 $148$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$334 $330 $326 $322 $317 $313 $309 $305 $301 $301 $297-$249 -$255 -$261 -$268 -$274 -$280 -$286 -$293 -$299 -$299 -$305$501 $495 $489 $482 $476 $470 $464 $457 $451 $451 $445
$711,765 $752,590 $793,677 $835,027 $876,641 $918,521 $960,667 $1,003,080 $1,045,762 $1,045,762 $1,092,560
$3,223 $3,237 $3,250 $3,264 $3,278 $3,291 $3,305 $3,319 $3,332 $3,332 $3,346$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$3,223 $3,237 $3,250 $3,264 $3,278 $3,291 $3,305 $3,319 $3,332 $3,332 $3,346
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$3,223 $3,237 $3,250 $3,264 $3,278 $3,291 $3,305 $3,319 $3,332 $3,332 $3,346
$250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000$417,991 $458,541 $499,353 $540,427 $581,763 $623,364 $665,230 $707,362 $749,761 $749,761 $792,429
$40,551 $40,812 $41,074 $41,337 $41,601 $41,866 $42,132 $42,399 $42,668 $42,668 $46,785$708,541 $749,353 $790,427 $831,763 $873,364 $915,230 $957,362 $999,761 $1,042,429 $1,042,429 $1,089,214
$711,765 $752,590 $793,677 $835,027 $876,641 $918,521 $960,667 $1,003,080 $1,045,762 $1,045,762 $1,092,560
$40,551 $40,812 $41,074 $41,337 $41,601 $41,866 $42,132 $42,399 $42,668 $494,536 $46,785-$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$75 -$6
-
$40,557 $40,818 $41,080 $41,343 $41,607 $41,872 $42,138 $42,406 $42,674 $494,611 $46,791
-$178 -$178 -$179 -$180 -$181 -$181 -$182 -$183 -$184 $0 -$184-$36 -$36 -$36 -$36 -$36 -$36 -$37 -$37 -$37 $0 -$37
-$213 -$214 -$215 -$216 -$217 -$218 -$219 -$220 -$220 $0 -$221
$13 $13 $13 $14 $14 $14 $14 $14 $14 $0 $14$13 $13 $13 $14 $14 $14 $14 $14 $14 $0 $14
$40,357 $40,617 $40,878 $41,140 $41,404 $41,668 $41,933 $42,200 $42,467 $494,611 $46,583
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$40,357 $40,617 $40,878 $41,140 $41,404 $41,668 $41,933 $42,200 $42,467 $494,611 $46,583
$619,510 $659,867 $700,484 $741,363 $782,503 $823,907 $865,575 $907,508 $949,708 $992,175 $992,175$659,867 $700,484 $741,363 $782,503 $823,907 $865,575 $907,508 $949,708 $992,175 $1,486,786 $1,038,758
34172.33% 34746.46% 35335.82% 35941.02% 36562.67% 37201.44% 37858.01% 38533.11% 39227.51% 460133.74% 39942.04%
-
24.16% 22.94% 21.84% 20.84% 19.93% 19.10% 18.33% 17.63% 16.98% 199.16% 16.32%23.53% 23.44% 23.35% 23.26% 23.17% 23.09% 23.00% 22.91% 22.83% 23.30% 19.13%36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99%
22065.37% 23235.25% 24403.10% 25568.92% 26732.70% 27894.44% 29054.13% 30211.78% 31367.38% 31367.38% 32635.88%22080.91% 23250.53% 24418.13% 25583.69% 26747.22% 27908.71% 29068.16% 30225.56% 31380.92% 31380.92% 32649.18%
15 15 15 15 15 15 15 15 15 15 1515 15 15 15 15 15 15 15 15 15 15
0.45% 0.43% 0.41% 0.39% 0.38% 0.36% 0.35% 0.33% 0.32% 0.32% 0.31%
39.48% 39.57% 39.66% 39.75% 39.83% 39.92% 40.01% 40.10% 40.18% 39.70% 43.88%23.69% 23.74% 23.79% 23.85% 23.90% 23.95% 24.00% 24.06% 24.11% 23.82% 26.32%
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0$1 $1 $0 $0 $0 $0 $0 $0 $0 $0$1 $1 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$167 $165 $163 $161 $159 $157 $155 $152 $150 $150 $148$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$334 $330 $326 $322 $317 $313 $309 $305 $301 $301 $297$501 $495 $489 $482 $476 $470 $464 $457 $451 $451 $445
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$2 -$2 -$2 -$2 -$2 -$2 -$2 -$2 -$2 -$25 -$2$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$50 -$4.15-$249.00 -$255.23 -$261.45 -$267.68 -$273.90 -$280.13 -$286.35 -$292.58 -$298.80 -$298.80 -$305.03
-$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$25 -$6
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78%0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01%0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%
0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70%
-
$178,473 $179,216 $179,963 $180,713 $181,466 $182,222 $182,982 $183,744 $184,510 $185,279 $186,051$178,473 $179,216 $179,963 $180,713 $181,466 $182,222 $182,982 $183,744 $184,510 $185,279 $186,051
$66,020 $66,295 $66,572 $66,849 $67,128 $67,407 $67,688 $67,970 $68,254 $68,538 $68,824
$112,452 $112,921 $113,391 $113,864 $114,338 $114,815 $115,293 $115,774 $116,256 $116,741 $117,227
$2,252 $2,268 $2,284 $2,300 $2,316 $2,332 $2,348 $2,365 $2,381 $2,398 $2,415$4,557 $4,557 $4,557 $4,557 $4,557 $4,557 $4,557 $4,557 $4,557 $4,557 $4,557
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$27,112 $27,112 $27,112 $27,112 $27,112 $27,112 $27,112 $27,112 $27,112 $27,112 $27,112
$100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100$34,021 $34,036 $34,052 $34,068 $34,084 $34,101 $34,117 $34,133 $34,150 $34,167 $34,183
$78,432 $78,884 $79,339 $79,796 $80,254 $80,714 $81,176 $81,640 $82,106 $82,574 $83,044-$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6
$78,425 $78,878 $79,333 $79,789 $80,248 $80,708 $81,170 $81,634 $82,100 $82,568 $83,037$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$78,425 $78,878 $79,333 $79,789 $80,248 $80,708 $81,170 $81,634 $82,100 $82,568 $83,037$19,606 $19,720 $19,833 $19,947 $20,062 $20,177 $20,293 $20,409 $20,525 $20,642 $20,759$11,764 $11,832 $11,900 $11,968 $12,037 $12,106 $12,176 $12,245 $12,315 $12,385 $12,456
$47,055 $47,327 $47,600 $47,874 $48,149 $48,425 $48,702 $48,980 $49,260 $49,541 $49,82226.37% 26.41% 26.45% 26.49% 26.53% 26.57% 26.62% 26.66% 26.70% 26.74% 26.78%
$1,085,612 $1,132,735 $1,180,131 $1,227,800 $1,275,743 $1,323,961 $1,372,456 $1,421,228 $1,470,279 $1,519,609 $1,575,059$44,618 $44,804 $44,991 $45,178 $45,367 $45,556 $45,745 $45,936 $46,127 $46,320 $46,513
$8,961 $8,998 $9,036 $9,073 $9,111 $9,149 $9,187 $9,225 $9,264 $9,303 $0
-
$1,139,191 $1,186,538 $1,234,158 $1,282,052 $1,330,221 $1,378,666 $1,427,388 $1,476,389 $1,525,670 $1,575,231 $1,621,572
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$146 $144 $142 $140 $138 $136 $134 $132 $130 $128 $126$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$293 $288 $284 $280 $276 $272 $268 $263 $259 $255 $251-$311 -$317 -$324 -$330 -$336 -$342 -$349 -$355 -$361 -$367 -$374$439 $433 $426 $420 $414 $408 $401 $395 $389 $383 $377
$1,139,629 $1,186,970 $1,234,584 $1,282,472 $1,330,635 $1,379,074 $1,427,790 $1,476,785 $1,526,059 $1,575,614 $1,621,948
$3,360 $3,374 $3,388 $3,402 $3,417 $3,431 $3,445 $3,460 $3,474 $3,488 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$3,360 $3,374 $3,388 $3,402 $3,417 $3,431 $3,445 $3,460 $3,474 $3,488 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$3,360 $3,374 $3,388 $3,402 $3,417 $3,431 $3,445 $3,460 $3,474 $3,488 $0
$250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000$839,214 $886,269 $933,596 $981,196 $1,029,069 $1,077,218 $1,125,643 $1,174,345 $1,223,325 $1,272,585 $1,322,126
$47,055 $47,327 $47,600 $47,874 $48,149 $48,425 $48,702 $48,980 $49,260 $49,541 $49,822$1,136,269 $1,183,596 $1,231,196 $1,279,069 $1,327,218 $1,375,643 $1,424,345 $1,473,325 $1,522,585 $1,572,126 $1,621,948
$1,139,629 $1,186,970 $1,234,584 $1,282,472 $1,330,635 $1,379,074 $1,427,790 $1,476,785 $1,526,059 $1,575,614 $1,621,948
$47,055 $47,327 $47,600 $47,874 $48,149 $48,425 $48,702 $48,980 $49,260 $49,541 $49,822-$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6
-
$47,061 $47,333 $47,606 $47,880 $48,155 $48,431 $48,708 $48,987 $49,266 $49,547 $49,829
-$185 -$186 -$187 -$187 -$188 -$189 -$190 -$191 -$191 -$192 -$193-$37 -$37 -$37 -$38 -$38 -$38 -$38 -$38 -$38 -$39 $9,303
-$222 -$223 -$224 -$225 -$226 -$227 -$228 -$229 -$230 -$231 $9,110
$14 $14 $14 $14 $14 $14 $14 $14 $14 $14 -$3,488$14 $14 $14 $14 $14 $14 $14 $14 $14 $14 -$3,488
$46,853 $47,124 $47,396 $47,669 $47,943 $48,218 $48,495 $48,772 $49,051 $49,331 $55,450
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$46,853 $47,124 $47,396 $47,669 $47,943 $48,218 $48,495 $48,772 $49,051 $49,331 $55,450
$1,038,758 $1,085,612 $1,132,735 $1,180,131 $1,227,800 $1,275,743 $1,323,961 $1,372,456 $1,421,228 $1,470,279 $1,519,609$1,085,612 $1,132,735 $1,180,131 $1,227,800 $1,275,743 $1,323,961 $1,372,456 $1,421,228 $1,470,279 $1,519,609 $1,575,059
40677.54% 41434.92% 42215.15% 43019.24% 43848.28% 44703.41% 45585.85% 46496.89% 47437.91% 48410.37% 49415.85%
-
15.71% 15.14% 14.62% 14.13% 13.67% 13.25% 12.85% 12.47% 12.12% 11.79% 11.47%19.06% 18.99% 18.92% 18.85% 18.78% 18.71% 18.65% 18.58% 18.51% 18.44% 18.37%36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99% 36.99%
33901.38% 35163.86% 36423.34% 37679.81% 38933.27% 40183.74% 41431.20% 42675.67% 43917.14% 45155.63% #DIV/0!33914.44% 35176.68% 36435.92% 37692.15% 38945.39% 40195.62% 41442.85% 42687.09% 43928.34% 45166.60% #DIV/0!
15 15 15 15 15 15 15 15 15 15 1515 15 15 15 15 15 15 15 15 15 15
0.30% 0.29% 0.28% 0.27% 0.26% 0.25% 0.24% 0.23% 0.23% 0.22% 0.00%
43.95% 44.02% 44.09% 44.16% 44.23% 44.29% 44.36% 44.43% 44.50% 44.57% 44.63%26.37% 26.41% 26.45% 26.49% 26.53% 26.57% 26.62% 26.66% 26.70% 26.74% 26.78%
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$146 $144 $142 $140 $138 $136 $134 $132 $130 $128 $126$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$293 $288 $284 $280 $276 $272 $268 $263 $259 $255 $251$439 $433 $426 $420 $414 $408 $401 $395 $389 $383 $377
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$2 -$2 -$2 -$2 -$2 -$2 -$2 -$2 -$2 -$2 -$2$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
-$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15 -$4.15-$311.25 -$317.48 -$323.70 -$329.93 -$336.15 -$342.38 -$348.60 -$354.83 -$361.05 -$367.28 -$373.50
-$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6 -$6
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78% 2.78%0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42% 0.42%0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01% 0.01%0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83% 0.83%
0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70% 0.70%
-
AO 5
$2,182,351$2,182,351
$807,292
$1,375,058
$27,894$54,678
$0$325,347
$1,200$409,119
$965,940-$75
$965,865$0$0
$965,865$241,466$144,880
$579,51926.55%
$1,575,059$46,513
$0
-
$1,621,572
$0$0$0
$126$0$0
$251-$374$377
$1,621,948
$0$0$0
$0
$0
$250,000$1,322,126
$49,822$1,621,948
$1,621,948
$579,519-$75
-
$579,594
$0$0$0
$0$0
$579,594
$0$0$0
$0$0$0$0
$0$0
$0
$579,594
$1,575,059$2,154,653
579641.58%
-
134.55%18.75%36.99%
#DIV/0!#DIV/0!
1515
0.00%
44.26%26.55%
$0$0$0
$126$0$0
$251$377
$0$0$0$0$0$0$0$0
-
$0$0$0
-$25$0$0
-$50-$373.50
-$31
-
AO 0 AO 1 AO 2 AO 3 AO 4NATUREZZO TONI
Flujo de Caja:Ingreso
Ingresos por productos 0 1040995 1501756 1844086 2076123Ingresos por servicios 0 0 0 0 0
Total Ingresos 0 1040995 1501756 1844086 2076123
Costo de Venta 0 385084 555528 682162 767997
Utilidad Bruta 0 655912 946229 1161924 1308127
Gastos operativos:Gastos fijos 0 19957 21699 23594 25654Sueldos y salarios 0 39120 42536 46249 50287Comisiones 0 0 0 0 0Gastos de Promocion y Publicidad 0 794304 635443 508355 406684Otros Gastos 0 1200 1200 1200 1200
Total gastos operativos 0 854581 700878 579398 483825
Ebitda 0 -198669 245351 582527 824302Depreciacin y Amortizacin 0 -75 -75 -75 -75Utilidad (perdida) de Operacin 0 -198744 245276 582452 824227Gastos financieros corto plazo 0 0 0 0Gastos financieros largo plazo 0 0 0 0
Utilidad antes de impuestos 0 -198744 245276 582452 824227ISR (25%) 0 0 61319 145613 206057PTU (15%) 0 0 36791 87368 123634
Utilidad (prdida neta) 0 -198744 147166 349471 494536
AjustesDepreciacin y Amortizacin 0 -75 -75 -75 -75
Total de Ajustes 0 $ -75 $ -75 $ -75 $ -75
INVERSION -250000.00 0 0 0 0PASIVOS 0 0 0 0 0RECUPERACION DE CAPITAL 0 0 0 0 0VALOR DE DESECHO 0 0 0 0 0
FLUJO NETO -250000.00 -198818.45 147090.87 349396.41 494461.52
TIR 49.19%TMAR 32.90%VAN 191078ANALISIS SE ACEPTA
RECUPERACION DE CAPITAL
Ao CAPITAL Flujo Acum Por Recuperar % recuperado% por
recuperar
-
0 -250,000 0 0 -250,000 0.00% 100.00%1 0 -198,818 -198,818 -448,818 -79.53% 179.53%2 0 147,091 -51,728 -301,728 -20.69% 120.69%3 0 349,396 297,669 47,669 119.07% -19.07%4 0 494,462 792,130 542,130 316.85% -216.85%5 0 829,071 1,621,201 1,371,201 648.48% -548.48%
-
AO 5
21823510
2182351
807292
1375058
2789454678
0325347
1200409119
965940-75
96586500
965865241466144880579519
-75$ -75
00
249250377
829070.80
-
FLUJO DE CAJA SOCIALRUBRO/AO AO 0 AO 1 AO 2 AO 3 AO 4INGRESOS
Ingresos por productos 0 988,946 1,426,669 1,751,882 1,972,317Ingresos por servicios 0 0 0 0 0
Total Ingresos 0 988,946 1,426,669 1,751,882 1,972,317
Egresos:Gastos fijos 0 18,959 20,614 22,414 24,371Sueldos y salarios 0 39,120 42,536 46,249 50,287Gastos Variables 0 365,829 527,751 648,054 729,597Gastos de Promocion y Publicidad 0 754,589 603,671 482,937 386,349Otros Gastos 0 1,140 1,140 1,140 1,140
Total costos 0 1,179,637 1,195,712 1,200,794 1,191,745
FLUJO OPERATIVO 0 -190,692 230,956 551,088 780,572PART 15% TRABAJADORES 0 0 36,791 87,368 123,634
INVERSION -250,000 0 0 0 0RECUPERACION DE CAPITAL 0 0 0 0 0VALOR DE DESECHO 0 0 0 0 0
FLUJO NETO -250,000 -190,692 267,748 638,456 904,206
TIR SOCIAL 79%
RAZONES BENEFICO COSTO MANO DE OBRA NO CALIFICADA 0.15MANO DE OBRA CALIFICADA 1DIVISA 1COMBUSTIBLE 0.48ENERGIA 1.1INSUMOS NACIONALES 0.95Insumos importados 0.9FUENTE: BANCO DEL ESTADO
-
FLUJO DE CAJA SOCIALAO 5
2,073,2330
2,073,233
26,49954,678766,928309,080
1,1401,158,324
914,909144,880
0249,250
358
1,309,396
-
CALCULO DE PUNTO DE EQUILIBRIONATUREZZO TONI AO 1 AO 2 AO 3 AO 4 AO 5
INGRESOS 1040995 1501756 1844086 2076123 2182351COSTOS VARIABLES 385084 555528 682162 767997 807292MARGEN VARIABLE 655912 946229 1161924 1308127 1375058% MARGEN VARIABLE 63.01% 63.01% 63.01% 63.01% 63.01%GASTOS FIJOS 854581 700878 579398 483825 409119% DE GASTOS FIJOS 82.09% 46.67% 31.42% 23.30% 18.75%PUNTO DE EQUILIBRIO SIN DEUDA 1356302 1112361 919560 767877 649311INTERESES 0 0 0 0 0TOTAL DE GASTOS FIJOS 854581 700878 579398 483825 409119PUNTO DE EQUILIBRIO CON DEUDA 1356302 1112361 919560 767877 649311
PUNTO DE EQUILIBRIO CON DEUDA AO 1
RUBROSANALISIS DE ESCENARIOS
MALO EQUILIBRIO BUENOINGRESOS 1085042 1356302 1695378EGRESOS VARIABLES 401377 501722 627152GASTOS Y COSTOS FIJOS 854581 854581 854581INTERESES 0 0 0TOTAL DE EGRESOS FIJOS 854581 854581 854581EGRESOS 1255958 1356302 1481733UTILIDADES -170916 0 213645
-
MALO EQUILIBRIO BUENO0
200000
400000
600000
800000
1000000
1200000
1400000
1600000
1800000
PUNTO DE EQUILIBRIO
-
AO 1 AO 2 AO 3 AO 4 AO 50
200000
400000
600000
800000
1000000
1200000
1400000
1600000
1356302
1112361
919560
767877
649311
VENTAS PUNTO DE EQUILIBRIO
-
MALO EQUILIBRIO BUENO0
200000
400000
600000
800000
1000000
1200000
1400000
1600000
1800000
Ventas Punto de EquilibrioESCENARIO MALO - EQUILIBRIO - BUENO
-
ANALISIS DE SENSIBILIDADESCENARIO VARIACION % TIR TMAR ANALISIS PUNTO CRITICO
AUMENTO DE LAS VENTAS5% 60.34% 32.90% SE ACEPTA
10% 72.00% 32.90% SE ACEPTA15% 84.20% 32.90% SE ACEPTA
DISMINUCION DE LAS VENTAS-5% 38.50% 32.90% SE ACEPTA-10% 28.22% 32.90% SE RECHAZA-15% 18.26% 32.90% SE RECHAZA
AUMENTO DE LOS COSTOS5% 45.19% 32.90% SE ACEPTA
10% 41.24% 32.90% SE ACEPTA15% 37.36% 32.90% SE ACEPTA
DISMINUCION DE LOS COSTOS-5% 53.26% 32.90% SE ACEPTA-10% 57.40% 32.90% SE ACEPTA-15% 61.60% 32.90% SE ACEPTA
AUMENTO DE LOS GASTOS5% 43.77% 32.90% SE ACEPTA
10% 38.70% 32.90% SE ACEPTA15% 33.96% 32.90% SE ACEPTA
DISMINUCION DE LOS GASTOS-5% 55.00% 32.90% SE ACEPTA-10% 61.22% 32.90% SE ACEPTA-15% 67.89% 32.90% SE ACEPTA
SE PUEDE BAJAR HASTA 7,7%
SE PUEDE SUBIR HASTA 20,82%
SE PUEDE SUBIR HASTA 16,17%
-
ANALISIS DE SENSIBILIDADPUNTO CRITICO
SE PUEDE BAJAR HASTA 7,7%
SE PUEDE SUBIR HASTA 20,82%
SE PUEDE SUBIR HASTA 16,17%
-
5% 10% 15% -5% -10% -15%0.00%
10.00%
20.00%
30.00%
40.00%
50.00%
60.00%
70.00%
80.00%
90.00%
VARIACION % VENTAS
-
5% 10% 15% -5% -10% -15%0.00%
10.00%
20.00%
30.00%
40.00%
50.00%
60.00%
70.00%
VARIACION % COSTOS
-
5% 10% 15% -5% -10% -15%0.00%
10.00%
20.00%
30.00%
40.00%
50.00%
60.00%
70.00%
80.00%
VARIACION % GASTOS
INICIOPrecio ventaDemandaIngresosEquipo de Trabajogastos publicidadGastos PreoperativosInversion en activos fijosResumen de Gastos e inversionesCapital de TrabajoFinanciamientoAmortizacion Deuda CPAmortizacion Deudas LPEstados ProformaEvaluacion FinancieraFlujo SocialPunto de equilibrioGrfico PUNTO EQUILIBRIOGrfico equilibrio aosGrfico equilibrio escenariosAnalisis de SensibilidadGrfico Variacion VentasGrfico Variacion CostosGrfico Variacion Gastos
Drop Down 17: Director de VentasDrop Down 18: Gerente generalDrop Down 19: Gerente generalDrop Down 20: Gerente general