Cuadro De Amortización 1.xls
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 Cuadro De Amortización 1.xls as PDF for free.
More details
- Words: 833
- Pages: 8
Capital= Plazo= Cuotas por año Total Cuota Period. Gracia Total Cuota para calcular
6
150000 5 2 10 10
TEA TEM Seg. Desg. Tasa de Interés para calcular Comisiones Cuota
18.00% 1.67% 0.06% 1.73% 20 S/16,483.01
CUADRO DE AMORTIZACIÓN PERIODO 0 1 2 3 4 5 6 7 8 9 10
CAPITAL AMORTIZACIÓN 150,000.000 0.000 136,130.363 13,869.637 122,020.931 14,109.432 107,667.559 14,353.372 93,066.029 14,601.530 78,212.050 14,853.979 63,101.259 15,110.792 47,729.214 15,372.045 32,091.399 15,637.815 16,183.219 15,908.180 0.000 16,183.219
INTERÉS 0.000 2,503.377 2,271.904 2,036.429 1,796.883 1,553.196 1,305.295 1,053.108 796.561 535.579 270.085
150,000.000
14,122.416
Columna1 1 2 3 4 5 6
AMORTIZACIÓN SEG.DESG. COMISIÓN 0.000 0.000 90.000 20.000 81.678 20.000 73.213 20.000 64.601 20.000 55.840 20.000 46.927 20.000 37.861 20.000 28.638 20.000 19.255 20.000 9.710 20.000 507.721
CUOTA 0 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014
200.000 164,830.137
Columna2 Semanal Mensual Bimensual Trimestral Cuatrimestral Semestral
Columna3 52 12 6 4 3 2
Capital= Plazo= Cuotas por año Total Cuota Period. Gracia Total Cuota para calcular
6
150000 12 2 24 24
TEA TEM Seg. Desg. Tasa de Interés para calcular Comisiones Cuota
18.00% 0.69% 0.06% 0.75% 20 S/6,874.39
CUADRO DE AMORTIZACIÓN PERIODO 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
CAPITAL AMORTIZACIÓN 150,000.000 0.000 144,273.655 5,726.345 138,504.246 5,769.409 132,691.450 5,812.796 126,834.940 5,856.510 120,934.388 5,900.553 114,989.461 5,944.926 108,999.828 5,989.634 102,965.150 6,034.677 96,885.091 6,080.060 90,759.307 6,125.783 84,587.456 6,171.851 78,369.191 6,218.265 72,104.163 6,265.028 65,792.020 6,312.143 59,432.409 6,359.612 53,024.971 6,407.438 46,569.347 6,455.623 40,065.176 6,504.171 33,512.091 6,553.085 26,909.726 6,602.366
INTERÉS 0.000 1,038.041 998.413 958.487 918.261 877.732 836.899 795.758 754.308 712.547 670.471 628.079 585.368 542.336 498.980 455.299 411.288 366.947 322.272 277.262 231.913
123,090.274
12,880.660
Columna1 1 2 3 4 5 6
AMORTIZACIÓN SEG.DESG. COMISIÓN 0.000 0.000 90.000 20.000 86.564 20.000 83.103 20.000 79.615 20.000 76.101 20.000 72.561 20.000 68.994 20.000 65.400 20.000 61.779 20.000 58.131 20.000 54.456 20.000 50.752 20.000 47.022 20.000 43.262 20.000 39.475 20.000 35.659 20.000 31.815 20.000 27.942 20.000 24.039 20.000 20.107 20.000
1,116.777
CUOTA 0 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386
400.000 137,487.710
Columna2 Semanal Mensual Bimensual Trimestral Cuatrimestral Semestral
Columna3 52 12 6 4 3 2
Capital= Plazo= Cuotas por año Total Cuota Period. Gracia Total Cuota para calcular
6
150000 10 2 20 20
TEA TEM Seg. Desg. Tasa de Interés para calcular Comisiones Cuota
18.00% 0.83% 0.06% 0.89% 20 S/8,241.37
CUADRO DE AMORTIZACIÓN CON PAGO ANTI PERIODO 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
CAPITAL 150,000.000 143,115.142 136,168.940 129,160.846 122,090.310 114,956.776 107,759.681 100,498.459 93,172.539 85,781.345 48,324.295 43,682.473 38,999.291 34,274.382 29,507.374 24,697.892 19,845.557 14,949.987 10,010.797 5,027.599 0.000
AMORTIZACIÓN 0.000 6,884.858 6,946.202 7,008.093 7,070.536 7,133.535 7,197.095 7,261.222 7,325.920 7,391.194 37,457.050 4,641.823 4,683.182 4,724.909 4,767.008 4,809.482 4,852.335 4,895.570 4,939.190 4,983.198 5,027.599
INTERÉS 0.000 1,246.509 1,189.295 1,131.572 1,073.334 1,014.578 955.298 895.489 835.148 774.269 712.848 401.578 363.004 324.086 284.822 245.208 205.241 164.918 124.235 83.190 41.780
150,000.000
12,066.404
Columna1 1 2 3 4 5 6
Columna2 Semanal Mensual Bimensual Trimestral Cuatrimestral Semestral
ÓN CON PAGO ANTICIPADO SEG.DESG. COMISIÓN 0.000 0.000 90.000 20.000 85.869 20.000 81.701 20.000 77.497 20.000 73.254 20.000 68.974 20.000 64.656 20.000 60.299 20.000 55.904 20.000 51.469 20.000 28.995 20.000 26.209 20.000 23.400 20.000 20.565 20.000 17.704 20.000 14.819 20.000 11.907 20.000 8.970 20.000 6.006 20.000 3.017 20.000
871.214
CUOTA 0 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395
400.000 133,337.619
P. Anticipado
30,000.000
Columna3 52 12 6 4 3 2
Capital= Plazo= Cuotas por año Total Cuota Period. Gracia Total Cuota para calcular Cuota Doble Julio - Diciembre TEA TEM Seg. Desg. Tasa de Interés para calcular Comisiones Cuota
6
150000 12 2 24 24 2 18.00% 0.69% 0.06% 0.75% 20 S/7,076.87
6874.39
CUADRO DE AMORTIZACIÓN CON PAGOS DOBLE PERIODO 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
CAPITAL AMORTIZACIÓN 150,000.000 0.000 144,071.169 5,928.831 138,097.752 5,973.417 132,079.414 6,018.339 126,015.815 6,063.598 119,906.617 6,109.198 106,674.605 13,232.012 100,419.956 6,254.649 94,118.270 6,301.686 87,769.193 6,349.076 81,372.370 6,396.823 74,927.441 6,444.929 61,357.174 13,570.268 54,761.725 6,595.449 48,116.677 6,645.048 41,421.656 6,695.021 34,676.287 6,745.369 27,880.191 6,796.096 13,956.115 13,924.076 7,004.198 6,951.917 0.000 7,004.198
INTERÉS 0.000 1,038.041 997.011 955.674 914.025 872.063 829.786 738.217 694.933 651.324 607.387 563.119 518.518 424.608 378.966 332.980 286.649 239.969 192.938 96.580 48.471
150,000.000
11,381.260
Columna1 1 2 3 4 5 6
N CON PAGOS DOBLES JUL.-DIC. SEG.DESG. COMISIÓN 0.000 0.000 90.000 20.000 86.443 20.000 82.859 20.000 79.248 20.000 75.609 20.000 71.944 20.000 64.005 20.000 60.252 20.000 56.471 20.000 52.662 20.000 48.823 20.000 44.956 20.000 36.814 20.000 32.857 20.000 28.870 20.000 24.853 20.000 20.806 20.000 16.728 20.000 8.374 20.000 4.203 20.000
986.776
400.000
CUOTA 0 7,076.871 7,076.871 7,076.871 7,076.871 7,076.871 14,153.742 7,076.871 7,076.871 7,076.871 7,076.871 7,076.871 14,153.742 7,076.871 7,076.871 7,076.871 7,076.871 7,076.871 14,153.742 7,076.871 7,076.871
162,768.036
Columna2 Semanal Mensual Bimensual Trimestral Cuatrimestral Semestral
Columna3 52 12 6 4 3 2
6
150000 5 2 10 10
TEA TEM Seg. Desg. Tasa de Interés para calcular Comisiones Cuota
18.00% 1.67% 0.06% 1.73% 20 S/16,483.01
CUADRO DE AMORTIZACIÓN PERIODO 0 1 2 3 4 5 6 7 8 9 10
CAPITAL AMORTIZACIÓN 150,000.000 0.000 136,130.363 13,869.637 122,020.931 14,109.432 107,667.559 14,353.372 93,066.029 14,601.530 78,212.050 14,853.979 63,101.259 15,110.792 47,729.214 15,372.045 32,091.399 15,637.815 16,183.219 15,908.180 0.000 16,183.219
INTERÉS 0.000 2,503.377 2,271.904 2,036.429 1,796.883 1,553.196 1,305.295 1,053.108 796.561 535.579 270.085
150,000.000
14,122.416
Columna1 1 2 3 4 5 6
AMORTIZACIÓN SEG.DESG. COMISIÓN 0.000 0.000 90.000 20.000 81.678 20.000 73.213 20.000 64.601 20.000 55.840 20.000 46.927 20.000 37.861 20.000 28.638 20.000 19.255 20.000 9.710 20.000 507.721
CUOTA 0 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014 16,483.014
200.000 164,830.137
Columna2 Semanal Mensual Bimensual Trimestral Cuatrimestral Semestral
Columna3 52 12 6 4 3 2
Capital= Plazo= Cuotas por año Total Cuota Period. Gracia Total Cuota para calcular
6
150000 12 2 24 24
TEA TEM Seg. Desg. Tasa de Interés para calcular Comisiones Cuota
18.00% 0.69% 0.06% 0.75% 20 S/6,874.39
CUADRO DE AMORTIZACIÓN PERIODO 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
CAPITAL AMORTIZACIÓN 150,000.000 0.000 144,273.655 5,726.345 138,504.246 5,769.409 132,691.450 5,812.796 126,834.940 5,856.510 120,934.388 5,900.553 114,989.461 5,944.926 108,999.828 5,989.634 102,965.150 6,034.677 96,885.091 6,080.060 90,759.307 6,125.783 84,587.456 6,171.851 78,369.191 6,218.265 72,104.163 6,265.028 65,792.020 6,312.143 59,432.409 6,359.612 53,024.971 6,407.438 46,569.347 6,455.623 40,065.176 6,504.171 33,512.091 6,553.085 26,909.726 6,602.366
INTERÉS 0.000 1,038.041 998.413 958.487 918.261 877.732 836.899 795.758 754.308 712.547 670.471 628.079 585.368 542.336 498.980 455.299 411.288 366.947 322.272 277.262 231.913
123,090.274
12,880.660
Columna1 1 2 3 4 5 6
AMORTIZACIÓN SEG.DESG. COMISIÓN 0.000 0.000 90.000 20.000 86.564 20.000 83.103 20.000 79.615 20.000 76.101 20.000 72.561 20.000 68.994 20.000 65.400 20.000 61.779 20.000 58.131 20.000 54.456 20.000 50.752 20.000 47.022 20.000 43.262 20.000 39.475 20.000 35.659 20.000 31.815 20.000 27.942 20.000 24.039 20.000 20.107 20.000
1,116.777
CUOTA 0 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386 6,874.386
400.000 137,487.710
Columna2 Semanal Mensual Bimensual Trimestral Cuatrimestral Semestral
Columna3 52 12 6 4 3 2
Capital= Plazo= Cuotas por año Total Cuota Period. Gracia Total Cuota para calcular
6
150000 10 2 20 20
TEA TEM Seg. Desg. Tasa de Interés para calcular Comisiones Cuota
18.00% 0.83% 0.06% 0.89% 20 S/8,241.37
CUADRO DE AMORTIZACIÓN CON PAGO ANTI PERIODO 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
CAPITAL 150,000.000 143,115.142 136,168.940 129,160.846 122,090.310 114,956.776 107,759.681 100,498.459 93,172.539 85,781.345 48,324.295 43,682.473 38,999.291 34,274.382 29,507.374 24,697.892 19,845.557 14,949.987 10,010.797 5,027.599 0.000
AMORTIZACIÓN 0.000 6,884.858 6,946.202 7,008.093 7,070.536 7,133.535 7,197.095 7,261.222 7,325.920 7,391.194 37,457.050 4,641.823 4,683.182 4,724.909 4,767.008 4,809.482 4,852.335 4,895.570 4,939.190 4,983.198 5,027.599
INTERÉS 0.000 1,246.509 1,189.295 1,131.572 1,073.334 1,014.578 955.298 895.489 835.148 774.269 712.848 401.578 363.004 324.086 284.822 245.208 205.241 164.918 124.235 83.190 41.780
150,000.000
12,066.404
Columna1 1 2 3 4 5 6
Columna2 Semanal Mensual Bimensual Trimestral Cuatrimestral Semestral
ÓN CON PAGO ANTICIPADO SEG.DESG. COMISIÓN 0.000 0.000 90.000 20.000 85.869 20.000 81.701 20.000 77.497 20.000 73.254 20.000 68.974 20.000 64.656 20.000 60.299 20.000 55.904 20.000 51.469 20.000 28.995 20.000 26.209 20.000 23.400 20.000 20.565 20.000 17.704 20.000 14.819 20.000 11.907 20.000 8.970 20.000 6.006 20.000 3.017 20.000
871.214
CUOTA 0 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 8,241.367 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395 5,092.395
400.000 133,337.619
P. Anticipado
30,000.000
Columna3 52 12 6 4 3 2
Capital= Plazo= Cuotas por año Total Cuota Period. Gracia Total Cuota para calcular Cuota Doble Julio - Diciembre TEA TEM Seg. Desg. Tasa de Interés para calcular Comisiones Cuota
6
150000 12 2 24 24 2 18.00% 0.69% 0.06% 0.75% 20 S/7,076.87
6874.39
CUADRO DE AMORTIZACIÓN CON PAGOS DOBLE PERIODO 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
CAPITAL AMORTIZACIÓN 150,000.000 0.000 144,071.169 5,928.831 138,097.752 5,973.417 132,079.414 6,018.339 126,015.815 6,063.598 119,906.617 6,109.198 106,674.605 13,232.012 100,419.956 6,254.649 94,118.270 6,301.686 87,769.193 6,349.076 81,372.370 6,396.823 74,927.441 6,444.929 61,357.174 13,570.268 54,761.725 6,595.449 48,116.677 6,645.048 41,421.656 6,695.021 34,676.287 6,745.369 27,880.191 6,796.096 13,956.115 13,924.076 7,004.198 6,951.917 0.000 7,004.198
INTERÉS 0.000 1,038.041 997.011 955.674 914.025 872.063 829.786 738.217 694.933 651.324 607.387 563.119 518.518 424.608 378.966 332.980 286.649 239.969 192.938 96.580 48.471
150,000.000
11,381.260
Columna1 1 2 3 4 5 6
N CON PAGOS DOBLES JUL.-DIC. SEG.DESG. COMISIÓN 0.000 0.000 90.000 20.000 86.443 20.000 82.859 20.000 79.248 20.000 75.609 20.000 71.944 20.000 64.005 20.000 60.252 20.000 56.471 20.000 52.662 20.000 48.823 20.000 44.956 20.000 36.814 20.000 32.857 20.000 28.870 20.000 24.853 20.000 20.806 20.000 16.728 20.000 8.374 20.000 4.203 20.000
986.776
400.000
CUOTA 0 7,076.871 7,076.871 7,076.871 7,076.871 7,076.871 14,153.742 7,076.871 7,076.871 7,076.871 7,076.871 7,076.871 14,153.742 7,076.871 7,076.871 7,076.871 7,076.871 7,076.871 14,153.742 7,076.871 7,076.871
162,768.036
Columna2 Semanal Mensual Bimensual Trimestral Cuatrimestral Semestral
Columna3 52 12 6 4 3 2
Related Documents
Cuadro
October 2019 94
Cuadro
October 2019 65
Cuadro
November 2019 79
Cuadro
April 2020 58
Cuadro
November 2019 59
Cuadro
May 2020 36More Documents from ""
Auditoria-8.pdf
June 2020 4
Solat Jemaah
December 2019 27
Express Tubi.docx
November 2019 38