Anexo - Plantilla - Tarea 3 - Tablas de Amortización_Claribel_Buzón_116005_5

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
		Claribel Buzón Valencia
		1044330251
		116005_5
		Presentado a:
		Edward Eli Loboa
		UNIVERSIDAD NACIONAL ABIERTA Y A DISTANCIA UNAD
		ESCUELA DE CIENCIAS ADMINISTRATIVAS, CONTABLES, ECONÓMICAS Y DE NEGOCIOS (ECACEN)
		Contaduría Pública
		Matemáticas Financieras
		116005
		Puerto Giraldo
		Apr-23
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					Condiciones de Crédito		Monto	Tasa
		Decisión 1	Alternativa 1	$107,500,012	13.44% NACM	1.12% MMV	96					Decisión 1	Alternativa 1	$41,241,766	8.50% NACM
			Alternativa 2		13.44% E+A	1.06% MMV	96						Alternativa 2		13.90% E+A
		Decisión 2	Alternativa 1	$124,650,000	17.23% E+A	1.33% MMV	84					Decisión 2	Alternativa 1	$64,902,516	17.90% E+A
			Alternativa 2		17.23% E+A	1.33% MMV	84						Alternativa 2		10.00% E+A
		Decisión 3	Alternativa 1	$311,050,000	19.02% E+A	4.45% TTV	38					Decisión 3	Alternativa 1	$157,546,198	11.30% E+A
			Alternativa 2		19.02% NACT	4.76% TTV	38						Alternativa 2		15.70% NACT
		Decisión 4	Alternativa 1	$795,302,000	22.09% E+A	1.68% MMV	120					Decisión 4	Alternativa 1	$53,388,690	9.60% E+A
			Alternativa 2		22.09% NACB	1.84% MMV	120						Alternativa 2		16.00% NACB
		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 8 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 8 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)	$107,500,012	Cuota (A)	$1,833,340				Capital (P)	$107,500,012
		Tasa (i)	1.12%						Tasa (i)	1.06%
		Plazo (n)	96						Plazo (n)	96
		Decisión
		La mejor alternativa es la 1, ya que al haber problemas de liquidez esta la posiblibilidad de que en algun mes no este el dinero necesario para poder cancelar la cuota correspondida.
		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	$107,500,012	$1,833,340	$1,204,000	$629,340	$106,870,672		1	$107,500,012	$2,255,429	$1,135,637	$1,119,792	$106,380,220
		2	$106,870,672	$1,833,340	$1,196,952	$636,388	$106,234,284		2	$106,380,220	$2,243,599	$1,123,808	$1,119,792	$105,260,428
		3	$106,234,284	$1,833,340	$1,189,824	$643,516	$105,590,768		3	$105,260,428	$2,231,770	$1,111,978	$1,119,792	$104,140,637
		4	$105,590,768	$1,833,340	$1,182,617	$650,723	$104,940,045		4	$104,140,637	$2,219,940	$1,100,149	$1,119,792	$103,020,845
		5	$104,940,045	$1,833,340	$1,175,329	$658,011	$104,282,034		5	$103,020,845	$2,208,111	$1,088,319	$1,119,792	$101,901,053
		6	$104,282,034	$1,833,340	$1,167,959	$665,381	$103,616,653		6	$101,901,053	$2,196,281	$1,076,489	$1,119,792	$100,781,261
		7	$103,616,653	$1,833,340	$1,160,507	$672,833	$102,943,819		7	$100,781,261	$2,184,452	$1,064,660	$1,119,792	$99,661,469
		8	$102,943,819	$1,833,340	$1,152,971	$680,369	$102,263,450		8	$99,661,469	$2,172,622	$1,052,830	$1,119,792	$98,541,678
		9	$102,263,450	$1,833,340	$1,145,351	$687,989	$101,575,461		9	$98,541,678	$2,160,793	$1,041,001	$1,119,792	$97,421,886
		10	$101,575,461	$1,833,340	$1,137,645	$695,695	$100,879,766		10	$97,421,886	$2,148,963	$1,029,171	$1,119,792	$96,302,094
		11	$100,879,766	$1,833,340	$1,129,853	$703,486	$100,176,280		11	$96,302,094	$2,137,133	$1,017,342	$1,119,792	$95,182,302
		12	$100,176,280	$1,833,340	$1,121,974	$711,365	$99,464,914		12	$95,182,302	$2,125,304	$1,005,512	$1,119,792	$94,062,510
		13	$99,464,914	$1,833,340	$1,114,007	$719,333	$98,745,582		13	$94,062,510	$2,113,474	$993,683	$1,119,792	$92,942,719
		14	$98,745,582	$1,833,340	$1,105,951	$727,389	$98,018,192		14	$92,942,719	$2,101,645	$981,853	$1,119,792	$91,822,927
		15	$98,018,192	$1,833,340	$1,097,804	$735,536	$97,282,656		15	$91,822,927	$2,089,815	$970,023	$1,119,792	$90,703,135
		16	$97,282,656	$1,833,340	$1,089,566	$743,774	$96,538,882		16	$90,703,135	$2,077,986	$958,194	$1,119,792	$89,583,343
		17	$96,538,882	$1,833,340	$1,081,235	$752,104	$95,786,778		17	$89,583,343	$2,066,156	$946,364	$1,119,792	$88,463,552
		18	$95,786,778	$1,833,340	$1,072,812	$760,528	$95,026,250		18	$88,463,552	$2,054,327	$934,535	$1,119,792	$87,343,760
		19	$95,026,250	$1,833,340	$1,064,294	$769,046	$94,257,204		19	$87,343,760	$2,042,497	$922,705	$1,119,792	$86,223,968
		20	$94,257,204	$1,833,340	$1,055,681	$777,659	$93,479,545		20	$86,223,968	$2,030,668	$910,876	$1,119,792	$85,104,176
		21	$93,479,545	$1,833,340	$1,046,971	$786,369	$92,693,176		21	$85,104,176	$2,018,838	$899,046	$1,119,792	$83,984,384
		22	$92,693,176	$1,833,340	$1,038,164	$795,176	$91,898,000		22	$83,984,384	$2,007,008	$887,217	$1,119,792	$82,864,593
		23	$91,898,000	$1,833,340	$1,029,258	$804,082	$91,093,918		23	$82,864,593	$1,995,179	$875,387	$1,119,792	$81,744,801
		24	$91,093,918	$1,833,340	$1,020,252	$813,088	$90,280,830		24	$81,744,801	$1,983,349	$863,557	$1,119,792	$80,625,009
		25	$90,280,830	$1,833,340	$1,011,145	$822,195	$89,458,635		25	$80,625,009	$1,971,520	$851,728	$1,119,792	$79,505,217
		26	$89,458,635	$1,833,340	$1,001,937	$831,403	$88,627,232		26	$79,505,217	$1,959,690	$839,898	$1,119,792	$78,385,425
		27	$88,627,232	$1,833,340	$992,625	$840,715	$87,786,517		27	$78,385,425	$1,947,861	$828,069	$1,119,792	$77,265,634
		28	$87,786,517	$1,833,340	$983,209	$850,131	$86,936,386		28	$77,265,634	$1,936,031	$816,239	$1,119,792	$76,145,842
		29	$86,936,386	$1,833,340	$973,688	$859,652	$86,076,734		29	$76,145,842	$1,924,202	$804,410	$1,119,792	$75,026,050
		30	$86,076,734	$1,833,340	$964,059	$869,280	$85,207,454		30	$75,026,050	$1,912,372	$792,580	$1,119,792	$73,906,258
		31	$85,207,454	$1,833,340	$954,323	$879,016	$84,328,437		31	$73,906,258	$1,900,542	$780,751	$1,119,792	$72,786,466
		32	$84,328,437	$1,833,340	$944,478	$888,861	$83,439,576		32	$72,786,466	$1,888,713	$768,921	$1,119,792	$71,666,675
		33	$83,439,576	$1,833,340	$934,523	$898,817	$82,540,759		33	$71,666,675	$1,876,883	$757,091	$1,119,792	$70,546,883
		34	$82,540,759	$1,833,340	$924,457	$908,883	$81,631,876		34	$70,546,883	$1,865,054	$745,262	$1,119,792	$69,427,091
		35	$81,631,876	$1,833,340	$914,277	$919,063	$80,712,813		35	$69,427,091	$1,853,224	$733,432	$1,119,792	$68,307,299
		36	$80,712,813	$1,833,340	$903,984	$929,356	$79,783,457		36	$68,307,299	$1,841,395	$721,603	$1,119,792	$67,187,507
		37	$79,783,457	$1,833,340	$893,575	$939,765	$78,843,692		37	$67,187,507	$1,829,565	$709,773	$1,119,792	$66,067,716
		38	$78,843,692	$1,833,340	$883,049	$950,290	$77,893,401		38	$66,067,716	$1,817,736	$697,944	$1,119,792	$64,947,924
		39	$77,893,401	$1,833,340	$872,406	$960,934	$76,932,468		39	$64,947,924	$1,805,906	$686,114	$1,119,792	$63,828,132
		40	$76,932,468	$1,833,340	$861,644	$971,696	$75,960,771		40	$63,828,132	$1,794,076	$674,285	$1,119,792	$62,708,34041	$75,960,771	$1,833,340	$850,761	$982,579	$74,978,192		41	$62,708,340	$1,782,247	$662,455	$1,119,792	$61,588,549
		42	$74,978,192	$1,833,340	$839,756	$993,584	$73,984,608		42	$61,588,549	$1,770,417	$650,626	$1,119,792	$60,468,757
		43	$73,984,608	$1,833,340	$828,628	$1,004,712	$72,979,896		43	$60,468,757	$1,758,588	$638,796	$1,119,792	$59,348,965
		44	$72,979,896	$1,833,340	$817,375	$1,015,965	$71,963,931		44	$59,348,965	$1,746,758	$626,966	$1,119,792	$58,229,173
		45	$71,963,931	$1,833,340	$805,996	$1,027,344	$70,936,587		45	$58,229,173	$1,734,929	$615,137	$1,119,792	$57,109,381
		46	$70,936,587	$1,833,340	$794,490	$1,038,850	$69,897,737		46	$57,109,381	$1,723,099	$603,307	$1,119,792	$55,989,590
		47	$69,897,737	$1,833,340	$782,855	$1,050,485	$68,847,252		47	$55,989,590	$1,711,270	$591,478	$1,119,792	$54,869,798
		48	$68,847,252	$1,833,340	$771,089	$1,062,251	$67,785,001		48	$54,869,798	$1,699,440	$579,648	$1,119,792	$53,750,006
		49	$67,785,001	$1,833,340	$759,192	$1,074,148	$66,710,854		49	$53,750,006	$1,687,610	$567,819	$1,119,792	$52,630,214
		50	$66,710,854	$1,833,340	$747,162	$1,086,178	$65,624,675		50	$52,630,214	$1,675,781	$555,989	$1,119,792	$51,510,422
		51	$65,624,675	$1,833,340	$734,996	$1,098,343	$64,526,332		51	$51,510,422	$1,663,951	$544,160	$1,119,792	$50,390,631
		52	$64,526,332	$1,833,340	$722,695	$1,110,645	$63,415,687		52	$50,390,631	$1,652,122	$532,330	$1,119,792	$49,270,839
		53	$63,415,687	$1,833,340	$710,256	$1,123,084	$62,292,603		53	$49,270,839	$1,640,292	$520,500	$1,119,792	$48,151,047
		54	$62,292,603	$1,833,340	$697,677	$1,135,663	$61,156,940		54	$48,151,047	$1,628,463	$508,671	$1,119,792	$47,031,255
		55	$61,156,940	$1,833,340	$684,958	$1,148,382	$60,008,558		55	$47,031,255	$1,616,633	$496,841	$1,119,792	$45,911,463
		56	$60,008,558	$1,833,340	$672,096	$1,161,244	$58,847,314		56	$45,911,463	$1,604,804	$485,012	$1,119,792	$44,791,672
		57	$58,847,314	$1,833,340	$659,090	$1,174,250	$57,673,064		57	$44,791,672	$1,592,974	$473,182	$1,119,792	$43,671,880
		58	$57,673,064	$1,833,340	$645,938	$1,187,402	$56,485,663		58	$43,671,880	$1,581,144	$461,353	$1,119,792	$42,552,088
		59	$56,485,663	$1,833,340	$632,639	$1,200,700	$55,284,962		59	$42,552,088	$1,569,315	$449,523	$1,119,792	$41,432,296
		60	$55,284,962	$1,833,340	$619,192	$1,214,148	$54,070,814		60	$41,432,296	$1,557,485	$437,694	$1,119,792	$40,312,504
		61	$54,070,814	$1,833,340	$605,593	$1,227,747	$52,843,067		61	$40,312,504	$1,545,656	$425,864	$1,119,792	$39,192,713
		62	$52,843,067	$1,833,340	$591,842	$1,241,497	$51,601,570		62	$39,192,713	$1,533,826	$414,034	$1,119,792	$38,072,921
		63	$51,601,570	$1,833,340	$577,938	$1,255,402	$50,346,167		63	$38,072,921	$1,521,997	$402,205	$1,119,792	$36,953,129
		64	$50,346,167	$1,833,340	$563,877	$1,269,463	$49,076,705		64	$36,953,129	$1,510,167	$390,375	$1,119,792	$35,833,337
		65	$49,076,705	$1,833,340	$549,659	$1,283,681	$47,793,024		65	$35,833,337	$1,498,338	$378,546	$1,119,792	$34,713,546
		66	$47,793,024	$1,833,340	$535,282	$1,298,058	$46,494,966		66	$34,713,546	$1,486,508	$366,716	$1,119,792	$33,593,754
		67	$46,494,966	$1,833,340	$520,744	$1,312,596	$45,182,370		67	$33,593,754	$1,474,678	$354,887	$1,119,792	$32,473,962
		68	$45,182,370	$1,833,340	$506,043	$1,327,297	$43,855,073		68	$32,473,962	$1,462,849	$343,057	$1,119,792	$31,354,170
		69	$43,855,073	$1,833,340	$491,177	$1,342,163	$42,512,910		69	$31,354,170	$1,451,019	$331,228	$1,119,792	$30,234,378
		70	$42,512,910	$1,833,340	$476,145	$1,357,195	$41,155,714		70	$30,234,378	$1,439,190	$319,398	$1,119,792	$29,114,587
		71	$41,155,714	$1,833,340	$460,944	$1,372,396	$39,783,318		71	$29,114,587	$1,427,360	$307,568	$1,119,792	$27,994,795
		72	$39,783,318	$1,833,340	$445,573	$1,387,767	$38,395,552		72	$27,994,795	$1,415,531	$295,739	$1,119,792	$26,875,003
		73	$38,395,552	$1,833,340	$430,030	$1,403,310	$36,992,242		73	$26,875,003	$1,403,701	$283,909	$1,119,792	$25,755,211
		74	$36,992,242	$1,833,340	$414,313	$1,419,027	$35,573,215		74	$25,755,211	$1,391,872	$272,080	$1,119,792	$24,635,419
		75	$35,573,215	$1,833,340	$398,420	$1,434,920	$34,138,296		75	$24,635,419	$1,380,042	$260,250	$1,119,792	$23,515,628
		76	$34,138,296	$1,833,340	$382,349	$1,450,991	$32,687,305		76	$23,515,628	$1,368,212	$248,421	$1,119,792	$22,395,836
		77	$32,687,305	$1,833,340	$366,098	$1,467,242	$31,220,063		77	$22,395,836	$1,356,383	$236,591	$1,119,792	$21,276,044
		78	$31,220,063	$1,833,340	$349,665	$1,483,675	$29,736,388		78	$21,276,044	$1,344,553	$224,762	$1,119,792	$20,156,252
		79	$29,736,388	$1,833,340	$333,048	$1,500,292	$28,236,095		79	$20,156,252	$1,332,724	$212,932	$1,119,792	$19,036,460
		80	$28,236,095	$1,833,340	$316,244	$1,517,096	$26,719,000		80	$19,036,460	$1,320,894	$201,102	$1,119,792	$17,916,669
		81	$26,719,000	$1,833,340	$299,253	$1,534,087	$25,184,913		81	$17,916,669	$1,309,065	$189,273	$1,119,792	$16,796,877
		82	$25,184,913	$1,833,340	$282,071	$1,551,269	$23,633,644		82	$16,796,877	$1,297,235	$177,443	$1,119,792	$15,677,085
		83	$23,633,644	$1,833,340	$264,697	$1,568,643	$22,065,001		83	$15,677,085	$1,285,406	$165,614	$1,119,792	$14,557,293
		84	$22,065,001	$1,833,340	$247,128	$1,586,212	$20,478,789		84	$14,557,293	$1,273,576	$153,784	$1,119,792	$13,437,501
		85	$20,478,789	$1,833,340	$229,362	$1,603,977	$18,874,812		85	$13,437,501	$1,261,746	$141,955	$1,119,792	$12,317,710
		86	$18,874,812	$1,833,340	$211,398	$1,621,942	$17,252,870		86	$12,317,710	$1,249,917	$130,125	$1,119,792	$11,197,918
		87	$17,252,870	$1,833,340	$193,232	$1,640,108	$15,612,762		87	$11,197,918	$1,238,087	$118,296	$1,119,792	$10,078,126
		88	$15,612,762	$1,833,340	$174,863	$1,658,477	$13,954,285		88	$10,078,126	$1,226,258	$106,466	$1,119,792	$8,958,334
		89	$13,954,285	$1,833,340	$156,288	$1,677,052	$12,277,233		89	$8,958,334	$1,214,428	$94,636	$1,119,792	$7,838,543
		90	$12,277,233	$1,833,340	$137,505	$1,695,835	$10,581,399		90	$7,838,543	$1,202,599	$82,807	$1,119,792	$6,718,751
		91	$10,581,399	$1,833,340	$118,512	$1,714,828	$8,866,570		91	$6,718,751	$1,190,769	$70,977	$1,119,792	$5,598,959
		92	$8,866,570	$1,833,340	$99,306	$1,734,034	$7,132,536		92	$5,598,959	$1,178,940	$59,148	$1,119,792	$4,479,167
		93	$7,132,536	$1,833,340	$79,884	$1,753,455	$5,379,081		93	$4,479,167	$1,167,110	$47,318	$1,119,792	$3,359,375
		94	$5,379,081	$1,833,340	$60,246	$1,773,094	$3,605,987		94	$3,359,375	$1,155,280	$35,489	$1,119,792	$2,239,584
		95	$3,605,987	$1,833,340	$40,387	$1,792,953	$1,813,034		95	$2,239,584	$1,143,451	$23,659	$1,119,792	$1,119,792
		96	$1,813,034	$1,833,340	$20,306	$1,813,034	$0		96	$1,119,792	$1,131,621	$11,830	$1,119,792	-$0
Decisión 2
	Diligencie, ú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 2 años y un plazo total de 7 años. La tasa de interés periódica está dada a continuación.
• Alternativa 2: Periodo muerto de 18 meses y un plazo total de 7 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.
								$124,650,000	Deuda (D)
		Capital (P)	$124,650,000					1.33%	Tasa (i)
		Tasa (i)	1.33%					84	Plazo (n)
		Plazo	84					18	Periodo Muerto (nm)
		Periodo Gracia	24					66	Periodo Abono (na)
		Periodo Abono (na)	60					$158,216,011	Capital (P)
		Cuota (A)	$3,031,413					$3,619,903	Cuota (A)
		Decisión
		La mejor alternativa es la 2, ya que al haberincentidunbre sobre la generacion de flujo de caja, por parte de la empresa, esta la posiblidad de no cumplir con el pago, puesto que no se sabe si el producto va a ser aceptado en dicho mercado. Asi que lo recomendable seria no pagar durante los 18 meses hasta que el producto sea aceptado y empiece a generar ingresos con los cuales se puedan pagar las siguiente cuotas.
		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	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		1	$124,650,000	$0	$1,662,262	-$1,662,262	$126,312,262
		2	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		2	$126,312,262	$0	$1,684,429	-$1,684,429	$127,996,691
		3	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		3	$127,996,691	$0	$1,706,892	-$1,706,892	$129,703,583
		4	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		4	$129,703,583	$0	$1,729,654	-$1,729,654	$131,433,237
		5	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		5	$131,433,237	$0	$1,752,720	-$1,752,720	$133,185,957
		6	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		6	$133,185,957	$0	$1,776,093	-$1,776,093	$134,962,050
		7	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		7	$134,962,050	$0	$1,799,778	-$1,799,778	$136,761,828
		8	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		8	$136,761,828	$0	$1,823,779	-$1,823,779	$138,585,606
		9	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		9	$138,585,606	$0	$1,848,100	-$1,848,100	$140,433,706
		10	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		10	$140,433,706	$0	$1,872,745	-$1,872,745	$142,306,451
		11	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		11	$142,306,451	$0	$1,897,719	-$1,897,719	$144,204,169
		12	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		12	$144,204,169	$0	$1,923,026	-$1,923,026	$146,127,195
		13	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		13	$146,127,195	$0	$1,948,670	-$1,948,670	$148,075,865
		14	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		14	$148,075,865	$0	$1,974,656	-$1,974,656	$150,050,521
		15	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		15	$150,050,521	$0	$2,000,989	-$2,000,989	$152,051,511
		16	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		16	$152,051,511	$0	$2,027,673	-$2,027,673	$154,079,184
		17	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		17	$154,079,184	$0	$2,054,713	-$2,054,713	$156,133,897
		18	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		18	$156,133,897	$0	$2,082,114	-$2,082,114	$158,216,011
		19	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		19	$158,216,011	$3,619,903	$2,109,880	$1,510,024	$156,705,987
		20	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		20	$156,705,987	$3,619,903	$2,089,743	$1,530,161	$155,175,827
		21	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		21	$155,175,827	$3,619,903	$2,069,337	$1,550,566	$153,625,261
		22	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		22	$153,625,261	$3,619,903	$2,048,660	$1,571,243	$152,054,017
		23	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		23	$152,054,017	$3,619,903	$2,027,707	$1,592,197	$150,461,821
		24	$124,650,000	$1,662,262	$1,662,262	$0	$124,650,000		24	$150,461,821	$3,619,903	$2,006,474	$1,613,429	$148,848,392
		25	$124,650,000	$3,031,413	$1,662,262	$1,369,151	$123,280,849		25	$148,848,392	$3,619,903	$1,984,958	$1,634,945	$147,213,447
		26	$123,280,849	$3,031,413	$1,644,004	$1,387,409	$121,893,440		26	$147,213,447	$3,619,903	$1,963,156	$1,656,748	$145,556,699
		27	$121,893,440	$3,031,413	$1,625,502	$1,405,911	$120,487,529		27	$145,556,699	$3,619,903	$1,941,062	$1,678,841	$143,877,858
		28	$120,487,529	$3,031,413	$1,606,754	$1,424,659	$119,062,870		28	$143,877,858	$3,619,903	$1,918,674	$1,701,229	$142,176,628
		29	$119,062,870	$3,031,413	$1,587,755	$1,443,658	$117,619,213		29	$142,176,628	$3,619,903	$1,895,987	$1,723,916	$140,452,713
		30	$117,619,213	$3,031,413	$1,568,504	$1,462,909	$116,156,303		30	$140,452,713	$3,619,903	$1,872,998	$1,746,905	$138,705,808
		31	$116,156,303	$3,031,413	$1,548,995	$1,482,418	$114,673,885		31	$138,705,808	$3,619,903	$1,849,703	$1,770,201	$136,935,607
		32	$114,673,885	$3,031,413	$1,529,226	$1,502,187	$113,171,699		32	$136,935,607	$3,619,903	$1,826,096	$1,793,807	$135,141,800
		33	$113,171,699	$3,031,413	$1,509,194	$1,522,219	$111,649,480		33	$135,141,800	$3,619,903	$1,802,175	$1,817,728	$133,324,071
		34	$111,649,480	$3,031,413	$1,488,895	$1,542,518	$110,106,961		34	$133,324,071	$3,619,903	$1,777,935	$1,841,969	$131,482,103
		35	$110,106,961	$3,031,413	$1,468,324	$1,563,089	$108,543,873		35	$131,482,103	$3,619,903	$1,753,371	$1,866,532	$129,615,571
		36	$108,543,873	$3,031,413	$1,447,480	$1,583,933	$106,959,940		36	$129,615,571	$3,619,903	$1,728,480	$1,891,423	$127,724,147
		37	$106,959,940	$3,031,413	$1,426,358	$1,605,055	$105,354,884		37	$127,724,147	$3,619,903	$1,703,257	$1,916,646	$125,807,501
		38	$105,354,884	$3,031,413	$1,404,953	$1,626,460	$103,728,425		38	$125,807,501	$3,619,903	$1,677,698	$1,942,205	$123,865,296
		39	$103,728,425	$3,031,413	$1,383,264	$1,648,149	$102,080,275		39	$123,865,296	$3,619,903	$1,651,798	$1,968,105	$121,897,191
		40	$102,080,275	$3,031,413	$1,361,285	$1,670,128	$100,410,147		40	$121,897,191	$3,619,903	$1,625,552	$1,994,351	$119,902,840
		41	$100,410,147	$3,031,413	$1,339,013	$1,692,400	$98,717,748		41	$119,902,840	$3,619,903	$1,598,957	$2,020,947	$117,881,893
		42	$98,717,748	$3,031,413	$1,316,444	$1,714,969	$97,002,779		42	$117,881,893	$3,619,903	$1,572,007	$2,047,897	$115,833,996
		43	$97,002,779	$3,031,413	$1,293,574	$1,737,839	$95,264,940		43	$115,833,996	$3,619,903	$1,544,697	$2,075,206	$113,758,790
		44	$95,264,940	$3,031,413	$1,270,400	$1,761,013	$93,503,927		44	$113,758,790	$3,619,903	$1,517,023	$2,102,880	$111,655,910
		45	$93,503,927	$3,031,413	$1,246,916	$1,784,497	$91,719,430		45	$111,655,910	$3,619,903	$1,488,980	$2,130,923	$109,524,987
		46	$91,719,430	$3,031,413	$1,223,119	$1,808,294	$89,911,135		46	$109,524,987	$3,619,903	$1,460,564	$2,159,340	$107,365,647
		47	$89,911,135	$3,031,413	$1,199,004	$1,832,409	$88,078,727		47	$107,365,647	$3,619,903	$1,431,768	$2,188,136	$105,177,511
		48	$88,078,727	$3,031,413	$1,174,568	$1,856,845	$86,221,882		48	$105,177,511	$3,619,903	$1,402,588	$2,217,315	$102,960,196
		49	$86,221,882	$3,031,413	$1,149,806	$1,881,607	$84,340,275		49	$102,960,196	$3,619,903	$1,373,019	$2,246,884	$100,713,312
		50	$84,340,275	$3,031,413	$1,124,714	$1,906,699	$82,433,577		50	$100,713,312	$3,619,903	$1,343,056	$2,276,847	$98,436,465
		51	$82,433,577	$3,031,413	$1,099,288	$1,932,125	$80,501,452		51	$98,436,465	$3,619,903	$1,312,693	$2,307,210	$96,129,255
		52	$80,501,452	$3,031,413	$1,073,522	$1,957,891	$78,543,561		52	$96,129,255	$3,619,903	$1,281,926	$2,337,978	$93,791,277
		53	$78,543,561	$3,031,413	$1,047,413	$1,984,000	$76,559,560		53	$93,791,277	$3,619,903	$1,250,748	$2,369,156	$91,422,121
		54	$76,559,560	$3,031,413	$1,020,955	$2,010,458	$74,549,102		54	$91,422,121	$3,619,903	$1,219,154	$2,400,749	$89,021,372
		55	$74,549,102	$3,031,413	$994,145	$2,037,268	$72,511,834		55	$89,021,372	$3,619,903	$1,187,139	$2,432,764	$86,588,607
		56	$72,511,834	$3,031,413	$966,977	$2,064,436	$70,447,398		56	$86,588,607	$3,619,903	$1,154,697	$2,465,206	$84,123,401
		57	$70,447,398	$3,031,413	$939,447	$2,091,966	$68,355,432		57	$84,123,401	$3,619,903	$1,121,822	$2,498,081	$81,625,320
		58	$68,355,432	$3,031,413	$911,550	$2,119,863	$66,235,569		58	$81,625,320	$3,619,903	$1,088,509	$2,531,394	$79,093,926
		59	$66,235,569	$3,031,413	$883,280	$2,148,133	$64,087,436		59	$79,093,926	$3,619,903	$1,054,752	$2,565,151	$76,528,775
		60	$64,087,436	$3,031,413	$854,634	$2,176,779	$61,910,657		60	$76,528,775	$3,619,903	$1,020,545	$2,599,359	$73,929,416
		61	$61,910,657	$3,031,413	$825,606	$2,205,807	$59,704,849		61	$73,929,416	$3,619,903	$985,881	$2,634,022	$71,295,394
		62	$59,704,849	$3,031,413	$796,190	$2,235,223	$57,469,627		62	$71,295,394$3,619,903	$950,755	$2,669,148	$68,626,245
		63	$57,469,627	$3,031,413	$766,383	$2,265,030	$55,204,596		63	$68,626,245	$3,619,903	$915,161	$2,704,742	$65,921,503
		64	$55,204,596	$3,031,413	$736,177	$2,295,236	$52,909,361		64	$65,921,503	$3,619,903	$879,092	$2,740,811	$63,180,692
		65	$52,909,361	$3,031,413	$705,569	$2,325,844	$50,583,517		65	$63,180,692	$3,619,903	$842,542	$2,777,361	$60,403,331
		66	$50,583,517	$3,031,413	$674,553	$2,356,860	$48,226,657		66	$60,403,331	$3,619,903	$805,505	$2,814,399	$57,588,932
		67	$48,226,657	$3,031,413	$643,124	$2,388,289	$45,838,368		67	$57,588,932	$3,619,903	$767,974	$2,851,930	$54,737,002
		68	$45,838,368	$3,031,413	$611,275	$2,420,138	$43,418,230		68	$54,737,002	$3,619,903	$729,942	$2,889,961	$51,847,041
		69	$43,418,230	$3,031,413	$579,001	$2,452,412	$40,965,818		69	$51,847,041	$3,619,903	$691,403	$2,928,500	$48,918,540
		70	$40,965,818	$3,031,413	$546,297	$2,485,116	$38,480,702		70	$48,918,540	$3,619,903	$652,350	$2,967,553	$45,950,987
		71	$38,480,702	$3,031,413	$513,157	$2,518,256	$35,962,446		71	$45,950,987	$3,619,903	$612,776	$3,007,127	$42,943,860
		72	$35,962,446	$3,031,413	$479,575	$2,551,838	$33,410,608		72	$42,943,860	$3,619,903	$572,675	$3,047,228	$39,896,632
		73	$33,410,608	$3,031,413	$445,545	$2,585,868	$30,824,740		73	$39,896,632	$3,619,903	$532,039	$3,087,864	$36,808,768
		74	$30,824,740	$3,031,413	$411,061	$2,620,352	$28,204,388		74	$36,808,768	$3,619,903	$490,861	$3,129,042	$33,679,726
		75	$28,204,388	$3,031,413	$376,118	$2,655,295	$25,549,093		75	$33,679,726	$3,619,903	$449,134	$3,170,769	$30,508,956
		76	$25,549,093	$3,031,413	$340,708	$2,690,705	$22,858,388		76	$30,508,956	$3,619,903	$406,850	$3,213,053	$27,295,903
		77	$22,858,388	$3,031,413	$304,827	$2,726,586	$20,131,802		77	$27,295,903	$3,619,903	$364,003	$3,255,901	$24,040,003
		78	$20,131,802	$3,031,413	$268,466	$2,762,947	$17,368,855		78	$24,040,003	$3,619,903	$320,584	$3,299,319	$20,740,683
		79	$17,368,855	$3,031,413	$231,621	$2,799,792	$14,569,063		79	$20,740,683	$3,619,903	$276,586	$3,343,317	$17,397,366
		80	$14,569,063	$3,031,413	$194,285	$2,837,128	$11,731,935		80	$17,397,366	$3,619,903	$232,001	$3,387,902	$14,009,464
		81	$11,731,935	$3,031,413	$156,450	$2,874,963	$8,856,973		81	$14,009,464	$3,619,903	$186,822	$3,433,081	$10,576,383
		82	$8,856,973	$3,031,413	$118,112	$2,913,301	$5,943,671		82	$10,576,383	$3,619,903	$141,041	$3,478,863	$7,097,520
		83	$5,943,671	$3,031,413	$79,261	$2,952,152	$2,991,520		83	$7,097,520	$3,619,903	$94,649	$3,525,255	$3,572,266
		84	$2,991,520	$3,031,413	$39,893	$2,991,520	-$0		84	$3,572,266	$3,619,903	$47,638	$3,572,266	-$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ísticas se 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 9,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 9,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)	$311,050,000					$311,050,000	Capital (P)											Capital (P)	$40,100,477
		Tasa (i)	4.45%					4.76%	Tasa (i)											Tasa (i)
		Plazo (n)	38					38	Plazo (n)											Plazo (n)
		Gradiente Arimét.	$311,050					6%	Gradiente Geomé.
		Primera Cuota (A1)	$12,915,849					$34,007,793	Primera Cuota (A1)
		Decisión
		Según el costo de financiamiento la mejor alternativa es la 1, ya que la tasa de interes periodica es menor y a pesar de que al final hay que pagar mas la cuota de entrada es mas facil de pagar.
		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	$311,050,000	$12,915,849	$13,839,138	-$923,290	$311,973,290		1	$311,050,000	$34,007,793	$14,790,428	$19,217,365	$291,832,635
		2	$311,973,290	$13,226,899	$13,880,217	-$653,318	$312,626,608		2	$291,832,635	$31,967,325	$13,876,642	$18,090,683	$273,741,951
		3	$312,626,608	$13,537,949	$13,909,284	-$371,336	$312,997,944		3	$273,741,951	$30,049,286	$13,016,430	$17,032,856	$256,709,096
		4	$312,997,944	$13,848,999	$13,925,806	-$76,807	$313,074,751		4	$256,709,096	$28,246,328	$12,206,517	$16,039,811	$240,669,285
		5	$313,074,751	$14,160,049	$13,929,223	$230,826	$312,843,925		5	$240,669,285	$26,551,549	$11,443,824	$15,107,724	$225,561,560
		6	$312,843,925	$14,471,099	$13,918,953	$552,146	$312,291,779		6	$225,561,560	$24,958,456	$10,725,452	$14,233,004	$211,328,557
		7	$312,291,779	$14,782,149	$13,894,387	$887,762	$311,404,018		7	$211,328,557	$23,460,949	$10,048,673	$13,412,276	$197,916,281
		8	$311,404,018	$15,093,199	$13,854,889	$1,238,310	$310,165,708		8	$197,916,281	$22,053,292	$9,410,919	$12,642,372	$185,273,909
		9	$310,165,708	$15,404,249	$13,799,795	$1,604,454	$308,561,254		9	$185,273,909	$20,730,094	$8,809,774	$11,920,320	$173,353,589
		10	$308,561,254	$15,715,299	$13,728,410	$1,986,889	$306,574,365		10	$173,353,589	$19,486,288	$8,242,963	$11,243,325	$162,110,264
		11	$306,574,365	$16,026,349	$13,640,010	$2,386,339	$304,188,026		11	$162,110,264	$18,317,111	$7,708,343	$10,608,768	$151,501,495
		12	$304,188,026	$16,337,399	$13,533,837	$2,803,561	$301,384,465		12	$151,501,495	$17,218,084	$7,203,896	$10,014,188	$141,487,307
		13	$301,384,465	$16,648,449	$13,409,102	$3,239,346	$298,145,119		13	$141,487,307	$16,184,999	$6,727,721	$9,457,278	$132,030,029
		14	$298,145,119	$16,959,499	$13,264,978	$3,694,520	$294,450,599		14	$132,030,029	$15,213,899	$6,278,028	$8,935,872	$123,094,158
		15	$294,450,599	$17,270,549	$13,100,603	$4,169,946	$290,280,653		15	$123,094,158	$14,301,065	$5,853,127	$8,447,938	$114,646,219
		16	$290,280,653	$17,581,599	$12,915,075	$4,666,524	$285,614,129		16	$114,646,219	$13,443,002	$5,451,428	$7,991,574	$106,654,646
		17	$285,614,129	$17,892,649	$12,707,454	$5,185,195	$280,428,934		17	$106,654,646	$12,636,421	$5,071,428	$7,564,993	$99,089,652
		18	$280,428,934	$18,203,699	$12,476,755	$5,726,943	$274,701,991		18	$99,089,652	$11,878,236	$4,711,713	$7,166,523	$91,923,129
		19	$274,701,991	$18,514,749	$12,221,954	$6,292,794	$268,409,197		19	$91,923,129	$11,165,542	$4,370,945	$6,794,597	$85,128,532
		20	$268,409,197	$18,825,799	$11,941,977	$6,883,821	$261,525,375		20	$85,128,532	$10,495,609	$4,047,862	$6,447,748	$78,680,784
		21	$261,525,375	$19,136,849	$11,635,704	$7,501,144	$254,024,231		21	$78,680,784	$9,865,873	$3,741,271	$6,124,602	$72,556,183
		22	$254,024,231	$19,447,899	$11,301,966	$8,145,933	$245,878,298		22	$72,556,183	$9,273,921	$3,450,046	$5,823,874	$66,732,309
		23	$245,878,298	$19,758,949	$10,939,539	$8,819,409	$237,058,889		23	$66,732,309	$8,717,485	$3,173,121	$5,544,364	$61,187,945
		24	$237,058,889	$20,069,999	$10,547,149	$9,522,849	$227,536,040		24	$61,187,945	$8,194,436	$2,909,487	$5,284,949	$55,902,995
		25	$227,536,040	$20,381,049	$10,123,462	$10,257,587	$217,278,452		25	$55,902,995	$7,702,770	$2,658,187	$5,044,583	$50,858,413
		26	$217,278,452	$20,692,099	$9,667,084	$11,025,014	$206,253,438		26	$50,858,413	$7,240,604	$2,418,318	$4,822,286	$46,036,126
		27	$206,253,438	$21,003,149	$9,176,563	$11,826,586	$194,426,852		27	$46,036,126$6,806,168	$2,189,018	$4,617,150	$41,418,976
		28	$194,426,852	$21,314,199	$8,650,378	$12,663,821	$181,763,032		28	$41,418,976	$6,397,798	$1,969,472	$4,428,325	$36,990,651
		29	$181,763,032	$21,625,249	$8,086,943	$13,538,305	$168,224,726		29	$36,990,651	$6,013,930	$1,758,905	$4,255,024	$32,735,627
		30	$168,224,726	$21,936,299	$7,484,601	$14,451,697	$153,773,029		30	$32,735,627	$5,653,094	$1,556,579	$4,096,515	$28,639,112
		31	$153,773,029	$22,247,349	$6,841,621	$15,405,728	$138,367,301		31	$28,639,112	$5,313,908	$1,361,790	$3,952,118	$24,686,994
		32	$138,367,301	$22,558,399	$6,156,194	$16,402,204	$121,965,097		32	$24,686,994	$4,995,074	$1,173,867	$3,821,207	$20,865,787
		33	$121,965,097	$22,869,449	$5,426,433	$17,443,016	$104,522,081		33	$20,865,787	$4,695,369	$992,168	$3,703,201	$17,162,585
		34	$104,522,081	$23,180,499	$4,650,363	$18,530,135	$85,991,946		34	$17,162,585	$4,413,647	$816,081	$3,597,566	$13,565,019
		35	$85,991,946	$23,491,549	$3,825,926	$19,665,622	$66,326,324		35	$13,565,019	$4,148,828	$645,017	$3,503,812	$10,061,207
		36	$66,326,324	$23,802,599	$2,950,970	$20,851,629	$45,474,695		36	$10,061,207	$3,899,899	$478,410	$3,421,488	$6,639,719
		37	$45,474,695	$24,113,649	$2,023,246	$22,090,403	$23,384,292		37	$6,639,719	$3,665,905	$315,719	$3,350,186	$3,289,533
		38	$23,384,292	$24,424,699	$1,040,407	$23,384,292	-$0		38	$3,289,533	$3,445,950	$156,417	$3,289,533	$0
Decisión 4
	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 10 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 10 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
		La mejor alternativa es la 1 ya que el costo anual es mas bajo que la otra alternativa, paga menos en el costo de financiamiento y eso hace que sea economico para la empresa.
												$795,302,000	Capital (P)
												1.84%	UVR + ? EMV (i)
												120	Plazo (n)
		Capital (P)	$795,302,000									280	UVR
		Tasa Fija (if)	1.68%									2,840,364 UVRs	Capital en UVR (PUVR)
		Plazo (n)	120									58,884 UVRs	Cuota en UVR (A)
		IPC Mes Anterior	100.380
		Variación Mes Anterior (∆i)	0.21%
		Tasa del Mes (i)	1.89%
		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.67%	Costo Anual	2.04%					Costo Periódico	0.86%	Costo Anual	2.61%					Costo Periódico	0.75%	Costo Anual	2.25%
		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	-$795,302,000							Deuda	-$795,302,000							Deuda	-2,840,364 UVRs
		1	100.59	0.21%	1.89%	$795,302,000	$16,829,621	$15,056,933	$1,772,689	$793,529,311		1	$280.000	$795,302,000	$16,487,406	$14,640,184	$1,847,222	$793,454,778			1	2,840,364 UVRs	58,884 UVRs	52,286 UVRs	6,597 UVRs	2,833,767 UVRs
		2	101.13	0.54%	2.22%	$793,529,311	$19,030,390	$17,639,860	$1,390,531	$792,138,781		2	$281.503	$797,714,162	$16,575,913	$14,684,588	$1,891,325	$795,822,837			2	2,833,767 UVRs	58,884 UVRs	52,165 UVRs	6,719 UVRs	2,827,048 UVRs
		3	101.64	0.50%	2.19%	$792,138,781	$18,783,675	$17,320,397	$1,463,278	$790,675,503		3	$282.913	$799,809,820	$16,658,956	$14,723,166	$1,935,790	$797,874,030			3	2,827,048 UVRs	58,884 UVRs	52,041 UVRs	6,842 UVRs	2,820,206 UVRs
		4	102.06	0.41%	2.10%	$790,675,503	$18,186,357	$16,582,822	$1,603,536	$789,071,967		4	$284.082	$801,171,030	$16,727,795	$14,748,223	$1,979,572	$799,191,459			4	2,820,206 UVRs	58,884 UVRs	51,915 UVRs	6,968 UVRs	2,813,238 UVRs
		5	102.42	0.36%	2.04%	$789,071,967	$17,802,223	$16,090,084	$1,712,139	$787,359,828		5	$285.094	$802,036,578	$16,787,346	$14,764,157	$2,023,189	$800,013,389			5	2,813,238 UVRs	58,884 UVRs	51,787 UVRs	7,097 UVRs	2,806,141 UVRs
		6	102.70	0.27%	1.95%	$787,359,828	$17,212,516	$15,341,600	$1,870,916	$785,488,912		6	$285.855	$802,148,355	$16,832,146	$14,766,214	$2,065,931	$800,082,423			6	2,806,141 UVRs	58,884 UVRs	51,656 UVRs	7,227 UVRs	2,798,914 UVRs
		7	102.89	0.19%	1.87%	$785,488,912	$16,722,116	$14,703,243	$2,018,873	$783,470,039		7	$286.402	$801,614,601	$16,864,380	$14,756,389	$2,107,991	$799,506,610			7	2,798,914 UVRs	58,884 UVRs	51,523 UVRs	7,360 UVRs	2,791,554 UVRs
		8	103.08	0.18%	1.86%	$783,470,039	$16,636,415	$14,559,309	$2,077,106	$781,392,933		8	$286.912	$800,931,156	$16,894,428	$14,743,808	$2,150,621	$798,780,535			8	2,791,554 UVRs	58,884 UVRs	51,388 UVRs	7,496 UVRs	2,784,058 UVRs
		9	103.24	0.16%	1.84%	$781,392,933	$16,510,544	$14,364,035	$2,146,508	$779,246,425		9	$287.367	$800,046,268	$16,921,199	$14,727,518	$2,193,680	$797,852,587			9	2,784,058 UVRs	58,884 UVRs	51,250 UVRs	7,634 UVRs	2,776,424 UVRs
		10	103.41	0.16%	1.84%	$779,246,425	$16,549,913	$14,373,754	$2,176,159	$777,070,266		10	$287.840	$799,166,370	$16,949,062	$14,711,321	$2,237,741	$796,928,629			10	2,776,424 UVRs	58,884 UVRs	51,109 UVRs	7,774 UVRs	2,768,650 UVRs
		11	103.59	0.17%	1.85%	$777,070,266	$16,609,290	$14,407,879	$2,201,411	$774,868,855		11	$288.341	$798,315,798	$16,978,564	$14,695,663	$2,282,901	$796,032,897			11	2,768,650 UVRs	58,884 UVRs	50,966 UVRs	7,917 UVRs	2,760,733 UVRs
		12	103.86	0.26%	1.94%	$774,868,855	$17,157,230	$15,049,184	$2,108,046	$772,760,809		12	$289.093	$798,107,700	$17,022,818	$14,691,833	$2,330,985	$795,776,715			12	2,760,733 UVRs	58,884 UVRs	50,820 UVRs	8,063 UVRs	2,752,670 UVRs
		13	104.33	0.45%	2.13%	$772,760,809	$18,368,670	$16,490,740	$1,877,930	$770,882,879		13	$290.392	$799,352,321	$17,099,305	$14,714,744	$2,384,561	$796,967,760			13	2,752,670 UVRs	58,884 UVRs	50,672 UVRs	8,212 UVRs	2,744,458 UVRs
		14	104.90	0.55%	2.24%	$770,882,879	$19,042,373	$17,261,347	$1,781,026	$769,101,853		14	$291.997	$801,373,007	$17,193,822	$14,751,941	$2,441,880	$798,931,127			14	2,744,458 UVRs	58,884 UVRs	50,521 UVRs	8,363 UVRs	2,736,095 UVRs
		15	105.39	0.46%	2.15%	$769,101,853	$18,466,020	$16,526,801	$1,939,219	$767,162,634		15	$293.351	$802,637,522	$17,273,587	$14,775,219	$2,498,368	$800,139,153			15	2,736,095 UVRs	58,884 UVRs	50,367 UVRs	8,517 UVRs	2,727,579 UVRs
		16	105.53	0.13%	1.81%	$767,162,634	$16,388,983	$13,902,616	$2,486,367	$764,676,268		16	$293.741	$801,202,058	$17,296,533	$14,748,795	$2,547,739	$798,654,319			16	2,727,579 UVRs	58,884 UVRs	50,210 UVRs	8,673 UVRs	2,718,905 UVRs
		17	105.34	-0.18%	1.50%	$764,676,268	$14,551,449	$11,449,444	$3,102,005	$761,574,263		17	$293.222	$797,241,620	$17,265,938	$14,675,889	$2,590,049	$794,651,571			17	2,718,905 UVRs	58,884 UVRs	50,051 UVRs	8,833 UVRs	2,710,072 UVRs
		18	105.10	-0.23%	1.44%	$761,574,263	$14,242,652	$10,984,031	$3,258,620	$758,315,643		18	$292.544	$792,815,999	$17,226,056	$14,594,421	$2,631,635	$790,184,365			18	2,710,072 UVRs	58,884 UVRs	49,888 UVRs	8,996 UVRs	2,701,076 UVRs
		19	104.97	-0.13%	1.55%	$758,315,643	$14,835,580	$11,739,891	$3,095,689	$755,219,953		19	$292.173	$789,181,911	$17,204,202	$14,527,524	$2,676,679	$786,505,232			19	2,701,076 UVRs	58,884 UVRs	49,722 UVRs	9,161 UVRs	2,691,915 UVRs
		20	105.07	0.10%	1.78%	$755,219,953	$16,165,977	$13,446,453	$2,719,525	$752,500,429		20	$292.470	$787,304,475	$17,221,685	$14,492,963	$2,728,722	$784,575,754			20	2,691,915 UVRs	58,884 UVRs	49,554 UVRs	9,330 UVRs	2,682,585UVRs
		21	105.16	0.08%	1.76%	$752,500,429	$16,053,323	$13,251,607	$2,801,716	$749,698,713		21	$292.711	$785,222,888	$17,235,890	$14,454,645	$2,781,245	$782,441,643			21	2,682,585 UVRs	58,884 UVRs	49,382 UVRs	9,502 UVRs	2,673,084 UVRs
		22	105.20	0.04%	1.72%	$749,698,713	$15,794,708	$12,863,479	$2,931,229	$746,767,484		22	$292.823	$782,739,262	$17,242,446	$14,408,925	$2,833,521	$779,905,742			22	2,673,084 UVRs	58,884 UVRs	49,207 UVRs	9,677 UVRs	2,663,407 UVRs
		23	105.26	0.06%	1.74%	$746,767,484	$15,922,595	$12,981,485	$2,941,110	$743,826,374		23	$292.999	$780,375,267	$17,252,826	$14,365,408	$2,887,418	$777,487,848			23	2,663,407 UVRs	58,884 UVRs	49,029 UVRs	9,855 UVRs	2,653,552 UVRs
		24	105.49	0.22%	1.90%	$743,826,374	$16,824,143	$14,103,610	$2,720,533	$741,105,841		24	$293.630	$779,162,036	$17,289,977	$14,343,074	$2,946,903	$776,215,133			24	2,653,552 UVRs	58,884 UVRs	48,847 UVRs	10,036 UVRs	2,643,516 UVRs
		25	105.99	0.47%	2.16%	$741,105,841	$18,363,497	$16,001,012	$2,362,485	$738,743,356		25	$295.022	$779,894,227	$17,371,928	$14,356,553	$3,015,375	$776,878,851			25	2,643,516 UVRs	58,884 UVRs	48,663 UVRs	10,221 UVRs	2,633,295 UVRs
		26	106.54	0.52%	2.20%	$738,743,356	$18,615,803	$16,263,928	$2,351,875	$736,391,481		26	$296.543	$780,885,774	$17,461,528	$14,374,806	$3,086,722	$777,799,052			26	2,633,295 UVRs	58,884 UVRs	48,475 UVRs	10,409 UVRs	2,622,886 UVRs
		27	105.13	-1.32%	0.33%	$736,391,481	$9,143,570	$2,464,268	$6,679,302	$729,712,179		27	$292.628	$767,529,311	$17,230,973	$14,128,935	$3,102,037	$764,427,274			27	2,622,886 UVRs	58,884 UVRs	48,283 UVRs	10,601 UVRs	2,612,286 UVRs
		28	103.21	-1.83%	-0.18%	$729,712,179	$7,201,606	-$1,311,990	$8,513,596	$721,198,582		28	$287.283	$750,466,460	$16,916,282	$13,814,837	$3,101,445	$747,365,015			28	2,612,286 UVRs	58,884 UVRs	48,088 UVRs	10,796 UVRs	2,601,490 UVRs
		29	104.04	0.80%	2.49%	$721,198,582	$20,072,400	$17,992,589	$2,079,811	$719,118,771		29	$289.594	$753,375,217	$17,052,320	$13,868,382	$3,183,938	$750,191,279			29	2,601,490 UVRs	58,884 UVRs	47,889 UVRs	10,994 UVRs	2,590,495 UVRs
		30	102.06	-1.90%	-0.26%	$719,118,771	$7,001,232	-$1,854,518	$8,855,751	$710,263,021		30	$284.082	$735,914,282	$16,727,795	$13,546,955	$3,180,840	$732,733,443			30	2,590,495 UVRs	58,884 UVRs	47,687 UVRs	11,197 UVRs	2,579,299 UVRs
		31	102.42	0.36%	2.04%	$710,263,021	$17,294,351	$14,483,079	$2,811,272	$707,451,749		31	$285.094	$735,341,972	$16,787,346	$13,536,420	$3,250,926	$732,091,046			31	2,579,299 UVRs	58,884 UVRs	47,481 UVRs	11,403 UVRs	2,567,896 UVRs
		32	102.70	0.27%	1.95%	$707,451,749	$16,800,635	$13,784,602	$3,016,032	$704,435,717		32	$285.855	$734,044,750	$16,832,146	$13,512,540	$3,319,605	$730,725,145			32	2,567,896 UVRs	58,884 UVRs	47,271 UVRs	11,613 UVRs	2,556,283 UVRs
		33	102.89	0.19%	1.87%	$704,435,717	$16,391,099	$13,186,042	$3,205,057	$701,230,660		33	$286.402	$732,124,502	$16,864,380	$13,477,192	$3,387,188	$728,737,314			33	2,556,283 UVRs	58,884 UVRs	47,057 UVRs	11,827 UVRs	2,544,456 UVRs
		34	103.08	0.18%	1.86%	$701,230,660	$16,319,710	$13,031,046	$3,288,664	$697,941,995		34	$286.912	$730,035,764	$16,894,428	$13,438,742	$3,455,687	$726,580,078			34	2,544,456 UVRs	58,884 UVRs	46,839 UVRs	12,044 UVRs	2,532,412 UVRs
		35	103.24	0.16%	1.84%	$697,941,995	$16,215,133	$12,829,990	$3,385,143	$694,556,853		35	$287.367	$727,731,403	$16,921,199	$13,396,322	$3,524,877	$724,206,526			35	2,532,412 UVRs	58,884 UVRs	46,617 UVRs	12,266 UVRs	2,520,145 UVRs
		36	103.41	0.16%	1.84%	$694,556,853	$16,247,754	$12,811,595	$3,436,159	$691,120,694		36	$287.840	$725,399,040	$16,949,062	$13,353,387	$3,595,675	$721,803,365			36	2,520,145 UVRs	58,884 UVRs	46,392 UVRs	12,492 UVRs	2,507,654 UVRs
		37	105.34	1.87%	3.58%	$691,120,694	$26,090,231	$24,728,856	$1,361,375	$689,759,319		37	$293.222	$735,298,061	$17,265,938	$13,535,612	$3,730,327	$731,567,734			37	2,507,654 UVRs	58,884 UVRs	46,162 UVRs	12,722 UVRs	2,494,932 UVRs
		38	105.10	-0.23%	1.44%	$689,759,319	$14,307,151	$9,948,259	$4,358,892	$685,400,427		38	$292.544	$729,877,881	$17,226,056	$13,435,835	$3,790,220	$726,087,660			38	2,494,932 UVRs	58,884 UVRs	45,928 UVRs	12,956 UVRs	2,481,976 UVRs
		39	104.97	-0.13%	1.55%	$685,400,427	$14,814,158	$10,611,051	$4,203,107	$681,197,320		39	$292.173	$725,166,522	$17,204,202	$13,349,107	$3,855,095	$721,311,426			39	2,481,976 UVRs	58,884 UVRs	45,689 UVRs	13,195 UVRs	2,468,781 UVRs
		40	105.07	0.10%	1.78%	$681,197,320	$15,946,613	$12,128,503	$3,818,110	$677,379,211		40	$292.470	$722,044,420	$17,221,685	$13,291,634	$3,930,051	$718,114,369			40	2,468,781 UVRs	58,884 UVRs	45,446 UVRs	13,437 UVRs	2,455,344 UVRs
		41	105.16	0.08%	1.76%	$677,379,211	$15,851,058	$11,928,715	$3,922,343	$673,456,868		41	$292.711	$718,706,685	$17,235,890	$13,230,192	$4,005,698	$714,700,987			41	2,455,344 UVRs	58,884 UVRs	45,199 UVRs	13,685 UVRs	2,441,659 UVRs
		42	105.20	0.04%	1.72%	$673,456,868	$15,632,186	$11,555,306	$4,076,880	$669,379,988		42	$292.823	$714,972,840	$17,242,446	$13,161,458	$4,080,988	$710,891,853			42	2,441,659 UVRs	58,884 UVRs	44,947 UVRs	13,937 UVRs	2,427,722 UVRs
		43	105.26	0.06%	1.74%	$669,379,988	$15,740,152	$11,636,214	$4,103,938	$665,276,050		43	$292.999	$711,319,829	$17,252,826	$13,094,213	$4,158,614	$707,161,215			43	2,427,722 UVRs	58,884 UVRs	44,690 UVRs	14,193 UVRs	2,413,529 UVRs
		44	105.49	0.22%	1.90%	$665,276,050	$16,498,569	$12,614,226	$3,884,344	$661,391,706		44	$293.630	$708,683,967	$17,289,977	$13,045,691	$4,244,287	$704,439,680			44	2,413,529 UVRs	58,884 UVRs	44,429 UVRs	14,455 UVRs	2,399,074 UVRs
		45	105.99	0.47%	2.16%	$661,391,706	$17,788,109	$14,279,926	$3,508,183	$657,883,523		45	$295.022	$707,778,573	$17,371,928	$13,029,024	$4,342,904	$703,435,669			45	2,399,074 UVRs	58,884 UVRs	44,163 UVRs	14,721 UVRs	2,384,354 UVRs
		46	106.54	0.52%	2.20%	$657,883,523	$17,998,748	$14,483,745	$3,515,004	$654,368,519		46	$296.543	$707,063,793	$17,461,528	$13,015,866	$4,445,662	$702,618,131			46	2,384,354 UVRs	58,884 UVRs	43,892 UVRs	14,992 UVRs	2,369,362 UVRs
		47	100.59	-5.58%	-4.00%	$654,368,519	$1,345,421	-$26,142,624	$27,488,044	$626,880,475		47	$280.000	$663,421,356	$16,487,406	$12,212,481	$4,274,924	$659,146,432			47	2,369,362 UVRs	58,884 UVRs	43,616 UVRs	15,268 UVRs	2,354,094 UVRs
		48	101.13	0.54%	2.22%	$626,880,475	$17,438,587	$13,935,318	$3,503,269	$623,377,206		48	$281.503	$662,684,828	$16,575,913	$12,198,923	$4,376,990	$658,307,838			48	2,354,094 UVRs	58,884 UVRs	43,335 UVRs	15,549 UVRs	2,338,546 UVRs
		49	101.64	0.50%	2.19%	$623,377,206	$17,268,830	$13,630,365	$3,638,466	$619,738,740		49	$282.913	$661,605,887	$16,658,956	$12,179,062	$4,479,895	$657,125,992			49	2,338,546 UVRs	58,884 UVRs	43,049 UVRs	15,835 UVRs	2,322,711 UVRs
		50	102.06	0.41%	2.10%	$619,738,740	$16,860,088	$12,997,768	$3,862,319	$615,876,421		50	$284.082	$659,841,389	$16,727,795	$12,146,580	$4,581,215	$655,260,174			50	2,322,711 UVRs	58,884 UVRs	42,757 UVRs	16,126 UVRs	2,306,585 UVRs
		51	102.42	0.36%	2.04%	$615,876,421	$16,598,647	$12,558,428	$4,040,219	$611,836,202		51	$285.094	$657,592,899	$16,787,346	$12,105,189	$4,682,157	$652,910,742			51	2,306,585 UVRs	58,884 UVRs	42,460 UVRs	16,423 UVRs	2,290,161 UVRs
		52	102.70	0.27%	1.95%	$611,836,202	$16,199,386	$11,921,546	$4,277,840	$607,558,362		52	$285.855	$654,653,141	$16,832,146	$12,051,073	$4,781,072	$649,872,068			52	2,290,161 UVRs	58,884 UVRs	42,158 UVRs	16,726 UVRs	2,273,436 UVRs
		53	103.24	0.53%	2.22%	$607,558,362	$17,374,347	$13,457,928	$3,916,420	$603,641,943		53	$287.367	$653,310,322	$16,921,199	$12,026,354	$4,894,845	$648,415,477			53	2,273,436 UVRs	58,884 UVRs	41,850 UVRs	17,033 UVRs	2,256,402 UVRs
		54	103.41	0.16%	1.84%	$603,641,943	$15,768,590	$11,134,605	$4,633,986	$599,007,957		54	$287.840	$649,483,189	$16,949,062	$11,955,903	$4,993,159	$644,490,030			54	2,256,402 UVRs	58,884 UVRs	41,537 UVRs	17,347 UVRs	2,239,055 UVRs
		55	105.34	1.87%	3.58%	$599,007,957	$23,768,148	$21,432,988	$2,335,160	$596,672,797		55	$293.222	$656,539,291	$17,265,938	$12,085,794	$5,180,144	$651,359,147			55	2,239,055 UVRs	58,884 UVRs	41,217 UVRs	17,666 UVRs	2,221,389UVRs
		56	105.10	-0.23%	1.44%	$596,672,797	$14,206,527	$8,605,691	$5,600,836	$591,071,961		56	$292.544	$649,854,568	$17,226,056	$11,962,739	$5,263,316	$644,591,251			56	2,221,389 UVRs	58,884 UVRs	40,892 UVRs	17,992 UVRs	2,203,398 UVRs
		57	104.97	-0.13%	1.55%	$591,071,961	$14,620,116	$9,150,702	$5,469,414	$585,602,547		57	$292.173	$643,773,502	$17,204,202	$11,850,797	$5,353,405	$638,420,097			57	2,203,398 UVRs	58,884 UVRs	40,561 UVRs	18,323 UVRs	2,185,075 UVRs
		58	105.07	0.10%	1.78%	$585,602,547	$15,537,720	$10,426,468	$5,111,251	$580,491,295		58	$292.470	$639,068,856	$17,221,685	$11,764,193	$5,457,492	$633,611,364			58	2,185,075 UVRs	58,884 UVRs	40,224 UVRs	18,660 UVRs	2,166,415 UVRs
		59	105.16	0.08%	1.76%	$580,491,295	$15,460,710	$10,222,509	$5,238,200	$575,253,095		59	$292.711	$634,133,980	$17,235,890	$11,673,350	$5,562,540	$628,571,439			59	2,166,415 UVRs	58,884 UVRs	39,880 UVRs	19,004 UVRs	2,147,411 UVRs
		60	102.70	-2.34%	-0.70%	$575,253,095	$7,515,728	-$4,053,258	$11,568,986	$563,684,109		60	$285.855	$613,847,391	$16,832,146	$11,299,907	$5,532,238	$608,315,152			60	2,147,411 UVRs	58,884 UVRs	39,530 UVRs	19,353 UVRs	2,128,058 UVRs
		61	103.24	0.53%	2.22%	$563,684,109	$17,071,396	$12,486,076	$4,585,320	$559,098,789		61	$287.367	$611,533,542	$16,921,199	$11,257,313	$5,663,886	$605,869,657			61	2,128,058 UVRs	58,884 UVRs	39,174 UVRs	19,710 UVRs	2,108,348 UVRs
		62	103.41	0.16%	1.84%	$559,098,789	$15,629,167	$10,312,974	$5,316,193	$553,782,596		62	$287.840	$606,867,311	$16,949,062	$11,171,416	$5,777,646	$601,089,665			62	2,108,348 UVRs	58,884 UVRs	38,811 UVRs	20,072 UVRs	2,088,276 UVRs
		63	105.34	1.87%	3.58%	$553,782,596	$22,779,703	$19,814,788	$2,964,915	$550,817,681		63	$293.222	$612,327,521	$17,265,938	$11,271,929	$5,994,009	$606,333,511			63	2,088,276 UVRs	58,884 UVRs	38,442 UVRs	20,442 UVRs	2,067,834 UVRs
		64	105.10	-0.23%	1.44%	$550,817,681	$14,239,613	$7,944,332	$6,295,282	$544,522,400		64	$292.544	$604,932,937	$17,226,056	$11,135,807	$6,090,249	$598,842,688			64	2,067,834 UVRs	58,884 UVRs	38,065 UVRs	20,818 UVRs	2,047,016 UVRs
		65	104.97	-0.13%	1.55%	$544,522,400	$14,610,765	$8,430,043	$6,180,722	$538,341,678		65	$292.173	$598,082,977	$17,204,202	$11,009,711	$6,194,491	$591,888,485			65	2,047,016 UVRs	58,884 UVRs	37,682 UVRs	21,201 UVRs	2,025,814 UVRs
		66	105.07	0.10%	1.78%	$538,341,678	$15,430,806	$9,585,003	$5,845,802	$532,495,876		66	$292.470	$592,489,960	$17,221,685	$10,906,753	$6,314,932	$586,175,028			66	2,025,814 UVRs	58,884 UVRs	37,292 UVRs	21,592 UVRs	2,004,223 UVRs
		67	105.16	0.08%	1.76%	$532,495,876	$15,362,219	$9,377,305	$5,984,914	$526,510,962		67	$292.711	$586,658,517	$17,235,890	$10,799,406	$6,436,484	$580,222,033			67	2,004,223 UVRs	58,884 UVRs	36,894 UVRs	21,989 UVRs	1,982,233 UVRs
		68	102.70	-2.34%	-0.70%	$526,510,962	$8,159,808	-$3,709,818	$11,869,627	$514,641,335		68	$285.855	$566,630,550	$16,832,146	$10,430,724	$6,401,422	$560,229,129			68	1,982,233 UVRs	58,884 UVRs	36,490 UVRs	22,394 UVRs	1,959,840 UVRs
		69	103.24	0.53%	2.22%	$514,641,335	$16,765,602	$11,399,737	$5,365,864	$509,275,471		69	$287.367	$563,193,112	$16,921,199	$10,367,447	$6,553,752	$556,639,359			69	1,959,840 UVRs	58,884 UVRs	36,077 UVRs	22,806 UVRs	1,937,033 UVRs
		70	103.41	0.16%	1.84%	$509,275,471	$15,493,953	$9,393,948	$6,100,005	$503,175,466		70	$287.840	$557,555,949	$16,949,062	$10,263,676	$6,685,386	$550,870,563			70	1,937,033 UVRs	58,884 UVRs	35,658 UVRs	23,226 UVRs	1,913,807 UVRs
		71	105.34	1.87%	3.58%	$503,175,466	$21,755,228	$18,004,024	$3,751,204	$499,424,262		71	$293.222	$561,169,532	$17,265,938	$10,330,196	$6,935,743	$554,233,789			71	1,913,807 UVRs	58,884 UVRs	35,230 UVRs	23,654 UVRs	1,890,154 UVRs
		72	105.10	-0.23%	1.44%	$499,424,262	$14,284,971	$7,203,095	$7,081,876	$492,342,386		72	$292.544	$552,953,561	$17,226,056	$10,178,953	$7,047,102	$545,906,458			72	1,890,154 UVRs	58,884 UVRs	34,795 UVRs	24,089 UVRs	1,866,065 UVRs
		73	104.97	-0.13%	1.55%	$492,342,386	$14,611,643	$7,622,216	$6,989,427	$485,352,959		73	$292.173	$545,213,903	$17,204,202	$10,036,479	$7,167,723	$538,046,180			73	1,866,065 UVRs	58,884 UVRs	34,351 UVRs	24,532 UVRs	1,841,532 UVRs
		74	105.07	0.10%	1.78%	$485,352,959	$15,329,676	$8,641,556	$6,688,120	$478,664,839		74	$292.470	$538,592,941	$17,221,685	$9,914,598	$7,307,087	$531,285,854			74	1,841,532 UVRs	58,884 UVRs	33,900 UVRs	24,984 UVRs	1,816,548 UVRs
		75	105.16	0.08%	1.76%	$478,664,839	$15,269,884	$8,429,335	$6,840,549	$471,824,290		75	$292.711	$531,724,070	$17,235,890	$9,788,154	$7,447,736	$524,276,334			75	1,816,548 UVRs	58,884 UVRs	33,440 UVRs	25,444 UVRs	1,791,104 UVRs
		76	107.15	1.90%	3.60%	$471,824,290	$21,344,347	$17,006,715	$4,337,631	$467,486,659		76	$298.260	$534,214,119	$17,562,600	$9,833,992	$7,728,609	$526,485,510			76	1,791,104 UVRs	58,884 UVRs	32,971 UVRs	25,912 UVRs	1,765,192 UVRs
		77	107.34	0.18%	1.86%	$467,486,659	$15,647,515	$8,688,187	$6,959,329	$460,527,330		77	$298.792	$527,424,512	$17,593,924	$9,709,006	$7,884,917	$519,539,595			77	1,765,192 UVRs	58,884 UVRs	32,494 UVRs	26,389 UVRs	1,738,802 UVRs
		78	107.42	0.07%	1.75%	$460,527,330	$15,323,613	$8,050,061	$7,273,552	$453,253,778		78	$299.000	$519,901,693	$17,606,186	$9,570,524	$8,035,662	$511,866,031			78	1,738,802 UVRs	58,884 UVRs	32,008 UVRs	26,875 UVRs	1,711,927 UVRs
		79	107.31	-0.11%	1.57%	$453,253,778	$14,818,523	$7,114,433	$7,704,090	$445,549,688		79	$298.684	$511,324,807	$17,587,570	$9,412,637	$8,174,933	$503,149,875			79	1,711,927 UVRs	58,884 UVRs	31,514 UVRs	27,370 UVRs	1,684,557 UVRs
		80	107.36	0.05%	1.73%	$445,549,688	$15,249,604	$7,686,903	$7,562,701	$437,986,987		80	$298.825	$503,387,988	$17,595,893	$9,266,534	$8,329,359	$495,058,629			80	1,684,557 UVRs	58,884 UVRs	31,010 UVRs	27,874 UVRs	1,656,684 UVRs
		81	107.36	0.00%	1.68%	$437,986,987	$15,128,683	$7,362,290	$7,766,393	$430,220,595		81	$298.836	$495,077,099	$17,596,550	$9,113,544	$8,483,005	$486,594,094			81	1,656,684 UVRs	58,884 UVRs	30,497 UVRs	28,387 UVRs	1,628,297 UVRs
		82	107.34	-0.02%	1.66%	$430,220,595	$15,069,203	$7,135,571	$7,933,632	$422,286,963		82	$298.782	$486,505,271	$17,593,338	$8,955,751	$8,637,586	$477,867,684			82	1,628,297 UVRs	58,884 UVRs	29,974 UVRs	28,909 UVRs	1,599,388 UVRs
		83	104.73	-2.43%	-0.79%	$422,286,963	$9,477,348	-$3,351,495	$12,828,843	$409,458,119		83	$291.521	$466,255,295	$17,165,812	$8,582,983	$8,582,829	$457,672,466			83	1,599,388 UVRs	58,884 UVRs	29,442 UVRs	29,442 UVRs	1,569,946 UVRs
		84	104.86	0.12%	1.80%	$409,458,119	$15,250,592	$7,365,795	$7,884,797	$401,573,323		84	$291.870	$458,220,574	$17,186,370	$8,435,077	$8,751,293	$449,469,282			84	1,569,946 UVRs	58,884 UVRs	28,900 UVRs	29,984 UVRs	1,539,963 UVRs
		85	104.97	0.11%	1.79%	$401,573,323	$15,219,973	$7,174,451	$8,045,522	$393,527,801		85	$292.184	$449,953,072	$17,204,868	$8,282,886	$8,921,982	$441,031,089			85	1,539,963 UVRs	58,884 UVRs	28,348 UVRs	30,535 UVRs	1,509,427 UVRs
		86	105.07	0.10%	1.77%	$393,527,801	$15,191,693	$6,984,760	$8,206,933	$385,320,868		86	$292.465	$441,455,149	$17,221,411	$8,126,454	$9,094,958	$432,360,191			86	1,509,427 UVRs	58,884 UVRs	27,786 UVRs	31,098 UVRs	1,478,330 UVRs
		87	105.16	0.09%	1.77%	$385,320,868	$15,169,391	$6,802,681	$8,366,711	$376,954,157		87	$292.719	$432,735,728	$17,236,369	$7,965,944	$9,270,426	$423,465,302			87	1,478,330 UVRs	58,884 UVRs	27,214 UVRs	31,670 UVRs	1,446,660 UVRs
		88	105.25	0.08%	1.76%	$376,954,157	$15,150,897	$6,624,633	$8,526,264	$368,427,894		88	$292.950	$423,799,595	$17,249,976	$7,801,444	$9,448,532	$414,351,063			88	1,446,660 UVRs	58,884 UVRs	26,631 UVRs	32,253 UVRs	1,414,407 UVRs
		89	105.32	0.07%	1.75%	$368,427,894	$15,138,296	$6,454,031	$8,684,265	$359,743,629		89	$293.165	$414,655,198	$17,262,638	$7,633,111	$9,629,527	$405,025,671			89	1,414,407 UVRs	58,884 UVRs	26,037 UVRs	32,847 UVRs	1,381,560 UVRs
		90	105.40	0.07%	1.75%	$359,743,629	$15,130,581	$6,289,138	$8,841,443	$350,902,186		90	$293.370	$405,308,827	$17,274,706	$7,461,060	$9,813,646	$395,495,181			90	1,381,560 UVRs	58,884 UVRs	25,432 UVRs	33,451 UVRs	1,348,108 UVRs
		91	105.47	0.07%	1.74%$350,902,186	$15,123,701	$6,123,142	$9,000,559	$341,901,626		91	$293.566	$395,759,007	$17,286,230	$7,285,264	$10,000,966	$385,758,041			91	1,348,108 UVRs	58,884 UVRs	24,816 UVRs	34,067 UVRs	1,314,041 UVRs
		92	105.53	0.06%	1.74%	$341,901,626	$15,118,037	$5,956,638	$9,161,399	$332,740,228		92	$293.754	$386,004,890	$17,297,291	$7,105,707	$10,191,585	$375,813,305			92	1,314,041 UVRs	58,884 UVRs	24,189 UVRs	34,694 UVRs	1,279,347 UVRs
		93	105.60	0.06%	1.74%	$332,740,228	$15,112,006	$5,786,931	$9,325,075	$323,415,153		93	$293.933	$376,042,574	$17,307,844	$6,922,317	$10,385,527	$365,657,048			93	1,279,347 UVRs	58,884 UVRs	23,551 UVRs	35,333 UVRs	1,244,014 UVRs
		94	105.66	0.06%	1.74%	$323,415,153	$15,105,441	$5,613,719	$9,491,722	$313,923,431		94	$294.103	$365,867,853	$17,317,822	$6,735,017	$10,582,804	$355,285,049			94	1,244,014 UVRs	58,884 UVRs	22,900 UVRs	35,983 UVRs	1,208,031 UVRs
		95	105.71	0.05%	1.73%	$313,923,431	$15,094,031	$5,429,716	$9,664,315	$304,259,116		95	$294.254	$355,468,448	$17,326,761	$6,543,582	$10,783,180	$344,685,268			95	1,208,031 UVRs	58,884 UVRs	22,238 UVRs	36,646 UVRs	1,171,385 UVRs
		96	104.73	-0.93%	0.73%	$304,259,116	$13,363,369	$2,229,185	$11,134,185	$293,124,932		96	$291.521	$341,483,468	$17,165,812	$6,286,142	$10,879,671	$330,603,797			96	1,171,385 UVRs	58,884 UVRs	21,563 UVRs	37,320 UVRs	1,134,065 UVRs
		97	104.86	0.12%	1.80%	$293,124,932	$15,147,057	$5,273,062	$9,873,995	$283,250,937		97	$291.870	$330,999,728	$17,186,370	$6,093,153	$11,093,216	$319,906,512			97	1,134,065 UVRs	58,884 UVRs	20,876 UVRs	38,007 UVRs	1,096,057 UVRs
		98	104.97	0.11%	1.79%	$283,250,937	$15,126,489	$5,060,520	$10,065,969	$273,184,968		98	$292.184	$320,250,846	$17,204,868	$5,895,284	$11,309,584	$308,941,262			98	1,096,057 UVRs	58,884 UVRs	20,177 UVRs	38,707 UVRs	1,057,350 UVRs
		99	105.07	0.10%	1.77%	$273,184,968	$15,107,774	$4,848,784	$10,258,989	$262,925,979		99	$292.465	$309,238,314	$17,221,411	$5,692,562	$11,528,849	$297,709,465			99	1,057,350 UVRs	58,884 UVRs	19,464 UVRs	39,420 UVRs	1,017,931 UVRs
		100	105.16	0.09%	1.77%	$262,925,979	$15,093,249	$4,641,849	$10,451,400	$252,474,579		100	$292.719	$297,968,048	$17,236,369	$5,485,095	$11,751,274	$286,216,774			100	1,017,931 UVRs	58,884 UVRs	18,738 UVRs	40,145 UVRs	977,785 UVRs
		101	105.25	0.08%	1.76%	$252,474,579	$15,081,412	$4,437,015	$10,644,397	$241,830,182		101	$292.950	$286,442,719	$17,249,976	$5,272,933	$11,977,043	$274,465,676			101	977,785 UVRs	58,884 UVRs	17,999 UVRs	40,884 UVRs	936,901 UVRs
		102	105.32	0.07%	1.75%	$241,830,182	$15,073,498	$4,236,323	$10,837,175	$230,993,007		102	$293.165	$274,667,135	$17,262,638	$5,056,164	$12,206,473	$262,460,661			102	936,901 UVRs	58,884 UVRs	17,247 UVRs	41,637 UVRs	895,265 UVRs
		103	105.40	0.07%	1.75%	$230,993,007	$15,068,750	$4,038,284	$11,030,466	$219,962,541		103	$293.370	$262,644,150	$17,274,706	$4,834,841	$12,439,865	$250,204,284			103	895,265 UVRs	58,884 UVRs	16,480 UVRs	42,403 UVRs	852,861 UVRs
		104	105.47	0.07%	1.74%	$219,962,541	$15,064,610	$3,838,283	$11,226,327	$208,736,214		104	$293.566	$250,371,190	$17,286,230	$4,608,916	$12,677,313	$237,693,877			104	852,861 UVRs	58,884 UVRs	15,700 UVRs	43,184 UVRs	809,677 UVRs
		105	105.53	0.06%	1.74%	$208,736,214	$15,061,283	$3,636,619	$11,424,664	$197,311,550		105	$293.754	$237,845,978	$17,297,291	$4,378,348	$12,918,943	$224,927,035			105	809,677 UVRs	58,884 UVRs	14,905 UVRs	43,979 UVRs	765,699 UVRs
		106	105.60	0.06%	1.74%	$197,311,550	$15,057,834	$3,431,591	$11,626,244	$185,685,307		106	$293.933	$225,064,254	$17,307,844	$4,143,058	$13,164,786	$211,899,469			106	765,699 UVRs	58,884 UVRs	14,095 UVRs	44,788 UVRs	720,910 UVRs
		107	105.66	0.06%	1.74%	$185,685,307	$15,054,189	$3,223,056	$11,831,133	$173,854,173		107	$294.103	$212,021,631	$17,317,822	$3,902,965	$13,414,857	$198,606,774			107	720,910 UVRs	58,884 UVRs	13,271 UVRs	45,613 UVRs	675,297 UVRs
		108	105.71	0.05%	1.73%	$173,854,173	$15,048,057	$3,007,035	$12,041,022	$161,813,151		108	$294.254	$198,709,295	$17,326,761	$3,657,907	$13,668,854	$185,040,441			108	675,297 UVRs	58,884 UVRs	12,431 UVRs	46,452 UVRs	628,845 UVRs
		109	107.15	1.36%	3.06%	$161,813,151	$16,315,433	$4,953,260	$11,362,173	$150,450,978		109	$298.260	$187,559,075	$17,562,600	$3,452,650	$14,109,950	$173,449,124			109	628,845 UVRs	58,884 UVRs	11,576 UVRs	47,308 UVRs	581,537 UVRs
		110	107.34	0.18%	1.86%	$150,450,978	$15,249,290	$2,796,114	$12,453,176	$137,997,802		110	$298.792	$173,758,476	$17,593,924	$3,198,604	$14,395,320	$159,363,156			110	581,537 UVRs	58,884 UVRs	10,705 UVRs	48,178 UVRs	533,359 UVRs
		111	107.42	0.07%	1.75%	$137,997,802	$15,160,967	$2,412,215	$12,748,752	$125,249,050		111	$299.000	$159,474,226	$17,606,186	$2,935,655	$14,670,531	$144,803,695			111	533,359 UVRs	58,884 UVRs	9,818 UVRs	49,065 UVRs	484,294 UVRs
		112	107.31	-0.11%	1.57%	$125,249,050	$15,031,431	$1,965,954	$13,065,477	$112,183,573		112	$298.684	$144,650,586	$17,587,570	$2,662,776	$14,924,794	$129,725,792			112	484,294 UVRs	58,884 UVRs	8,915 UVRs	49,969 UVRs	434,325 UVRs
		113	107.36	0.05%	1.73%	$112,183,573	$15,133,363	$1,935,461	$13,197,902	$98,985,671		113	$298.825	$129,787,184	$17,595,893	$2,389,166	$15,206,727	$114,580,457			113	434,325 UVRs	58,884 UVRs	7,995 UVRs	50,888 UVRs	383,437 UVRs
		114	107.36	0.00%	1.68%	$98,985,671	$15,107,449	$1,663,888	$13,443,561	$85,542,110		114	$298.836	$114,584,732	$17,596,550	$2,109,314	$15,487,236	$99,097,496			114	383,437 UVRs	58,884 UVRs	7,058 UVRs	51,825 UVRs	331,611 UVRs
		115	107.34	-0.02%	1.66%	$85,542,110	$15,095,988	$1,418,788	$13,677,200	$71,864,910		115	$298.782	$99,079,406	$17,593,338	$1,823,887	$15,769,451	$83,309,955			115	331,611 UVRs	58,884 UVRs	6,104 UVRs	52,779 UVRs	278,832 UVRs
		116	107.34	0.00%	1.68%	$71,864,910	$15,104,167	$1,205,278	$13,898,888	$57,966,022		116	$298.782	$83,309,955	$17,593,338	$1,533,597	$16,059,740	$67,250,215			116	278,832 UVRs	58,884 UVRs	5,133 UVRs	53,751 UVRs	225,081 UVRs
		117	107.15	-0.17%	1.50%	$57,966,022	$15,038,800	$869,203	$14,169,597	$43,796,425		117	$298.260	$67,132,722	$17,562,600	$1,235,802	$16,326,799	$50,805,924			117	225,081 UVRs	58,884 UVRs	4,143 UVRs	54,740 UVRs	170,341 UVRs
		118	107.34	0.18%	1.86%	$43,796,425	$15,144,773	$813,952	$14,330,822	$29,465,603		118	$298.792	$50,896,537	$17,593,924	$936,920	$16,657,003	$34,239,534			118	170,341 UVRs	58,884 UVRs	3,136 UVRs	55,748 UVRs	114,593 UVRs
		119	107.42	0.07%	1.75%	$29,465,603	$15,120,213	$515,062	$14,605,152	$14,860,451		119	$299.000	$34,263,398	$17,606,186	$630,732	$16,975,454	$17,287,944			119	114,593 UVRs	58,884 UVRs	2,109 UVRs	56,774 UVRs	57,819 UVRs
		120	107.31	-0.11%	1.57%	$14,860,451	$15,093,706	$233,255	$14,860,451	$0		120	$298.684	$17,269,664	$17,587,570	$317,906	$17,269,664	-$0			120	57,819 UVRs	58,884 UVRs	1,064 UVRs	57,819 UVRs	-0 UVRs