Planilha para Calculo das Tabelas PRICE e GLAUSS.xls

Aproveite o Simulador Simulador Grátis! Grátis! Tabela 1 - Juros Compostos ( Método PRICE) PRICE) Tabela 2 - Juros Simples (Método GAUSS) Digite os Valores nos Campos em Amarelo.

Taxa de Juro ao mês Taxa de Juro ao ano Valor Total Financiado + Taxas Taxas Valor Total do Bem, sem Taxas IOF Ficha Cadastral Outros Outros Outros Prazo Valor da Prestação

1.37%

< Digitar

16.44% R$ 40,895.00 R$ 40,000.00 R$ 745.00 R$ 150.00 R$ 0.00 R$ 0.00 R$ 0.00 60 R$ 779.00

Taxa de Inflação Estimad Índice da Prestação (PMT Financiamento Atualizado Data Assinatura do Contr

< Digitar < Digitar < Digitar < Digitar

Total da Coluna Parcela C Total da Coluna Juros ( Total da Coluna Amortiza

< Digitar < Digitar < Digitar < Digitar

Total da Coluna Parcela R Total da Coluna Juros (M Total da Coluna Amortiza Site Revisional

Tabela 1 - Juros Compostos ( Método PRICE) PRICE)

Nº

0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

Venc Venciiment mentoo 17/02/13 17/03/13 17/04/13 17/05/13 17/06/13 17/07/13 17/08/13 17/09/13 17/10/13 17/11/13 17/12/13 17/01/14 17/02/14 17/03/14 17/04/14 17/05/14 17/06/14 17/07/14 17/08/14 17/09/14 17/10/14 17/11/14 17/12/14 17/01/15 17/02/15 17/03/15 17/04/15

Parcela Contratada 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00

Juros Juros 560.26 557.26 554.23 551.15 548.03 544.86 541.65 538.40 535.11 531.76 528.38 524.94 521.46 517.94 514.36 510.73 507.06 503.33 499.56 495.73 491.85 487.91 483.92 479.88 475.78 471.63 467.42

Tabela 2 - Juros

Amorti Amortizaç zações ões Saldo Saldo Devedor Devedor 218.74 221.74 224.77 227.85 230.97 234.14 237.35 240.60 243.89 247.24 250.62 254.06 257.54 261.06 264.64 268.27 271.94 275.67 279.44 283.27 287.15 291.09 295.08 299.12 303.22 307.37 311.58

40,895.00 40,676.26 40,454.53 40,229.75 40,001.90 39,770.93 39,536.79 39,299.44 39,058.85 38,814.95 38,567.72 38,317.09 38,063.04 37,805.50 37,544.44 37,279.80 37,011.53 36,739.59 36,463.92 36,184.47 35,901.20 35,614.05 35,322.96 35,027.89 34,728.77 34,425.55 34,118.18 33,806.60

Parcela Recalculada 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41

Juros 399.00 392.35 385.70 379.05 372.40 365.75 359.10 352.45 345.80 339.15 332.50 325.85 319.20 312.55 305.90 299.25 292.60 285.95 279.30 272.65 266.00 259.35 252.70 246.05 239.40 232.75 226.10

28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79

28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60

17/05/15 17/06/15 17/07/15 17/08/15 17/09/15 17/10/15 17/11/15 17/12/15 17/01/16 17/02/16 17/03/16 17/04/16 17/05/16 17/06/16 17/07/16 17/08/16 17/09/16 17/10/16 17/11/16 17/12/16 17/01/17 17/02/17 17/03/17 17/04/17 17/05/17 17/06/17 17/07/17 17/08/17 17/09/17 17/10/17 17/11/17 17/12/17 17/01/18 FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE

779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00 779.00

463.15 458.82 454.44 449.99 445.48 440.91 436.28 431.59 426.83 422.00 417.11 412.15 407.13 402.03 396.87 391.63 386.33 380.95 375.49 369.97 364.36 358.68 352.92 347.09 341.17 335.17 329.09 322.93 316.68 310.34 303.92 297.41 290.82

315.85 320.18 324.56 329.01 333.52 338.09 342.72 347.41 352.17 357.00 361.89 366.85 371.87 376.97 382.13 387.37 392.67 398.05 403.51 409.03 414.64 420.32 426.08 431.91 437.83 443.83 449.91 456.07 462.32 468.66 475.08 481.59 488.18

33,490.75 33,170.57 32,846.01 32,517.00 32,183.48 31,845.40 31,502.68 31,155.27 30,803.09 30,446.10 30,084.21 29,717.36 29,345.49 28,968.52 28,586.39 28,199.03 27,806.35 27,408.30 27,004.79 26,595.76 26,181.12 25,760.80 25,334.72 24,902.81 24,464.98 24,021.15 23,571.24 23,115.16 22,652.84 22,184.19 21,709.11 21,227.52 20,739.34

884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41 884.41

219.45 212.80 206.15 199.50 192.85 186.20 179.55 172.90 166.25 159.60 152.95 146.30 139.65 133.00 126.35 119.70 113.05 106.40 99.75 93.10 86.45 79.80 73.15 66.50 59.85 53.20 46.55 39.90 33.25 26.60 19.95 13.30 6.65

80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #

FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #


# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #


# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #


# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #


# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #


# # # # # # # # #

FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE 46,740.00

26,584.34

20,155.66

53,064.62

12,169.62

© 2013 "CalculoREVisional.net.br" Copyright, Todos os Direitos Reservados

: ): (Sem Inflação): to dd/mm/aaaa

0.00%

0.021626369 R$ 74,510.69 17/01/13

ontratada ( Método PRICE) étodo PRICE) ões ( Método PRICE)

ecalculada (Método GAUSS) étodo GAUSS) ões (Método GAUSS) Facebook

< Digitar

Blog

< Digitar

R$ 46,740.00 R$ 26,584.34 R$ 20,155.66 R$ 53,064.62 R$ 12,169.62 R$ 40,895.00 Twitter

Simples (Método GAUSS)

Amortizações 485.41 492.06 498.71 505.36 512.01 518.66 525.31 531.96 538.61 545.26 551.91 558.56 565.21 571.86 578.51 585.16 591.81 598.46 605.11 611.76 618.41 625.06 631.71 638.36 645.01 651.66 658.31

Saldo Devedor 40,895.00 40,409.59 39,917.54 39,418.83 38,913.47 38,401.47 37,882.81 37,357.50 36,825.55 36,286.94 35,741.68 35,189.78 34,631.22 34,066.01 33,494.15 32,915.65 32,330.49 31,738.68 31,140.23 30,535.12 29,923.36 29,304.95 28,679.89 28,048.19 27,409.83 26,764.82 26,113.16 25,454.85

6.650067063 6.650067063 7.149733944 7.149 733944 7.683860609 7.683 860609 8.255167569 8.255 167569 8.866634428 8.866 634428 9.521529332 9.521 529332 10.22344233 10.22 344233 10.97632328 11.78452499 12.65285244 13.58661905 14.59171128 15.67466276 16.84273987 18.10404052 19.46760878 20.94356813 22.54327683 24.27950983 26.1666724 28.22105191 30.46111572 32.90786508 35.58525726 38.52071134 41.74571701 45.29657101

664.96 671.61 678.26 684.91 691.56 698.21 704.86 711.51 718.16 724.81 731.46 738.11 744.76 751.41 758.06 764.71 771.36 778.01 784.66 791.31 797.96 804.61 811.26 817.91 824.56 831.21 837.86 844.51 851.16 857.81 864.46 871.11 877.76

24,789.90 24,118.29 23,440.03 22,755.12 22,063.56 21,365.35 20,660.50 19,948.99 19,230.83 18,506.02 17,774.56 17,036.45 16,291.69 15,540.28 14,782.23 14,017.52 13,246.16 12,468.15 11,683.49 10,892.18 10,094.22 9,289.61 8,478.35 7,660.44 6,835.88 6,004.67 5,166.81 4,322.30 3,471.14 2,613.33 1,748.87 877.76 0.00

49.21527246 53.55061745 58.35954485 63.70880118 69.6770136 76.35728903 83.86049695 92.31944848 101.8942617 112.7793125 125.212328 139.4864085 155.966105 175.1091868 197.4965172 223.8736689 255.2098467 292.7828367 338.3039591 394.1060425 463.4334495 550.9026078 663.2577725 810.6595023 1008.98183 1284.131725 1680.71257 2280.848184 3249.488123 4959.348188 8408.548665 17105.25072 52186.86241 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!






#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 40,895.00

.

Planilha para Calculo das Tabelas PRICE e GLAUSS.xls

Recommend Documents