Trabajador valor tiempo tasa

Carlos Pérez $ 650,000.00 12 meses 15% efectiva

Juan Gómez $ 1,800,000.00 15 meses 15% efectiva
Lucia Jiménez $ 5,800,000.00 36 meses 15% efectiva
Paula Rendón $ 690,560.00 5 meses 15% efectiva
Luis Herrera $ 1,785,000.00 9 meses 15% efectiva

EA 15.0000%
NOM MENSUAL 1.17149169%
CUOTA $ 54,166.67

EA 15.0000%
NOM MENSUAL 1.17149169%
CUOTA $ 120,000.00

EA 15.0000%
NOM MENSUAL 1.17149169%
CUOTA $ 161,111.11

EA 15.0000%
NOM MENSUAL 1.17149169%
CUOTA $ 138,112.00

EA 15.0000%
NOM MENSUAL 1.17149169%
CUOTA $ 198,333.33

VALOR DEL TASA

FECHA INICIAL EMPLEADO
PRESTAMO INTERES
12/1/2011 Carlos Pérez $ 650,000.00 15.00%

VALOR DEL TASA

FECHA INICIAL EMPLEADO
PRESTAMO INTERES
12/1/2011 Juan Gómez $ 1,800,000.00 15.00%

VALOR DEL TASA

FECHA INICIAL EMPLEADO
PRESTAMO INTERES
12/1/2011 Lucia Jiménez $ 5,800,000.00 15.00%

VALOR DEL TASA

FECHA INICIAL EMPLEADO
PRESTAMO INTERES
12/1/2011 Paula Rendón $ 690,560.00 15.00%
 VALOR DEL TASA
FECHA INICIAL EMPLEADO
PRESTAMO INTERES
12/1/2011 Luis Herrera $ 1,785,000.00 15.00%

Cuota Saldo Inicial cuotas Interes

1 $ 603,096 54,166.67 7,065.22
2 555,994.37 54,166.67 6,513.43
3 508,341.13 54,166.67 5,955.17
4 460,129.64 54,166.67 5,390.38
5 411,353.35 54,166.67 4,818.97
6 362,005.65 54,166.67 4,240.87
7 312,079.85 54,166.67 3,655.99
8 261,569.18 54,166.67 3,064.26
9 210,466.77 54,166.67 2,465.60
10 158,765.70 54,166.67 1,859.93
11 106,458.97 54,166.67 1,247.16
12 53,539.46 54,166.67 627.21

REGISTRO AÑO 2018

DEBITO CREDITO
Cuenta por cobrar empleados 1365 7,065.22 0
Ingresos por interes 42 0 7,065.22
Bancos 1110 54,166.67 0
Cuenta por cobrar empleados 1365 0 54,166.67

Cuota Saldo Inicial cuotas Interes

1 $ 4,710,058 161,111.11 55,177.94
2 4,604,125.01 161,111.11 53,936.94
3 4,496,950.85 161,111.11 52,681.41
4 4,388,521.14 161,111.11 51,411.16
5 4,278,821.19 161,111.11 50,126.03
6 4,167,836.11 161,111.11 48,825.85
7 4,055,550.86 161,111.11 47,510.44
8 3,941,950.19 161,111.11 46,179.62
9 3,827,018.69 161,111.11 44,833.21
10 3,710,740.79 161,111.11 43,471.02
11 3,593,100.70 161,111.11 42,092.88
12 3,474,082.46 161,111.11 40,698.59
13 3,353,669.94 161,111.11 39,287.96
14 3,231,846.79 161,111.11 37,860.82
15 3,108,596.50 161,111.11 36,416.95
16 2,983,902.34 161,111.11 34,956.17
17 2,857,747.39 161,111.11 33,478.27
18 2,730,114.56 161,111.11 31,983.07
19 2,600,986.51 161,111.11 30,470.34
20 2,470,345.74 161,111.11 28,939.90
21 2,338,174.52 161,111.11 27,391.52
22 2,204,454.93 161,111.11 25,825.01
23 2,069,168.83 161,111.11 24,240.14
24 1,932,297.86 161,111.11 22,636.71
25 1,793,823.46 161,111.11 21,014.49
26 1,653,726.84 161,111.11 19,373.27
27 1,511,989.00 161,111.11 17,712.83
28 1,368,590.71 161,111.11 16,032.93
29 1,223,512.53 161,111.11 14,333.35
30 1,076,734.77 161,111.11 12,613.86
31 928,237.51 161,111.11 10,874.23
32 778,000.63 161,111.11 9,114.21
33 626,003.73 161,111.11 7,333.58
34 472,226.20 161,111.11 5,532.09
35 316,647.18 161,111.11 3,709.50
36 159,245.56 161,111.11 1,865.55

REGISTRO AÑO 2018

DEBITO
Cuenta por cobrar empleados 55,177.94
Ingresos por interes 0
Bancos 161,111.11
Cuenta por cobrar empleados 0
CUOTAS
$ 54,167
$ 120,000
$ 161,111
$ 138,112
$ 198,333

CUOTA TASA
CUOTAS VALOR PRESENTE
MENSUAL MENSUAL
54,166.67 12 1.17% $ 603,096

CUOTA TASA
CUOTAS VALOR PRESENTE
MENSUAL MENSUAL
120,000.00 15 1.17% $ 1,641,939

CUOTA TASA
CUOTAS VALOR PRESENTE
MENSUAL MENSUAL
161,111.11 36 1.17% $ 4,710,058

CUOTA TASA
CUOTAS VALOR PRESENTE
MENSUAL MENSUAL
138,112.00 5 1.17% $ 666,939
 CUOTA TASA
CUOTAS VALOR PRESENTE
MENSUAL MENSUAL
198,333.33 9 1.17% $ 1,684,782

Capital Saldo Final Cuota Saldo Inicial

47,101.45 555,994.37 1 $ 1,641,939
47,653.24 508,341.13 2 1,541,174.02
48,211.49 460,129.64 3 1,439,228.75
48,776.29 411,353.35 4 1,336,089.19
49,347.70 362,005.65 5 1,231,741.37
49,925.80 312,079.85 6 1,126,171.12
50,510.68 261,569.18 7 1,019,364.12
51,102.41 210,466.77 8 911,305.88
51,701.07 158,765.70 9 801,981.76
52,306.74 106,458.97 10 691,376.91
52,919.51 53,539.46 11 579,476.33
53,539.46 0.00 12 466,264.85
13 351,727.10
14 235,847.55
15 118,610.49

REGISTRO AÑO 2018

Cuenta por cobrar empleados

Ingresos por interes
Bancos
Capital Saldo Final Cuenta por cobrar empleados
105,933.17 4,604,125.01
107,174.17 4,496,950.85 Cuota Saldo Inicial
108,429.71 4,388,521.14 1 $ 666,939
109,699.95 4,278,821.19 2 536,639.75
110,985.08 4,167,836.11 3 404,814.44
112,285.26 4,055,550.86 4 271,444.81
113,600.67 3,941,950.19 5 136,512.76
114,931.49 3,827,018.69
116,277.91 3,710,740.79 REGISTRO AÑO 2018
117,640.09 3,593,100.70
119,018.23 3,474,082.46 Cuenta por cobrar empleados 1365
120,412.52 3,353,669.94 Ingresos por interes 42
121,823.15 3,231,846.79 Bancos 1110
123,250.29 3,108,596.50 Cuenta por cobrar empleados 1365
124,694.16 2,983,902.34
126,154.94 2,857,747.39
127,632.84 2,730,114.56 Cuota Saldo Inicial
129,128.05 2,600,986.51 1 $ 1,684,782
130,640.77 2,470,345.74 2 1,506,186.11
132,171.22 2,338,174.52 3 1,325,497.62
133,719.59 2,204,454.93 4 1,142,692.39
135,286.10 2,069,168.83 5 957,745.60
136,870.97 1,932,297.86 6 770,632.18
138,474.40 1,793,823.46 7 581,326.73
140,096.62 1,653,726.84 8 389,803.60
141,737.84 1,511,989.00 9 196,036.78
143,398.29 1,368,590.71
145,078.18 1,223,512.53 REGISTRO AÑO 2018
146,777.76 1,076,734.77
148,497.25 928,237.51 Cuenta por cobrar empleados 1365
150,236.89 778,000.63 Ingresos por interes 42
151,996.90 626,003.73 Bancos 1110
153,777.53 472,226.20 Cuenta por cobrar empleados 1365
155,579.02 316,647.18
157,401.62 159,245.56
159,245.56 0.00

CREDITO
0
55,177.94
0
161,111.11
1110 BANCO 650000
1365 CXC EMPLEADOS 603906

53 46094

1110 BANCO 650000

1365 CXC EMPLEADOS 603906

53 46094

1110 BANCO 650000

1365 CXC EMPLEADOS 603906
53 46094

1110 BANCO 1785000

 1365 CXC EMPLEADOS 1684782

53 100218

cuotas Interes Capital Saldo Final

120,000.00 19,235.18 100,764.82 1,541,174.02
120,000.00 18,054.73 101,945.27 1,439,228.75
120,000.00 16,860.45 103,139.55 1,336,089.19
120,000.00 15,652.17 104,347.83 1,231,741.37
120,000.00 14,429.75 105,570.25 1,126,171.12
120,000.00 13,193.00 106,807.00 1,019,364.12
120,000.00 11,941.77 108,058.23 911,305.88
120,000.00 10,675.87 109,324.13 801,981.76
120,000.00 9,395.15 110,604.85 691,376.91
120,000.00 8,099.42 111,900.58 579,476.33
120,000.00 6,788.52 113,211.48 466,264.85
120,000.00 5,462.25 114,537.75 351,727.10
120,000.00 4,120.45 115,879.55 235,847.55
120,000.00 2,762.93 117,237.07 118,610.49
120,000.00 1,389.51 118,610.49 -

DEBITO CREDITO
19,235.18 0
0 19,235.18
120,000.00 0
0 120,000.00

cuotas Interes Capital Saldo Final

138,112.00 7,813.13 130,298.87 536,639.75
138,112.00 6,286.69 131,825.31 404,814.44
138,112.00 4,742.37 133,369.63 271,444.81
138,112.00 3,179.95 134,932.05 136,512.76
138,112.00 1,599.24 136,512.76 (0.00)

DEBITO CREDITO
7,813.13 0
0 7,813.13
138,112.00 0
0 138,112.00
 cuotas Interes Capital Saldo Final
198,333.33 19,737.09 178,596.25 1,506,186.11
198,333.33 17,644.85 180,688.49 1,325,497.62
198,333.33 15,528.09 182,805.24 1,142,692.39
198,333.33 13,386.55 184,946.79 957,745.60
198,333.33 11,219.91 187,113.42 770,632.18
198,333.33 9,027.89 189,305.44 581,326.73
198,333.33 6,810.19 191,523.14 389,803.60
198,333.33 4,566.52 193,766.82 196,036.78
198,333.33 2,296.55 196,036.78 0.00

DEBITO CREDITO
19,737.09 0
0 19,737.09
198,333.33 0
0 198,333.33