RETROALIMENTACION TALLER N 6 (1)

Prévia do material em texto

1V
	600,000	5%	6,502,662
	NO	CUOTA 	INTERES 	ABONO	 SALDO
	- 0				6,502,662
	1	600,000	325,133	274,867	6,227,795
	2	600,000	311,390	288,610	5,939,185
	3	600,000	296,959	303,041	5,636,144
	4	600,000	281,807	318,193	5,317,951
	5	600,000	265,898	334,102	4,983,849
	6	600,000	249,192	350,808	4,633,041
	7	600,000	231,652	368,348	4,264,693
	8	600,000	213,235	386,765	3,877,928
	9	600,000	193,896	406,104	3,471,824
	10	600,000	173,591	426,409	3,045,415
	11	600,000	152,271	447,729	2,597,686
	12	600,000	129,884	470,116	2,127,570
	13	600,000	106,379	493,621	1,633,949
	14	600,000	81,697	518,303	1,115,646
	15	600,000	55,782	544,218	571,429
	16	600,000	28,571	571,429	- 0
2V
	80,000	3%	442,842
	NO	CUOTA 	INTERES 	ABONO	 SALDO
	- 0				442,842
	1		13,285	- 13,285	456,127
	2		13,684	- 13,684	469,811
	3		14,094	- 14,094	483,905
	4		14,517	- 14,517	498,423
	5	80,000	14,953	65,047	433,375
	6	80,000	13,001	66,999	366,377
	7	80,000	10,991	69,009	297,368
	8	80,000	8,921	71,079	226,289
	9	80,000	6,789	73,211	153,078
	10	80,000	4,592	75,408	77,670
	11	80,000	2,330	77,670	- 0
3V
	391,250	1.0%	8,500,000	24
	NO	CUOTA 	INTERES 	ABONO	 SALDO
	0				8,500,000
	1	391,250	85,000.0	306,250.0	8,193,750.0
	2	391,250	81,937.5	309,312.5	7,884,437.5
	3	391,250	78,844.4	312,405.6	7,572,031.9
	4	391,250	75,720.3	315,529.7	7,256,502.2
	5	391,250	72,565.0	318,685.0	6,937,817.2
	6	391,250	69,378.2	321,871.8	6,615,945.4
	7	391,250	66,159.5	325,090.5	6,290,854.8
	8	391,250	62,908.5	328,341.5	5,962,513.4
	9	391,250	59,625.1	331,624.9	5,630,888.5
	10	391,250	56,308.9	334,941.1	5,295,947.4
	11	391,250	52,959.5	338,290.5	4,957,656.9
	12	391,250	49,576.6	341,673.4	4,615,983.5
	13	391,250	46,159.8	345,090.2	4,270,893.3
	14	391,250	42,708.9	348,541.1	3,922,352.2
	15	391,250	39,223.5	352,026.5	3,570,325.7
	16	391,250	35,703.3	355,546.7	3,214,779.0
	17	391,250	32,147.8	359,102.2	2,855,676.8
	18	391,250	28,556.8	362,693.2	2,492,983.6
	19	391,250	24,929.8	366,320.2	2,126,663.4
	20	391,250	21,266.6	369,983.4	1,756,680.0
	21	391,250	17,566.8	373,683.2	1,382,996.8
	22	391,250	13,830.0	377,420.0	1,005,576.8
	23	391,250	10,055.8	381,194.2	624,382.6
	24	391,250	6,243.8	385,006.2	239,376.4
	25	391,250	2,393.8	388,856.2	- 149,479.8
4V
	60,000,000	2.21%	800000
	NO	CUOTA	INTERES 	ABONO	 SALDO
	0				60,000,000
	1	800,000	1,324,694	- 524,694	60,524,694
	2	800,000	1,336,279	- 536,279	61,060,973
	3	800,000	1,348,119	- 548,119	61,609,092
	4	800,000	1,360,220	- 560,220	62,169,312
	5	800,000	1,372,589	- 572,589	62,741,901
	6	800,000	1,385,231	- 585,231	63,327,132
	7	800,000	1,398,152	- 598,152	63,925,283
	8	800,000	1,411,358	- 611,358	64,536,641
	9	800,000	1,424,855	- 624,855	65,161,496
	10	800,000	1,438,651	- 638,651	65,800,147
	11	800,000	1,452,751	- 652,751	66,452,899
	12	800,000	1,467,163	- 667,163	67,120,062
	13	800,000	1,481,893	- 681,893	67,801,955
	14	800,000	1,496,948	- 696,948	68,498,902
	15	800,000	1,512,335	- 712,335	69,211,237
	16	800,000	1,528,062	- 728,062	69,939,300
	17	800,000	1,544,137	- 744,137	70,683,436
	18	800,000	1,560,566	- 760,566	71,444,002
	19	800,000	1,577,358	- 777,358	72,221,360
	20	800,000	1,594,520	- 794,520	73,015,880
		El dinero nunca se va a agotar.
5V
	350,000	18,000,000	1.94%	23.32%
	NO	DEPOSITO	INTERES	D+I	SALDO
	0
	1	350,000			350,000
	2	350,000	6,801	356,801	706,801
	3	350,000	13,733	363,733	1,070,534
	4	350,000	20,801	370,801	1,441,335
	5	350,000	28,006	378,006	1,819,341
	6	350,000	35,351	385,351	2,204,692
	7	350,000	42,838	392,838	2,597,530
	8	350,000	50,471	400,471	2,998,001
	9	350,000	58,253	408,253	3,406,253
	10	350,000	66,185	416,185	3,822,438
	11	350,000	74,272	424,272	4,246,710
	12	350,000	82,516	432,516	4,679,226
	13	350,000	90,919	440,919	5,120,145
	14	350,000	99,487	449,487	5,569,632
	15	350,000	108,220	458,220	6,027,852
	16	350,000	117,124	467,124	6,494,976
	17	350,000	126,200	476,200	6,971,177
	18	350,000	135,453	485,453	7,456,630
	19	350,000	144,886	494,886	7,951,516
	20	350,000	154,502	504,502	8,456,017
	21	350,000	164,304	514,304	8,970,321
	22	350,000	174,297	524,297	9,494,619
	23	350,000	184,485	534,485	10,029,104
	24	350,000	194,870	544,870	10,573,974
	25	350,000	205,457	555,457	11,129,431
	26	350,000	216,250	566,250	11,695,681
	27	350,000	227,252	577,252	12,272,933
	28	350,000	238,469	588,469	12,861,402
	29	350,000	249,903	599,903	13,461,305
	30	350,000	261,559	611,559	14,072,864
	31	350,000	273,442	623,442	14,696,306
	32	350,000	285,556	635,556	15,331,862
	33	350,000	297,905	647,905	15,979,767
	34	350,000	310,494	660,494	16,640,261
	35	350,000	323,328	673,328	17,313,589
	36	350,000	336,411	686,411	18,000,000
6V
	260000	1.39%	7,345,971
	NO	DEPOSITO	INTERES	D+I	SALDO
	0
	1	260,000			260,000
	2	260,000	3,611	263,611	523,611
	3	260,000	7,272	267,272	790,883
	4	260,000	10,984	270,984	1,061,867
	5	260,000	14,748	274,748	1,336,615
	6	260,000	18,563	278,563	1,615,178
	7	260,000	22,432	282,432	1,897,611
	8	260,000	26,355	286,355	2,183,966
	9	260,000	30,332	290,332	2,474,297
	10	260,000	34,364	294,364	2,768,661
	11	260,000	38,452	298,452	3,067,114
	12	260,000	42,597	302,597	3,369,711
	13	260,000	46,800	306,800	3,676,511
	14	260,000	51,061	311,061	3,987,572
	15	260,000	55,381	315,381	4,302,953
	16	260,000	59,761	319,761	4,622,715
	17	260,000	64,202	324,202	4,946,917
	18	260,000	68,705	328,705	5,275,622
	19	260,000	73,270	333,270	5,608,892
	20	260,000	77,899	337,899	5,946,791
	21	260,000	82,592	342,592	6,289,382
	22	260,000	87,350	347,350	6,636,732
	23	260,000	92,174	352,174	6,988,906
	24	260,000	97,065	357,065	7,345,971
			1,105,971
7V
	300,000	6.12%	5,096,821
	NO	DEPOSITO	INTERES	D+I	SALDO
	0
	1	300,000			300,000
	2	300,000	18,362	318,362	618,362
	3	300,000	37,849	337,849	956,211
	4	300,000	58,528	358,528	1,314,739
	5	300,000	80,473	380,473	1,695,211
	6	300,000	103,761	403,761	2,098,972
	7	300,000	128,474	428,474	2,527,446
	8	300,000	154,700	454,700	2,982,146
	9	300,000	182,531	482,531	3,464,677
	10	300,000	212,066	512,066	3,976,743
	11	300,000	243,408	543,408	4,520,151
	12	300,000	276,669	576,669	5,096,821
			1,496,821
1A
	30,000	3%	424,984
	NO	CUOTA 	INTERES 	ABONO	 SALDO
	0	30,000			394,984
	1	30,000	11849.5066246569	18,150	376,833
	2	30,000	11304.9918233966	18,695	358,138
	3	30,000	10744.1415780985	19,256	338,882
	4	30,000	10166.4658254414	19,834	319,049
	5	30,000	9571.4598002047	20,429	298,620
	6	30,000	8958.6035942108	21,041	277,579
	7	30,000	8327.3617020371	21,673	255,906
	8	30,000	7677.1825530982	22,323	233,583
	9	30,000	7007.4980296912	22,993	210,591
	10	30,000	6317.7229705819	23,682	186,908
	11	30,000	5607.2546596994	24,393	162,516
	12	30,000	4875.4722994904	25,125	137,391
	13	30,000	4121.7364684751	25,878	111,513
	14	30,000	3345.3885625293	26,655	84,858
	15	30,000	2545.7502194052	27,454	57,404
	16	30,000	1722.1227259874	28,278	29,126
	17	30,000	873.786407767	29,126	0
2A
	5,000,000	500,000	1,000,000	4%	12,997,746
	NO	CUOTA 	INTERES 	ABONO	 SALDO
	0	5,500,000			7,497,746
	1	500,000	299,910	200,090	7,297,656
	2	500,000	291,906	208,094	7,089,562
	3	500,000	283,582	216,418	6,873,145
	4	500,000	274,926	225,074	6,648,070
	5	500,000	265,923	234,077	6,413,993
	6	1,500,000	256,560	1,243,440	5,170,553
	7	500,000	206,822	293,178	4,877,375
	8	500,000	195,095	304,905	4,572,470
	9	500,000	182,899	317,101	4,255,369
	10	500,000	170,215	329,785	3,925,584
	11	500,000	157,023	342,977	3,582,607
	12	1,500,000	143,304	1,356,696	2,225,911
	13	500,000	89,036	410,964	1,814,948
	14	500,000	72,598	427,402	1,387,546
	15	500,000	55,502	444,498	943,047
	16	500,000	37,722	462,278	480,769
	17	500,000	19,231	480,769	0
3A
	1,536,810	15,000,000	4%
	NO	CUOTA 	INTERES 	ABONO	 SALDO
	0	1,536,810			13,463,190
	1	1,536,810	538527.592681121	998,283	12,464,907
	2	1,536,810	498596.289069487	1,038,214	11,426,693
	3	1,536,810	457067.733313388	1,079,742	10,346,951
	4	1,536,810	413878.035327045	1,122,932	9,224,019
	5	1,536,810	368960.749421248	1,167,849	8,056,169
	6	1,536,810	322246.772079219	1,214,563	6,841,606
	7	1,536,810	273664.235643509	1,263,146	5,578,460
	8	1,536,810	223138.397750371,313,672	4,264,788
	9	1,536,810	170591.526341506	1,366,219	2,898,570
	10	1,536,810	115942.780076288	1,420,867	1,477,702
	11	1,536,810	59108.0839604604	1,477,702	- 0
4A
	2,000,000	400,000	3%	5
	NO	CUOTA 	INTERES 	ABONO	 SALDO
	0	400,000			1,600,000
	1	400,000	48,000	352,000	1,248,000
	2	400,000	37,440	362,560	885,440
	3	400,000	26,563	373,437	512,003
	4	400,000	15,360	384,640	127,363
	5	400,000	3,821	396,179	- 268,816
	6	400,000	- 8,064	408,064	- 676,880
	7	400,000	- 20,306	420,306	- 1,097,187
	8	400,000	- 32,916	432,916	- 1,530,102
	9	400,000	- 45,903	445,903	- 1,976,005
	10	400,000	- 59,280	459,280	- 2,435,286
	11	400,000	- 73,059	473,059	- 2,908,344
	12	400,000	- 87,250	487,250	- 3,395,594
5A
	200,000	6,000,000	3.77%
	NO	DEPOSITO	INTERES	D+I	SALDO
	0	200,000			200,000
	1	200,000	7,549	207,549	407,549
	2	200,000	15,383	215,383	622,931
	3	200,000	23,512	223,512	846,444
	4	200,000	31,948	231,948	1,078,392
	5	200,000	40,703	240,703	1,319,095
	6	200,000	49,788	249,788	1,568,883
	7	200,000	59,216	259,216	1,828,100
	8	200,000	69,000	269,000	2,097,100
	9	200,000	79,153	279,153	2,376,253
	0	- 0	89,690	89,690	2,465,943
	1	- 0	93,075	93,075	2,559,019
	2	- 0	96,588	96,588	2,655,607
	3	- 0	100,234	100,234	2,755,841
	4	- 0	104,017	104,017	2,859,858
	5	- 0	107,943	107,943	2,967,801
	6	- 0	112,017	112,017	3,079,819
	7	- 0	116,245	116,245	3,196,064
	8	- 0	120,633	120,633	3,316,697
	9	- 0	125,186	125,186	3,441,883
	10	- 0	129,911	129,911	3,571,795
	11	- 0	134,815	134,815	3,706,609
	12	- 0	139,903	139,903	3,846,513
	13	- 0	145,184	145,184	3,991,696
	14	- 0	150,664	150,664	4,142,360
	15	- 0	156,350	156,350	4,298,710
	16	- 0	162,252	162,252	4,460,962
	17	- 0	168,376	168,376	4,629,338
	18	- 0	174,731	174,731	4,804,069
	19	- 0	181,326	181,326	4,985,395
	20	- 0	188,170	188,170	5,173,565
	21	- 0	195,272	195,272	5,368,837
	22	- 0	202,643	202,643	5,571,480
	23	- 0	210,291	210,291	5,781,771
	24	- 0	218,229	218,229	6,000,000
6A
	100,000	3%	50,000
	NO	DEPOSITO	INTERES	D+I	SALDO
	0	50,000			50,000
	1	50,000	1500	51,500	101,500
	2	50,000	3045	53,045	154,545
	3	50,000	4636.35	54,636	209,181
	4	50,000	6275.4405	56,275	265,457
	5	50,000	7963.703715	57,964	323,420
	6	50,000	9702.61482645	59,703	383,123
	7	50,000	11493.6932712435	61,494	444,617
	8	50,000	13338.5040693808	63,339	507,955
	9	50,000	15238.6591914622	65,239	573,194
	10	50,000	17195.8189672061	67,196	640,390
	11	50,000	19211.6935362223	69,212	709,601
	12		21288.0443423089	21,288	730,890
7A
	1,500,000	75,000	3.87%
	NO	CUOTA 	INTERES 	ABONO	 SALDO
	0	75,000			1,425,000
	1	75,000	55,140	19,860	1,405,140
	2	75,000	54,371	20,629	1,384,511
	3	75,000	53,573	21,427	1,363,084
	4	75,000	52,744	22,256	1,340,827
	5	75,000	51,883	23,117	1,317,710
	6	75,000	50,988	24,012	1,293,698
	7	75,000	50,059	24,941	1,268,757
	8	75,000	49,094	25,906	1,242,851
	9	75,000	48,091	26,909	1,215,942
	10	75,000	47,050	27,950	1,187,993
	11	75,000	45,969	29,031	1,158,961
	12	75,000	44,845	30,155	1,128,807
	13	75,000	43,679	31,321	1,097,485
	14	75,000	42,467	32,533	1,064,952
	15	75,000	41,208	33,792	1,031,160
	16	75,000	39,900	35,100	996,060
	17	75,000	38,542	36,458	959,602
	18	75,000	37,131	37,869	921,733
	19	75,000	35,666	39,334	882,399
	20	75,000	34,144	40,856	841,543
	21	75,000	32,563	42,437	799,106
	22	75,000	30,921	44,079	755,027
	23	75,000	29,215	45,785	709,243
	24	75,000	27,444	47,556	661,686
	25	75,000	25,604	49,396	612,290
	26	75,000	23,692	51,308	560,982
	27	75,000	21,707	53,293	507,689
	28	75,000	19,645	55,355	452,334
	29	75,000	17,503	57,497	394,837
	30	75,000	15,278	59,722	335,115
	31	75,000	12,967	62,033	273,082
	32	75,000	10,567	64,433	208,649
	33	75,000	8,074	66,926	141,722
	34	75,000	5,484	69,516	72,206
	35	75,000	2,794	72,206	0