Vista previa del material en texto
Plantilla - Tarea 3 Anexo - Plantilla - Tarea 3 - Tablas de Amortización Autor: Joan Sebastián Rojas Portada Planificación del Pago de Obligaciones Financieras Paula Andrea Vargas Idarraga 1,053,828,261 Grupo: 152 Presentado a: Adriana Milena Tejedor UNIVERSIDAD NACIONAL ABIERTA Y A DISTANCIA UNAD ESCUELA DE CIENCIAS ADMINISTRATIVAS, CONTABLES, ECONÓMICAS Y DE NEGOCIOS (ECACEN) Gestion Comercial y de Negocios Matemáticas Financieras 116005 Palmira Sunday, October 31, 2021 Asignación Tasas y Préstamos Diligencie, únicamente, las celdas en color amarillo. La información que debe utilizar para el desarrollo de la actividad es la siguiente: Condiciones de Crédito Monto Tasa Anual Tasa Periódica Plazo Meses Condiciones de Crédito Monto Tasa Decisión 1 Alternativa 1 $43,326,148 11.70% NACM 0.98% MMV 84 Decisión 1 Alternativa 1 $45,293,663 12.40% NACM Alternativa 2 16.40% E+A 1.27% MMV 84 Alternativa 2 13.80% E+A Decisión 2 Alternativa 1 $61,187,550 17.70% E+A 1.37% MMV 60 Decisión 2 Alternativa 1 $70,441,545 11.50% E+A Alternativa 2 9.60% E+A 0.77% MMV 60 Alternativa 2 11.70% E+A Decisión 3 Alternativa 1 $217,564,843 11.40% E+A 2.74% TTV 42 Decisión 3 Alternativa 1 $169,186,733 11.20% E+A Alternativa 2 14.70% NACT 3.68% TTV 42 Alternativa 2 17.70% NACT Decisión 4 Alternativa 1 $53,636,259 11.20% E+A 1.79% BBV 84 Decisión 4 Alternativa 1 $48,406,875 12.40% E+A Alternativa 2 11.10% NACB 1.85% BBV 84 Alternativa 2 18.90% NACB Decisión 5 Alternativa 1 $124,339,955 11.10% NACM 0.93% MMV 180 Decisión 5 Alternativa 1 $96,052,167 9.70% NACM Alternativa 2 16.90% E+A 1.31% MMV 180 Alternativa 2 12.20% E+A Tenga en cuenta las siguientes fórmulas: m Expresión Nominal Número Periodos Meses NACM 12 Bimestres NACB 6 Cuatrimestres NACC 3 Trimestres NACT 4 Asignar Aleatorio Decisión 1 Diligencie, únicamente, las celdas en color amarillo. Una empresa, vínculada al sector industrial, solicita un crédito comercial a una institución financiera, con la finalidad de financiar la compra de un activo fijo que le permita modernizar su sistema de producción. Se plantea la alternativa de financiar el crédito con un sistema de amortización de cuota fija o con un sistema de abono constante a capital, cuyas condiciones se plantean a continuación: • Alternativa 1: Financiación con Cuota Fija mensual a un Plazo de 7 años y la tasa de interés periódica dada a continuación. • Alternativa 2: Financiación con Abono mensual Constante a Capital a un plazo de 7 años y la tasa de interés periódica dada a continuación. El objetivo es estructurar la tabla de amortización correspondiente y tomar una decisión; teniendo en cuenta los problemas de liquidez que enfrenta actualmente la empresa: Capital (P) $43,326,148 Cuota (A) $757,891 Capital (P) $43,326,148 Tasa (i) 0.98% Tasa (i) 1.27% Plazo (n) 84 Plazo (n) 84 Decisión En análisis de vertical de las columnas de interes y abono de las alternativas, resulta más favoable la ALTERNATIVA 1 CUOTA FIJA. Al observar que en la Alternativa 1, los intereses y abonos son de menor valor que los de la alternativa 2 , en análisis horizontal el valor de los abonos se viene a equiparar en la cuota 45 que es aproximadamente de $514,106, que es casi igual al que se paga en la alternativa 2 desde en el abono 1, es de notar respecto a los intereses de la alternativa 1 son más bajos y nunca se igualan a un valor tan alto a los pagos de interes iniciales de la alternativa 2 estos se vienen a equiparar en la cuota 20. De tal manera que con la alternativa 1 siempre debo conseguir menos dinero para dar cumplimiento quedando una diferencia de más o menos $250,000 en cada cuota para poder invertir en otras oportunidades de negocio. Además al final del cumplimiento con la Alternativa 1 pago con la cuota 84 un valor total de interes es igual a $20,336,724 mientras que en la alternativa 2 se pagan $23,450,862, dando una diferencia de $3,114,138 que me sirven para invertir. En igual estudio de los abonos en la Alternativa 1 pago un total de $43,326.148 igual valor pagado en la Alternativa 2. Entonces con la Alternativa 1 pago menos que con la Alternativa 2 y requiero un menor esfuerzo en mantener un flujo de caja alto. Alternativa 2 lo que ocurre con abono, el capital aquí es mas rapido pero al final se abona un valor igual en las 2 alternativas y en el enfoque de abono constante capital se pagan muchos más intereses por un valor considerable. ALTERNATIVA 1 ALTERNATIVA 2 TABLA DE AMORTIZACIÓN DE CUOTA FIJA TABLA DE AMORTIZACIÓN ABONO CONSTANTE A CAPITAL No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final 1 $43,326,148 $757,891 $422,430 $335,461 $42,990,687 1 $43,326,148 $1,067,572 $551,785 $515,787 $42,810,361 2 $42,990,687 $757,891 $419,159 $338,732 $42,651,954 2 $42,810,361 $1,061,004 $545,216 $515,787 $42,294,573 3 $42,651,954 $757,891 $415,857 $342,035 $42,309,920 3 $42,294,573 $1,054,435 $538,647 $515,787 $41,778,786 4 $42,309,920 $757,891 $412,522 $345,370 $41,964,550 4 $41,778,786 $1,047,866 $532,078 $515,787 $41,262,998 5 $41,964,550 $757,891 $409,154 $348,737 $41,615,813 5 $41,262,998 $1,041,297 $525,510 $515,787 $40,747,211 6 $41,615,813 $757,891 $405,754 $352,137 $41,263,676 6 $40,747,211 $1,034,728 $518,941 $515,787 $40,231,423 7 $41,263,676 $757,891 $402,321 $355,570 $40,908,105 7 $40,231,423 $1,028,159 $512,372 $515,787 $39,715,636 8 $40,908,105 $757,891 $398,854 $359,037 $40,549,068 8 $39,715,636 $1,021,590 $505,803 $515,787 $39,199,848 9 $40,549,068 $757,891 $395,353 $362,538 $40,186,530 9 $39,199,848 $1,015,022 $499,234 $515,787 $38,684,061 10 $40,186,530 $757,891 $391,819 $366,073 $39,820,458 10 $38,684,061 $1,008,453 $492,665 $515,787 $38,168,273 11 $39,820,458 $757,891 $388,249 $369,642 $39,450,816 11 $38,168,273 $1,001,884 $486,096 $515,787 $37,652,486 12 $39,450,816 $757,891 $384,645 $373,246 $39,077,570 12 $37,652,486 $995,315 $479,527 $515,787 $37,136,698 13 $39,077,570 $757,891 $381,006 $376,885 $38,700,685 13 $37,136,698 $988,746 $472,959 $515,787 $36,620,911 14 $38,700,685 $757,891 $377,332 $380,560 $38,320,125 14 $36,620,911 $982,177 $466,390 $515,787 $36,105,123 15 $38,320,125 $757,891 $373,621 $384,270 $37,935,855 15 $36,105,123 $975,608 $459,821 $515,787 $35,589,336 16 $37,935,855 $757,891 $369,875 $388,017 $37,547,838 16 $35,589,336 $969,039 $453,252 $515,787 $35,073,548 17 $37,547,838 $757,891 $366,091 $391,800 $37,156,038 17 $35,073,548 $962,471 $446,683 $515,787 $34,557,761 18 $37,156,038 $757,891 $362,271 $395,620 $36,760,418 18 $34,557,761 $955,902 $440,114 $515,787 $34,041,973 19 $36,760,418 $757,891 $358,414 $399,477 $36,360,941 19 $34,041,973 $949,333 $433,545 $515,787 $33,526,186 20 $36,360,941 $757,891 $354,519 $403,372 $35,957,569 20 $33,526,186 $942,764 $426,976 $515,787 $33,010,398 21 $35,957,569 $757,891 $350,586 $407,305 $35,550,264 21 $33,010,398 $936,195 $420,408 $515,787 $32,494,611 22 $35,550,264 $757,891 $346,615 $411,276 $35,138,988 22 $32,494,611 $929,626 $413,839 $515,787 $31,978,824 23 $35,138,988 $757,891 $342,605 $415,286 $34,723,701 23 $31,978,824 $923,057 $407,270 $515,787 $31,463,036 24 $34,723,701 $757,891 $338,556 $419,335 $34,304,366 24 $31,463,036 $916,488 $400,701 $515,787 $30,947,249 25 $34,304,366 $757,891 $334,468 $423,424 $33,880,942 25 $30,947,249 $909,920 $394,132 $515,787 $30,431,461 26 $33,880,942 $757,891 $330,339 $427,552 $33,453,390 26 $30,431,461 $903,351 $387,563 $515,787 $29,915,674 27 $33,453,390 $757,891 $326,171 $431,721 $33,021,669 27 $29,915,674 $896,782 $380,994 $515,787 $29,399,886 28 $33,021,669 $757,891 $321,961 $435,930 $32,585,739 28 $29,399,886 $890,213 $374,426 $515,787 $28,884,09929 $32,585,739 $757,891 $317,711 $440,180 $32,145,559 29 $28,884,099 $883,644 $367,857 $515,787 $28,368,311 30 $32,145,559 $757,891 $313,419 $444,472 $31,701,087 30 $28,368,311 $877,075 $361,288 $515,787 $27,852,524 31 $31,701,087 $757,891 $309,086 $448,806 $31,252,281 31 $27,852,524 $870,506 $354,719 $515,787 $27,336,736 32 $31,252,281 $757,891 $304,710 $453,182 $30,799,100 32 $27,336,736 $863,938 $348,150 $515,787 $26,820,949 33 $30,799,100 $757,891 $300,291 $457,600 $30,341,499 33 $26,820,949 $857,369 $341,581 $515,787 $26,305,161 34 $30,341,499 $757,891 $295,830 $462,062 $29,879,438 34 $26,305,161 $850,800 $335,012 $515,787 $25,789,374 35 $29,879,438 $757,891 $291,325 $466,567 $29,412,871 35 $25,789,374 $844,231 $328,443 $515,787 $25,273,586 36 $29,412,871 $757,891 $286,775 $471,116 $28,941,755 36 $25,273,586 $837,662 $321,875 $515,787 $24,757,799 37 $28,941,755 $757,891 $282,182 $475,709 $28,466,046 37 $24,757,799 $831,093 $315,306 $515,787 $24,242,011 38 $28,466,046 $757,891 $277,544 $480,347 $27,985,698 38 $24,242,011 $824,524 $308,737 $515,787 $23,726,224 39 $27,985,698 $757,891 $272,861 $485,031 $27,500,668 39 $23,726,224 $817,955 $302,168 $515,787 $23,210,436 40 $27,500,668 $757,891 $268,132 $489,760 $27,010,908 40 $23,210,436 $811,387 $295,599 $515,787 $22,694,649 41 $27,010,908 $757,891 $263,356 $494,535 $26,516,373 41 $22,694,649 $804,818 $289,030 $515,787 $22,178,861 42 $26,516,373 $757,891 $258,535 $499,357 $26,017,016 42 $22,178,861 $798,249 $282,461 $515,787 $21,663,074 43 $26,017,016 $757,891 $253,666 $504,225 $25,512,791 43 $21,663,074 $791,680 $275,892 $515,787 $21,147,287 44 $25,512,791 $757,891 $248,750 $509,142 $25,003,649 44 $21,147,287 $785,111 $269,324 $515,787 $20,631,499 45 $25,003,649 $757,891 $243,786 $514,106 $24,489,543 45 $20,631,499 $778,542 $262,755 $515,787 $20,115,712 46 $24,489,543 $757,891 $238,773 $519,118 $23,970,425 46 $20,115,712 $771,973 $256,186 $515,787 $19,599,924 47 $23,970,425 $757,891 $233,712 $524,180 $23,446,245 47 $19,599,924 $765,404 $249,617 $515,787 $19,084,137 48 $23,446,245 $757,891 $228,601 $529,290 $22,916,955 48 $19,084,137 $758,836 $243,048 $515,787 $18,568,349 49 $22,916,955 $757,891 $223,440 $534,451 $22,382,504 49 $18,568,349 $752,267 $236,479 $515,787 $18,052,562 50 $22,382,504 $757,891 $218,229 $539,662 $21,842,842 50 $18,052,562 $745,698 $229,910 $515,787 $17,536,774 51 $21,842,842 $757,891 $212,968 $544,924 $21,297,918 51 $17,536,774 $739,129 $223,342 $515,787 $17,020,987 52 $21,297,918 $757,891 $207,655 $550,237 $20,747,682 52 $17,020,987 $732,560 $216,773 $515,787 $16,505,199 53 $20,747,682 $757,891 $202,290 $555,601 $20,192,080 53 $16,505,199 $725,991 $210,204 $515,787 $15,989,412 54 $20,192,080 $757,891 $196,873 $561,019 $19,631,062 54 $15,989,412 $719,422 $203,635 $515,787 $15,473,624 55 $19,631,062 $757,891 $191,403 $566,488 $19,064,573 55 $15,473,624 $712,854 $197,066 $515,787 $14,957,837 56 $19,064,573 $757,891 $185,880 $572,012 $18,492,561 56 $14,957,837 $706,285 $190,497 $515,787 $14,442,049 57 $18,492,561 $757,891 $180,302 $577,589 $17,914,973 57 $14,442,049 $699,716 $183,928 $515,787 $13,926,262 58 $17,914,973 $757,891 $174,671 $583,220 $17,331,752 58 $13,926,262 $693,147 $177,359 $515,787 $13,410,474 59 $17,331,752 $757,891 $168,985 $588,907 $16,742,845 59 $13,410,474 $686,578 $170,791 $515,787 $12,894,687 60 $16,742,845 $757,891 $163,243 $594,649 $16,148,197 60 $12,894,687 $680,009 $164,222 $515,787 $12,378,899 61 $16,148,197 $757,891 $157,445 $600,446 $15,547,750 61 $12,378,899 $673,440 $157,653 $515,787 $11,863,112 62 $15,547,750 $757,891 $151,591 $606,301 $14,941,450 62 $11,863,112 $666,871 $151,084 $515,787 $11,347,324 63 $14,941,450 $757,891 $145,679 $612,212 $14,329,237 63 $11,347,324 $660,303 $144,515 $515,787 $10,831,537 64 $14,329,237 $757,891 $139,710 $618,181 $13,711,056 64 $10,831,537 $653,734 $137,946 $515,787 $10,315,750 65 $13,711,056 $757,891 $133,683 $624,209 $13,086,848 65 $10,315,750 $647,165 $131,377 $515,787 $9,799,962 66 $13,086,848 $757,891 $127,597 $630,295 $12,456,553 66 $9,799,962 $640,596 $124,809 $515,787 $9,284,175 67 $12,456,553 $757,891 $121,451 $636,440 $11,820,113 67 $9,284,175 $634,027 $118,240 $515,787 $8,768,387 68 $11,820,113 $757,891 $115,246 $642,645 $11,177,468 68 $8,768,387 $627,458 $111,671 $515,787 $8,252,600 69 $11,177,468 $757,891 $108,980 $648,911 $10,528,557 69 $8,252,600 $620,889 $105,102 $515,787 $7,736,812 70 $10,528,557 $757,891 $102,653 $655,238 $9,873,319 70 $7,736,812 $614,321 $98,533 $515,787 $7,221,025 71 $9,873,319 $757,891 $96,265 $661,626 $9,211,692 71 $7,221,025 $607,752 $91,964 $515,787 $6,705,237 72 $9,211,692 $757,891 $89,814 $668,077 $8,543,615 72 $6,705,237 $601,183 $85,395 $515,787 $6,189,450 73 $8,543,615 $757,891 $83,300 $674,591 $7,869,024 73 $6,189,450 $594,614 $78,826 $515,787 $5,673,662 74 $7,869,024 $757,891 $76,723 $681,168 $7,187,856 74 $5,673,662 $588,045 $72,258 $515,787 $5,157,875 75 $7,187,856 $757,891 $70,082 $687,810 $6,500,046 75 $5,157,875 $581,476 $65,689 $515,787 $4,642,087 76 $6,500,046 $757,891 $63,375 $694,516 $5,805,530 76 $4,642,087 $574,907 $59,120 $515,787 $4,126,300 77 $5,805,530 $757,891 $56,604 $701,287 $5,104,243 77 $4,126,300 $568,338 $52,551 $515,787 $3,610,512 78 $5,104,243 $757,891 $49,766 $708,125 $4,396,118 78 $3,610,512 $561,770 $45,982 $515,787 $3,094,725 79 $4,396,118 $757,891 $42,862 $715,029 $3,681,088 79 $3,094,725 $555,201 $39,413 $515,787 $2,578,937 80 $3,681,088 $757,891 $35,891 $722,001 $2,959,088 80 $2,578,937 $548,632 $32,844 $515,787 $2,063,150 81 $2,959,088 $757,891 $28,851 $729,040 $2,230,047 81 $2,063,150 $542,063 $26,275 $515,787 $1,547,362 82 $2,230,047 $757,891 $21,743 $736,148 $1,493,899 82 $1,547,362 $535,494 $19,707 $515,787 $1,031,575 83 $1,493,899 $757,891 $14,566 $743,326 $750,573 83 $1,031,575 $528,925 $13,138 $515,787 $515,787 84 $750,573 $757,891 $7,318 $750,573 -$0 84 $515,787 $522,356 $6,569 $515,787 -$0 Decisión 2 SoloDiligencie, únicamente, las celdas en color amarillo. edite las celdas de color blanco Una empresa acude a un establecimiento de crédito a solicitar financiamiento con la finalidad de llevar a cabo un proyecto de expansión geográfica e incursionar en el mercado peruano. No obstante, hoy afronta un nivel importante de incertidumbre sobre la aceptación del producto en dicho mercado y no se tiene certeza sobre la capacidad de responder por la obligación financiera a corto plazo. Por tanto, solicita financiamiento a cuota fija con dos posibilidades para flexibilizar los pagos: • Alternativa 1: Periodo de gracia de 1 año y un plazo total de 5 años. La tasa de interés periódica está dada a continuación. • Alternativa 2: Periodo muerto de 6 meses y un plazo total de 5 años. La tasa de interés periódica está dada a continuación A partir de la estructuración de los planes de pago, para cada una de las alternativas; deberá tomar la decisión teniendo en cuenta la incertidumbre sobre la generación de flujo de caja, por parte de la empresa, a corto plazo. $61,187,550 Deuda (D) Capital (P) $61,187,550 0.77% Tasa (i) Tasa (i) 1.37% 60 Plazo (n) Plazo 60 6 Periodo Muerto (nm) Periodo Gracia 12 54 Periodo Abono (na) Periodo Abono (na) 48 $64,057,257 Capital (P) Cuota (A) $1,746,886 $1,453,227 Cuota (A) Decisión En análisis del Costo Financiero, la menor tasa de interes es el que me indica la mejor alternativa para el punto de comparación siendo en nuesto caso la de la Alternativa 2 PERÍODO MUERTO porque su Tasa de Interés es del 0,77% y el de la Alternativa 1FIJA CON PERÍODO DE GRACA es de 1,37%. En la Alternativa 1 vengo a pagar en abonos e intereses un costo total de $93,890,214 siendo mucho más que la Alternativa 2 que pago un menor costo financiamiento total de $78,874,247 reduciendose en $15,415,967 cantidad considerable para invertir. En lo rreferentea la liquidez del flujo de caja se debe tener de presente que en la Alternativa 2 PERÍODO MUERTO a partir de la cuota 7 debo reservar una cantidad de $1,453,227 , en la Alternativa 1 los primeros 12 revervamos tan solo $835,640 siendo bajo, pero ya a partir del período de gracia debo tener en cada plazo de pago el valor de $$1.746.886 siendo mayor que las nececidades de flujo de caja de la Alternativa 2 período muerto. Pero en mejor considaración nos la da la menor tasa de interes. ALTERNATIVA 1 ALTERNATIVA 2 TABLA DE AMORTIZACIÓN DE CUOTA FIJA CON PERIODO DE GRACIA TABLA DE AMORTIZACIÓN CON PERIODO MUERTO No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final 1 $61,187,550 $836,640 $836,640 $0 $61,187,550 1 $61,187,550 $0 $469,197 -$469,197 $61,656,747 2 $61,187,550 $836,640 $836,640 $0 $61,187,550 2 $61,656,747 $0 $472,795 -$472,795 $62,129,543 3 $61,187,550 $836,640 $836,640 $0 $61,187,550 3 $62,129,543 $0 $476,421 -$476,421 $62,605,963 4 $61,187,550 $836,640 $836,640 $0 $61,187,550 4 $62,605,963 $0 $480,074 -$480,074 $63,086,037 5 $61,187,550 $836,640 $836,640 $0 $61,187,550 5 $63,086,037 $0 $483,755 -$483,755 $63,569,793 6 $61,187,550 $836,640 $836,640 $0 $61,187,550 6 $63,569,793 $0 $487,465 -$487,465 $64,057,257 7 $61,187,550 $836,640 $836,640 $0 $61,187,550 7 $64,057,257 $1,453,227 $491,203 $962,024 $63,095,234 8 $61,187,550 $836,640 $836,640 $0 $61,187,550 8 $63,095,234 $1,453,227 $483,826 $969,401 $62,125,833 9 $61,187,550 $836,640 $836,640 $0 $61,187,550 9 $62,125,833 $1,453,227 $476,392 $976,835 $61,148,998 10 $61,187,550 $836,640 $836,640 $0 $61,187,550 10 $61,148,998 $1,453,227 $468,902 $984,325 $60,164,673 11 $61,187,550 $836,640 $836,640 $0 $61,187,550 11 $60,164,673 $1,453,227 $461,354 $991,873 $59,172,800 12 $61,187,550 $836,640 $836,640 $0 $61,187,550 12 $59,172,800 $1,453,227 $453,748 $999,479 $58,173,321 13 $61,187,550 $1,746,886 $836,640 $910,246 $60,277,304 13 $58,173,321 $1,453,227 $446,084 $1,007,143 $57,166,178 14 $60,277,304 $1,746,886 $824,194 $922,692 $59,354,612 14 $57,166,178 $1,453,227 $438,361 $1,014,866 $56,151,312 15 $59,354,612 $1,746,886 $811,578 $935,308 $58,419,304 15 $56,151,312 $1,453,227 $430,579 $1,022,648 $55,128,664 16 $58,419,304 $1,746,886 $798,789 $948,097 $57,471,207 16 $55,128,664 $1,453,227 $422,737 $1,030,490 $54,098,174 17 $57,471,207 $1,746,886 $785,825 $961,061 $56,510,146 17 $54,098,174 $1,453,227 $414,835 $1,038,392 $53,059,781 18 $56,510,146 $1,746,886 $772,684 $974,202 $55,535,944 18 $53,059,781 $1,453,227 $406,872 $1,046,355 $52,013,427 19 $55,535,944 $1,746,886 $759,364 $987,522 $54,548,421 19 $52,013,427 $1,453,227 $398,848 $1,054,378 $50,959,049 20 $54,548,421 $1,746,886 $745,861 $1,001,025 $53,547,396 20 $50,959,049 $1,453,227 $390,763 $1,062,463 $49,896,585 21 $53,547,396 $1,746,886 $732,174 $1,014,713 $52,532,684 21 $49,896,585 $1,453,227 $382,616 $1,070,611 $48,825,974 22 $52,532,684 $1,746,886 $718,299 $1,028,587 $51,504,097 22 $48,825,974 $1,453,227 $374,407 $1,078,820 $47,747,154 23 $51,504,097 $1,746,886 $704,235 $1,042,651 $50,461,445 23 $47,747,154 $1,453,227 $366,134 $1,087,093 $46,660,061 24 $50,461,445 $1,746,886 $689,978 $1,056,908 $49,404,537 24 $46,660,061 $1,453,227 $357,798 $1,095,429 $45,564,632 25 $49,404,537 $1,746,886 $675,527 $1,071,359 $48,333,178 25 $45,564,632 $1,453,227 $349,398 $1,103,829 $44,460,804 26 $48,333,178 $1,746,886 $660,878 $1,086,009 $47,247,169 26 $44,460,804 $1,453,227 $340,934 $1,112,293 $43,348,510 27 $47,247,169 $1,746,886 $646,028 $1,100,858 $46,146,311 27 $43,348,510 $1,453,227 $332,404 $1,120,822 $42,227,688 28 $46,146,311 $1,746,886 $630,976 $1,115,910 $45,030,401 28 $42,227,688 $1,453,227 $323,810 $1,129,417 $41,098,271 29 $45,030,401 $1,746,886 $615,717 $1,131,169 $43,899,232 29 $41,098,271 $1,453,227 $315,149 $1,138,078 $39,960,193 30 $43,899,232 $1,746,886 $600,251 $1,146,636 $42,752,597 30 $39,960,193 $1,453,227 $306,422 $1,146,805 $38,813,388 31 $42,752,597 $1,746,886 $584,572 $1,162,314 $41,590,283 31 $38,813,388 $1,453,227 $297,628 $1,155,599 $37,657,790 32 $41,590,283 $1,746,886 $568,679 $1,178,207 $40,412,076 32 $37,657,790 $1,453,227 $288,767 $1,164,460 $36,493,330 33 $40,412,076 $1,746,886 $552,569 $1,194,317 $39,217,760 33 $36,493,330 $1,453,227 $279,838 $1,173,389 $35,319,941 34 $39,217,760 $1,746,886 $536,239 $1,210,647 $38,007,113 34 $35,319,941 $1,453,227 $270,840 $1,182,387 $34,137,554 35 $38,007,113 $1,746,886 $519,685 $1,227,201 $36,779,912 35 $34,137,554 $1,453,227 $261,773 $1,191,454 $32,946,100 36 $36,779,912 $1,746,886 $502,905 $1,243,981 $35,535,931 36 $32,946,100 $1,453,227 $252,637 $1,200,590 $31,745,510 37 $35,535,931 $1,746,886 $485,896 $1,260,990 $34,274,941 37 $31,745,510 $1,453,227 $243,430 $1,209,796 $30,535,713 38 $34,274,941 $1,746,886 $468,654 $1,278,232 $32,996,709 38 $30,535,713 $1,453,227 $234,153 $1,219,073 $29,316,640 39 $32,996,709 $1,746,886 $451,176 $1,295,710 $31,700,999 39 $29,316,640 $1,453,227 $224,805 $1,228,421 $28,088,219 40 $31,700,999 $1,746,886 $433,460 $1,313,427 $30,387,573 40 $28,088,219 $1,453,227 $215,386 $1,237,841 $26,850,377 41 $30,387,573 $1,746,886 $415,501 $1,331,385 $29,056,187 41 $26,850,377 $1,453,227 $205,894 $1,247,333 $25,603,044 42 $29,056,187 $1,746,886 $397,296 $1,349,590 $27,706,597 42 $25,603,044 $1,453,227 $196,329 $1,256,898 $24,346,146 43 $27,706,597 $1,746,886 $378,843 $1,368,043 $26,338,554 43 $24,346,146 $1,453,227 $186,691 $1,266,536 $23,079,610 44 $26,338,554 $1,746,886 $360,137 $1,386,749 $24,951,805 44 $23,079,610 $1,453,227 $176,979 $1,276,248 $21,803,362 45 $24,951,805 $1,746,886 $341,175 $1,405,711 $23,546,094 45 $21,803,362 $1,453,227 $167,192 $1,286,035 $20,517,327 46 $23,546,094 $1,746,886 $321,955 $1,424,932 $22,121,162 46 $20,517,327 $1,453,227 $157,331 $1,295,896 $19,221,431 47 $22,121,162 $1,746,886 $302,471 $1,444,415 $20,676,747 47 $19,221,431 $1,453,227 $147,393 $1,305,833 $17,915,598 48 $20,676,747 $1,746,886 $282,721 $1,464,165 $19,212,582 48 $17,915,598 $1,453,227 $137,380 $1,315,847 $16,599,751 49 $19,212,582 $1,746,886 $262,701 $1,484,185 $17,728,397 49 $16,599,751 $1,453,227 $127,290 $1,325,937 $15,273,814 50 $17,728,397 $1,746,886 $242,407 $1,504,479 $16,223,918 50 $15,273,814 $1,453,227 $117,122 $1,336,104 $13,937,710 51 $16,223,918 $1,746,886 $221,836 $1,525,050 $14,698,867 51 $13,937,710 $1,453,227 $106,877 $1,346,350 $12,591,360 52 $14,698,867 $1,746,886 $200,983 $1,545,903 $13,152,964 52 $12,591,360 $1,453,227 $96,553 $1,356,674 $11,234,686 53 $13,152,964 $1,746,886 $179,845 $1,567,041 $11,585,924 53 $11,234,686 $1,453,227 $86,150 $1,367,077 $9,867,609 54 $11,585,924 $1,746,886 $158,419 $1,588,467 $9,997,456 54 $9,867,609 $1,453,227 $75,667 $1,377,560 $8,490,049 55 $9,997,456 $1,746,886 $136,699 $1,610,187 $8,387,269 55 $8,490,049 $1,453,227 $65,103 $1,388,124 $7,101,925 56 $8,387,269 $1,746,886 $114,682 $1,632,204 $6,755,065 56 $7,101,925 $1,453,227 $54,459 $1,398,768 $5,703,157 57 $6,755,065 $1,746,886 $92,365 $1,654,522 $5,100,544 57 $5,703,157 $1,453,227 $43,733 $1,409,494 $4,293,664 58 $5,100,544 $1,746,886 $69,742 $1,677,144 $3,423,399 58 $4,293,664 $1,453,227 $32,925 $1,420,302 $2,873,361 59 $3,423,399 $1,746,886 $46,809 $1,700,077 $1,723,322 59 $2,873,361 $1,453,227 $22,033 $1,431,193 $1,442,168 60 $1,723,322 $1,746,886 $23,564 $1,723,322 $0 60 $1,442,168 $1,453,227 $11,059 $1,442,168 $0 Decisión 3 Diligencie, únicamente, las celdas en color amarillo. Una empresa requiere solicitar financiación para llevar a cabo un proceso de actualización tecnológico de su sistema de planificación de recursos empresariales (ERP, Enterprise Resource Planning). Para los fines correspondientes, acude a un establecimiento de crédito que le ofrece dos alternativas de financiación, cuyas característicasse enuncian a continuación: • Alternativa 1: Una cuota que se va incrementando constantemente (trimestre) en un 0,1% del valor del préstamo y un plazo de 10,5 años. La tasa de interés periódica está dada a continuación. • Alternativa 2: Una cuota que se va reduciendo en un 6% cada trimestre y un plazo de 10,5 años. La tasa de interés periódica está dada a continuación. El gerente financiero considera que no habrá inconveniente en afrontar el compromiso con el establecimiento de crédito y que, incluso, podría hacerse un abono anticipado para amortizar completamente la deuda en el corto plazo. Por tanto, lo único que le preocupa al directivo financiero es el costo del financiamiento. Con esta premisa en mente, debe tomar la decisión correspondiente: Capital (P) $217,564,843 $217,564,843 Capital (P) Capital (P) $46,099,641 Tasa (i) 2.74% 3.68% Tasa (i) Tasa (i) Plazo (n) 42 42 Plazo (n) Plazo (n) Gradiente Arimét. $217,565 6% Gradiente Geomé. Primera Cuota (A1) $5,161,802 $21,398,902 Primera Cuota (A1) Decisión En estudio del costo de financiamiento la Alternativa 1 AMORTIZACIÓN AUMENTO CONSTANTE presenta una menor tasa de interés siendo de 2,74%, mientras que la Alternativa 2 AMORTIZACIÓN REDUCCIÓN VARIABLE tiene una tasa de interés alta de 3,68%. Aunado a este el análisis vertical nos muestra que con AUMENTO CONSTANTE Alt 1 pago un total de $404,119,032 mientras que con la Alternativa 2 voy a pagar al final un menor costo de financiamiento el cual es por $330,126,134 lo que me representa un valor considerable en su diferencia es de $73.992,898 con la cual se puede hacer alguna inversión y del análisis horizontal, tenemos que: debo reservar una considerable cantidad millonaria los primeros 25 pagos mientras que en la alternativa 1 es menos exigente hasta la cuota 24 en donde se sube a más de 10 millones. De acuerdo a si la actualización del proceso tecnologico me retorne el capital invertido en corto tiempo puedo adquirir el compromiso de la alternativa 2, pero si el retorno es lento me debo acoger a la alternativa 1 y contar con el castigo al final o solucionarlo en menor tiempo para equiparar en los costos la oportunidad de negocio. ALTERNATIVA 1 ALTERNATIVA 2 TABLA DE AMORTIZACIÓN DE CUOTA VARIABLE (AUMENTO CONSTANTE) TABLA DE AMORTIZACIÓN CUOTA VARIABLE (REDUCCIÓN VARIABLE) No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final 1 $217,564,843 $5,161,802 $5,951,877 -$790,074 $218,354,917 1 $217,564,843 $21,398,902 $7,995,508 $13,403,394 $204,161,449 2 $218,354,917 $5,379,367 $5,973,491 -$594,123 $218,949,041 2 $204,161,449 $20,114,968 $7,502,933 $12,612,035 $191,549,414 3 $218,949,041 $5,596,932 $5,989,744 -$392,812 $219,341,853 3 $191,549,414 $18,908,070 $7,039,441 $11,868,629 $179,680,785 4 $219,341,853 $5,814,497 $6,000,490 -$185,993 $219,527,846 4 $179,680,785 $17,773,586 $6,603,269 $11,170,317 $168,510,469 5 $219,527,846 $6,032,062 $6,005,578 $26,484 $219,501,362 5 $168,510,469 $16,707,171 $6,192,760 $10,514,411 $157,996,058 6 $219,501,362 $6,249,627 $6,004,854 $244,773 $219,256,589 6 $157,996,058 $15,704,740 $5,806,355 $9,898,385 $148,097,673 7 $219,256,589 $6,467,191 $5,998,158 $469,034 $218,787,555 7 $148,097,673 $14,762,456 $5,442,589 $9,319,866 $138,777,806 8 $218,787,555 $6,684,756 $5,985,326 $699,430 $218,088,125 8 $138,777,806 $13,876,709 $5,100,084 $8,776,624 $130,001,182 9 $218,088,125 $6,902,321 $5,966,192 $936,129 $217,151,996 9 $130,001,182 $13,044,106 $4,777,543 $8,266,563 $121,734,620 10 $217,151,996 $7,119,886 $5,940,583 $1,179,303 $215,972,693 10 $121,734,620 $12,261,460 $4,473,747 $7,787,712 $113,946,907 11 $215,972,693 $7,337,451 $5,908,321 $1,429,130 $214,543,563 11 $113,946,907 $11,525,772 $4,187,549 $7,338,223 $106,608,684 12 $214,543,563 $7,555,016 $5,869,224 $1,685,791 $212,857,771 12 $106,608,684 $10,834,226 $3,917,869 $6,916,357 $99,692,327 13 $212,857,771 $7,772,581 $5,823,106 $1,949,474 $210,908,297 13 $99,692,327 $10,184,172 $3,663,693 $6,520,479 $93,171,848 14 $210,908,297 $7,990,145 $5,769,775 $2,220,370 $208,687,927 14 $93,171,848 $9,573,122 $3,424,065 $6,149,056 $87,022,792 15 $208,687,927 $8,207,710 $5,709,033 $2,498,677 $206,189,250 15 $87,022,792 $8,998,735 $3,198,088 $5,800,647 $81,222,145 16 $206,189,250 $8,425,275 $5,640,677 $2,784,598 $203,404,651 16 $81,222,145 $8,458,810 $2,984,914 $5,473,897 $75,748,248 17 $203,404,651 $8,642,840 $5,564,499 $3,078,341 $200,326,311 17 $75,748,248 $7,951,282 $2,783,748 $5,167,534 $70,580,715 18 $200,326,311 $8,860,405 $5,480,286 $3,380,119 $196,946,192 18 $70,580,715 $7,474,205 $2,593,841 $4,880,364 $65,700,351 19 $196,946,192 $9,077,970 $5,387,817 $3,690,153 $193,256,039 19 $65,700,351 $7,025,753 $2,414,488 $4,611,265 $61,089,086 20 $193,256,039 $9,295,534 $5,286,866 $4,008,669 $189,247,370 20 $61,089,086 $6,604,207 $2,245,024 $4,359,184 $56,729,903 21 $189,247,370 $9,513,099 $5,177,202 $4,335,898 $184,911,473 21 $56,729,903 $6,207,955 $2,084,824 $4,123,131 $52,606,771 22 $184,911,473 $9,730,664 $5,058,585 $4,672,079 $180,239,394 22 $52,606,771 $5,835,478 $1,933,299 $3,902,179 $48,704,593 23 $180,239,394 $9,948,229 $4,930,772 $5,017,457 $175,221,937 23 $48,704,593 $5,485,349 $1,789,894 $3,695,455 $45,009,137 24 $175,221,937 $10,165,794 $4,793,511 $5,372,283 $169,849,654 24 $45,009,137 $5,156,228 $1,654,086 $3,502,142 $41,506,995 25 $169,849,654 $10,383,359 $4,646,542 $5,736,817 $164,112,837 25 $41,506,995 $4,846,854 $1,525,382 $3,321,472 $38,185,523 26 $164,112,837 $10,600,924 $4,489,601 $6,111,322 $158,001,515 26 $38,185,523 $4,556,043 $1,403,318 $3,152,725 $35,032,797 27 $158,001,515 $10,818,488 $4,322,415 $6,496,073 $151,505,441 27 $35,032,797 $4,282,681 $1,287,455 $2,995,225 $32,037,572 28 $151,505,441 $11,036,053 $4,144,703 $6,891,350 $144,614,092 28 $32,037,572 $4,025,720 $1,177,381 $2,848,339 $29,189,233 29 $144,614,092 $11,253,618 $3,956,178 $7,297,440 $137,316,652 29 $29,189,233 $3,784,177 $1,072,704 $2,711,472 $26,477,761 30 $137,316,652 $11,471,183 $3,756,543 $7,714,639 $129,602,012 30 $26,477,761 $3,557,126 $973,058 $2,584,068 $23,893,693 31 $129,602,012 $11,688,748 $3,545,496 $8,143,252 $121,458,760 31 $23,893,693 $3,343,698 $878,093 $2,465,605 $21,428,087 32 $121,458,760 $11,906,313 $3,322,722 $8,583,590 $112,875,170 32 $21,428,087 $3,143,077 $787,482 $2,355,594 $19,072,493 33 $112,875,170 $12,123,877 $3,087,903 $9,035,975 $103,839,195 33 $19,072,493 $2,954,492 $700,914 $2,253,578 $16,818,915 34 $103,839,195 $12,341,442 $2,840,708 $9,500,735 $94,338,461 34 $16,818,915 $2,777,222 $618,095 $2,159,127 $14,659,788 35 $94,338,461 $12,559,007 $2,580,798 $9,978,209 $84,360,252 35 $14,659,788 $2,610,589 $538,747 $2,071,842 $12,587,946 36 $84,360,252 $12,776,572 $2,307,826 $10,468,746 $73,891,506 36 $12,587,946 $2,453,954 $462,607 $1,991,347 $10,596,600 37 $73,891,506 $12,994,137 $2,021,435 $10,972,702 $62,918,804 37 $10,596,600 $2,306,716 $389,425 $1,917,291 $8,679,308 38 $62,918,804 $13,211,702 $1,721,257 $11,490,445 $51,428,359 38 $8,679,308 $2,168,313 $318,965 $1,849,349 $6,829,959 39 $51,428,359 $13,429,266 $1,406,915 $12,022,351 $39,406,008 39 $6,829,959 $2,038,215 $251,001 $1,787,214 $5,042,746 40 $39,406,008 $13,646,831 $1,078,022 $12,568,809 $26,837,198 40 $5,042,746 $1,915,922 $185,321 $1,730,601 $3,312,145 41 $26,837,198 $13,864,396 $734,180 $13,130,216 $13,706,982 41 $3,312,145 $1,800,966 $121,721 $1,679,245 $1,632,899 42 $13,706,982 $14,081,961 $374,979 $13,706,982 -$0 42 $1,632,899 $1,692,909 $60,009 $1,632,899 $0 Decisión 4 Diligencie, únicamente, las celdas en color amarillo. La gerencia de una empresa da cuenta de la necesidad de financiamiento con la finalidad de llevar a cabo una inversión de reemplazo en un activo que ya está llegando al final de su vidaútil y que, debido al deterioro y obsolescencia, es necesario darlo de baja con la finalidad de modernizar la infraestructura operacional de la empresa. Por tanto, ha contemplado las siguientes alternativas que le ofrece la entidad de financiera de confianza: • Alternativa 1: Cuota fija bimestral anticipada a un plazo de catorce (14) años. La tasa de interés está dada a continuación. • Alternativa 2: Cuota fija bimestral vencida correspondiente al 1% del valor del préstamo, a un plazo de catorce (14) años. El excedente, se amortizará en siete (7) cuotas anuales uniformes. Para este caso no se contemplan restricciones de liquidez y, en ese sentido, lo que más le interesa al gerente es asumir el menor costo financiero posible. Capital (P) $53,636,259 $53,636,259 Capital (P) Tasa (i) 1.79% 1.9% Tasa (ip) Plazo (n) 84 84 Plazo (n) Cuota (A) $1,215,670 $536,363 Cuota Mensual (A) $22,775,872 Cap. Cuota Nor (PCN) 11.63% Tasa iEA $30,860,387 Saldo Abono Extra (Ps) 7 Núm. Abo.Extra (ne) $6,682,107 Abono Extraordinario (Ae) Decisión En estudio del costo de financiamiento la tasa de interes de la alternativa 1, CUOTA FIJA ANTICIPADA es la menor de las dos, pero en cumplimiento de la liquidez se debe contar con al menos dos millones para cada cuota mientras que en la alternativa 2 en las primeras 11 cuotas debo reservar un valor aceptable de un millón para cada pago pero debo tener en cuenta que en las cuotas 12, 24 ...84 debo contar con un flujo de caja alto por siete millones doscientosdieciocho mil cuatrocientos sesentainueve pero en el pago final de los intereses se reducen en diez millones tercientos mil como una oportunidad de inversión siendo de $38,192,944 mientras que en la alternativa 1 se pagan intereses por $48,480,002. Teniendo en cuenta que al GERENTA le interesa asumir el menor costo financiero no importando como se pague lo representa la Alternativa 2 ABONOS EXTRAORDINARIOS en la que al final pago de intereses es mas bajo en diezmillones. ALTERNATIVA 1 ALTERNATIVA 2 TABLA DE AMORTIZACIÓN CUOTA FIJA ANTICIPADA TABLA DE CUOTA FIJA CON ABONOS EXTRAORDINARIOS TABLA DE AMORTIZACIÓN ABONOS EXTRAORDINARIOS No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final 0 $53,636,259 $1,215,670 $1,215,670 $52,420,589 1 $53,636,259 $536,363 $421,354 $115,009 $22,660,863 1 $30,860,387 $6,682,107 $3,587,895 $3,094,211 $27,766,176 1 $52,420,589 $1,215,670 $935,751 $279,919 $52,140,670 2 $53,521,250 $536,363 $419,226 $117,137 $22,543,726 2 $27,766,176 $6,682,107 $3,228,155 $3,453,951 $24,312,224 2 $52,140,670 $1,215,670 $930,754 $284,916 $51,855,754 3 $53,404,113 $536,363 $417,059 $119,304 $22,424,423 3 $24,312,224 $6,682,107 $2,826,592 $3,855,515 $20,456,709 3 $51,855,754 $1,215,670 $925,668 $290,002 $51,565,752 4 $53,284,810 $536,363 $414,852 $121,511 $22,302,912 4 $20,456,709 $6,682,107 $2,378,341 $4,303,765 $16,152,944 4 $51,565,752 $1,215,670 $920,491 $295,179 $51,270,573 5 $53,163,299 $536,363 $412,604 $123,759 $22,179,153 5 $16,152,944 $6,682,107 $1,877,976 $4,804,130 $11,348,814 5 $51,270,573 $1,215,670 $915,222 $300,448 $50,970,125 6 $53,039,540 $536,363 $410,314 $126,048 $22,053,105 6 $11,348,814 $6,682,107 $1,319,437 $5,362,669 $5,986,144 6 $50,970,125 $1,215,670 $909,859 $305,811 $50,664,314 7 $52,913,492 $536,363 $407,982 $128,380 $21,924,725 7 $5,986,144 $6,682,107 $695,962 $5,986,144 $0 7 $50,664,314 $1,215,670 $904,400 $311,270 $50,353,044 8 $52,785,112 $536,363 $405,607 $130,755 $21,793,970 8 $50,353,044 $1,215,670 $898,843 $316,827 $50,036,217 9 $52,654,357 $536,363 $403,188 $133,174 $21,660,795 9 $50,036,217 $1,215,670 $893,188 $322,482 $49,713,735 10 $52,521,183 $536,363 $400,725 $135,638 $21,525,157 10 $49,713,735 $1,215,670 $887,431 $328,239 $49,385,496 11 $52,385,545 $536,363 $398,215 $138,147 $21,387,010 11 $49,385,496 $1,215,670 $881,572 $334,098 $49,051,398 12 $52,247,397 $7,218,469 $3,983,555 $3,234,914 $49,012,483 12 $49,051,398 $1,215,670 $875,608 $340,062 $48,711,336 13 $49,012,483 $536,363 $393,057 $143,306 $48,869,177 13 $48,711,336 $1,215,670 $869,537 $346,132 $48,365,204 14 $48,869,177 $536,363 $390,406 $145,957 $48,723,220 TABLA DE AMORTIZACIÓN CUOTA NORMAL 14 $48,365,204 $1,215,670 $863,359 $352,311 $48,012,892 15 $48,723,220 $536,363 $387,705 $148,657 $48,574,563 15 $48,012,892 $1,215,670 $857,070 $358,600 $47,654,292 16 $48,574,563 $536,363 $384,955 $151,407 $48,423,155 No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final 16 $47,654,292 $1,215,670 $850,668 $365,002 $47,289,291 17 $48,423,155 $536,363 $382,154 $154,208 $48,268,947 1 $22,775,872 $536,363 $421,354 $115,009 $22,660,863 17 $47,289,291 $1,215,670 $844,153 $371,517 $46,917,774 18 $48,268,947 $536,363 $379,301 $157,061 $48,111,886 2 $22,660,863 $536,363 $419,226 $117,137 $22,543,726 18 $46,917,774 $1,215,670 $837,521 $378,149 $46,539,625 19 $48,111,886 $536,363 $376,396 $159,967 $47,951,919 3 $22,543,726 $536,363 $417,059 $119,304 $22,424,423 19 $46,539,625 $1,215,670 $830,771 $384,899 $46,154,725 20 $47,951,919 $536,363 $373,436 $162,926 $47,788,992 4 $22,424,423 $536,363 $414,852 $121,511 $22,302,912 20 $46,154,725 $1,215,670 $823,900 $391,770 $45,762,955 21 $47,788,992 $536,363 $370,422 $165,940 $47,623,052 5 $22,302,912 $536,363 $412,604 $123,759 $22,179,153 21 $45,762,955 $1,215,670 $816,906 $398,763 $45,364,192 22 $47,623,052 $536,363 $367,352 $169,010 $47,454,041 6 $22,179,153 $536,363 $410,314 $126,048 $22,053,105 22 $45,364,192 $1,215,670 $809,788 $405,882 $44,958,310 23 $47,454,041 $536,363 $364,226 $172,137 $47,281,904 7 $22,053,105 $536,363 $407,982 $128,380 $21,924,725 23 $44,958,310 $1,215,670 $802,543 $413,127 $44,545,183 24 $47,281,904 $7,218,469 $3,589,196 $3,629,273 $43,652,632 8 $21,924,725 $536,363 $405,607 $130,755 $21,793,970 24 $44,545,183 $1,215,670 $795,168 $420,502 $44,124,681 25 $43,652,632 $536,363 $357,798 $178,565 $19,161,842 9 $21,793,970 $536,363 $403,188 $133,174 $21,660,795 25 $44,124,681 $1,215,670 $787,662 $428,008 $43,696,673 26 $43,474,067 $536,363 $354,494 $181,869 $18,979,974 10 $21,660,795 $536,363 $400,725 $135,638 $21,525,157 26 $43,696,673 $1,215,670 $780,021 $435,648 $43,261,025 27 $43,292,198 $536,363 $351,130 $185,233 $18,794,740 11 $21,525,157 $536,363 $398,215 $138,147 $21,387,010 27 $43,261,025 $1,215,670 $772,245 $443,425 $42,817,600 28 $43,106,965 $536,363 $347,703 $188,660 $18,606,081 12 $21,387,010 $536,363 $395,660 $140,703 $21,246,307 28 $42,817,600 $1,215,670 $764,329 $451,340 $42,366,260 29 $42,918,305 $536,363 $344,212 $192,150 $18,413,930 13 $21,246,307 $536,363 $393,057 $143,306 $21,103,002 29 $42,366,260 $1,215,670 $756,273 $459,397 $41,906,862 30 $42,726,155 $536,363 $340,658 $195,705 $18,218,226 14 $21,103,002 $536,363 $390,406 $145,957 $20,957,044 30 $41,906,862 $1,215,670 $748,072 $467,598 $41,439,265 31 $42,530,450 $536,363 $337,037 $199,325 $18,018,900 15 $20,957,044 $536,363 $387,705 $148,657 $20,808,387 31 $41,439,265 $1,215,670 $739,725 $475,945 $40,963,320 32 $42,331,125 $536,363 $333,350 $203,013 $17,815,887 16 $20,808,387 $536,363 $384,955 $151,407 $20,656,980 32 $40,963,320 $1,215,670 $731,229 $484,441 $40,478,879 33 $42,128,112 $536,363 $329,594 $206,769 $17,609,119 17 $20,656,980 $536,363 $382,154 $154,208 $20,502,771 33 $40,478,879 $1,215,670 $722,581 $493,089 $39,985,790 34 $41,921,343 $536,363 $325,769 $210,594 $17,398,525 18 $20,502,771 $536,363 $379,301 $157,061 $20,345,710 34 $39,985,790 $1,215,670 $713,779 $501,891 $39,483,900 35 $41,710,749 $536,363 $321,873 $214,490 $17,184,035 19 $20,345,710 $536,363 $376,396 $159,967 $20,185,743 35 $39,483,900 $1,215,670 $704,820 $510,850 $38,973,050 36 $41,496,259 $7,218,469 $3,144,496 $4,073,973 $37,422,28620 $20,185,743 $536,363 $373,436 $162,926 $20,022,817 36 $38,973,050 $1,215,670 $695,701 $519,969 $38,453,081 37 $37,422,286 $536,363 $313,863 $222,499 $37,199,787 21 $20,022,817 $536,363 $370,422 $165,940 $19,856,876 37 $38,453,081 $1,215,670 $686,419 $529,251 $37,923,830 38 $37,199,787 $536,363 $309,747 $226,616 $36,973,171 22 $19,856,876 $536,363 $367,352 $169,010 $19,687,866 38 $37,923,830 $1,215,670 $676,971 $538,698 $37,385,132 39 $36,973,171 $536,363 $305,555 $230,808 $36,742,363 23 $19,687,866 $536,363 $364,226 $172,137 $19,515,729 39 $37,385,132 $1,215,670 $667,355 $548,314 $36,836,818 40 $36,742,363 $536,363 $301,285 $235,078 $36,507,285 24 $19,515,729 $536,363 $361,041 $175,322 $19,340,407 40 $36,836,818 $1,215,670 $657,567 $558,102 $36,278,715 41 $36,507,285 $536,363 $296,936 $239,427 $36,267,858 25 $19,340,407 $536,363 $357,798 $178,565 $19,161,842 41 $36,278,715 $1,215,670 $647,605 $568,065 $35,710,650 42 $36,267,858 $536,363 $292,506 $243,856 $36,024,002 26 $19,161,842 $536,363 $354,494 $181,869 $18,979,974 42 $35,710,650 $1,215,670 $637,464 $578,205 $35,132,445 43 $36,024,002 $536,363 $287,995 $248,368 $35,775,634 27 $18,979,974 $536,363 $351,130 $185,233 $18,794,740 43 $35,132,445 $1,215,670 $627,143 $588,527 $34,543,918 44 $35,775,634 $536,363 $283,400 $252,962 $35,522,672 28 $18,794,740 $536,363 $347,703 $188,660 $18,606,081 44 $34,543,918 $1,215,670 $616,637 $599,032 $33,944,886 45 $35,522,672 $536,363 $278,720 $257,642 $35,265,030 29 $18,606,081 $536,363 $344,212 $192,150 $18,413,930 45 $33,944,886 $1,215,670 $605,944 $609,726 $33,335,160 46 $35,265,030 $536,363 $273,954 $262,409 $35,002,621 30 $18,413,930 $536,363 $340,658 $195,705 $18,218,226 46 $33,335,160 $1,215,670 $595,060 $620,610 $32,714,550 47 $35,002,621 $536,363 $269,099 $267,263 $34,735,358 31 $18,218,226 $536,363 $337,037 $199,325 $18,018,900 47 $32,714,550 $1,215,670 $583,982 $631,688 $32,082,862 48 $34,735,358 $7,218,469 $2,642,496 $4,575,973 $30,159,385 32 $18,018,900 $536,363 $333,350 $203,013 $17,815,887 48 $32,082,862 $1,215,670 $572,705 $642,964 $31,439,898 49 $30,159,385 $536,363 $259,119 $277,243 $29,882,141 33 $17,815,887 $536,363 $329,594 $206,769 $17,609,119 49 $31,439,898 $1,215,670 $561,228 $654,442 $30,785,456 50 $29,882,141 $536,363 $253,990 $282,372 $29,599,769 34 $17,609,119 $536,363 $325,769 $210,594 $17,398,525 50 $30,785,456 $1,215,670 $549,546 $666,124 $30,119,332 51 $29,599,769 $536,363 $248,766 $287,596 $29,312,172 35 $17,398,525 $536,363 $321,873 $214,490 $17,184,035 51 $30,119,332 $1,215,670 $537,655 $678,015 $29,441,317 52 $29,312,172 $536,363 $243,446 $292,917 $29,019,255 36 $17,184,035 $536,363 $317,905 $218,458 $16,965,577 52 $29,441,317 $1,215,670 $525,552 $690,118 $28,751,199 53 $29,019,255 $536,363 $238,027 $298,336 $28,720,920 37 $16,965,577 $536,363 $313,863 $222,499 $16,743,077 53 $28,751,199 $1,215,670 $513,232 $702,437 $28,048,761 54 $28,720,920 $536,363 $232,508 $303,855 $28,417,065 38 $16,743,077 $536,363 $309,747 $226,616 $16,516,462 54 $28,048,761 $1,215,670 $500,693 $714,976 $27,333,785 55 $28,417,065 $536,363 $226,886 $309,476 $28,107,588 39 $16,516,462 $536,363 $305,555 $230,808 $16,285,654 55 $27,333,785 $1,215,670 $487,930 $727,739 $26,606,046 56 $28,107,588 $536,363 $221,161 $315,202 $27,792,387 40 $16,285,654 $536,363 $301,285 $235,078 $16,050,576 56 $26,606,046 $1,215,670 $474,940 $740,730 $25,865,316 57 $27,792,387 $536,363 $215,330 $321,033 $27,471,354 41 $16,050,576 $536,363 $296,936 $239,427 $15,811,149 57 $25,865,316 $1,215,670 $461,717 $753,953 $25,111,363 58 $27,471,354 $536,363 $209,391 $326,972 $27,144,382 42 $15,811,149 $536,363 $292,506 $243,856 $15,567,292 58 $25,111,363 $1,215,670 $448,258 $767,411 $24,343,952 59 $27,144,382 $536,363 $203,342 $333,021 $26,811,361 43 $15,567,292 $536,363 $287,995 $248,368 $15,318,925 59 $24,343,952 $1,215,670 $434,560 $781,110 $23,562,841 60 $26,811,361 $7,218,469 $2,075,157 $5,143,312 $21,668,048 44 $15,318,925 $536,363 $283,400 $252,962 $15,065,962 60 $23,562,841 $1,215,670 $420,616 $795,054 $22,767,788 61 $21,668,048 $536,363 $190,906 $345,457 $21,322,592 45 $15,065,962 $536,363 $278,720 $257,642 $14,808,320 61 $22,767,788 $1,215,670 $406,424 $809,246 $21,958,542 62 $21,322,592 $536,363 $184,515 $351,848 $20,970,744 46 $14,808,320 $536,363 $273,954 $262,409 $14,545,911 62 $21,958,542 $1,215,670 $391,978 $823,692 $21,134,850 63 $20,970,744 $536,363 $178,006 $358,357 $20,612,387 47 $14,545,911 $536,363 $269,099 $267,263 $14,278,648 63 $21,134,850 $1,215,670 $377,274 $838,395 $20,296,455 64 $20,612,387 $536,363 $171,376 $364,986 $20,247,400 48 $14,278,648 $536,363 $264,155 $272,208 $14,006,441 64 $20,296,455 $1,215,670 $362,308 $853,361 $19,443,093 65 $20,247,400 $536,363 $164,624 $371,739 $19,875,662 49 $14,006,441 $536,363 $259,119 $277,243 $13,729,197 65 $19,443,093 $1,215,670 $347,075 $868,595 $18,574,499 66 $19,875,662 $536,363 $157,747 $378,616 $19,497,046 50 $13,729,197 $536,363 $253,990 $282,372 $13,446,825 66 $18,574,499 $1,215,670 $331,570 $884,100 $17,690,399 67 $19,497,046 $536,363 $150,742 $385,620 $19,111,426 51 $13,446,825 $536,363 $248,766 $287,596 $13,159,228 67 $17,690,399 $1,215,670 $315,788 $899,882 $16,790,517 68 $19,111,426 $536,363 $143,608 $392,754 $18,718,671 52 $13,159,228 $536,363 $243,446 $292,917 $12,866,311 68 $16,790,517 $1,215,670 $299,725 $915,945 $15,874,572 69 $18,718,671 $536,363 $136,342 $400,020 $18,318,651 53 $12,866,311 $536,363 $238,027 $298,336 $12,567,976 69 $15,874,572 $1,215,670 $283,374 $932,296 $14,942,276 70 $18,318,651 $536,363 $128,942 $407,421 $17,911,230 54 $12,567,976 $536,363 $232,508 $303,855 $12,264,121 70 $14,942,276 $1,215,670 $266,732 $948,938 $13,993,338 71 $17,911,230 $536,363 $121,405 $414,958 $17,496,273 55 $12,264,121 $536,363 $226,886 $309,476 $11,954,644 71 $13,993,338 $1,215,670 $249,793 $965,877 $13,027,461 72 $17,496,273 $7,218,469 $1,433,165 $5,785,304 $11,710,969 56 $11,954,644 $536,363 $221,161 $315,202 $11,639,443 72 $13,027,461 $1,215,670 $232,551 $983,119 $12,044,342 73 $11,710,969 $536,363 $105,909 $430,453 $11,280,516 57 $11,639,443 $536,363 $215,330 $321,033 $11,318,410 73 $12,044,342 $1,215,670 $215,001 $1,000,668 $11,043,674 74 $11,280,516 $536,363 $97,946 $438,417 $10,842,099 58 $11,318,410 $536,363 $209,391 $326,972 $10,991,438 74 $11,043,674 $1,215,670 $197,139 $1,018,531 $10,025,143 75 $10,842,099 $536,363 $89,835 $446,527 $10,395,571 59 $10,991,438 $536,363 $203,342 $333,021 $10,658,417 75 $10,025,143 $1,215,670 $178,957 $1,036,713 $8,988,430 76 $10,395,571 $536,363 $81,574 $454,788 $9,940,783 60 $10,658,417 $536,363 $197,181 $339,182 $10,319,235 76 $8,988,430 $1,215,670 $160,451 $1,055,219 $7,933,211 77 $9,940,783 $536,363 $73,161 $463,202 $9,477,582 61 $10,319,235 $536,363 $190,906 $345,457 $9,973,778 77 $7,933,211 $1,215,670 $141,614 $1,074,055 $6,859,156 78 $9,477,582 $536,363 $64,592 $471,771 $9,005,810 62 $9,973,778 $536,363 $184,515 $351,848 $9,621,930 78 $6,859,156 $1,215,670 $122,442 $1,093,228 $5,765,928 79 $9,005,810 $536,363 $55,864 $480,499 $8,525,312 63 $9,621,930 $536,363 $178,006 $358,357 $9,263,573 79 $5,765,928 $1,215,670 $102,927 $1,112,743 $4,653,184 80 $8,525,312 $536,363 $46,975 $489,388 $8,035,924 64 $9,263,573 $536,363 $171,376 $364,986 $8,898,587 80 $4,653,184 $1,215,670 $83,063 $1,132,607 $3,520,578 81 $8,035,924 $536,363 $37,921 $498,442 $7,537,482 65 $8,898,587 $536,363 $164,624 $371,739 $8,526,848 81 $3,520,578 $1,215,670 $62,845 $1,152,825 $2,367,753 82 $7,537,482 $536,363 $28,700 $507,663 $7,029,819 66 $8,526,848 $536,363 $157,747 $378,616 $8,148,232 82 $2,367,753 $1,215,670 $42,266 $1,173,403 $1,194,350 83 $7,029,819 $536,363 $19,308 $517,055 $6,512,765 67 $8,148,232 $536,363 $150,742 $385,620 $7,762,612 83 $1,194,350 $1,215,670 $21,320 $1,194,350 -$0 84 $6,512,765 $7,218,469$705,705 $6,512,765 $0 68 $7,762,612 $536,363 $143,608 $392,754 $7,369,858 69 $7,369,858 $536,363 $136,342 $400,020 $6,969,838 70 $6,969,838 $536,363 $128,942 $407,421 $6,562,417 71 $6,562,417 $536,363 $121,405 $414,958 $6,147,459 72 $6,147,459 $536,363 $113,728 $422,635 $5,724,824 73 $5,724,824 $536,363 $105,909 $430,453 $5,294,371 74 $5,294,371 $536,363 $97,946 $438,417 $4,855,954 75 $4,855,954 $536,363 $89,835 $446,527 $4,409,427 76 $4,409,427 $536,363 $81,574 $454,788 $3,954,639 77 $3,954,639 $536,363 $73,161 $463,202 $3,491,437 78 $3,491,437 $536,363 $64,592 $471,771 $3,019,666 79 $3,019,666 $536,363 $55,864 $480,499 $2,539,167 80 $2,539,167 $536,363 $46,975 $489,388 $2,049,779 81 $2,049,779 $536,363 $37,921 $498,442 $1,551,338 82 $1,551,338 $536,363 $28,700 $507,663 $1,043,675 83 $1,043,675 $536,363 $19,308 $517,055 $526,620 84 $526,620 $536,363 $9,742 $526,620 $0 Decisión 5 Diligencie, únicamente, las celdas en color amarillo. Una empresa del sector turístico desea ampliar su infraestructura de locaciones de alojamiento; para lo cual planea tomar un crédito a largo plazo, el cuál puede ser financiado en cuota fija con tasa de interés indexada al IPC o cuota fija en UVRs. Así las cosas, el banco propone las siguientes alternativas: • Alternativa 1: Financiación de cuota fija mensual con tasa indexada a IPC, la cual se propone a continuación, por un plazo de 15 años. • Alternativa 2: Financiación de cuota fija mensual en UVR más la tasa fija, la cual se propone a continuación, por un plazo de 15 años. Tenga en cuenta un valor de UVR de 280 al inicio. Debe construir las tablas de amortización correspondientes y tomar una decisión en razón del costo de financiamiento. Decisión En análisis del costo de financiamiento la tasa de interes menor es la que me brinda la Alternativa 1 AMORTIZACIÓN FIJA TASA INDEXADA con una tasa de interés del 0,99% y teniendo en cuenta la variación del IPC en cada cuota es poca y a la baja, como parámetro de estudio en comparación con la de la alternativa 2 UNIDAD CUENTA VARIABLE en la que el valor del UVR siempre es de tendencia con gradiente ascendentenos sale más costoso el financiamiento y que sube el precio del UVR de 280000 a 307578 y los intereses en UVR que bajan al final de la cuota 153 se pueden considerar altos, pero en definitiva al hacer el análisis vertical nos damos cuenta que el menor costo de financiación es el de la Alternativa 1 indexada que es un total de $258,253.007 mientras que el costo de la Alternativa 2 es mucho mayor e igual a $339.176.328 y que al escoger la ALTERNATIVA 1 INDEXADA me va a dar menor costo en diferencia de $80,923,321 lo cual me representa un dinero por invertir como costo de oportunidad al final del compromiso. $124,339,955 Capital (P) 1.31% UVR + ? EMV (i) 180 Plazo (n) Capital (P) $124,339,955 280 UVR Tasa Fija (if) 0.93% 444,071 UVRs Capital en UVR (PUVR) Plazo (n) 180 6,435 UVRs Cuota en UVR (A) IPC Mes Anterior 100.380 Variación Mes Anterior (∆i) 0.21% Tasa del Mes (i) ALTERNATIVA 1 ALTERNATIVA 2 TABLA DE AMORTIZACIÓN CUOTA FIJA CON TASA INDEXADA TABLA DE AMORTIZACIÓN EN PESOS (CON UNIDAD DE CUENTA VARIABLE) TABLA DE AMORTIZACIÓN EN UVR Costo Periódico 0.99% Costo Anual 112.60% Costo Periódico 1.38% Costo Anual 17.85% Costo Periódico Costo Anual No. de Cuota IPC Mes Anterior Variación Mes Ant Tasa del Mes Saldo Inicial Cuota Interés Abono Saldo Final No. de Cuota Precio UVR Saldo Inicial Cuota Interés Abono Saldo Final No. de Cuota Saldo Inicial Cuota Interés Abono Saldo Final Deuda -$124,339,955 Deuda -$124,339,955 Deuda -444,071 UVRs 1 100.59 0.21% 1.14% $124,339,955 $1,628,734 $1,416,843 $211,891 $124,128,064 1 $280.000 $124,339,955 $1,801,699 $1,628,533 $173,167 $124,166,788 1 444,071 UVRs 6,435 UVRs 5,816 UVRs 618 UVRs 443,453 UVRs 2 101.13 0.54% 1.47% $124,128,064 $1,965,748 $1,820,686 $145,062 $123,983,002 2 $281.503 $124,833,334 $1,811,371 $1,634,995 $176,377 $124,656,957 2 443,453 UVRs 6,435 UVRs 5,808 UVRs 627 UVRs 442,826 UVRs 3 101.64 0.50% 1.43% $123,983,002 $1,927,509 $1,773,729 $153,779 $123,829,223 3 $282.913 $125,281,475 $1,820,446 $1,640,864 $179,582 $125,101,893 3 442,826 UVRs 6,435 UVRs 5,800 UVRs 635 UVRs 442,192 UVRs 4 102.06 0.41% 1.34% $123,829,223 $1,835,189 $1,661,844 $173,344 $123,655,879 4 $284.082 $125,618,843 $1,827,968 $1,645,283 $182,686 $125,436,157 4 442,192 UVRs 6,435 UVRs 5,792 UVRs 643 UVRs 441,548 UVRs 5 102.42 0.36% 1.28% $123,655,879 $1,776,055 $1,588,103 $187,952 $123,467,926 5 $285.094 $125,882,710 $1,834,476 $1,648,739 $185,737 $125,696,972 5 441,548 UVRs 6,435 UVRs 5,783 UVRs 651 UVRs 440,897 UVRs 6 102.70 0.27% 1.19% $123,467,926 $1,685,699 $1,474,620 $211,079 $123,256,847 6 $285.855 $126,032,415 $1,839,372 $1,650,699 $188,672 $125,843,743 6 440,897 UVRs 6,435 UVRs 5,775 UVRs 660 UVRs 440,237 UVRs 7 102.89 0.19% 1.12% $123,256,847 $1,611,020 $1,378,349 $232,671 $123,024,176 7 $286.402 $126,084,737 $1,842,894 $1,651,385 $191,509 $125,893,227 7 440,237 UVRs 6,435 UVRs 5,766 UVRs 669 UVRs 439,568 UVRs 8 103.08 0.18% 1.10% $123,024,176 $1,598,008 $1,359,203 $238,804 $122,785,372 8 $286.912 $126,117,541 $1,846,178 $1,651,814 $194,363 $125,923,178 8 439,568 UVRs 6,435 UVRs 5,757 UVRs 677 UVRs 438,891 UVRs 9 103.24 0.16% 1.08% $122,785,372 $1,578,900 $1,332,128 $246,772 $122,538,600 9 $287.367 $126,122,714 $1,849,103 $1,651,882 $197,221 $125,925,493 9 438,891 UVRs 6,435 UVRs 5,748 UVRs 686 UVRs 438,204 UVRs 10 103.41 0.16% 1.09% $122,538,600 $1,584,882 $1,337,127 $247,755 $122,290,845 10 $287.840 $126,132,848 $1,852,148 $1,652,015 $200,133 $125,932,715 10 438,204 UVRs 6,435 UVRs 5,739 UVRs 695 UVRs 437,509 UVRs 11 103.59 0.17% 1.10% $122,290,845 $1,593,926 $1,346,024 $247,901 $122,042,944 11 $288.341 $126,151,919 $1,855,372 $1,652,265 $203,107 $125,948,811 11 437,509 UVRs 6,435 UVRs 5,730 UVRs 704 UVRs 436,805 UVRs 12 103.86 0.26% 1.19% $122,042,944 $1,677,935 $1,449,936 $227,999 $121,814,945 12 $289.093 $126,277,088 $1,860,208 $1,653,904 $206,304 $126,070,784 12 436,805 UVRs 6,435 UVRs 5,721 UVRs 714 UVRs 436,091 UVRs 13 104.33 0.45% 1.38% $121,814,945 $1,866,301 $1,679,193 $187,108 $121,627,837 13 $290.392 $126,637,249 $1,868,566 $1,658,621 $209,945 $126,427,304 13 436,091 UVRs 6,435 UVRs 5,712 UVRs 723 UVRs 435,368 UVRs 14 104.90 0.55% 1.48% $121,627,837 $1,972,390 $1,803,575 $168,814 $121,459,022 14 $291.997 $127,126,132 $1,878,895 $1,665,024 $213,870 $126,912,262 14 435,368 UVRs 6,435 UVRs 5,702 UVRs 732 UVRs 434,636 UVRs 15 105.39 0.46% 1.39% $121,459,022 $1,881,420 $1,692,180 $189,240 $121,269,782 15 $293.351 $127,501,032 $1,887,611 $1,669,935 $217,677 $127,283,356 15 434,636 UVRs 6,435 UVRs 5,693 UVRs 742 UVRs 433,894 UVRs 16 105.53 0.13% 1.06% $121,269,782 $1,558,319 $1,284,330 $273,989 $120,995,793 16 $293.741 $127,452,439 $1,890,119 $1,669,298 $220,821 $127,231,618 16 433,894 UVRs 6,435 UVRs 5,683 UVRs 752 UVRs 433,142 UVRs 17 105.34 -0.18% 0.75% $120,995,793 $1,281,737 $903,208 $378,529 $120,617,264 17 $293.222 $127,006,565 $1,886,775 $1,663,458 $223,317 $126,783,248 17 433,142 UVRs 6,435 UVRs 5,673 UVRs 762 UVRs 432,380 UVRs 18 105.10 -0.23% 0.69% $120,617,264 $1,236,359 $834,518 $401,841 $120,215,423 18 $292.544 $126,490,390 $1,882,417 $1,656,698 $225,719 $126,264,671 18 432,380 UVRs 6,435 UVRs 5,663 UVRs 772 UVRs 431,609 UVRs 19 104.97 -0.13% 0.80% $120,215,423 $1,324,008 $958,073 $365,935 $119,849,488 19 $292.173 $126,104,487 $1,880,029 $1,651,643 $228,386 $125,876,102 19 431,609 UVRs 6,435 UVRs 5,653 UVRs 782 UVRs 430,827 UVRs 20 105.07 0.10%1.03% $119,849,488 $1,525,738 $1,231,525 $294,213 $119,555,275 20 $292.470 $126,004,016 $1,881,939 $1,650,327 $231,612 $125,772,405 20 430,827 UVRs 6,435 UVRs 5,643 UVRs 792 UVRs 430,035 UVRs 21 105.16 0.08% 1.01% $119,555,275 $1,508,397 $1,205,410 $302,987 $119,252,288 21 $292.711 $125,876,144 $1,883,492 $1,648,653 $234,839 $125,641,305 21 430,035 UVRs 6,435 UVRs 5,632 UVRs 802 UVRs 429,233 UVRs 22 105.20 0.04% 0.96% $119,252,288 $1,468,645 $1,148,864 $319,782 $118,932,506 22 $292.823 $125,689,096 $1,884,208 $1,646,203 $238,005 $125,451,090 22 429,233 UVRs 6,435 UVRs 5,622 UVRs 813 UVRs 428,420 UVRs 23 105.26 0.06% 0.99% $118,932,506 $1,488,322 $1,172,389 $315,933 $118,616,573 23 $292.999 $125,526,616 $1,885,342 $1,644,075 $241,268 $125,285,348 23 428,420 UVRs 6,435 UVRs 5,611 UVRs 823 UVRs 427,597 UVRs 24 105.49 0.22% 1.14% $118,616,573 $1,628,757 $1,354,987 $273,770 $118,342,803 24 $293.630 $125,555,128 $1,889,402 $1,644,448 $244,954 $125,310,174 24 427,597 UVRs 6,435 UVRs 5,600 UVRs 834 UVRs 426,762 UVRs 25 105.99 0.47% 1.40% $118,342,803 $1,873,874 $1,660,779 $213,095 $118,129,709 25 $295.022 $125,904,118 $1,898,358 $1,649,019 $249,339 $125,654,779 25 426,762 UVRs 6,435 UVRs 5,589 UVRs 845 UVRs 425,917 UVRs 26 106.54 0.52% 1.45% $118,129,709 $1,914,616 $1,707,616 $207,000 $117,922,708 26 $296.543 $126,302,871 $1,908,149 $1,654,242 $253,907 $126,048,964 26 425,917 UVRs 6,435 UVRs 5,578 UVRs 856 UVRs 425,061 UVRs 27 105.13 -1.32% -0.41% $117,922,708 $548,886 -$480,621 $1,029,506 $116,893,202 27 $292.628 $124,384,665 $1,882,954 $1,629,118 $253,836 $124,130,829 27 425,061 UVRs 6,435 UVRs 5,567 UVRs 867 UVRs 424,194 UVRs 28 103.21 -1.83% -0.92% $116,893,202 $346,069 -$1,073,318 $1,419,387 $115,473,815 28 $287.283 $121,863,815 $1,848,566 $1,596,102 $252,464 $121,611,351 28 424,194 UVRs 6,435 UVRs 5,556 UVRs 879 UVRs 423,315 UVRs 29 104.04 0.80% 1.74% $115,473,815 $2,163,313 $2,005,346 $157,967 $115,315,848 29 $289.594 $122,589,332 $1,863,432 $1,605,604 $257,828 $122,331,504 29 423,315 UVRs 6,435 UVRs 5,544 UVRs 890 UVRs 422,425 UVRs 30 102.06 -1.90% -1.00% $115,315,848 $325,130 -$1,148,221 $1,473,350 $113,842,497 30 $284.082 $120,003,396 $1,827,968 $1,571,735 $256,234 $119,747,162 30 422,425 UVRs 6,435 UVRs 5,533 UVRs 902 UVRs 421,523 UVRs 31 102.42 0.36% 1.28% $113,842,497 $1,714,966 $1,462,071 $252,895 $113,589,602 31 $285.094 $120,173,462 $1,834,476 $1,573,962 $260,514 $119,912,948 31 421,523 UVRs 6,435 UVRs 5,521 UVRs 914 UVRs 420,609 UVRs 32 102.70 0.27% 1.19% $113,589,602 $1,635,493 $1,356,640 $278,853 $113,310,749 32 $285.855 $120,232,955 $1,839,372 $1,574,741 $264,630 $119,968,325 32 420,609 UVRs 6,435 UVRs 5,509 UVRs 926 UVRs 419,683 UVRs 33 102.89 0.19% 1.12% $113,310,749 $1,569,868 $1,267,125 $302,744 $113,008,005 33 $286.402 $120,198,067 $1,842,894 $1,574,285 $268,610 $119,929,458 33 419,683 UVRs 6,435 UVRs 5,497 UVRs 938 UVRs 418,745 UVRs 34 103.08 0.18% 1.10% $113,008,005 $1,558,444 $1,248,542 $309,902 $112,698,104 34 $286.912 $120,143,146 $1,846,178 $1,573,565 $272,612 $119,870,533 34 418,745 UVRs 6,435 UVRs 5,484 UVRs 950 UVRs 417,795 UVRs 35 103.24 0.16% 1.08% $112,698,104 $1,541,682 $1,222,689 $318,994 $112,379,110 35 $287.367 $120,060,478 $1,849,103 $1,572,482 $276,621 $119,783,857 35 417,795 UVRs 6,435 UVRs 5,472 UVRs 963 UVRs 416,832 UVRs 36 103.41 0.16% 1.09% $112,379,110 $1,546,924 $1,226,267 $320,657 $112,058,453 36 $287.840 $119,981,099 $1,852,148 $1,571,443 $280,705 $119,700,394 36 416,832 UVRs 6,435 UVRs 5,459 UVRs 975 UVRs 415,857 UVRs 37 105.34 1.87% 2.81% $112,058,453 $3,210,139 $3,150,943 $59,196 $111,999,257 37 $293.222 $121,938,289 $1,886,775 $1,597,077 $289,698 $121,648,591 37 415,857 UVRs 6,435 UVRs 5,447 UVRs 988 UVRs 414,869 UVRs 38 105.10 -0.23% 0.69% $111,999,257 $1,236,024 $774,892 $461,132 $111,538,125 38 $292.544 $121,367,594 $1,882,417 $1,589,602 $292,815 $121,074,779 38 414,869 UVRs 6,435 UVRs 5,434 UVRs 1,001 UVRs 413,868 UVRs 39 104.97 -0.13% 0.80% $111,538,125 $1,314,847 $888,918 $425,929 $111,112,196 39 $292.173 $120,921,180 $1,880,029 $1,583,755 $296,274 $120,624,906 39 413,868 UVRs 6,435 UVRs 5,421 UVRs 1,014 UVRs 412,854 UVRs 40 105.07 0.10% 1.03% $111,112,196 $1,495,566 $1,141,744 $353,822 $110,758,374 40 $292.470 $120,747,485 $1,881,939 $1,581,480 $300,459 $120,447,026 40 412,854 UVRs 6,435 UVRs 5,407 UVRs 1,027 UVRs 411,827 UVRs 41 105.16 0.08% 1.01% $110,758,374 $1,480,066 $1,116,716 $363,350 $110,395,023 41 $292.711 $120,546,373 $1,883,492 $1,578,846 $304,645 $120,241,728 41 411,827 UVRs 6,435 UVRs 5,394 UVRs 1,041 UVRs 410,786 UVRs 42 105.20 0.04% 0.96% $110,395,023 $1,444,555 $1,063,534 $381,021 $110,014,002 42 $292.823 $120,287,465 $1,884,208 $1,575,455 $308,753 $119,978,712 42 410,786 UVRs 6,435 UVRs 5,380 UVRs 1,054 UVRs 409,732 UVRs 43 105.26 0.06% 0.99% $110,014,002 $1,462,119 $1,084,474 $377,645 $109,636,357 43 $292.999 $120,050,942 $1,885,342 $1,572,358 $312,985 $119,737,958 43 409,732 UVRs 6,435 UVRs 5,366 UVRs 1,068 UVRs 408,664 UVRs 44 105.49 0.22% 1.14% $109,636,357 $1,587,238 $1,252,403 $334,835 $109,301,523 44 $293.630 $119,995,793 $1,889,402 $1,571,635 $317,767 $119,678,026 44 408,664 UVRs 6,435 UVRs 5,352 UVRs 1,082 UVRs 407,581 UVRs 45 105.99 0.47% 1.40% $109,301,523 $1,805,163 $1,533,897 $271,266 $109,030,256 45 $295.022 $120,245,274 $1,898,358 $1,574,903 $323,455 $119,921,819 45 407,581 UVRs 6,435 UVRs 5,338 UVRs 1,096 UVRs 406,485 UVRs 46 106.54 0.52% 1.45% $109,030,256 $1,841,347 $1,576,079 $265,268 $108,764,989 46 $296.543 $120,540,342 $1,908,149 $1,578,767 $329,381 $120,210,961 46 406,485 UVRs 6,435 UVRs 5,324 UVRs 1,111 UVRs 405,374 UVRs 47 100.59 -5.58% -4.71% $108,764,989 $8,035 -$5,117,694 $5,125,729 $103,639,260 47 $280.000 $113,504,783 $1,801,699 $1,486,620 $315,080 $113,189,704 47 405,374 UVRs 6,435 UVRs 5,309 UVRs 1,125 UVRs 404,249 UVRs 48 101.13 0.54% 1.47% $103,639,260 $1,776,275 $1,520,160 $256,114 $103,383,145 48 $281.503 $113,797,323 $1,811,371 $1,490,451 $320,920 $113,476,403 48 404,249 UVRs 6,435 UVRs 5,295 UVRs 1,140 UVRs 403,109 UVRs 49 101.64 0.50% 1.43% $103,383,145 $1,746,909 $1,479,023 $267,886 $103,115,259 49 $282.913 $114,044,907 $1,820,446 $1,493,694 $326,752 $113,718,155 49 403,109 UVRs 6,435 UVRs 5,280 UVRs 1,155 UVRs 401,954 UVRs 50 102.06 0.41% 1.34% $103,115,259 $1,676,185 $1,383,854 $292,332 $102,822,928 50 $284.082 $114,188,065 $1,827,968 $1,495,569 $332,399 $113,855,665 50 401,954 UVRs 6,435 UVRs 5,265 UVRs 1,170 UVRs 400,784 UVRs 51 102.42 0.36% 1.28% $102,822,928 $1,630,987 $1,320,547 $310,440 $102,512,488 51 $285.094 $114,260,991 $1,834,476 $1,496,524 $337,952 $113,923,040 51 400,784 UVRs 6,435 UVRs 5,249 UVRs 1,185 UVRs 399,598 UVRs 52 102.70 0.27% 1.19% $102,512,488 $1,562,054 $1,224,342 $337,712 $102,174,776 52 $285.855 $114,227,062 $1,839,372 $1,496,080 $343,292 $113,883,770 52 399,598 UVRs 6,435 UVRs 5,234 UVRs 1,201 UVRs 398,398 UVRs 53 103.24 0.53% 1.46% $102,174,776 $1,767,503 $1,490,689 $276,814 $101,897,962 53 $287.367 $114,486,290 $1,849,103 $1,499,475 $349,628 $114,136,662 53 398,398 UVRs 6,435 UVRs 5,218 UVRs 1,217 UVRs 397,181 UVRs 54 103.41 0.16% 1.09% $101,897,962 $1,486,507 $1,111,898 $374,609 $101,523,353 54 $287.840 $114,324,605 $1,852,148 $1,497,357 $354,791 $113,969,815 54 397,181 UVRs 6,435 UVRs 5,202 UVRs 1,233 UVRs 395,948 UVRs 55 105.34 1.87% 2.81% $101,523,353 $2,944,144 $2,854,709 $89,435 $101,433,918 55 $293.222 $116,100,572 $1,886,775 $1,520,618 $366,157 $115,734,415 55 395,948 UVRs 6,435 UVRs 5,186 UVRs 1,249 UVRs 394,700 UVRs 56 105.10 -0.23% 0.69% $101,433,918 $1,214,963 $701,793 $513,170 $100,920,749 56 $292.544 $115,467,079 $1,882,417 $1,512,321 $370,096 $115,096,983 56 394,700 UVRs 6,435 UVRs 5,170 UVRs 1,265 UVRs 393,434 UVRs 57 104.97 -0.13% 0.80% $100,920,749 $1,284,199 $804,301 $479,898 $100,440,851 57 $292.173 $114,950,967 $1,880,029 $1,505,561 $374,468 $114,576,49957 393,434 UVRs 6,435 UVRs 5,153 UVRs 1,282 UVRs 392,153 UVRs 58 105.07 0.10% 1.03% $100,440,851 $1,442,229 $1,032,090 $410,139 $100,030,712 58 $292.470 $114,692,931 $1,881,939 $1,502,181 $379,758 $114,313,173 58 392,153 UVRs 6,435 UVRs 5,136 UVRs 1,298 UVRs 390,854 UVRs 59 105.16 0.08% 1.01% $100,030,712 $1,428,712 $1,008,555 $420,157 $99,610,555 59 $292.711 $114,407,461 $1,883,492 $1,498,443 $385,049 $114,022,412 59 390,854 UVRs 6,435 UVRs 5,119 UVRs 1,315 UVRs 389,539 UVRs 60 102.70 -2.34% -1.44% $99,610,555 $300,048 -$1,433,525 $1,733,573 $97,876,982 60 $285.855 $111,351,480 $1,839,372 $1,458,417 $380,955 $110,970,525 60 389,539 UVRs 6,435 UVRs 5,102 UVRs 1,333 UVRs 388,206 UVRs 61 103.24 0.53% 1.46% $97,876,982 $1,732,685 $1,427,986 $304,699 $97,572,283 61 $287.367 $111,557,633 $1,849,103 $1,461,117 $387,986 $111,169,647 61 388,206 UVRs 6,435 UVRs 5,084 UVRs 1,350 UVRs 386,856 UVRs 62 103.41 0.16% 1.09% $97,572,283 $1,468,271 $1,064,697 $403,574 $97,168,709 62 $287.840 $111,352,704 $1,852,148 $1,458,433 $393,715 $110,958,989 62 386,856 UVRs 6,435 UVRs 5,067 UVRs 1,368 UVRs 385,488 UVRs 63 105.34 1.87% 2.81% $97,168,709 $2,839,959 $2,732,262 $107,697 $97,061,011 63 $293.222 $113,033,457 $1,886,775 $1,480,447 $406,329 $112,627,129 63 385,488 UVRs 6,435 UVRs 5,049 UVRs 1,386 UVRs 384,102 UVRs 64 105.10 -0.23% 0.69% $97,061,011 $1,212,879 $671,539 $541,341 $96,519,670 64 $292.544 $112,366,970 $1,882,417 $1,471,717 $410,700 $111,956,271 64 384,102 UVRs 6,435 UVRs 5,031 UVRs 1,404 UVRs 382,699 UVRs 65 104.97 -0.13% 0.80% $96,519,670 $1,278,199 $769,226 $508,973 $96,010,698 65 $292.173 $111,814,239 $1,880,029 $1,464,478 $415,551 $111,398,688 65 382,699 UVRs 6,435 UVRs 5,012 UVRs 1,422 UVRs 381,276 UVRs 66 105.07 0.10% 1.03% $96,010,698 $1,426,941 $986,567 $440,374 $95,570,323 66 $292.470 $111,511,891 $1,881,939 $1,460,518 $421,421 $111,090,470 66 381,276 UVRs 6,435 UVRs 4,994 UVRs 1,441 UVRs 379,835 UVRs 67 105.16 0.08% 1.01% $95,570,323 $1,414,238 $963,583 $450,655 $95,119,668 67 $292.711 $111,182,099 $1,883,492 $1,456,199 $427,293 $110,754,806 67 379,835 UVRs 6,435 UVRs 4,975 UVRs 1,460 UVRs 378,376 UVRs 68 102.70 -2.34% -1.44% $95,119,668 $330,250 -$1,368,896 $1,699,145 $93,420,523 68 $285.855 $108,160,417 $1,839,372 $1,416,622 $422,749 $107,737,668 68 378,376 UVRs 6,435 UVRs 4,956 UVRs 1,479 UVRs 376,897 UVRs 69 103.24 0.53% 1.46% $93,420,523 $1,698,313 $1,362,968 $335,345 $93,085,177 69 $287.367 $108,307,671 $1,849,103 $1,418,551 $430,552 $107,877,119 69 376,897 UVRs 6,435 UVRs 4,936 UVRs 1,498 UVRs 375,398 UVRs 70 103.41 0.16% 1.09% $93,085,177 $1,450,623 $1,015,734 $434,889 $92,650,289 70 $287.840 $108,054,755 $1,852,148 $1,415,238 $436,909 $107,617,845 70 375,398 UVRs 6,435 UVRs 4,917 UVRs 1,518 UVRs 373,881 UVRs 71 105.34 1.87% 2.81% $92,650,289 $2,734,672 $2,605,210 $129,463 $92,520,826 71 $293.222 $109,629,848 $1,886,775 $1,435,868 $450,907 $109,178,940 71 373,881 UVRs 6,435 UVRs 4,897 UVRs 1,538 UVRs 372,343 UVRs 72 105.10 -0.23% 0.69% $92,520,826 $1,211,529 $640,126 $571,403 $91,949,423 72 $292.544 $108,926,747 $1,882,417 $1,426,659 $455,758 $108,470,990 72 372,343 UVRs 6,435 UVRs 4,877 UVRs 1,558 UVRs 370,785 UVRs 73 104.97 -0.13% 0.80% $91,949,423 $1,272,896 $732,803 $540,093 $91,409,330 73 $292.173 $108,333,380 $1,880,029 $1,418,888 $461,141 $107,872,238 73 370,785 UVRs 6,435 UVRs 4,856 UVRs 1,578 UVRs 369,207 UVRs 74 105.07 0.10% 1.03% $91,409,330 $1,412,279 $939,285 $472,994 $90,936,337 74 $292.470 $107,981,858 $1,881,939 $1,414,284 $467,656 $107,514,202 74 369,207 UVRs 6,435 UVRs 4,836 UVRs 1,599 UVRs 367,608 UVRs 75 105.16 0.08% 1.01% $90,936,337 $1,400,395 $916,861 $483,534 $90,452,802 75 $292.711 $107,602,882 $1,883,492 $1,409,320 $474,172 $107,128,710 75 367,608 UVRs 6,435 UVRs 4,815 UVRs 1,620 UVRs 365,988 UVRs 76 107.15 1.90% 2.84% $90,452,802 $2,710,623 $2,567,103 $143,520 $90,309,282 76 $298.260 $109,159,361 $1,919,194 $1,429,706 $489,488 $108,669,873 76 365,988 UVRs 6,435 UVRs 4,793 UVRs 1,641 UVRs 364,347 UVRs 77 107.34 0.18% 1.11% $90,309,282 $1,465,144 $997,920 $467,224 $89,842,058 77 $298.792 $108,863,689 $1,922,617 $1,425,833 $496,783 $108,366,906 77 364,347 UVRs 6,435 UVRs 4,772 UVRs 1,663 UVRs 362,684 UVRs 78 107.42 0.07% 1.00% $89,842,058 $1,398,437 $894,235 $504,203 $89,337,855 78 $299.000 $108,442,433 $1,923,957 $1,420,316 $503,641 $107,938,793 78 362,684 UVRs 6,435 UVRs 4,750 UVRs 1,684 UVRs 360,999 UVRs 79 107.31 -0.11% 0.82% $89,337,855 $1,295,026 $731,040 $563,987 $88,773,869 79 $298.684 $107,824,663 $1,921,922 $1,412,225 $509,697 $107,314,966 79 360,999 UVRs 6,435 UVRs 4,728 UVRs 1,706 UVRs 359,293 UVRs 80 107.36 0.05% 0.97% $88,773,869 $1,384,262 $863,559 $520,703 $88,253,166 80 $298.825 $107,365,752 $1,922,832 $1,406,214 $516,618 $106,849,134 80 359,293 UVRs 6,435 UVRs 4,706 UVRs 1,729 UVRs 357,564 UVRs 81 107.36 0.00% 0.93% $88,253,166 $1,358,722 $819,665 $539,057 $87,714,109 81 $298.836 $106,853,121 $1,922,904 $1,399,500 $523,403 $106,329,718 81 357,564 UVRs 6,435 UVRs 4,683 UVRs 1,751 UVRs 355,813 UVRs 82 107.34 -0.02% 0.91% $87,714,109 $1,346,043 $795,196 $550,847 $87,163,262 82 $298.782 $106,310,308 $1,922,553 $1,392,391 $530,162 $105,780,146 82 355,813 UVRs 6,435 UVRs 4,660 UVRs 1,774 UVRs 354,038 UVRs 83 104.73 -2.43% -1.53% $87,163,262 $378,245 -$1,331,437 $1,709,681 $85,453,581 83 $291.521 $103,209,643 $1,875,834 $1,351,780 $524,054 $102,685,590 83 354,038 UVRs 6,435 UVRs 4,637 UVRs 1,798 UVRs 352,241 UVRs 84 104.86 0.12% 1.05% $85,453,581 $1,406,348 $893,731 $512,617 $84,940,964 84 $291.870 $102,808,566 $1,878,080 $1,346,527 $531,553 $102,277,012 84 352,241 UVRs 6,435 UVRs 4,613 UVRs 1,821 UVRs 350,419 UVRs 85 104.97 0.11% 1.03% $84,940,964 $1,399,436 $877,977 $521,459 $84,419,505 85 $292.184 $102,387,099 $1,880,102 $1,341,007 $539,095 $101,848,004 85 350,419 UVRs 6,435 UVRs 4,590 UVRs 1,845 UVRs 348,574 UVRs 86 105.07 0.10% 1.02% $84,419,505 $1,392,960 $862,802 $530,158 $83,889,346 86 $292.465 $101,945,933 $1,881,910 $1,335,229 $546,681 $101,399,252 86 348,574 UVRs 6,435 UVRs 4,565 UVRs 1,869 UVRs 346,705 UVRs 87 105.16 0.09% 1.01% $83,889,346 $1,387,776 $849,515 $538,261 $83,351,085 87 $292.719 $101,487,325 $1,883,544 $1,329,222 $554,322 $100,933,003 87 346,705 UVRs 6,435 UVRs 4,541 UVRs 1,894 UVRs 344,811 UVRs 88 105.25 0.08% 1.00% $83,351,085 $1,383,407 $837,405 $546,001 $82,805,084 88 $292.950 $101,012,682 $1,885,031 $1,323,005 $562,026 $100,450,656 88 344,811 UVRs 6,435 UVRs 4,516 UVRs 1,919 UVRs 342,893 UVRs 89 105.32 0.07% 1.00% $82,805,084 $1,380,379 $827,288 $553,090 $82,251,993 89 $293.165 $100,524,387 $1,886,415 $1,316,610 $569,805 $99,954,583 89 342,893 UVRs 6,435 UVRs 4,491 UVRs 1,944 UVRs 340,949 UVRs 90 105.40 0.07% 1.00% $82,251,993 $1,378,491 $818,866 $559,625 $81,692,368 90 $293.370 $100,024,461 $1,887,733 $1,310,062 $577,671 $99,446,790 90 340,949 UVRs 6,435 UVRs 4,466 UVRs 1,969 UVRs 338,980 UVRs 91 105.47 0.07% 0.99% $81,692,368 $1,376,775 $810,654 $566,122 $81,126,246 91 $293.566 $99,513,129 $1,888,993 $1,303,365 $585,627 $98,927,502 91 338,980 UVRs 6,435 UVRs 4,440 UVRs 1,995 UVRs 336,985 UVRs 92 105.53 0.06% 0.99% $81,126,246 $1,375,334 $802,811 $572,523 $80,553,723 92 $293.754 $98,990,806 $1,890,201 $1,296,524 $593,677 $98,397,128 92 336,985 UVRs 6,435 UVRs 4,414 UVRs 2,021 UVRs 334,964 UVRs 93 105.60 0.06% 0.99% $80,553,723 $1,373,767 $794,719 $579,047 $79,974,676 93 $293.933 $98,457,157 $1,891,355 $1,289,535 $601,820 $97,855,337 93 334,964 UVRs 6,435 UVRs 4,387 UVRs 2,047 UVRs 332,917 UVRs 94 105.66 0.06% 0.98% $79,974,676 $1,372,022 $786,299 $585,724 $79,388,952 94 $294.103 $97,911,751 $1,892,445 $1,282,391 $610,054 $97,301,698 94 332,917 UVRs 6,435 UVRs 4,360 UVRs 2,074 UVRs 330,843 UVRs 95 105.71 0.05% 0.98% $79,388,952 $1,368,920 $775,708 $593,212 $78,795,740 95 $294.254 $97,351,925 $1,893,422 $1,275,059 $618,363 $96,733,56295 330,843 UVRs 6,435 UVRs 4,333 UVRs 2,101 UVRs 328,741 UVRs 96 104.73 -0.93% -0.01% $78,795,740 $922,036 -$9,848 $931,883 $77,863,857 96 $291.521 $95,834,999 $1,875,834 $1,255,191 $620,643 $95,214,356 96 328,741 UVRs 6,435 UVRs 4,306 UVRs 2,129 UVRs 326,612 UVRs 97 104.86 0.12% 1.05% $77,863,857 $1,397,534 $814,353 $583,181 $77,280,676 97 $291.870 $95,328,385 $1,878,080 $1,248,556 $629,524 $94,698,861 97 326,612 UVRs 6,435 UVRs 4,278 UVRs 2,157 UVRs 324,455 UVRs 98 104.97 0.11% 1.03% $77,280,676 $1,391,432 $798,797 $592,635 $76,688,041 98 $292.184 $94,800,791 $1,880,102 $1,241,646 $638,456 $94,162,335 98 324,455 UVRs 6,435 UVRs 4,250 UVRs 2,185 UVRs 322,270 UVRs 99 105.07 0.10% 1.02% $76,688,041 $1,385,723 $783,783 $601,940 $76,086,101 99 $292.465 $94,252,873 $1,881,910 $1,234,469 $647,440 $93,605,433 99 322,270 UVRs 6,435 UVRs 4,221 UVRs 2,214 UVRs 320,056 UVRs 100 105.16 0.09% 1.01% $76,086,101 $1,381,159 $770,494 $610,665 $75,475,436 100 $292.719 $93,686,737 $1,883,544 $1,227,055 $656,490 $93,030,247 100 320,056 UVRs 6,435 UVRs 4,192 UVRs 2,243 UVRs 317,814 UVRs 101 105.25 0.08% 1.00% $75,475,436 $1,377,319 $758,281 $619,038 $74,856,398 101 $292.950 $93,103,687 $1,885,031 $1,219,418 $665,613 $92,438,074 101 317,814 UVRs 6,435 UVRs 4,163 UVRs 2,272 UVRs 315,542 UVRs 102 105.32 0.07% 1.00% $74,856,398 $1,374,662 $747,875 $626,787 $74,229,611 102 $293.165 $92,505,924 $1,886,415 $1,211,589 $674,826 $91,831,098 102 315,542 UVRs 6,435 UVRs 4,133 UVRs 2,302 UVRs 313,240 UVRs 103 105.40 0.07% 1.00% $74,229,611 $1,373,008 $738,998 $634,010 $73,595,601 103 $293.370 $91,895,298 $1,887,733 $1,203,591 $684,142 $91,211,156 103 313,240 UVRs 6,435 UVRs 4,103 UVRs 2,332 UVRs 310,908 UVRs 104 105.47 0.07% 0.99% $73,595,601 $1,371,508 $730,307 $641,201 $72,954,400 104 $293.566 $91,272,001 $1,888,993 $1,195,428 $693,565 $90,578,436 104 310,908 UVRs 6,435 UVRs 4,072 UVRs 2,363 UVRs 308,545 UVRs 105 105.53 0.06% 0.99% $72,954,400 $1,370,250 $721,944 $648,306 $72,306,095 105 $293.754 $90,636,397 $1,890,201 $1,187,103 $703,099 $89,933,299 105 308,545 UVRs 6,435 UVRs 4,041 UVRs 2,393 UVRs 306,152 UVRs 106 105.60 0.06% 0.99% $72,306,095 $1,368,884 $713,351 $655,534 $71,650,561 106 $293.933 $89,988,164 $1,891,355 $1,178,613 $712,742 $89,275,422 106 306,152 UVRs 6,435 UVRs 4,010 UVRs 2,425 UVRs 303,727 UVRs 107 105.66 0.06% 0.98% $71,650,561 $1,367,367 $704,457 $662,910 $70,987,651 107 $294.103 $89,326,890 $1,892,445 $1,169,952 $722,493 $88,604,397 107 303,727 UVRs 6,435 UVRs 3,978 UVRs 2,457 UVRs 301,270 UVRs 108 105.71 0.05% 0.98% $70,987,651 $1,364,674 $693,619 $671,056 $70,316,596 108 $294.254 $88,650,135 $1,893,422 $1,161,088 $732,334 $87,917,801 108 301,270 UVRs 6,435 UVRs 3,946 UVRs 2,489 UVRs 298,782 UVRs 109 107.15 1.36% 2.30% $70,316,596 $2,007,155 $1,616,379 $390,776 $69,925,820 109 $298.260 $89,114,473 $1,919,194 $1,167,170 $752,024 $88,362,449 109 298,782 UVRs 6,435 UVRs 3,913 UVRs 2,521 UVRs 296,260 UVRs 110 107.34 0.18% 1.11% $69,925,820 $1,426,381 $772,682 $653,699 $69,272,121 110 $298.792 $88,520,046 $1,922,617 $1,159,384 $763,232 $87,756,813 110 296,260 UVRs 6,435 UVRs 3,880 UVRs 2,554 UVRs 293,706 UVRs 111 107.42 0.07% 1.00% $69,272,121 $1,378,785 $689,494 $689,291 $68,582,829 111 $299.000 $87,817,976 $1,923,957 $1,150,189 $773,768 $87,044,208 111 293,706 UVRs 6,435 UVRs 3,847 UVRs 2,588 UVRs 291,118 UVRs 112 107.31 -0.11% 0.82% $68,582,829 $1,304,778 $561,204 $743,574 $67,839,256 112 $298.684 $86,952,172 $1,921,922 $1,138,849 $783,073 $86,169,098 112 291,118 UVRs 6,435 UVRs 3,813 UVRs 2,622 UVRs 288,496 UVRs 113 107.36 0.05% 0.97% $67,839,256 $1,368,380 $659,915 $708,465 $67,130,790 113 $298.825 $86,209,878 $1,922,832 $1,129,127 $793,705 $85,416,173 113 288,496 UVRs 6,435 UVRs 3,779 UVRs 2,656 UVRs 285,840 UVRs 114 107.36 0.00% 0.93% $67,130,790 $1,350,320 $623,488 $726,832 $66,403,958 114 $298.836 $85,419,360 $1,922,904 $1,118,773 $804,130 $84,615,229 114 285,840 UVRs 6,435 UVRs 3,744 UVRs 2,691 UVRs 283,149 UVRs 115 107.34 -0.02% 0.91% $66,403,958 $1,341,382 $602,003 $739,379 $65,664,579 115 $298.782 $84,599,783 $1,922,553 $1,108,039 $814,514 $83,785,270 115 283,149 UVRs 6,435 UVRs 3,709 UVRs 2,726 UVRs 280,423 UVRs 116 107.34 0.00% 0.92% $65,664,579 $1,348,702 $607,397 $741,305 $64,923,274 116 $298.782 $83,785,270 $1,922,553 $1,097,371 $825,182 $82,960,088 116 280,423 UVRs 6,435 UVRs 3,673 UVRs 2,762 UVRs 277,661 UVRs 117 107.15 -0.17% 0.75% $64,923,274 $1,280,513 $486,064 $794,450 $64,128,824 117 $298.260 $82,815,148 $1,919,194 $1,084,665 $834,529 $81,980,619 117 277,661 UVRs 6,435 UVRs 3,637 UVRs 2,798 UVRs 274,863 UVRs 118 107.34 0.18% 1.11% $64,128,824 $1,418,405 $708,625 $709,780 $63,419,044 118 $298.792 $82,126,834 $1,922,617 $1,075,650 $846,967 $81,279,867 118 274,863 UVRs 6,435 UVRs 3,600 UVRs 2,835 UVRs 272,029 UVRs 119 107.42 0.07% 1.00% $63,419,044 $1,375,688 $631,236 $744,452 $62,674,592 119 $299.000 $81,336,516 $1,923,957 $1,065,298 $858,658 $80,477,858 119 272,029 UVRs 6,435 UVRs 3,563 UVRs 2,872 UVRs 269,157 UVRs 120 107.31 -0.11% 0.82% $62,674,592 $1,309,238 $512,858 $796,381 $61,878,211 120 $298.684 $80,392,764 $1,921,922 $1,052,938 $868,985 $79,523,779 120 269,157 UVRs 6,435 UVRs 3,525 UVRs 2,909 UVRs 266,247 UVRs 121 107.36 0.05% 0.97% $61,878,211 $1,366,248 $601,928 $764,320 $61,113,891 121 $298.825 $79,561,414 $1,922,832 $1,042,049 $880,783 $78,680,631 121 266,247 UVRs 6,435 UVRs 3,487 UVRs 2,947 UVRs 263,300 UVRs 122 107.36 0.00% 0.93% $61,113,891 $1,350,106 $567,605 $782,502 $60,331,389 122 $298.836 $78,683,566 $1,922,904 $1,030,552 $892,352 $77,791,215 122 263,300 UVRs 6,435 UVRs 3,449 UVRs 2,986 UVRs 260,314 UVRs 123 107.34 -0.02% 0.91% $60,331,389 $1,342,130 $546,951 $795,179 $59,536,210 123 $298.782 $77,777,014 $1,922,553 $1,018,678 $903,874 $76,873,140 123 260,314 UVRs 6,435 UVRs 3,409 UVRs 3,025 UVRs 257,289 UVRs 124 104.73 -2.43% -1.53% $59,536,210 $647,440 -$909,428 $1,556,868 $57,979,342 124 $291.521 $75,005,090 $1,875,834 $982,373 $893,461 $74,111,629 124 257,289 UVRs 6,435 UVRs 3,370 UVRs 3,065 UVRs 254,224 UVRs 125 104.86 0.12% 1.05% $57,979,342 $1,373,221 $606,387 $766,834 $57,212,509 125 $291.870 $74,200,385 $1,878,080 $971,834 $906,247 $73,294,139 125 254,224 UVRs 6,435 UVRs 3,330 UVRs 3,105 UVRs 251,119 UVRs 126 104.97 0.11% 1.03% $57,212,509 $1,369,002 $591,367 $777,636 $56,434,873 126 $292.184 $73,373,029 $1,880,102 $960,997 $919,104 $72,453,925 126 251,119 UVRs 6,435 UVRs 3,289 UVRs 3,146 UVRs 247,973 UVRs 127 105.07 0.10% 1.02% $56,434,873 $1,365,077 $576,788 $788,289 $55,646,584 127 $292.465 $72,523,591 $1,881,910 $949,872 $932,038 $71,591,553 127 247,973 UVRs 6,435 UVRs 3,248 UVRs 3,187 UVRs 244,786 UVRs 128 105.16 0.09% 1.01% $55,646,584 $1,361,957 $563,511 $798,446 $54,848,138 128 $292.719 $71,653,736 $1,883,544 $938,479 $945,065 $70,708,671 128 244,786 UVRs 6,435 UVRs 3,206 UVRs 3,229 UVRs 241,558 UVRs 129 105.25 0.08% 1.00% $54,848,138 $1,359,347 $551,044 $808,303 $54,039,835 129 $292.950 $70,764,490 $1,885,031 $926,832 $958,199 $69,806,291 129 241,558 UVRs 6,435 UVRs 3,164 UVRs 3,271 UVRs 238,287 UVRs 130 105.32 0.07% 1.00% $54,039,835 $1,357,553 $539,901 $817,652 $53,222,183 130 $293.165 $69,857,529 $1,886,415 $914,953 $971,461 $68,886,068 130 238,287 UVRs 6,435 UVRs 3,121 UVRs 3,314 UVRs 234,973 UVRs 131 105.40 0.07% 1.00% $53,222,183 $1,356,444 $529,857 $826,587 $52,395,596 131 $293.370 $68,934,226 $1,887,733 $902,860 $984,873 $67,949,353 131 234,973 UVRs 6,435 UVRs 3,078 UVRs 3,357 UVRs 231,616 UVRs 132 105.47 0.07% 0.99% $52,395,596 $1,355,444 $519,935 $835,510 $51,560,087 132 $293.566 $67,994,681 $1,888,993 $890,555 $998,438 $66,996,243 132 231,616 UVRs 6,435 UVRs 3,034 UVRs 3,401 UVRs 228,215 UVRs 133 105.53 0.06% 0.99% $51,560,087 $1,354,612 $510,230 $844,383 $50,715,704 133 $293.754 $67,039,114 $1,890,201 $878,039 $1,012,162 $66,026,952 133 228,215 UVRs6,435 UVRs 2,989 UVRs 3,446 UVRs 224,770 UVRs 134 105.60 0.06% 0.99% $50,715,704 $1,353,716 $500,346 $853,370 $49,862,334 134 $293.933 $66,067,233 $1,891,355 $865,310 $1,026,044 $65,041,188 134 224,770 UVRs 6,435 UVRs 2,944 UVRs 3,491 UVRs 221,279 UVRs 135 105.66 0.06% 0.98% $49,862,334 $1,352,728 $490,239 $862,489 $48,999,845 135 $294.103 $65,078,685 $1,892,445 $852,363 $1,040,082 $64,038,603 135 221,279 UVRs 6,435 UVRs 2,898 UVRs 3,536 UVRs 217,742 UVRs 136 105.71 0.05% 0.98% $48,999,845 $1,350,987 $478,776 $872,211 $48,127,635 136 $294.254 $64,071,660 $1,893,422 $839,173 $1,054,248 $63,017,412 136 217,742 UVRs 6,435 UVRs 2,852 UVRs 3,583 UVRs 214,160 UVRs 137 105.76 0.04% 0.97% $48,127,635 $1,347,642 $464,503 $883,139 $47,244,495 137 $294.372 $63,042,480 $1,894,175 $825,694 $1,068,481 $61,973,999 137 214,160 UVRs 6,435 UVRs 2,805 UVRs 3,630 UVRs 210,530 UVRs 138 105.78 0.02% 0.95% $47,244,495 $1,343,406 $448,668 $894,739 $46,349,757 138 $294.444 $61,989,149 $1,894,638 $811,898 $1,082,740 $60,906,408 138 210,530 UVRs 6,435 UVRs 2,757 UVRs 3,677 UVRs 206,853 UVRs 139 105.79 0.01% 0.94% $46,349,757 $1,339,841 $433,993 $905,848 $45,443,908 139 $294.477 $60,913,254 $1,894,851 $797,806 $1,097,045 $59,816,209 139 206,853 UVRs 6,435 UVRs 2,709 UVRs 3,725 UVRs 203,127 UVRs 140 105.80 0.01% 0.93% $45,443,908 $1,338,873 $423,827 $915,045 $44,528,863 140 $294.499 $59,820,736 $1,894,994 $783,497 $1,111,497 $58,709,239 140 203,127 UVRs 6,435 UVRs 2,660 UVRs 3,774 UVRs 199,353 UVRs 141 105.82 0.01% 0.94% $44,528,863 $1,340,311 $417,799 $922,512 $43,606,351 141 $294.538 $58,716,955 $1,895,244 $769,041 $1,126,203 $57,590,752 141 199,353 UVRs 6,435 UVRs 2,611 UVRs 3,824 UVRs 195,529 UVRs 142 105.84 0.02% 0.95% $43,606,351 $1,342,169 $412,384 $929,785 $42,676,566 142 $294.598 $57,602,563 $1,895,632 $754,445 $1,141,187 $56,461,376 142 195,529 UVRs 6,435 UVRs 2,561 UVRs 3,874 UVRs 191,656 UVRs 143 105.86 0.02% 0.95% $42,676,566 $1,343,263 $405,501 $937,761 $41,738,804 143 $294.671 $56,475,459 $1,896,105 $739,683 $1,156,422 $55,319,037 143 191,656 UVRs 6,435 UVRs 2,510 UVRs 3,924 UVRs 187,731 UVRs 144 105.89 0.02% 0.95% $41,738,804 $1,342,708 $395,621 $947,088 $40,791,717 144 $294.738 $55,331,560 $1,896,534 $724,701 $1,171,834 $54,159,727 144 187,731 UVRs 6,435 UVRs 2,459 UVRs 3,976 UVRs 183,755 UVRs 145 105.91 0.02% 0.95% $40,791,717 $1,342,286 $385,903 $956,383 $39,835,333 145 $294.800 $54,171,013 $1,896,930 $709,501 $1,187,429 $52,983,584 145 183,755 UVRs 6,435 UVRs 2,407 UVRs 4,028 UVRs 179,727 UVRs 146 105.93 0.02% 0.95% $39,835,333 $1,342,168 $376,647 $965,521 $38,869,813 146 $294.860 $52,994,352 $1,897,315 $694,089 $1,203,226 $51,791,126 146 179,727 UVRs 6,435 UVRs 2,354 UVRs 4,081 UVRs 175,647 UVRs 147 105.95 0.02% 0.94% $38,869,813 $1,341,900 $367,047 $974,853 $37,894,960 147 $294.916 $51,801,030 $1,897,678 $678,460 $1,219,218 $50,581,812 147 175,647 UVRs 6,435 UVRs 2,301 UVRs 4,134 UVRs 171,513 UVRs 148 105.97 0.01% 0.94% $37,894,960 $1,340,621 $355,582 $985,038 $36,909,921 148 $294.955 $50,588,496 $1,897,929 $662,579 $1,235,350 $49,353,146 148 171,513 UVRs 6,435 UVRs 2,246 UVRs 4,188 UVRs 167,324 UVRs 149 105.97 -0.00% 0.92% $36,909,921 $1,337,697 $341,162 $996,535 $35,913,386 149 $294.953 $49,352,808 $1,897,916 $646,394 $1,251,521 $48,101,287 149 167,324 UVRs 6,435 UVRs 2,192 UVRs 4,243 UVRs 163,081 UVRs 150 105.95 -0.02% 0.91% $35,913,386 $1,334,502 $326,277 $1,008,226 $34,905,160 150 $294.905 $48,093,428 $1,897,606 $629,900 $1,267,706 $46,825,722 150 163,081 UVRs 6,435 UVRs 2,136 UVRs 4,299 UVRs 158,783 UVRs 151 105.95 0.00% 0.93% $34,905,160 $1,338,493 $324,215 $1,014,277 $33,890,883 151 $294.916 $46,827,507 $1,897,678 $613,320 $1,284,358 $45,543,148 151 158,783 UVRs 6,435 UVRs 2,080 UVRs 4,355 UVRs 154,428 UVRs 152 105.95 -0.00% 0.92% $33,890,883 $1,337,029 $312,187 $1,024,842 $32,866,042 152 $294.905 $45,541,413 $1,897,606 $596,475 $1,301,131 $44,240,282 152 154,428 UVRs 6,435 UVRs 2,023 UVRs 4,412 UVRs 150,016 UVRs 153 105.89 -0.06% 0.87% $32,866,042 $1,327,265 $285,286 $1,041,979 $31,824,063 153 $294.738 $44,215,308 $1,896,534 $579,106 $1,317,428 $42,897,880 153 150,016 UVRs 6,435 UVRs 1,965 UVRs 4,470 UVRs 145,546 UVRs 154 105.95 0.06% 0.98% $31,824,063 $1,347,567 $312,514 $1,035,053 $30,789,010 154 $294.905 $42,922,110 $1,897,606 $562,169 $1,335,437 $41,586,673 154 145,546 UVRs 6,435 UVRs 1,906 UVRs 4,528 UVRs 141,017 UVRs 155 105.89 -0.06% 0.87% $30,789,010 $1,327,954 $267,257 $1,060,697 $29,728,313 155 $294.738 $41,563,197 $1,896,534 $544,371 $1,352,164 $40,211,034 155 141,017 UVRs 6,435 UVRs 1,847 UVRs 4,588 UVRs 136,430 UVRs 156 105.66 -0.22% 0.71% $29,728,313 $1,301,567 $210,294 $1,091,273 $28,637,039 156 $294.103 $40,124,330 $1,892,445 $525,525 $1,366,920 $38,757,411 156 136,430 UVRs 6,435 UVRs 1,787 UVRs 4,648 UVRs 131,782 UVRs 157 105.71 0.05% 0.98% $28,637,039 $1,344,372 $279,812 $1,064,561 $27,572,479 157 $294.254 $38,777,417 $1,893,422 $507,884 $1,385,538 $37,391,880 157 131,782 UVRs 6,435 UVRs 1,726 UVRs 4,709 UVRs 127,073 UVRs 158 105.76 0.04% 0.97% $27,572,479 $1,342,532 $266,115 $1,076,417 $26,496,062 158 $294.372 $37,406,754 $1,894,175 $489,932 $1,404,243 $36,002,511 158 127,073 UVRs 6,435 UVRs 1,664 UVRs 4,770 UVRs 122,303 UVRs 159 105.78 0.02% 0.95% $26,496,062 $1,340,246 $251,626 $1,088,621 $25,407,441 159 $294.444 $36,011,312 $1,894,638 $471,655 $1,422,983 $34,588,329 159 122,303 UVRs 6,435 UVRs 1,602 UVRs 4,833 UVRs 117,470 UVRs 160 105.79 0.01% 0.94% $25,407,441 $1,338,362 $237,901 $1,100,461 $24,306,981 160 $294.477 $34,592,217 $1,894,851 $453,069 $1,441,782 $33,150,434 160 117,470 UVRs 6,435 UVRs 1,539 UVRs 4,896 UVRs 112,574 UVRs 161 105.80 0.01% 0.93% $24,306,981 $1,337,861 $226,696 $1,111,165 $23,195,816 161 $294.499 $33,152,943 $1,894,994 $434,218 $1,460,776 $31,692,167 161 112,574 UVRs 6,435 UVRs 1,474 UVRs 4,960 UVRs 107,614 UVRs 162 105.78 -0.02% 0.91% $23,195,816 $1,334,434 $210,159 $1,124,275 $22,071,541 162 $294.444 $31,686,207 $1,894,638 $415,008 $1,479,631 $30,206,577 162 107,614 UVRs 6,435 UVRs 1,409 UVRs 5,025 UVRs 102,589 UVRs 163 105.79 0.01% 0.94% $22,071,541 $1,338,149 $206,665 $1,131,484 $20,940,057 163 $294.477 $30,209,971 $1,894,851 $395,673 $1,499,178 $28,710,793 163 102,589 UVRs 6,435 UVRs 1,344 UVRs 5,091 UVRs 97,498 UVRs 164 105.80 0.01% 0.93% $20,940,057 $1,337,718 $195,295 $1,142,423 $19,797,634 164 $294.499 $28,712,966 $1,894,994 $376,066 $1,518,929 $27,194,037 164 97,498 UVRs 6,435 UVRs 1,277 UVRs 5,158 UVRs 92,340 UVRs 165 105.89 0.08% 1.01% $19,797,634 $1,345,916 $199,364 $1,146,552 $18,651,082 165 $294.738 $27,216,135 $1,896,534 $356,461 $1,540,073 $25,676,061 165 92,340 UVRs 6,435 UVRs 1,209 UVRs 5,225 UVRs 87,115 UVRs 166 105.95 0.06% 0.98% $18,651,082 $1,343,314 $183,155 $1,160,160 $17,490,922 166 $294.905 $25,690,564 $1,897,606 $336,480 $1,561,125 $24,129,439 166 87,115 UVRs 6,435 UVRs 1,141 UVRs 5,294 UVRs 81,821 UVRs 167 105.89 -0.06% 0.87% $17,490,922 $1,332,210 $151,826 $1,180,384 $16,310,539 167 $294.738 $24,115,817 $1,896,534 $315,855 $1,580,679 $22,535,138 167 81,821 UVRs 6,435 UVRs 1,072 UVRs 5,363 UVRs 76,458 UVRs 168 105.66 -0.22% 0.71% $16,310,539 $1,317,659 $115,378 $1,202,281 $15,108,258 168 $294.103 $22,486,548 $1,892,445 $294,516 $1,597,929 $20,888,618 168 76,458 UVRs 6,435 UVRs 1,001 UVRs 5,433 UVRs 71,025 UVRs 169 106.54 0.83% 1.76% $15,108,258 $1,407,874 $266,282 $1,141,592 $13,966,665 169 $296.543 $21,061,955 $1,908,149 $275,857 $1,632,292 $19,429,664 169 71,025 UVRs 6,435 UVRs 930 UVRs 5,504 UVRs 65,521 UVRs 170 106.12 -0.39% 0.53% $13,966,665 $1,310,250 $73,701 $1,236,549 $12,730,116 170 $295.376 $19,353,176 $1,900,637 $253,477 $1,647,160 $17,706,016 170 65,521 UVRs 6,435 UVRs 858 UVRs 5,576 UVRs 59,944 UVRs 171 105.91 -0.19% 0.73% $12,730,116 $1,324,864 $93,256 $1,231,608 $11,498,509 171 $294.813 $17,672,255 $1,897,013 $231,461$1,665,552 $16,006,703 171 59,944 UVRs 6,435 UVRs 785 UVRs 5,650 UVRs 54,295 UVRs 172 105.83 -0.08% 0.84% $11,498,509 $1,332,191 $97,152 $1,235,039 $10,263,470 172 $294.579 $15,994,001 $1,895,508 $209,480 $1,686,028 $14,307,974 172 54,295 UVRs 6,435 UVRs 711 UVRs 5,724 UVRs 48,571 UVRs 173 106.99 1.09% 2.03% $10,263,470 $1,402,630 $207,929 $1,194,700 $9,068,770 173 $297.792 $14,464,049 $1,916,184 $189,442 $1,726,743 $12,737,306 173 48,571 UVRs 6,435 UVRs 636 UVRs 5,798 UVRs 42,772 UVRs 174 107.46 0.45% 1.38% $9,068,770 $1,367,840 $124,821 $1,243,019 $7,825,751 174 $299.124 $12,794,273 $1,924,755 $167,572 $1,757,183 $11,037,090 174 42,772 UVRs 6,435 UVRs 560 UVRs 5,874 UVRs 36,898 UVRs 175 106.74 -0.67% 0.25% $7,825,751 $1,315,568 $19,292 $1,296,277 $6,529,474 175 $297.113 $10,962,892 $1,911,815 $143,586 $1,768,229 $9,194,662 175 36,898 UVRs 6,435 UVRs 483 UVRs 5,951 UVRs 30,947 UVRs 176 105.57 -1.10% -0.18% $6,529,474 $1,298,751 -$11,921 $1,310,672 $5,218,802 176 $293.852 $9,093,758 $1,890,834 $119,105 $1,771,730 $7,322,029 176 30,947 UVRs 6,435 UVRs 405 UVRs 6,029 UVRs 24,917 UVRs 177 106.02 0.43% 1.36% $5,218,802 $1,349,356 $70,969 $1,278,387 $3,940,416 177 $295.119 $7,353,579 $1,898,982 $96,313 $1,802,669 $5,550,910 177 24,917 UVRs 6,435 UVRs 326 UVRs 6,108 UVRs 18,809 UVRs 178 104.43 -1.51% -0.59% $3,940,416 $1,297,887 -$23,424 $1,321,311 $2,619,105 178 $290.675 $5,467,338 $1,870,392 $71,608 $1,798,784 $3,668,555 178 18,809 UVRs 6,435 UVRs 246 UVRs 6,188 UVRs 12,621 UVRs 179 110.50 5.81% 6.79% $2,619,105 $1,444,461 $177,930 $1,266,531 $1,352,574 179 $307.578 $3,881,873 $1,979,151 $50,843 $1,928,308 $1,953,564 179 12,621 UVRs 6,435 UVRs 165 UVRs 6,269 UVRs 6,351 UVRs 180 106.42 -3.69% -2.80% $1,352,574 $1,314,679 -$37,894 $1,352,574 $0 180 $296.220 $1,881,429 $1,906,071 $24,642 $1,881,429 -$0 180 6,351 UVRs 6,435 UVRs 83 UVRs 6,351 UVRs -0 UVRs