| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TU SÓLO DEBES LLENAR LOS ESPACIOS EN COLOR VERDE | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | NSS | Interés anual | CAT | Monto de crédito otorgado | Años (Según el histórico) | Formal préstamo | Saldo para aprovechar descuento por pago anticipado Infonavit Tradicional | |||||||||||||||||||
4 | 123456789 | 10.45% | 11.40% | $881,189.81 | 30 | 23-oct-24 | $220,297.45 | |||||||||||||||||||
5 | ||||||||||||||||||||||||||
6 | Mes | Saldo | Interés | Comisiones | Pago del crédito | Saldo final | Años reales | |||||||||||||||||||
7 | Fondo de protección de pagos | Tu retención mensual | Tu patrón aporta | Tu aportación a capital | 11.67 | |||||||||||||||||||||
8 | 1 | $881,189.81 | $7,673.69 | $174.45 | $8,349.02 | $2,746.22 | $0 | $877,942.71 | ||||||||||||||||||
9 | 2 | $877,942.71 | $7,645.42 | $174.45 | $8,349.02 | $2,746.22 | $0 | $874,667.34 | ||||||||||||||||||
10 | 3 | $874,667.34 | $7,616.89 | $174.45 | $8,349.02 | $2,746.22 | $0 | $871,363.45 | ||||||||||||||||||
11 | 4 | $871,363.45 | $7,588.12 | $174.45 | $8,349.02 | $2,746.22 | $0 | $868,030.78 | ||||||||||||||||||
12 | 5 | $868,030.78 | $7,559.10 | $174.45 | $8,349.02 | $2,746.22 | $0 | $864,669.09 | ||||||||||||||||||
13 | 6 | $864,669.09 | $7,529.83 | $174.45 | $8,349.02 | $2,746.22 | $0 | $861,278.13 | ||||||||||||||||||
14 | 7 | $861,278.13 | $7,500.30 | $174.45 | $8,349.02 | $2,746.22 | $0 | $857,857.64 | ||||||||||||||||||
15 | 8 | $857,857.64 | $7,470.51 | $174.45 | $8,349.02 | $2,746.22 | $0 | $854,407.36 | ||||||||||||||||||
16 | 9 | $854,407.36 | $7,440.46 | $174.45 | $8,349.02 | $2,746.22 | $0 | $850,927.03 | ||||||||||||||||||
17 | 10 | $850,927.03 | $7,410.16 | $174.45 | $8,349.02 | $2,746.22 | $0 | $847,416.40 | ||||||||||||||||||
18 | 11 | $847,416.40 | $7,379.58 | $174.45 | $8,349.02 | $2,746.22 | $0 | $843,875.19 | ||||||||||||||||||
19 | 12 | $843,875.19 | $7,348.75 | $174.45 | $8,349.02 | $2,746.22 | $0 | $840,303.15 | ||||||||||||||||||
20 | 13 | $840,303.15 | $7,317.64 | $174.45 | $8,349.02 | $2,746.22 | $0 | $836,700.00 | ||||||||||||||||||
21 | 14 | $836,700.00 | $7,286.26 | $174.45 | $8,349.02 | $2,746.22 | $0 | $833,065.47 | ||||||||||||||||||
22 | 15 | $833,065.47 | $7,254.61 | $174.45 | $8,349.02 | $2,746.22 | $0 | $829,399.29 | ||||||||||||||||||
23 | 16 | $829,399.29 | $7,222.69 | $174.45 | $8,349.02 | $2,746.22 | $0 | $825,701.19 | ||||||||||||||||||
24 | 17 | $825,701.19 | $7,190.48 | $174.45 | $8,349.02 | $2,746.22 | $0 | $821,970.88 | ||||||||||||||||||
25 | 18 | $821,970.88 | $7,158.00 | $174.45 | $8,349.02 | $2,746.22 | $20,000 | $798,208.08 | ||||||||||||||||||
26 | 19 | $798,208.08 | $6,951.06 | $174.45 | $8,349.02 | $2,746.22 | $0 | $794,238.36 | ||||||||||||||||||
27 | 20 | $794,238.36 | $6,916.49 | $174.45 | $8,349.02 | $2,746.22 | $0 | $790,234.06 | ||||||||||||||||||
28 | 21 | $790,234.06 | $6,881.62 | $174.45 | $8,349.02 | $2,746.22 | $0 | $786,194.89 | ||||||||||||||||||
29 | 22 | $786,194.89 | $6,846.45 | $174.45 | $8,349.02 | $2,746.22 | $0 | $782,120.55 | ||||||||||||||||||
30 | 23 | $782,120.55 | $6,810.97 | $174.45 | $8,349.02 | $2,746.22 | $0 | $778,010.72 | ||||||||||||||||||
31 | 24 | $778,010.72 | $6,775.18 | $174.45 | $8,349.02 | $2,746.22 | $10,000 | $763,865.11 | ||||||||||||||||||
32 | 25 | $763,865.11 | $6,651.99 | $174.45 | $8,349.02 | $2,746.22 | $0 | $759,596.31 | ||||||||||||||||||
33 | 26 | $759,596.31 | $6,614.82 | $174.45 | $8,349.02 | $2,746.22 | $0 | $755,290.34 | ||||||||||||||||||
34 | 27 | $755,290.34 | $6,577.32 | $174.45 | $8,349.02 | $2,746.22 | $0 | $750,946.87 | ||||||||||||||||||
35 | 28 | $750,946.87 | $6,539.50 | $174.45 | $8,349.02 | $2,746.22 | $0 | $746,565.58 | ||||||||||||||||||
36 | 29 | $746,565.58 | $6,501.34 | $174.45 | $8,349.02 | $2,746.22 | $0 | $742,146.13 | ||||||||||||||||||
37 | 30 | $742,146.13 | $6,462.86 | $174.45 | $8,349.02 | $2,746.22 | $10,000 | $727,688.19 | ||||||||||||||||||
38 | 31 | $727,688.19 | $6,336.95 | $174.45 | $8,349.02 | $2,746.22 | $0 | $723,104.36 | ||||||||||||||||||
39 | 32 | $723,104.36 | $6,297.03 | $174.45 | $8,349.02 | $2,746.22 | $0 | $718,480.60 | ||||||||||||||||||
40 | 33 | $718,480.60 | $6,256.77 | $174.45 | $8,349.02 | $2,746.22 | $0 | $713,816.58 | ||||||||||||||||||
41 | 34 | $713,816.58 | $6,216.15 | $174.45 | $8,349.02 | $2,746.22 | $0 | $709,111.94 | ||||||||||||||||||
42 | 35 | $709,111.94 | $6,175.18 | $174.45 | $8,349.02 | $2,746.22 | $0 | $704,366.33 | ||||||||||||||||||
43 | 36 | $704,366.33 | $6,133.86 | $174.45 | $8,349.02 | $2,746.22 | $25,000 | $674,579.40 | ||||||||||||||||||
44 | 37 | $674,579.40 | $5,874.46 | $174.45 | $8,349.02 | $2,746.22 | $0 | $669,533.07 | ||||||||||||||||||
45 | 38 | $669,533.07 | $5,830.52 | $174.45 | $8,349.02 | $2,746.22 | $0 | $664,442.80 | ||||||||||||||||||
46 | 39 | $664,442.80 | $5,786.19 | $174.45 | $8,349.02 | $2,746.22 | $0 | $659,308.20 | ||||||||||||||||||
47 | 40 | $659,308.20 | $5,741.48 | $174.45 | $8,349.02 | $2,746.22 | $0 | $654,128.88 | ||||||||||||||||||
48 | 41 | $654,128.88 | $5,696.37 | $174.45 | $8,349.02 | $2,746.22 | $0 | $648,904.47 | ||||||||||||||||||
49 | 42 | $648,904.47 | $5,650.88 | $174.45 | $8,349.02 | $2,746.22 | $0 | $643,634.55 | ||||||||||||||||||
50 | 43 | $643,634.55 | $5,604.98 | $174.45 | $8,349.02 | $2,746.22 | $0 | $638,318.75 | ||||||||||||||||||
51 | 44 | $638,318.75 | $5,558.69 | $174.45 | $8,349.02 | $2,746.22 | $0 | $632,956.65 | ||||||||||||||||||
52 | 45 | $632,956.65 | $5,512.00 | $174.45 | $8,349.02 | $2,746.22 | $0 | $627,547.86 | ||||||||||||||||||
53 | 46 | $627,547.86 | $5,464.90 | $174.45 | $8,349.02 | $2,746.22 | $0 | $622,091.96 | ||||||||||||||||||
54 | 47 | $622,091.96 | $5,417.38 | $174.45 | $8,349.02 | $2,746.22 | $0 | $616,588.56 | ||||||||||||||||||
55 | 48 | $616,588.56 | $5,369.46 | $174.45 | $8,349.02 | $2,746.22 | $0 | $611,037.23 | ||||||||||||||||||
56 | 49 | $611,037.23 | $5,321.12 | $174.45 | $8,349.02 | $2,746.22 | $0 | $605,437.55 | ||||||||||||||||||
57 | 50 | $605,437.55 | $5,272.35 | $174.45 | $8,349.02 | $2,746.22 | $0 | $599,789.11 | ||||||||||||||||||
58 | 51 | $599,789.11 | $5,223.16 | $174.45 | $8,349.02 | $2,746.22 | $0 | $594,091.49 | ||||||||||||||||||
59 | 52 | $594,091.49 | $5,173.55 | $174.45 | $8,349.02 | $2,746.22 | $0 | $588,344.24 | ||||||||||||||||||
60 | 53 | $588,344.24 | $5,123.50 | $174.45 | $8,349.02 | $2,746.22 | $0 | $582,546.95 | ||||||||||||||||||
61 | 54 | $582,546.95 | $5,073.01 | $174.45 | $8,349.02 | $2,746.22 | $0 | $576,699.18 | ||||||||||||||||||
62 | 55 | $576,699.18 | $5,022.09 | $174.45 | $8,349.02 | $2,746.22 | $0 | $570,800.47 | ||||||||||||||||||
63 | 56 | $570,800.47 | $4,970.72 | $174.45 | $8,349.02 | $2,746.22 | $0 | $564,850.40 | ||||||||||||||||||
64 | 57 | $564,850.40 | $4,918.91 | $174.45 | $8,349.02 | $2,746.22 | $0 | $558,848.52 | ||||||||||||||||||
65 | 58 | $558,848.52 | $4,866.64 | $174.45 | $8,349.02 | $2,746.22 | $0 | $552,794.37 | ||||||||||||||||||
66 | 59 | $552,794.37 | $4,813.92 | $174.45 | $8,349.02 | $2,746.22 | $0 | $546,687.50 | ||||||||||||||||||
67 | 60 | $546,687.50 | $4,760.74 | $174.45 | $8,349.02 | $2,746.22 | $0 | $540,527.44 | ||||||||||||||||||
68 | 61 | $540,527.44 | $4,707.09 | $174.45 | $8,349.02 | $2,746.22 | $0 | $534,313.75 | ||||||||||||||||||
69 | 62 | $534,313.75 | $4,652.98 | $174.45 | $8,349.02 | $2,746.22 | $0 | $528,045.94 | ||||||||||||||||||
70 | 63 | $528,045.94 | $4,598.40 | $174.45 | $8,349.02 | $2,746.22 | $0 | $521,723.55 | ||||||||||||||||||
71 | 64 | $521,723.55 | $4,543.34 | $174.45 | $8,349.02 | $2,746.22 | $0 | $515,346.10 | ||||||||||||||||||
72 | 65 | $515,346.10 | $4,487.81 | $174.45 | $8,349.02 | $2,746.22 | $0 | $508,913.12 | ||||||||||||||||||
73 | 66 | $508,913.12 | $4,431.79 | $174.45 | $8,349.02 | $2,746.22 | $0 | $502,424.11 | ||||||||||||||||||
74 | 67 | $502,424.11 | $4,375.28 | $174.45 | $8,349.02 | $2,746.22 | $0 | $495,878.60 | ||||||||||||||||||
75 | 68 | $495,878.60 | $4,318.28 | $174.45 | $8,349.02 | $2,746.22 | $0 | $489,276.09 | ||||||||||||||||||
76 | 69 | $489,276.09 | $4,260.78 | $174.45 | $8,349.02 | $2,746.22 | $0 | $482,616.07 | ||||||||||||||||||
77 | 70 | $482,616.07 | $4,202.78 | $174.45 | $8,349.02 | $2,746.22 | $0 | $475,898.07 | ||||||||||||||||||
78 | 71 | $475,898.07 | $4,144.28 | $174.45 | $8,349.02 | $2,746.22 | $0 | $469,121.56 | ||||||||||||||||||
79 | 72 | $469,121.56 | $4,085.27 | $174.45 | $8,349.02 | $2,746.22 | $0 | $462,286.03 | ||||||||||||||||||
80 | 73 | $462,286.03 | $4,025.74 | $174.45 | $8,349.02 | $2,746.22 | $0 | $455,390.98 | ||||||||||||||||||
81 | 74 | $455,390.98 | $3,965.70 | $174.45 | $8,349.02 | $2,746.22 | $0 | $448,435.89 | ||||||||||||||||||
82 | 75 | $448,435.89 | $3,905.13 | $174.45 | $8,349.02 | $2,746.22 | $0 | $441,420.23 | ||||||||||||||||||
83 | 76 | $441,420.23 | $3,844.03 | $174.45 | $8,349.02 | $2,746.22 | $0 | $434,343.47 | ||||||||||||||||||
84 | 77 | $434,343.47 | $3,782.41 | $174.45 | $8,349.02 | $2,746.22 | $0 | $427,205.09 | ||||||||||||||||||
85 | 78 | $427,205.09 | $3,720.24 | $174.45 | $8,349.02 | $2,746.22 | $0 | $420,004.55 | ||||||||||||||||||
86 | 79 | $420,004.55 | $3,657.54 | $174.45 | $8,349.02 | $2,746.22 | $0 | $412,741.30 | ||||||||||||||||||
87 | 80 | $412,741.30 | $3,594.29 | $174.45 | $8,349.02 | $2,746.22 | $0 | $405,414.79 | ||||||||||||||||||
88 | 81 | $405,414.79 | $3,530.49 | $174.45 | $8,349.02 | $2,746.22 | $0 | $398,024.49 | ||||||||||||||||||
89 | 82 | $398,024.49 | $3,466.13 | $174.45 | $8,349.02 | $2,746.22 | $0 | $390,569.83 | ||||||||||||||||||
90 | 83 | $390,569.83 | $3,401.21 | $174.45 | $8,349.02 | $2,746.22 | $0 | $383,050.25 | ||||||||||||||||||
91 | 84 | $383,050.25 | $3,335.73 | $174.45 | $8,349.02 | $2,746.22 | $0 | $375,465.19 | ||||||||||||||||||
92 | 85 | $375,465.19 | $3,269.68 | $174.45 | $8,349.02 | $2,746.22 | $0 | $367,814.08 | ||||||||||||||||||
93 | 86 | $367,814.08 | $3,203.05 | $174.45 | $8,349.02 | $2,746.22 | $0 | $360,096.34 | ||||||||||||||||||
94 | 87 | $360,096.34 | $3,135.84 | $174.45 | $8,349.02 | $2,746.22 | $0 | $352,311.39 | ||||||||||||||||||
95 | 88 | $352,311.39 | $3,068.04 | $174.45 | $8,349.02 | $2,746.22 | $0 | $344,458.64 | ||||||||||||||||||
96 | 89 | $344,458.64 | $2,999.66 | $174.45 | $8,349.02 | $2,746.22 | $0 | $336,537.51 | ||||||||||||||||||
97 | 90 | $336,537.51 | $2,930.68 | $174.45 | $8,349.02 | $2,746.22 | $0 | $328,547.40 | ||||||||||||||||||
98 | 91 | $328,547.40 | $2,861.10 | $174.45 | $8,349.02 | $2,746.22 | $0 | $320,487.71 | ||||||||||||||||||
99 | 92 | $320,487.71 | $2,790.91 | $174.45 | $8,349.02 | $2,746.22 | $0 | $312,357.84 | ||||||||||||||||||
100 | 93 | $312,357.84 | $2,720.12 | $174.45 | $8,349.02 | $2,746.22 | $0 | $304,157.16 | ||||||||||||||||||