Ejemplo Leasing

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 6

Tasa anual 10%

tasa mensual 0.0079741404289


Valor activo 350,000.00
Plazo 8 años
pagos por año 12
Num pagos 96
Valor residual 10,000.00
Monto cuota 5,161.74

Num Cuota monto cuota Interes


0
1 5,161.74 2,790.95
2 5,161.74 2,772.04
3 5,161.74 2,752.99
4 5,161.74 2,733.78
5 5,161.74 2,714.42
6 5,161.74 2,694.90
7 5,161.74 2,675.23
8 5,161.74 2,655.41
9 5,161.74 2,635.42
10 5,161.74 2,615.27
11 5,161.74 2,594.97
12 5,161.74 2,574.50
13 5,161.74 2,553.87
14 5,161.74 2,533.07
15 5,161.74 2,512.11
16 5,161.74 2,490.98
17 5,161.74 2,469.69
18 5,161.74 2,448.22
19 5,161.74 2,426.58
20 5,161.74 2,404.77
21 5,161.74 2,382.79
22 5,161.74 2,360.63
23 5,161.74 2,338.29
24 5,161.74 2,315.78
25 5,161.74 2,293.08
26 5,161.74 2,270.21
27 5,161.74 2,247.15
28 5,161.74 2,223.91
29 5,161.74 2,200.48
30 5,161.74 2,176.87
31 5,161.74 2,153.07
32 5,161.74 2,129.08
33 5,161.74 2,104.89
34 5,161.74 2,080.52
35 5,161.74 2,055.95
36 5,161.74 2,031.18
37 5,161.74 2,006.22
38 5,161.74 1,981.06
39 5,161.74 1,955.69
40 5,161.74 1,930.13
41 5,161.74 1,904.36
42 5,161.74 1,878.38
43 5,161.74 1,852.20
44 5,161.74 1,825.81
45 5,161.74 1,799.21
46 5,161.74 1,772.40
47 5,161.74 1,745.37
48 5,161.74 1,718.13
49 5,161.74 1,690.67
50 5,161.74 1,662.99
51 5,161.74 1,635.09
52 5,161.74 1,606.97
53 5,161.74 1,578.62
54 5,161.74 1,550.05
55 5,161.74 1,521.25
56 5,161.74 1,492.22
57 5,161.74 1,462.96
58 5,161.74 1,433.46
59 5,161.74 1,403.73
60 5,161.74 1,373.76
61 5,161.74 1,343.56
62 5,161.74 1,313.11
63 5,161.74 1,282.42
64 5,161.74 1,251.49
65 5,161.74 1,220.31
66 5,161.74 1,188.88
67 5,161.74 1,157.20
68 5,161.74 1,125.27
69 5,161.74 1,093.08
70 5,161.74 1,060.63
71 5,161.74 1,027.93
72 5,161.74 994.97
73 5,161.74 961.74
74 5,161.74 928.25
75 5,161.74 894.49
76 5,161.74 860.46
77 5,161.74 826.16
78 5,161.74 791.59
79 5,161.74 756.74
80 5,161.74 721.62
81 5,161.74 686.21
82 5,161.74 650.52
83 5,161.74 614.55
84 5,161.74 578.29
85 5,161.74 541.74
86 5,161.74 504.90
87 5,161.74 467.77
88 5,161.74 430.34
89 5,161.74 392.61
90 5,161.74 354.58
91 5,161.74 316.24
92 5,161.74 277.61
93 5,161.74 238.66
94 5,161.74 199.40
95 5,161.74 159.83
96 5,161.74 119.95
R = Vi(1+i)^n - Fi
(1+i)^n -1

Amort capital Saldo capital


350,000.00
2,370.79 347,629.21
2,389.69 345,239.52
2,408.75 342,830.77
2,427.96 340,402.81
2,447.32 337,955.49
2,466.83 335,488.66
2,486.50 333,002.15
2,506.33 330,495.82
2,526.32 327,969.50
2,546.46 325,423.04
2,566.77 322,856.27
2,587.24 320,269.03
2,607.87 317,661.17
2,628.66 315,032.50
2,649.62 312,382.88
2,670.75 309,712.12
2,692.05 307,020.07
2,713.52 304,306.56
2,735.15 301,571.40
2,756.97 298,814.44
2,778.95 296,035.49
2,801.11 293,234.38
2,823.45 290,410.93
2,845.96 287,564.97
2,868.65 284,696.32
2,891.53 281,804.79
2,914.59 278,890.20
2,937.83 275,952.37
2,961.26 272,991.12
2,984.87 270,006.25
3,008.67 266,997.58
3,032.66 263,964.92
3,056.84 260,908.07
3,081.22 257,826.85
3,105.79 254,721.06
3,130.56 251,590.50
3,155.52 248,434.98
3,180.68 245,254.30
3,206.05 242,048.25
3,231.61 238,816.64
3,257.38 235,559.26
3,283.36 232,275.91
3,309.54 228,966.37
3,335.93 225,630.44
3,362.53 222,267.91
3,389.34 218,878.57
3,416.37 215,462.20
3,443.61 212,018.59
3,471.07 208,547.51
3,498.75 205,048.76
3,526.65 201,522.11
3,554.77 197,967.34
3,583.12 194,384.22
3,611.69 190,772.53
3,640.49 187,132.04
3,669.52 183,462.52
3,698.78 179,763.74
3,728.28 176,035.46
3,758.01 172,277.45
3,787.97 168,489.48
3,818.18 164,671.30
3,848.63 160,822.67
3,879.32 156,943.36
3,910.25 153,033.11
3,941.43 149,091.68
3,972.86 145,118.82
4,004.54 141,114.28
4,036.47 137,077.80
4,068.66 133,009.14
4,101.10 128,908.04
4,133.81 124,774.23
4,166.77 120,607.46
4,200.00 116,407.46
4,233.49 112,173.98
4,267.25 107,906.73
4,301.27 103,605.45
4,335.57 99,269.88
4,370.15 94,899.73
4,404.99 90,494.74
4,440.12 86,054.62
4,475.53 81,579.09
4,511.21 77,067.88
4,547.19 72,520.69
4,583.45 67,937.24
4,620.00 63,317.24
4,656.84 58,660.41
4,693.97 53,966.44
4,731.40 49,235.03
4,769.13 44,465.90
4,807.16 39,658.74
4,845.49 34,813.25
4,884.13 29,929.12
4,923.08 25,006.04
4,962.34 20,043.70
5,001.91 15,041.79
5,041.79 10,000.00

También podría gustarte