AMORTIZACION DEUDA
10
CAPITAL 26,000,000.00 TASA NOMINAL 0.16 N. PERIODOS AÑO 1.00 i= 0.16 1+i= 1.16 AÑOS 3.00 MESES DIAS TOTAL DIAS 1,080.00 n= 3.00 R= 11,576,704.70 PERIODO INTERES CUOTA ABONO 0.00 1.00 4,160,000.00 11,576,704.70 7,416,704.70 2.00 2,973,327.25 11,576,704.70 8,603,377.45 3.00 1,596,786.86 11,576,704.70 9,979,917.85 " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " "
-
Upload
camilo-palacio -
Category
Documents
-
view
8 -
download
0
description
como amortizar una deuda en excel fácil y solo cambiando los datos de la formula.
Transcript of AMORTIZACION DEUDA
![Page 1: AMORTIZACION DEUDA](https://reader035.fdocuments.mx/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.fdocuments.mx/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/2.jpg)
""""""""""""""""""""""""""""""""""""""""""""""""""
![Page 3: AMORTIZACION DEUDA](https://reader035.fdocuments.mx/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/3.jpg)
""""""""""""""""""""""""""""""""""""""""""""""""""
![Page 4: AMORTIZACION DEUDA](https://reader035.fdocuments.mx/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/4.jpg)
""""""""""""""""""""""""""""""""""""""""""""""""""
![Page 5: AMORTIZACION DEUDA](https://reader035.fdocuments.mx/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/5.jpg)
"""""""""""""""
![Page 6: AMORTIZACION DEUDA](https://reader035.fdocuments.mx/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.fdocuments.mx/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/7.jpg)
0.00 0.00
0.00 0.00
![Page 8: AMORTIZACION DEUDA](https://reader035.fdocuments.mx/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/8.jpg)
![Page 9: AMORTIZACION DEUDA](https://reader035.fdocuments.mx/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/9.jpg)
![Page 10: AMORTIZACION DEUDA](https://reader035.fdocuments.mx/reader035/viewer/2022080105/577c82ef1a28abe054b2db0c/html5/thumbnails/10.jpg)