Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
menu Planilha MATEMAGICA.XLS Aprendendo matemática financeira com o Excel Modelo Taxas Datas Sistemas Equivalência Desenho Sistemas modelo 0 MATEMÁGICA FINANCEIRA NO EXCEL Clique sobre o valor que deseja obter Operações financeiras com juros compostos. Regime N I PV PMT FV Tipo 3 0 Juros Compostos 0.00 0.00% 0.0 0.0 0.0 Sem entrada Resposta 0.00% Operações na HP12C 0.0 Operações no Excel 0.0 0 0 0 0 0 N I PV PMT FV Tipo JS 1 0 0 0 Não existe 0 D 2 0 0 0 Não existe 0 JC 3 0 0 0 0 0 l 3 c 0 fómula ==> 3 Opção : 3 juros compostos (Não Mexa !!!) 1 - Juros Simples 2 - Desconto Bancário 3 - Juros Compostos Cálculos Financeiros Gerais (Não Mexa !!!) 2 3 4 5 6 1 0.0 0.00% 0.0 Não tem 0.0 2 0.0 0.00% 0.0 Não tem 0.0 3 0.0 0.00% 0.0 0.0 0.0 Cálculos na HP 12C - Não Mexa Nunca !!! Juros N I PV PMT FV TIPO 0 0 0 [n] 0 [i] 0 0 0 [g] [END] N 0 I 0 PV 0 PMT 0 FV 0 Regimes 1 - Juros simples 2 - Desconto comercial TAXA(nper;pgto;vp;vf;tipo;estimativa) 3 - Juros compostos VF(taxa;nper;pgto;vp;tipo) VP(taxa;nper;pgto;vf;tipo) Tipos 0 - postecipado 1 - antecipado Legenda cod desc simb conc 1 O número de períodos períodos =NPER(;;;;0) 2 A taxa de juros % a.p. =TAXA(;;;;0;) 3 O valor presente =VP(;;;;0) 4 A prestação =PGTO(;;;;0) 5 O valor futuro =VF(;;;;0) Taxa 1 % a.d. dias 1 2 % a.m. meses 30 3 % a.b. bimestres 60 4 % a.t. trimestres 90 5 % a.q. quadrimestres 120 6 % a.s. semestres 180 7 % a.a. ano comercial 360 8 % a.a. (exato) ano civil 365 Tipo: 0 = postecipado, sem entrada, 1 = antecipado, com entrada N I PV PMT FV Limpa Valor Limpa Função Menu taxas MATEMÁGICA FINANCEIRA NO EXCEL Operações com taxas de juros no regime de juros compostos 3 Regime Juros Compostos ? Equivalência de taxas de juros. Taxa A Nper A Taxa B Nper B 0.00% 0 Menu Taxa B Nper B Limpa datas MATEMÁGICA FINANCEIRA NO EXCEL Operações com datas ? ? Contagem de dias Início Fim Dias úteis Dias corridos 12/31/99 12/31/99 -1 0 Lembre-se : os feriados devem estar abastecidos. Último feriado fornecido = 12/31/03 0 Primeiro feriado fornecido = 1/1/01 0 Relação de feriados bancários (importante para a contagem de dias úteis). 1/1/01 1/1/02 1/1/03 2/26/01 2/11/02 3/3/03 2/27/01 2/12/02 3/4/03 4/13/01 3/29/02 4/18/03 4/21/01 4/21/02 4/21/03 5/1/01 5/1/02 5/1/03 6/14/01 5/30/02 6/19/03 9/7/01 9/7/02 9/7/03 10/12/01 12/12/02 10/12/03 11/2/01 11/2/02 11/2/03 11/15/01 11/15/02 11/15/03 12/25/01 12/25/02 12/25/03 12/31/03 Para obter a relação de feriados, visite: http://www.febraban.org.br. Menu Limpa Dias úteis Dias corridos sistemas MATEMÁGICA FINANCEIRA NO EXCEL Operações com sistemas de pagamento Sistema 1 Valor Presente Carência (m+1) Taxa ao período (%) Número de Pagamentos Período Saldo Pagamento Saldo Correção Prestação N Inicial Juros Amortização Total Final Monetária Corrigida 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 0 0.0 0.0 0.0 0.0 0.0 0.0 $1.00 N máximo -1 Gráficos Pagamento : Juros e Amortização Price 1 SAC Price sistemas 0 0 0 0 0 0 0 0 0 0 0 0 Juros Amortização equivalencia MATEMÁGICA FINANCEIRA NO EXCEL Operações com equivalência de capitais No regime de juros compostos Regime 3 3 Data focal i VPL 0.0 TIR 0% Período Fluxo de caixa Fluxo na Valor equivalente na data focal Fórmulas N nominal data focal 0.00000 Na HP 12C, VPL : SIMPL DESC COMP Período 0.0 [f] [REG] 0 [i] [f] [NPV] Visor => 0 0 0 0 0 0.0 Na HP12C: 0 0 0 1 0.0 VPL 0 0 0 2 0.0 0 0 0 0 3 0.0 0 0 0 4 0.0 0 0 0 5 0.0 0 0 0 6 0.0 Na HP 12C, TIR : 0 0 0 7 0.0 0 0 0 0 8 0.0 0 0 0 9 0.0 TIR 0 0 0 10 0.0 0 0 0 0 11 0.0 0 0 0 12 0.0 0 0 0 13 0.0 0 0 0 14 0.0 0 0 0 15 0.0 0 0 0 16 0.0 0 0 0 17 0.0 0 0 0 18 0.0 0 0 0 19 0.0 0 0 0 20 0.0 0 0 0 21 0.0 0 0 0 22 0.0 0 0 0 23 0.0 0 0 0 24 0.0 0 0 0 25 0.0 0 0 0 26 0.0 0 0 0 27 0.0 0 0 0 28 0.0 0 0 0 29 0.0 0 0 0 30 0.0 0 0 0 31 0.0 0 0 0 32 0.0 0 0 0 33 0.0 0 0 0 34 0.0 0 0 0 35 0.0 0 0 0 36 0.0 0 0 0 37 0.0 0 0 0 38 0.0 0 0 0 39 0.0 0 0 0 40 0.0 0 0 0 41 0.0 0 0 0 42 0.0 0 0 0 43 0.0 0 0 0 44 0.0 0 0 0 45 0.0 0 0 0 46 0.0 0 0 0 47 0.0 0 0 0 48 0.0 0 0 0 49 0.0 0 0 0 50 0.0 0 0 0 51 0.0 0 0 0 52 0.0 0 0 0 53 0.0 0 0 0 54 0.0 0 0 0 55 0.0 0 0 0 56 0.0 0 0 0 57 0.0 0 0 0 58 0.0 0 0 0 59 0.0 0 0 0 60 0.0 0 0 0 61 0.0 0 0 0 62 0.0 0 0 0 63 0.0 0 0 0 64 0.0 0 0 0 65 0.0 0 0 0 66 0.0 0 0 0 67 0.0 0 0 0 68 0.0 0 0 0 69 0.0 0 0 0 70 0.0 0 0 0 71 0.0 0 0 0 72 0.0 0 0 0 73 0.0 0 0 0 74 0.0 0 0 0 75 0.0 0 0 0 76 0.0 0 0 0 77 0.0 0 0 0 78 0.0 0 0 0 79 Na HP 12C : 0 TIR Na HP 12C : [f] [REG] 0 [i] [f] [NPV] Visor => 0 VPL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Menu Limpa Períodos intervalares Limpa Menu desenhos MATEMÁGICA FINANCEIRA NO EXCEL Diagramas de fluxo de caixa Ano FC 0 0 1 0 2 0 3 0 4 0 5 0 6 0 7 0 8 9 10 desenhos 0 1 2 3 4 5 6 7 8 9 10 Períodos Taxa de juros (i) Menu Limpa
Compartilhar