Deus é FielANO SEMES TRIMES MÊS DIA

Conversor de Taxas - Juros Compostos1 2 4 12 360

Taxa Conhecida: 2 a.a Colaborador: Paulo Ricardo Peixoto Lira

Taxa que se quer: 12 a.m Última Atualização: 11/05/2011

Taxa Encontrada: 0.1652% a.m 0.002

Exemplo: Se quiser saber, por exemplo, qual taxa (ao mês) é equivalente à 16% ao ano, coloque:

Taxa Conhecida: 16 a.a

Taxa que se quer: 12 a.m

Cálculo de Montante Antecipação/Atraso

M = C( 1+ i )ⁿMontante Capital Tomado:

R$ 10,000.00 Data do Vencimento:

Valor Final:

Juros: R$ R$ 1,128.14 Taxa de Juro(a.m):

Capital: R$ 8,871.86 Nº de Parcelas:

Taxa de Juro:(a.m) 0.5000% a.m Data do Evento:

Tempo: (meses) 24.00

Tabela PriceTaxa de Juro(a.m):

Capital Tomado:

Parcela R$ 78.80 Nº de Parcelas:

Juros: R$ 418.42 Média Juro na Parcela :

Total: R$ 1,418.42

78.8008343 R$ 1,418.42 R$ 418.42 R$ 23.25

Deus é Fiel

Conversor de Taxas - Juros Compostos

senha: basa

Colaborador: Paulo Ricardo Peixoto Lira

Última Atualização: 11/05/2011

0.002 Preencher apenas as células em Verde

Se quiser saber, por exemplo, qual taxa (ao mês) é equivalente à 16% ao ano, coloque:

Taxa ao mês: 1.244514 %

Antecipação/Atraso

743.56 Valor Final

12/31/2011975.61

R$ 1,000.00

2.50% Desconto/Juros:

1224.39

12/1/2011

3.971,000.00

18

Para saber as fórmulas acompanhe as linhas ocultas

23.25

Sistema de Amortização PRICE - Incidência de IOF

EmpréstimoJurosPrazoIOF Fixo

Prazo Saldo Devedor Amortização Juros Prestação Alíquota IOF Valor IOF Soma IOF1 4,500.00 58.72 177.30 236.02 0.13% 0.07 0.072 4,441.28 61.03 174.99 236.02 0.25% 0.15 0.233 4,380.25 63.44 172.58 236.02 0.38% 0.24 0.464 4,316.82 65.93 170.08 236.02 0.50% 0.33 0.795 4,250.88 68.53 167.48 236.02 0.63% 0.43 1.226 4,182.35 71.23 164.78 236.02 0.75% 0.54 1.767 4,111.12 74.04 161.98 236.02 0.88% 0.65 2.418 4,037.08 76.96 159.06 236.02 1.00% 0.77 3.189 3,960.12 79.99 156.03 236.02 1.13% 0.90 4.0810 3,880.13 83.14 152.88 236.02 1.25% 1.04 5.1211 3,796.99 86.42 149.60 236.02 1.38% 1.19 6.3112 3,710.58 89.82 146.20 236.02 1.50% 1.35 7.6613 3,621 93.36 142.66 236.02 1.63% 1.52 9.1814 3527.40 97.04 138.98 236.02 1.75% 1.70 10.8915 3430.36 100.86 135.16 236.02 1.88% 1.90 12.7816 3329.50 104.84 131.18 236.02 2.00% 2.10 14.8817 3224.66 108.97 127.05 236.02 2.13% 2.32 17.2018 3115.70 113.26 122.76 236.02 2.26% 2.55 19.7619 3002.44 117.72 118.30 236.02 2.38% 2.80 22.5620 2884.72 122.36 113.66 236.02 2.51% 3.07 25.6321 2762.36 127.18 108.84 236.02 2.63% 3.35 28.9722 2635.18 132.19 103.83 236.02 2.76% 3.64 32.6223 2502.98 137.40 98.62 236.02 2.88% 3.96 36.5824 2365.58 142.81 93.20 236.02 3.01% 4.29 40.8725 2222.77 148.44 87.58 236.02 3.13% 4.65 45.5226 2074.33 154.29 81.73 236.02 3.26% 5.03 50.5427 1920.04 160.37 75.65 236.02 3.38% 5.42 55.9728 1759.67 166.69 69.33 236.02 3.51% 5.85 61.8229 1592.99 173.25 62.76 236.02 3.63% 6.29 68.1130 1419.74 180.08 55.94 236.02 3.76% 6.77 74.8831 1239.66 187.17 48.84 236.02 3.88% 7.27 82.1532 1052.48 194.55 41.47 236.02 4.01% 7.80 89.9533 857.93 202.21 33.80 236.02 4.13% 8.36 98.3134 655.72 210.18 25.84 236.02 4.26% 8.95 107.2735 445.53 218.46 17.55 236.02 4.39% 9.58 116.8536 227.07 227.07 8.95 236.02 4.51% 10.24 127.0937 0.00 236.02 0.00 236.02 4.64% 10.94 138.0338 -236.02 245.32 -9.30 236.02 4.76% 11.68 149.7139 -481.33 254.98 -18.96 236.02 4.89% 12.46 162.1740 -736.32 265.03 -29.01 236.02 5.01% 13.28 175.4541 -1001.34 275.47 -39.45 236.02 5.14% 14.15 189.6042 -1276.81 286.32 -50.31 236.02 5.26% 15.07 204.6743 -1563.14 297.60 -61.59 236.02 5.39% 16.03 220.7044 -1860.74 309.33 -73.31 236.02 5.51% 17.05 237.7645 -2170.07 321.52 -85.50 236.02 5.64% 18.13 255.8846 -2491.59 334.19 -98.17 236.02 5.76% 19.26 275.1447 -2825.78 347.35 -111.34 236.02 5.89% 20.45 295.6048 -3173.13 361.04 -125.02 236.02 6.01% 21.71 317.31

4,500.003.9400%

3617.10

IOF Total 17.1017.1717.3317.5617.8918.3218.8619.5120.2821.1822.2223.4124.7626.2827.9929.8831.9834.3036.8639.6642.7346.0749.7253.6857.9762.6267.6473.0778.9285.2191.9899.25

107.05115.41124.37133.95144.19155.13166.81179.27192.55206.70221.77237.80254.86272.98292.24312.70334.41

Cálculo de IOFPrazo Parcela Valor Presente Alíquota IOF Valor IOF Soma IOF IOF TOTAL01 236.02 227.07 0.13% 0.28 0.28 17.3802 236.02 218.46 0.25% 0.55 0.83 17.9303 236.02 210.18 0.38% 0.79 1.62 18.7204 236.02 202.21 0.50% 1.01 2.63 19.7305 236.02 194.55 0.63% 1.22 3.85 20.9506 236.02 187.17 0.75% 1.40 5.25 22.3507 236.02 180.08 0.88% 1.58 6.82 23.9208 236.02 173.25 1.00% 1.73 8.56 25.6609 236.02 166.69 1.13% 1.88 10.43 27.5310 236.02 160.37 1.25% 2.00 12.44 29.5411 236.02 154.29 1.37% 2.12 14.56 31.6612 236.02 148.44 1.50% 2.23 16.79 33.8913 236.02 142.81 1.62% 2.32 19.11 36.2114 236.02 137.40 1.75% 2.40 21.51 38.6115 236.02 132.19 1.88% 2.48 23.99 41.0916 236.02 127.18 2.00% 2.54 26.53 43.6317 236.02 122.36 2.13% 2.60 29.13 46.2318 236.02 117.72 2.25% 2.65 31.78 48.8819 236.02 113.26 2.38% 2.69 34.47 51.5720 236.02 108.97 2.50% 2.72 37.20 54.3021 236.02 104.84 2.63% 2.75 39.95 57.0522 236.02 100.86 2.75% 2.77 42.72 59.8223 236.02 97.04 2.88% 2.79 45.51 62.6124 236.02 93.36 3.00% 2.80 48.31 65.4125 236.02 89.82 3.13% 2.81 51.12 68.2226 236.02 86.42 3.25% 2.81 53.93 71.0327 236.02 83.14 3.38% 2.81 56.73 73.8328 236.02 79.99 3.50% 2.80 59.53 76.6329 236.02 76.96 3.63% 2.79 62.32 79.4230 236.02 74.04 3.75% 2.78 65.10 82.2031 236.02 71.23 3.88% 2.76 67.86 84.9632 236.02 68.53 4.00% 2.74 70.60 87.7033 236.02 65.93 4.13% 2.72 73.32 90.4234 236.02 63.44 4.25% 2.70 76.02 93.1235 236.02 61.03 4.38% 2.67 78.69 95.7936 236.02 58.72 4.50% 2.64 81.33 98.4337 236.02 56.49 4.63% 2.61 83.94 101.0438 236.02 54.35 4.75% 2.58 86.52 103.6239 236.02 52.29 4.88% 2.55 89.07 106.1740 236.02 50.31 5.00% 2.52 91.59 108.6941 236.02 48.40 5.13% 2.48 94.07 111.1742 236.02 46.57 5.25% 2.44 96.51 113.6143 236.02 44.80 5.38% 2.41 98.92 116.0244 236.02 43.10 5.50% 2.37 101.29 118.3945 236.02 41.47 5.63% 2.33 103.62 120.7246 236.02 39.90 5.75% 2.29 105.92 123.0247 236.02 38.38 5.88% 2.26 108.17 125.2748 236.02 36.93 6.00% 2.22 110.39 127.49

Cálculo de IOFEmpréstimo 4500Taxa: 3.94%Prazo: 36IOF Fixo 17.10