Presupuesto - Tercer Corte.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Presupuesto - Tercer Corte.xlsx as PDF for free.
More details
- Words: 1,568
- Pages: 10
Prestamo Meses Tasa N° Cuota Cuota 0 1 3,597,892 2 3,597,892 3 3,597,892 4 3,597,892 5 3,597,892 6 3,597,892 7 3,597,892 8 3,597,892 9 3,597,892 10 3,597,892 11 3,597,892 12 3,597,892 13 3,597,892 14 3,597,892 15 3,597,892 16 3,597,892 17 3,597,892 18 3,597,892 19 3,597,892 20 3,597,892 21 3,597,892 22 3,597,892 23 3,597,892 24 3,597,892 25 3,597,892 26 3,597,892 27 3,597,892 28 3,597,892 29 3,597,892 30 3,597,892 SUMA 107,936,755
100,000,000 30 0.5% CUOTA FIJA Interes Abono K 500,000 484,511 468,944 453,299 437,576 421,774 405,894 389,934 373,894 357,774 341,573 325,292 308,929 292,484 275,957 259,347 242,655 225,878 209,018 192,074 175,045 157,931 140,731 123,445 106,073 88,614 71,067 53,433 35,711 17,900 7,936,755
3,097,892 3,113,381 3,128,948 3,144,593 3,160,316 3,176,117 3,191,998 3,207,958 3,223,998 3,240,118 3,256,318 3,272,600 3,288,963 3,305,408 3,321,935 3,338,545 3,355,237 3,372,013 3,388,874 3,405,818 3,422,847 3,439,961 3,457,161 3,474,447 3,491,819 3,509,278 3,526,825 3,544,459 3,562,181 3,579,992 100,000,000
Vr.Cuota
Saldo 100,000,000 96,902,108 93,788,727 90,659,779 87,515,186 84,354,870 81,178,752 77,986,754 74,778,796 71,554,798 68,314,680 65,058,362 61,785,762 58,496,799 55,191,391 51,869,456 48,530,912 45,175,674 41,803,661 38,414,787 35,008,969 31,586,122 28,146,161 24,689,000 21,214,553 17,722,734 14,213,456 10,686,632 7,142,173 3,579,992 0
(C*I) (1-(1+I)^-n)
500,000 0.13897027
N° Cuota 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 SUMA
3,597,892
Cuota 3,833,333 3,816,667 3,800,000 3,783,333 3,766,667 3,750,000 3,733,333 3,716,667 3,700,000 3,683,333 3,666,667 3,650,000 3,633,333 3,616,667 3,600,000 3,583,333 3,566,667 3,550,000 3,533,333 3,516,667 3,500,000 3,483,333 3,466,667 3,450,000 3,433,333 3,416,667 3,400,000 3,383,333 3,366,667 3,350,000 107,750,000
CUOTA VARIABLE Interes Abono K 500,000 483,333 466,667 450,000 433,333 416,667 400,000 383,333 366,667 350,000 333,333 316,667 300,000 283,333 266,667 250,000 233,333 216,667 200,000 183,333 166,667 150,000 133,333 116,667 100,000 83,333 66,667 50,000 33,333 16,667 7,750,000
3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 100,000,000
Saldo 100,000,000 96,666,667 93,333,333 90,000,000 86,666,667 83,333,333 80,000,000 76,666,667 73,333,333 70,000,000 66,666,667 63,333,333 60,000,000 56,666,667 53,333,333 50,000,000 46,666,667 43,333,333 40,000,000 36,666,667 33,333,333 30,000,000 26,666,667 23,333,333 20,000,000 16,666,667 13,333,333 10,000,000 6,666,667 3,333,333 0
4 SEMESTRE
3 SEMESTRE
2 SEMESTRE
1 SEMESTRE
Prestamo Meses Tasa N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112 SUMA 33,366,672
250,000,000 60 1% CUOTA FIJA Interes Abono K 2,500,000 2,469,389 2,438,472 2,407,245 2,375,707 2,343,853 14,534,665
3,061,112 3,091,723 3,122,640 3,153,867 3,185,405 3,217,259 18,832,007
Vr.Cuota
Saldo 250,000,000 246,938,888 243,847,165 240,724,525 237,570,658 234,385,253 231,167,993
CUOTA FIJA N° Cuota Cuota Interes Abono K Saldo 0 231,167,993 1 5,561,112 2,311,680 3,249,432 227,918,561 2 5,561,112 2,279,186 3,281,926 224,636,635 3 5,561,112 2,246,366 3,314,746 221,321,889 4 5,561,112 2,213,219 3,347,893 217,973,996 5 5,561,112 2,179,740 3,381,372 214,592,625 6 5,561,112 2,145,926 3,415,186 211,177,439 SUMA 33,366,672 13,376,117 19,990,555
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112 SUMA 33,366,672
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112
CUOTA FIJA Interes Abono K 2,111,774 2,077,281 2,042,443 2,007,256 1,971,717 1,935,824 12,146,295
3,449,338 3,483,831 3,518,669 3,553,856 3,589,394 3,625,288 21,220,376
CUOTA FIJA Interes Abono K 1,899,571 1,862,955 1,825,974 1,788,622 1,750,897
3,661,541 3,698,157 3,735,138 3,772,490 3,810,215
Saldo 211,177,439 207,728,101 204,244,270 200,725,601 197,171,745 193,582,351 189,957,062
Saldo 189,957,062 186,295,521 182,597,364 178,862,226 175,089,736 171,279,522
(C*I) (1-(1+I)^-n)
4 SEM 5 SEMESTRE 6 SEMESTRE 7 SEMESTRE 8 SEMESTRE
6 SUMA
5,561,112 33,366,672
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112 SUMA 33,366,672
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112 SUMA 33,366,672
1,712,795 10,840,814
3,848,317 22,525,857
CUOTA FIJA Interes Abono K 1,674,312 1,635,444 1,596,187 1,556,538 1,516,492 1,476,046 9,455,020
3,886,800 3,925,668 3,964,925 4,004,574 4,044,620 4,085,066 23,911,651
CUOTA FIJA Interes Abono K 1,435,196 1,393,936 1,352,265 1,310,176 1,267,667 1,224,732 7,983,972
4,125,916 4,167,176 4,208,847 4,250,936 4,293,445 4,336,380 25,382,700
167,431,205
Saldo 167,431,205 163,544,405 159,618,737 155,653,813 151,649,239 147,604,620 143,519,554
Saldo 143,519,554 139,393,637 135,226,462 131,017,615 126,766,679 122,473,234 118,136,854
CUOTA FIJA N° Cuota Cuota Interes Abono K Saldo 0 118,136,854 1 5,561,112 1,181,369 4,379,743 113,757,111 2 5,561,112 1,137,571 4,423,541 109,333,570 3 5,561,112 1,093,336 4,467,776 104,865,794 4 5,561,112 1,048,658 4,512,454 100,353,340 5 5,561,112 1,003,533 4,557,579 95,795,761 6 5,561,112 957,958 4,603,154 91,192,607 SUMA 33,366,672 6,422,424 26,944,247
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112
CUOTA FIJA Interes Abono K 911,926 865,434 818,477 771,051 723,150 674,771
4,649,186 4,695,678 4,742,634 4,790,061 4,837,961 4,886,341
Saldo 91,192,607 86,543,421 81,847,743 77,105,109 72,315,048 67,477,087 62,590,746
8 SE 10 SEMESTRE
9 SEMESTRE
SUMA
33,366,672
4,764,810
28,601,861
CUOTA FIJA N° Cuota Cuota Interes Abono K Saldo 0 62,590,746 1 5,561,112 625,907 4,935,204 57,655,541 2 5,561,112 576,555 4,984,557 52,670,985 3 5,561,112 526,710 5,034,402 47,636,582 4 5,561,112 476,366 5,084,746 42,551,836 5 5,561,112 425,518 5,135,594 37,416,243 6 5,561,112 374,162 5,186,949 32,229,293 SUMA 33,366,672 3,005,219 30,361,452
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112 SUMA 33,366,672 TOTAL 333,666,715
CUOTA FIJA Interes Abono K 322,293 269,905 216,993 163,551 109,576 55,061 1,137,378 83,666,715
5,238,819 5,291,207 5,344,119 5,397,560 5,451,536 5,506,051 32,229,293 250,000,000
Saldo 32,229,293 26,990,474 21,699,267 16,355,148 10,957,587 5,506,051 0
2,500,000 0.44955038
5,561,112
N° Cuota 0 1 2 3 4 5 6 SUMA
Cuota
N° Cuota 0 1 2 3 4 5 6 SUMA
Cuota
N° Cuota 0 1 2 3 4 5 6 SUMA
N° Cuota 0 1 2 3 4 5
CUOTA VARIABLE Interes Abono K
6,666,667 2,500,000 6,625,000 2,458,333 6,583,333 2,416,667 6,541,667 2,375,000 6,500,000 2,333,333 6,458,333 2,291,667 39,375,000 14,375,000
CUOTA VARIABLE Interes Abono K
6,416,667 2,250,000 6,375,000 2,208,333 6,333,333 2,166,667 6,291,667 2,125,000 6,250,000 2,083,333 6,208,333 2,041,667 37,875,000 12,875,000
Cuota
5,916,667 5,875,000 5,833,333 5,791,667 5,750,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K
6,166,667 2,000,000 6,125,000 1,958,333 6,083,333 1,916,667 6,041,667 1,875,000 6,000,000 1,833,333 5,958,333 1,791,667 36,375,000 11,375,000
Cuota
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K 1,750,000 1,708,333 1,666,667 1,625,000 1,583,333
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667
Saldo 250,000,000 245,833,333 241,666,667 237,500,000 233,333,333 229,166,667 225,000,000
Saldo 225,000,000 220,833,333 216,666,667 212,500,000 208,333,333 204,166,667 200,000,000
Saldo 200,000,000 195,833,333 191,666,667 187,500,000 183,333,333 179,166,667 175,000,000
Saldo 175,000,000 170,833,333 166,666,667 162,500,000 158,333,333 154,166,667
6 SUMA
N° Cuota 0 1 2 3 4 5 6 SUMA
5,708,333 34,875,000
Cuota 5,666,667 5,625,000 5,583,333 5,541,667 5,500,000 5,458,333 33,375,000
N° Cuota 0 1 2 3 4 5 6 SUMA
Cuota
N° Cuota 0 1 2 3 4 5 6 SUMA
Cuota
N° Cuota 0 1 2 3 4 5 6
5,416,667 5,375,000 5,333,333 5,291,667 5,250,000 5,208,333 31,875,000
5,166,667 5,125,000 5,083,333 5,041,667 5,000,000 4,958,333 30,375,000
Cuota 4,916,667 4,875,000 4,833,333 4,791,667 4,750,000 4,708,333
1,541,667 9,875,000
4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K 1,500,000 1,458,333 1,416,667 1,375,000 1,333,333 1,291,667 8,375,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K 1,250,000 1,208,333 1,166,667 1,125,000 1,083,333 1,041,667 6,875,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K 1,000,000 958,333 916,667 875,000 833,333 791,667 5,375,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K 750,000 708,333 666,667 625,000 583,333 541,667
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667
150,000,000
Saldo 150,000,000 145,833,333 141,666,667 137,500,000 133,333,333 129,166,667 125,000,000
Saldo 125,000,000 120,833,333 116,666,667 112,500,000 108,333,333 104,166,667 100,000,000
Saldo 100,000,000 95,833,333 91,666,667 87,500,000 83,333,333 79,166,667 75,000,000
Saldo 75,000,000 70,833,333 66,666,667 62,500,000 58,333,333 54,166,667 50,000,000
SUMA
N° Cuota 0 1 2 3 4 5 6 SUMA
N° Cuota 0 1 2 3 4 5 6 SUMA TOTAL
28,875,000
Cuota 4,666,667 4,625,000 4,583,333 4,541,667 4,500,000 4,458,333 27,375,000
Cuota
3,875,000
25,000,000
CUOTA VARIABLE Interes Abono K 500,000 458,333 416,667 375,000 333,333 291,667 2,375,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K
4,416,667 250,000 4,166,667 4,375,000 208,333 4,166,667 4,333,333 166,667 4,166,667 4,291,667 125,000 4,166,667 4,250,000 83,333 4,166,667 4,208,333 41,667 4,166,667 25,875,000 875,000 25,000,000 326,250,000 76,250,000 250,000,000
Saldo 50,000,000 45,833,333 41,666,667 37,500,000 33,333,333 29,166,667 25,000,000
Saldo 25,000,000 20,833,333 16,666,667 12,500,000 8,333,333 4,166,667 0
Prestamo Meses Tasa N° Cuota Cuota 0 1 0 2 0 3 0 4 0 5 11,915,640 6 11,915,640 7 11,915,640 8 11,915,640 9 11,915,640 10 11,915,640 11 11,915,640 12 11,915,640 13 11,915,640 14 11,915,640 15 11,915,640 16 11,915,640 17 11,915,640 18 11,915,640 19 11,915,640 20 11,915,640 21 11,915,640 22 11,915,640 23 11,915,640 24 11,915,640 SUMA 238,312,795
180,000,000 24 2% CUOTA FIJA Interes Abono K 3,600,000 3,672,000 3,745,440 3,820,349 3,896,756 3,736,378 3,572,793 3,405,936 3,235,742 3,062,144 2,885,074 2,704,463 2,520,239 2,332,331 2,140,665 1,945,165 1,745,756 1,542,358 1,334,893 1,123,278 907,430 687,266 462,699 233,640 58,312,795
0 0 0 0 8,018,884 8,179,262 8,342,847 8,509,704 8,679,898 8,853,496 9,030,566 9,211,177 9,395,401 9,583,309 9,774,975 9,970,474 10,169,884 10,373,281 10,580,747 10,792,362 11,008,209 11,228,373 11,452,941 11,682,000 194,837,789
Vr.Cuota
Saldo 180,000,000 183,600,000 187,272,000 191,017,440 194,837,789 186,818,905 178,639,643 170,296,796 161,787,093 153,107,195 144,253,699 135,223,133 126,011,956 116,616,555 107,033,247 97,258,272 87,287,798 77,117,914 66,744,632 56,163,885 45,371,523 34,363,314 23,134,941 11,682,000 0
(C*I) (1-(1+I)^-n)
3,896,756 0.32702867
N° Cuota 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 SUMA
11,915,640
Cuota 0 0 0 0 13,638,645 13,443,807 13,248,970 13,054,132 12,859,294 12,664,456 12,469,618 12,274,781 12,079,943 11,885,105 11,690,267 11,495,430 11,300,592 11,105,754 10,910,916 10,716,078 10,521,241 10,326,403 10,131,565 9,936,727 235,753,724
CUOTA VARIABLE Interes Abono K 3,600,000 3,672,000 3,745,440 3,820,349 3,896,756 3,701,918 3,507,080 3,312,242 3,117,405 2,922,567 2,727,729 2,532,891 2,338,053 2,143,216 1,948,378 1,753,540 1,558,702 1,363,865 1,169,027 974,189 779,351 584,513 389,676 194,838 55,753,724
0 0 0 0 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 194,837,789
Saldo 180,000,000 183,600,000 187,272,000 191,017,440 194,837,789 185,095,899 175,354,010 165,612,120 155,870,231 146,128,342 136,386,452 126,644,563 116,902,673 107,160,784 97,418,894 87,677,005 77,935,116 68,193,226 58,451,337 48,709,447 38,967,558 29,225,668 19,483,779 9,741,889 0
100,000,000 30 0.5% CUOTA FIJA Interes Abono K 500,000 484,511 468,944 453,299 437,576 421,774 405,894 389,934 373,894 357,774 341,573 325,292 308,929 292,484 275,957 259,347 242,655 225,878 209,018 192,074 175,045 157,931 140,731 123,445 106,073 88,614 71,067 53,433 35,711 17,900 7,936,755
3,097,892 3,113,381 3,128,948 3,144,593 3,160,316 3,176,117 3,191,998 3,207,958 3,223,998 3,240,118 3,256,318 3,272,600 3,288,963 3,305,408 3,321,935 3,338,545 3,355,237 3,372,013 3,388,874 3,405,818 3,422,847 3,439,961 3,457,161 3,474,447 3,491,819 3,509,278 3,526,825 3,544,459 3,562,181 3,579,992 100,000,000
Vr.Cuota
Saldo 100,000,000 96,902,108 93,788,727 90,659,779 87,515,186 84,354,870 81,178,752 77,986,754 74,778,796 71,554,798 68,314,680 65,058,362 61,785,762 58,496,799 55,191,391 51,869,456 48,530,912 45,175,674 41,803,661 38,414,787 35,008,969 31,586,122 28,146,161 24,689,000 21,214,553 17,722,734 14,213,456 10,686,632 7,142,173 3,579,992 0
(C*I) (1-(1+I)^-n)
500,000 0.13897027
N° Cuota 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 SUMA
3,597,892
Cuota 3,833,333 3,816,667 3,800,000 3,783,333 3,766,667 3,750,000 3,733,333 3,716,667 3,700,000 3,683,333 3,666,667 3,650,000 3,633,333 3,616,667 3,600,000 3,583,333 3,566,667 3,550,000 3,533,333 3,516,667 3,500,000 3,483,333 3,466,667 3,450,000 3,433,333 3,416,667 3,400,000 3,383,333 3,366,667 3,350,000 107,750,000
CUOTA VARIABLE Interes Abono K 500,000 483,333 466,667 450,000 433,333 416,667 400,000 383,333 366,667 350,000 333,333 316,667 300,000 283,333 266,667 250,000 233,333 216,667 200,000 183,333 166,667 150,000 133,333 116,667 100,000 83,333 66,667 50,000 33,333 16,667 7,750,000
3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 3,333,333 100,000,000
Saldo 100,000,000 96,666,667 93,333,333 90,000,000 86,666,667 83,333,333 80,000,000 76,666,667 73,333,333 70,000,000 66,666,667 63,333,333 60,000,000 56,666,667 53,333,333 50,000,000 46,666,667 43,333,333 40,000,000 36,666,667 33,333,333 30,000,000 26,666,667 23,333,333 20,000,000 16,666,667 13,333,333 10,000,000 6,666,667 3,333,333 0
4 SEMESTRE
3 SEMESTRE
2 SEMESTRE
1 SEMESTRE
Prestamo Meses Tasa N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112 SUMA 33,366,672
250,000,000 60 1% CUOTA FIJA Interes Abono K 2,500,000 2,469,389 2,438,472 2,407,245 2,375,707 2,343,853 14,534,665
3,061,112 3,091,723 3,122,640 3,153,867 3,185,405 3,217,259 18,832,007
Vr.Cuota
Saldo 250,000,000 246,938,888 243,847,165 240,724,525 237,570,658 234,385,253 231,167,993
CUOTA FIJA N° Cuota Cuota Interes Abono K Saldo 0 231,167,993 1 5,561,112 2,311,680 3,249,432 227,918,561 2 5,561,112 2,279,186 3,281,926 224,636,635 3 5,561,112 2,246,366 3,314,746 221,321,889 4 5,561,112 2,213,219 3,347,893 217,973,996 5 5,561,112 2,179,740 3,381,372 214,592,625 6 5,561,112 2,145,926 3,415,186 211,177,439 SUMA 33,366,672 13,376,117 19,990,555
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112 SUMA 33,366,672
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112
CUOTA FIJA Interes Abono K 2,111,774 2,077,281 2,042,443 2,007,256 1,971,717 1,935,824 12,146,295
3,449,338 3,483,831 3,518,669 3,553,856 3,589,394 3,625,288 21,220,376
CUOTA FIJA Interes Abono K 1,899,571 1,862,955 1,825,974 1,788,622 1,750,897
3,661,541 3,698,157 3,735,138 3,772,490 3,810,215
Saldo 211,177,439 207,728,101 204,244,270 200,725,601 197,171,745 193,582,351 189,957,062
Saldo 189,957,062 186,295,521 182,597,364 178,862,226 175,089,736 171,279,522
(C*I) (1-(1+I)^-n)
4 SEM 5 SEMESTRE 6 SEMESTRE 7 SEMESTRE 8 SEMESTRE
6 SUMA
5,561,112 33,366,672
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112 SUMA 33,366,672
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112 SUMA 33,366,672
1,712,795 10,840,814
3,848,317 22,525,857
CUOTA FIJA Interes Abono K 1,674,312 1,635,444 1,596,187 1,556,538 1,516,492 1,476,046 9,455,020
3,886,800 3,925,668 3,964,925 4,004,574 4,044,620 4,085,066 23,911,651
CUOTA FIJA Interes Abono K 1,435,196 1,393,936 1,352,265 1,310,176 1,267,667 1,224,732 7,983,972
4,125,916 4,167,176 4,208,847 4,250,936 4,293,445 4,336,380 25,382,700
167,431,205
Saldo 167,431,205 163,544,405 159,618,737 155,653,813 151,649,239 147,604,620 143,519,554
Saldo 143,519,554 139,393,637 135,226,462 131,017,615 126,766,679 122,473,234 118,136,854
CUOTA FIJA N° Cuota Cuota Interes Abono K Saldo 0 118,136,854 1 5,561,112 1,181,369 4,379,743 113,757,111 2 5,561,112 1,137,571 4,423,541 109,333,570 3 5,561,112 1,093,336 4,467,776 104,865,794 4 5,561,112 1,048,658 4,512,454 100,353,340 5 5,561,112 1,003,533 4,557,579 95,795,761 6 5,561,112 957,958 4,603,154 91,192,607 SUMA 33,366,672 6,422,424 26,944,247
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112
CUOTA FIJA Interes Abono K 911,926 865,434 818,477 771,051 723,150 674,771
4,649,186 4,695,678 4,742,634 4,790,061 4,837,961 4,886,341
Saldo 91,192,607 86,543,421 81,847,743 77,105,109 72,315,048 67,477,087 62,590,746
8 SE 10 SEMESTRE
9 SEMESTRE
SUMA
33,366,672
4,764,810
28,601,861
CUOTA FIJA N° Cuota Cuota Interes Abono K Saldo 0 62,590,746 1 5,561,112 625,907 4,935,204 57,655,541 2 5,561,112 576,555 4,984,557 52,670,985 3 5,561,112 526,710 5,034,402 47,636,582 4 5,561,112 476,366 5,084,746 42,551,836 5 5,561,112 425,518 5,135,594 37,416,243 6 5,561,112 374,162 5,186,949 32,229,293 SUMA 33,366,672 3,005,219 30,361,452
N° Cuota Cuota 0 1 5,561,112 2 5,561,112 3 5,561,112 4 5,561,112 5 5,561,112 6 5,561,112 SUMA 33,366,672 TOTAL 333,666,715
CUOTA FIJA Interes Abono K 322,293 269,905 216,993 163,551 109,576 55,061 1,137,378 83,666,715
5,238,819 5,291,207 5,344,119 5,397,560 5,451,536 5,506,051 32,229,293 250,000,000
Saldo 32,229,293 26,990,474 21,699,267 16,355,148 10,957,587 5,506,051 0
2,500,000 0.44955038
5,561,112
N° Cuota 0 1 2 3 4 5 6 SUMA
Cuota
N° Cuota 0 1 2 3 4 5 6 SUMA
Cuota
N° Cuota 0 1 2 3 4 5 6 SUMA
N° Cuota 0 1 2 3 4 5
CUOTA VARIABLE Interes Abono K
6,666,667 2,500,000 6,625,000 2,458,333 6,583,333 2,416,667 6,541,667 2,375,000 6,500,000 2,333,333 6,458,333 2,291,667 39,375,000 14,375,000
CUOTA VARIABLE Interes Abono K
6,416,667 2,250,000 6,375,000 2,208,333 6,333,333 2,166,667 6,291,667 2,125,000 6,250,000 2,083,333 6,208,333 2,041,667 37,875,000 12,875,000
Cuota
5,916,667 5,875,000 5,833,333 5,791,667 5,750,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K
6,166,667 2,000,000 6,125,000 1,958,333 6,083,333 1,916,667 6,041,667 1,875,000 6,000,000 1,833,333 5,958,333 1,791,667 36,375,000 11,375,000
Cuota
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K 1,750,000 1,708,333 1,666,667 1,625,000 1,583,333
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667
Saldo 250,000,000 245,833,333 241,666,667 237,500,000 233,333,333 229,166,667 225,000,000
Saldo 225,000,000 220,833,333 216,666,667 212,500,000 208,333,333 204,166,667 200,000,000
Saldo 200,000,000 195,833,333 191,666,667 187,500,000 183,333,333 179,166,667 175,000,000
Saldo 175,000,000 170,833,333 166,666,667 162,500,000 158,333,333 154,166,667
6 SUMA
N° Cuota 0 1 2 3 4 5 6 SUMA
5,708,333 34,875,000
Cuota 5,666,667 5,625,000 5,583,333 5,541,667 5,500,000 5,458,333 33,375,000
N° Cuota 0 1 2 3 4 5 6 SUMA
Cuota
N° Cuota 0 1 2 3 4 5 6 SUMA
Cuota
N° Cuota 0 1 2 3 4 5 6
5,416,667 5,375,000 5,333,333 5,291,667 5,250,000 5,208,333 31,875,000
5,166,667 5,125,000 5,083,333 5,041,667 5,000,000 4,958,333 30,375,000
Cuota 4,916,667 4,875,000 4,833,333 4,791,667 4,750,000 4,708,333
1,541,667 9,875,000
4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K 1,500,000 1,458,333 1,416,667 1,375,000 1,333,333 1,291,667 8,375,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K 1,250,000 1,208,333 1,166,667 1,125,000 1,083,333 1,041,667 6,875,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K 1,000,000 958,333 916,667 875,000 833,333 791,667 5,375,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K 750,000 708,333 666,667 625,000 583,333 541,667
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667
150,000,000
Saldo 150,000,000 145,833,333 141,666,667 137,500,000 133,333,333 129,166,667 125,000,000
Saldo 125,000,000 120,833,333 116,666,667 112,500,000 108,333,333 104,166,667 100,000,000
Saldo 100,000,000 95,833,333 91,666,667 87,500,000 83,333,333 79,166,667 75,000,000
Saldo 75,000,000 70,833,333 66,666,667 62,500,000 58,333,333 54,166,667 50,000,000
SUMA
N° Cuota 0 1 2 3 4 5 6 SUMA
N° Cuota 0 1 2 3 4 5 6 SUMA TOTAL
28,875,000
Cuota 4,666,667 4,625,000 4,583,333 4,541,667 4,500,000 4,458,333 27,375,000
Cuota
3,875,000
25,000,000
CUOTA VARIABLE Interes Abono K 500,000 458,333 416,667 375,000 333,333 291,667 2,375,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 4,166,667 25,000,000
CUOTA VARIABLE Interes Abono K
4,416,667 250,000 4,166,667 4,375,000 208,333 4,166,667 4,333,333 166,667 4,166,667 4,291,667 125,000 4,166,667 4,250,000 83,333 4,166,667 4,208,333 41,667 4,166,667 25,875,000 875,000 25,000,000 326,250,000 76,250,000 250,000,000
Saldo 50,000,000 45,833,333 41,666,667 37,500,000 33,333,333 29,166,667 25,000,000
Saldo 25,000,000 20,833,333 16,666,667 12,500,000 8,333,333 4,166,667 0
Prestamo Meses Tasa N° Cuota Cuota 0 1 0 2 0 3 0 4 0 5 11,915,640 6 11,915,640 7 11,915,640 8 11,915,640 9 11,915,640 10 11,915,640 11 11,915,640 12 11,915,640 13 11,915,640 14 11,915,640 15 11,915,640 16 11,915,640 17 11,915,640 18 11,915,640 19 11,915,640 20 11,915,640 21 11,915,640 22 11,915,640 23 11,915,640 24 11,915,640 SUMA 238,312,795
180,000,000 24 2% CUOTA FIJA Interes Abono K 3,600,000 3,672,000 3,745,440 3,820,349 3,896,756 3,736,378 3,572,793 3,405,936 3,235,742 3,062,144 2,885,074 2,704,463 2,520,239 2,332,331 2,140,665 1,945,165 1,745,756 1,542,358 1,334,893 1,123,278 907,430 687,266 462,699 233,640 58,312,795
0 0 0 0 8,018,884 8,179,262 8,342,847 8,509,704 8,679,898 8,853,496 9,030,566 9,211,177 9,395,401 9,583,309 9,774,975 9,970,474 10,169,884 10,373,281 10,580,747 10,792,362 11,008,209 11,228,373 11,452,941 11,682,000 194,837,789
Vr.Cuota
Saldo 180,000,000 183,600,000 187,272,000 191,017,440 194,837,789 186,818,905 178,639,643 170,296,796 161,787,093 153,107,195 144,253,699 135,223,133 126,011,956 116,616,555 107,033,247 97,258,272 87,287,798 77,117,914 66,744,632 56,163,885 45,371,523 34,363,314 23,134,941 11,682,000 0
(C*I) (1-(1+I)^-n)
3,896,756 0.32702867
N° Cuota 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 SUMA
11,915,640
Cuota 0 0 0 0 13,638,645 13,443,807 13,248,970 13,054,132 12,859,294 12,664,456 12,469,618 12,274,781 12,079,943 11,885,105 11,690,267 11,495,430 11,300,592 11,105,754 10,910,916 10,716,078 10,521,241 10,326,403 10,131,565 9,936,727 235,753,724
CUOTA VARIABLE Interes Abono K 3,600,000 3,672,000 3,745,440 3,820,349 3,896,756 3,701,918 3,507,080 3,312,242 3,117,405 2,922,567 2,727,729 2,532,891 2,338,053 2,143,216 1,948,378 1,753,540 1,558,702 1,363,865 1,169,027 974,189 779,351 584,513 389,676 194,838 55,753,724
0 0 0 0 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 9,741,889 194,837,789
Saldo 180,000,000 183,600,000 187,272,000 191,017,440 194,837,789 185,095,899 175,354,010 165,612,120 155,870,231 146,128,342 136,386,452 126,644,563 116,902,673 107,160,784 97,418,894 87,677,005 77,935,116 68,193,226 58,451,337 48,709,447 38,967,558 29,225,668 19,483,779 9,741,889 0
Related Documents
Presupuesto - Tercer Corte.xlsx
October 2019 6
Presupuesto
May 2020 39
Presupuesto
June 2020 28
Presupuesto
May 2020 24
Presupuesto
November 2019 48
Presupuesto
October 2019 51More Documents from ""
Ensayo- Conceptos Generales.docx
October 2019 5
Presupuesto - Tercer Corte.xlsx
October 2019 6
Actividad Fisisca 2.docx
June 2020 5
