Scribd
Upload
35 views4 pages

Cuadro de Amortización Leasing 36 Meses

This document contains an amortization schedule for a financial leasing agreement over 36 months. It shows the periodic payment amount, interest amount, amortization amount, and remaining balance over the term of the lease. The initial asset amount was €80,000, the interest rate was 12% annually, and the periodic payments were €2,572 each month.

Uploaded by

JuanCarlosArrosquipaQuispe
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
35 views4 pages

Cuadro de Amortización Leasing 36 Meses

This document contains an amortization schedule for a financial leasing agreement over 36 months. It shows the periodic payment amount, interest amount, amortization amount, and remaining balance over the term of the lease. The initial asset amount was €80,000, the interest rate was 12% annually, and the periodic payments were €2,572 each month.

Uploaded by

JuanCarlosArrosquipaQuispe
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

CUADRO DE AMORTIZACION DE UN LEASING FINANCIERO

IMPORTE DE ADQUISICION DEL BIEN


TIPO DE INTERESES (Nominal Anual)
N DE PAGOS EN UN AO
N DE AOS
N DE CUOTAS LEASING EN MESES
TIPO DEL IVA
VALOR RESIDUAL DEL ACTIVO (%)

P
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
32
33
34
35
36
TOTAL

PAGO
PERIODICO
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
95,154

IMPORTE
IVA

IMPORTE
TOTAL
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
95,154

80,000
12.00%
12
3
36
0.00%
0
CUOTA DE
INTERES
0
774
756
738
720
701
683
664
645
625
606
586
566
546
526
506
485
464
443
422
400
379
357
334
312
289
267
244
220
197
173
149
125
100
76
51
25
15,154

MENSUALIDAD
TIPO DE INTERES EFECTIVO
TIPO DE INTERES EFECTIVO ANUAL

TIPO DE TAE
VIDA UTIL DEL BIEN
CUOTA
AMORTIZACION
2,572
1,797
1,815
1,834
1,852
1,870
1,889
1,908
1,927
1,946
1,966
1,985
2,005
2,025
2,046
2,066
2,087
2,108
2,129
2,150
2,172
2,193
2,215
2,237
2,260
2,282
2,305
2,328
2,351
2,375
2,399
2,423
2,447
2,471
2,496
2,521
2,546
80,000

TOTAL
AMORTIZADO
2,572
4,369
6,185
8,018
9,870
11,740
13,630
15,538
17,465
19,411
21,377
23,362
25,368
27,393
29,439
31,505
33,592
35,699
37,828
39,978
42,150
44,343
46,558
48,795
51,055
53,337
55,642
57,971
60,322
62,697
65,096
67,518
69,965
72,437
74,933
77,454
80,000

AO CAPITAL
GASTOS FIN. VALOR RESIDUAL
2000
25,368
8,065
2001
25,687
5,174
2002
28,945
1,916
0

1 ANUAL
2 SEMESTRAL
3 CUATRIMESTRAL

ING FINANCIERO
2,572
1.00%
12.68%

12.68%
3
RESTO POR
AMORTIZAR
77,428
75,631
73,815
71,982
70,130
68,260
66,370
64,462
62,535
60,589
58,623
56,638
54,632
52,607
50,561
48,495
46,408
44,301
42,172
40,022
37,850
35,657
33,442
31,205
28,945
26,663
24,358
22,029
19,678
17,303
14,904
12,482
10,035
7,563
5,067
2,546
0

CALCULO
TIR
-77,428
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572
2,572

4 TRIMESTRAL
6 BIMESTRAL
12 ANUAL

You might also like