Metodos de Amortizacion Excel

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

1ºTRABAJO ENCARGADO DE MATEMATICA FINANCIERA

PRESENTADO POR :ESTEFANY MELANIA CCAMA CALISAYA

DATOS: ITF : 0.005%


SEGURO DE DESGRAVAMEN : 0.0515%
CAPITAL : 4500
cuota=4500(FRC i=5% n=12 )
cuota=507.72

TEM=(1+79.59%)^(1÷12)-1 507.72
TEM=5.00021279%

INTERES
PERIODO DIAS AMORTIZACION CUOTA SIN SEGURO
2.41008600%
0
1 30 S/. 349.71 S/. 115.68 S/. 465.39
2 30 S/. 358.13 S/. 107.26 S/. 465.39
3 30 S/. 366.77 S/. 98.62 S/. 465.39
4 30 S/. 375.60 S/. 89.79 S/. 465.39
5 30 S/. 384.66 S/. 80.73 S/. 465.39
6 30 S/. 393.93 S/. 71.46 S/. 465.39
7 30 S/. 403.42 S/. 61.97 S/. 465.39
8 30 S/. 413.14 S/. 52.25 S/. 465.39
9 30 S/. 423.10 S/. 42.29 S/. 465.39
10 30 S/. 433.30 S/. 32.09 S/. 465.39
11 30 S/. 443.74 S/. 21.65 S/. 465.39
12 30 S/. 454.44 S/. 10.95 S/. 465.39
TOTAL S/. 4,799.94 S/. 784.74 S/. 5,584.68
CUOTA SIN SEGURO-INTERES CAPITAL*INTERES CUOTA SIN SEGURO
ICA FINANCIERA

III-A CONTABILIDAD

E DESGRAVAMEN : 0.0515%
0.7695 0.032071955174519
0.33078652176428
4800 0.096956656527178
465.39195133

SEGURO DE DESGRAVAMEN ITF


TOTAL CUOTA SALDO CAPITAL
0.0515% 0.005%
S/. 500.00
S/. 4,800.00
S/. 2.47 S/. 0.02 S/. 467.89 S/. 4,450.29 S/. 450.00
S/. 2.29 S/. 0.02 S/. 467.71 S/. 4,092.16 S/. 400.00
S/. 2.11 S/. 0.02 S/. 467.52 S/. 3,725.39 S/. 350.00
S/. 1.92 S/. 0.02 S/. 467.33 S/. 3,349.79 S/. 300.00
S/. 1.73 S/. 0.02 S/. 467.14 S/. 2,965.13 S/. 250.00
S/. 1.53 S/. 0.02 S/. 466.94 S/. 2,571.20
S/. 200.00
S/. 1.32 S/. 0.02 S/. 466.74 S/. 2,167.78
S/. 150.00
S/. 1.12 S/. 0.02 S/. 466.53 S/. 1,754.64
S/. 100.00
S/. 0.90 S/. 0.02 S/. 466.32 S/. 1,331.54
S/. 0.69 S/. 0.02 S/. 466.10 S/. 898.24 S/. 50.00

S/. 0.46 S/. 0.02 S/. 465.88 S/. 454.50 S/. -


1 2 3
S/. 0.23 S/. 0.02 S/. 465.65 S/. 0.06
S/. 16.77 S/. 0.28 S/. 5,601.73
CAPITAL*SEGURO DE DESGRAVAMEN CUOTA SIN SEGURO*ITF CUOTA+SEGURO+ITF CAPITAL-AMORTIZACION
S/. 500.00
S/. 450.00
S/. 400.00
S/. 350.00
S/. 300.00
S/. 250.00 Column E
Column D
S/. 200.00
S/. 150.00
S/. 100.00
S/. 50.00
S/. -
1 2 3 4 5 6 7 8 9 10 11 12
2º TRABAJO ENCARGADO DE MATEMATI
PRESENTADO POR:ESTEFANY MELANIA CCAMA CALISAYA
DATOS:

CAPITAL : 30000
CUOTA = 2896.454236
TEM = 2.34056908%

PLAN DE CUOTAS CONSTANTES O METODO FRANCES

INTERES CUOTA SIN SEGURO


PERIODOS AMORTIZACION
2.34056908%
0
1 S/. 2,194.28 S/. 702.17 S/. 2,896.45
2 S/. 2,245.64 S/. 650.81 S/. 2,896.45
3 S/. 2,298.20 S/. 598.25 S/. 2,896.45
4 S/. 2,351.99 S/. 544.46 S/. 2,896.45
5 S/. 2,407.04 S/. 489.41 S/. 2,896.45
6 S/. 2,463.38 S/. 433.07 S/. 2,896.45
7 S/. 2,521.04 S/. 375.41 S/. 2,896.45
8 S/. 2,580.05 S/. 316.41 S/. 2,896.45
9 S/. 2,640.43 S/. 256.02 S/. 2,896.45
10 S/. 2,702.24 S/. 194.22 S/. 2,896.45
11 S/. 2,765.48 S/. 130.97 S/. 2,896.45
12 S/. 2,830.21 S/. 66.24 S/. 2,896.45
TOTALES S/. 30,000.00 S/. 4,757.45 S/. 34,757.45
CUOTA SIN SEGURO-INTERES SALDO*INTERES CUOTA SIN SEGURO
GADO DE MATEMATICA FINANCIERA
AMA CALISAYA

ITF : 0.005%
SEGURO DE DESGRAVAMEN : 0.0515%

SEGURO DE DESGRAVAMEN ITF TOTAL CUOTA


SALDO CAPITAL
0.0515% 0.005%
S/. 30,000.00
S/. 15.4500 S/. 0.1448227118 S/. 2,912.05 S/. 27,805.72
S/. 14.3199 S/. 0.1448227118 S/. 2,910.92 S/. 25,560.07
S/. 13.1634 S/. 0.1448227118 S/. 2,909.76 S/. 23,261.87
S/. 11.9799 S/. 0.1448227118 S/. 2,908.58 S/. 20,909.88
S/. 10.7686 S/. 0.1448227118 S/. 2,907.37 S/. 18,502.83
S/. 9.5290 S/. 0.1448227118 S/. 2,906.13 S/. 16,039.45
S/. 8.2603 S/. 0.1448227118 S/. 2,904.86 S/. 13,518.41
S/. 6.9620 S/. 0.1448227118 S/. 2,903.56 S/. 10,938.36
S/. 5.6333 S/. 0.1448227118 S/. 2,902.23 S/. 8,297.93
S/. 4.2734 S/. 0.1448227118 S/. 2,900.87 S/. 5,595.69
S/. 2.8818 S/. 0.1448227118 S/. 2,899.48 S/. 2,830.21
S/. 1.4576 S/. 0.1448227118 S/. 2,898.06 S/. 0.00
S/. 104.68 S/. 1.74 S/. 34,863.87
CAPITAL*SEGURO DE DESGRAVAMEN CUOTA SIN SEGURO*ITF CUOTA+SEGURO+ITF CAPITAL-AMORTIZACION
S/. 3,000.00

S/. 2,500.00

S/. 2,000.00

S/. 1,500.00 Column D


Column C
S/. 1,000.00

S/. 500.00

S/. -
1 2 3 4 5 6 7 8 9 10 11 12
2º TRABAJO ENCARGADO DE MATEMATICA FINANC

PRESENTADO POR:ESTEFANY MELANIA CCAMA CALISAYA

DATOS:

CAPITAL : 30000
CUOTA = 6000/12= 2500
TEM = 2.75%

PLAN DE AMORTIZACION CONSTANTE O METODO ALEM

AMORTIZACION
INTERES
CUOTA SIN
PERIODOS SEGURO 2.75000000%
0
1 S/. 595.36 S/. 165.00 S/. 430.36
2 S/. 595.36 S/. 153.17 S/. 442.19
3 S/. 595.36 S/. 141.00 S/. 454.36
4 S/. 595.36 S/. 128.51 S/. 466.85
5 S/. 595.36 S/. 115.67 S/. 479.69
6 S/. 595.36 S/. 102.48 S/. 492.88
7 S/. 595.36 S/. 88.93 S/. 506.43
8 S/. 595.36 S/. 75.00 S/. 520.36
9 S/. 595.36 S/. 60.69 S/. 534.67
10 S/. 595.36 S/. 45.99 S/. 549.37
11 S/. 595.36 S/. 30.88 S/. 564.48
12 S/. 595.36 S/. 15.35 S/. 580.01
TOTALES S/. 7,144.32 S/. 1,122.66 S/. 6,021.66
CAPITAL/TIEMPO SALDO*INTERES AMORTIZACION+INTERES
GADO DE MATEMATICA FINANCIERA

LANIA CCAMA CALISAYA

ITF : 0.005%
SEGURO DE DESGRAVAMEN : 0.0515%

ON CONSTANTE O METODO ALEMAN

SEGURO DE DESGRAVAMEN CUOTA CON


ITF
SALDO CAPITAL
0.0000%
0.005% SEGUROS
AMORT
S/. 6,000.00 S/. 800.00
S/. 3.0000 S/. - S/. 598.36 S/. 5,569.64 S/. 700.00
S/. 3.0000 S/. - S/. 598.36 S/. 5,127.45 S/. 600.00
S/. 3.0000 S/. - S/. 598.36 S/. 4,673.09 S/. 500.00
S/. 3.0000 S/. - S/. 598.36 S/. 4,206.24 S/. 400.00
S/. 3.0000 S/. - S/. 598.36 S/. 3,726.55 S/. 300.00
S/. 3.0000 S/. - S/. 598.36 S/. 3,233.67
S/. 200.00
S/. 3.0000 S/. - S/. 598.36 S/. 2,727.24
S/. 100.00
S/. 3.0000 S/. - S/. 598.36 S/. 2,206.88
S/. -
S/. 3.0000 S/. - S/. 598.36 S/. 1,672.21 1 2
S/. 3.0000 S/. - S/. 598.36 S/. 1,122.83
S/. 3.0000 S/. - S/. 598.36 S/. 558.35
S/. 3.0000 S/. - S/. 598.36 S/. -21.66
S/. 36.00 S/. - S/. 7,180.32
CAPITAL*SEGURO DE DESGRAVAMEN CUOTA SIN SEGURO*ITF CUOTA+SEGURO+ITF CAPITAL-AMORTIZACION
AMORTIZACION-METODO FRANCES
S/. 800.00
S/. 700.00
S/. 600.00
S/. 500.00
S/. 400.00
S/. 300.00
S/. 200.00
S/. 100.00
S/. -
1 2 3 4 5 6 7 8 9 10 11 12

Column C Column D
2º TRABAJO ENCARGADO DE MATEMATICA FI

PRESENTADO POR:ESTEFANY MELANIA CCAMA CALISAYA

DATOS:

CAPITAL : 30000
TEM = 2.34056908%

PLAN DE CUOTAS E INTERES CONSTANTE O METODO AMERICANO

INTERES CUOTA SIN SEGURO


PERIODOS AMORTIZACION
2.34056908%
0
1 S/. - S/. 702.17 S/. 702.17
2 S/. - S/. 702.17 S/. 702.17
3 S/. - S/. 702.17 S/. 702.17
4 S/. - S/. 702.17 S/. 702.17
5 S/. - S/. 702.17 S/. 702.17
6 S/. - S/. 702.17 S/. 702.17
7 S/. - S/. 702.17 S/. 702.17
8 S/. - S/. 702.17 S/. 702.17
9 S/. - S/. 702.17 S/. 702.17
10 S/. - S/. 702.17 S/. 702.17
11 S/. 702.17 S/. 702.17
12 S/. 30,000.00 S/. 702.17 S/. 30,702.17
TOTALES S/. 30,000.00 S/. 8,426.05 S/. 38,426.05
CUOTA SIN SEGURO-INTERES SALDO*INTERES AMORTIZACION+INTERES
DE MATEMATICA FINANCIERA

CALISAYA

ITF : 0.005%
SEGURO DE DESGRAVAMEN : 0.0515%

ETODO AMERICANO

SEGURO DE DESGRAVAMEN ITF TOTAL CUOTA


SALDO CAPITAL
0.0515% 0.005%
S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 0.0351085362 S/. 717.66 S/. 30,000.00
S/. 15.4500 S/. 1.5351085362 S/. 30,719.16 S/. -
S/. 185.40 S/. 1.92 S/. 38,613.37
CAPITAL*SEGURO DE DESGRAVAMENCUOTA SIN SEGURO*ITF CUOTA+SEGURO+ITF CAPITAL-AMORTIZACION
AMORTIZACION-METODO AMERICANO
S/. 35,000.00

S/. 30,000.00

S/. 25,000.00
Column D
S/. 20,000.00 Column C
S/. 15,000.00

S/. 10,000.00

S/. 5,000.00

S/. -
1 2 3 4 5 6 7 8 9 10 11 12
2º TRABAJO ENCARGADO DE MATEMATICA FINANCI

PRESENTADO POR:ESTEFANY MELANIA CCAMA CALISAYA

DATOS:
CAPITAL : 30000
TEM = 2.34056908%
FRC 0.09654847454
FASG 54.11429106
1° cuota S/. 2,635.22
PLAN DE CUOTAS CRECIENTES ARITMETICAMENTE O GRA

INTERES CUOTA SIN SEGURO


PERIODOS AMORTIZACION 2.34056908%
0
1 S/. 1,933.05 S/. 702.17 S/. 2,635.22
2 S/. 2,028.30 S/. 656.93 S/. 2,685.22
3 S/. 2,125.77 S/. 609.45 S/. 2,735.22
4 S/. 2,225.52 S/. 559.70 S/. 2,785.22
5 S/. 2,327.61 S/. 507.61 S/. 2,835.22
6 S/. 2,432.09 S/. 453.13 S/. 2,885.22
7 S/. 2,539.02 S/. 396.20 S/. 2,935.22
8 S/. 2,648.45 S/. 336.78 S/. 2,985.22
9 S/. 2,760.43 S/. 274.79 S/. 3,035.22
10 S/. 2,875.04 S/. 210.18 S/. 3,085.22
11 S/. 2,992.34 S/. 142.88 S/. 3,135.22
12 S/. 3,112.37 S/. 72.85 S/. 3,185.22
TOTALES S/. 30,000.00 S/. 4,922.66 S/. 34,922.66
CUOTA SIN SEGURO-INTERES SALDO*INTERES CUOTA+GRADIENTE ARITMETICO
MATEMATICA FINANCIERA

CALISAYA

GRADIENTA ARITMETICO
ITF : 0.005%
SEGURO DE DESGRAVAMEN : 0.0515%

ARITMETICAMENTE O GRADIENTE ARITMETICO

SEGURO DE DESGRAVAMEN ITF TOTAL CUOTA


SALDO CAPITAL
0.0515% 0.005%
S/. 30,000.00
S/. 15.4500 S/. 0.1317610812 S/. 2,650.80 S/. 28,066.95
S/. 14.4545 S/. 0.1342610812 S/. 2,699.81 S/. 26,038.65
S/. 13.4099 S/. 0.1367610812 S/. 2,748.77 S/. 23,912.88
S/. 12.3151 S/. 0.1392610812 S/. 2,797.68 S/. 21,687.36
S/. 11.1690 S/. 0.1417610812 S/. 2,846.53 S/. 19,359.75
S/. 9.9703 S/. 0.1442610812 S/. 2,895.34 S/. 16,927.65
S/. 8.7177 S/. 0.1467610812 S/. 2,944.09 S/. 14,388.64
S/. 7.4101 S/. 0.1492610812 S/. 2,992.78 S/. 11,740.19
S/. 6.0462 S/. 0.1517610812 S/. 3,041.42 S/. 8,979.76
S/. 4.6246 S/. 0.1542610812 S/. 3,090.00 S/. 6,104.71
S/. 3.1439 S/. 0.1567610812 S/. 3,138.52 S/. 3,112.37
S/. 1.6029 S/. 0.1592610812 S/. 3,186.98 S/. -0.00
S/. 108.31 S/. 1.75 S/. 35,032.72
CAPITAL*SEGURO DE DESGRAVAMENCUOTA SIN SEGURO*ITF CUOTA+SEGURO+ITF CAPITAL-AMORTIZACION
AMORIZACION-GRADIENTE ARITMETICO
S/. 3,500.00

S/. 3,000.00

S/. 2,500.00
Column D
S/. 2,000.00 Column C
S/. 1,500.00

S/. 1,000.00

S/. 500.00

S/. -
1 2 3 4 5 6 7 8 9 10 11 12
2º TRABAJO ENCARGADO DE MATEMATICA FINANCIERA

PRESENTADO POR:ESTEFANY MELANIA CCAMA CALISAYA

DATOS:

CAPITAL : 30000
TEM = 2.34056908%
GRAD. GEOMETRICO 10%
FACTORG 0.05559992873
1° CUOTA S/. 1,667.997862

PLAN DE CUOTAS CRECIENTES GEOMETR

INTERES
PERIODOS AMORTIZACION 2.34056908%
0
1 S/. 965.83 S/. 702.17
2 S/. 1,155.23 S/. 679.56
3 S/. 1,365.75 S/. 652.53
4 S/. 1,599.55 S/. 620.56
5 S/. 1,858.99 S/. 583.12
6 S/. 2,146.72 S/. 539.61
7 S/. 2,465.60 S/. 489.36
8 S/. 2,818.80 S/. 431.66
9 S/. 3,209.82 S/. 365.68
10 S/. 3,642.50 S/. 290.55
11 S/. 4,121.06 S/. 205.30
12 S/. 4,650.15 S/. 108.84
TOTALES S/. 30,000.00 S/. 5,668.94
CUOTA SIN SEGURO-INTERES SALDO*INTERES
E MATEMATICA FINANCIERA

AMA CALISAYA

ITF : 0.005%
SEGURO DE DESGRAVAMEN : 0.0515%

DE CUOTAS CRECIENTES GEOMETRICAMENTE O GRADIENTE GEOMETRICO

CUOTA SIN SEGURO SEGURO DE DESGRAVAMEN ITF


0.0515% 0.005%

S/. 1,668.00 S/. 15.4500 S/. 0.0833998931


S/. 1,834.80 S/. 14.9526 S/. 0.0917398824
S/. 2,018.28 S/. 14.3577 S/. 0.1009138707
S/. 2,220.11 S/. 13.6543 S/. 0.1110052577
S/. 2,442.12 S/. 12.8305 S/. 0.1221057835
S/. 2,686.33 S/. 11.8731 S/. 0.1343163618
S/. 2,954.96 S/. 10.7676 S/. 0.1477479980
S/. 3,250.46 S/. 9.4978 S/. 0.1625227978
S/. 3,575.50 S/. 8.0461 S/. 0.1787750776
S/. 3,933.05 S/. 6.3931 S/. 0.1966525854
S/. 4,326.36 S/. 4.5172 S/. 0.2163178439
S/. 4,758.99 S/. 2.3948 S/. 0.2379496283
S/. 35,668.94 S/. 124.73 S/. 1.78
1ºCUOTA*GRADIENTE GEOMETRICO CAPITAL*SEGURO DE DESGRAVAMEN CUOTA SIN SEGURO*ITF
DESGRAVAMEN : 0.0515%

TOTAL CUOTA
SALDO CAPITAL

S/. 30,000.00
S/. 1,683.53 S/. 29,034.17
S/. 1,849.84 S/. 27,878.94 AMORTIZACION-GRAD. GEOMETRICO
S/. 2,032.74 S/. 26,513.19 S/. 5,000.00
S/. 2,233.87 S/. 24,913.64 S/. 4,500.00
S/. 2,455.07 S/. 23,054.65 S/. 4,000.00
S/. 2,698.33 S/. 20,907.93 S/. 3,500.00
C
S/. 2,965.88 S/. 18,442.34 S/. 3,000.00
C
S/. 3,260.12 S/. 15,623.54 S/. 2,500.00
S/. 2,000.00
S/. 3,583.73 S/. 12,413.71
S/. 1,500.00
S/. 3,939.64 S/. 8,771.21
S/. 1,000.00
S/. 4,331.09 S/. 4,650.15
S/. 500.00
S/. 4,761.63 S/. 0.00
S/. -
S/. 35,795.46 1 2 3 4 5 6 7 8 9 10 11 12

CUOTA+SEGURO+ITF CAPITAL-AMORTIZACION
N-GRAD. GEOMETRICO

Column D
Column C

6 7 8 9 10 11 12
2º TRABAJO ENCARGADO DE MATEMATICA FINAN

PRESENTADO POR:ESTEFANY MELANIA CCAMA CALISAYA

DATOS:

CAPITAL : 30000
TEM = 2.34056908%
SUMA DE DIGITOS = 78

PLAN O METODO DE SUMA DE DIG

INTERES
PERIODOS PROPORCION AMORTIZACION 2.34056908%
0
1 0.0128205128205128 S/. 384.62 S/. 702.17
2 0.0256410256410256 S/. 769.23 S/. 693.17
3 0.0384615384615385 S/. 1,153.85 S/. 675.16
4 0.0512820512820513 S/. 1,538.46 S/. 648.16
5 0.0641025641025641 S/. 1,923.08 S/. 612.15
6 0.0769230769230769 S/. 2,307.69 S/. 567.14
7 0.0897435897435897 S/. 2,692.31 S/. 513.12
8 0.1025641025641030 S/. 3,076.92 S/. 450.11
9 0.1153846153846150 S/. 3,461.54 S/. 378.09
10 0.1282051282051280 S/. 3,846.15 S/. 297.07
11 0.1410256410256410 S/. 4,230.77 S/. 207.05
12 0.1538461538461540 S/. 4,615.38 S/. 108.03
TOTALES S/. 1.00 S/. 30,000.00 S/. 5,851.42
TIEMPO/SUMA DE DIGITOS SALDO*PROPORCION SALDO*INTERES
DO DE MATEMATICA FINANCIERA

AMA CALISAYA

ITF : 0.005%
SEGURO DE DESGRAVAMEN : 0.0515%

N O METODO DE SUMA DE DIGITOS

CUOTA SIN SEGURO SEGURO DE DESGRAVAMEN ITF TOTAL CUOTA


0.0515% 0.005%

S/. 1,086.79 S/. 15.4500 S/. 0.0543393054 S/. 1,102.29


S/. 1,462.40 S/. 15.2519 S/. 0.0731199652 S/. 1,477.72
S/. 1,829.01 S/. 14.8558 S/. 0.0914505156 S/. 1,843.96
S/. 2,186.62 S/. 14.2615 S/. 0.1093309565 S/. 2,200.99
S/. 2,535.23 S/. 13.4692 S/. 0.1267612880 S/. 2,548.82
S/. 2,874.83 S/. 12.4788 S/. 0.1437415100 S/. 2,887.45
S/. 3,205.43 S/. 11.2904 S/. 0.1602716226 S/. 3,216.88
S/. 3,527.03 S/. 9.9038 S/. 0.1763516258 S/. 3,537.11
S/. 3,839.63 S/. 8.3192 S/. 0.1919815195 S/. 3,848.14
S/. 4,143.23 S/. 6.5365 S/. 0.2071613038 S/. 4,149.97
S/. 4,437.82 S/. 4.5558 S/. 0.2218909786 S/. 4,442.60
S/. 4,723.41 S/. 2.3769 S/. 0.2361705440 S/. 4,726.02
S/. 35,851.42 S/. 128.75 S/. 1.79 S/. 35,981.97
INTERES+AMORTIZACION CAPITAL*SEGURO DE DESGRAVAMENCUOTA SIN SEGURO*ITF CUOTA+SEGURO+ITF
SALDO CAPITAL S/. 5,000.00

S/. 30,000.00 S/. 4,500.00

S/. 29,615.38 S/. 4,000.00


S/. 28,846.15 S/. 3,500.00
S/. 27,692.31
S/. 3,000.00
S/. 26,153.85
S/. 2,500.00 Column E
S/. 24,230.77
Column D
S/. 21,923.08 S/. 2,000.00
S/. 19,230.77 S/. 1,500.00
S/. 16,153.85
S/. 1,000.00
S/. 12,692.31
S/. 500.00
S/. 8,846.15
S/. 4,615.38 S/. -
1 2 3 4 5 6 7 8 9 10 11 12
S/. -

CAPITAL-AMORTIZACION
Column E
Column D

También podría gustarte