amortizacion deuda
DESCRIPTION
como amortizar una deuda en excel fácil y solo cambiando los datos de la formula.TRANSCRIPT
![Page 1: AMORTIZACION DEUDA](https://reader035.vdocuments.co/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/1.jpg)
CAPITAL 26,000,000.00TASA NOMINAL 0.16
N. PERIODOS AÑO 1.00i= 0.16
1+i= 1.16AÑOS 3.00
MESESDIAS
TOTAL DIAS 1,080.00n= 3.00R= 11,576,704.70
PERIODO INTERES CUOTA ABONO0.001.00 4,160,000.00 11,576,704.70 7,416,704.702.00 2,973,327.25 11,576,704.70 8,603,377.453.00 1,596,786.86 11,576,704.70 9,979,917.85
"""""""""""""""""""""""""""""""""
![Page 2: AMORTIZACION DEUDA](https://reader035.vdocuments.co/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/2.jpg)
""""""""""""""""""""""""""""""""""""""""""""""""""
![Page 3: AMORTIZACION DEUDA](https://reader035.vdocuments.co/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/3.jpg)
""""""""""""""""""""""""""""""""""""""""""""""""""
![Page 4: AMORTIZACION DEUDA](https://reader035.vdocuments.co/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/4.jpg)
""""""""""""""""""""""""""""""""""""""""""""""""""
![Page 5: AMORTIZACION DEUDA](https://reader035.vdocuments.co/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/5.jpg)
"""""""""""""""
![Page 6: AMORTIZACION DEUDA](https://reader035.vdocuments.co/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/6.jpg)
SALDO ABONO AÑO INTERES AÑO26,000,000.0018,583,295.30
9,979,917.850.00
26,000,000.00 8,730,114.10
0.00 0.00
0.00 0.00
![Page 7: AMORTIZACION DEUDA](https://reader035.vdocuments.co/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/7.jpg)
0.00 0.00
0.00 0.00
![Page 8: AMORTIZACION DEUDA](https://reader035.vdocuments.co/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/8.jpg)
![Page 9: AMORTIZACION DEUDA](https://reader035.vdocuments.co/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/9.jpg)
![Page 10: AMORTIZACION DEUDA](https://reader035.vdocuments.co/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/10.jpg)