Funciones Financieras

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 23

Monto (VA) ($761.

00) Tiempo
Tasa 18% anual Tasa
Tiempo 3 años Cuota
Pago $ 350.00 Monto (VA)
10 años
7.50% anual
$ 300.00
($2,059.22)
Tasa 18% annual Pago 200
Pago $ 350.00 Tasa 3%
Tiempo 3 años Tiempo 10
Vf $1,250.34 VF $2,329.02
VA $761.00
anual
anual
años
Monto (VA) $ 10,000.00 Monto (VA)
No. periodos 24 trimestres Tiempo
Tasa 36% annual Tasa
Cuota inicial $945.16 Cuota
Cuota final $1,030.23
$ 25,000.00
8 años
12% annual
$5,032.57 annual
$406.32 mensual
Monto $ 5,000.00 Monto 52000
Tiempo 36 meses Tiempo 8 años
Cuota 150 mensuales Cuota 900 mensuales
Tasas 5.06% annual Tasa 14% annual
Monto 12000 Monto
Tasa 15% annual Tasa
Cuota 350 mensual Cuota
No. periodos 45 No. periodos
$ 45,000.00
11% annual
$ 700.00 mensual
98 meses
8 AÑOS
Monto $ 5,000.00 Periodo Cuota A principal A intereses
No. periodos 36 meses 1 $209.53 $88.70 $120.83
Tasa 29% annual 2 $209.53 $90.84 $118.69
Cuota $209.53 mensual 3 $209.53 $93.03 $116.49
4 $209.53 $95.28 $114.25
5 $209.53 $97.58 $111.94
6 $209.53 $99.94 $109.59
7 $209.53 $102.36 $107.17
8 $209.53 $104.83 $104.70
9 $209.53 $107.37 $102.16
10 $209.53 $109.96 $99.57
11 $209.53 $112.62 $96.91
12 $209.53 $115.34 $94.19
13 $209.53 $118.13 $91.40
14 $209.53 $120.98 $88.55
15 $209.53 $123.91 $85.62
16 $209.53 $126.90 $82.63
17 $209.53 $129.97 $79.56
18 $209.53 $133.11 $76.42
19 $209.53 $136.32 $73.20
20 $209.53 $139.62 $69.91
21 $209.53 $142.99 $66.54
22 $209.53 $146.45 $63.08
23 $209.53 $149.99 $59.54
24 $209.53 $153.61 $55.92
25 $209.53 $157.32 $52.20
26 $209.53 $161.13 $48.40
27 $209.53 $165.02 $44.51
28 $209.53 $169.01 $40.52
29 $209.53 $173.09 $36.44
30 $209.53 $177.28 $32.25
31 $209.53 $181.56 $27.97
32 $209.53 $185.95 $23.58
33 $209.53 $190.44 $19.09
34 $209.53 $195.04 $14.49
35 $209.53 $199.76 $9.77
36 $209.53 $204.58 $4.94
Saldo
$4,911.30
$4,820.47
$4,727.43
$4,632.15
$4,534.56
$4,434.62
$4,332.26
$4,227.43
$4,120.07
$4,010.10
$3,897.49
$3,782.15
$3,664.02
$3,543.04
$3,419.13
$3,292.24
$3,162.27
$3,029.16
$2,892.84
$2,753.22
$2,610.23
$2,463.78
$2,313.79
$2,160.18
$2,002.86
$1,841.73
$1,676.71
$1,507.70
$1,334.61
$1,157.33
$975.77
$789.83
$599.38
$404.34
$204.58
$0.00
Monto $ 90,000.00 Periodo Cuota total Cuota
Tasa 6% annual 1 $ 719.79 $644.79
No. periodos 20 años 240 meses 2 $ 719.79 $644.79
Cuota $644.79 mensual 3 $ 719.79 $644.79
Seguro (1%) $ 75.00 4 $ 719.79 $644.79
cuota total $ 719.79 5 $ 719.79 $644.79
6 $ 719.79 $644.79
7 $ 719.79 $644.79
8 $ 719.79 $644.79
9 $ 719.79 $644.79
10 $ 719.79 $644.79
11 $ 719.79 $644.79
12 $ 719.79 $644.79
13 $ 719.79 $644.79
14 $ 719.79 $644.79
15 $ 719.79 $644.79
16 $ 719.79 $644.79
17 $ 719.79 $644.79
18 $ 719.79 $644.79
19 $ 719.79 $644.79
20 $ 719.79 $644.79
21 $ 719.79 $644.79
22 $ 719.79 $644.79
23 $ 719.79 $644.79
24 $ 719.79 $644.79
25 $ 719.79 $644.79
26 $ 719.79 $644.79
27 $ 719.79 $644.79
28 $ 719.79 $644.79
29 $ 719.79 $644.79
30 $ 719.79 $644.79
31 $ 719.79 $644.79
32 $ 719.79 $644.79
33 $ 719.79 $644.79
34 $ 719.79 $644.79
35 $ 719.79 $644.79
36 $ 719.79 $644.79
37 $ 719.79 $644.79
38 $ 719.79 $644.79
39 $ 719.79 $644.79
40 $ 719.79 $644.79
41 $ 719.79 $644.79
42 $ 719.79 $644.79
43 $ 719.79 $644.79
44 $ 719.79 $644.79
45 $ 719.79 $644.79
46 $ 719.79 $644.79
47 $ 719.79 $644.79
48 $ 719.79 $644.79
49 $ 719.79 $644.79
50 $ 719.79 $644.79
51 $ 719.79 $644.79
52 $ 719.79 $644.79
53 $ 719.79 $644.79
54 $ 719.79 $644.79
55 $ 719.79 $644.79
56 $ 719.79 $644.79
57 $ 719.79 $644.79
58 $ 719.79 $644.79
59 $ 719.79 $644.79
60 $ 719.79 $644.79
61 $ 719.79 $644.79
62 $ 719.79 $644.79
63 $ 719.79 $644.79
64 $ 719.79 $644.79
65 $ 719.79 $644.79
66 $ 719.79 $644.79
67 $ 719.79 $644.79
68 $ 719.79 $644.79
69 $ 719.79 $644.79
70 $ 719.79 $644.79
71 $ 719.79 $644.79
72 $ 719.79 $644.79
73 $ 719.79 $644.79
74 $ 719.79 $644.79
75 $ 719.79 $644.79
76 $ 719.79 $644.79
77 $ 719.79 $644.79
78 $ 719.79 $644.79
79 $ 719.79 $644.79
80 $ 719.79 $644.79
81 $ 719.79 $644.79
82 $ 719.79 $644.79
83 $ 719.79 $644.79
84 $ 719.79 $644.79
85 $ 719.79 $644.79
86 $ 719.79 $644.79
87 $ 719.79 $644.79
88 $ 719.79 $644.79
89 $ 719.79 $644.79
90 $ 719.79 $644.79
91 $ 719.79 $644.79
92 $ 719.79 $644.79
93 $ 719.79 $644.79
94 $ 719.79 $644.79
95 $ 719.79 $644.79
96 $ 719.79 $644.79
97 $ 719.79 $644.79
98 $ 719.79 $644.79
99 $ 719.79 $644.79
100 $ 719.79 $644.79
101 $ 719.79 $644.79
102 $ 719.79 $644.79
103 $ 719.79 $644.79
104 $ 719.79 $644.79
105 $ 719.79 $644.79
106 $ 719.79 $644.79
107 $ 719.79 $644.79
108 $ 719.79 $644.79
109 $ 719.79 $644.79
110 $ 719.79 $644.79
111 $ 719.79 $644.79
112 $ 719.79 $644.79
113 $ 719.79 $644.79
114 $ 719.79 $644.79
115 $ 719.79 $644.79
116 $ 719.79 $644.79
117 $ 719.79 $644.79
118 $ 719.79 $644.79
119 $ 719.79 $644.79
120 $ 719.79 $644.79
121 $ 719.79 $644.79
122 $ 719.79 $644.79
123 $ 719.79 $644.79
124 $ 719.79 $644.79
125 $ 719.79 $644.79
126 $ 719.79 $644.79
127 $ 719.79 $644.79
128 $ 719.79 $644.79
129 $ 719.79 $644.79
130 $ 719.79 $644.79
131 $ 719.79 $644.79
132 $ 719.79 $644.79
133 $ 719.79 $644.79
134 $ 719.79 $644.79
135 $ 719.79 $644.79
136 $ 719.79 $644.79
137 $ 719.79 $644.79
138 $ 719.79 $644.79
139 $ 719.79 $644.79
140 $ 719.79 $644.79
141 $ 719.79 $644.79
142 $ 719.79 $644.79
143 $ 719.79 $644.79
144 $ 719.79 $644.79
145 $ 719.79 $644.79
146 $ 719.79 $644.79
147 $ 719.79 $644.79
148 $ 719.79 $644.79
149 $ 719.79 $644.79
150 $ 719.79 $644.79
151 $ 719.79 $644.79
152 $ 719.79 $644.79
153 $ 719.79 $644.79
154 $ 719.79 $644.79
155 $ 719.79 $644.79
156 $ 719.79 $644.79
157 $ 719.79 $644.79
158 $ 719.79 $644.79
159 $ 719.79 $644.79
160 $ 719.79 $644.79
161 $ 719.79 $644.79
162 $ 719.79 $644.79
163 $ 719.79 $644.79
164 $ 719.79 $644.79
165 $ 719.79 $644.79
166 $ 719.79 $644.79
167 $ 719.79 $644.79
168 $ 719.79 $644.79
169 $ 719.79 $644.79
170 $ 719.79 $644.79
171 $ 719.79 $644.79
172 $ 719.79 $644.79
173 $ 719.79 $644.79
174 $ 719.79 $644.79
175 $ 719.79 $644.79
176 $ 719.79 $644.79
177 $ 719.79 $644.79
178 $ 719.79 $644.79
179 $ 719.79 $644.79
180 $ 719.79 $644.79
181 $ 719.79 $644.79
182 $ 719.79 $644.79
183 $ 719.79 $644.79
184 $ 719.79 $644.79
185 $ 719.79 $644.79
186 $ 719.79 $644.79
187 $ 719.79 $644.79
188 $ 719.79 $644.79
189 $ 719.79 $644.79
190 $ 719.79 $644.79
191 $ 719.79 $644.79
192 $ 719.79 $644.79
193 $ 719.79 $644.79
194 $ 719.79 $644.79
195 $ 719.79 $644.79
196 $ 719.79 $644.79
197 $ 719.79 $644.79
198 $ 719.79 $644.79
199 $ 719.79 $644.79
200 $ 719.79 $644.79
201 $ 719.79 $644.79
202 $ 719.79 $644.79
203 $ 719.79 $644.79
204 $ 719.79 $644.79
205 $ 719.79 $644.79
206 $ 719.79 $644.79
207 $ 719.79 $644.79
208 $ 719.79 $644.79
209 $ 719.79 $644.79
210 $ 719.79 $644.79
211 $ 719.79 $644.79
212 $ 719.79 $644.79
213 $ 719.79 $644.79
214 $ 719.79 $644.79
215 $ 719.79 $644.79
216 $ 719.79 $644.79
217 $ 719.79 $644.79
218 $ 719.79 $644.79
219 $ 719.79 $644.79
220 $ 719.79 $644.79
221 $ 719.79 $644.79
222 $ 719.79 $644.79
223 $ 719.79 $644.79
224 $ 719.79 $644.79
225 $ 719.79 $644.79
226 $ 719.79 $644.79
227 $ 719.79 $644.79
228 $ 719.79 $644.79
229 $ 719.79 $644.79
230 $ 719.79 $644.79
231 $ 719.79 $644.79
232 $ 719.79 $644.79
233 $ 719.79 $644.79
234 $ 719.79 $644.79
235 $ 719.79 $644.79
236 $ 719.79 $644.79
237 $ 719.79 $644.79
238 $ 719.79 $644.79
239 $ 719.79 $644.79
240 $ 719.79 $644.79
A principal A intereses Saldo
$194.79 $450.00 $89,805.21
$195.76 $449.03 $89,609.45
$196.74 $448.05 $89,412.71
$197.72 $447.06 $89,214.99
$198.71 $446.07 $89,016.27
$199.71 $445.08 $88,816.57
$200.71 $444.08 $88,615.86
$201.71 $443.08 $88,414.15
$202.72 $442.07 $88,211.43
$203.73 $441.06 $88,007.70
$204.75 $440.04 $87,802.95
$205.77 $439.01 $87,597.18
$206.80 $437.99 $87,390.38
$207.84 $436.95 $87,182.54
$208.88 $435.91 $86,973.67
$209.92 $434.87 $86,763.75
$210.97 $433.82 $86,552.78
$212.02 $432.76 $86,340.75
$213.08 $431.70 $86,127.67
$214.15 $430.64 $85,913.52
$215.22 $429.57 $85,698.30
$216.30 $428.49 $85,482.00
$217.38 $427.41 $85,264.63
$218.46 $426.32 $85,046.16
$219.56 $425.23 $84,826.60
$220.65 $424.13 $84,605.95
$221.76 $423.03 $84,384.19
$222.87 $421.92 $84,161.32
$223.98 $420.81 $83,937.34
$225.10 $419.69 $83,712.24
$226.23 $418.56 $83,486.01
$227.36 $417.43 $83,258.66
$228.49 $416.29 $83,030.16
$229.64 $415.15 $82,800.53
$230.79 $414.00 $82,569.74
$231.94 $412.85 $82,337.80
$233.10 $411.69 $82,104.70
$234.26 $410.52 $81,870.44
$235.44 $409.35 $81,635.00
$236.61 $408.18 $81,398.39
$237.80 $406.99 $81,160.59
$238.98 $405.80 $80,921.61
$240.18 $404.61 $80,681.43
$241.38 $403.41 $80,440.05
$242.59 $402.20 $80,197.46
$243.80 $400.99 $79,953.66
$245.02 $399.77 $79,708.64
$246.24 $398.54 $79,462.39
$247.48 $397.31 $79,214.92
$248.71 $396.07 $78,966.20
$249.96 $394.83 $78,716.25
$251.21 $393.58 $78,465.04
$252.46 $392.33 $78,212.58
$253.73 $391.06 $77,958.85
$254.99 $389.79 $77,703.86
$256.27 $388.52 $77,447.59
$257.55 $387.24 $77,190.04
$258.84 $385.95 $76,931.20
$260.13 $384.66 $76,671.07
$261.43 $383.36 $76,409.64
$262.74 $382.05 $76,146.90
$264.05 $380.73 $75,882.85
$265.37 $379.41 $75,617.47
$266.70 $378.09 $75,350.77
$268.03 $376.75 $75,082.74
$269.37 $375.41 $74,813.36
$270.72 $374.07 $74,542.64
$272.07 $372.71 $74,270.57
$273.44 $371.35 $73,997.13
$274.80 $369.99 $73,722.33
$276.18 $368.61 $73,446.15
$277.56 $367.23 $73,168.60
$278.94 $365.84 $72,889.65
$280.34 $364.45 $72,609.31
$281.74 $363.05 $72,327.57
$283.15 $361.64 $72,044.42
$284.57 $360.22 $71,759.85
$285.99 $358.80 $71,473.87
$287.42 $357.37 $71,186.45
$288.86 $355.93 $70,897.59
$290.30 $354.49 $70,607.29
$291.75 $353.04 $70,315.54
$293.21 $351.58 $70,022.33
$294.68 $350.11 $69,727.65
$296.15 $348.64 $69,431.50
$297.63 $347.16 $69,133.87
$299.12 $345.67 $68,834.75
$300.61 $344.17 $68,534.14
$302.12 $342.67 $68,232.02
$303.63 $341.16 $67,928.39
$305.15 $339.64 $67,623.25
$306.67 $338.12 $67,316.58
$308.21 $336.58 $67,008.37
$309.75 $335.04 $66,698.63
$311.29 $333.49 $66,387.33
$312.85 $331.94 $66,074.48
$314.42 $330.37 $65,760.06
$315.99 $328.80 $65,444.08
$317.57 $327.22 $65,126.51
$319.16 $325.63 $64,807.35
$320.75 $324.04 $64,486.60
$322.35 $322.43 $64,164.25
$323.97 $320.82 $63,840.28
$325.59 $319.20 $63,514.69
$327.21 $317.57 $63,187.48
$328.85 $315.94 $62,858.63
$330.49 $314.29 $62,528.13
$332.15 $312.64 $62,195.99
$333.81 $310.98 $61,862.18
$335.48 $309.31 $61,526.70
$337.15 $307.63 $61,189.55
$338.84 $305.95 $60,850.71
$340.53 $304.25 $60,510.17
$342.24 $302.55 $60,167.94
$343.95 $300.84 $59,823.99
$345.67 $299.12 $59,478.32
$347.40 $297.39 $59,130.92
$349.13 $295.65 $58,781.79
$350.88 $293.91 $58,430.91
$352.63 $292.15 $58,078.28
$354.40 $290.39 $57,723.88
$356.17 $288.62 $57,367.71
$357.95 $286.84 $57,009.76
$359.74 $285.05 $56,650.02
$361.54 $283.25 $56,288.49
$363.35 $281.44 $55,925.14
$365.16 $279.63 $55,559.98
$366.99 $277.80 $55,192.99
$368.82 $275.96 $54,824.17
$370.67 $274.12 $54,453.50
$372.52 $272.27 $54,080.98
$374.38 $270.40 $53,706.60
$376.25 $268.53 $53,330.34
$378.14 $266.65 $52,952.21
$380.03 $264.76 $52,572.18
$381.93 $262.86 $52,190.25
$383.84 $260.95 $51,806.41
$385.76 $259.03 $51,420.66
$387.68 $257.10 $51,032.97
$389.62 $255.16 $50,643.35
$391.57 $253.22 $50,251.78
$393.53 $251.26 $49,858.25
$395.50 $249.29 $49,462.75
$397.47 $247.31 $49,065.28
$399.46 $245.33 $48,665.82
$401.46 $243.33 $48,264.36
$403.47 $241.32 $47,860.89
$405.48 $239.30 $47,455.41
$407.51 $237.28 $47,047.90
$409.55 $235.24 $46,638.35
$411.60 $233.19 $46,226.75
$413.65 $231.13 $45,813.10
$415.72 $229.07 $45,397.38
$417.80 $226.99 $44,979.58
$419.89 $224.90 $44,559.69
$421.99 $222.80 $44,137.70
$424.10 $220.69 $43,713.60
$426.22 $218.57 $43,287.38
$428.35 $216.44 $42,859.03
$430.49 $214.30 $42,428.53
$432.65 $212.14 $41,995.89
$434.81 $209.98 $41,561.08
$436.98 $207.81 $41,124.10
$439.17 $205.62 $40,684.93
$441.36 $203.42 $40,243.57
$443.57 $201.22 $39,800.00
$445.79 $199.00 $39,354.21
$448.02 $196.77 $38,906.19
$450.26 $194.53 $38,455.93
$452.51 $192.28 $38,003.43
$454.77 $190.02 $37,548.66
$457.04 $187.74 $37,091.61
$459.33 $185.46 $36,632.28
$461.63 $183.16 $36,170.65
$463.93 $180.85 $35,706.72
$466.25 $178.53 $35,240.47
$468.59 $176.20 $34,771.88
$470.93 $173.86 $34,300.95
$473.28 $171.50 $33,827.67
$475.65 $169.14 $33,352.02
$478.03 $166.76 $32,873.99
$480.42 $164.37 $32,393.57
$482.82 $161.97 $31,910.75
$485.23 $159.55 $31,425.52
$487.66 $157.13 $30,937.86
$490.10 $154.69 $30,447.76
$492.55 $152.24 $29,955.21
$495.01 $149.78 $29,460.20
$497.49 $147.30 $28,962.71
$499.97 $144.81 $28,462.74
$502.47 $142.31 $27,960.26
$504.99 $139.80 $27,455.28
$507.51 $137.28 $26,947.76
$510.05 $134.74 $26,437.72
$512.60 $132.19 $25,925.12
$515.16 $129.63 $25,409.95
$517.74 $127.05 $24,892.22
$520.33 $124.46 $24,371.89
$522.93 $121.86 $23,848.96
$525.54 $119.24 $23,323.42
$528.17 $116.62 $22,795.25
$530.81 $113.98 $22,264.43
$533.47 $111.32 $21,730.97
$536.13 $108.65 $21,194.84
$538.81 $105.97 $20,656.02
$541.51 $103.28 $20,114.51
$544.22 $100.57 $19,570.30
$546.94 $97.85 $19,023.36
$549.67 $95.12 $18,473.69
$552.42 $92.37 $17,921.27
$555.18 $89.61 $17,366.09
$557.96 $86.83 $16,808.13
$560.75 $84.04 $16,247.38
$563.55 $81.24 $15,683.83
$566.37 $78.42 $15,117.46
$569.20 $75.59 $14,548.26
$572.05 $72.74 $13,976.22
$574.91 $69.88 $13,401.31
$577.78 $67.01 $12,823.53
$580.67 $64.12 $12,242.86
$583.57 $61.21 $11,659.29
$586.49 $58.30 $11,072.79
$589.42 $55.36 $10,483.37
$592.37 $52.42 $9,891.00
$595.33 $49.45 $9,295.67
$598.31 $46.48 $8,697.36
$601.30 $43.49 $8,096.06
$604.31 $40.48 $7,491.75
$607.33 $37.46 $6,884.42
$610.37 $34.42 $6,274.05
$613.42 $31.37 $5,660.63
$616.48 $28.30 $5,044.15
$619.57 $25.22 $4,424.58
$622.67 $22.12 $3,801.92
$625.78 $19.01 $3,176.14
$628.91 $15.88 $2,547.23
$632.05 $12.74 $1,915.18
$635.21 $9.58 $1,279.97
$638.39 $6.40 $641.58
$641.58 $3.21 $0.00

You might also like