Amortizacion

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

MONTO 5000

INTERES 16% 1.33%


TIEMPO 36

METODO FRANCÉS

Saldo Cuota Interes Capital/amortizacion


0 $5,000.00
1 $4,890.81 $175.69 $66.50 $109.19
2 $4,780.17 $175.69 $65.05 $110.64
3 $4,668.05 $175.69 $63.58 $112.11
4 $4,554.45 $175.69 $62.09 $113.60
5 $4,439.33 $175.69 $60.57 $115.12
6 $4,322.69 $175.69 $59.04 $116.65
7 $4,204.49 $175.69 $57.49 $118.20
8 $4,084.72 $175.69 $55.92 $119.77
9 $3,963.35 $175.69 $54.33 $121.36
10 $3,840.38 $175.69 $52.71 $122.98
11 $3,715.76 $175.69 $51.08 $124.61
12 $3,589.49 $175.69 $49.42 $126.27
13 $3,461.54 $175.69 $47.74 $127.95
14 $3,331.89 $175.69 $46.04 $129.65
15 $3,200.52 $175.69 $44.31 $131.38
16 $3,067.39 $175.69 $42.57 $133.12
17 $2,932.50 $175.69 $40.80 $134.89
18 $2,795.81 $175.69 $39.00 $136.69
19 $2,657.31 $175.69 $37.18 $138.51
20 $2,516.96 $175.69 $35.34 $140.35
21 $2,374.74 $175.69 $33.48 $142.21
22 $2,230.64 $175.69 $31.58 $144.11
23 $2,084.62 $175.69 $29.67 $146.02
24 $1,936.65 $175.69 $27.73 $147.96
25 $1,786.72 $175.69 $25.76 $149.93
26 $1,634.79 $175.69 $23.76 $151.93
27 $1,480.84 $175.69 $21.74 $153.95
28 $1,324.85 $175.69 $19.70 $155.99
29 $1,166.78 $175.69 $17.62 $158.07
30 $1,006.61 $175.69 $15.52 $160.17
31 $844.31 $175.69 $13.39 $162.30
32 $679.85 $175.69 $11.23 $164.46
33 $513.20 $175.69 $9.04 $166.65
34 $344.33 $175.69 $6.83 $168.86
35 $173.22 $175.69 $4.58 $171.11
36 $0.00 $175.53 $2.30 $173.23
$5,000.00

METODO ALEMAN
(MONTO DEL PRESTAMO*TASA DE INTERES)
(1-(1+TASA DE INTERES)^-n)

CUOTA= 5000*1,33
(1-1+1,33)^-36

CUOTA= 175.69
METODO FRANCES

Monto $66,000.00
Tiempo 12 meses
Tasa 18% anual 18dividido para 4 4.50%
METODO ALEMAN
ENTRADAS
FECHA DESCRIPCION PRECIO PRECIO
CANTIDAD
UNITARIO TOTAL
12/31/1899
25 360.000 9,000.000
(-5) 360.000 1,800.000

25 380.000 9,500.000
250.000

VENTAS NETAS
VENTAS
DESCUENTOS EN VENTAS
DEVOLUCIONES
VENTAS NETAS

COSTO DE VENTAS

INVENTARIO INCIAL
COMPRAS NETAS
DEDUCIBLE
INVENTARIO FINAL
COSTO DE VENTAS

UTILIDAD BRUTA EN VENTAS


VENTAS NETAS
COSTO DE VENTAS
UTILIDAD BRUTA EN VENTAS
SALIDAS SALDO
PRECIO PRECIO
CANTIDAD CANTIDAD PRECIO UNITARIO PRECIO TOTAL
UNITARIO TOTAL
25 $ 350.000 $ 8,750.000
50 $ 355.000 $ 17,750.000
45 $ 354.444 $ 15,950.000
26 $ 354.444 $9,215.544 19 $ 354.445 $ 6,734.456
-1 $ 354.444 $ 354.444 20 $ 354.445 $ 7,088.900
45 $ 368.642 $ 16,588.900
45 $ 363.087 $ 16,338.900
15 $ 363.087 $5,446.300 30 $ 363.087 $ 10,892.600

También podría gustarte