Calculos y Eeff

download Calculos y Eeff

of 68

description

ee.ff

Transcript of Calculos y Eeff

  • 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