Formulas y Funciones Financieras en Excel I

EJERCICIOS DE SERIES UNIFORMES
VALOR ACTUAL DE UNA ANUALIDAD

SIMBOLOS EXCEL
CALCULAR EL VALOR PRESENTE Y FUTURO DE UNA S
VP ò VA 227,069
i 0.15000
n 6
VF 525,224
A 60,000
EJERCICIO LA MEJOR ELECCION

SIMBOLOS EXCEL
CALCULAR EL VALOR PRESENTE Y FUTURO DE UNA SERIE UNI
VP ò VA 513,180,141
i 0.00416667
n 300
VF 1,786,529,125
A 3,000,000
VALOR PRESENTE DE UNA ANUALIDAD PREP

SIMBOLOS EXCEL
CALCULAR EL VALOR FUTURO DE UNA SERIE UNIFORME
VP ò VA 94,523,450
i 0.21600000
n 5
A 26,913,000
CALCULO DE UN INCREMENTO ANUA

SIMBOLOS EXCEL
CALCULAR LA TASA DE INTERES DE UNA SERIE U
VP ò VA 285,000
i 0.29271601
n 7
A 100,000
CALCULO DE LA TASA DE INTERES DE UNA AN

SIMBOLOS EXCEL
CALCULAR LA TASA DE INTERES DE UNA SERIE U
VP ò VA 120,000,000
i 0.2541300204
n 5
A 45,000,000
PRACTICAS
SIMBOLOS EXCEL
VP ò VA 10,000
i
n 4.5
VF
A 2,222
SIMBOLOS EXCEL
CALCULAR EL VALOR DE UNA SERIE UNIFORME TA
VP ò VA
i
n
VF
A
ES UNIFORMES VALOR PRESENTE
R ACTUAL DE UNA ANUALIDAD
CONCEPTO FUNCIONES ARITMETICAS
RESENTE Y FUTURO DE UNA SERIE UNIFORME
A* ( (1+i)^n - 1 / (1+i)^n *i ) 227,069
TASA DE INTERES 0.15000
NUMERO DE PERIODOS 6
VP * ( 1 + i ) ^ n -525,224
SERIE UNIFORME O CUOTA UNIFORME 60,000
RCICIO LA MEJOR ELECCION

Y FUTURO DE UNA SERIE UNIFORME PAGOS VENCIDOS
A* ( (1+i)^n - 1 / (1+i)^n *i ) 513,180,141
VP * ( 1 + i ) ^ n 1,786,529,125
SERIE UNIFORME O CUOTA UNIFORME 3,000,000
NTE DE UNA ANUALIDAD PREPAGABLE

RO DE UNA SERIE UNIFORME PAGOS ANTICIPADOS
A* ( (1+i)^n - 1 / (1+i)^n *i ) * 94,523,450
( 1 + i ) ^ 1
O DE UN INCREMENTO ANUAL
SA DE INTERES DE UNA SERIE UNIFORME
VALOR PRESENTE 285,000
TASA DE INTERES DE UNA ANUALIDAD

SA DE INTERES DE UNA SERIE UNIFORME
VALOR PRESENTE 120,000,000
PRACTICAS

RESENTE Y FUTURO DE UNA SERIE UNIFORME
VALOR PRESENTE
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( 1 + i ) ^ n
SERIE UNIFORME O CUOTA UNIFORME

R DE UNA SERIE UNIFORME TABLA ALEMAN
VALOR PRESENTE
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( 1 + i ) ^ n
VP * ( ( 1 + i ) ^ n * i)/(( 1 + i )^
n- 1 )
1)
i=1.1% mes vencido
P=?
2)
i=1.45% mes vencido
P=?
3)
i=1.02% mes vencido
0 1
A=1.085.870
P=?
4)
i=1.67% mes vencido
0 1
A=67.830
P=?
5)
0
i=1.8% mes vencido
P=15.000.000
6)
i=0.78% mes vencido
P=20.000.000
7)
i=1.73% mes vencido f=5.065.812
0 1 n=12 meses
A=?
8)
i=1.09% mes vencido f=2.350.000
0 1 n=22 meses
A=?
9)
i=1.32% mes vencido
0 1
A=?
P=75.000.000
10)
i=1.75% mes vencido
0 1
A=?
P=32.000.000
EJERCICIOS ESPECIALES
i=3% i=3.5%
0 1 3 4 6 7
A=9.624.883,83
A1=10.452.999,93
P=100.000.000
AHORA CALCULAMOS LA SERIE TOTAL :
1) P=(P/A,3%,3)
2) P=(P/A,3,5%,3)*(P/F,3,5%,3)
3) P=(P/A,4%,3)*(P/F,4%,6)
4) P=(P/A,2%,3)*(P/F,2%,9)
EQUIVALENCIA
i=3,038437% mes vencido
0 1 2 n=60 meses
A=10.069.273,07
P=100.000.000
EJEMPLO f=5.500.350
0
n=4 trimestres
i=5,146% trimestre vencido
P=4.500.000
f=5.000.000 11)
i=1.06% mes vencido
0 1
n=24 meses A=?
12)
i=0.82% trimestre vencido
0 1
A=?
f=2.000.000
13) f=81.000.000
n=5 meses
0
n=36 meses
i=?
P=74.500.000
14) f=6.000.000
n=18 meses 0
n=35 dìas
i=? Diario
P=5.778.333
n=18 meses 15)

i=? semestre vencido
0 1
f=? A=100.000
P=285.000
n=36 meses
16)
i=? Anual
0 1
A=45.000.000
f=?
P=120.000.000
n=18 meses 17)

i=9% anual
P=35.000.000
f=5.065.812
18)
n=12 meses i=1.67% mes vencido
f=2.350.000 P=500.000
n=22 meses 19)

i=1.4% mes vencido
P=3.500.000
n=120 meses
n=60 meses
ERCICIOS ESPECIALES
i=4% i=2%
7 9 10 12 n=12 meses
A2=10.625.316,72 A3=10.224.484,96
EQUIVALENCIA
n=60 meses
=4 trimestres
=81.000.000
EJERCICIOS DE SERIES UNIFORME
CALCULO DEL VALOR FUTURO Y EL PLAZO DE U
SIMBOLOS EXCEL
CALCULAR EL VALOR FUTURO DE UN PLAZO EN AHOR
VP ò VA 2,500,000
i 0.01800
n 10
VF 2,988,256
A 390,000
SIMBOLOS EXCEL
CALCULAR EL VALOR FUTURO DE UN PLAZO EN AHOR
VP ò VA 2,500,000
i 0.01800
n 7.2422755
VF 2,988,256
A 390,000
SIMBOLOS EXCEL
VP ò VA 27,225,056
VP 1 ò VA 29,285,511
VP 2 ò VA 29,486,221
VP 3 ò VA 29,486,221
i 0.03000
i1 0.03500
i2 0.04000
i3 0.02000
n 3
A 9,624,883.827000
A1 10,452,999.930000
A2 10,625,316.720000
A3 10,224,484.960000
VALOR PRESENTE TOTAL 27,225,056
VALOR PRESENTE TOTAL 1 26,413,853
VALOR TOTAL PRESENTE 101,615,049
TASA PROMEDIO 0.03125
RECOGIMOS TODAS LAS SERIES Y LAS DEJAMOS EN EL MOMENTO CERO COMO VALOR PRESENTE
PROMEDIO
SIMBOLOS EXCEL
CALCULAR EL VALOR FUTURO DE UN VALOR PRES
VP ò VA 100,000,000
i 0.03038437
n 12
A 10,069,273
3
SIMBOLOS EXCEL
C) CALCULAR LA TASA DE INTERES DE UNA SERIE
VP ò VA 100,000,000
i 0.03000000
n 3
VF -109,272,700
A1 35,353,036
SIMBOLOS EXCEL
VP ò VA (109,272,700)
i 0.03500000
n 3
VF -121,152,596
A2 39,003,162
SIMBOLOS EXCEL
A) CALCULAR EL VALOR PRESENTE Y FUTURO DE UNA
VP ò VA (121,152,596)
i 0.04000
n 3
VF -136,280,194
A3 43,657,161
SIMBOLOS EXCEL
VP ò VA (136,280,194)
i 0.02000000
n 3
VF -144,621,632
A4 47,255,794
SIMBOLOS EXCEL
VP ò VA
i 0.04000000
n 12
VF -144,621,632
AT 9,624,884
SIMBOLOS EXCEL
VP ò VA 12,891,282
i 0.02000000
n 2
VF 13,412,090
A
EJERCICIOS DE SERIES UNIFORMES PER
SIMBOLOS EXCEL
CALCULAR EL VALOR PRESENTE DE UNA SERIE
VP ò VA ?
i 0.01500
VF
A 2,500,000
E SERIES UNIFORMES VALOR FUTURO
CULO DEL VALOR FUTURO Y EL PLAZO DE UN AHORRO
R EL VALOR FUTURO DE UN PLAZO EN AHORRO PASO # 1
VP * ( 1 + i ) ^ n 2,988,256

R EL VALOR FUTURO DE UN PLAZO EN AHORRO PASO # 2
n = ( Log ( ( ( VF / A ) * I ) + 1 ) / Log 7.2422755
(1+i))
VALOR FUTURO 2,988,256
R EL VALOR PRESENTE Y FUTURO DE UNA SERIE UNIFORME
A* ( (1+i)^n - 1 / (1+i)^n *i ) 27,225,056
A* ( (1+i)^n - 1 / (1+i)^n *i ) 29,285,511
A* ( (1+i)^n - 1 / (1+i)^n *i ) 29,486,221
A* ( (1+i)^n - 1 / (1+i)^n *i ) 29,486,221
SERIE UNIFORME O CUOTA UNIFORME 9,624,883.827000
EL VP LLEGA A O 27,225,056
EL VP 1 LLEGA A O 26,413,853
EL VP 2 LLEGA A O 23,303,389
EL VP 3 LLEGA A O 24,672,751
SUMATORIA DE VP+VP1+VP2+VP3 101,615,049
S EN EL MOMENTO CERO COMO VALOR PRESENTE Y AHORA CALCULAMOS UNA SOLA SERIE CON UNA TASA
PROMEDIO

ULAR EL VALOR FUTURO DE UN VALOR PRESENTE PASO 1
VALOR PRESENTE INICIAL 100,000,000
VP * ( ( 1 + i ) ^ n * i)/(( 1 + i )^ 10,069,273
n- 1 )
LCULAR LA TASA DE INTERES DE UNA SERIE UNIFORME
VALOR PRESENTE
VP * ( 1 + i ) ^ n -359,155,245

VALOR PRESENTE
VALOR FUTURO -255,476,647

AR EL VALOR PRESENTE Y FUTURO DE UNA SERIE UNIFORME
VALOR PRESENTE
VP * ( 1 + i ) ^ n -136,280,194

VALOR PRESENTE
VP * ( 1 + i ) ^ n 0

VALOR PRESENTE
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( 1 + i ) ^ n

VALOR PRESENTE
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( 1 + i ) ^ n
RIES UNIFORMES PERPETUAS O PERENNES

LCULAR EL VALOR PRESENTE DE UNA SERIE PERPETUA
A / i 166,666,667
n = ( Log ( ( ( VF / A ) * I ) + 1 ) / Log
(1+i))
VALOR FUTURO
EJERCICIOS PARA DESA
EJERCICIO # 1 FONDO DE
SIMBOLOS EXCEL
CALCULAR EL VALOR FUTURO DE UNA SERIE UNIFORM
VF 51,888,318
i 0.007
n 60
n(1) 48
VF QUE SE CONVIERTE EN VP 37,124,020
A 500,000
OTRA FORMA DE RESOLVER EL EJERCICIO SI N
EJERCICIO # 1 FONDO DE
SIMBOLOS EXCEL
CALCULAR EL VALOR FUTURO DE UN
VP ò VA
i 0.00700000
n 60
VF 37,124,020
A 500,000
SIMBOLOS EXCEL
CALCULAR EL VALOR FUTURO DE U
VP ò VA 37,124,020
i 0.00700000
n 48
VF 51,888,318
A 500,000
EJERCICIO # 2 VALOR ACTUAL DE

SIMBOLOS EXCEL
CALCULAR EL VALOR PRESENTE DE UNA SERIE UNIF
VP ò VA 17,708,544
i 0.25000000
n 6
n(1) 5
VP ( 1 ) ò VA 8,542,419
A 6,000,000
A(1) 3,176,471
VPT 26,250,963
OTRA FORMA DE RESOLVER EL EJERCICIO SI N
EJERCICIO # 2 VALOR ACTUAL DE

SIMBOLOS EXCEL
CALCULAR EL VALOR PRESENTE DE U
VP ò VA 17,708,544
i 0.25000000
n 6
VF 67,552,734
A 6,000,000
SIMBOLOS EXCEL
VP ò VA 8,542,417
i 0.25000000
n 5
A 3,176,470
SIMBOLOS EXCEL
CALCULAR EL VALOR PRESE
VPT 26,250,961
EJERCICIO # 3 CALCULANDO LA
SIMBOLOS FORMULAS
CALCULO DE TASA VE
ia ia = iv / ( 1 + iv )
iv iv = ia / ( 1 - ia )
SIMBOLOS TASAS
CALCULO DE TASA VE
ia ia = iv / ( 1 + iv )
iv iv = ia / ( 1 - ia )
EJERCICIO # 5 CALCULANDO V
SIMBOLOS EXCEL
VP ò VA 450,000
i 0.11000000
n 8
VF 1,037,042
EJERCICIO # 6 CALCULANDO
SIMBOLOS EXCEL
CALCULAR LOS DIAS LABORADOS EXCEPTUANDO
DIAS LAB #ADDIN?
FECHA INICIAL 36,249
FECHA FINAL 38,806
AHORA RESOLVEMOS EL EJERCICIO UNA VEZ CALCULADO

VP ò VA 1,500,000
i 0.05000000
n 20.31
VF 4,040,601
EJERCICIO # 7 CALCULANDO V
SIMBOLOS EXCEL
VP ò VA 800,000
VP ( 1 ) ò VA 1,700,000
VP ( 2 ) ò VA 500,000
i 0.11000000
n 12
n (1 ) 9
n (2 ) 7
VF 2,798,760
VF (1) 4,348,663
VF (2) 1,038,080
VF (T) 8,185,503
EJERCICIO # 8 CALCULANDO EL
SIMBOLOS EXCEL
VP ò VA 1,500
i 0.01400000
n 36
VF 2,474
EJERCICIO # 9 CALCULANDO EL MO
SIMBOLOS EXCEL
VP ò VA
i 0.01800000
n 180
VF 211,630,874
A 160,000
EJERCICIO # 10 CALCULAND
SIMBOLOS EXCEL
VP ò VA 4,800,000
i 0.12000000
n 5.24763087
VF 8,700,000
A
REGLAS DE TRES SIM
SIMBOLOS EXCEL
PERIODO 1 0.247600
PERIODO 2 12
SIMBOLOS EXCEL
PERIODO 1 0.971200
PERIODO 2 30
TOTAL TOTAL EN AÑOS,MESES,
EJERCICIO # 11 CALCULANDO EL MONT
SIMBOLOS EXCEL
VP ò VA 600,000
i 0.11000000
i(1) 0.13000000
n 6
n (1 ) 6
VF 1,122,249
VF (1) 2,336,468
EJERCICIO # 12 CALCULAR EL MONTO A PAGAR
SIMBOLOS EXCEL
VP ò VA 18,000,000
i 0.01890000
i(1) 0.02050000
n 12
n (1 ) 0.8333333333
VF 22,534,673
VF (1) 22,918,987
EJERCICIO # 13 CALCULAND
SIMBOLOS EXCEL
VP ò VA 6,000,000
VP (1 ) ò VA 15,000,000
VP (T ) ò VA 80,038,976
i 0.14500000
n 10
n (1 ) 6
n (T ) 1.49517596
VF 23,238,394
VF (1) 33,800,582
VF (T) 98,000,000
REGLAS DE TRES SIM
SIMBOLOS EXCEL
PERIODO 1 0.495176
PERIODO 2 12
SIMBOLOS EXCEL
PERIODO 1 0.942400
PERIODO 2 30
NOTA : OBSERVESE COMO EN EL PRIMER n(T) el valor es 1,495175596 DE ALLI SE TOMA EL ENTERO OSEA 1
DE 11 AÑOS, POSTERIORMENTE AL TOMAR LOS DECIMALES 0,49517596 Y CONVERTIRLOS EN MESES ES
POR ULTIMO CALCULAMOS LOS DIAS PARA OBTENER LA RESPUETA DE : 10 AÑOS+1 AÑOS + 5 MESES + 28 DIAS
EJERCICIO # 14 AHORRO O
SIMBOLOS EXCEL
CALCULAR EL VALOR FUTURO DE UN
VP ò VA 20,000,000
i 0.0082796441
n 18
VF 23,200,000
I 3,200,000
EJERCICIO # 15 SUMAS EQU
SIMBOLOS EXCEL
VP ò VA 5,000,000
i 0.32000000
n 2.03620024
VF 8,800,000
REGLAS DE TRES SIM
SIMBOLOS EXCEL
PERIODO 1 0.03620024
PERIODO 2 12
EJERCICIO # 16 CALCULANDO EL VALOR DE
SIMBOLOS EXCEL
VP ò VA 60,000,000
i 0.21000000
n 5
VF 155,624,548
VF ( 1 ) 26,562,374
A 3,500,000
VF TOTAL 129,062,173
EJERCICIO # 17 DOBLE PR
SIMBOLOS EXCEL
CALCULAR EL VALOR FUTURO DE UN V
VP ò VA 3,000,000
i 0.03800000
n 36
A 154,294
SIMBOLOS EXCEL
CALCULAR EL VALOR FUTURO DE UN V
VP ò VA 4,990,023
i 0.03800000
n 26
A 305,446
EJERCICIO # 18 CALCULANDO LAS CUOTAS V
SIMBOLOS EXCEL
VP ò VA 2,500,000
i 0.04500000
n 8
A 379,024
EJERCICIO # 19 PRESTAMOS SISTEMA DE AMOR
SIMBOLOS EXCEL
VP ò VA 15,000,000
i 0.03500000
n 12
A 1,552,259
EJERCICIO # 20 PRESTAMO CON TASA

AMORT 1000000
VP ò VA 5,000,000
n 5
SIMBOLOS EXCEL
VP ò VA 2,000,000
i 0.03800000
n 12
A 210,639
S 31,596
SIMBOLOS EXCEL
CALCULO DE TASA EFE
TEA #ADDIN?
J 0.75360000
n 12
EJERCICIO # 23 EVALUANDO EL COSTO EF
SIMBOLOS EXCEL
CALCULO DE TASA EFE
TEA #ADDIN?
J 0.42000000
n 12
SIMBOLOS EXCEL
VP ò VA 25,000,000
i 0.04258905
n 12
VF 41,238,033
EJERCICIO # 24 COMPRA CON TAR
SIMBOLOS EXCEL
VP ò VA 8,789,700
i 0.04428603
n 12
A 960,000
SIMBOLOS EXCEL
CALCULO DE TASA EFE
TEA #ADDIN?
J 0.53143235
n 12
SIMBOLOS EXCEL
CALCULO DE TASA EFE
TEA #ADDIN?
J 0.660080124
n 12
EJERCICIO # 25 VALOR ACTUAL DE LO
SIMBOLOS EXCEL
VP ò VA 4,256,782
i 0.10000000
n 20
A 500,000
SIMBOLOS EXCEL
VP ò VA 2,643,127
i 0.10000
n 5
VF 4,256,782
EJERCICIO # 26 CUANDO UNA INVE
SIMBOLOS EXCEL
VP ò VA 1
i 0.05946309
n 12
VF 2
SIMBOLOS EXCEL
VP ò VA 1
i 0.05000000
n 12
VF 1.7958563
EJERCICIO # 27 CALCULANDO EL VALOR DE
SIMBOLOS EXCEL
VP ò VA 26,775,080
i 0.00750000
n 30
A 1,000,000
SIMBOLOS EXCEL
VP ò VA 1,983,094
i 0.00750000
n 31
VF 2,500,000
TOTAL 48,758,174
EJERCICIO # 28 LA MEJO
TOTAL OPCION A 400,000,000
SIMBOLOS EXCEL
VP ò VA 222,591,117
i 0.04000000
n 5
A 50,000,000
TOTAL OPCION B 412,591,117
SIMBOLOS EXCEL
VP ò VA 211,506,824
i 0.02000
n 12
A 20,000,000
VF 215,736,961
SIMBOLOS EXCEL
VP ò VA 183,757,463
i 0.08000000
n 4
VF 250,000,000
TOTAL OPCION C 399,494,424
EJERCICIO # 29 GENERANDO FONDOS PARA L
SIMBOLOS EXCEL
VF 180,000,000
i 0.06
n 5
A 31,931,352
EJERCICIO # 30 SOBREGIROS
PRIMER PAS
VN 10,000,000
i 0.0007222222
n 2
D (2 ) 14,424
SEGUNDO PA
VP ò VA 9,580,576
VN 10,000,000
f 0.04
p 5,000
D (2 ) 14,424
TERCER PAS
ir 0.0437785362
CUARTO PAS
VF 10,189,910
VF ( 1 ) 10,378,240
VP ò VA 10,000,000
i 0.0012222222
n 15
n(1) 30
p 5,000
CALCULAMOS EL COSTO MENSU
SIMBOLOS EXCEL
VP ò VA 9,580,576
0.004119145 i 0.06178718
0.00266934 i(1) 0.08008020
n 15
n(1) 30
VF 10,189,910
VF ( 1 ) 10,378,240
QUINTO PASO CALCULO LA TASA NOMINA
SIMBOLOS EXCEL
CALCULO DE TASA EFE
TEA #ADDIN?
J 0.9609623829
n 360
UVR
TASA DE INTERES 7.50%
DTF
TASA DE INTERES 5%
EJERCICIO # 38
SIMBOLOS EXCEL
VP ò VA 701,000
i 0.05844091
n 12
A 82,900
SIMBOLOS EXCEL
CALCULO DE TASA EFE
TEA #ADDIN?
J 0.7012909543
n 12
EJERCICIOS PARA DESARROLLAR
EJERCICIO # 1 FONDO DE AHORRO

CONCEPTO
L VALOR FUTURO DE UNA SERIE UNIFORME Y PROYECTARLO A UN VALOR FUTURO
VP * ( 1 + i ) ^ n
TASA DE INTERES
NUMERO DE PERIODOS
NUMERO DE PERIODOS
A * ( ( 1 + i ) ^ n -1 ) / i
SERIE UNIFORME
A DE RESOLVER EL EJERCICIO SI NO SE QUIERE TODO JUNTO SERIA :
EJERCICIO # 1 FONDO DE AHORRO

CONCEPTO
VALOR PRESENTE
TASA DE INTERES
NUMERO DE PERIODOS
A * ( ( 1 + i ) ^ n - 1 ) / i
VF * i / ( ( 1 + i ) ^ n - 1 )
CONCEPTO
CALCULAR EL VALOR FUTURO DE UN VALOR PRESENTE
VF / ( 1 + i ) ^ n
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( 1 + i ) ^ n
VP * ( ( 1 + i ) ^ n * i ) / ( ( 1 + i ) ^ n - 1 )
EJERCICIO # 2 VALOR ACTUAL DE UN ADITAMENTO

CONCEPTO
AR EL VALOR PRESENTE DE UNA SERIE UNIFORME Y DISTRIBUIRLA EN 5 AÑOS
A* ( (1+i)^n - 1 / (1+i)^n *i )
TASA DE INTERES ANUAL
NUMERO DE AÑOS
NUMERO DE AÑOS
A* ( (1+i)^n - 1 / (1+i)^n *i )
PRECIO A PAGAR HOY VP + VP ( 1 )
A DE RESOLVER EL EJERCICIO SI NO SE QUIERE TODO JUNTO SERIA :
EJERCICIO # 2 VALOR ACTUAL DE UN ADITAMENTO

CONCEPTO
CALCULAR EL VALOR PRESENTE DE UNA SERIE UNIFORME
A * ( ( 1 + i ) ^n - 1 ) / ( ( 1 + i ) ^n * i )
TASA DE INTERES
NUMERO DE PERIODOS
A *( ( 1 + i ) ^ n - 1 ) / i
CONCEPTO
A * ( ( 1 + i ) ^n - 1 ) / ( ( 1 + i ) ^n * i )
TASA DE INTERES
NUMERO DE PERIODOS
CONCEPTO
CALCULAR EL VALOR PRESENTE TOTAL
SUMA DE 17.708.544 + 8.542.417
EJERCICIO # 3 CALCULANDO LA TASA VENCIDA

CONCEPTO
CALCULO DE TASA VENCIDA
TASA DE INTERES ANTICIPADA
TASA DE INTERES VENCIDA
EJERCICIO # 4 CALCULANDO LA TASA VENCIDA
CONCEPTO
CALCULO DE TASA VENCIDA
TASA DE INTERES ANTICIPADA
TASA DE INTERES VENCIDA
EJERCICIO # 5 CALCULANDO VALOR FUTURO

CONCEPTO
VF / ( 1 + i ) ^ n
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( 1 + i ) ^ n
EJERCICIO # 6 CALCULANDO EL n, VF el I
CONCEPTO
ULAR LOS DIAS LABORADOS EXCEPTUANDO LOS FESTIVOS Y DOMINICALES
CALCULO DE DIAS LABORADOS EXC FESTIVOS Y DOMIN
TASA DE INTERES
NUMERO DE PERIODOS
VEMOS EL EJERCICIO UNA VEZ CALCULADO EL n = 20.31 TRIMESTRES

VF / ( 1 + i ) ^ n
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( 1 + i ) ^ n
EJERCICIO # 7 CALCULANDO VALOR FUTURO
CONCEPTO
VALOR PRESENTE AÑO 0
NUMERO DE PERIODOS ( VP )
NUMERO DE PERIODOS ( VP 1 )
NUMERO DE PERIODOS ( VP 2 )
VP * ( 1 + i ) ^ n
VP * ( 1 + i ) ^ n
VP * ( 1 + i ) ^ n
SUMATORIA DE VALORES ( VF + VF1 + VF2 )
EJERCICIO # 8 CALCULANDO EL VALOR FUTURO
CONCEPTO
VALOR FUTURO
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( 1 + i ) ^ n
EJERCICIO # 9 CALCULANDO EL MONTO ACUMULADO
CONCEPTO
A * ( ( 1 + i ) ^n - 1 ) / ( ( 1 + i ) ^n * i )
TASA DE INTERES
NUMERO DE PERIODOS
A *( ( 1 + i ) ^ n - 1 ) / i
EJERCICIO # 10 CALCULANDO EL PLAZO
CONCEPTO
VALOR PRESENTE
TASA DE INTERES
LOG ( VF / VP ) / LOG ( 1 + i )
VALOR FUTURO
SERIE UNIFORME
REGLAS DE TRES SIMPLES
CONCEPTO
FRACCION DE AÑO
MESES
CONCEPTO
FRACCION DE MES
DIAS
TOTAL EN AÑOS,MESES,DIAS
EJERCICIO # 11 CALCULANDO EL MONTO FINAL DE UN CAPITAL
CONCEPTO
TASA DE INTERES ANUAL ( 1 )
NUMERO DE PERIODOS 6 PRIMEROS AÑOS
NUMERO DE PERIODOS 6 ULTIMOS AÑOS
VP * ( 1 + i ) ^ n
VP * ( 1 + i ) ^ n
CICIO # 12 CALCULAR EL MONTO A PAGAR POR UNA DEUDA CON ATRASO
CONCEPTO
TASA DE INTERES CORRIENTE
TASA DE INTERES MORA
NUMERO DE PERIODOS 6 PRIMEROS AÑOS
NUMERO DE PERIODOS 6 ULTIMOS AÑOS
VP * ( 1 + i ) ^ n
VP * ( 1 + i ) ^ n
EJERCICIO # 13 CALCULANDO EL TIEMPO
CONCEPTO
SUMATORIA DE 23.000.000+VF+VF (1)
TASA DE INTERES CORRIENTE
NUMERO DE PERIODOS AÑO 0 AL10
NUMERO DE PERIODOS AÑO 4 AL10
LOG ( VF / VP ) / LOG ( 1 + i )
VALOR FUTURO AL AÑO 10
VALOR FUTURO AL AÑO 10
VALOR FUTURO ESPERADO
CONCEPTO
FRACCION DE AÑO
MESES
CONCEPTO
FRACCION DE AÑO
DIAS
1,495175596 DE ALLI SE TOMA EL ENTERO OSEA 1 Y SE LE SUMA A LOS 10 AÑOS QUE TRAIAMOS PARA UN TOTAL
S 0,49517596 Y CONVERTIRLOS EN MESES ESTE DA 5.942111452 SE TOMA EL ENTERO EN MESES OSEA 5 Y
RESPUETA DE : 10 AÑOS+1 AÑOS + 5 MESES + 28 DIAS
EJERCICIO # 14 AHORRO O INVERSION
CONCEPTO
VALOR PRESENTE
( ( VF / VP ) ^ 1/n ) - 1
NUMERO DE PERIODOS
VALOR FUTURO = I + VP
INTERES
EJERCICIO # 15 SUMAS EQUIVALENTES
CONCEPTO
VALOR PRESENTE
TASA DE INTERES
LOG ( VF / VP ) / LOG ( 1 + i )
VALOR FUTURO
CONCEPTO
FRACCION DE AÑO
MESES * DIAS
EJERCICIO # 16 CALCULANDO EL VALOR DE VENTA DE UNA MAQUINA
CONCEPTO
VF / ( 1 + i ) ^ n
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( 1 + i ) ^ n
VF = A * ((1+i)^ n - 1 ) / i
SERIE UNIFORME
VALOR DE VENTA DENTRO DE 5 AÑOS
EJERCICIO # 17 DOBLE PRESTAMO
CONCEPTO
CALCULAR EL VALOR FUTURO DE UN VALOR PRESENTE PASO 1
VALOR PRESENTE INICIAL
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( ( 1 + i ) ^ n * i ) / ( ( 1 + i ) ^ n - 1 )
CONCEPTO
CALCULAR EL VALOR FUTURO DE UN VALOR PRESENTE PASO 2
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( ( 1 + i ) ^ n * i ) / ( ( 1 + i ) ^ n - 1 )
ERCICIO # 18 CALCULANDO LAS CUOTAS VARIABLES DE UN PRESTAMO
CONCEPTO
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( ( 1 + i ) ^ n * i ) / ( ( 1 + i ) ^ n - 1 )
CICIO # 19 PRESTAMOS SISTEMA DE AMORTIZACION FRANCES Y ALEMAN
CONCEPTO
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( ( 1 + i ) ^ n * i)/(( 1 + i )^ n- 1 )
EJERCICIO # 20 PRESTAMO CON TASA DE INTERES FLOTANTE

AMORTIZACION ANUAL
VALOR PRESENTE
NUMERO DE PERIODOS
EJERCICIO # 22 CALCULANDO LA TASA NOMINAL
CONCEPTO
TASA DE INTERES
NUMERO DE PERIODOS
VP * ( ( 1 + i ) ^ n * i ) / ( ( 1 + i ) ^ n - 1 )
15% AHORRO MENSUAL DEL VALOR DE LA CUOTA
CONCEPTO
CALCULO DE TASA EFECTIVA
[ 1 + j / n ] ^ 12 - 1
TASA DE INTERES NOMINAL
NUMERO DE PERIODOS
EJERCICIO # 23 EVALUANDO EL COSTO EFECTIVO DE UN PRESTAMO
CONCEPTO
[ 1 + j / n ] ^ 12 - 1
NUMERO DE PERIODOS
CONCEPTO
VALOR PRESENTE
TASA DE INTERES MENSUAL
PERIODO DE PAGO
VP * ( 1 + i ) ^ n
EJERCICIO # 24 COMPRA CON TARJETA DE CREDITO
CONCEPTO
VALOR PRESENTE
VP * ( 1 + i ) ^ n - 1/( 1 + i ) ^ n * i
NUMERO DE PERIODOS
SERIE UNIFORME
CONCEPTO
[ 1 + j / n ] ^ 12 - 1
NUMERO DE PERIODOS
CONCEPTO
[ 1 + j / n ] ^ 12 - 1
NUMERO DE PERIODOS
EJERCICIO # 25 VALOR ACTUAL DE LOS INGRESOS ANUALES
CONCEPTO
A * ( ( 1 + i ) ^n - 1 ) / ( ( 1 + i ) ^n * i )
TASA DE INTERES
NUMERO DE PERIODOS
SERIE UNIFORME
CONCEPTO
VF / ( 1 + i ) ^ n
TASA DE INTERES
PERIODOS
VALOR FUTURO
EJERCICIO # 26 CUANDO UNA INVERSION SE DUPLICA
CONCEPTO
VALOR PRESENTE
VP * ( 1 + i ) ^ n - 1/( 1 + i ) ^ n * i
NUMERO DE PERIODOS
VALOR FUTURO
CONCEPTO
VALOR PRESENTE
TASA DE INTERES MENSUAL
PERIODO DE PAGO
VP * ( 1 + i ) ^ n
JERCICIO # 27 CALCULANDO EL VALOR DE CONTADO DE UN TERRENO
CONCEPTO
A * ( ( 1 + i ) ^n - 1 ) / ( ( 1 + i ) ^n * i )
TASA DE INTERES
NUMERO DE PERIODOS
SERIE UNIFORME
CONCEPTO
VF / ( 1 + i ) ^ n
TASA DE INTERES
NUMERO DE PERIODOS
SERIE UNIFORME
VALOR DE CONTADO DEL TERRENO = $26.775.080 + $1.983.094 +

$20.000.000
EJERCICIO # 28 LA MEJOR OFERTA
DE CONTADO
CONCEPTO
A * ( ( 1 + i ) ^n - 1 ) / ( ( 1 + i ) ^n * i )
TASA DE INTERES
NUMERO DE PERIODOS
SERIE UNIFORME
OPCION B $190.000.000 + $222.591.117
CONCEPTO
A * ( ( 1 + i ) ^n - 1 ) / ( ( 1 + i ) ^n * i )
TASA DE INTERES
PERIODOS
VALOR FUTURO
DADO UN VP HALLO UN VF VF=VP*(1+i)^n
CONCEPTO
VF / ( 1 + i ) ^ n
TASA DE INTERES
NUMERO DE PERIODOS
VALOR FUTURO
OPCION C $215,736,961 + $183,757,463
ERCICIO # 29 GENERANDO FONDOS PARA LA SUSTITUCION DE EQUIPOS
CONCEPTO
VALOR FUTURO
TASA DE INTERES
PERIODOS
VF * ( i / ( ( 1 + i ) ^ n - 1 ) )
EJERCICIO # 30 SOBREGIROS BANCARIOS

PRIMER PASO
MONTO SOBREGIRO
TASA NOMINAL ANUAL CAP MES VENCIDO
DIAS DE SOBREGIRO
VP * n * d / ( 1 + n * i )
SEGUNDO PASO
VALOR PRESENTE = VN - ( D ( 2 ) + p ) = * f
MONTO SOBREGIRO
COMISION FLAT
PORTES
VP * n * d / ( 1 + n * i )
TERCER PASO
( VN - VP ) / VP
CUARTO PASO
VP * ( 1 + i ) ^ n
VP * ( 1 + i ) ^ n
MONTO SOBREGIRO
INT CTE + INT MORA ( 0.49/360 + 0,18/360 )
DIAS DE SOBREGIRO
DIAS DE SOBREGIRO
PORTES
ALCULAMOS EL COSTO MENSUAL DEL SOBREGIRO
CONCEPTO
VALOR PRESENTE
VP * ( 1 + i ) ^ n - 1/( 1 + i ) ^ n * i
VP * ( 1 + i ) ^ n - 1/( 1 + i ) ^ n * i
NUMERO DE DIAS
NUMERO DE DIAS
VALOR FUTURO
VALOR FUTURO
O CALCULO LA TASA NOMINAL Y EFECTIVA DEL SOBREGIRO
CONCEPTO
[ 1 + j / n ] ^ 12 - 1
TASA DE INTERES NOMINAL ( INTERES DIARIO/30 DIAS * 360
DIAS )
NUMERO DE PERIODOS
EJERCICIO # 38
CONCEPTO
VP * ( 1 + i ) ^ n - 1/( 1 + i ) ^ n * i
NUMERO DE PERIODOS
SERIE UNIFORME
CONCEPTO
[ 1 + j / n ] ^ 12 - 1
TASA DE INTERES NOMINAL ( INTERES DIARIO/30 DIAS * 360
DIAS )
NUMERO DE PERIODOS
FUNCIONES ARITMETICAS
ALOR FUTURO
51,888,317
0.007
48
37,124,020
UNTO SERIA :
0.00700000
60
37,124,020
500,000
37,124,020
0.00700000
48
51,888,318
500,000
N 5 AÑOS
17,708,544
0.25000000
6
5
8,542,419
6,000,000
3,176,471
26,250,963
UNTO SERIA :
17,708,544
0.25000000
6
67,552,734
6,000,000
8,542,417
0.25000000
5
3,176,470
26,250,961
0.12
0.136364
0.06
0.0638297872
450,000
0.11000000
8
1,037,042
CALES
#ADDIN?
36,249
38,806
TRIMESTRES
1,500,000
0.05000000
20.31
4,040,601
800,000
1,700,000
500,000
0.11000000
12
9
7
2,798,760
4,348,663
1,038,080
8,185,503
1,500
0.01400000
36
2,474
0.01800000
180
211,630,874
160,000
4,800,000
0.12000000
5.24763087
8,700,000
2.97120000
29.13600000
5 AÑOS, 2 MESES Y 29 DIAS
600,000
0.11000000
0.13000000
6
6
1,122,249
2,336,468
RASO
18,000,000
0.01890000
0.02050000
12
0.8333333333
22,534,673
22,918,987
6,000,000
15,000,000
80,038,976
0.14500000
10
6
1.49517596
23,238,394
33,800,582
98,000,000
5.94211152
28.27200000
UE TRAIAMOS PARA UN TOTAL

L ENTERO EN MESES OSEA 5 Y
20,000,000
0.0082796441
18
23,200,000
3,200,000
5,000,000
0.32000000
2.03620024
8,800,000
13.03208640
60,000,000
0.21000000
5
155,624,548
26,562,374
3,500,000
129,062,173
3,000,000
0.03800000
36
154,294
4,990,023
0.03800000
26
305,446
MO
2,500,000
0.04500000
8
379,024
MAN
15,000,000
0.03500000
12
1,552,259
1000000
5,000,000
5
2,000,000
0.03800000
12
210,639
31,596
1.0769141676
0.75360000
12
0.5110686573
0.42000000
12
25,000,000
0.04258905
12
41,238,033
8,789,700
0.04428603
12
960,000
0.6820295218
0.53143235
12
0.9013518816
0.660080124
12
4,256,782
0.10000000
20
500,000
2,643,127
0.10000
5
4,256,782
1
0.05946309
12
2
1
0.05000000
12
1.7958563
26,775,080
0.00750000
30
1,000,000
1,983,094
0.00750000
31
2,500,000
48,758,174
400,000,000
222,591,117
0.04000000
5
50,000,000
412,591,117
211,506,824
0.02000
12
20,000,000
215,736,961
183,757,463
0.08000000
4
250,000,000
399,494,424
POS
180,000,000
0.06
5
31,931,352
10,000,000
0.0013611111
2
27,148
9,580,576
10,000,000
0.04
5,000
14,424
0.0437785787
10,189,910
10,378,240
10,000,000
0.0012222222
15
30
5,000
RO
9,580,576
0.06178723
0.08008024
15
30
10,189,910
10,378,240
SOBREGIRO
1.6108676033
0.9609628722
360
701,000
0.05844091
12
82,900
0.9769670186
0.7012909543
12
EJERCICIOS DE TASA
EJERCICIO # 1
SIMBOLOS EXCEL
CALCULO DE TASA E
TEA #ADDIN?
J 0.30000
n 12
EJERCICIO #
SIMBOLOS EXCEL
CALCULO DE TASA N
TEA 0.344888824
J #ADDIN?
n 12
SIMBOLOS FORMULAS
CALCULO DE TASA CO
i
f
j i + f + ( i * f )
SIMBOLOS EXCEL
CALCULO DE TASA N
TEA #ADDIN?
J 0.19197446
m 12
SIMBOLOS EXCEL
CALCULO DE TASA N
TEA #ADDIN?
J 0.456
m 12
U.
CALCULO DE LA UVR PERIODO 16 DE E
d = DIAS CALENDARIO
FECHA ENTRE EL 16/01/07 AL
15/02/2007
d 31
Variaciòn IPC mes
de diciembre 0.0023
31/2006
UVR al 15 de Enero 160.2018
de 2.007
1/16/2007
1/17/2007
1/18/2007
1/19/2007
1/20/2007
1/21/2007
1/22/2007
1/23/2007
1/24/2007
1/25/2007
1/26/2007
1/27/2007
1/28/2007
1/29/2007
1/30/2007
1/31/2007
2/1/2007
2/2/2007
2/3/2007
2/4/2007
2/5/2007
2/6/2007
2/7/2007
2/8/2007
2/9/2007
2/10/2007
2/11/2007
2/12/2007
2/13/2007
2/14/2007
2/15/2007
EJERCICIOS DE TASAS DE INTERES
EJERCICIO # 1
CONCEPTO
[ 1 + j / n ] ^ 12 - 1
NUMERO DE PERIODOS
EJERCICIO # 2
CONCEPTO
CALCULO DE TASA NOMINAL
TASA DE INTERES EFECTIVA
( ( 1 + i efectiva ) ^ ( 1 / n ) - 1 ) * 12
NUMERO DE PERIODOS
CONCEPTO
CALCULO DE TASA COMBINADA
TASA DE INTERES REAL
INFLACION
TASA DE INTERES COMBINADA
EJERCICIO # 21 CALCULANDO LA TASA EFECTIVA

CONCEPTO
[ 1 + j / n ] ^ 12 - 1
TASA NOMINAL
NUMERO DE PERIODOS
EJERCICIO # 22 CALCULANDO LA TASA NOMINAL

CONCEPTO
[ 1 + j / n ] ^ 12 - 1
( ( 1 + i efectiva ) ^ ( 1 / n ) - 1 ) * 12
NUMERO DE PERIODOS
U.V.R.
ULO DE LA UVR PERIODO 16 DE ENERO 2.007 AL 15 DE FEBRERO DE 2.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
31
NTERES
0.3448888242
0.30000
12
0.344888824
0.30
12
0.15
0.25
0.4375
A
0.2097999944
0.19197446
12
AL
0.5644736115
0.456
12
07 AL 15 DE FEBRERO DE 2.008
Fòrmula para
Exponente de la fòrmula ( t/d ) p nuevo UVR
0.0322580645 160.2137
0.064516129 160.2255
0.0967741935 160.2374
0.1290322581 160.2493
0.1612903226 160.2612
0.1935483871 160.2730
0.2258064516 160.2849
0.2580645161 160.2968
0.2903225806 160.3087
0.3225806452 160.3206
0.3548387097 160.3324
0.3870967742 160.3443
0.4193548387 160.3562
0.4516129032 160.3681
0.4838709677 160.3800
0.5161290323 160.3919
0.5483870968 160.4038
0.5806451613 160.4156
0.6129032258 160.4275
0.6451612903 160.4394
0.6774193548 160.4513
0.7096774194 160.4632
0.7419354839 160.4751
0.7741935484 160.4870
0.8064516129 160.4989
0.8387096774 160.5108
0.8709677419 160.5227
0.9032258065 160.5346
0.935483871 160.5465
0.9677419355 160.5584
1 160.5703
EJERCICIOS TA
CALCULANDO LA CUO
P = $3.000.000 n=6 i=4.5% A=$581.635
SALDO INTERES PAGO O CUOTA SALDO FINAL
MESES INICIAL AMORTIZA
CION
0
3,000,000
1 3,000,000 135,000 446,635 581,635 2,553,365
2 2,553,365 114,901 466,734 581,635 2,086,631
3 2,086,631 93,898 487,737 581,635 1,598,894
4 1,598,894 71,950 509,685 581,635 1,089,209
5 1,089,209 49,014 532,621 581,635 556,589
6 556,589 25,046 556,589 581,635 -
TABLA DE AMORTIZACION FRANCES EJERCICIO # 17

P = $3.000.000 n=36 i=3.8% A=$154.294
SALDO INTERES PAGO O CUOTA SALDO FINAL
MESES INICIAL AMORTIZA
CION
0
3,000,000
1 3,000,000 114,000 40,294 154,294 2,959,706
2 2,959,706 112,469 41,826 154,294 2,917,880
3 2,917,880 110,879 43,415 154,294 2,874,465
4 2,874,465 109,230 45,065 154,294 2,829,400
5 2,829,400 107,517 46,777 154,294 2,782,623
6 2,782,623 105,740 48,555 154,294 2,734,068
7 2,734,068 103,895 50,400 154,294 2,683,668
8 2,683,668 101,979 52,315 154,294 4,631,353
9 4,631,353 175,991 175,991 - 4,807,344
10 4,807,344 182,679 182,679 - 4,990,023
11 4,990,023 189,621 115,825 305,446 4,874,198
12 4,874,198 185,220 120,227 305,446 4,753,971
13 4,753,971 180,651 124,795 305,446 4,629,176
14 4,629,176 175,909 129,538 305,446 4,499,638
15 4,499,638 170,986 134,460 305,446 4,365,178
16 4,365,178 165,877 139,569 305,446 4,225,609
17
4,225,609 160,573 144,873 305,446 4,080,736
18 4,080,736 155,068 150,378 305,446 3,930,358
19 3,930,358 149,354 156,093 305,446 3,774,265
20 3,774,265 143,422 162,024 305,446 3,612,241
21 3,612,241 137,265 168,181 305,446 3,444,060
22 3,444,060 130,874 174,572 305,446 3,269,488
23 3,269,488 124,241 181,206 305,446 3,088,282
24 3,088,282 117,355 188,091 305,446 2,900,191
25 2,900,191 110,207 195,239 305,446 2,704,952
26 2,704,952 102,788 202,658 305,446 2,502,294
27 2,502,294 95,087 210,359 305,446 2,291,935
28 2,291,935 87,094 218,353 305,446 2,073,582
29 2,073,582 78,796 226,650 305,446 1,846,932
30 1,846,932 70,183 235,263 305,446 1,611,669
31 1,611,669 61,243 244,203 305,446 1,367,466
32 1,367,466 51,964 253,483 305,446 1,113,984
33 1,113,984 42,331 263,115 305,446 850,869
34
850,869 32,333 273,113 305,446 577,756
35 577,756 21,955 283,492 305,446 294,264
36 294,264 11,182 294,264 305,446 (0)
TABLA DE AMORTIZACION FRANCES EJERCICIO # 24

P = $8.789.700 n=12 i=4.428603%% A=$960.0
SALDO PORTES PAGO O

MESES INICIAL SEGURO INTERES AMORTIZACION CUOTA
0
1 8,789,700 59,900 389,261 570,739 960,000
2 8,218,961 59,900 363,985 596,015 960,000
3 7,622,946 59,900 337,590 622,410 960,000
4 7,000,536 59,900 310,026 649,974 960,000
5 6,350,562 59,900 281,241 678,759 960,000
6 5,671,803 59,900 251,182 708,818 960,000
7 4,962,985 59,900 219,791 740,209 960,000
8 4,222,776 59,900 187,010 772,990 960,000
9 3,449,786 59,900 152,777 807,223 960,000
10 2,642,563 59,900 117,029 842,971 960,000
11 1,799,592 59,900 79,697 880,303 960,000
12 919,288 59,900 40,712 919,288 960,000
P = $8.789.700 n=12 i=4.428603%% A=$960.000

PORTES
MESES PRESTAMO PAGOS
SEGURO AMORTIZACION
0 (8,789,700) (8,789,700)
1 - 59,900 960,000 1,019,900
2 - 59,900 960,000 1,019,900
3 - 59,900 960,000 1,019,900
4 - 59,900 960,000 1,019,900
5 - 59,900 960,000 1,019,900
6 - 59,900 960,000 1,019,900
7 - 59,900 960,000 1,019,900
8 - 59,900 960,000 1,019,900
9 - 59,900 960,000 1,019,900
10 - 59,900 960,000 1,019,900
11 - 59,900 960,000 1,019,900
12 - 59,900 960,000 1,019,900
TIR 5.5006677%
P = $100.000.000 n=12 i=3.038437% A=$10.069.273.07
SALDO INTERES PAGO SALDO FINAL
AÑOS INICIAL AMORTIZA
CION
0 100,000,000
1 100,000,000 3,000,000 6,624,884 $ 9,624,883.83 93,375,116
2 93,375,116 2,801,253 6,823,630 $ 9,624,883.83 86,551,486
3 86,551,486 2,596,545 7,028,339 $ 9,624,883.83 79,523,147
4 79,523,147 2,783,310 7,669,690 $ 10,452,999.93 71,853,457
5 71,853,457 2,514,871 7,938,129 $ 10,452,999.93 63,915,328
6 63,915,328 2,237,036 8,215,963 $ 10,452,999.93 55,699,364
7 55,699,364 2,227,975 8,397,342 $ 10,625,316.72 47,302,022
8 47,302,022 1,892,081 8,733,236 $ 10,625,316.72 38,568,786
9 38,568,786 1,542,751 9,082,565 $ 10,625,316.72 29,486,221
10 29,486,221 589,724 9,634,761 $ 10,224,484.96 19,851,461
11 19,851,461 397,029 9,827,456 $ 10,224,484.96 10,024,005
12 10,024,005 200,480 10,024,005 $ 10,224,484.96 -
P = $100.000.000 n=12 i=3.038437% A=$10.069.273.07
SALDO AMORTIZA
MESES INICIAL INTERES CION PAGO O CUOTA SALDO FINAL
0 100,000,000
1 100,000,000 3,038,437 7,030,836 $ 10,069,273.07 92,969,164
2 92,969,164 2,824,809 7,244,464 10,069,273.07 85,724,700
3 85,724,700 2,604,691 7,464,582 10,069,273.07 78,260,118
4 78,260,118 2,377,884 7,691,389 10,069,273.07 70,568,730
5 70,568,730 2,144,186 7,925,087 10,069,273.07 62,643,643
6 62,643,643 1,903,388 8,165,885 10,069,273.07 54,477,757
7 54,477,757 1,655,272 8,414,001 10,069,273.07 46,063,757
8 46,063,757 1,399,618 8,669,655 10,069,273.07 37,394,102
9 37,394,102 1,136,196 8,933,077 10,069,273.07 28,461,025
10 28,461,025 864,770 9,204,503 10,069,273.07 19,256,522
11 19,256,522 585,097 9,484,176 10,069,273.07 9,772,346
12 9,772,346 296,927 9,772,346 10,069,273.07 -
EJERCICIOS TABLA DE AMORTIZACION
CULANDO LA CUOTA MENSUAL DE UN PRESTAMO
A=$581.635 P = $2.500.000 n=8 i=4.5%
TASA DE INTERES
TABLA DE AMORTIZACION FRANCES E
SALDO INTERES
MESES
INICIAL AMORTIZAC
4.5% 0 ION
4.5% 1 2,500,000 112,500 266,524
4.5% 2 2,233,476 100,506 278,518
4.5% 3 1,954,958 87,973 291,051
4.5% 4 1,663,907 74,876 831,954
4.5% 5 831,954 37,438 -
6 869,391 39,123 -
7 908,514 40,883 -
8 949,397 42,723 949,397
RCICIO # 17
A=$154.294 TABLA DE AMORTIZACION FRANCES E
TASA DE INTERES
P = $15.000.000 n=12 i=3.5%
SALDO INTERES
MESES INICIAL AMORTIZAC
ION
3.8% 0
3.8% 1 15,000,000 525,000 1,027,259
3.8% 2 13,972,741 489,046 1,063,213
3.8% 3 12,909,527 451,833 1,100,426
3.8% 4 11,809,102 413,319 1,138,941
3.8% 5 10,670,161 373,456 1,178,804
3.8% 6 9,491,357 332,198 1,220,062
3.8% 7 8,271,296 289,495 1,262,764
3.8% 8 7,008,532 245,299 1,306,961
3.8% 9 5,701,571 199,555 1,352,704
3.8% 10 4,348,867 152,210 1,400,049
3.8% 11 2,948,818 103,209 1,449,051
3.8% 12 1,499,767 52,492 1,499,767
3.8%
3.8% TABLA DE AMORTIZACION FR
3.8% P = $2.000.000 n=12 i=3.8%
SALDO INTERES
3.8% ION
3.8% 0
3.8% 1 2,000,000 76,000 134,639
3.8% 2 1,865,361 70,884 139,755
3.8% 3 1,725,606 65,573 145,066
3.8% 4 1,580,541 60,061 150,578
3.8% 5 1,429,962 54,339 156,300
3.8% 6 1,273,662 48,399 162,240
3.8% 7 1,111,423 42,234 168,405
3.8% 8 943,018 35,835 174,804
3.8% 9 768,214 29,192 181,447
3.8% 10 586,768 22,297 188,342
3.8% 11 398,426 15,140 195,499
3.8% 12 202,927 7,711 202,927
3.8%
3.8% TABLA DE AMORTIZACION FRANCES EJERCICIO # 22 COST
3.8% P = $2.000.000 n=12 i=3.8%
SALDO INTERES
3.8% ION
3.8% 0
3.8% 1 2,000,000 76,000 134,639
2 1,865,361 70,884 139,755
3 1,725,606 65,573 145,066
4 1,580,541 60,061 150,578
5 1,429,962 54,339 156,300
6 1,273,662 48,399 162,240
7 1,111,423 42,234 168,405
8 943,018 35,835 174,804
9 768,214 29,192 181,447
10 586,768 22,297 188,342
11 398,426 15,140 195,499
12 202,927 7,711 202,927
TIR
RCICIO # 24
%% A=$960.000
TASA DE
SALDO FINAL INTERES
8,789,700
8,218,961 0.04428603
7,622,946 0.04428603
7,000,536 0.04428603
6,350,562 0.04428603
5,671,803 0.04428603
4,962,985 0.04428603
4,222,776 0.04428603
3,449,786 0.04428603
2,642,563 0.04428603
1,799,592 0.04428603
919,288 0.04428603
- 0.04428603
A=$10.069.273.07
TASA DE INTERES
3.0%
3.0%
3.0%
3.5%
3.5%
3.5%
4.0%
4.0%
4.0%
2.0%
2.0%
2.0%
A=$10.069.273.07
TASA DE INTERES
0.03038437
0.03038437
0.03038437
0.03038437
0.03038437
0.03038437
0.03038437
0.03038437
0.03038437
0.03038437
0.03038437
0.03038437
=8 i=4.5% A=$379.024
ACION FRANCES EJERCICIO # 18

PAGO O CUOTA SALDO TASA DE
INSOLUTO INTERES
DE DEUDA
2,500,000
379,024 2,233,476 4.5%
379,024 1,954,958 4.5%
379,024 1,663,907 4.5%
906,829 831,954 4.5%
- 869,391 4.5%
- 908,514 4.5%
- 949,397 4.5%
992,120 - 4.5%
ACION FRANCES EJERCICIO # 19
=12 i=3.5% A=$1.552.259
PAGO O CUOTA SALDO TASA DE

FINAL INTERES
15,000,000
1,552,259 13,972,741 3.5%
1,552,259 12,909,527 3.5%
1,552,259 11,809,102 3.5%
1,552,259 10,670,161 3.5%
1,552,259 9,491,357 3.5%
1,552,259 8,271,296 3.5%
1,552,259 7,008,532 3.5%
1,552,259 5,701,571 3.5%
1,552,259 4,348,867 3.5%
1,552,259 2,948,818 3.5%
1,552,259 1,499,767 3.5%
1,552,259 - 3.5%
MORTIZACION FRANCES EJERCICIO # 22

n=12 i=3.8% A=$210.639 S=$31.596
PAGO O CUOTA AHORRO PAGO TOTAL SALDO TASA DE
FINAL INTERES
2,000,000
210,639 31,596 242,235 1,865,361 3.8%
210,639 31,596 242,235 1,725,606 3.8%
210,639 31,596 242,235 1,580,541 3.8%
210,639 31,596 242,235 1,429,962 3.8%
210,639 31,596 242,235 1,273,662 3.8%
210,639 31,596 242,235 1,111,423 3.8%
210,639 31,596 242,235 943,018 3.8%
210,639 31,596 242,235 768,214 3.8%
210,639 31,596 242,235 586,768 3.8%
210,639 31,596 242,235 398,426 3.8%
210,639 31,596 242,235 202,927 3.8%
210,639 31,596 242,235 - 3.8%
CES EJERCICIO # 22 COSTO EFECTIVO DEL DINERO FLUJO DE CAJA Y TIR

n=12 i=3.8% A=$210.639 S=$31.596
PAGO O CUOTA AHORRO PAGO TOTAL ( SALDO TASA DE
FLUJO DE FINAL INTERES
CAJA )
(2,000,000) 2,000,000
210,639 31,596 242,235 1,865,361 3.8%
210,639 31,596 242,235 1,725,606 3.8%
210,639 31,596 242,235 1,580,541 3.8%
210,639 31,596 242,235 1,429,962 3.8%
210,639 31,596 242,235 1,273,662 3.8%
210,639 31,596 242,235 1,111,423 3.8%
210,639 31,596 242,235 943,018 3.8%
210,639 31,596 242,235 768,214 3.8%
210,639 31,596 242,235 586,768 3.8%
210,639 31,596 242,235 398,426 3.8%
210,639 31,596 242,235 202,927 3.8%
210,639 31,596 242,235 - 3.8%
TIR 6.2804%
EJERCICIOS TABLA DE AMORTIZACION
SISTEMA DE AMORTIZACION ALEMAN
P = $4.000.000 n=24 i=3.85% AMORTIZACION=$166.667
SALDO INTERES AMORTIZA PAGO O SALDO
MESES
INICIAL CION CUOTA FINAL
0 4,000,000
1 4,000,000 154,000 166,667 320,667 3,833,333
2 3,833,333 147,583 166,667 314,250 3,666,667
3 3,666,667 141,167 166,667 307,833 3,500,000
4 3,500,000 134,750 166,667 301,417 3,333,333
5 3,333,333 128,333 166,667 295,000 3,166,667
6 3,166,667 121,917 166,667 288,583 3,000,000
7 3,000,000 115,500 166,667 282,167 2,833,333
8 2,833,333 109,083 166,667 275,750 2,666,667
9 2,666,667 102,667 166,667 269,333 2,500,000
10 2,500,000 96,250 166,667 262,917 2,333,333
11 2,333,333 89,833 166,667 256,500 2,166,667
12 2,166,667 83,417 166,667 250,083 2,000,000
13 2,000,000 77,000 166,667 243,667 1,833,333
14 1,833,333 70,583 166,667 237,250 1,666,667
15 1,666,667 64,167 166,667 230,833 1,500,000
16 1,500,000 57,750 166,667 224,417 1,333,333
17 1,333,333 51,333 166,667 218,000 1,166,667
18 1,166,667 44,917 166,667 211,583 1,000,000
19 1,000,000 38,500 166,667 205,167 833,333
20 833,333 32,083 166,667 198,750 666,667
21 666,667 25,667 166,667 192,333 500,000
22 500,000 19,250 166,667 185,917 333,333
23 333,333 12,833 166,667 179,500 166,667
24 166,667 6,417 166,667 173,083 0
TOTAL 50,000,000 1,925,000 4,000,000 5,925,000 50,000,000
P = $15.000.000 n=12 i=3.5% AMORTIZACION=$1.250.000

TABLA DE AMORTIZACION ALEMAN EJERCICIO # 19
MESES
0 15,000,000
1 15,000,000 525,000 1,250,000 1,775,000 13,750,000
2 13,750,000 481,250 1,250,000 1,731,250 12,500,000
3 12,500,000 437,500 1,250,000 1,687,500 11,250,000
4 11,250,000 393,750 1,250,000 1,643,750 10,000,000
5 10,000,000 350,000 1,250,000 1,600,000 8,750,000
6 8,750,000 306,250 1,250,000 1,556,250 7,500,000
7 7,500,000 262,500 1,250,000 1,512,500 6,250,000
8 6,250,000 218,750 1,250,000 1,468,750 5,000,000
9 5,000,000 175,000 1,250,000 1,425,000 3,750,000
10 3,750,000 131,250 1,250,000 1,381,250 2,500,000
11 2,500,000 87,500 1,250,000 1,337,500 1,250,000
12 1,250,000 43,750 1,250,000 1,293,750 -
P = $5.000.000 n=5 i(1 a 3)=5.5% i(4 a 5)=7.5% AMORTIZACION=$1.000.000

TABLA DE AMORTIZACION ALEMAN EJERCICIO # 20
AÑOS
0 5,000,000
1 5,000,000 275,000 1,000,000 1,275,000 4,000,000
2 4,000,000 220,000 1,000,000 1,220,000 3,000,000
3 3,000,000 165,000 1,000,000 1,165,000 2,000,000
4 2,000,000 150,000 1,000,000 1,150,000 1,000,000
5 1,000,000 75,000 1,000,000 1,075,000 -
0.66008
ZACION EJERCICIO DOLARES
EMAN SISTEMA DE AMORTIZACION ALEMAN
ZACION=$166.667 P = $4.000.000 n=24 i=3.85% AMORTIZACION=$166.667
TASA DE SALDO INTERES SALDO FINAL
MESES
INTERES INICIAL
0 10,000
3.85% 1 833 320 (156,667)
3.85% 2 (156,667) (6,032) (323,333)
3.85% 3 (323,333) (12,448) (490,000)
3.85% 4 (490,000) (18,865) (656,667)
3.85% 5 (656,667) (25,282) (823,333)
3.85% 6 (823,333) (31,698) (990,000)
3.85% 7 (990,000) (38,115) (1,156,667)
3.85% 8 (1,156,667) (44,532) (1,323,333)
3.85% 9 (1,323,333) (50,948) (1,490,000)
3.85% 10 (1,490,000) (57,365) (1,656,667)
3.85% 11 (1,656,667) (63,782) (1,823,333)
3.85% 12 (1,823,333) (70,198) (1,990,000)
3.85%
3.85%
3.85%
3.85%
3.85%
3.85%
3.85%
3.85%
3.85%
3.85%
3.85%
3.85%
ACION=$1.250.000
RCICIO # 19
TASA DE
INTERES
3.50%
3.50%
3.50%
3.50%
3.50%
3.50%
3.50%
3.50%
3.50%
3.50%
3.50%
3.50%
TIZACION=$1.000.000
RCICIO # 20
TASA DE
INTERES
5.50%
5.50%
5.50%
7.50%
7.50%
ALEMAN
ORTIZACION=$166.667
TASA DE
INTERES
3.20%
3.20%
3.20%
3.20%
3.20%
3.20%
3.20%
3.20%
3.20%
3.20%
3.20%
3.20%
TALLERES VA
EJER
NOTACION ESTANDAR
SIMBOLOS DE FACTORES
CALCULAR EL VALOR PRESENT
VP ò VA = VALOR PRESENTE VP=VF(VP/VF,i%,n) *
i = TASA DE INTERES
n = PERIODOS
VF = VALOR FUTURO
* Indica que el valor que se encuentra en el denominador
EJER
NOTACION ESTANDAR
VP ò VA = VALOR PRESENTE VP=VF(VP/VF,i%,n) *
i = TASA DE INTERES
n = PERIODOS
VF = VALOR FUTURO
TALLERES V
EJER
SIMBOLOS NOTACION ESTANDAR
DE FACTORES
CALCULAR EL VALOR FUTURO A
VP ò VA = VALOR PRESENTE
i = TASA DE INTERES
n = PERIODOS
VF = VALOR FUTURO VF=VP(VF/VP,i%,n) *
EJER
NOTACION ESTANDAR
SIMBOLOS
DE FACTORES
i = TASA DE INTERES
n = PERIODOS
VF = VALOR FUTURO VF=VP(VF/VP,i%,n) *
TALLERES SE
EJER
NOTACION ESTANDAR
CALCULAR EL VALOR PRESENTE A PA
VP ò VA = VALOR PRESENTE VP=A(VP/A,i%,n) *
i = TASA DE INTERES
n = PERIODOS
A = SERIE UNIFORME
* Indica que el valor que se encuentra en el denominado
EJER
NOTACION ESTANDAR
VP ò VA = VALOR PRESENTE VP=A(VP/A,i%,n) *
i = TASA DE INTERES
n = PERIODOS
A = SERIE UNIFORME

EJER
NOTACION ESTANDAR
CALCULAR LA SERIE UNIFORME

A = SERIE UNIFORME A=VF(A/VF,i%,n) *
i = TASA DE INTERES
n = PERIODOS
VF = VALOR FUTURO
EJER
NOTACION ESTANDAR
i = TASA DE INTERES
n = PERIODOS
VF = VALOR FUTURO
EJER
NOTACION ESTANDAR

i = TASA DE INTERES
n = PERIODOS
A = SERIE UNIFORME A=VP(A/VP,i%,n) *

EJER
NOTACION ESTANDAR
i = TASA DE INTERES
n = PERIODOS
A = SERIE UNIFORME A=VP(A/VP,i%,n) *
EJER
NOTACION ESTANDAR

VF = VALOR FUTURO
i = TASA DE INTERES
n = PERIODOS
EJER
NOTACION ESTANDAR
VF = VALOR FUTURO
i = TASA DE INTERES
n = PERIODOS

TALLERES TAS
EJER
NOTACION ESTANDAR
CALCULAR LA TASA DE INTERE

i = TASA DE INTERES VF=VP(VF/VP,i%,n) *
n = PERIODOS
VF = VALOR FUTURO
EJER

DE FACTORES
i = TASA DE INTERES VF=VP(VF/VP,i%,n) *
n = PERIODOS
VF = VALOR FUTURO
CALCULAR LA TASA DE INTERES A PARTIR DE UN VA
EJER
NOTACION ESTANDAR
i = TASA DE INTERES VP=A(VP/A,i%,n) *
n = PERIODOS
A = SERIE UNIFORME
* Indica que el valor que se encuentra en el denominad
EJER
NOTACION ESTANDAR
i = TASA DE INTERES VP=A(VP/A,i%,n) *
n = PERIODOS
A = SERIE UNIFORME
* Indica que el valor que se encuentra en el denominad
TALLERES NUME
EJER
CALCULAR EL NUMERO DE PERIODOS A
NOTACION ESTANDAR
i = TASA DE INTERES
n = PERIODOS VF=VP(VF/VP,i%,n) *
VF = VALOR FUTURO
* Indica que el valor que se encuentra en el denominador (
EJER
NOTACION ESTANDAR
i = TASA DE INTERES
VF = VALOR FUTURO
EJER

DE FACTORES
i = TASA DE INTERES
VF = VALOR FUTURO

TALLERES VALOR PRESENTE
EJERCICIO # 1
EXCEL CONCEPTO
VALOR PRESENTE A PARTIR DE UN VALOR FUTURO

3,845,407 VF / ( 1 + i ) ^ n
0.01100 TASA DE INTERES
24 PERIODOS
5,000,000 VALOR FUTURO
se encuentra en el denominador ( VF ) es el valor conocido y voy a calcular en este caso el VP
EJERCICIO # 2
EXCEL CONCEPTO
1,861,100 VF / ( 1 + i ) ^ n
5 PERIODOS
se encuentra en el denominador ( VF ) es el valor conocido y voy a calcular en este caso el VP
TALLERES VALOR FUTURO

EJERCICIO # 5
EXCEL CONCEPTO
VALOR FUTURO A PARTIR DE UN VALOR PRESENTE
15,000,000 VALOR PRESENTE
24 PERIODOS
23,016,428 VP * ( 1 + i ) ^ n
se encuentra en el denominador ( VP ) es el valor conocido y voy a calcular en este caso el VF
EJERCICIO # 6
EXCEL CONCEPTO
21 PERIODOS
23,544,606 VP * ( 1 + i ) ^ n
se encuentra en el denominador ( VP ) es el valor conocido y voy a calcular en este caso el VF
TALLERES SERIE UNIFORME

EJERCICIO # 3
EXCEL CONCEPTO
R PRESENTE A PARTIR DE SERIE UNIFORME ( ANUALIDAD )

24,689,312 A * ( ( 1 + i ) ^ n - 1 ) /( ( 1 + i ) ^ n * i ) )
26 PERIODOS
1,085,870 SERIE UNIFORME O PAGO
se encuentra en el denominador ( A ) es el valor conocido y voy a calcular en este caso el VP
EJERCICIO # 4
EXCEL CONCEPTO
1,110,264 A * ( ( 1 + i ) ^ n - 1 ) /( ( 1 + i ) ^ n * i ) )
18 PERIODOS
67,830 SERIE UNIFORME O PAGO
se encuentra en el denominador ( A ) es el valor conocido y voy a calcular en este caso el VP

EJERCICIO # 7
EXCEL CONCEPTO
A SERIE UNIFORME A PARTIR DE UN VALOR FUTURO

383,475 VF*( i / ((1+i)^n-1))
12 PERIODOS
e se encuentra en el denominador ( VF ) es el valor conocido y voy a calcular en este caso la
EJERCICIO # 8
EXCEL CONCEPTO
95,100 VF*( i / ((1+i)^n-1))

22 PERIODOS
EJERCICIO # 9
EXCEL CONCEPTO
SERIE UNIFORME A PARTIR DE UN VALOR PRESENTE

120 PERIODOS
1,248,880 VP * ( ( 1 + i ) ^ n * i)/(( 1 + i )^ n- 1 )
se encuentra en el denominador ( VP ) es el valor conocido y voy a calcular en este caso la

EJERCICIO # 10
EXCEL CONCEPTO

60 PERIODOS
865,708 VP * ( ( 1 + i ) ^ n * i)/(( 1 + i )^ n- 1 )
se encuentra en el denominador ( VP ) es el valor conocido y voy a calcular en este caso la
EJERCICIO # 11
EXCEL CONCEPTO
A SERIE UNIFORME A PARTIR DE UN VALOR FUTURO

360 PERIODOS
40,920 VF * ( i / ( ( 1 + i ) ^ n - 1 ) )
EJERCICIO # 12
EXCEL CONCEPTO

8 PERIODOS
974,351 VF * ( i / ( ( 1 + i ) ^ n - 1 ) )

TALLERES TASAS DE INTERES
EJERCICIO # 13
EXCEL CONCEPTO
LA TASA DE INTERES A PARTIR DE UN VF-VP Y UN N

0.02809232 ( ( VF / VP ) ^ 1/n ) - 1
3 PERIODOS
e se encuentra en el denominador ( VP ) es el valor conocido y voy a calcular en este caso la i
EJERCICIO # 14
EXCEL CONCEPTO

0.00107613 ( ( VF / VP ) ^ 1/n ) - 1
35 PERIODOS
e se encuentra en el denominador ( VP ) es el valor conocido y voy a calcular en este caso la i
ES A PARTIR DE UN VALOR PRESENTE Y UNA SERIE UNIFORME O ANUALIDAD
EJERCICIO # 15
EXCEL CONCEPTO

0.13353177 VP * ( 1 + i ) ^ n - 1/( 1 + i ) ^ n * i
7
6,853,000 SERIE UNIFORME
e se encuentra en el denominador (VP ) es el valor conocido y voy a calcular en este caso la i
EJERCICIO # 16
EXCEL CONCEPTO

0.02779709 VP * ( 1 + i ) ^ n - 1/( 1 + i ) ^ n * i
35
9,020,000 SERIE UNIFORME
e se encuentra en el denominador (VP ) es el valor conocido y voy a calcular en este caso la i
TALLERES NUMERO DE PERIODOS

EJERCICIO # 17
O DE PERIODOS A PARTIR DE UN VF-VP Y LA TASA DE INTERES
EXCEL CONCEPTO

5.54779044 LOG ( VF / VP ) / LOG ( 1 + i )
ntra en el denominador ( VP ) es el valor conocido y voy a calcular en este caso el nùmero de perìodos n
EJERCICIO # 18
EXCEL CONCEPTO
500,000 VALOR PRESENTE

158.03537486 LOG ( VF / VP ) / LOG ( 1 + i )
EJERCICIO # 19
EXCEL CONCEPTO

38.76862384 LOG ( VF / VP ) / LOG ( 1 + i )
UTURO
3,845,407
0.01100
24
5,000,000
e caso el VP
1,861,100
0.01450
5
2,000,000
e caso el VP
SENTE
15,000,000
0.01800
24
23,016,428
e caso el VF
15,000,000
0.01800
24
23,016,428
e caso el VF
( ANUALIDAD )
24,689,312
0.01020
26
1,085,870
e caso el VP
1,110,264
0.01020
18
67,830
e caso el VP
UTURO
383,475
0.01730
12
5,065,812
te caso la A
95,100
0.01090
22
2,350,000
te caso la A
ESENTE
75,000,000
0.01320
120
1,248,880
te caso la A
32,000,000
0.01750
60
865,708
te caso la A
UTURO
168,000,000
0.01060
360
40,920
te caso la A
8,500,000
0.02460
8
974,351
te caso la A
Y UN N
75,000,000
0.0280923205
3
81,500,000
ste caso la i
5,778,333
0.00107613
35
6,000,000
ste caso la i
FORME O ANUALIDAD
2,850,000
0.13353177
7
6,853,000
ste caso la i
3,455,000
0.02779709
35
9,020,000
ste caso la i
ASA DE INTERES
35,000,000
0.09000000
5.54779044
56,455,000
nùmero de perìodos n
500,000
0.01670000
158.03537486
6,850,000
3,500,000
0.01400000
38.76862384
6,000,000
TALLERES TASAS DE INTERES Y NUMERO DE PE
EJERCICIO
NOTACION
SIMBOLOS ESTANDAR DE
FACTORES
CALCULAR LA TASA DE INTERES A PAR
i = TASA DE INTERES i=VP(i/VP,VF,n) *
n = PERIODOS
VF = VALOR FUTURO
* Indica que el valor que se encuentra en el denominador ( VP ) es el val
EJERCICIO
CALCULAR EL NUMERO DE PERIODOS A P
i = TASA DE INTERES
n = PERIODOS n=VP(n/VP,VF,i%) *
VF = VALOR FUTURO
TALLERES TASAS DE INTERES Y NUMERO DE P

EJERCICIO
NOTACION
SIMBOLOS ESTANDAR DE
FACTORES
CALCULAR LA TASA DE INTERES A PAR
i = TASA DE INTERES i=VF(i/VF,VP,n) *
n = PERIODOS
VF = VALOR FUTURO

CALCULAR EL NUMERO DE PERIODOS A P
i = TASA DE INTERES
n = PERIODOS n=VF(n/VF,VP,i%) *
VF = VALOR FUTURO

INTERES Y NUMERO DE PERIODOS A PARTIR DEL VALOR PRESENTE
EJERCICIO #
EXCEL CONCEPTO
CULAR LA TASA DE INTERES A PARTIR DE UN VALOR PRESENTE

0.09596 ( ( VF / VP ) ^ 1/n ) - 1
10 PERIODOS
250,000 VALOR FUTURO
a en el denominador ( VP ) es el valor conocido, al igual que el VF y voy a calcular en este caso la i
EJERCICIO #
AR EL NUMERO DE PERIODOS A PARTIR DE UN VALOR PRESENTE
9.9998233865 LOG ( VF / VP ) / LOG ( 1 + i )
en el denominador ( VP ) es el valor conocido, al igual que el VF y voy a calcular en este caso el
E INTERES Y NUMERO DE PERIODOS A PARTIR DEL VALOR FUTURO

EJERCICIO #
EXCEL CONCEPTO
CULAR LA TASA DE INTERES A PARTIR DE UN VALOR PRESENTE

0.09741 ( ( VF / VP ) ^ 1/n ) - 1
10 PERIODOS
a en el denominador ( VF ) es el valor conocido, al igual que el VP y voy a calcular en este caso la i

AR EL NUMERO DE PERIODOS A PARTIR DE UN VALOR PRESENTE
10.000079375 LOG ( VF / VP ) / LOG ( 1 + i )
en el denominador ( VF ) es el valor conocido, al igual que el VP y voy a calcular en este caso el

NTE
FUNCIONES
ARITMETICAS
100,000
0.09596
10
250,000
en este caso la i
100,000
0.09596
9.9998233865
250,000
en este caso el n
RO
FUNCIONES
ARITMETICAS
150,000
0.09741
10
380,000
en este caso la i
150,000
0.09741
10.000079375
380,000
en este caso el n
EJERCICIO
EJERCICIO # 7 SUSTITUCION DE UNA SERIE UN
SIMBOLOS EXCEL
SUSTITUCION DE UNA SERIE UNIFORM
VP ò VA 238,425.119584
i 0.02333333
n 18
A 16,000.0000000
VP ( 1 ) 243,988.3723745
P = $238.425 PAGO ( MES 1 ) n=15
n(1) 15
g (4,000)
FACTOR 1 12.5345452053
FACTOR 2 -171,428.571429
FACTOR 3 12.5345452
FACTOR 4 10.612909178
VP TOTAL -2,148,777.2564
DESPEJE ALGEBRAICO EN A 190,893.693357
EJERCICIO # 8 CALCULO DEL V
SIMBOLOS EXCEL
VALOR PRESENTE DE U
VP PRIMER AÑO 49,770.02
VP SEGUNDO AÑO 59,724.02
VP TERCER AÑO 69,678.03
i 0.03000000
n 12
A PRIMER AÑO 5,000
A SEGUNDO AÑO 6,000
A TERCER AÑO 7,000
P = $49.770,019968 n=1
n(1) 10
g 9,954
i 0.03
IE #ADDIN?
m 12
P(g) #ADDIN?
P (A) #ADDIN?
PT #ADDIN?
EJERCICIO # 9 CALCULO DEL
SIMBOLOS EXCEL
VALOR PRESENTE DE U
CUOTA INICIAL = $1.500 n=24
i 0.02800000
n 24
g 80
A 250
P(g) 14,103
P (A) 4,327
PT 19,930
SIMBOLOS EXCEL
VALOR PRESENTE DE U
VALOR PAGADO = $5.000 n=12 i=0,0234
i #ADDIN?
IE 0.32
m 12
n 12
n ( 1 ) 10
P 5,000
F 11,000
F ( 1 ) 7,400
g 500
g ( 1 ) (360)
A 5,500
P(g) #ADDIN?
P (A ) #ADDIN?
PT #ADDIN?
A ( 1 ) 11,360
P(g 1 ) #ADDIN?
P (A 1 ) #ADDIN?
PT ( 1 ) ò V F #ADDIN?
PT ( 1 ) #ADDIN?
VP TOTAL #ADDIN?
LA SECUENCIA DE PAGOS ES VALORES

0 5,000
1 ( g ) + 500 5,500
2 6,000
3 6,500
4 7,000
5 7,500
6 8,000
7 8,500
8 9,000
9 9,500
10 10,000
11 10,500
12 11,000
13 ( g ) - 360 10,640
14 10,280
15 9,920
16 9,560
17 9,200
18 8,840
19 8,480
20 8,120
21 7,760
22 7,400
SIMBOLOS EXCEL
VALOR PRESENTE DE U
n=12 i=0,02500706 Ò 2
i #ADDIN?
IE 0.345
m 12
n 12
g 2,000
A 120,000
P(g) #ADDIN?
P (A ) #ADDIN?
PT = P ( A ) + P ( g ) #ADDIN?
A Perpetua #ADDIN?
SIMBOLOS EXCEL
VALOR PRESENTE DE U
P=$15.000.000 n=12 TRIMESTRES i
ia 0.09
iv 0.0989010989
n 12
P 15,000,000
A 2,189,613
i #ADDIN?
IE 0.33
m 4
P #ADDIN?
SIMBOLOS EXCEL
VALOR PRESENTE DE U
P=$15.000.000 n=24 TRIMESTRES
ia 0.0725
iv 0.0781671159
i #ADDIN?
IE 0.0725
m 3
n 24
g (50)
A 48,000
A(1) 24,000
F (A) #ADDIN?
F (g) #ADDIN?
FT = F ( A ) + F ( g ) #ADDIN?
EJERCICIOS DE GRADIENTES
TITUCION DE UNA SERIE UNIFORME A PARTIR DE UN GRADIENTE DECRECIENTE ARITMETICO
CONCEPTO
N DE UNA SERIE UNIFORME POR UNA EQUIVALENCIA CON GRADIENTE DECRECIENTE
VALOR PRESENTE EN EL MES - 1
TASA DE INTERES
NUMERO DE PERIODOS
SERIE UNIFORME MES ANTICIPADO
VALOR PRESENTE DESDE -1 HASTA 1 ( DOS PERIODOS DESPUES )
( MES 1 ) n=15 i=2.333333% A= ? G = - $4.000
NUMERO DE PERIODOS
GRADIENTE DECRECIENTE
(1-(1+i)^-n )/i
g / i
( ( 1 - (1+i )^ - n ) / i )
n / ( 1 + i ) ^ n
VPT = A * { (1-(1+I) ^ - n ) / i }+g/i{(1-(1+i)^-n)/i}-{n/(1+i)^n}
LA PRIMERA CUOTA ES DE $190.894 Y DE AHÍ EN ADELANTE SE DISMINUYE EN $4.000
ERCICIO # 8 CALCULO DEL VALOR PRESENTE DE UN GRADIENTE CRECIENTE

CONCEPTO
VALOR PRESENTE DE UNA SERIE DE PAGOS DURANTE 10 AÑOS
VALOR PRESENTE EN EL PRIMER AÑO
TASA DE INTERES
NUMERO DE PERIODOS
SERIE UNIFORME PRIMER AÑO
SERIE UNIFORME SEGUNDO AÑO
SERIE UNIFORME TERCER AÑO
9968 n=10 i=42.5760887% E.A. g = $9.954
NUMERO DE PERIODOS
AUMENTO AÑO TRAS AÑO GRADIENTE CRECIENTE
TASA DE INTERES
INTERES EFECTIVO CAPITALIZABLE MES VENCIDO
NUMERO DE MESES
g / i * ( ( ( 1 + i ) ^ n - 1 ) / ( ( 1 + i ) ^ n * i ) - n / ( 1 + i ) ^
n
A *( ( ( 1 + i ) ^ n ) - 1 ) / ( ( 1 + i ) ^ n * i )
SUMATORIA DE V/P GRADIENTE + V/P DE LA SERIE UNIFORME
ERCICIO # 9 CALCULO DEL VALOR PRESENTE DE UN GRADIENTE CRECIENTE
CONCEPTO
VALOR PRESENTE DE UN GRADIENTE ARITMETICO POSPAGABLE
L = $1.500 n=24 i=0,0208 Ò 2.08% g = $80 A=$250
TASA DE INTERES
NUMERO DE PERIODOS
AUMENTO MENSUAL GRADIENTE CRECIENTE
PRIMERA SERIE UNIFORME = VP + g
g / i * ( ( ( 1 + i ) ^ n - 1 ) / ( ( 1 + i ) ^ n * i ) - n / ( 1 + i ) ^
n
A *( ( ( 1 + i ) ^ n ) - 1 ) / ( ( 1 + i ) ^ n * i )
RCICIO # 10 CALCULO DEL VALOR PRESENTE DE UN GRADIENTE CRECIENTE
CONCEPTO
n=12 i=0,02340569 Ò 2.2340569% g = $500 A=$5.500 A1=$10.64
TASA DE INTERES NOMINAL MES VENCIDO
TASA DE INTERES EFECTIVA ANUAL
NUMERO DE PERIODOS DE CAPITALIZACION
NUMERO DE MESES SERIE A 1
NUMERO DE MESES SERIE A 2
VALOR INICIAL
VALOR FUTURO PERIODO 12
VALOR FUTURO PERIODO 22
DECRECIMIENTO MENSUAL DEL GRADIENTE
g / i * ( ( ( 1 + i ) ^ n - 1 ) / ( ( 1 + i ) ^ n * i ) - n / ( 1 + i ) ^
n
A *( ( ( 1 + i ) ^ n ) - 1 ) / ( ( 1 + i ) ^ n * i )
g / i * ( ( ( 1 + i ) ^ n - 1 ) / ( ( 1 + i ) ^ n * i ) - n / ( 1 + i ) ^
n
A *( ( ( 1 + i ) ^ n ) - 1 ) / ( ( 1 + i ) ^ n * i )
VALOR PRESENTE AL TRASLADARLO AL MOMENTO CERO DESDE EL MES 12
SUMA TOTAL DE LOS VALORES PRESENTES
CONCEPTO
i=0,02500706 Ò 2.500706% g = $2.000 A=$120.000
TASA DE INTERES NOMINAL MES VENCIDO
NUMERO DE MESES
SERIE UNIFORME ( MANTENIMIENTO )
g / i * ( ( ( 1 + i ) ^ n - 1 ) / ( ( 1 + i ) ^ n * i ) - n / ( 1 + i ) ^
n
A *( ( ( 1 + i ) ^ n ) - 1 ) / ( ( 1 + i ) ^ n * i )
SERIE PERPETUA O PERENNE PT / i
CONCEPTO
12 TRIMESTRES i=0,098901 Ò 9.8901% g = $2.000 A=$120.000
TASA DE INTERES NOMINAL TRIMESTRE ANTICIPADO ( N.A. / TRIMESTRES )
TASA DE INTERES EFECTIVA VENCIDA TRIMESTRAL ( ia / ( 1 - ia ) )
NUMERO DE TRIMESTRES
VALOR PRESENTE
VP * ( ( 1 + i ) ^ n * i ) / ( ( 1 + i ) ^ n - 1 )
i N. T ( 1 + i ) ^ 4 = 1 + 0.33 i = ( 1.33 ) ^ 4 - 1
A * ( ( 1 + i ) ^ n - 1 ) /( ( 1 + i ) ^ n * i ) )
CONCEPTO
24 TRIMESTRES i=0,02360508 Ò 2,360508% g = -$50 A=$48,000
TASA DE INTERES NOMINAL TRIMESTRE ANTICIPADO ( N.A. / TRIMESTRES )
TASA DE INTERES EFECTIVA VENCIDA TRIMESTRAL ( ia / ( 1 - ia ) )
i N. M ( 1 + i ) ^ 3 = 1 + 0.0725 i = ( 1.0725 ) ^ ( 1 / 3 ) - 1
NUMERO DE MESES
VALOR PRESENTE
PRIMER PAGO
SEGUNDO PAGO
A*( (1+i)^n)-1 / i
g/i * ( (1+i)^n-1 / i )
SUMATORIA DE F ( A ) + F ( g )
CO
250,344.293558
0.01708333
18
16,000.0000000
254,621.0085727
= - $4.000
15
(4,000)
13.1341321682
-234,146.341463
13.1341322
11.634378632
-3,075,307.4957
253,532.434550
.954
250
.500 A1=$10.640
500
=$120.000
0.09
0.0989010989
12
15000000
2,189,613
0.0738976951
0.33
4
17,035,811
A=$48,000
0.0725
0.0781671159
0.0236050825
0.0725
3
12
15,000,000
48,000
24,000
PESOS 1,000,000 PESOS
n 15 AÑOS
TASA DE INTERES ( TEA ) 0.14 ANUAL
TASA DE INFLACION 0.10 ANUAL
VALOR DE LA UVR 120 PESOS
TRANSFORMACION TASA EFECTIVA A NOMINAL

SIMBOLOS EXCEL CONCEPTO
TEA 0.10 TASA DE INTERES EFECTIV
#ADDIN? (( (1 /1 n+ )i efectiva ) ^
R - 1 ) * 12
J #ADDIN? j= R/n
n 12 NUMERO DE PERIODOS
La unidad de valor real (UVR) es certificada por el Banco de la República y refleja el poder adquisitivo con base e
consumidor (IPC) durante el mes calendario inmediatamente anterior al mes del inicio del período de cálculo. La
calcular el costo de los créditos de vivienda que le permite a las entidades financieras mantener el poder adquisi
La metodología usada para calcular la UVR fue establecida por la Junta Directiva del Banco de la República dan
Corte Constitucional en la sentencia C-955/2000. Para más información sobre los antecedentes de la UVR consu
la metodología usada para calcular la UVR puede consultarse en la Resolución Externa 13 del 2000.
TABLA DE AMORTIZACION FRANCES CUOTAS E

P = $1.000.000 n=180 i=0,80% A=$1
VALOR DE
MESES INTERES
LA CUOTA
0
1 10,502.6727 8,000.0000
2 10,502.6727 7,979.9786
3 10,502.6727 7,959.7971
4 10,502.6727 7,939.4541
5 10,502.6727 7,918.9483
6 10,502.6727 7,898.2785
7 10,502.6727 7,877.4434
8 10,502.6727 7,856.4415
9 10,502.6727 7,835.2717
10 10,502.6727 7,813.9325
11 10,502.6727 7,792.4226
12 10,502.6727 7,770.7406
13 10,502.6727 7,748.8851
14 10,502.6727 7,726.8548
15 10,502.6727 7,704.6483
16 10,502.6727 7,682.2641
17 10,502.6727 7,659.7008
18 10,502.6727 7,636.9570
19 10,502.6727 7,614.0313
20 10,502.6727 7,590.9222
21 10,502.6727 7,567.6282
22 10,502.6727 7,544.1478
23 10,502.6727 7,520.4796
24 10,502.6727 7,496.6221
25 10,502.6727 7,472.5736
26 10,502.6727 7,448.3329
27 10,502.6727 7,423.8981
28 10,502.6727 7,399.2679
29 10,502.6727 7,374.4407
30 10,502.6727 7,349.4148
31 10,502.6727 7,324.1888
32 10,502.6727 7,298.7609
33 10,502.6727 7,273.1296
34 10,502.6727 7,247.2933
35 10,502.6727 7,221.2502
36 10,502.6727 7,194.9989
37 10,502.6727 7,168.5375
38 10,502.6727 7,141.8644
39 10,502.6727 7,114.9779
40 10,502.6727 7,087.8764
41 10,502.6727 7,060.5580
42 10,502.6727 7,033.0211
43 10,502.6727 7,005.2639
44 10,502.6727 6,977.2846
45 10,502.6727 6,949.0815
46 10,502.6727 6,920.6528
47 10,502.6727 6,891.9966
48 10,502.6727 6,863.1112
49 10,502.6727 6,833.9947
50 10,502.6727 6,804.6453
51 10,502.6727 6,775.0611
52 10,502.6727 6,745.2402
53 10,502.6727 6,715.1807
54 10,502.6727 6,684.8808
55 10,502.6727 6,654.3384
56 10,502.6727 6,623.5518
57 10,502.6727 6,592.5188
58 10,502.6727 6,561.2376
59 10,502.6727 6,529.7061
60 10,502.6727 6,497.9223
61 10,502.6727 6,465.8843
62 10,502.6727 6,433.5900
63 10,502.6727 6,401.0374
64 10,502.6727 6,368.2243
65 10,502.6727 6,335.1487
66 10,502.6727 6,301.8085
67 10,502.6727 6,268.2016
68 10,502.6727 6,234.3258
69 10,502.6727 6,200.1791
70 10,502.6727 6,165.7591
71 10,502.6727 6,131.0638
72 10,502.6727 6,096.0909
73 10,502.6727 6,060.8383
74 10,502.6727 6,025.3036
75 10,502.6727 5,989.4846
76 10,502.6727 5,953.3791
77 10,502.6727 5,916.9848
78 10,502.6727 5,880.2993
79 10,502.6727 5,843.3203
80 10,502.6727 5,806.0455
81 10,502.6727 5,768.4725
82 10,502.6727 5,730.5989
83 10,502.6727 5,692.4223
84 10,502.6727 5,653.9403
85 10,502.6727 5,615.1504
86 10,502.6727 5,576.0502
87 10,502.6727 5,536.6373
88 10,502.6727 5,496.9090
89 10,502.6727 5,456.8629
90 10,502.6727 5,416.4964
91 10,502.6727 5,375.8070
92 10,502.6727 5,334.7921
93 10,502.6727 5,293.4490
94 10,502.6727 5,251.7752
95 10,502.6727 5,209.7680
96 10,502.6727 5,167.4248
97 10,502.6727 5,124.7428
98 10,502.6727 5,081.7194
99 10,502.6727 5,038.3518
100 10,502.6727 4,994.6372
101 10,502.6727 4,950.5729
102 10,502.6727 4,906.1561
103 10,502.6727 4,861.3840
104 10,502.6727 4,816.2537
105 10,502.6727 4,770.7623
106 10,502.6727 4,724.9070
107 10,502.6727 4,678.6849
108 10,502.6727 4,632.0930
109 10,502.6727 4,585.1284
110 10,502.6727 4,537.7880
111 10,502.6727 4,490.0689
112 10,502.6727 4,441.9681
113 10,502.6727 4,393.4825
114 10,502.6727 4,344.6089
115 10,502.6727 4,295.3444
116 10,502.6727 4,245.6858
117 10,502.6727 4,195.6299
118 10,502.6727 4,145.1736
119 10,502.6727 4,094.3136
120 10,502.6727 4,043.0467
121 10,502.6727 3,991.3697
122 10,502.6727 3,939.2793
123 10,502.6727 3,886.7721
124 10,502.6727 3,833.8449
125 10,502.6727 3,780.4943
126 10,502.6727 3,726.7169
127 10,502.6727 3,672.5092
128 10,502.6727 3,617.8679
129 10,502.6727 3,562.7895
130 10,502.6727 3,507.2704
131 10,502.6727 3,451.3072
132 10,502.6727 3,394.8963
133 10,502.6727 3,338.0341
134 10,502.6727 3,280.7170
135 10,502.6727 3,222.9413
136 10,502.6727 3,164.7035
137 10,502.6727 3,105.9997
138 10,502.6727 3,046.8263
139 10,502.6727 2,987.1795
140 10,502.6727 2,927.0556
141 10,502.6727 2,866.4507
142 10,502.6727 2,805.3609
143 10,502.6727 2,743.7824
144 10,502.6727 2,681.7113
145 10,502.6727 2,619.1436
146 10,502.6727 2,556.0753
147 10,502.6727 2,492.5026
148 10,502.6727 2,428.4212
149 10,502.6727 2,363.8272
150 10,502.6727 2,298.7164
151 10,502.6727 2,233.0848
152 10,502.6727 2,166.9281
153 10,502.6727 2,100.2421
154 10,502.6727 2,033.0227
155 10,502.6727 1,965.2655
156 10,502.6727 1,896.9662
157 10,502.6727 1,828.1206
158 10,502.6727 1,758.7242
159 10,502.6727 1,688.7726
160 10,502.6727 1,618.2614
161 10,502.6727 1,547.1861
162 10,502.6727 1,475.5422
163 10,502.6727 1,403.3251
164 10,502.6727 1,330.5304
165 10,502.6727 1,257.1532
166 10,502.6727 1,183.1891
167 10,502.6727 1,108.6332
168 10,502.6727 1,033.4809
169 10,502.6727 957.7273
170 10,502.6727 881.3678
171 10,502.6727 804.3973
172 10,502.6727 726.8111
173 10,502.6727 648.6042
174 10,502.6727 569.7717
175 10,502.6727 490.3085
176 10,502.6727 410.2096
177 10,502.6727 329.4699
178 10,502.6727 248.0843
179 10,502.6727 166.0475
180 10,502.6727 83.3545
VA A NOMINAL
FUNCIONES ARITMETICAS 12,874.14
OMINAL 12,972.29
0.10 13,075.50
0.0957
0.0080 0.01106663 (98.15)

12 0.0110663508 (103.21)
a República y refleja el poder adquisitivo con base en la variación del índice de precios al
anterior al mes del inicio del período de cálculo. La UVR es una unidad de cuenta usada para
as entidades financieras mantener el poder adquisitivo del dinero prestado.
or la Junta Directiva del Banco de la República dando estricto cumplimiento a lo ordenado por la
nformación sobre los antecedentes de la UVR consulte Reportes del Emisor 41. Adicionalmente,
e en la Resolución Externa 13 del 2000.
IZACION FRANCES CUOTAS EN PESOS Fecha

n=180 i=0,80% A=$10.502,6727
SALDO TASA DE
CAPITAL VALOR UVR
FINAL INTERES
1,000,000 $ 120.00 1/16/2011
2,502.6727 997,497 $ 120.96 0.80000% 1/17/2011
2,522.6940 994,975 $ 121.93 0.80000% 1/18/2011
2,542.8756 992,432 $ 122.90 0.80000% 1/19/2011
2,563.2186 989,869 $ 123.89 0.80000% 1/20/2011
2,583.7244 987,285 $ 124.88 0.80000% 1/21/2011

2,604.3941 984,680 $ 125.88 0.80000% 1/22/2011
2,625.2293 982,055 $ 126.88 0.80000% 1/23/2011
2,646.2311 979,409 $ 127.90 0.80000% 1/24/2011
2,667.4010 976,742 $ 128.92 0.80000% 1/25/2011
2,688.7402 974,053 $ 129.95 0.80000% 1/26/2011
2,710.2501 971,343 $ 130.99 0.80000% 1/27/2011
2,731.9321 968,611 $ 132.04 0.80000% 1/28/2011
2,753.7876 965,857 $ 133.10 0.80000% 1/29/2011
2,775.8179 963,081 $ 134.16 0.80000% 1/30/2011
2,798.0244 960,283 $ 135.24 0.80000% 1/31/2011
2,820.4086 957,463 $ 136.32 0.80000% 2/1/2011
2,842.9719 954,620 $ 137.41 0.80000% 2/2/2011
2,865.7157 951,754 $ 138.51 0.80000% 2/3/2011
2,888.6414 948,865 $ 139.61 0.80000% 2/4/2011
2,911.7505 945,954 $ 140.73 0.80000% 2/5/2011
2,935.0445 943,018 $ 141.86 0.80000% 2/6/2011
2,958.5249 940,060 $ 142.99 0.80000% 2/7/2011
2,982.1931 937,078 $ 144.14 0.80000% 2/8/2011
3,006.0506 934,072 $ 145.29 0.80000% 2/9/2011
3,030.0990 931,042 $ 146.45 0.80000% 2/10/2011
3,054.3398 927,987 $ 147.62 0.80000% 2/11/2011
3,078.7745 924,908 $ 148.80 0.80000% 2/12/2011
3,103.4047 921,805 $ 149.99 0.80000% 2/13/2011
3,128.2320 918,677 $ 151.19 0.80000% 2/14/2011
3,153.2578 915,524 $ 152.40 0.80000% 2/15/2011
3,178.4839 912,345 $ 153.62 0.80000% http://www.banrep.go

3,203.9118 909,141 $ 154.85 0.80000%
3,229.5430 905,912 $ 156.09 0.80000%
3,255.3794 902,656 $ 157.34 0.80000%
3,281.4224 899,375 $ 158.60 0.80000%
3,307.6738 896,067 $ 159.87 0.80000%
3,334.1352 892,733 $ 161.15 0.80000%
3,360.8083 889,372 $ 162.44 0.80000%
3,387.6947 885,985 $ 163.74 0.80000%
3,414.7963 882,570 $ 165.05 0.80000%
3,442.1147 879,128 $ 166.37 0.80000%
3,469.6516 875,658 $ 167.70 0.80000%
3,497.4088 872,161 $ 169.04 0.80000%
3,525.3881 868,635 $ 170.39 0.80000%
3,553.5912 865,082 $ 171.75 0.80000%
3,582.0199 861,500 $ 173.13 0.80000%
3,610.6761 857,889 $ 174.51 0.80000%
3,639.5615 854,249 $ 175.91 0.80000%
3,668.6780 850,581 $ 177.32 0.80000%
3,698.0274 846,883 $ 178.73 0.80000%
3,727.6116 843,155 $ 180.16 0.80000%
3,757.4325 839,398 $ 181.61 0.80000%
3,787.4920 835,610 $ 183.06 0.80000%
3,817.7919 831,792 $ 184.52 0.80000%
3,848.3342 827,944 $ 186.00 0.80000%
3,879.1209 824,065 $ 187.49 0.80000%
3,910.1539 820,155 $ 188.99 0.80000%
3,941.4351 816,213 $ 190.50 0.80000%
3,972.9666 812,240 $ 192.02 0.80000%
4,004.7503 808,236 $ 193.56 0.80000%
4,036.7883 804,199 $ 195.11 0.80000%
4,069.0826 800,130 $ 196.67 0.80000%
4,101.6353 796,028 $ 198.24 0.80000%
4,134.4484 791,894 $ 199.83 0.80000%
4,167.5240 787,726 $ 201.43 0.80000%
4,200.8642 783,525 $ 203.04 0.80000%
4,234.4711 779,291 $ 204.66 0.80000%
4,268.3468 775,022 $ 206.30 0.80000%
4,302.4936 770,720 $ 207.95 0.80000%
4,336.9136 766,383 $ 209.61 0.80000%
4,371.6089 762,011 $ 211.29 0.80000%
4,406.5817 757,605 $ 212.98 0.80000%
4,441.8344 753,163 $ 214.68 0.80000%
4,477.3691 748,686 $ 216.40 0.80000%
4,513.1880 744,172 $ 218.13 0.80000%
4,549.2935 739,623 $ 219.88 0.80000%
4,585.6879 735,037 $ 221.64 0.80000%
4,622.3734 730,415 $ 223.41 0.80000%
4,659.3524 725,756 $ 225.20 0.80000%
4,696.6272 721,059 $ 227.00 0.80000%
4,734.2002 716,325 $ 228.81 0.80000%
4,772.0738 711,553 $ 230.65 0.80000%
4,810.2504 706,743 $ 232.49 0.80000%
4,848.7324 701,894 $ 234.35 0.80000%
4,887.5223 697,006 $ 236.23 0.80000%
4,926.6224 692,080 $ 238.12 0.80000%
4,966.0354 687,114 $ 240.02 0.80000%
5,005.7637 682,108 $ 241.94 0.80000%
5,045.8098 677,062 $ 243.88 0.80000%
5,086.1763 671,976 $ 245.83 0.80000%
5,126.8657 666,849 $ 247.79 0.80000%
5,167.8806 661,681 $ 249.78 0.80000%
5,209.2237 656,472 $ 251.77 0.80000%
5,250.8975 651,221 $ 253.79 0.80000%
5,292.9046 645,928 $ 255.82 0.80000%
5,335.2479 640,593 $ 257.86 0.80000%
5,377.9299 635,215 $ 259.93 0.80000%
5,420.9533 629,794 $ 262.01 0.80000%
5,464.3209 624,330 $ 264.10 0.80000%
5,508.0355 618,822 $ 266.22 0.80000%
5,552.0998 613,270 $ 268.35 0.80000%
5,596.5166 607,673 $ 270.49 0.80000%
5,641.2887 602,032 $ 272.66 0.80000%
5,686.4190 596,345 $ 274.84 0.80000%
5,731.9104 590,613 $ 277.04 0.80000%
5,777.7656 584,836 $ 279.25 0.80000%
5,823.9878 579,012 $ 281.49 0.80000%
5,870.5797 573,141 $ 283.74 0.80000%
5,917.5443 567,224 $ 286.01 0.80000%
5,964.8847 561,259 $ 288.30 0.80000%
6,012.6037 555,246 $ 290.60 0.80000%
6,060.7046 549,185 $ 292.93 0.80000%
6,109.1902 543,076 $ 295.27 0.80000%
6,158.0637 536,918 $ 297.63 0.80000%
6,207.3282 530,711 $ 300.01 0.80000%
6,256.9869 524,454 $ 302.41 0.80000%
6,307.0428 518,147 $ 304.83 0.80000%
6,357.4991 511,789 $ 307.27 0.80000%
6,408.3591 505,381 $ 309.73 0.80000%
6,459.6260 498,921 $ 312.21 0.80000%
6,511.3030 492,410 $ 314.71 0.80000%
6,563.3934 485,847 $ 317.22 0.80000%
6,615.9005 479,231 $ 319.76 0.80000%
6,668.8277 472,562 $ 322.32 0.80000%
6,722.1784 465,840 $ 324.90 0.80000%
6,775.9558 459,064 $ 327.50 0.80000%
6,830.1634 452,233 $ 330.12 0.80000%
6,884.8048 445,349 $ 332.76 0.80000%
6,939.8832 438,409 $ 335.42 0.80000%
6,995.4023 431,413 $ 338.10 0.80000%
7,051.3655 424,362 $ 340.81 0.80000%
7,107.7764 417,254 $ 343.54 0.80000%
7,164.6386 410,090 $ 346.28 0.80000%
7,221.9557 402,868 $ 349.05 0.80000%
7,279.7314 395,588 $ 351.85 0.80000%
7,337.9692 388,250 $ 354.66 0.80000%
7,396.6730 380,853 $ 357.50 0.80000%
7,455.8463 373,397 $ 360.36 0.80000%
7,515.4931 365,882 $ 363.24 0.80000%
7,575.6171 358,306 $ 366.15 0.80000%
7,636.2220 350,670 $ 369.08 0.80000%
7,697.3118 342,973 $ 372.03 0.80000%
7,758.8903 335,214 $ 375.01 0.80000%
7,820.9614 327,393 $ 378.01 0.80000%
7,883.5291 319,509 $ 381.03 0.80000%
7,946.5973 311,563 $ 384.08 0.80000%
8,010.1701 303,553 $ 387.15 0.80000%
8,074.2515 295,478 $ 390.25 0.80000%
8,138.8455 287,340 $ 393.37 0.80000%
8,203.9562 279,136 $ 396.52 0.80000%
8,269.5879 270,866 $ 399.69 0.80000%
8,335.7446 262,530 $ 402.89 0.80000%
8,402.4305 254,128 $ 406.11 0.80000%
8,469.6500 245,658 $ 409.36 0.80000%
8,537.4072 237,121 $ 412.63 0.80000%
8,605.7064 228,515 $ 415.93 0.80000%
8,674.5521 219,841 $ 419.26 0.80000%
8,743.9485 211,097 $ 422.62 0.80000%
8,813.9001 202,283 $ 426.00 0.80000%
8,884.4113 193,398 $ 429.40 0.80000%
8,955.4866 184,443 $ 432.84 0.80000%
9,027.1305 175,416 $ 436.30 0.80000%
9,099.3475 166,316 $ 439.79 0.80000%
9,172.1423 157,144 $ 443.31 0.80000%
9,245.5194 147,899 $ 446.86 0.80000%
9,319.4836 138,579 $ 450.43 0.80000%
9,394.0395 129,185 $ 454.04 0.80000%
9,469.1918 119,716 $ 457.67 0.80000%
9,544.9453 110,171 $ 461.33 0.80000%
9,621.3049 100,550 $ 465.02 0.80000%
9,698.2753 90,851 $ 468.74 0.80000%
9,775.8615 81,076 $ 472.49 0.80000%
9,854.0684 71,221 $ 476.27 0.80000%
9,932.9010 61,289 $ 480.08 0.80000%
10,012.3642 51,276 $ 483.92 0.80000%
10,092.4631 41,184 $ 487.79 0.80000%
10,173.2028 31,011 $ 491.69 0.80000%
10,254.5884 20,756 $ 495.63 0.80000%
10,336.6251 10,419 $ 499.59 0.80000%
10,419.3181 0 $ 503.59 0.80000%
0.00762
0.00796
Pesos
Variación anual
colombianos por
porcentual
UVR
191.0450 2.5937%
191.0850 2.6126%
191.1249 2.6313%
191.1648 2.6501%
191.2048 2.6689%
191.2448 2.6878%
191.2847 2.7066%
191.3247 2.7254%
191.3647 2.7442%
191.4047 2.7630%
191.4447 2.7819%
191.4847 2.8006%
191.5248 2.8195%
191.5648 2.8383%
191.6048 2.8572%
191.6449 2.8760%
191.6849 2.8949%
191.7250 2.9137%
191.7651 2.9326%
191.8052 2.9515%
191.8453 2.9704%
191.8854 2.9892%
191.9255 3.0081%
191.9656 3.0270%
192.0057 3.0458%
192.0458 3.0647%
192.0860 3.0836%
192.1261 3.1025%
192.1663 3.1213%
192.2065 3.1403%
192.2466 3.1591%
ttp://www.banrep.gov.co/series-estadisticas/see_upac.htm
U.V.R.
CALCULO DE LA UVR PERIODO 16 DE ENERO 2.011 AL 15 DE FEBRERO DE 2.0
d = DIAS
CALENDARIO ENTRE Exponente de la
FECHA t
EL 16/01/11 AL fòrmula ( t/d ) p
15/02/2011
d 31
Variaciòn IPC
mes de diciembre 0.0065
31/2010
UVR al 15 de
191.0051
Enero de 2.011
1/16/2011 1 0.0322580645
1/17/2011 2 0.064516129
1/18/2011 3 0.0967741935
1/19/2011 4 0.1290322581
1/20/2011 5 0.1612903226
1/21/2011 6 0.1935483871
1/22/2011 7 0.2258064516
1/23/2011 8 0.2580645161
1/24/2011 9 0.2903225806
1/25/2011 10 0.3225806452
1/26/2011 11 0.3548387097
1/27/2011 12 0.3870967742
1/28/2011 13 0.4193548387
1/29/2011 14 0.4516129032
1/30/2011 15 0.4838709677
DIA EN QUE SE
1/31/2011 16 0.5161290323
TOMO EL CREDITO
2/1/2011 17 0.5483870968
2/2/2011 18 0.5806451613
2/3/2011 19 0.6129032258
2/4/2011 20 0.6451612903
2/5/2011 21 0.6774193548
2/6/2011 22 0.7096774194
2/7/2011 23 0.7419354839
2/8/2011 24 0.7741935484
2/9/2011 25 0.8064516129
2/10/2011 26 0.8387096774
2/11/2011 27 0.8709677419
2/12/2011 28 0.9032258065
2/13/2011 29 0.935483871
2/14/2011 30 0.9677419355
DIA QUE SE TOMARA

2/15/2011 PARA CALCULAR LA 31 1.00000
PROXIMA TABLA
EJERCICIO CALCULO DEL VALOR DE CUOTAS IGUALES ( SERIE UNIFORME

Se divide el v/r del
po 8,333.3333 prèstamo en el v/r de
la UVR
PESOS 1,000,000 PESOS
n 15 AÑOS
TASA DE INTERES
0.14 ANUAL
( TEA )
TASA DE INFLACION 0.10 ANUAL
VALOR DE LA UVR 120 PESOS
TRANSFORMACION TASA EFECTIVA A NOMINAL

FUNCIONES
SIMBOLOS EXCEL CONCEPTO
ARITMETICAS
TEA 0.14 TASA DE INTERES EFECTIVA 0.14
( ( 1 + i efectiva )
R #ADDIN? ^ ( 1/ n ) - 1)* 0.13175
12
J #ADDIN? j= R/n 0.01098

n 12 NUMERO DE PERIODOS 12
TABLA DE AMORTIZACION FRANCES CUOTAS EN UVR

P = $1.000.000/$120= 8,333,33 n=180 i=1,098% A=$106,4
MESES SALDO INICIAL EN UVR INTERES AMORTIZACION
0
1 8,333.3333 91.5000 14.9037
2 8,318.4296 91.3364 15.0674
3 8,303.3622 91.1709 15.2328
4 8,288.1293 91.0037 15.4001
5 8,272.7293 90.8346 15.5692
6 8,257.1601 90.6636 15.7401
7 8,241.4200 90.4908 15.9130
8 8,225.5070 90.3161 16.0877
9 8,209.4193 90.1394 16.2643
10 8,193.1550 89.9608 16.4429
11 8,176.7121 89.7803 16.6234
12 8,160.0887 89.5978 16.8060
13 8,143.2827 89.4132 16.9905
14 8,126.2922 89.2267 17.1771
15 8,109.1151 89.0381 17.3657
16 8,091.7495 88.8474 17.5563
17 8,074.1932 88.6546 17.7491
18 8,056.4441 88.4598 17.9440
19 8,038.5001 88.2627 18.1410
20 8,020.3591 88.0635 18.3402
21 8,002.0189 87.8622 18.5416
22 7,983.4773 87.6586 18.7452
23 7,964.7321 87.4528 18.9510
24 7,945.7811 87.2447 19.1591
25 7,926.6221 87.0343 19.3694
26 7,907.2526 86.8216 19.5821
27 7,887.6705 86.6066 19.7971
28 7,867.8734 86.3892 20.0145
29 7,847.8589 86.1695 20.2343
30 7,827.6247 85.9473 20.4564
31 7,807.1682 85.7227 20.6810
32 7,786.4872 85.4956 20.9081
33 7,765.5791 85.2661 21.1377
34 7,744.4414 85.0340 21.3698
35 7,723.0716 84.7993 21.6044
36 7,701.4672 84.5621 21.8416
37 7,679.6256 84.3223 22.0815
38 7,657.5441 84.0798 22.3239
39 7,635.2202 83.8347 22.5690
40 7,612.6512 83.5869 22.8168
41 7,589.8343 83.3364 23.0674
42 7,566.7670 83.0831 23.3206
43 7,543.4463 82.8270 23.5767
44 7,519.8696 82.5682 23.8356
45 7,496.0341 82.3065 24.0973
46 7,471.9368 82.0419 24.3619
47 7,447.5749 81.7744 24.6294
48 7,422.9455 81.5039 24.8998
49 7,398.0457 81.2305 25.1732
50 7,372.8725 80.9541 25.4496
51 7,347.4229 80.6747 25.7290
52 7,321.6939 80.3922 26.0115
53 7,295.6823 80.1066 26.2972
54 7,269.3852 79.8178 26.5859
55 7,242.7993 79.5259 26.8778
56 7,215.9215 79.2308 27.1729
57 7,188.7486 78.9325 27.4713
58 7,161.2773 78.6308 27.7729
59 7,133.5044 78.3259 28.0779
60 7,105.4265 78.0176 28.3862
61 7,077.0403 77.7059 28.6978
62 7,048.3425 77.3908 29.0129
63 7,019.3296 77.0722 29.3315
64 6,989.9981 76.7502 29.6536
65 6,960.3445 76.4246 29.9792
66 6,930.3653 76.0954 30.3083
67 6,900.0570 75.7626 30.6411
68 6,869.4159 75.4262 30.9776
69 6,838.4383 75.0861 31.3177
70 6,807.1206 74.7422 31.6616
71 6,775.4591 74.3945 32.0092
72 6,743.4499 74.0431 32.3607
73 6,711.0892 73.6878 32.7160
74 6,678.3732 73.3285 33.0752
75 6,645.2980 72.9654 33.4384
76 6,611.8596 72.5982 33.8055
77 6,578.0541 72.2270 34.1767
78 6,543.8774 71.8518 34.5520
79 6,509.3254 71.4724 34.9313
80 6,474.3941 71.0888 35.3149
81 6,439.0792 70.7011 35.7027
82 6,403.3765 70.3091 36.0947
83 6,367.2819 69.9128 36.4910
84 6,330.7909 69.5121 36.8917
85 6,293.8992 69.1070 37.2967
86 6,256.6025 68.6975 37.7062
87 6,218.8963 68.2835 38.1203
88 6,180.7760 67.8649 38.5388
89 6,142.2372 67.4418 38.9620
90 6,103.2752 67.0140 39.3898
91 6,063.8854 66.5815 39.8223
92 6,024.0631 66.1442 40.2595
93 5,983.8036 65.7022 40.7016
94 5,943.1020 65.2553 41.1485
95 5,901.9535 64.8034 41.6003
96 5,860.3532 64.3467 42.0571
97 5,818.2962 63.8849 42.5189
98 5,775.7773 63.4180 42.9857
99 5,732.7916 62.9461 43.4577
100 5,689.3339 62.4689 43.9349
101 5,645.3991 61.9865 44.4173
102 5,600.9818 61.4988 44.9050
103 5,556.0769 61.0057 45.3980
104 5,510.6788 60.5073 45.8965
105 5,464.7823 60.0033 46.4004
106 5,418.3819 59.4938 46.9099
107 5,371.4720 58.9788 47.4250
108 5,324.0470 58.4580 47.9457
109 5,276.1013 57.9316 48.4722
110 5,227.6292 57.3994 49.0044
111 5,178.6248 56.8613 49.5424
112 5,129.0823 56.3173 50.0864
113 5,078.9959 55.7674 50.6364
114 5,028.3596 55.2114 51.1924
115 4,977.1672 54.6493 51.7544
116 4,925.4128 54.0810 52.3227
117 4,873.0900 53.5065 52.8972
118 4,820.1928 52.9257 53.4780
119 4,766.7148 52.3385 54.0652
120 4,712.6496 51.7449 54.6589
121 4,657.9907 51.1447 55.2590
122 4,602.7317 50.5380 55.8657
123 4,546.8660 49.9246 56.4792
124 4,490.3868 49.3044 57.0993
125 4,433.2875 48.6775 57.7262
126 4,375.5613 48.0437 58.3601
127 4,317.2012 47.4029 59.0009
128 4,258.2003 46.7550 59.6487
129 4,198.5516 46.1001 60.3036
130 4,138.2480 45.4380 60.9658
131 4,077.2822 44.7686 61.6352
132 4,015.6470 44.0918 62.3119
133 3,953.3351 43.4076 62.9961
134 3,890.3390 42.7159 63.6878
135 3,826.6511 42.0166 64.3871
136 3,762.2640 41.3097 65.0941
137 3,697.1699 40.5949 65.8088
138 3,631.3611 39.8723 66.5314
139 3,564.8297 39.1418 67.2619
140 3,497.5678 38.4033 68.0004
141 3,429.5674 37.6566 68.7471
142 3,360.8203 36.9018 69.5019
143 3,291.3183 36.1387 70.2651
144 3,221.0533 35.3672 71.0366
145 3,150.0167 34.5872 71.8166
146 3,078.2001 33.7986 72.6051
147 3,005.5950 33.0014 73.4023
148 2,932.1927 32.1955 74.2083
149 2,857.9844 31.3807 75.0231
150 2,782.9614 30.5569 75.8468
151 2,707.1145 29.7241 76.6796
152 2,630.4349 28.8822 77.5216
153 2,552.9134 28.0310 78.3728
154 2,474.5406 27.1705 79.2333
155 2,395.3073 26.3005 80.1033
156 2,315.2040 25.4209 80.9828
157 2,234.2212 24.5317 81.8720
158 2,152.3492 23.6328 82.7709
159 2,069.5783 22.7240 83.6798
160 1,985.8985 21.8052 84.5986
161 1,901.2999 20.8763 85.5275
162 1,815.7725 19.9372 86.4666
163 1,729.3059 18.9878 87.4160
164 1,641.8900 18.0280 88.3758
165 1,553.5142 17.0576 89.3462
166 1,464.1680 16.0766 90.3272
167 1,373.8408 15.0848 91.3190
168 1,282.5219 14.0821 92.3217
169 1,190.2002 13.0684 93.3353
170 1,096.8649 12.0436 94.3602
171 1,002.5047 11.0075 95.3962
172 907.1084 9.9601 96.4437
173 810.6648 8.9011 97.5026
174 713.1621 7.8305 98.5732
175 614.5889 6.7482 99.6556
176 514.9333 5.6540 100.7498
177 414.1836 4.5477 101.8560
178 312.3276 3.4294 102.9744
179 209.3532 2.2987 104.1050
180 105.2481 1.1556 105.2481
DE FEBRERO DE 2.011
Fòrmula para nueva

UVR
191.0450
191.0850
191.1249
191.1648
191.2048
191.2448
191.2847
191.3247
191.3647
191.4047
191.4447
191.4847
191.5248
191.5648
191.6048
191.6449
191.6849
191.7250
191.7651
191.8052
191.8453
191.8854
191.9255
191.9656
192.0057
192.0458
192.0860
192.1261
192.1663
192.2065 www.banrep.gov.co/series-estadisticas/see_upac.htm
192.2466
ALES ( SERIE UNIFORME ) EN UVR
S CUOTAS EN UVR
i=1,098% A=$106,4037
SALDO TASA DE
PAGO O CUOTA FINAL EN INTERES
UVR
8,333.3333
106.4037 8,318.4296 1.0980%
106.4037 8,303.3622 1.0980%
106.4037 8,288.1293 1.0980%
106.4037 8,272.7293 1.0980%
106.4037 8,257.1601 1.0980%
106.4037 8,241.4200 1.0980%
106.4037 8,225.5070 1.0980%
106.4037 8,209.4193 1.0980%
106.4037 8,193.1550 1.0980%
106.4037 8,176.7121 1.0980%
106.4037 8,160.0887 1.0980%
106.4037 8,143.2827 1.0980%
106.4037 8,126.2922 1.0980%
106.4037 8,109.1151 1.0980%
106.4037 8,091.7495 1.0980%
106.4037 8,074.1932 1.0980%
106.4037 8,056.4441 1.0980%
106.4037 8,038.5001 1.0980%
106.4037 8,020.3591 1.0980%
106.4037 8,002.0189 1.0980%
106.4037 7,983.4773 1.0980%
106.4037 7,964.7321 1.0980%
106.4037 7,945.7811 1.0980%
106.4037 7,926.6221 1.0980%
106.4037 7,907.2526 1.0980%
106.4037 7,887.6705 1.0980%
106.4037 7,867.8734 1.0980%
106.4037 7,847.8589 1.0980%
106.4037 7,827.6247 1.0980%
106.4037 7,807.1682 1.0980%
106.4037 7,786.4872 1.0980%
106.4037 7,765.5791 1.0980%
106.4037 7,744.4414 1.0980%
106.4037 7,723.0716 1.0980%
106.4037 7,701.4672 1.0980%
106.4037 7,679.6256 1.0980%
106.4037 7,657.5441 1.0980%
106.4037 7,635.2202 1.0980%
106.4037 7,612.6512 1.0980%
106.4037 7,589.8343 1.0980%
106.4037 7,566.7670 1.0980%
106.4037 7,543.4463 1.0980%
106.4037 7,519.8696 1.0980%
106.4037 7,496.0341 1.0980%
106.4037 7,471.9368 1.0980%
106.4037 7,447.5749 1.0980%
106.4037 7,422.9455 1.0980%
106.4037 7,398.0457 1.0980%
106.4037 7,372.8725 1.0980%
106.4037 7,347.4229 1.0980%
106.4037 7,321.6939 1.0980%
106.4037 7,295.6823 1.0980%
106.4037 7,269.3852 1.0980%
106.4037 7,242.7993 1.0980%
106.4037 7,215.9215 1.0980%
106.4037 7,188.7486 1.0980%
106.4037 7,161.2773 1.0980%
106.4037 7,133.5044 1.0980%
106.4037 7,105.4265 1.0980%
106.4037 7,077.0403 1.0980%
106.4037 7,048.3425 1.0980%
106.4037 7,019.3296 1.0980%
106.4037 6,989.9981 1.0980%
106.4037 6,960.3445 1.0980%
106.4037 6,930.3653 1.0980%
106.4037 6,900.0570 1.0980%
106.4037 6,869.4159 1.0980%
106.4037 6,838.4383 1.0980%
106.4037 6,807.1206 1.0980%
106.4037 6,775.4591 1.0980%
106.4037 6,743.4499 1.0980%
106.4037 6,711.0892 1.0980%
106.4037 6,678.3732 1.0980%
106.4037 6,645.2980 1.0980%
106.4037 6,611.8596 1.0980%
106.4037 6,578.0541 1.0980%
106.4037 6,543.8774 1.0980%
106.4037 6,509.3254 1.0980%
106.4037 6,474.3941 1.0980%
106.4037 6,439.0792 1.0980%
106.4037 6,403.3765 1.0980%
106.4037 6,367.2819 1.0980%
106.4037 6,330.7909 1.0980%
106.4037 6,293.8992 1.0980%
106.4037 6,256.6025 1.0980%
106.4037 6,218.8963 1.0980%
106.4037 6,180.7760 1.0980%
106.4037 6,142.2372 1.0980%
106.4037 6,103.2752 1.0980%
106.4037 6,063.8854 1.0980%
106.4037 6,024.0631 1.0980%
106.4037 5,983.8036 1.0980%
106.4037 5,943.1020 1.0980%
106.4037 5,901.9535 1.0980%
106.4037 5,860.3532 1.0980%
106.4037 5,818.2962 1.0980%
106.4037 5,775.7773 1.0980%
106.4037 5,732.7916 1.0980%
106.4037 5,689.3339 1.0980%
106.4037 5,645.3991 1.0980%
106.4037 5,600.9818 1.0980%
106.4037 5,556.0769 1.0980%
106.4037 5,510.6788 1.0980%
106.4037 5,464.7823 1.0980%
106.4037 5,418.3819 1.0980%
106.4037 5,371.4720 1.0980%
106.4037 5,324.0470 1.0980%
106.4037 5,276.1013 1.0980%
106.4037 5,227.6292 1.0980%
106.4037 5,178.6248 1.0980%
106.4037 5,129.0823 1.0980%
106.4037 5,078.9959 1.0980%
106.4037 5,028.3596 1.0980%
106.4037 4,977.1672 1.0980%
106.4037 4,925.4128 1.0980%
106.4037 4,873.0900 1.0980%
106.4037 4,820.1928 1.0980%
106.4037 4,766.7148 1.0980%
106.4037 4,712.6496 1.0980%
106.4037 4,657.9907 1.0980%
106.4037 4,602.7317 1.0980%
106.4037 4,546.8660 1.0980%
106.4037 4,490.3868 1.0980%
106.4037 4,433.2875 1.0980%
106.4037 4,375.5613 1.0980%
106.4037 4,317.2012 1.0980%
106.4037 4,258.2003 1.0980%
106.4037 4,198.5516 1.0980%
106.4037 4,138.2480 1.0980%
106.4037 4,077.2822 1.0980%
106.4037 4,015.6470 1.0980%
106.4037 3,953.3351 1.0980%
106.4037 3,890.3390 1.0980%
106.4037 3,826.6511 1.0980%
106.4037 3,762.2640 1.0980%
106.4037 3,697.1699 1.0980%
106.4037 3,631.3611 1.0980%
106.4037 3,564.8297 1.0980%
106.4037 3,497.5678 1.0980%
106.4037 3,429.5674 1.0980%
106.4037 3,360.8203 1.0980%
106.4037 3,291.3183 1.0980%
106.4037 3,221.0533 1.0980%
106.4037 3,150.0167 1.0980%
106.4037 3,078.2001 1.0980%
106.4037 3,005.5950 1.0980%
106.4037 2,932.1927 1.0980%
106.4037 2,857.9844 1.0980%
106.4037 2,782.9614 1.0980%
106.4037 2,707.1145 1.0980%
106.4037 2,630.4349 1.0980%
106.4037 2,552.9134 1.0980%
106.4037 2,474.5406 1.0980%
106.4037 2,395.3073 1.0980%
106.4037 2,315.2040 1.0980%
106.4037 2,234.2212 1.0980%
106.4037 2,152.3492 1.0980%
106.4037 2,069.5783 1.0980%
106.4037 1,985.8985 1.0980%
106.4037 1,901.2999 1.0980%
106.4037 1,815.7725 1.0980%
106.4037 1,729.3059 1.0980%
106.4037 1,641.8900 1.0980%
106.4037 1,553.5142 1.0980%
106.4037 1,464.1680 1.0980%
106.4037 1,373.8408 1.0980%
106.4037 1,282.5219 1.0980%
106.4037 1,190.2002 1.0980%
106.4037 1,096.8649 1.0980%
106.4037 1,002.5047 1.0980%
106.4037 907.1084 1.0980%
106.4037 810.6648 1.0980%
106.4037 713.1621 1.0980%
106.4037 614.5889 1.0980%
106.4037 514.9333 1.0980%
106.4037 414.1836 1.0980%
106.4037 312.3276 1.0980%
106.4037 209.3532 1.0980%
106.4037 105.2481 1.0980%
106.4037 0.0000 1.0980%
Valor del préstamo 84,000,000
Valor de la UVR el día en el cual se toma el crédito 191.6449
T EFECTIVA ANUAL de ajuste anual de la UVR ( inflación Colombia ) 3.000%
Tasa NOMINAL de ajuste mensual de la UVR ( inflación Colombia ) 0.2466%
TASA DE INTERES PARA CUOTAS EN UVR ( SOLO VIVIENDA ) 11.39%
Valor del crédito en UVR 438,310.6765
Valor de la cuota mensual en UVR $ 9,614.6497
TEA Tasa de interés anual en UVR 12.0000%
TNM Tasa de interés mensual en UVR 0.9489%
Plazo en años 5
84,207,166.6609
1,048,118.4299
83,159,048.2310
82,951,881.5701
UVR
Interés Saldo
Período Flujo de Caja
Abono Capital
en UVR en UVR en UVR
0 -438,310.6765 438,310.6765
1 9,614.6497 4,159.0393 5,455.6104 432,855.0661
2 9,614.6497 4,107.2721 5,507.3776 427,347.6885
3 9,614.6497 4,055.0137 5,559.6360 421,788.0525
4 9,614.6497 4,002.2595 5,612.3902 416,175.6623
5 9,614.6497 3,949.0047 5,665.6450 410,510.0173
6 9,614.6497 3,895.2446 5,719.4051 404,790.6121
7 9,614.6497 3,840.9743 5,773.6754 399,016.9367
8 9,614.6497 3,786.1891 5,828.4606 393,188.4761
9 9,614.6497 3,730.8840 5,883.7657 387,304.7105
10 9,614.6497 3,675.0542 5,939.5955 381,365.1150
11 9,614.6497 3,618.6946 5,995.9551 375,369.1599
12 9,614.6497 3,561.8002 6,052.8495 369,316.3104
13 9,614.6497 3,504.3660 6,110.2837 363,206.0267
14 9,614.6497 3,446.3868 6,168.2629 357,037.7638
15 9,614.6497 3,387.8574 6,226.7923 350,810.9715
16 9,614.6497 3,328.7727 6,285.8770 344,525.0945
17 9,614.6497 3,269.1273 6,345.5224 338,179.5721
18 9,614.6497 3,208.9159 6,405.7338 331,773.8383
19 9,614.6497 3,148.1333 6,466.5164 325,307.3219
20 9,614.6497 3,086.7738 6,527.8759 318,779.4460
21 9,614.6497 3,024.8322 6,589.8175 312,189.6284
22 9,614.6497 2,962.3027 6,652.3470 305,537.2815
23 9,614.6497 2,899.1800 6,715.4697 298,821.8118
24 9,614.6497 2,835.4583 6,779.1914 292,042.6204
25 9,614.6497 2,771.1320 6,843.5177 285,199.1026
26 9,614.6497 2,706.1952 6,908.4545 278,290.6482
27 9,614.6497 2,640.6423 6,974.0074 271,316.6408
28 9,614.6497 2,574.4674 7,040.1823 264,276.4585
29 9,614.6497 2,507.6646 7,106.9851 257,169.4734
30 9,614.6497 2,440.2279 7,174.4218 249,995.0516
31 9,614.6497 2,372.1513 7,242.4984 242,752.5532
32 9,614.6497 2,303.4287 7,311.2210 235,441.3322
33 9,614.6497 2,234.0540 7,380.5956 228,060.7366
34 9,614.6497 2,164.0211 7,450.6286 220,610.1080
35 9,614.6497 2,093.3236 7,521.3261 213,088.7819
36 9,614.6497 2,021.9553 7,592.6944 205,496.0876
37 9,614.6497 1,949.9098 7,664.7399 197,831.3477
38 9,614.6497 1,877.1807 7,737.4690 190,093.8787
39 9,614.6497 1,803.7615 7,810.8882 182,282.9904
40 9,614.6497 1,729.6456 7,885.0041 174,397.9863
41 9,614.6497 1,654.8264 7,959.8233 166,438.1630
42 9,614.6497 1,579.2973 8,035.3524 158,402.8105
43 9,614.6497 1,503.0515 8,111.5982 150,291.2123
44 9,614.6497 1,426.0822 8,188.5675 142,102.6448
45 9,614.6497 1,348.3826 8,266.2671 133,836.3777
46 9,614.6497 1,269.9457 8,344.7040 125,491.6737
47 9,614.6497 1,190.7645 8,423.8852 117,067.7885
48 9,614.6497 1,110.8320 8,503.8177 108,563.9708
49 9,614.6497 1,030.1410 8,584.5087 99,979.4621
50 9,614.6497 948.6844 8,665.9653 91,313.4968
51 9,614.6497 866.4549 8,748.1948 82,565.3020
52 9,614.6497 783.4451 8,831.2046 73,734.0974
53 9,614.6497 699.6476 8,915.0021 64,819.0953
54 9,614.6497 615.0550 8,999.5947 55,819.5005
55 9,614.6497 529.6597 9,084.9900 46,734.5105
56 9,614.6497 443.4541 9,171.1956 37,563.3149
57 9,614.6497 356.4305 9,258.2192 28,305.0957
58 9,614.6497 268.5812 9,346.0685 18,959.0272
59 9,614.6497 179.8983 9,434.7514 9,524.2758
60 9,614.6497 90.3739 9,524.2758 0
TOTALES 138,568.3053 438,310.6765 14,165,054.1818
Costo financiero o TIR 0.9489% mensual
Dinero cancelado por concepto de intereses en UVR 138,568.3053

Dinero cancelado por concepto de intereses en pesos 28,024,277.5703
Dinero cancelado por concepto de capital en UVR 438,310.6765
Dinero cancelado por concepto de capital en pesos 91,265,981.1637
Composición de la cuota del año 2 en UVR Pago por concepto de interés

Pago por concepto de capital
Pago total
Composición de la cuota del año 2 en pesos Pago por concepto de interés
Pago total
Notas adicionales :
El comportamiento del capital en UVR corresponde a una variación geométrica
La variación del capital en pesos corresponde a una variación geométrica

positiva equivalente a la tasa de interés en pesos del crédito.
La variación del flujo de caja en pesos corresponde a la inflación periódica

o tasa de ajuste de la UVR.
La razón por la cual el saldo en pesos no puede ser obtenido realizando la

diferencia que generalmente se desarrolla se debe a que el saldo siempre
debe estar expresado bajo el mismo valor de la UVR para que puedan ser
dichas cantidades equivalente. Así, el saldo para el período 25 en pesos
se calcularía de la siguiente forma :
Saldo en pesos en 25 = Saldo en 24 * ( 1+ tasa de ajuste de la UVR )
- Abono a capital en pesos en 25
58,128,566.0212
Generalizando, se puede decir que la expresión que permite calcular el
saldo en pesos para cualquier período es la siguiente :
Saldo en pesos período ( n ) = Saldo en pesos período ( n - 1 ) * ( 1 + tasa de ajuste de la UVR ) - Abono a capital
fx
CORRESPONDE AL 70% DE UN CREDITO DE $120 MILLONES
LA UVR SE CALCULA DEL 16 AL 15 DE CADA MES ESTE VALOR SE TOMO DEL DIA 31 DE ENERO 2011
#ADDIN? LA TASA EFECTIVA ANUAL SE TOMA DE LA TASA MENSUAL NOMINAL Y SE CALCULA POR FORMULA
2.96% ESTA TASA SE CALCULA DE LA VARIACION EN EL FLUJO DE CAJA EN PESOS DEL
PERIODO SIGUIENTE/PERIODO ANTERIOR - 1 EJE : ( 1.851.698,3504/1.847.142,7980 - 1 )
RESULTA DE DIVIDIR EL VALOR DEL PRESTAMO / EL VALOR DE LA UVR DEL DIA DEL PRESTAMO
Forma de pago del capital y del interés Cuotas constantes iguales mensuales en UVR
TASA EFECTIVA ANUAL PARA CUOTAS EN UVR APLICABLE SOLO PARA VIVIENDA
TASA NOMINLA MENSUAL PARA CUOTAS EN UVR APLICABLE SOLO PARA VIVIENDA
SE OBTIENE MULTIPLICANDO EL VALOR DEL CREDITO POR ( 1 + TASA DE AJUSTE MENSUAL )

VALOR ABONO A CAPITAL EN PESOS PERIODO 1
ME MUESTRA LA DIFERENCIA ENTRE EL VALOR PROYECTADO MENOS EL ABONO A CAPITAL EN PESOS
CORRESPONDE AL SALDO EN PESOS MENOS EL ABONO A CAPITAL EN PESOS
PESOS
Variación Proyección Flujo de Caja Interés Abono Capital Saldo

Geomètrica
del Capital
en UVR del valor de en pesos en pesos en pesos en pesos
la UVR
191.6449 -84,000,000.0000 84,000,000.0000
192.1175 1,847,142.7980 799,024.3681 1,048,118.4299 83,159,048.2310
0.9489% 192.5913 1,851,698.3504 791,025.0710 1,060,673.2795 82,303,467.5985
0.9489% 193.0663 1,856,265.1381 782,886.6213 1,073,378.5168 81,433,071.6359
0.9489% 193.5425 1,860,843.1887 774,607.2453 1,086,235.9434 80,547,671.6156
0.9489% 194.0198 1,865,432.5300 766,185.1477 1,099,247.3822 79,647,076.5210
0.9489% 194.4983 1,870,033.1899 757,618.5117 1,112,414.6781 78,731,093.0202
0.9489% 194.9780 1,874,645.1962 748,905.4982 1,125,739.6980 77,799,525.4370
0.9489% 195.4589 1,879,268.5770 740,044.2458 1,139,224.3312 76,852,175.7238
0.9489% 195.9409 1,883,903.3602 731,032.8707 1,152,870.4895 75,888,843.4322
0.9489% 196.4242 1,888,549.5742 721,869.4663 1,166,680.1079 74,909,325.6849
0.9489% 196.9086 1,893,207.2469 712,552.1026 1,180,655.1443 73,913,417.1462
0.9489% 197.3942 1,897,876.4067 703,078.8265 1,194,797.5802 72,900,909.9925
0.9489% 197.8811 1,902,557.0819 693,447.6612 1,209,109.4207 71,871,593.8824
0.9489% 198.3691 1,907,249.3009 683,656.6057 1,223,592.6952 70,825,255.9267
0.9489% 198.8583 1,911,953.0922 673,703.6352 1,238,249.4570 69,761,680.6575
0.9489% 199.3488 1,916,668.4843 663,586.7000 1,253,081.7843 68,680,649.9975
0.9489% 199.8404 1,921,395.5059 653,303.7257 1,268,091.7802 67,581,943.2283
0.9489% 200.3333 1,926,134.1855 642,852.6129 1,283,281.5727 66,465,336.9594
0.9489% 200.8273 1,930,884.5521 632,231.2364 1,298,653.3156 65,330,605.0952
0.9489% 201.3226 1,935,646.6343 621,437.4458 1,314,209.1884 64,177,518.8033
0.9489% 201.8192 1,940,420.4611 610,469.0643 1,329,951.3967 63,005,846.4813
0.9489% 202.3169 1,945,206.0614 599,323.8889 1,345,882.1725 61,815,353.7235
0.9489% 202.8159 1,950,003.4643 587,999.6898 1,362,003.7745 60,605,803.2874
0.9489% 203.3161 1,954,812.6989 576,494.2104 1,378,318.4885 59,376,955.0595
0.9489% 203.8175 1,959,633.7944 564,805.1666 1,394,828.6278 58,128,566.0212
0.9489% 204.3202 1,964,466.7800 552,930.2468 1,411,536.5332 56,860,390.2133
0.9489% 204.8241 1,969,311.6850 540,867.1114 1,428,444.5736 55,572,178.7014
0.9489% 205.3292 1,974,168.5389 528,613.3925 1,445,555.1464 54,263,679.5395
0.9489% 205.8356 1,979,037.3711 516,166.6935 1,462,870.6776 52,934,637.7345
0.9489% 206.3433 1,983,918.2111 503,524.5889 1,480,393.6223 51,584,795.2092
0.9489% 206.8522 1,988,811.0886 490,684.6237 1,498,126.4649 50,213,890.7654
0.9489% 207.3623 1,993,716.0333 477,644.3135 1,516,071.7198 48,821,660.0466
0.9489% 207.8737 1,998,633.0749 464,401.1436 1,534,231.9312 47,407,835.4997
0.9489% 208.3864 2,003,562.2432 450,952.5691 1,552,609.6742 45,972,146.3372
0.9489% 208.9003 2,008,503.5682 437,296.0140 1,571,207.5542 44,514,318.4979
0.9489% 209.4155 2,013,457.0799 423,428.8715 1,590,028.2083 43,034,074.6077
0.9489% 209.9320 2,018,422.8082 409,348.5032 1,609,074.3050 41,531,133.9401
0.9489% 210.4498 2,023,400.7834 395,052.2387 1,628,348.5447 40,005,212.3757
0.9489% 210.9688 2,028,391.0355 380,537.3754 1,647,853.6601 38,456,022.3616
0.9489% 211.4891 2,033,393.5950 365,801.1782 1,667,592.4169 36,883,272.8702
0.9489% 212.0107 2,038,408.4922 350,840.8785 1,687,567.6137 35,286,669.3575
0.9489% 212.5336 2,043,435.7574 335,653.6748 1,707,782.0826 33,665,913.7209
0.9489% 213.0577 2,048,475.4213 320,236.7314 1,728,238.6899 32,020,704.2564
0.9489% 213.5832 2,053,527.5143 304,587.1784 1,748,940.3359 30,350,735.6154
0.9489% 214.1099 2,058,592.0671 288,702.1113 1,769,889.9559 28,655,698.7614
0.9489% 214.6380 2,063,669.1105 272,578.5904 1,791,090.5201 26,935,280.9249
0.9489% 215.1673 2,068,758.6753 256,213.6407 1,812,545.0346 25,189,165.5595
0.9489% 215.6980 2,073,860.7923 239,604.2511 1,834,256.5411 23,417,032.2960
0.9489% 216.2300 2,078,975.4924 222,747.3742 1,856,228.1182 21,618,556.8966
0.9489% 216.7633 2,084,102.8069 205,639.9257 1,878,462.8811 19,793,411.2089
0.9489% 217.2979 2,089,242.7666 188,278.7843 1,900,963.9823 17,941,263.1184
0.9489% 217.8338 2,094,395.4029 170,660.7908 1,923,734.6121 16,061,776.5012
0.9489% 218.3710 2,099,560.7470 152,782.7478 1,946,777.9991 14,154,611.1759
0.9489% 218.9096 2,104,738.8302 134,641.4196 1,970,097.4105 12,219,422.8551
0.9489% 219.4495 2,109,929.6839 116,233.5312 1,993,696.1527 10,255,863.0956
0.9489% 219.9907 2,115,133.3397 97,555.7682 2,017,577.5715 8,263,579.2492
0.9489% 220.5332 2,120,349.8291 78,604.7760 2,041,745.0531 6,242,214.4118
0.9489% 221.0771 2,125,579.1838 59,377.1598 2,066,202.0240 4,191,407.3725
0.9489% 221.6224 2,130,821.4355 39,869.4837 2,090,951.9519 2,110,792.5620
0.9489% 222.1689 2,136,076.6160 20,078.2702 2,115,998.3459 0
28,024,277.5703 91,265,981.1637
1.1978%
cepto de interés 2,835.4583
ncepto de capital 6,779.1914
9,614.6497
cepto de interés 576,494.2104
ncepto de capital 1,378,318.4885
1,954,812.6989
e de la UVR ) - Abono a capital en pesos período ( n )

A 31 DE ENERO 2011
CULA POR FORMULA
DEL PRESTAMO
E MENSUAL )
O A CAPITAL EN PESOS
PESOS
Porcentaje de Variación Variación

Mayor valor al variacion
Valor real saldo
saldo insoluto ( Mayor valor
insoluto de deuda
de deuda al saldo en
pesos ) del FC del capital
en pesos en pesos
82,951,881.5701 207,166.6609 0.2497%

82,098,374.9515 205,092.6469 0.2498% 0.2466% 1.1978%
81,230,089.0816 202,982.5543 0.2499% 0.2466% 1.1978%
80,346,835.6925 200,835.9230 0.2500% 0.2466% 1.1978%
79,448,424.2333 198,652.2877 0.2500% 0.2466% 1.1978%
78,534,661.8429 196,431.1773 0.2501% 0.2466% 1.1978%
77,605,353.3222 194,172.1149 0.2502% 0.2466% 1.1978%
76,660,301.1059 191,874.6179 0.2503% 0.2466% 1.1978%
75,699,305.2343 189,538.1979 0.2504% 0.2466% 1.1978%
74,722,163.3243 187,162.3606 0.2505% 0.2466% 1.1978%
73,728,670.5406 184,746.6056 0.2506% 0.2466% 1.1978%
72,718,619.5660 182,290.4265 0.2507% 0.2466% 1.1978%
71,691,800.5717 179,793.3107 0.2508% 0.2466% 1.1978%
70,648,001.1872 177,254.7395 0.2509% 0.2466% 1.1978%
69,587,006.4697 174,674.1878 0.2510% 0.2466% 1.1978%
68,508,598.8732 172,051.1243 0.2511% 0.2466% 1.1978%
67,412,558.2173 169,385.0110 0.2513% 0.2466% 1.1978%
66,298,661.6556 166,675.3037 0.2514% 0.2466% 1.1978%
65,166,683.6438 163,921.4514 0.2515% 0.2466% 1.1978%
64,016,395.9068 161,122.8966 0.2517% 0.2466% 1.1978%
62,847,567.4066 158,279.0747 0.2518% 0.2466% 1.1978%
61,659,964.3088 155,389.4147 0.2520% 0.2466% 1.1978%
60,453,349.9490 152,453.3384 0.2522% 0.2466% 1.1978%
59,227,484.7989 149,470.2607 0.2524% 0.2466% 1.1978%
57,982,126.4318 146,439.5894 0.2526% 0.2466% 1.1978%
56,717,029.4880 143,360.7253 0.2528% 0.2466% 1.1978%
55,431,945.6397 140,233.0616 0.2530% 0.2466% 1.1978%
54,126,623.5550 137,055.9845 0.2532% 0.2466% 1.1978%
52,800,808.8619 133,828.8726 0.2535% 0.2466% 1.1978%
51,454,244.1122 130,551.0970 0.2537% 0.2466% 1.1978%
50,086,668.7443 127,222.0211 0.2540% 0.2466% 1.1978%
48,697,819.0456 123,841.0009 0.2543% 0.2466% 1.1978%
47,287,428.1153 120,407.3844 0.2546% 0.2466% 1.1978%
45,855,225.8256 116,920.5117 0.2550% 0.2466% 1.1978%
44,400,938.7830 113,379.7149 0.2554% 0.2466% 1.1978%
42,924,290.2895 109,784.3181 0.2558% 0.2466% 1.1978%
41,425,000.3027 106,133.6374 0.2562% 0.2466% 1.1978%
39,902,785.3954 102,426.9802 0.2567% 0.2466% 1.1978%
38,357,358.7156 98,663.6460 0.2572% 0.2466% 1.1978%
36,788,429.9447 94,842.9255 0.2578% 0.2466% 1.1978%
35,195,705.2565 90,964.1010 0.2585% 0.2466% 1.1978%
33,578,887.2749 87,026.4460 0.2592% 0.2466% 1.1978%
31,937,675.0310 83,029.2254 0.2600% 0.2466% 1.1978%
30,271,763.9204 78,971.6950 0.2609% 0.2466% 1.1978%
28,580,845.6595 74,853.1018 0.2619% 0.2466% 1.1978%
26,864,608.2412 70,672.6837 0.2631% 0.2466% 1.1978%
25,122,735.8903 66,429.6692 0.2644% 0.2466% 1.1978%
23,354,909.0183 62,123.2776 0.2660% 0.2466% 1.1978%
21,560,804.1777 57,752.7189 0.2679% 0.2466% 1.1978%
19,740,094.0155 53,317.1934 0.2701% 0.2466% 1.1978%
17,892,447.2266 48,815.8918 0.2728% 0.2466% 1.1978%
16,017,528.5063 44,247.9949 0.2762% 0.2466% 1.1978%
14,114,998.5020 39,612.6739 0.2806% 0.2466% 1.1978%
12,184,513.7654 34,909.0897 0.2865% 0.2466% 1.1978%
10,225,726.7024 30,136.3932 0.2947% 0.2466% 1.1978%
8,238,285.5241 25,293.7251 0.3070% 0.2466% 1.1978%
6,221,834.1961 20,380.2157 0.3276% 0.2466% 1.1978%
4,176,012.3878 15,394.9847 0.3687% 0.2466% 1.1978%
2,100,455.4207 10,337.1413 0.4921% 0.2466% 1.1978%
(5,205.7839) 5,205.7839 -100.0000% 0.2466% 1.1978%
2,854,876,101.6371 7,265,981 0%
Valor de la UVR el día en el cual se toma el crédito 120
T EFECTIVA ANUAL de ajuste anual de la UVR
( inflación Colombia ) 7.971%
Tasa NOMINAL de ajuste mensual de la UVR ( inflación
Colombia ) 0.641%
Valor del crédito en UVR 8,333
Valor de la cuota mensual en UVR Cuotas constantes iguales mensuales en UVR
TEA Tasa de interés anual en UVR 10.00%
TNM Tasa de interés mensual en UVR 0.7974%
Plazo en años 5
UVR
Período Flujo de Caja Interés Abono Capital Saldo Variación
en UVR en UVR en UVR en UVR del capital
en UVR
0 -8,333 8,333
1 108.14622 66.4512 41.6950 8,291.6383
2 108.14622 66.1187 42.0275 8,249.6108 0.7974%
3 108.14622 65.7836 42.3627 8,207.2481 0.7974%
4 108.14622 65.4457 42.7005 8,164.5476 0.7974%
5 108.14622 65.1052 43.0410 8,121.5066 0.7974%
6 108.14622 64.7620 43.3842 8,078.1225 0.7974%
7 108.14622 64.4161 43.7301 8,034.3923 0.7974%
8 108.14622 64.0674 44.0788 7,990.3135 0.7974%
9 108.14622 63.7159 44.4303 7,945.8831 0.7974%
10 108.14622 63.3616 44.7846 7,901.0985 0.7974%
11 108.14622 63.0045 45.1418 7,855.9568 0.7974%
12 108.14622 62.6445 45.5017 7,810.4550 0.7974%
13 108.14622 62.2817 45.8646 7,764.5905 0.7974%
14 108.14622 61.9159 46.2303 7,718.3602 0.7974%
15 108.14622 61.5473 46.5989 7,671.7613 0.7974%
16 108.14622 61.1757 46.9705 7,624.7908 0.7974%
17 108.14622 60.8012 47.3451 7,577.4457 0.7974%
18 108.14622 60.4236 47.7226 7,529.7231 0.7974%
19 108.14622 60.0431 48.1032 7,481.6199 0.7974%
20 108.14622 59.6595 48.4867 7,433.1332 0.7974%
21 108.14622 59.2728 48.8734 7,384.2598 0.7974%
22 108.14622 58.8831 49.2631 7,334.9967 0.7974%
23 108.14622 58.4903 49.6559 7,285.3408 0.7974%
24 108.14622 58.0943 50.0519 7,235.2889 0.7974%
25 108.14622 57.6952 50.4510 7,184.8379 0.7974%
26 108.14622 57.2929 50.8533 7,133.9846 0.7974%
27 108.14622 56.8874 51.2588 7,082.7258 0.7974%
28 108.14622 56.4786 51.6676 7,031.0582 0.7974%
29 108.14622 56.0666 52.0796 6,978.9786 0.7974%
30 108.14622 55.6514 52.4949 6,926.4838 0.7974%
31 108.14622 55.2328 52.9135 6,873.5703 0.7974%
32 108.14622 54.8108 53.3354 6,820.2349 0.7974%
33 108.14622 54.3855 53.7607 6,766.4742 0.7974%
34 108.14622 53.9568 54.1894 6,712.2848 0.7974%
35 108.14622 53.5247 54.6215 6,657.6633 0.7974%
36 108.14622 53.0891 55.0571 6,602.6062 0.7974%
37 108.14622 52.6501 55.4961 6,547.1101 0.7974%
38 108.14622 52.2076 55.9386 6,491.1714 0.7974%
39 108.14622 51.7615 56.3847 6,434.7867 0.7974%
40 108.14622 51.3119 56.8343 6,377.9524 0.7974%
41 108.14622 50.8587 57.2875 6,320.6649 0.7974%
42 108.14622 50.4019 57.7444 6,262.9205 0.7974%
43 108.14622 49.9414 58.2048 6,204.7157 0.7974%
44 108.14622 49.4773 58.6689 6,146.0468 0.7974%
45 108.14622 49.0094 59.1368 6,086.9100 0.7974%
46 108.14622 48.5379 59.6083 6,027.3016 0.7974%
47 108.14622 48.0625 60.0837 5,967.2180 0.7974%
48 108.14622 47.5834 60.5628 5,906.6552 0.7974%
49 108.14622 47.1005 61.0457 5,845.6095 0.7974%
50 108.14622 46.6137 61.5325 5,784.0770 0.7974%
51 108.14622 46.1230 62.0232 5,722.0538 0.7974%
52 108.14622 45.6285 62.5178 5,659.5360 0.7974%
53 108.14622 45.1299 63.0163 5,596.5197 0.7974%
54 108.14622 44.6274 63.5188 5,533.0009 0.7974%
55 108.14622 44.1209 64.0253 5,468.9757 0.7974%
56 108.14622 43.6104 64.5358 5,404.4398 0.7974%
57 108.14622 43.0958 65.0505 5,339.3894 0.7974%
58 108.14622 42.5770 65.5692 5,273.8202 0.7974%
59 108.14622 42.0542 66.0920 5,207.7281 0.7974%
60 108.14622 41.5272 66.6191 5,141.1091 0.7974%
61 108.14622 40.9959 67.1503 5,073.9588 0.7974%
62 108.14622 40.4605 67.6858 5,006.2730 0.7974%
63 108.14622 39.9207 68.2255 4,938.0475 0.7974%
64 108.14622 39.3767 68.7695 4,869.2780 0.7974%
65 108.14622 38.8283 69.3179 4,799.9601 0.7974%
66 108.14622 38.2756 69.8707 4,730.0894 0.7974%
67 108.14622 37.7184 70.4278 4,659.6616 0.7974%
68 108.14622 37.1568 70.9894 4,588.6722 0.7974%
69 108.14622 36.5907 71.5555 4,517.1167 0.7974%
70 108.14622 36.0201 72.1261 4,444.9906 0.7974%
71 108.14622 35.4450 72.7012 4,372.2893 0.7974%
72 108.14622 34.8652 73.2810 4,299.0084 0.7974%
73 108.14622 34.2809 73.8653 4,225.1430 0.7974%
74 108.14622 33.6919 74.4543 4,150.6887 0.7974%
75 108.14622 33.0982 75.0480 4,075.6407 0.7974%
76 108.14622 32.4997 75.6465 3,999.9942 0.7974%
77 108.14622 31.8965 76.2497 3,923.7445 0.7974%
78 108.14622 31.2885 76.8577 3,846.8867 0.7974%
79 108.14622 30.6756 77.4706 3,769.4161 0.7974%
80 108.14622 30.0579 78.0884 3,691.3278 0.7974%
81 108.14622 29.4352 78.7111 3,612.6167 0.7974%
82 108.14622 28.8075 79.3387 3,533.2780 0.7974%
83 108.14622 28.1749 79.9714 3,453.3066 0.7974%
84 108.14622 27.5372 80.6091 3,372.6976 0.7974%
85 108.14622 26.8944 81.2519 3,291.4457 0.7974%
86 108.14622 26.2465 81.8998 3,209.5460 0.7974%
87 108.14622 25.5934 82.5528 3,126.9931 0.7974%
88 108.14622 24.9351 83.2111 3,043.7820 0.7974%
89 108.14622 24.2715 83.8747 2,959.9073 0.7974%
90 108.14622 23.6027 84.5435 2,875.3638 0.7974%
91 108.14622 22.9286 85.2177 2,790.1461 0.7974%
92 108.14622 22.2490 85.8972 2,704.2489 0.7974%
93 108.14622 21.5641 86.5822 2,617.6668 0.7974%
94 108.14622 20.8736 87.2726 2,530.3942 0.7974%
95 108.14622 20.1777 87.9685 2,442.4257 0.7974%
96 108.14622 19.4762 88.6700 2,353.7557 0.7974%
97 108.14622 18.7692 89.3770 2,264.3787 0.7974%
98 108.14622 18.0565 90.0897 2,174.2889 0.7974%
99 108.14622 17.3381 90.8081 2,083.4808 0.7974%
100 108.14622 16.6140 91.5323 1,991.9485 0.7974%
101 108.14622 15.8841 92.2621 1,899.6864 0.7974%
102 108.14622 15.1484 92.9979 1,806.6885 0.7974%
103 108.14622 14.4068 93.7394 1,712.9491 0.7974%
104 108.14622 13.6593 94.4869 1,618.4622 0.7974%
105 108.14622 12.9058 95.2404 1,523.2218 0.7974%
106 108.14622 12.1464 95.9998 1,427.2220 0.7974%
107 108.14622 11.3809 96.7654 1,330.4566 0.7974%
108 108.14622 10.6092 97.5370 1,232.9197 0.7974%
109 108.14622 9.8315 98.3147 1,134.6049 0.7974%
110 108.14622 9.0475 99.0987 1,035.5062 0.7974%
111 108.14622 8.2573 99.8889 935.6172 0.7974%
112 108.14622 7.4607 100.6855 834.9318 0.7974%
113 108.14622 6.6579 101.4884 733.4434 0.7974%
114 108.14622 5.8486 102.2976 631.1458 0.7974%
115 108.14622 5.0328 103.1134 528.0324 0.7974%
116 108.14622 4.2106 103.9356 424.0968 0.7974%
117 108.14622 3.3818 104.7644 319.3324 0.7974%
118 108.14622 2.5464 105.5998 213.7326 0.7974%
119 108.14622 1.7043 106.4419 107.2907 0.7974%
120 108.14622 0.8556 107.2907 0.0000 0.7974%
-0.7866% mensual
Dinero cancelado por concepto de intereses en UVR 3,297

Dinero cancelado por concepto de intereses en pesos 476,561
Dinero cancelado por concepto de capital en UVR 3,192
Dinero cancelado por concepto de capital en pesos 475,469

Pago total
Pago total
Notas adicionales : El comportamiento del capital en UVR corresponde a una variación

geométrica creciente equivalente a la tasa de interés en UVR.



1,011,541.89
Saldo en pesos período ( n ) = Saldo en pesos período ( n - 1 ) * ( 1 + tasa de

ajuste de la UVR ) - Abono a capital en pesos período ( n )
Costo financiero o TIR

s iguales mensuales en UVR
1,006,411
5,035 1,001,376
PESOS
Proyección Flujo de Caja Interés Abono Capital Saldo Variación Variación
del valor de en pesos en pesos en pesos en pesos del FC del capital
la UVR en pesos en pesos
120.0000 -1,000,000 1,000,000

120.7693 13,060.7469 8,025.2636 5,035.4833 1,001,375.6351
121.5436 13,144.4809 8,036.3034 5,108.1775 1,002,687.3954 0.6411% 1.4436%
122.3228 13,228.7517 8,046.8306 5,181.9211 1,003,933.8220 0.6411% 1.4436%
123.1071 13,313.5628 8,056.8335 5,256.7293 1,005,113.4313 0.6411% 1.4436%
123.8963 13,398.9177 8,066.3002 5,332.6174 1,006,224.7152 0.6411% 1.4436%
124.6906 13,484.8197 8,075.2186 5,409.6011 1,007,266.1399 0.6411% 1.4436%
125.4900 13,571.2725 8,083.5763 5,487.6962 1,008,236.1462 0.6411% 1.4436%
126.2946 13,658.2795 8,091.3608 5,566.9187 1,009,133.1488 0.6411% 1.4436%
127.1043 13,745.8444 8,098.5595 5,647.2849 1,009,955.5361 0.6411% 1.4436%
127.9191 13,833.9706 8,105.1594 5,728.8112 1,010,701.6695 0.6411% 1.4436%
128.7392 13,922.6618 8,111.1473 5,811.5145 1,011,369.8831 0.6411% 1.4436%
129.5646 14,011.9217 8,116.5099 5,895.4118 1,011,958.4834 0.6411% 1.4436%
130.3953 14,101.7537 8,121.2336 5,980.5202 1,012,465.7489 0.6411% 1.4436%
131.2312 14,192.1618 8,125.3045 6,066.8573 1,012,889.9295 0.6411% 1.4436%
132.0726 14,283.1494 8,128.7087 6,154.4407 1,013,229.2461 0.6411% 1.4436%
132.9193 14,374.7204 8,131.4318 6,243.2886 1,013,481.8902 0.6411% 1.4436%
133.7715 14,466.8784 8,133.4593 6,333.4191 1,013,646.0236 0.6411% 1.4436%
134.6291 14,559.6273 8,134.7765 6,424.8507 1,013,719.7776 0.6411% 1.4436%
135.4922 14,652.9708 8,135.3684 6,517.6023 1,013,701.2528 0.6411% 1.4436%
136.3609 14,746.9127 8,135.2198 6,611.6929 1,013,588.5186 0.6411% 1.4436%
137.2351 14,841.4569 8,134.3150 6,707.1419 1,013,379.6128 0.6411% 1.4436%
138.1149 14,936.6072 8,132.6385 6,803.9687 1,013,072.5408 0.6411% 1.4436%
139.0004 15,032.3676 8,130.1742 6,902.1934 1,012,665.2755 0.6411% 1.4436%
139.8915 15,128.7419 8,126.9058 7,001.8361 1,012,155.7564 0.6411% 1.4436%
140.7884 15,225.7340 8,122.8167 7,102.9173 1,011,541.8895 0.6411% 1.4436%
141.6910 15,323.3480 8,117.8903 7,205.4577 1,010,821.5467 0.6411% 1.4436%
142.5994 15,421.5878 8,112.1094 7,309.4785 1,009,992.5649 0.6411% 1.4436%
143.5136 15,520.4574 8,105.4566 7,415.0009 1,009,052.7459 0.6411% 1.4436%
144.4337 15,619.9609 8,097.9143 7,522.0467 1,007,999.8559 0.6411% 1.4436%
145.3597 15,720.1024 8,089.4645 7,630.6378 1,006,831.6246 0.6411% 1.4436%
146.2916 15,820.8858 8,080.0892 7,740.7966 1,005,545.7448 0.6411% 1.4436%
147.2295 15,922.3154 8,069.7697 7,852.5457 1,004,139.8719 0.6411% 1.4436%
148.1734 16,024.3952 8,058.4872 7,965.9081 1,002,611.6235 0.6411% 1.4436%
149.1234 16,127.1295 8,046.2226 8,080.9070 1,000,958.5784 0.6411% 1.4436%
150.0794 16,230.5224 8,032.9564 8,197.5660 999,178.2764 0.6411% 1.4436%
151.0416 16,334.5782 8,018.6690 8,315.9092 997,268.2175 0.6411% 1.4436%
152.0099 16,439.3012 8,003.3403 8,435.9608 995,225.8613 0.6411% 1.4436%
152.9845 16,544.6955 7,986.9499 8,557.7456 993,048.6266 0.6411% 1.4436%
153.9653 16,650.7655 7,969.4770 8,681.2885 990,733.8905 0.6411% 1.4436%
154.9524 16,757.5155 7,950.9006 8,806.6149 988,278.9879 0.6411% 1.4436%
155.9458 16,864.9499 7,931.1994 8,933.7505 985,681.2110 0.6411% 1.4436%
156.9456 16,973.0731 7,910.3515 9,062.7216 982,937.8084 0.6411% 1.4436%
157.9518 17,081.8895 7,888.3350 9,193.5545 980,045.9846 0.6411% 1.4436%
158.9644 17,191.4035 7,865.1274 9,326.2762 977,002.8994 0.6411% 1.4436%
159.9836 17,301.6196 7,840.7058 9,460.9138 973,805.6668 0.6411% 1.4436%
161.0093 17,412.5424 7,815.0472 9,597.4952 970,451.3551 0.6411% 1.4436%
162.0415 17,524.1762 7,788.1279 9,736.0483 966,936.9853 0.6411% 1.4436%
163.0804 17,636.5258 7,759.9242 9,876.6016 963,259.5313 0.6411% 1.4436%
164.1259 17,749.5957 7,730.4116 10,019.1840 959,415.9182 0.6411% 1.4436%
165.1781 17,863.3904 7,699.5656 10,163.8248 955,403.0225 0.6411% 1.4436%
166.2371 17,977.9147 7,667.3611 10,310.5536 951,217.6708 0.6411% 1.4436%
167.3029 18,093.1733 7,633.7725 10,459.4007 946,856.6392 0.6411% 1.4436%
168.3755 18,209.1708 7,598.7741 10,610.3966 942,316.6526 0.6411% 1.4436%
169.4549 18,325.9119 7,562.3395 10,763.5724 937,594.3839 0.6411% 1.4436%
170.5413 18,443.4015 7,524.4421 10,918.9594 932,686.4531 0.6411% 1.4436%
171.6347 18,561.6443 7,485.0546 11,076.5897 927,589.4267 0.6411% 1.4436%
172.7351 18,680.6452 7,444.1497 11,236.4956 922,299.8169 0.6411% 1.4436%
173.8425 18,800.4091 7,401.6991 11,398.7099 916,814.0803 0.6411% 1.4436%
174.9570 18,920.9407 7,357.6747 11,563.2660 911,128.6179 0.6411% 1.4436%
176.0787 19,042.2451 7,312.0473 11,730.1978 905,239.7736 0.6411% 1.4436%
177.2076 19,164.3272 7,264.7878 11,899.5394 899,143.8336 0.6411% 1.4436%
178.3437 19,287.1920 7,215.8663 12,071.3257 892,837.0256 0.6411% 1.4436%
179.4870 19,410.8444 7,165.2525 12,245.5920 886,315.5175 0.6411% 1.4436%
180.6377 19,535.2897 7,112.9157 12,422.3740 879,575.4173 0.6411% 1.4436%
181.7958 19,660.5327 7,058.8246 12,601.7081 872,612.7713 0.6411% 1.4436%
182.9614 19,786.5787 7,002.9475 12,783.6312 865,423.5640 0.6411% 1.4436%
184.1343 19,913.4328 6,945.2522 12,968.1806 858,003.7163 0.6411% 1.4436%
185.3148 20,041.1002 6,885.7060 13,155.3942 850,349.0856 0.6411% 1.4436%
186.5029 20,169.5861 6,824.2756 13,345.3105 842,455.4638 0.6411% 1.4436%
187.6986 20,298.8957 6,760.9272 13,537.9685 834,318.5770 0.6411% 1.4436%
188.9020 20,429.0343 6,695.6265 13,733.4078 825,934.0845 0.6411% 1.4436%
190.1130 20,560.0072 6,628.3387 13,931.6685 817,297.5772 0.6411% 1.4436%
191.3319 20,691.8199 6,559.0285 14,132.7914 808,404.5774 0.6411% 1.4436%
192.5585 20,824.4776 6,487.6598 14,336.8178 799,250.5371 0.6411% 1.4436%
193.7931 20,957.9858 6,414.1962 14,543.7895 789,830.8374 0.6411% 1.4436%
195.0355 21,092.3499 6,338.6007 14,753.7493 780,140.7872 0.6411% 1.4436%
196.2859 21,227.5755 6,260.8355 14,966.7400 770,175.6222 0.6411% 1.4436%
197.5443 21,363.6680 6,180.8624 15,182.8056 759,930.5037 0.6411% 1.4436%
198.8108 21,500.6330 6,098.6426 15,401.9904 749,400.5178 0.6411% 1.4436%
200.0854 21,638.4761 6,014.1367 15,624.3394 738,580.6739 0.6411% 1.4436%
201.3681 21,777.2029 5,927.3046 15,849.8983 727,465.9038 0.6411% 1.4436%
202.6591 21,916.8191 5,838.1056 16,078.7135 716,051.0603 0.6411% 1.4436%
203.9584 22,057.3305 5,746.4985 16,310.8320 704,330.9165 0.6411% 1.4436%
205.2660 22,198.7426 5,652.4413 16,546.3014 692,300.1641 0.6411% 1.4436%
206.5820 22,341.0614 5,555.8913 16,785.1701 679,953.4124 0.6411% 1.4436%
207.9064 22,484.2926 5,456.8054 17,027.4872 667,285.1870 0.6411% 1.4436%
209.2393 22,628.4420 5,355.1395 17,273.3025 654,289.9289 0.6411% 1.4436%
210.5808 22,773.5157 5,250.8491 17,522.6665 640,961.9926 0.6411% 1.4436%
211.9308 22,919.5194 5,143.8889 17,775.6304 627,295.6454 0.6411% 1.4436%
213.2896 23,066.4591 5,034.2129 18,032.2462 613,285.0659 0.6411% 1.4436%
214.6570 23,214.3409 4,921.7743 18,292.5666 598,924.3424 0.6411% 1.4436%
216.0332 23,363.1708 4,806.5257 18,556.6451 584,207.4723 0.6411% 1.4436%
217.4182 23,512.9549 4,688.4190 18,824.5359 569,128.3596 0.6411% 1.4436%
218.8121 23,663.6992 4,567.4051 19,096.2941 553,680.8149 0.6411% 1.4436%
220.2149 23,815.4100 4,443.4345 19,371.9755 537,858.5526 0.6411% 1.4436%
221.6267 23,968.0934 4,316.4567 19,651.6367 521,655.1908 0.6411% 1.4436%
223.0476 24,121.7557 4,186.4204 19,935.3353 505,064.2487 0.6411% 1.4436%
224.4776 24,276.4031 4,053.2737 20,223.1294 488,079.1460 0.6411% 1.4436%
225.9167 24,432.0420 3,916.9638 20,515.0782 470,693.2011 0.6411% 1.4436%
227.3651 24,588.6787 3,777.4370 20,811.2417 452,899.6292 0.6411% 1.4436%
228.8228 24,746.3197 3,634.6389 21,111.6808 434,691.5416 0.6411% 1.4436%
230.2898 24,904.9712 3,488.5142 21,416.4570 416,061.9435 0.6411% 1.4436%
231.7662 25,064.6400 3,339.0068 21,725.6332 397,003.7327 0.6411% 1.4436%
233.2521 25,225.3323 3,186.0596 22,039.2727 377,509.6979 0.6411% 1.4436%
234.7475 25,387.0549 3,029.6148 22,357.4401 357,572.5172 0.6411% 1.4436%
236.2525 25,549.8144 2,869.6137 22,680.2006 337,184.7563 0.6411% 1.4436%
237.7671 25,713.6172 2,705.9965 23,007.6207 316,338.8670 0.6411% 1.4436%
239.2915 25,878.4703 2,538.7028 23,339.7675 295,027.1855 0.6411% 1.4436%
240.8256 26,044.3802 2,367.6709 23,676.7093 273,241.9304 0.6411% 1.4436%
242.3696 26,211.3538 2,192.8385 24,018.5153 250,975.2015 0.6411% 1.4436%
243.9234 26,379.3979 2,014.1421 24,365.2558 228,218.9775 0.6411% 1.4436%
245.4873 26,548.5194 1,831.5174 24,717.0019 204,965.1145 0.6411% 1.4436%
247.0611 26,718.7251 1,644.8991 25,073.8260 181,205.3441 0.6411% 1.4436%
248.6450 26,890.0220 1,454.2206 25,435.8013 156,931.2717 0.6411% 1.4436%
250.2391 27,062.4171 1,259.4148 25,803.0023 132,134.3744 0.6411% 1.4436%
251.8435 27,235.9175 1,060.4132 26,175.5043 106,805.9992 0.6411% 1.4436%
253.4581 27,410.5301 857.1463 26,553.3839 80,937.3613 0.6411% 1.4436%
255.0830 27,586.2623 649.5437 26,936.7186 54,519.5416 0.6411% 1.4436%
256.7184 27,763.1211 437.5337 27,325.5874 27,543.4855 0.6411% 1.4436%
258.3642 27,941.1138 221.0437 27,720.0700 0.0000 0.6411% 1.4436%
-0.1505%
o de interés 58
o de capital 50
108
o de interés 8,127
o de capital 7,002
15,129
de a una variación
erés en UVR.
na variación geométrica
del crédito.
de a la inflación periódica
er obtenido realizando la
e a que el saldo siempre
VR para que puedan ser
el período 25 en pesos
ajuste de la UVR )
ue permite calcular el
período ( n - 1 ) * ( 1 + tasa de
período ( n )
Valor de la UVR el día en el cual se toma el crédito 140
Tasa de ajuste anual de la UVR ( inflación Colombia ) 7.971%
Tasa de ajuste mensual de la UVR ( inflación Colombia ) 0.641%
Valor del crédito en UVR 600,000
Forma de pago del capital y del interés Cuotas constantes iguales mensuales en UVR
Tasa de interés anual en UVR 13.92%
Tasa de interés mensual en UVR 1.09%
Plazo en años 5
Período Flujo de Caja Interés Abono Capital Saldo Variación

en UVR en UVR en UVR en UVR del capital
en UVR
0 -600,000 600,000
1 13,683.70173 6,551.8268 7,131.8749 592,868.1251
2 13,683.70173 6,473.9488 7,209.7529 585,658.3722 1.0920%
3 13,683.70173 6,395.2204 7,288.4814 578,369.8908 1.0920%
4 13,683.70173 6,315.6323 7,368.0695 571,001.8213 1.0920%
5 13,683.70173 6,235.1751 7,448.5267 563,553.2947 1.0920%
6 13,683.70173 6,153.8393 7,529.8624 556,023.4323 1.0920%
7 13,683.70173 6,071.6154 7,612.0863 548,411.3459 1.0920%
8 13,683.70173 5,988.4936 7,695.2081 540,716.1378 1.0920%
9 13,683.70173 5,904.4641 7,779.2376 532,936.9002 1.0920%
10 13,683.70173 5,819.5171 7,864.1846 525,072.7156 1.0920%
11 13,683.70173 5,733.6425 7,950.0592 517,122.6564 1.0920%
12 13,683.70173 5,646.8301 8,036.8716 509,085.7848 1.0920%
13 13,683.70173 5,559.0698 8,124.6319 500,961.1529 1.0920%
14 13,683.70173 5,470.3512 8,213.3505 492,747.8023 1.0920%
15 13,683.70173 5,380.6638 8,303.0380 484,444.7644 1.0920%
16 13,683.70173 5,289.9970 8,393.7047 476,051.0596 1.0920%
17 13,683.70173 5,198.3402 8,485.3616 467,565.6981 1.0920%
18 13,683.70173 5,105.6825 8,578.0193 458,987.6788 1.0920%
19 13,683.70173 5,012.0130 8,671.6888 450,315.9900 1.0920%
20 13,683.70173 4,917.3206 8,766.3811 441,549.6089 1.0920%
21 13,683.70173 4,821.5943 8,862.1075 432,687.5015 1.0920%
22 13,683.70173 4,724.8226 8,958.8791 423,728.6224 1.0920%
23 13,683.70173 4,626.9942 9,056.7075 414,671.9149 1.0920%
24 13,683.70173 4,528.0976 9,155.6041 405,516.3108 1.0920%
25 13,683.70173 4,428.1211 9,255.5807 396,260.7301 1.0920%
26 13,683.70173 4,327.0528 9,356.6489 386,904.0812 1.0920%
27 13,683.70173 4,224.8809 9,458.8208 377,445.2603 1.0920%
28 13,683.70173 4,121.5933 9,562.1084 367,883.1519 1.0920%
29 13,683.70173 4,017.1778 9,666.5239 358,216.6280 1.0920%
30 13,683.70173 3,911.6222 9,772.0795 348,444.5485 1.0920%
31 13,683.70173 3,804.9139 9,878.7878 338,565.7606 1.0920%
32 13,683.70173 3,697.0404 9,986.6613 328,579.0993 1.0920%
33 13,683.70173 3,587.9889 10,095.7128 318,483.3865 1.0920%
34 13,683.70173 3,477.7467 10,205.9551 308,277.4314 1.0920%
35 13,683.70173 3,366.3006 10,317.4012 297,960.0302 1.0920%
36 13,683.70173 3,253.6375 10,430.0642 287,529.9660 1.0920%
37 13,683.70173 3,139.7442 10,543.9575 276,986.0085 1.0920%
38 13,683.70173 3,024.6073 10,659.0945 266,326.9141 1.0920%
39 13,683.70173 2,908.2130 10,775.4887 255,551.4254 1.0920%
40 13,683.70173 2,790.5478 10,893.1539 244,658.2714 1.0920%
41 13,683.70173 2,671.5977 11,012.1040 233,646.1674 1.0920%
42 13,683.70173 2,551.3487 11,132.3530 222,513.8144 1.0920%
43 13,683.70173 2,429.7866 11,253.9151 211,259.8993 1.0920%
44 13,683.70173 2,306.8971 11,376.8046 199,883.0947 1.0920%
45 13,683.70173 2,182.6657 11,501.0360 188,382.0586 1.0920%
46 13,683.70173 2,057.0777 11,626.6240 176,755.4346 1.0920%
47 13,683.70173 1,930.1183 11,753.5834 165,001.8512 1.0920%
48 13,683.70173 1,801.7726 11,881.9291 153,119.9221 1.0920%
49 13,683.70173 1,672.0254 12,011.6764 141,108.2457 1.0920%
50 13,683.70173 1,540.8613 12,142.8404 128,965.4053 1.0920%
51 13,683.70173 1,408.2650 12,275.4367 116,689.9685 1.0920%
52 13,683.70173 1,274.2208 12,409.4810 104,280.4876 1.0920%
53 13,683.70173 1,138.7128 12,544.9889 91,735.4987 1.0920%
54 13,683.70173 1,001.7252 12,681.9766 79,053.5221 1.0920%
55 13,683.70173 863.2416 12,820.4601 66,233.0620 1.0920%
56 13,683.70173 723.2459 12,960.4558 53,272.6062 1.0920%
57 13,683.70173 581.7215 13,101.9802 40,170.6260 1.0920%
58 13,683.70173 438.6516 13,245.0501 26,925.5759 1.0920%
59 13,683.70173 294.0195 13,389.6822 13,535.8937 1.0920%
60 13,683.70173 147.8081 13,535.8937 0.0000 1.0920%
Costo financiero o TIR 1.0920% mensual
Dinero cancelado por concepto de intereses en UVR 221,022

Dinero cancelado por concepto de intereses en pesos 35,706,500
Dinero cancelado por concepto de capital en UVR 600,000
Dinero cancelado por concepto de capital en pesos 104,830,251

Pago total
Pago total
Notas adicionales : El comportamiento del capital en UVR corresponde a una variación

geométrica creciente equivalente a la tasa de interés en UVR.



65,087,070.11
Saldo en pesos período ( n ) = Saldo en pesos período ( n - 1 ) * ( 1 + tasa de

ajuste de la UVR ) - Abono a capital en pesos período ( n )
s iguales mensuales en UVR
84,538,534
1,004,864 83,533,670
Proyección Flujo de Caja Interés Abono Capital Saldo Variación Variación

del valor de en pesos en pesos en pesos en pesos del FC del capital
la UVR en pesos en pesos
140.0000 -84,000,000 84,000,000

140.8976 1,928,000 923,136.3892 1,004,863.7496 83,533,670.1996
141.8009 1,940,361 918,011.5557 1,022,349.2203 83,046,865.2328 0.6411% 1.7401%
142.7100 1,952,801 912,661.7060 1,040,138.9528 82,539,149.5693 0.6411% 1.7401%
143.6249 1,965,320 907,082.0535 1,058,238.2415 82,010,079.5918 0.6411% 1.7401%
144.5457 1,977,920 901,267.7232 1,076,652.4731 81,459,203.4525 0.6411% 1.7401%
145.4724 1,990,601 895,213.7493 1,095,387.1276 80,886,060.9264 0.6411% 1.7401%
146.4050 2,003,363 888,915.0740 1,114,447.7809 80,290,183.2624 0.6411% 1.7401%
147.3437 2,016,207 882,366.5460 1,133,840.1055 79,671,093.0316 0.6411% 1.7401%
148.2883 2,029,133 875,562.9183 1,153,569.8727 79,028,303.9727 0.6411% 1.7401%
149.2390 2,042,142 868,498.8473 1,173,642.9545 78,361,320.8353 0.6411% 1.7401%
150.1958 2,055,234 861,168.8901 1,194,065.3246 77,669,639.2198 0.6411% 1.7401%
151.1587 2,068,411 853,567.5035 1,214,843.0612 76,952,745.4150 0.6411% 1.7401%
152.1278 2,081,671 845,689.0421 1,235,982.3477 76,210,116.2327 0.6411% 1.7401%
153.1031 2,095,017 837,527.7561 1,257,489.4755 75,441,218.8388 0.6411% 1.7401%
154.0847 2,108,449 829,077.7899 1,279,370.8453 74,645,510.5829 0.6411% 1.7401%
155.0725 2,121,966 820,333.1798 1,301,632.9693 73,822,438.8231 0.6411% 1.7401%
156.0667 2,135,570 811,287.8525 1,324,282.4730 72,971,440.7491 0.6411% 1.7401%
157.0673 2,149,262 801,935.6229 1,347,326.0969 72,091,943.2017 0.6411% 1.7401%
158.0743 2,163,041 792,270.1921 1,370,770.6992 71,183,362.4892 0.6411% 1.7401%
159.0877 2,176,908 782,285.1454 1,394,623.2572 70,245,104.2000 0.6411% 1.7401%
160.1076 2,190,865 771,973.9506 1,418,890.8696 69,276,563.0134 0.6411% 1.7401%
161.1341 2,204,911 761,329.9552 1,443,580.7589 68,277,122.5053 0.6411% 1.7401%
162.1671 2,219,047 750,346.3849 1,468,700.2729 67,246,154.9516 0.6411% 1.7401%
163.2068 2,233,273 739,016.3413 1,494,256.8875 66,183,021.1284 0.6411% 1.7401%
164.2531 2,247,591 727,332.7994 1,520,258.2085 65,087,070.1071 0.6411% 1.7401%
165.3062 2,262,001 715,288.6057 1,546,711.9744 63,957,639.0482 0.6411% 1.7401%
166.3660 2,276,503 702,876.4758 1,573,626.0579 62,794,052.9896 0.6411% 1.7401%
167.4326 2,291,097 690,088.9921 1,601,008.4690 61,595,624.6318 0.6411% 1.7401%
168.5060 2,305,786 676,918.6013 1,628,867.3570 60,361,654.1198 0.6411% 1.7401%
169.5863 2,320,569 663,357.6122 1,657,211.0129 59,091,428.8208 0.6411% 1.7401%
170.6736 2,335,446 649,398.1932 1,686,047.8722 57,784,223.0977 0.6411% 1.7401%
171.7678 2,350,419 635,032.3698 1,715,386.5171 56,439,298.0790 0.6411% 1.7401%
172.8690 2,365,488 620,252.0218 1,745,235.6788 55,055,901.4249 0.6411% 1.7401%
173.9773 2,380,653 605,048.8815 1,775,604.2410 53,633,267.0888 0.6411% 1.7401%
175.0927 2,395,916 589,414.5300 1,806,501.2417 52,170,615.0749 0.6411% 1.7401%
176.2152 2,411,276 573,340.3955 1,837,935.8760 50,667,151.1914 0.6411% 1.7401%
177.3449 2,426,735 556,817.7500 1,869,917.4992 49,122,066.7996 0.6411% 1.7401%
178.4819 2,442,293 539,837.7068 1,902,455.6295 47,534,538.5585 0.6411% 1.7401%
179.6262 2,457,951 522,391.2177 1,935,559.9505 45,903,728.1648 0.6411% 1.7401%
180.7778 2,473,709 504,469.0698 1,969,240.3144 44,228,782.0886 0.6411% 1.7401%
181.9368 2,489,569 486,061.8833 2,003,506.7448 42,508,831.3043 0.6411% 1.7401%
183.1032 2,505,530 467,160.1076 2,038,369.4398 40,742,991.0168 0.6411% 1.7401%
184.2771 2,521,593 447,754.0192 2,073,838.7750 38,930,360.3829 0.6411% 1.7401%
185.4585 2,537,759 427,833.7180 2,109,925.3062 37,070,022.2281 0.6411% 1.7401%
186.6475 2,554,029 407,389.1246 2,146,639.7733 35,161,042.7580 0.6411% 1.7401%
187.8441 2,570,403 386,409.9768 2,183,993.1029 33,202,471.2648 0.6411% 1.7401%
189.0484 2,586,882 364,885.8266 2,221,996.4116 31,193,339.8290 0.6411% 1.7401%
190.2604 2,603,467 342,806.0369 2,260,661.0098 29,132,663.0155 0.6411% 1.7401%
191.4802 2,620,158 320,159.7779 2,299,998.4044 27,019,437.5642 0.6411% 1.7401%
192.7078 2,636,956 296,936.0242 2,340,020.3025 24,852,642.0762 0.6411% 1.7401%
193.9433 2,653,862 273,123.5508 2,380,738.6152 22,631,236.6929 0.6411% 1.7401%
195.1867 2,670,876 248,710.9300 2,422,165.4607 20,354,162.7712 0.6411% 1.7401%
196.4381 2,688,000 223,686.5277 2,464,313.1679 18,020,342.5516 0.6411% 1.7401%
197.6974 2,705,233 198,038.4995 2,507,194.2806 15,628,678.8215 0.6411% 1.7401%
198.9649 2,722,576 171,754.7873 2,550,821.5605 13,178,054.5720 0.6411% 1.7401%
200.2405 2,740,031 144,823.1156 2,595,207.9916 10,667,332.6491 0.6411% 1.7401%
201.5243 2,757,598 117,230.9874 2,640,366.7838 8,095,355.3985 0.6411% 1.7401%
202.8162 2,775,277 88,965.6804 2,686,311.3767 5,460,944.3040 0.6411% 1.7401%
204.1165 2,793,070 60,014.2429 2,733,055.4441 2,762,899.6207 0.6411% 1.7401%
205.4251 2,810,976 30,363.4902 2,780,612.8974 0.0000 0.6411% 1.7401%
1.7401%
o de interés 4,528
o de capital 9,156
13,684
o de interés 739,016
o de capital 1,494,257
2,233,273
de a una variación
erés en UVR.
na variación geométrica
del crédito.
de a la inflación periódica
er obtenido realizando la
e a que el saldo siempre
VR para que puedan ser
el período 25 en pesos
ajuste de la UVR )
ue permite calcular el
período ( n - 1 ) * ( 1 + tasa de
período ( n )
TABLA DE AMORTIZACION FRANCES EJERCICIO #
P = $64.650.000 n=120 i=1.1250% A=$984.453
SALDO PAGO O SALDO
MESES INTERES AMORTIZ
INICIAL CUOTA FINAL
ACION
0 64,650,000
1 64,650,000 727,313 257,141 984,453 64,392,859
2 64,392,859 724,420 260,034 984,453 64,132,826
3 64,132,826 721,494 262,959 984,453 63,869,867
4
63,869,867 718,536 265,917 984,453 63,603,949
5 63,603,949 715,544 268,909 984,453 63,335,040
6 63,335,040 712,519 271,934 984,453 63,063,106
7 63,063,106 709,460 274,993 984,453 62,788,113
8 62,788,113 706,366 278,087 984,453 62,510,026
9 62,510,026 703,238 281,215 984,453 62,228,811
10 62,228,811 700,074 284,379 984,453 61,944,431
11 61,944,431 696,875 287,578 984,453 61,656,853
12 61,656,853 693,640 290,814 984,453 61,366,039
13 61,366,039 690,368 294,085 984,453 61,071,954
14 61,071,954 687,059 297,394 984,453 60,774,560
15 60,774,560 683,714 300,739 984,453 60,473,821
16 60,473,821 680,330 304,123 984,453 60,169,698
17 60,169,698 676,909 307,544 984,453 59,862,154
18 59,862,154 673,449 311,004 984,453 59,551,150
19 59,551,150 669,950 314,503 984,453 59,236,647
20 59,236,647 666,412 318,041 984,453 58,918,606
21 58,918,606 662,834 321,619 984,453 58,596,987
22 58,596,987 659,216 325,237 984,453 58,271,750
23 58,271,750 655,557 328,896 984,453 57,942,854
24 57,942,854 651,857 332,596 984,453 57,610,257
25 57,610,257 648,115 336,338 984,453 57,273,920
26 57,273,920 644,332 340,122 984,453 56,933,798
27 56,933,798 640,505 343,948 984,453 56,589,850
28 56,589,850 636,636 347,817 984,453 56,242,032
29 56,242,032 632,723 351,730 984,453 55,890,302
30 55,890,302 628,766 355,687 984,453 55,534,615
31 55,534,615 624,764 359,689 984,453 55,174,926
32 55,174,926 620,718 363,735 984,453 54,811,190
33 54,811,190 616,626 367,827 984,453 54,443,363
34 54,443,363 612,488 371,965 984,453 54,071,397
35 54,071,397 608,303 376,150 984,453 53,695,247
36 53,695,247 604,072 380,382 984,453 53,314,866
37 53,314,866 599,792 384,661 984,453 52,930,205
38 52,930,205 595,465 388,988 984,453 52,541,216
39 52,541,216 591,089 393,365 984,453 52,147,852
40 52,147,852 586,663 397,790 984,453 51,750,062
41 51,750,062 582,188 402,265 984,453 51,347,797
42 51,347,797 577,663 406,791 984,453 50,941,006
43 50,941,006 573,086 411,367 984,453 50,529,639
44 50,529,639 568,458 415,995 984,453 50,113,644
45 50,113,644 563,778 420,675 984,453 49,692,969
46 49,692,969 559,046 425,407 984,453 49,267,562
47 49,267,562 554,260 430,193 984,453 48,837,369
48 48,837,369 549,420 435,033 984,453 48,402,336
49 48,402,336 544,526 439,927 984,453 47,962,409
50 47,962,409 539,577 444,876 984,453 47,517,533
51 47,517,533 534,572 449,881 984,453 47,067,652
52 47,067,652 529,511 454,942 984,453 46,612,709
53 46,612,709 524,393 460,060 984,453 46,152,649
54 46,152,649 519,217 465,236 984,453 45,687,413
55 45,687,413 513,983 470,470 984,453 45,216,943
56 45,216,943 508,691 475,763 984,453 44,741,181
57 44,741,181 503,338 481,115 984,453 44,260,066
58 44,260,066 497,926 486,528 984,453 43,773,538
59 43,773,538 492,452 492,001 984,453 43,281,537
60 43,281,537 486,917 497,536 984,453 42,784,001
61 42,784,001 481,320 503,133 984,453 42,280,868
62 42,280,868 475,660 508,794 984,453 41,772,074
63 41,772,074 469,936 514,517 984,453 41,257,557
64 41,257,557 464,148 520,306 984,453 40,737,251
65 40,737,251 458,294 526,159 984,453 40,211,092
66 40,211,092 452,375 532,078 984,453 39,679,013
67 39,679,013 446,389 538,064 984,453 39,140,949
68 39,140,949 440,336 544,118 984,453 38,596,832
69 38,596,832 434,214 550,239 984,453 38,046,593
70 38,046,593 428,024 556,429 984,453 37,490,163
71 37,490,163 421,764 562,689 984,453 36,927,475
72 36,927,475 415,434 569,019 984,453 36,358,455
73 36,358,455 409,033 575,421 984,453 35,783,035
74 35,783,035 402,559 581,894 984,453 35,201,141
75 35,201,141 396,013 588,440 984,453 34,612,700
76 34,612,700 389,393 595,060 984,453 34,017,640
77 34,017,640 382,698 601,755 984,453 33,415,885
78 33,415,885 375,929 608,525 984,453 32,807,360
79 32,807,360 369,083 615,370 984,453 32,191,990
80 32,191,990 362,160 622,293 984,453 31,569,696
81 31,569,696 355,159 629,294 984,453 30,940,402
82 30,940,402 348,080 636,374 984,453 30,304,028
83 30,304,028 340,920 643,533 984,453 29,660,496
84 29,660,496 333,681 650,773 984,453 29,009,723
85 29,009,723 326,359 658,094 984,453 28,351,629
86 28,351,629 318,956 665,497 984,453 27,686,131
87 27,686,131 311,469 672,984 984,453 27,013,147
88 27,013,147 303,898 680,555 984,453 26,332,592
89 26,332,592 296,242 688,212 984,453 25,644,380
90 25,644,380 288,499 695,954 984,453 24,948,426
91 24,948,426 280,670 703,783 984,453 24,244,643
92 24,244,643 272,752 711,701 984,453 23,532,942
93 23,532,942 264,746 719,708 984,453 22,813,234
94 22,813,234 256,649 727,804 984,453 22,085,430
95 22,085,430 248,461 735,992 984,453 21,349,437
96 21,349,437 240,181 744,272 984,453 20,605,165
97 20,605,165 231,808 752,645 984,453 19,852,520
98 19,852,520 223,341 761,112 984,453 19,091,408
99 19,091,408 214,778 769,675 984,453 18,321,733
100 18,321,733 206,119 778,334 984,453 17,543,399
101 17,543,399 197,363 787,090 984,453 16,756,309
102 16,756,309 188,508 795,945 984,453 15,960,364
103 15,960,364 179,554 804,899 984,453 15,155,465
104 15,155,465 170,499 813,954 984,453 14,341,511
105 14,341,511 161,342 823,111 984,453 13,518,399
106 13,518,399 152,082 832,371 984,453 12,686,028
107 12,686,028 142,718 841,735 984,453 11,844,293
108 11,844,293 133,248 851,205 984,453 10,993,088
109 10,993,088 123,672 860,781 984,453 10,132,307
110 10,132,307 113,988 870,465 984,453 9,261,842
111 9,261,842 104,196 880,258 984,453 8,381,584
112 8,381,584 94,293 890,160 984,453 7,491,424
113 7,491,424 84,279 900,175 984,453 6,591,249
114 6,591,249 74,152 910,302 984,453 5,680,947
115 5,680,947 63,911 920,543 984,453 4,760,405
116 4,760,405 53,555 930,899 984,453 3,829,506
117 3,829,506 43,082 941,371 984,453 2,888,134
118 2,888,134 32,492 951,962 984,453 1,936,173
119 1,936,173 21,782 962,671 984,453 973,501
120 973,501 10,952 973,501 984,453 (0)
ERCICIO #
A=$984.453 INDICADORES AL 28 DE ENERO DE 2.011
EURO
TASA DE IPC ( % ) UVR DTF ( E.A. ) ( TRM EXPRESADO IGBC
INTERES 28/01/2011 %) EN USA
3.17 191.5248 3.42 1,862.05 1.3732 15,090.22
1.1250%
1.1250% TABLA DE AMORTIZACION FRANCES EJERCICIO #
1.1250% P = $500.000 n=24 i=3% A=$29.524
SALDO PAGO O SALDO
MESES INTERES AMORTIZ
INICIAL CUOTA FINAL
1.1250% ACION
1.1250% 0 500,000
1.1250% 1 500,000 15,000 14,524 29,524 485,476
1.1250% 2 485,476 14,564 14,959 29,524 470,517
1.1250% 3 470,517 14,116 15,408 29,524 455,109
1.1250% 4 455,109 13,653 15,870 29,524 439,238
1.1250% 5 439,238 13,177 16,347 29,524 422,892
1.1250% 6 422,892 12,687 16,837 29,524 406,055
1.1250% 7 406,055 12,182 17,342 29,524 388,713
1.1250% 8 388,713 11,661 17,862 29,524 370,850
1.1250% 9 370,850 11,126 18,398 29,524 352,452
1.1250% 10 352,452 10,574 18,950 29,524 333,502
1.1250% 11 333,502 10,005 19,519 29,524 313,983
1.1250% 12 313,983 9,419 20,104 29,524 293,879
1.1250% 13 293,879 8,816 20,707 29,524 273,172
1.1250% 14 273,172 8,195 21,329 29,524 251,843
1.1250% 15 251,843 7,555 21,968 29,524 229,875
1.1250% 16 229,875 6,896 22,627 29,524 207,247
1.1250% 17 207,247 6,217 23,306 29,524 183,941
1.1250% 18 183,941 5,518 24,005 29,524 159,936
1.1250% 19 159,936 4,798 24,726 29,524 135,210
1.1250% 20 135,210 4,056 25,467 29,524 109,743
1.1250% 21 109,743 3,292 26,231 29,524 83,511
1.1250% 22 83,511 2,505 27,018 29,524 56,493
1.1250% 23 56,493 1,695 27,829 29,524 28,664
1.1250% 24 28,664 860 28,664 29,524 (0)
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250%
1.1250% http://www.calcular-hipoteca.net/
PRIME ( % )
3.25
EJERCICIO #
A=$29.524
TASA DE
INTERES
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
3.0000%
MODELO DE MARKOWITZ
FORMULA
( N2 + 3 N ) / 2 N=# TOTAL DE ESTIMACIONES A REALIZAR 500
RESULTADO 125750
N 500
TABLA DE AMORTIZACION FRANCES LEASING
P = $500.000 n=24 i=3% A=$29.524
AMORTIZ
No DE SALDO RENTA IVA
ACION INTERESES
PAGO INSOLUTO MENSUAL CAPITAL
DE
CAPITAL
0 229,224 500,000
1 500,000 15,000 2,863.39 13,535 497,137
2 497,137 14,914 6,245.83 13,535 490,891
3 490,891 14,727 6,210.06 13,535 484,681
4 484,681 14,540 6,132.04 13,535 478,549
5 478,549 14,356 6,054.47 13,535 472,494
6 472,494 14,175 5,977.87 13,535 466,516
7 466,516 13,995 5,902.24 13,535 460,614
8 460,614 13,818 5,827.57 13,535 454,787
9 454,787 13,644 5,753.84 13,535 449,033
10 449,033 13,471 5,681.04 13,535 443,352
11 443,352 13,301 5,609.17 13,535 437,742
12 437,742 13,132 5,538.20 13,535 432,204
13 432,204 12,966 5,468.13 13,535 426,736
14 426,736 12,802 5,398.95 13,535 421,337
15 421,337 12,640 5,330.65 13,535 416,007
16 416,007 12,480 5,263.20 13,535 410,743
17 410,743 12,322 5,196.62 13,535 405,547
18 405,547 12,166 5,130.87 13,535 400,416
19 400,416 12,012 5,065.95 13,535 395,350
20 395,350 11,860 5,001.86 13,535 390,348
21 390,348 11,710 4,938.58 13,535 385,409
22 385,409 11,562 4,876.10 13,535 380,533
23 380,533 11,416 4,814.41 13,535 375,719
24 375,719 11,272 4,753.50 13,535 370,965
ES LEASING
A=$29.524
IVA TOTAL
INTERESES RENTA
3.0000% 1.2492% 0.14937641

3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492% 0.01244803
3.0000% 1.2492%
3.0000% 1.2492% 0.04848189
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%
3.0000% 1.2492%

Formulas y Funciones Financieras en Excel I

Cargado por

Copyright:

Formatos disponibles

Formulas y Funciones Financieras en Excel I

Cargado por

Información del documento

Título original

Derechos de autor

Formatos disponibles

Compartir este documento

Compartir o incrustar documentos

Opciones para compartir

¿Le pareció útil este documento?

¿Este contenido es inapropiado?

Copyright:

Formatos disponibles

Formulas y Funciones Financieras en Excel I

Cargado por

Copyright:

Formatos disponibles

EJERCICIOS DE SERIES UNIFORMES

VALOR ACTUAL DE UNA ANUALIDAD

EJERCICIO LA MEJOR ELECCION

VALOR PRESENTE DE UNA ANUALIDAD PREP

CALCULO DE UN INCREMENTO ANUA

CALCULO DE LA TASA DE INTERES DE UNA AN

RCICIO LA MEJOR ELECCION

NTE DE UNA ANUALIDAD PREPAGABLE

TASA DE INTERES DE UNA ANUALIDAD

CONCEPTO FUNCIONES ARITMETICAS

CONCEPTO FUNCIONES ARITMETICAS

i=1.1% mes vencido

i=1.45% mes vencido

i=1.8% mes vencido

i=0.78% mes vencido

AHORA CALCULAMOS LA SERIE TOTAL :

i=3,038437% mes vencido

n=18 meses 15)

n=18 meses 17)

n=22 meses 19)

TASA PROMEDIO 0.03125

EJERCICIOS DE SERIES UNIFORMES PER

CONCEPTO FUNCIONES ARITMETICAS

CONCEPTO FUNCIONES ARITMETICAS

CONCEPTO FUNCIONES ARITMETICAS

CONCEPTO FUNCIONES ARITMETICAS

CONCEPTO FUNCIONES ARITMETICAS

CONCEPTO FUNCIONES ARITMETICAS

CONCEPTO FUNCIONES ARITMETICAS

RIES UNIFORMES PERPETUAS O PERENNES

CONCEPTO FUNCIONES ARITMETICAS

OTRA FORMA DE RESOLVER EL EJERCICIO SI N

EJERCICIO # 2 VALOR ACTUAL DE

OTRA FORMA DE RESOLVER EL EJERCICIO SI N

EJERCICIO # 2 VALOR ACTUAL DE

AHORA RESOLVEMOS EL EJERCICIO UNA VEZ CALCULADO

REGLAS DE TRES SIM

TOTAL TOTAL EN AÑOS,MESES,

EJERCICIO # 11 CALCULANDO EL MONT

EJERCICIO # 12 CALCULAR EL MONTO A PAGAR

REGLAS DE TRES SIM

EJERCICIO # 15 SUMAS EQU

REGLAS DE TRES SIM

EJERCICIO # 16 CALCULANDO EL VALOR DE

EJERCICIO # 18 CALCULANDO LAS CUOTAS V

EJERCICIO # 19 PRESTAMOS SISTEMA DE AMOR

EJERCICIO # 20 PRESTAMO CON TASA

EJERCICIO # 23 EVALUANDO EL COSTO EF

EJERCICIO # 24 COMPRA CON TAR

EJERCICIO # 25 VALOR ACTUAL DE LO

EJERCICIO # 26 CUANDO UNA INVE

EJERCICIO # 27 CALCULANDO EL VALOR DE

TOTAL OPCION A 400,000,000

TOTAL OPCION B 412,591,117

TOTAL OPCION C 399,494,424

EJERCICIO # 29 GENERANDO FONDOS PARA L

EJERCICIO # 1 FONDO DE AHORRO

A DE RESOLVER EL EJERCICIO SI NO SE QUIERE TODO JUNTO SERIA :

EJERCICIO # 1 FONDO DE AHORRO