Ejercicio 2 Amortizacion

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

vp 5000

interes 9% pago=intere+capital
5
principal fijo
saldo inicial cuota interes capital saldo final
0 5000 0
1 5000 1450 450 1000 4000 1
2 4000 1360 360 1000 3000 2
3 3000 1270 270 1000 2000 3
4 2000 1180 180 1000 1000 4
5 1000 1090 90 1000 0 5
S/ 1,285.46
principal fijo
saldo inicial cuota interes capital saldo final

5000 S/ 1,285.46 S/ 450.00


S/ 1,285.46
S/ 1,285.46
S/ 1,285.46
S/ 1,285.46
MONTO 50000 SOLES
TASA 1% ANUAL
PLAZO 48 AÑOS
PAGO $1,456.29
3 2 1
PERIODO SALDO INICIAPAGO/cuota INTERES capital SALDO FINAL
0 50000
1 50000 $1,456.29 730.085 $726.21 $49,273.79
2 49273.7933 $1,456.29 719.481147 $736.81 $48,536.98
3 48536.9827 $1,456.29 708.72246 $747.57 $47,789.41
4 47789.4134 $1,456.29 697.806678 $758.49 $47,030.93
5 47030.9283 $1,456.29 686.731506 $769.56 $46,261.37
6 46261.3681 $1,456.29 675.494619 $780.80 $45,480.57
7 45480.571 $1,456.29 664.093653 $792.20 $44,688.37
8 44688.3729 $1,456.29 652.526215 $803.77 $43,884.61
9 43884.6074 $1,456.29 640.789872 $815.50 $43,069.11
10 43069.1055 $1,456.29 628.882158 $827.41 $42,241.70
11 42241.6959 $1,456.29 616.800571 $839.49 $41,402.20
12 41402.2048 $1,456.29 604.542573 $851.75 $40,550.46
13 40550.4556 $1,456.29 592.105587 $864.19 $39,686.27
14 39686.2694 $1,456.29 579.487001 $876.80 $38,809.46
15 38809.4647 $1,456.29 566.684161 $889.61 $37,919.86
16 37919.8571 $1,456.29 553.694378 $902.60 $37,017.26
17 37017.2598 $1,456.29 540.514922 $915.78 $36,101.48
18 36101.483 $1,456.29 527.143024 $929.15 $35,172.33
19 35172.3342 $1,456.29 513.575873 $942.72 $34,229.62
20 34229.6184 $1,456.29 499.810619 $956.48 $33,273.14
21 33273.1373 $1,456.29 485.844368 $970.45 $32,302.69
22 32302.6899 $1,456.29 471.674187 $984.62 $31,318.07
23 31318.0723 $1,456.29 457.297097 $998.99 $30,319.08
24 30319.0777 $1,456.29 442.710077 $1,013.58 $29,305.50
25 29305.496 $1,456.29 427.910061 $1,028.38 $28,277.11
26 28277.1144 $1,456.29 412.893941 $1,043.40 $27,233.72
27 27233.7166 $1,456.29 397.658559 $1,058.63 $26,175.08
28 26175.0834 $1,456.29 382.200715 $1,074.09 $25,100.99
29 25100.9924 $1,456.29 366.51716 $1,089.77 $24,011.22
30 24011.2178 $1,456.29 350.604599 $1,105.69 $22,905.53
31 22905.5306 $1,456.29 334.459687 $1,121.83 $21,783.70
32 21783.6986 $1,456.29 318.079032 $1,138.21 $20,645.49
33 20645.4859 $1,456.29 301.459191 $1,154.83 $19,490.65
34 19490.6533 $1,456.29 284.596673 $1,171.70 $18,318.96
35 18318.9583 $1,456.29 267.487933 $1,188.80 $17,130.15
36 17130.1545 $1,456.29 250.129377 $1,206.16 $15,923.99
37 15923.9921 $1,456.29 232.517356 $1,223.77 $14,700.22
38 14700.2177 $1,456.29 214.648169 $1,241.64 $13,458.57
39 13458.5742 $1,456.29 196.518062 $1,259.77 $12,198.80
40 12198.8005 $1,456.29 178.123225 $1,278.17 $10,920.63
41 10920.632 $1,456.29 159.459792 $1,296.83 $9,623.80
42 9623.80003 $1,456.29 140.523841 $1,315.77 $8,308.03
43 8308.03213 $1,456.29 121.311393 $1,334.98 $6,973.05
44 6973.05178 $1,456.29 101.81841 $1,354.47 $5,618.58
45 5618.57846 $1,456.29 82.040797 $1,374.25 $4,244.33
46 4244.32751 $1,456.29 61.9743971 $1,394.32 $2,850.01
47 2850.01017 $1,456.29 41.6149936 $1,414.68 $1,435.33
48 1435.33343 $1,456.29 20.9583081 $1,435.33 -$0.00

También podría gustarte