Baixe o app para aproveitar ainda mais
Prévia do material em texto
Empresas Fonte: https://www.suafranquia.com/noticias/beleza-e-saude/2019/04/franquia-de-academias-brasil-e-o-2-maior-mercado-no-segmento-do-mundo/ Dados da Associação Brasileira de Academias mostram que já são mais de 36 mil estabelecimentos, com uma demanda de quase 10 milhões de clientes e um faturamento de US$ 2 bilhões, o que coloca o país como o 2° maior mercado, ficando atrás apenas dos Estados Unidos. Investimento Inicial Taxa de franquia Taxa de Publicidade Royalties Retorno Faturamento médio mensal Smart Fit R$ 2,8 milhões a R$ 4 milhões R$ 100.000 a partir de 5% a partir de 36 meses BlueFit a partir de R$ 2,5 milhões Selfit R$ 3,4 milhões Contours a partir de R$ 350.000 R$ 70.000 24 a 36 meses R$ 60.000 Doctor Fit R$ 57.000 até R$ 120.000 107.54 R$ 10,70 por aluno 18 a 24 meses R$ 15.000 a R$ 35.000 Team Nogueira a partir de R$ 250.000 20 a 48 meses 40+ Academia a partir de R$ 135.000 R$ 30.000 R$ 500.00 24 a 36 meses R$ 25,000.00 Instituto Pilates a partir de R$ 31.500 18 a 24 meses R$ 25.000 Fórmula Academia R$ 1.380.000 até R$ 5.200.000 2% 8% 36 a 60 meses R$ 120.000 Estúdio Anacã a partir de R$ 1.100.000 36 a 48 meses R$ 200.000 Spin’n Soul a partir de R$ 690.000 R$ 80 mil 2% 9% média de 21 meses Biofisic R$ 600.000 até R$ 2.000.000 R$ 60.000 2% 6% 36 a 48 meses R$ 150.000 Tribo Fitness R$ 150.000 a R$ 200.000 R$ 50.000 3% 5% R$ 25.000 a R$ 40.000 Curves a partir de R$ 220.000 24 meses Arena 235 R$ 80.000 a R$ 300.000 12 a 36 meses Studio Velocity R$ 220.000 a R$ 650.000 R$ 50 mil e R$ 100 mil 1% 10% 18 a 36 meses R$ 180.000 Capital de Giro: de R$ 80 mil a R$ 100 aulas avulsas – cujo preço varia entre R$ 45 e R$ 57 Dez aulas podem sair entre R$ 350, 00 e R$ 450,00, em promoção. Média de lucro mensal: 30 % Alta Energia Fitness a partir de R$ 1,5 milhão 2% 6% sobre o produto bruto a partir de 30 meses 30’ Extreme Fit a partir de R$ 60.000 2% sobre o faturamento bruto 6% a partir dos 26 meses https://www.suafranquia.com/noticias/beleza-e-saude/2019/04/franquia-de-academias-brasil-e-o-2-maior-mercado-no-segmento-do-mundo/ Início Início /xl/drawings/drawing1.xml#In%C3%ADcio!A1Dados /xl/drawings/drawing1.xml#Dados!A1Análise /xl/drawings/drawing1.xml#An%C3%A1lise!A1Econômico /xl/drawings/drawing1.xml#FC_Econ!A1Fluxos de caixa Inflação /xl/drawings/drawing1.xml#FC_Infla%C3%A7%C3%A3o!A1Contábil /xl/drawings/drawing1.xml#FC_sem_Infla%C3%A7%C3%A3o!A1Financiamento /xl/drawings/drawing1.xml#FC_PRICE!A1Pesquisa de preços /xl/drawings/drawing1.xml#P_Pre%C3%A7os!A1Conclusão /xl/drawings/drawing1.xml#Conclus%C3%A3o!A1Referências /xl/drawings/drawing1.xml#Refer%C3%AAncias!A1 Dados d CENÁRIO BASE IGP-M (FOCUS 25/09/2020) IPCA (FOCUS 25/09/2020) Qtde Aulas por Dia 5 Qtde de Bikes por Aula 43 2020 15.64% 1.22% 2020 2.05% 0.17% % Demanda Média 75.00% Número de Aulas Mensais 4838 2021 4.21% 0.34% 2021 3.01% 0.25% % Aula Avulsa 25% % Pacote (10 Aulas) 75% 2022 4.00% 0.33% 2022 3.50% 0.29% Ticket Médio da Aula Avulsa R$ 45.00 Ticket Médio do Pacote de Aulas R$ 350.00 2023 3.69% 0.30% 2023 3.25% 0.27% Ticket Médio Total R$ 37.50 2024 3.69% 0.30% 2024 3.69% 0.30% Dados Econômicos a.a. a.m. a.a. a.m. a.a. a.m. TMA 12.00% 0.95% Taxa Selic 2.00% 0.17% Depreciação (10 anos) 10% 0.80% Imposto de Renda 21% : Anexo III Do Simples Nacional Faturamento de até R$ 180 mil: alíquota de 6%; Faturamento de R$ 180 mil até R$ 360 mil: alíquota de 11,2%; Faturamento de R$ 360 mil até R$ 720 mil: alíquota de 13,5%; Faturamento de R$ 720 mil até R$ 1,8 milhão: alíquota de 16%; Faturamento de R$ 1,8 milhão até R$ 3,6 milhões: alíquota de 21%; Faturamento de R$ 3,6 milhões até R$ 4,8 milhões: alíquota de 33%. -Victor Quinalhia https://www.consultoriarr.com.br/como-funciona-o-simples-nacional-para-academias/#:~:text=Nesse%20caso%2C%20a%20al%C3%ADquota%20de,R%24%204%2C8%20milh%C3%B5es. -Victor Quinalhia Investimento inicial R$ 534,885.95 Custos Fixos/Mês R$ 84,651.56 Custos variáveis 26.00% Financiamento Taxa de Franquia R$ 100,000.00 Despesas operacionais R$ 36,197.67 Taxa de Publicidade 1.00% Valor do Empréstimo R$ 317,757.75 Reforma do local R$ 80,000.00 Luz R$ 3,812.68 Royalties 10.00% Tempo de Financiamento 60 Bicicleta Spinning R$ 317,757.75 Água R$ 540.00 Mimos 15.00% Juros (%a.a.) 5.78% Purificador/Bebedouro R$ 4,288.49 Aluguel + IPTU + FCI R$ 16,125.00 Juros (%a.m.) 0.47% Computadores R$ 7,358.00 Telefone + Internet R$ 109.99 Impressora R$ 268.90 Pró-labore R$ 10,000.00 Telefone Com Fio R$ 74.80 Manutenção R$ 300.00 TVs R$ 9,538.06 Material de Limpeza R$ 80.00 Espelhos R$ 97.68 Material de Escritório R$ 30.00 Ar Condicionado R$ 10,958.55 Marketing R$ 2,000.00 Ducha Elétrica R$ 1,809.33 Contador R$ 1,200.00 Lâmpada led tubular R$ 204.44 Demais Gastos R$ 2,000.00 Luzes R$ 400.00 Mão de obra R$ 48,453.89 Escrivaninha R$ 263.80 Salário R$ 23,500.00 Cadeira de escritório R$ 539.63 FGTS 8% R$ 2,245.56 Material de limpeza R$ 100.00 INSS 20% R$ 5,613.89 Kit Caixas de som R$ 993.67 Férias + 1/3 Férias R$ 2,611.11 Banquetas R$ 232.85 13º Salário R$ 1,958.33 Alíquota RAT 2% R$ 470.00 Valor de Mercado R$ 354,885.95 Vale-Refeição $15/dia R$ 5,400.00 Vale-Transporte $10/dia R$ 3,600.00 Fundo Rescisório R$ 3,055.00Início /xl/drawings/drawing2.xml#In%C3%ADcio!A1Dados /xl/drawings/drawing2.xml#Dados!A1Análise /xl/drawings/drawing2.xml#An%C3%A1lise!A1Econômico /xl/drawings/drawing2.xml#FC_Econ!A1Fluxos de caixa Inflação /xl/drawings/drawing2.xml#FC_Infla%C3%A7%C3%A3o!A1Contábil /xl/drawings/drawing2.xml#FC_sem_Infla%C3%A7%C3%A3o!A1Financiamento /xl/drawings/drawing2.xml#FC_PRICE!A1 Análise ANÁLISE DETERMINÍSTICA Fatores de variação % Fatores de variação VALORES DE CENÁRIO BASE MÁX/MÍN. p/ VIAB. % MÁX/MÍN. p/ VIAB. Valor do Investimento 0.00% Valor do Investimento R$ 534,885.95 R$ 1,850,224.82 245.91% Custo Váriavel 0.00% Custo Váriavel 26.00% 44.88% 72.63% Custo de Mão de Obra 0.00% Custo de Mão de Obra R$ 48,453.89 R$ 82,713.10 70.70% Quantidade de Aulas Vendidas 0.00% Quantidade de Aulas Vendidas 4838 3603.4338412054 -25.52% Custos com Aluguel 0.00% Custos com Aluguel R$ 16,125.00 R$ 46,407.12 187.80% Ticket Médio Total 0.00% Ticket Médio Total R$ 37.50 R$ 27.93 -25.52% Critérios de avaliação (FC Com Inflação e Sem Financiamento) Análise de Cenários (VPL e TIR) VPL R$ 1,315,338.86 Pessimista 2 Pessimista 1 Cenário Base Otimista 1 Otimista 2 VEU R$ 28,852.87 Valor do Investimento 15% 5% 0% 0% -5% IL 3.46 Custo Váriavel -30% 0% 0% 0% 0% TIR 7.30% Custo de Mão de Obra -5% 0% 0% 10% 20% Payback Simples(mês) 14 Quantidade de Aulas Vendidas -18% -10% 0% 15% 30% Payback Descontado(mês) 15 Custos com Aluguel 5% 2% 0% 0% 0% Ticket Médio Total -20% -10% 0% 8% 12% VPL -R$ 123,792.62 R$ 295,033.76 R$ 1,315,338.86 R$ 2,377,047.99 R$ 3,320,006.85 IL 0.80 1.53 3.46 5.44 7.53 TIR 0.17% 2.63% 7.30% 11.52% 15.88% TMA (%a.m.) 0.95% 0.95% 0.95% 0.95% 0.95% VPL (COM % DE VARIAÇÃO DO CENÁRIO BASE) -20% -10% 0% 10% 20% Valor do Investimento R$ 1,422,316.05 R$ 1,368,827.46 R$ 1,315,338.86 R$ 1,261,850.27 R$ 1,208,361.67 Custo váriavel R$ 1,677,549.14 R$ 1,496,444.00 R$ 1,315,338.86 R$ 1,134,233.72 R$ 953,128.58 Custo de Mão de Obra R$ 1,687,403.96 R$ 1,501,371.41 R$ 1,315,338.86 R$ 1,129,306.32 R$ 943,273.77 Quantidade de Aulas Vendidas R$ 284,432.68 R$ 799,885.77 R$ 1,315,338.86 R$ 1,830,791.96 R$ 2,346,245.05 Custos com aluguel R$ 1,455,420.45 R$ 1,385,379.66 R$ 1,315,338.86 R$ 1,245,298.07 R$ 1,175,257.28 Ticket Médio R$ 284,432.68 R$ 799,885.77 R$ 1,315,338.86 R$ 1,830,791.96 R$ 2,346,245.05 Análise de Cenários VPL Pessimista 2 Pessimista 1 Cenário Base Otimista 1 Otimista 2 -123792.616590594 295033.75875290914 1315338.8641505498 2377047.9935710691 3320006.8482437134 TIR Pessimista 2 Pessimista 1 Cenário Base Otimista 1 Otimista 2 1.6677910190470158E-3 2.6268314992828667E-2 7.3038165687295376E-2 0.11524244739461076 0.15876601696620107 TMA (%a.m.) 9.4887929345830457E-3 9.4887929345830457E-3 9.4887929345830457E-3 9.4887929345830457E-3 9.4887929345830457E-3 Análise de Sensibilidade Valor do Investimento -0.2 -0.1 0 0.1 0.2 1422316.0544838831 1368827.4593172164 1315338.8641505498 1261850.2689838831 1208361.6738172164 Custo váriavel -0.2 -0.1 0 0.1 0.2 1677549.1442451896 1496444.0041978692 1315338.8641505498 1134233.7241032321 953128.58405591222 Custo de Mão de O bra -0.2 -0.1 0 0.1 0.2 1687403.9613218526 1501371.4127362024 1315338.8641505498 1129306.3155648997 943273.76697924547 Quantidade de Aulas Vendidas -0.2 -0.1 0 0.1 0.2 284432.68234273826 799885.7732466422 1315338.8641505498 1830791.9550544624 2346245.0459583686 Custos com aluguel -0.2 -0.1 0 0.1 0.2 1455420.4483487497 1385379.6562496498 1315338.8641505498 1245298.0720514497 1175257.2799523501 Ticket Médio -0.2 -0.1 0 0.1 0.2 284432.68234273826 799885.7732466422 1315338.8641505498 1830791.9550544624 2346245.0459583695 Início /xl/drawings/drawing3.xml#In%C3%ADcio!A1Dados /xl/drawings/drawing3.xml#Dados!A1Análise /xl/drawings/drawing3.xml#An%C3%A1lise!A1Econômico /xl/drawings/drawing3.xml#FC_Econ!A1Fluxos de caixa Inflação /xl/drawings/drawing3.xml#FC_Infla%C3%A7%C3%A3o!A1Contábil /xl/drawings/drawing3.xml#FC_sem_Infla%C3%A7%C3%A3o!A1Financiamento /xl/drawings/drawing3.xml#FC_PRICE!A1 ASAC Critérios de avaliação TABELA SAC VPL R$ 1,315,338.86 Parcelas Juros Amortização Pagamento Saldo devedor F. Contábil F. Completo FCA FC Descontado FCDA VEU R$ 28,852.87 0 R$ 0.00 R$ 0.00 R$ 0.00 R$ 317,757.75 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 IL 3.46 1 R$ 1,491.42 R$ 5,295.96 R$ 6,787.39 R$ 312,461.79 R$ 39,713.29 R$ 46,500.68 -R$ 488,385.27 R$ 46,063.59 -R$ 488,822.36 TIR 8.55% 2 R$ 1,466.57 R$ 5,295.96 R$ 6,762.53 R$ 307,165.83 R$ 39,644.24 R$ 46,406.77 -R$ 441,978.51 R$ 45,538.46 -R$ 443,283.90 Payback Simples(mês) 13 3 R$ 1,441.71 R$ 5,295.96 R$ 6,737.67 R$ 301,869.86 R$ 39,573.42 R$ 46,311.09 -R$ 395,667.42 R$ 45,017.41 -R$ 398,266.50 Payback Descontado(mês) 14 4 R$ 1,416.85 R$ 5,295.96 R$ 6,712.82 R$ 296,573.90 R$ 39,500.81 R$ 46,213.63 -R$ 349,453.79 R$ 44,500.41 -R$ 353,766.08 5 R$ 1,392.00 R$ 5,295.96 R$ 6,687.96 R$ 291,277.94 R$ 39,426.39 R$ 46,114.35 -R$ 303,339.44 R$ 43,987.43 -R$ 309,778.65 Inputs 6 R$ 1,367.14 R$ 5,295.96 R$ 6,663.10 R$ 285,981.98 R$ 39,350.14 R$ 46,013.24 -R$ 257,326.20 R$ 43,478.43 -R$ 266,300.23 Vida útil (anos) 5 7 R$ 1,342.28 R$ 5,295.96 R$ 6,638.24 R$ 280,686.01 R$ 39,272.03 R$ 45,910.27 -R$ 211,415.93 R$ 42,973.36 -R$ 223,326.86 Vida útil (meses) 60 8 R$ 1,317.42 R$ 5,295.96 R$ 6,613.39 R$ 275,390.05 R$ 39,192.03 R$ 45,805.42 -R$ 165,610.51 R$ 42,472.21 -R$ 180,854.66 Selic (%a.m) 0.17% 9 R$ 1,292.57 R$ 5,295.96 R$ 6,588.53 R$ 270,094.09 R$ 39,110.13 R$ 45,698.66 -R$ 119,911.85 R$ 41,974.93 -R$ 138,879.73 TMA (%a.m) 0.95% 10 R$ 1,267.71 R$ 5,295.96 R$ 6,563.67 R$ 264,798.13 R$ 39,026.30 R$ 45,589.97 -R$ 74,321.88 R$ 41,481.48 -R$ 97,398.25 IR 21% 11 R$ 1,242.85 R$ 5,295.96 R$ 6,538.82 R$ 259,502.16 R$ 38,940.50 R$ 45,479.32 -R$ 28,842.56 R$ 40,991.84 -R$ 56,406.41 Entrada Mensal R$ 181,425.00 12 R$ 1,218.00 R$ 5,295.96 R$ 6,513.96 R$ 254,206.20 R$ 38,852.73 R$ 45,366.69 R$ 16,524.12 R$ 40,505.97 -R$ 15,900.44 Saída Mensal -R$ 131,822.06 13 R$ 1,193.14 R$ 5,295.96 R$ 6,489.10 R$ 248,910.24 R$ 38,933.13 R$ 45,422.24 R$ 61,946.36 R$ 40,174.36 R$ 24,273.93 Aluguel R$ 16,125.00 14 R$ 1,168.28 R$ 5,295.96 R$ 6,464.24 R$ 243,614.28 R$ 39,013.69 R$ 45,477.93 R$ 107,424.29 R$ 39,845.54 R$ 64,119.46 15 R$ 1,143.42 R$ 5,295.96 R$ 6,439.39 R$ 238,318.31 R$ 39,094.40 R$ 45,533.78 R$ 152,958.08 R$ 39,519.48 R$ 103,638.94 Depreciação 16 R$ 1,118.57 R$ 5,295.96 R$ 6,414.53 R$ 233,022.35 R$ 39,175.25 R$ 45,589.78 R$ 198,547.86 R$ 39,196.16 R$ 142,835.10 Valor de Mercado 17 R$ 1,093.71 R$ 5,295.96 R$ 6,389.67 R$ 227,726.39 R$ 39,256.26 R$ 45,645.93 R$ 244,193.79 R$ 38,875.55 R$ 181,710.65 Valor de Depreciação Mensal 18 R$ 1,068.85 R$ 5,295.96 R$ 6,364.82 R$ 222,430.43 R$ 39,337.42 R$ 45,702.23 R$ 289,896.02 R$ 38,557.63 R$ 220,268.28 19 R$ 1,044.00 R$ 5,295.96 R$ 6,339.96 R$ 217,134.46 R$ 39,418.72 R$ 45,758.68 R$ 335,654.70 R$ 38,242.39 R$ 258,510.67 20 R$ 1,019.14 R$ 5,295.96 R$ 6,315.10 R$ 211,838.50 R$ 39,500.18 R$ 45,815.28 R$ 381,469.99 R$ 37,929.78 R$ 296,440.45 21 R$ 994.28 R$ 5,295.96 R$ 6,290.24 R$ 206,542.54 R$ 39,581.79 R$ 45,872.04 R$ 427,342.03 R$ 37,619.80 R$ 334,060.25 22 R$ 969.43 R$ 5,295.96 R$ 6,265.39 R$ 201,246.58 R$ 39,663.56 R$ 45,928.94 R$ 473,270.97 R$ 37,312.42 R$ 371,372.67 23 R$ 944.57 R$ 5,295.96 R$ 6,240.53 R$ 195,950.61 R$ 39,745.47 R$ 45,986.00 R$ 519,256.97 R$ 37,007.61 R$ 408,380.29 24 R$ 919.71 R$ 5,295.96 R$ 6,215.67 R$ 190,654.65 R$ 39,827.53 R$ 46,043.21 R$ 565,300.18 R$ 36,705.36 R$ 445,085.65 25 R$ 894.85 R$ 5,295.96 R$ 6,190.82 R$ 185,358.69 R$ 39,933.98 R$ 46,124.80 R$ 611,424.98 R$ 36,424.78R$ 481,510.43 26 R$ 870.00 R$ 5,295.96 R$ 6,165.96 R$ 180,062.73 R$ 40,040.72 R$ 46,206.68 R$ 657,631.66 R$ 36,146.46 R$ 517,656.89 27 R$ 845.14 R$ 5,295.96 R$ 6,141.10 R$ 174,766.76 R$ 40,147.74 R$ 46,288.85 R$ 703,920.51 R$ 35,870.37 R$ 553,527.25 28 R$ 820.28 R$ 5,295.96 R$ 6,116.25 R$ 169,470.80 R$ 40,255.05 R$ 46,371.30 R$ 750,291.80 R$ 35,596.49 R$ 589,123.74 29 R$ 795.43 R$ 5,295.96 R$ 6,091.39 R$ 164,174.84 R$ 40,362.65 R$ 46,454.04 R$ 796,745.84 R$ 35,324.82 R$ 624,448.56 30 R$ 770.57 R$ 5,295.96 R$ 6,066.53 R$ 158,878.88 R$ 40,470.53 R$ 46,537.06 R$ 843,282.90 R$ 35,055.32 R$ 659,503.88 31 R$ 745.71 R$ 5,295.96 R$ 6,041.67 R$ 153,582.91 R$ 40,578.71 R$ 46,620.38 R$ 889,903.29 R$ 34,787.98 R$ 694,291.86 32 R$ 720.85 R$ 5,295.96 R$ 6,016.82 R$ 148,286.95 R$ 40,687.17 R$ 46,703.99 R$ 936,607.27 R$ 34,522.79 R$ 728,814.66 33 R$ 696.00 R$ 5,295.96 R$ 5,991.96 R$ 142,990.99 R$ 40,795.93 R$ 46,787.89 R$ 983,395.16 R$ 34,259.72 R$ 763,074.38 34 R$ 671.14 R$ 5,295.96 R$ 5,967.10 R$ 137,695.03 R$ 40,904.97 R$ 46,872.08 R$ 1,030,267.24 R$ 33,998.76 R$ 797,073.14 35 R$ 646.28 R$ 5,295.96 R$ 5,942.25 R$ 132,399.06 R$ 41,014.31 R$ 46,956.56 R$ 1,077,223.79 R$ 33,739.89 R$ 830,813.03 36 R$ 621.43 R$ 5,295.96 R$ 5,917.39 R$ 127,103.10 R$ 41,123.94 R$ 47,041.33 R$ 1,124,265.12 R$ 33,483.09 R$ 864,296.13 37 R$ 596.57 R$ 5,295.96 R$ 5,892.53 R$ 121,807.14 R$ 41,226.43 R$ 47,118.97 R$ 1,171,384.09 R$ 33,223.10 R$ 897,519.23 38 R$ 571.71 R$ 5,295.96 R$ 5,867.67 R$ 116,511.18 R$ 41,329.18 R$ 47,196.86 R$ 1,218,580.95 R$ 32,965.22 R$ 930,484.45 39 R$ 546.86 R$ 5,295.96 R$ 5,842.82 R$ 111,215.21 R$ 41,432.19 R$ 47,275.01 R$ 1,265,855.95 R$ 32,709.43 R$ 963,193.88 40 R$ 522.00 R$ 5,295.96 R$ 5,817.96 R$ 105,919.25 R$ 41,535.45 R$ 47,353.41 R$ 1,313,209.37 R$ 32,455.72 R$ 995,649.60 41 R$ 497.14 R$ 5,295.96 R$ 5,793.10 R$ 100,623.29 R$ 41,638.97 R$ 47,432.08 R$ 1,360,641.44 R$ 32,204.06 R$ 1,027,853.65 42 R$ 472.28 R$ 5,295.96 R$ 5,768.25 R$ 95,327.33 R$ 41,742.75 R$ 47,511.00 R$ 1,408,152.44 R$ 31,954.43 R$ 1,059,808.09 43 R$ 447.43 R$ 5,295.96 R$ 5,743.39 R$ 90,031.36 R$ 41,846.79 R$ 47,590.18 R$ 1,455,742.62 R$ 31,706.83 R$ 1,091,514.91 44 R$ 422.57 R$ 5,295.96 R$ 5,718.53 R$ 84,735.40 R$ 41,951.09 R$ 47,669.63 R$ 1,503,412.25 R$ 31,461.23 R$ 1,122,976.14 45 R$ 397.71 R$ 5,295.96 R$ 5,693.68 R$ 79,439.44 R$ 42,055.65 R$ 47,749.33 R$ 1,551,161.58 R$ 31,217.61 R$ 1,154,193.75 46 R$ 372.86 R$ 5,295.96 R$ 5,668.82 R$ 74,143.48 R$ 42,160.48 R$ 47,829.29 R$ 1,598,990.87 R$ 30,975.97 R$ 1,185,169.72 47 R$ 348.00 R$ 5,295.96 R$ 5,643.96 R$ 68,847.51 R$ 42,265.56 R$ 47,909.52 R$ 1,646,900.40 R$ 30,736.28 R$ 1,215,906.00 48 R$ 323.14 R$ 5,295.96 R$ 5,619.10 R$ 63,551.55 R$ 42,370.91 R$ 47,990.01 R$ 1,694,890.41 R$ 30,498.52 R$ 1,246,404.52 49 R$ 298.28 R$ 5,295.96 R$ 5,594.25 R$ 58,255.59 R$ 42,476.52 R$ 48,070.77 R$ 1,742,961.18 R$ 30,262.68 R$ 1,276,667.20 50 R$ 273.43 R$ 5,295.96 R$ 5,569.39 R$ 52,959.63 R$ 42,582.39 R$ 48,151.78 R$ 1,791,112.96 R$ 30,028.75 R$ 1,306,695.96 51 R$ 248.57 R$ 5,295.96 R$ 5,544.53 R$ 47,663.66 R$ 42,688.53 R$ 48,233.07 R$ 1,839,346.03 R$ 29,796.71 R$ 1,336,492.66 52 R$ 223.71 R$ 5,295.96 R$ 5,519.68 R$ 42,367.70 R$ 42,794.94 R$ 48,314.61 R$ 1,887,660.64 R$ 29,566.53 R$ 1,366,059.20 53 R$ 198.86 R$ 5,295.96 R$ 5,494.82 R$ 37,071.74 R$ 42,901.61 R$ 48,396.43 R$ 1,936,057.07 R$ 29,338.22 R$ 1,395,397.41 54 R$ 174.00 R$ 5,295.96 R$ 5,469.96 R$ 31,775.78 R$ 43,008.55 R$ 48,478.51 R$ 1,984,535.58 R$ 29,111.74 R$ 1,424,509.15 55 R$ 149.14 R$ 5,295.96 R$ 5,445.10 R$ 26,479.81 R$ 43,115.75 R$ 48,560.86 R$ 2,033,096.43 R$ 28,887.09 R$ 1,453,396.24 56 R$ 124.29 R$ 5,295.96 R$ 5,420.25 R$ 21,183.85 R$ 43,223.22 R$ 48,643.47 R$ 2,081,739.91 R$ 28,664.24 R$ 1,482,060.48 57 R$ 99.43 R$ 5,295.96 R$ 5,395.39 R$ 15,887.89 R$ 43,330.97 R$ 48,726.36 R$ 2,130,466.26 R$ 28,443.19 R$ 1,510,503.67 58 R$ 74.57 R$ 5,295.96 R$ 5,370.53 R$ 10,591.93 R$ 43,438.98 R$ 48,809.51 R$ 2,179,275.77 R$ 28,223.92 R$ 1,538,727.59 59 R$ 49.71 R$ 5,295.96 R$ 5,345.68 R$ 5,295.96 R$ 43,547.26 R$ 48,892.93 R$ 2,228,168.71 R$ 28,006.41 R$ 1,566,734.01 60 R$ 24.86 R$ 5,295.96 R$ 5,320.82 -R$ 0.00 R$ 43,655.81 R$ 48,976.63 R$ 2,277,145.34 R$ 27,790.65 R$ 1,594,524.66 SOMA R$ 45,488.42 R$ 317,757.75 R$ 363,246.17 FC SAC F. Completo 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 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 -534885.95166666666 46500.678251072619 46406.766584596102 46311.090143551446 46213.62586482898 46114. 350401697564 46013.240120344752 45910.271096374803 45805.419111263996 45698.659648772911 45589.967891314773 45479.318716279668 45366.686692313953 45422.235518789697 45477.93421114418 45533.782971218912 45589.782000773142 45645.931501481609 45702.231674932358 45758.682722624522 45815.284845966053 45872.038246271455 45928.943124759528 45985.999682551148 46043.208120666808 46124.801633541872 46206.680510029822 46288.845503103119 46371.297367679028 46454.036860624365 46537.064740760456 46620.381768868036 46703.988707692071 46787.886321946818 46872.07537832058 46956.556645480865 47041.330894079125 47118.966002287387 47196.857484028857 47275.005971625018 47353 .412098927991 47432.076501324125 47510.99981573761 47590.182680634098 47669.625736024376 47749.329623468002 47829.294986076871 47909.522468518997 47990.012717022139 48070.766379377383 48151.784104943006 48233.066544648005 48314.614350995915 48396.428178068403 48478.5086815291 48560.856518627275 48643.472348201562 48726.356830683748 48809.510628102485 48892.934404086998 48976.628823871019 FC Descontado 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 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 -534885.95166666666 46063.590380132096 45538.456462020324 45017.409333052507 44500.41247842148 43987.429704079608 43478.42513383281 42973.36320646137 42472.208672867135 41974.926593247037 41481.482334292486 40991.84156641455 40505.970260994553 40174.361232476636 39845.538690414993 39519.478490540183 39196.156704519897 38875.549617970122 38557.633728485242 38242.385743686689 37929.782579289938 37619.801357189819 37312.419403563821 37007.614246993428 36705.363616602917 36424.782249066135 36146.455810189254 35870.365184368668 35596.491426377157 35324.815759780635 35055.319575370217 34787.984429609343 34522.792043095564 34259.724299037349 33998.763241745175 33739.891075137421 33483.090161260181 33223.102160771617 32965.222479648015 32709.43320809861 32455.716595392583 32204.055048391332 31954.431130094705 31706.82755820109 31461.227203681181 31217.613089365237 30975.96838854377 30736.276423581643 30498.520664545169 30262.684727842265 30028.752374875654 29796.707510708657 29566.534182743795 29338.216579413773 29111.739028885047 28887.085997773553 28664.242089872667 28443.192044893181 28223.920737215274 28006.4131746522 27790.654497225878 FCA -534885.95166666666 -488385.27341559401 -441978.50683099788 -395667.41668744641 -349453.79082261742 -303339.44042091985 -257326.20030057512 -211415.92920420031 -165610.51009293631 -119911.8504441634 -74321.882552848634 -28842.563836568967 16524.122855744987 61946.358374534684 107424.29258567886 152958.07555689779 198547.85755767094 244193.78905915254 289896.02073408489 335654.70345670939 381469.98830267543 427342.02654894686 473270.96967370639 519256.96935625753 565300.17747692438 611424.9791104662 657631.65962049598 70392 0.50512359908 750291.80249127815 796745.83935190248 843282.90409266297 889903.28586153104 936607.27456922317 983395.16089117003 1030267.2362694906 1077223.7929149715 1124265.1238090505 1171384.0898113379 1218580.9472953668 1265855.9532669918 1313209.3653659197 1360641.4418672437 1408152.4416829813 1455742.6243636154 1503412.2500996399 1551161.5797231079 1598990.8747091847 1646900.39717770371694890.4098947258 1742961.1762741031 1791112.9603790462 1839346.0269236942 1887660.6412746902 1936057.0694527586 1984535.5781342878 2033096.4346529152 2081739.9070011168 2130466.2638318003 2179275.7744599027 2228168.7088639895 2277145.3376878602 FCDA -534885.95166666666 -488822.36128653458 -443283.90482451423 -398266.49549146171 -353766.08301304025 -309778.65330896061 -266300.22817512782 -223326.86496866646 -180854.65629579933 -138879.72970255229 -97398.247368259792 -56406.405801845242 -15900.435540850689 24273.925691625947 64119.46438204094 103638.94287258113 142835.09957710103 181710.64919507116 220268.2829235564 258510.6686672431 296440.45124653302 334060.25260372285 371372.67200728669 408380.28625428013 445085.64987088303 481510.432119949 14 517656.88793013839 553527.25311450707 589123.74454088428 624448.56030066486 659503.87987603503 6942 91.86430564441 728814.65634873998 763074.38064777735 797073.14388952253 830813.03496465995 864296.12512592017 897519.22728669178 930484.44976633973 963193.88297443837 995649.59956983093 1027853.6546182223 1059808.085748317 1091514.913306518 1122976.1405101991 1154193.7535995643 1185169.721988108 1215905.9984116897 1246404.5190762349 1276667.2038040771 1306695.9561789527 1336492.6636896613 1366059.1978724052 1395397.4144518189 1424509.1534807039 1453396.2394784775 1482060.4815683502 1510503.6736132435 1538727.5943504588 1566734.0075251111 1594524.6620223369 FC_Econ FLUXO ECONÔMICO Critérios de avaliação n (mês) Entrada Saída Fluxo Completo Fluxo Completo Acumulado Fluxo Completo Descontado Fluxo Completo Descontado Acumulado VPL R$ 1,726,402.74 0 R$ - 0 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 VEU R$ 37,869.85 1 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 -R$ 485,283.01 R$ 49,136.69 -R$ 485,749.26 IL 4.23 2 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 -R$ 435,680.07 R$ 48,674.83 -R$ 437,074.43 TIR 9.23% 3 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 -R$ 386,077.13 R$ 48,217.30 -R$ 388,857.13 Payback Simples (mês) 11 4 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 -R$ 336,474.19 R$ 47,764.08 -R$ 341,093.05 Payback Descontado (mês) 12 5 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 -R$ 286,871.25 R$ 47,315.12 -R$ 293,777.93 6 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 -R$ 237,268.31 R$ 46,870.37 -R$ 246,907.56 Inputs 7 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 -R$ 187,665.36 R$ 46,429.81 -R$ 200,477.74 Vida útil (anos) 5 8 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 -R$ 138,062.42 R$ 45,993.39 -R$ 154,484.36 Vida útil (meses) 60 9 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 -R$ 88,459.48 R$ 45,561.07 -R$ 108,923.29 Selic (%a.m) 0.17% 10 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 -R$ 38,856.54 R$ 45,132.81 -R$ 63,790.47 TMA (%a.m) 0.95% 11 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 10,746.40 R$ 44,708.58 -R$ 19,081.89 Investimento Inicial Total R$ 534,885.95 12 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 60,349.34 R$ 44,288.34 R$ 25,206.45 Custo Fixo Mensal R$ 84,651.56 13 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 109,952.28 R$ 43,872.05 R$ 69,078.50 Número de Aulas Mensais 4838 14 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 159,555.22 R$ 43,459.67 R$ 112,538.17 Ticket Médio Total R$ 37.50 15 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 209,158.16 R$ 43,051.16 R$ 155,589.33 Custo Variável 26.00% 16 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 258,761.11 R$ 42,646.50 R$ 198,235.83 17 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 308,364.05 R$ 42,245.64 R$ 240,481.47 18 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 357,966.99 R$ 41,848.55 R$ 282,330.02 19 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 407,569.93 R$ 41,455.19 R$ 323,785.21 20 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 457,172.87 R$ 41,065.53 R$ 364,850.73 21 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 506,775.81 R$ 40,679.53 R$ 405,530.26 22 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 556,378.75 R$ 40,297.16 R$ 445,827.41 23 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 605,981.69 R$ 39,918.38 R$ 485,745.79 24 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 655,584.63 R$ 39,543.16 R$ 525,288.95 25 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 705,187.58 R$ 39,171.47 R$ 564,460.42 26 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 754,790.52 R$ 38,803.27 R$ 603,263.70 27 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 804,393.46 R$ 38,438.54 R$ 641,702.24 28 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 853,996.40 R$ 38,077.23 R$ 679,779.47 29 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 903,599.34 R$ 37,719.32 R$ 717,498.79 30 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 953,202.28 R$ 37,364.77 R$ 754,863.57 31 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,002,805.22 R$ 37,013.56 R$ 791,877.13 32 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,052,408.16 R$ 36,665.65 R$ 828,542.78 33 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,102,011.10 R$ 36,321.01 R$ 864,863.78 34 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,151,614.05 R$ 35,979.60 R$ 900,843.39 35 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,201,216.99 R$ 35,641.41 R$ 936,484.79 36 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,250,819.93 R$ 35,306.39 R$ 971,791.19 37 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,300,422.87 R$ 34,974.53 R$ 1,006,765.72 38 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,350,025.81 R$ 34,645.78 R$ 1,041,411.50 39 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,399,628.75 R$ 34,320.12 R$ 1,075,731.62 40 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,449,231.69 R$ 33,997.53 R$ 1,109,729.15 41 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,498,834.63 R$ 33,677.97 R$ 1,143,407.12 42 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,548,437.57 R$ 33,361.41 R$ 1,176,768.52 43 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,598,040.52 R$ 33,047.82 R$ 1,209,816.34 44 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,647,643.46 R$ 32,737.19 R$ 1,242,553.53 45 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,697,246.40 R$ 32,429.47 R$ 1,274,983.00 46 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,746,849.34 R$ 32,124.65 R$ 1,307,107.64 47 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,796,452.28 R$ 31,822.69 R$ 1,338,930.33 48 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,846,055.22 R$ 31,523.57 R$ 1,370,453.90 49 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,895,658.16 R$ 31,227.26 R$ 1,401,681.15 50 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,945,261.10 R$ 30,933.73 R$ 1,432,614.89 51 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 1,994,864.04 R$ 30,642.97 R$ 1,463,257.86 52 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 2,044,466.99 R$ 30,354.94 R$ 1,493,612.79 53 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 2,094,069.93 R$ 30,069.61 R$ 1,523,682.40 54 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 2,143,672.87 R$ 29,786.97 R$ 1,553,469.37 55 R$ 181,425.00 -R$ 131,822.06R$ 49,602.94 R$ 2,193,275.81 R$ 29,506.98 R$ 1,582,976.36 56 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 2,242,878.75 R$ 29,229.63 R$ 1,612,205.99 57 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 2,292,481.69 R$ 28,954.88 R$ 1,641,160.87 58 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 2,342,084.63 R$ 28,682.72 R$ 1,669,843.59 59 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 2,391,687.57 R$ 28,413.11 R$ 1,698,256.70 60 R$ 181,425.00 -R$ 131,822.06 R$ 49,602.94 R$ 2,441,290.51 R$ 28,146.04 R$ 1,726,402.74 Fluxo de Caixa Econômico Fluxo Completo -534885.95166666666 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 49602.941111111111 Fluxo Completo De scontado -534885.95166666666 49136.69320381002 48674.827841297469 48217.303829396442 47764.080361138818 47315.117013125702 46870.373741922078 46429.810880485296 45993.389134627119 45561.069579509029 45132.813656170496 44708.583168089906 44288.340277777723 43872.047503401751 43459.667715444113 43051.164133389626 42646.500322445318 42245.640190290746 41848.547983858945 41455.188286147539 41065.526013059876 40679.526410275867 40297.155050152185 39918.377828651654 39543.160962301488 39171.470985180094 38803.274745932198 38438.539404812116 38077.232430754695 37719.321598473842 37364.774985588294 37013.560969774539 36665.648225946272 36321.005723460548 35979.602723350115 35641.408775581789 35306.393716340564 34974.527665339316 34645.781023153701 34320.124468582202 33997.528956030932 33677.965712923025 33361.40623713236 33047.82229444151 32737.185916023413 32429.469395946879 32124.645288705418 31822.686406769408 31523.56581816118 31227.256844052921 30933.733056387195 30642.968275519786 30354.936567884728 30069.612243681233 29786.969854582432 29506.984191465592 29229.630282163729 28954.88338923825 28682.719007772663 28413.112863186936 28146.040909072446 Fluxo Completo Acumulado -534885.95166666666 -485283.01055555558 -435680.0694444445 -386077.12833333341 -336474.18722222233 -286871.24611111125 -237268.30500000014 -187665.36388888903 -138062.42277777792 -88459.481666666805 -38856.540555555694 10746.400555555418 60349.341666666529 109952.28277777764 159555.22388888875 209158.16499999986 258761.10611111097 308364.04722222209 357966.98833333317 407569.92944444425 457172.87055555533 506775.81166666641 556378.7527777775 605981.69388888858 655584.63499999966 705187.57611111074 754790.5172 2222182 804393.458333332 91 853996.39944444399 903599.34055555507 953202.28166666615 1002805.2227777772 1052408.1638888884 1102011.1049999995 1151614.0461111106 1201216.9872222217 1250819.9283333328 1300422.8694444438 1350025.8105555549 1399628.751666666 1449231.6927777771 1498834.6338888882 1548437.5749999993 1598040.5161111103 1647643.4572222214 1697246.3983333325 1746849.3394444436 1796452.2805555547 1846055.2216666657 1895658.1627777768 1945261.1038888879 1994864.044999999 2044466.9861111101 2094069.9272222212 2143672.8683333322 2193275.8094444433 2242878.7505555544 2292481.6916666655 2342084.6327777766 2391687.5738888877 2441290.5149999987 Fluxo Completo Descontado Acumulado -534885.95166666666 -485749.25846285664 -437074.43062155915 -38 8857.12679216271 -341093.04643102392 -293777.92941789824 -246907.55567597615 -200477.74479549087 -154484.35566086374 -108923.28608135472 -63790.47242518422 -19081.889257094314 25206.451020683409 69078.498524085153 112538.16623952927 155589.33037291889 198235.83069536422 240481.47088565497 282330.01886951394 323785.20715566148 364850.73316872137 405530.25957899727 445827.41462914948 485745.79245780112 525288.9534201026 564460.42440528271 603263.69915121491 641702.23855602706 679779.47098678176 717498.79258525558 754863.56757084385 791877.12854061835 828542.77676656458 864863.78249002516 900843.38521337532 936484.79398895707 97179 1.18770529761 1006765.7153706369 1041411.4963937906 1075731.6208623727 1109729.1498184036 1143407.1155313267 1176768.5217684591 1209816.3440629006 1242553.529978924 1274982.9993748709 1307107.6446635763 1338930.3310703456 1370453.8968885068 1401681.1537325596 1432614.8867889468 1463257.8550644666 1493612.7916323512 1523682.4038760324 1553469.3737306148 1582976.3579220804 1612205.9882042441 1641160.8715934823 1669843.590601255 1698256.7034644419 1726402.7443735143 n (mês) 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 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 Início /xl/drawings/drawing5.xml#In%C3%ADcio!A1Dados /xl/drawings/drawing5.xml#Dados!A1Análise /xl/drawings/drawing5.xml#An%C3%A1lise!A1Econômico /xl/drawings/drawing5.xml#FC_Econ!A1Fluxos de caixa Inflação /xl/drawings/drawing5.xml#FC_Infla%C3%A7%C3%A3o!A1Contábil /xl/drawings/drawing5.xml#FC_sem_Infla%C3%A7%C3%A3o!A1Financiamento /xl/drawings/drawing5.xml#FC_PRICE!A1 FC_sem_Inflação FLUXO DE CAIXA CONTÁBIL - SEM INFLAÇÃO E SEM FINANCIAMENTO Critérios de avaliação n (mês) Fluxo Econômico Fluxo Contábil Fluxo Completo Fluxo Completo Acumulado Fluxo Completo Descontado Fluxo Completo Descontado Acumulado VPL R$ 1,251,579.99 0 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 VEU R$ 27,454.28 1 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 495,698.58 R$ 38,819.03 -R$ 496,066.92 IL 3.34 2 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 456,511.20 R$ 38,454.14 -R$ 457,612.78 TIR 7.21% 3 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 417,323.83 R$ 38,092.69 -R$ 419,520.09 Payback Simples(mês) 14 4 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 378,136.46 R$ 37,734.63 -R$ 381,785.45 Payback Descontado(mês) 15 5 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 338,949.08 R$ 37,379.94 -R$ 344,405.51 6 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 299,761.71 R$ 37,028.59 -R$ 307,376.92 Inputs 7 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 260,574.34 R$ 36,680.53 -R$ 270,696.39 Vida útil (anos) 5 8 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 221,386.96R$ 36,335.75 -R$ 234,360.64 Vida útil (meses) 60 9 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 182,199.59 R$ 35,994.21 -R$ 198,366.43 Selic (%a.m) 0.17% 10 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 143,012.22 R$ 35,655.88 -R$ 162,710.55 TMA (%a.m) 0.95% 11 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 103,824.84 R$ 35,320.73 -R$ 127,389.82 IR 21% 12 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 64,637.47 R$ 34,988.73 -R$ 92,401.10 Entrada Mensal R$ 181,425.00 13 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 -R$ 25,450.10 R$ 34,659.85 -R$ 57,741.25 Saída Mensal -R$ 131,822.06 14 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 13,737.28 R$ 34,334.06 -R$ 23,407.19 Aluguel R$ 16,125.00 15 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 52,924.65 R$ 34,011.33 R$ 10,604.14 16 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 92,112.02 R$ 33,691.64 R$ 44,295.78 Depreciação 17 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 131,299.40 R$ 33,374.95 R$ 77,670.73 Valor de Mercado R$ 354,885.95 18 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 170,486.77 R$ 33,061.24 R$ 110,731.96 Valor de Depreciação Mensal R$ 2,829.91 19 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 209,674.14 R$ 32,750.48 R$ 143,482.44 20 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 248,861.52 R$ 32,442.63 R$ 175,925.08 21 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 288,048.89 R$ 32,137.69 R$ 208,062.76 22 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 327,236.26 R$ 31,835.61 R$ 239,898.37 23 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 366,423.64 R$ 31,536.36 R$ 271,434.73 24 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 405,611.01 R$ 31,239.93 R$ 302,674.67 25 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 444,798.39 R$ 30,946.29 R$ 333,620.96 26 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 483,985.76 R$ 30,655.41 R$ 364,276.36 27 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 523,173.13 R$ 30,367.26 R$ 394,643.62 28 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 562,360.51 R$ 30,081.82 R$ 424,725.44 29 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 601,547.88 R$ 29,799.06 R$ 454,524.51 30 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 640,735.25 R$ 29,518.96 R$ 484,043.47 31 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 679,922.63 R$ 29,241.50 R$ 513,284.97 32 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 719,110.00 R$ 28,966.64 R$ 542,251.60 33 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 758,297.37 R$ 28,694.36 R$ 570,945.97 34 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 797,484.75 R$ 28,424.65 R$ 599,370.62 35 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 836,672.12 R$ 28,157.47 R$ 627,528.08 36 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 875,859.49 R$ 27,892.80 R$ 655,420.88 37 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 915,046.87 R$ 27,630.62 R$ 683,051.50 38 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 954,234.24 R$ 27,370.90 R$ 710,422.40 39 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 993,421.61 R$ 27,113.62 R$ 737,536.02 40 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,032,608.99 R$ 26,858.77 R$ 764,394.79 41 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,071,796.36 R$ 26,606.31 R$ 791,001.10 42 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,110,983.73 R$ 26,356.22 R$ 817,357.31 43 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,150,171.11 R$ 26,108.48 R$ 843,465.79 44 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,189,358.48 R$ 25,863.07 R$ 869,328.86 45 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,228,545.85 R$ 25,619.97 R$ 894,948.83 46 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,267,733.23 R$ 25,379.15 R$ 920,327.98 47 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,306,920.60 R$ 25,140.60 R$ 945,468.58 48 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,346,107.98 R$ 24,904.28 R$ 970,372.86 49 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,385,295.35 R$ 24,670.19 R$ 995,043.06 50 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,424,482.72 R$ 24,438.30 R$ 1,019,481.36 51 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,463,670.10 R$ 24,208.59 R$ 1,043,689.95 52 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,502,857.47 R$ 23,981.04 R$ 1,067,671.00 53 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,542,044.84 R$ 23,755.63 R$ 1,091,426.63 54 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,581,232.22 R$ 23,532.34 R$ 1,114,958.96 55 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,620,419.59 R$ 23,311.14 R$ 1,138,270.10 56 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,659,606.96 R$ 23,092.03 R$ 1,161,362.13 57 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,698,794.34 R$ 22,874.97 R$ 1,184,237.10 58 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,737,981.71 R$ 22,659.96 R$ 1,206,897.06 59 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,777,169.08 R$ 22,446.96 R$ 1,229,344.02 60 R$ 49,602.94 -R$ 10,415.57 R$ 39,187.37 R$ 1,816,356.46 R$ 22,235.97 R$ 1,251,579.99 Fluxo Contábil - Sem Inflação e Sem Financiamento Fluxo Completo 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 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 -534885.95166666666 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.37347777 7779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 39187.373477777779 Fluxo Completo Descontado 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 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 -534885.95166666666 38819.027761427758 38454.144348230831 38092.690693915145 37734.634560112085 37379.944011480831 37028.587412860092 36680.533426446484 36335.751008999527 35994.209409072813 35655.878164271315 35320.727098534408 34988.726319444402 34659.846215560457 34334.057453777481 34011.330976709905 33691.638000100029 33374.950010250701 33061.238761482186 32750.476273612894 32442.634829463819 32137.686972386397 31835.605503813636 31536.36348083425 31239.934213789606 30946.291263893232 30655.408440872714 30367.259800633805 30081.819642946415 29799.062509152376 29518.963179894767 29241.49667286861628966.638240592656 28694.363368202106 28424.647771262138 28157.467393601972 27892.798405169251 27630.617199904627 27370.900393636311 27113.624821994432 26858.767538344979 26606.305811743157 26356.217124906008 26108.479172204086 25863.069857671981 25619.96729303756 25379.149795769732 25140.595887144584 24904.284290329659 24670.193928486246 24438.303922889536 24208.59359106643 23981.042444950846 23755.630189056359 23532.336718666051 23311.142118039334 23092.026658635674 22874.970797354938 22659.955174794377 22446.960613521922 22235.968116365737 Fluxo Completo Acumulado -534885.95166666666 -495698.5781888889 -456511.20471111115 -417323.83123333339 -378136.45775555563 -338949.08427777787 -299761.71080000012 -260574.33732222233 -221386.96384444454 -182199.59036666676 -143012.21688888897 -103824.84341111119 -64637.469933333407 -25450.096455555627 13737.277022222152 52924.650499999931 92112.023977777717 131299.3974555555 170486.77093333329 209674.14441111108 248861.51788888886 288048.89136666665 327236.26484444441 366423.63832222216 405611.01179999992 444798.38527777768 483985.75875555543 523173.132233333 19 562360.50571111101 601547.87918888882 640735.25266666664 679922.62614444445 719109.99962222227 758297.37310000008 797484.7465777779 836672.12005555572 875859.49353333353 915046.86701111135 954234.24048888916 993421.61396666698 1032608.9874444448 1071796.3609222225 1110983.7344000002 1150171.1078777779 1189358.4813555556 1228545.8548333333 1267733.228311111 1306920.6017888887 1346107.9752666664 1385295.3487444441 1424482.7222222218 1463670.0956999995 1502857.4691777772 1542044.8426555549 1581232.2161333326 1620419.5896111103 1659606.963088888 1698794.3365666657 1737981.7100444434 1777169.0835222211 1816356.4569999988 Fluxo Completo Descontado Acumulado -534885.95166666666 -496066.92390523892 -457612.77955700806 -419520.08886309294 -381785.45430298086 -344405.51029150002 -307376.92287863995 -270696.38945219346 -234360.63844319392 -198366.4290341211 -162710.5508698498 -127389.82377131539 -92401.097451870999 -57741.251236310542 -23407.193782533061 10604.137194176845 44295.775194276874 77670.725204527582 110731.96396600976 143482.44023962267 175925.07506908648 208062.76204147289 239898.36754528651 271434.73102612077 302674.66523991036 333620.95650380361 364276.36494467634 394643.62474531017 424725.44438825658 454524.50689740898 484043.47007730376 513284.96675017237 542251.60499076499 570945.9683589671 599370.6161302292 627528.08352383121 655420.88192900049 683051.49912890512 710422.39952254144 737536.02434453589 764394.79188288085 791001.09769462398 817357.31481953 843465.79399173404 869328.86384940601 894948.83114244358 920327.9809382133 945468.57682535786 970372.86111568753 995043.05504417373 1019481.3589670633 1043689.9525581297 1067670.9950030805 1091426.6251921367 1114958.9619108029 1138270.1040288422 1161362.1306874778 1184237.1014848328 1206897.0566596272 1229344.0172731492 1251579.9853895151 Início /xl/drawings/drawing6.xml#In%C3%ADcio!A1Dados /xl/drawings/drawing6.xml#Dados!A1Análise /xl/drawings/drawing6.xml#An%C3%A1lise!A1Econômico /xl/drawings/drawing6.xml#FC_Econ!A1Fluxos de caixa Inflação /xl/drawings/drawing6.xml#FC_Infla%C3%A7%C3%A3o!A1Contábil /xl/drawings/drawing6.xml#FC_sem_Infla%C3%A7%C3%A3o!A1Financiamento /xl/drawings/drawing6.xml#FC_PRICE!A1 FC_Inflação FLUXO DE CAIXA CONTÁBIL - COM INFLAÇÃO E SEM FINANCIAMENTO Critérios de avaliação n (mês) Entrada Saída IPCA Saída IGP-M Fluxo antes do IR Fluxo Contábil Fluxo Contábil + Inflação Fluxo Completo Acumulado Fluxo Contábil Descontado Fluxo Contábil Descontado Acumulado VPL R$ 1,315,338.86 0 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 VEU R$ 28,852.87 1 R$ 181,732.06 -R$ 115,892.87 -R$ 16,321.45 R$ 49,517.74 -R$ 9,804.44 R$ 39,713.29 -R$ 495,172.66 R$ 39,340.00 -R$ 495,545.95 IL 3.46 2 R$ 182,039.64 -R$ 116,089.02 -R$ 16,520.29 R$ 49,430.32 -R$ 9,786.09 R$ 39,644.24 -R$ 455,528.42 R$ 38,902.46 -R$ 456,643.49 TIR 7.30% 3 R$ 182,347.74 -R$ 116,285.50 -R$ 16,721.56 R$ 49,340.68 -R$ 9,767.26 R$ 39,573.42 -R$ 415,955.00 R$ 38,467.95 -R$ 418,175.54 Payback Simples(mês) 14 4 R$ 182,656.36 -R$ 116,482.31 -R$ 16,925.28 R$ 49,248.77 -R$ 9,747.96 R$ 39,500.81 -R$ 376,454.19 R$ 38,036.45 -R$ 380,139.09 Payback Descontado(mês) 15 5 R$ 182,965.51 -R$ 116,679.46 -R$ 17,131.48 R$ 49,154.57 -R$ 9,728.18 R$ 39,426.39 -R$ 337,027.80 R$ 37,607.94 -R$ 342,531.15 6 R$ 183,275.17 -R$ 116,876.94 -R$ 17,340.19 R$ 49,058.05 -R$ 9,707.91 R$ 39,350.14 -R$ 297,677.66 R$ 37,182.39 -R$ 305,348.76 Inputs 7 R$ 183,585.36 -R$ 117,074.75 -R$ 17,551.44 R$ 48,959.17 -R$ 9,687.14 R$ 39,272.03 -R$ 258,405.63 R$ 36,759.77 -R$ 268,588.99 Vida útil (anos) 5 8 R$ 183,896.08 -R$ 117,272.90 -R$ 17,765.27 R$ 48,857.91 -R$ 9,665.88 R$ 39,192.03 -R$ 219,213.60 R$ 36,340.07 -R$ 232,248.92 Vida útil (meses) 60 9 R$ 184,207.32 -R$ 117,471.38 -R$ 17,981.70 R$ 48,754.24 -R$ 9,644.11 R$ 39,110.13 -R$ 180,103.47 R$ 35,923.26 -R$ 196,325.66 Selic (%a.m) 0.17% 10 R$ 184,519.09 -R$ 117,670.20 -R$ 18,200.77 R$ 48,648.12 -R$ 9,621.82 R$ 39,026.30 -R$ 141,077.18 R$ 35,509.32 -R$ 160,816.34 TMA (%a.m) 0.95% 11 R$ 184,831.39 -R$ 117,869.36 -R$ 18,422.51 R$ 48,539.52 -R$ 9,599.02 R$ 38,940.50 -R$ 102,136.67 R$ 35,098.22 -R$ 125,718.13 Entrada Mensal R$ 181,425.00 12 R$ 185,144.21 -R$ 118,068.85 -R$ 18,646.95 R$ 48,428.41 -R$ 9,575.69 R$ 38,852.73 -R$ 63,283.95 R$ 34,689.94 -R$ 91,028.19 Saída Mensal -R$ 131,822.06 13 R$ 185,602.33 -R$ 118,361.00 -R$ 18,711.14 R$ 48,530.19 -R$ 9,597.06 R$ 38,933.13 -R$ 24,350.81 R$ 34,434.98 -R$ 56,593.21 Aluguel R$ 16,125.00 14 R$ 186,061.58 -R$ 118,653.87 -R$ 18,775.55 R$ 48,632.16 -R$ 9,618.47 R$ 39,013.69 R$ 14,662.88 R$ 34,181.88 -R$ 22,411.32 15 R$ 186,521.97 -R$ 118,947.46 -R$ 18,840.18 R$ 48,734.32 -R$ 9,639.93 R$ 39,094.40 R$ 53,757.27 R$ 33,930.63 R$ 11,519.31 Depreciação 16 R$ 186,983.49 -R$ 119,241.78 -R$ 18,905.04 R$ 48,836.67 -R$ 9,661.42 R$ 39,175.25 R$ 92,932.53 R$ 33,681.22 R$ 45,200.53 Valor de Mercado R$ 354,885.95 17 R$ 187,446.16 -R$ 119,536.83 -R$ 18,970.12 R$ 48,939.21 -R$ 9,682.95 R$ 39,256.26 R$ 132,188.78 R$ 33,433.62 R$ 78,634.14 Valor de Depreciação Mensal R$ 2,829.91 18 R$ 187,909.97 -R$ 119,832.61 -R$ 19,035.42 R$ 49,041.94 -R$ 9,704.53 R$ 39,337.42 R$ 171,526.20 R$ 33,187.82 R$ 111,821.97 19 R$ 188,374.94 -R$ 120,129.12 -R$ 19,100.95 R$ 49,144.86 -R$ 9,726.14 R$ 39,418.72 R$ 210,944.92 R$ 32,943.82 R$ 144,765.79 20 R$ 188,841.05 -R$ 120,426.37 -R$ 19,166.70 R$ 49,247.98 -R$ 9,747.79 R$ 39,500.18 R$ 250,445.11 R$ 32,701.60 R$ 177,467.40 21 R$ 189,308.31 -R$ 120,724.35 -R$ 19,232.68 R$ 49,351.28 -R$ 9,769.49 R$ 39,581.79 R$ 290,026.90 R$ 32,461.15 R$ 209,928.55 22 R$ 189,776.73 -R$ 121,023.07 -R$ 19,298.89 R$ 49,454.78 -R$ 9,791.22 R$ 39,663.56 R$ 329,690.45 R$ 32,222.45 R$ 242,151.00 23 R$ 190,246.31 -R$ 121,322.52 -R$ 19,365.32 R$ 49,558.47 -R$ 9,813.00 R$ 39,745.47 R$ 369,435.92 R$ 31,985.50 R$ 274,136.50 24 R$ 190,717.05 -R$ 121,622.72 -R$ 19,431.99 R$ 49,662.35 -R$ 9,834.81 R$ 39,827.53 R$ 409,263.46 R$ 31,750.27 R$ 305,886.76 25 R$ 191,264.58 -R$ 121,971.89 -R$ 19,495.60 R$ 49,797.09 -R$ 9,863.11 R$ 39,933.98 R$ 449,197.44 R$ 31,535.89 R$ 337,422.66 26 R$ 191,813.68 -R$ 122,322.06 -R$ 19,559.43 R$ 49,932.20 -R$ 9,891.48 R$ 40,040.72 R$ 489,238.16 R$ 31,322.96 R$ 368,745.62 27 R$ 192,364.36 -R$ 122,673.23 -R$ 19,623.46 R$ 50,067.67 -R$ 9,919.93 R$ 40,147.74 R$ 529,385.91 R$ 31,111.47 R$ 399,857.09 28 R$ 192,916.62 -R$ 123,025.41 -R$ 19,687.70 R$ 50,203.51 -R$ 9,948.46 R$ 40,255.05 R$ 569,640.96 R$ 30,901.41 R$ 430,758.50 29 R$ 193,470.46 -R$ 123,378.61 -R$ 19,752.15 R$ 50,339.71 -R$ 9,977.06 R$ 40,362.65 R$ 610,003.61 R$ 30,692.77 R$ 461,451.28 30 R$ 194,025.90 -R$ 123,732.81 -R$ 19,816.82 R$ 50,476.27 -R$ 10,005.74 R$ 40,470.53 R$ 650,474.14 R$ 30,485.54 R$ 491,936.81 31 R$ 194,582.93 -R$ 124,088.04 -R$ 19,881.69 R$ 50,613.20 -R$ 10,034.49 R$ 40,578.71R$ 691,052.85 R$ 30,279.71 R$ 522,216.52 32 R$ 195,141.55 -R$ 124,444.28 -R$ 19,946.78 R$ 50,750.49 -R$ 10,063.32 R$ 40,687.17 R$ 731,740.02 R$ 30,075.26 R$ 552,291.78 33 R$ 195,701.79 -R$ 124,801.55 -R$ 20,012.08 R$ 50,888.16 -R$ 10,092.23 R$ 40,795.93 R$ 772,535.94 R$ 29,872.20 R$ 582,163.99 34 R$ 196,263.63 -R$ 125,159.84 -R$ 20,077.59 R$ 51,026.19 -R$ 10,121.22 R$ 40,904.97 R$ 813,440.92 R$ 29,670.51 R$ 611,834.50 35 R$ 196,827.08 -R$ 125,519.16 -R$ 20,143.32 R$ 51,164.59 -R$ 10,150.28 R$ 41,014.31 R$ 854,455.23 R$ 29,470.18 R$ 641,304.68 36 R$ 197,392.15 -R$ 125,879.52 -R$ 20,209.27 R$ 51,303.37 -R$ 10,179.43 R$ 41,123.94 R$ 895,579.17 R$ 29,271.21 R$ 670,575.89 37 R$ 197,918.95 -R$ 126,215.46 -R$ 20,270.38 R$ 51,433.10 -R$ 10,206.67 R$ 41,226.43 R$ 936,805.60 R$ 29,068.34 R$ 699,644.23 38 R$ 198,447.16 -R$ 126,552.31 -R$ 20,331.68 R$ 51,563.17 -R$ 10,233.98 R$ 41,329.18 R$ 978,134.79 R$ 28,866.87 R$ 728,511.10 39 R$ 198,976.78 -R$ 126,890.05 -R$ 20,393.17 R$ 51,693.55 -R$ 10,261.36 R$ 41,432.19 R$ 1,019,566.97 R$ 28,666.81 R$ 757,177.91 40 R$ 199,507.81 -R$ 127,228.70 -R$ 20,454.84 R$ 51,824.27 -R$ 10,288.81 R$ 41,535.45 R$ 1,061,102.43 R$ 28,468.12 R$ 785,646.03 41 R$ 200,040.26 -R$ 127,568.25 -R$ 20,516.70 R$ 51,955.31 -R$ 10,316.33 R$ 41,638.97 R$ 1,102,741.40 R$ 28,270.82 R$ 813,916.85 42 R$ 200,574.13 -R$ 127,908.70 -R$ 20,578.75 R$ 52,086.67 -R$ 10,343.92 R$ 41,742.75 R$ 1,144,484.15 R$ 28,074.89 R$ 841,991.74 43 R$ 201,109.42 -R$ 128,250.07 -R$ 20,640.98 R$ 52,218.37 -R$ 10,371.58 R$ 41,846.79 R$ 1,186,330.94 R$ 27,880.31 R$ 869,872.05 44 R$ 201,646.14 -R$ 128,592.34 -R$ 20,703.41 R$ 52,350.39 -R$ 10,399.30 R$ 41,951.09 R$ 1,228,282.04 R$ 27,687.08 R$ 897,559.13 45 R$ 202,184.30 -R$ 128,935.53 -R$ 20,766.02 R$ 52,482.75 -R$ 10,427.10 R$ 42,055.65 R$ 1,270,337.69 R$ 27,495.20 R$ 925,054.33 46 R$ 202,723.89 -R$ 129,279.63 -R$ 20,828.82 R$ 52,615.44 -R$ 10,454.96 R$ 42,160.48 R$ 1,312,498.17 R$ 27,304.64 R$ 952,358.97 47 R$ 203,264.92 -R$ 129,624.66 -R$ 20,891.81 R$ 52,748.46 -R$ 10,482.89 R$ 42,265.56 R$ 1,354,763.73 R$ 27,115.40 R$ 979,474.37 48 R$ 203,807.40 -R$ 129,970.60 -R$ 20,954.99 R$ 52,881.81 -R$ 10,510.90 R$ 42,370.91 R$ 1,397,134.64 R$ 26,927.48 R$ 1,006,401.85 49 R$ 204,351.32 -R$ 130,317.47 -R$ 21,018.36 R$ 53,015.49 -R$ 10,538.97 R$ 42,476.52 R$ 1,439,611.16 R$ 26,740.86 R$ 1,033,142.70 50 R$ 204,896.69 -R$ 130,665.26 -R$ 21,081.92 R$ 53,149.51 -R$ 10,567.12 R$ 42,582.39 R$ 1,482,193.55 R$ 26,555.53 R$ 1,059,698.23 51 R$ 205,443.52 -R$ 131,013.98 -R$ 21,145.68 R$ 53,283.86 -R$ 10,595.33 R$ 42,688.53 R$ 1,524,882.08 R$ 26,371.49 R$ 1,086,069.72 52 R$ 205,991.81 -R$ 131,363.63 -R$ 21,209.63 R$ 53,418.55 -R$ 10,623.62 R$ 42,794.94 R$ 1,567,677.02 R$ 26,188.72 R$ 1,112,258.44 53 R$ 206,541.56 -R$ 131,714.22 -R$ 21,273.77 R$ 53,553.58 -R$ 10,651.97 R$ 42,901.61 R$ 1,610,578.63 R$ 26,007.22 R$ 1,138,265.67 54 R$ 207,092.78 -R$ 132,065.74 -R$ 21,338.11 R$ 53,688.94 -R$ 10,680.40 R$ 43,008.55 R$ 1,653,587.18 R$ 25,826.98 R$ 1,164,092.65 55 R$ 207,645.48 -R$ 132,418.19 -R$ 21,402.64 R$ 53,824.65 -R$ 10,708.89 R$ 43,115.75 R$ 1,696,702.93 R$ 25,647.99 R$ 1,189,740.64 56 R$ 208,199.64 -R$ 132,771.59 -R$ 21,467.36 R$ 53,960.69 -R$ 10,737.46 R$ 43,223.22 R$ 1,739,926.15 R$ 25,470.24 R$ 1,215,210.88 57 R$ 208,755.29 -R$ 133,125.93 -R$ 21,532.28 R$ 54,097.07 -R$ 10,766.10 R$ 43,330.97 R$ 1,783,257.12 R$ 25,293.72 R$ 1,240,504.61 58 R$ 209,312.41 -R$ 133,481.22 -R$ 21,597.40 R$ 54,233.79 -R$ 10,794.82 R$ 43,438.98 R$ 1,826,696.10 R$ 25,118.43 R$ 1,265,623.04 59 R$ 209,871.03 -R$ 133,837.46 -R$ 21,662.71 R$ 54,370.86 -R$ 10,823.60 R$ 43,547.26 R$ 1,870,243.36 R$ 24,944.35 R$ 1,290,567.39 60 R$ 210,431.14 -R$ 134,194.64 -R$ 21,728.23 R$ 54,508.26 -R$ 10,852.45 R$ 43,655.81 R$ 1,913,899.16 R$ 24,771.48 R$ 1,315,338.86 Fluxo Contábil - Com Inflação e Sem Financiamento Fluxo Contábil + Inflação 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 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 -534885.95166666666 39713.292051734141 39644.23744691327 39573.418067524253 39500.810850457427 39426.392448981649 39350.139229284483 39272.027266970174 39192.032343515006 39110.129942679567 39026.295246877067 38940.503133497608 38852.728171187533 38933.134059318916 39013.689813329038 39094.395635059416 39175.251726269285 39256.258288633391 39337.415523739786 39418.723633087589 39500.182818084759 39581.793280045807 39663.555220189519 39745.468839636778 39827.534339408085 39933.984913938788 40040.720852082377 40147.74290681132 40255.051833042868 40362.648387643843 40470.533329435581 40578.7 07419198799 40687.171419678474 40795.92609558886 40904.972213618268 41014.310542434192 41123.941852688091 41226.434022551999 41329.182565949108 41432.188115200908 41535.451304159527 41638.972768211301 41742.753144280425 41846.793070832558 41951.093187878476 42055.654136977741 42160.476561242249 42265.561105340021 42370.908415498801 42476.519139509692 42582.393926730954 42688.533428091592 42794.938296095141 42901.609184823275 43008.546749939611 43115.751648693426 43223.224539923358 43330.966084061183 43438.97694313556 43547.257780775719 43655.809262215378 Fluxo Contábil Descontado 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 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 -534885.95166666666 39340.002910074552 38902.460003440647 38467.951290535915 38036.45230562277 37607.938770209657 37182.386591590548 36759.771861395639 36340.070854153426 35923.260025863994 35509.316012583113 35098.215629017679 34689.93586713168 34434.980439579966 34181.884333082176 33930.634060801829 33681.216233405641 33433.617558359671 33187.824839230525 32943.824974991599 32701.604959334345 32461.151879984467 32222.452918023097 31985.495347212938 31750.266533329072 31535.890742344 993 31322.9630631820 73 31111.47369832169 30901.412916733323 30692.771053421042 30485.538508973284 30279.70574911567 30075.263304266777 29872.201769097181 29670.511802091274 29470.184125112373 29271.209522970523 29068.337984943584 28866.873152508921 28666.805259272969 28468.124606802074 28270.821564147845 28074.886567375946 27880.310119098147 27687.082788007639 27495.195208417677 27304.638079803321 27115.402166346612 26927.478296484755 26740.857362461484 26555.53031988172 26371.488187269202 26188.722045627313 26007.223038002881 25826.982369053192 25647.991304615924 25470.241171282152 25293.723355972288 25118.429305515092 24944.350526229515 24771.478583509619 Fluxo Completo Acumulado -534885.95166666666 -495172.65961493249 -455528.42216801923 -415955.00410049496 -376454.19325003756 -337027.80080105591 -297677.66157177143 -258405.63430480126 -219213.60196128627 -180103.4720186067 -141077.17677172963 -102136.67363823202 -63283.94546704449 -24350.811407725574 14662.878405603464 53757.27404066288 92932.525766932173 132188.78405556557 171526.19957930536 210944.92321239295250445.10603047771 290026.89931052353 329690.45453071303 369435.9233703498 409263.4577097579 449197.4426236967 489238.16347577906 529385.90638259042 569640.95821563329 610003.60660327715 650474.13993271277 691052.84735191159 731740.01877159008 772535.94486717891 813440.91708079714 854455.22762323136 895579.16947591945 936805.60349847144 978134.78606442059 1019566.9741796216 1061102.4254837811 1102741.3982519924 1144484.1513962729 1186330.9444671054 1228282.0376549838 1270337.6917919614 1312498.1683532037 1354763.7294585437 1397134.6378740426 1439611.1570135523 1482193.5509402831 1524882.0843683747 1567677.0226 644699 1610578.6318492931 1653587.1785992328 1696702.9302479262 1739926.1547878494 1783257.1208719106 1826696.0978150461 1870243.3555958217 1913899.1648580371 Fluxo Contábil Descontado Acumulado -534885.95166666666 -495545.94875659212 -456643.4887531515 -418175.53746261558 -380139.08515699283 -342531.14638678316 -305348.75979519263 -268588.98793379701 -232248.91707964358 -196325.65705377958 -160816.34104119646 -125718.12541217878 -91028.189545047091 -56593.209105467125 -22411.324772384949 11519.30928841688 45200.525521822521 78634.143080182199 111821.96791941272 144765.79289440432 177467.39785373866 209928.54973372314 242151.002 65174624 274136.49799895915 305886.76453228825 337422.65527463326 368745.61833781534 399857.09203613701 430758.50495287031 461451.27600629133 491936.81451526459 522216.52026438026 552291.78356864699 582163.98533774412 611834.49713983538 641304.68126494775 670575.89078791824 699644.22877286177 728511.10192537063 757177.90718464355 785646.03179144568 813916.85335559351 841991.73992296949 869872.05004206765 897559.13283007534 925054.32803849305 952358.96611829638 979474.36828464293 1006401.8465811277 1033142.7039435892 1059698.2342634709 1086069.7224507402 1112258.4444963676 1138265.6675343704 1164092.6499034236 1189740.6412080396 1215210.8 823793218 1240504.6057352941 1265623.0350408091 1290567.3855670386 1315338.8641505481 Início /xl/drawings/drawing7.xml#In%C3%ADcio!A1Dados /xl/drawings/drawing7.xml#Dados!A1Análise /xl/drawings/drawing7.xml#An%C3%A1lise!A1Econômico /xl/drawings/drawing7.xml#FC_Econ!A1Fluxos de caixa Inflação /xl/drawings/drawing7.xml#FC_Infla%C3%A7%C3%A3o!A1Contábil /xl/drawings/drawing7.xml#FC_sem_Infla%C3%A7%C3%A3o!A1Financiamento /xl/drawings/drawing7.xml#FC_PRICE!A1 Pesquisa Itens INVESTIMENTO CUSTOS VARIAVEIS CUSTOS FIXOS RECEITAS TAXAS Bikes (45) Taxa de Publicidade Luz Aulas avulsas Impostos débito e crédito Bebedouro Royalties Funcionários (secretário, 5 professores, 2 limpeza) Pacotes de Aula IR Caixas de Som mimos : toalhas à vontade, sapatilhas para usar na bike, demaquilante, shampoo, condicionador e hidratante. Água Depreciação Espelho Aluguel Banheiro Telefone Taxa de Franquia Internet Iluminação Pro-labore TVs Material de Limpeza VICTOR Reforma do Local Material de Escritório ELISA Cadeiras Investimento em MKT LELEO Computador Contador KAIANA Impressora Telefone Ar condicionado / Climatizador Chuveiro (20) FC_PRICE TABELA PRICE Parcelas Juros Amortização Pagamento Saldo devedor F. Contábil F. Completo FCA FC Descontado FCDA BB Sicoob Caixa 0 R$ - 0 R$ - 0 R$ - 0 R$ 317,757.75 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 -R$ 534,885.95 Juros (a.a) 9.89% 5.78% 15.30% 1 R$ 1,491.42 R$ 4,597.54 R$ 6,088.97 R$ 313,160.21 R$ 39,713.29 R$ 33,624.33 -R$ 501,261.63 R$ 33,308.27 -R$ 501,577.68 Juros (a.m) 0.79% 0.47% 1.19% 2 R$ 1,469.84 R$ 4,619.12 R$ 6,088.97 R$ 308,541.09 R$ 39,644.24 R$ 33,555.27 -R$ 467,706.35 R$ 32,927.42 -R$ 468,650.26 Investimento inicial R$ 317,757.75 R$ 317,757.75 R$ 317,757.75 3 R$ 1,448.16 R$ 4,640.80 R$ 6,088.97 R$ 303,900.28 R$ 39,573.42 R$ 33,484.45 -R$ 434,221.90 R$ 32,549.08 -R$ 436,101.18 Período (meses) 60 60 60 4 R$ 1,426.38 R$ 4,662.58 R$ 6,088.97 R$ 299,237.70 R$ 39,500.81 R$ 33,411.84 -R$ 400,810.06 R$ 32,173.21 -R$ 403,927.97 % investimento 5 R$ 1,404.50 R$ 4,684.47 R$ 6,088.97 R$ 294,553.23 R$ 39,426.39 R$ 33,337.43 -R$ 367,472.63 R$ 31,799.81 -R$ 372,128.15 59% 6 R$ 1,382.51 R$ 4,706.45 R$ 6,088.97 R$ 289,846.78 R$ 39,350.14 R$ 33,261.17 -R$ 334,211.46 R$ 31,428.85 -R$ 340,699.30 7 R$ 1,360.42 R$ 4,728.54 R$ 6,088.97 R$ 285,118.23 R$ 39,272.03 R$ 33,183.06 -R$ 301,028.40 R$ 31,060.32 -R$ 309,638.98 8 R$ 1,338.23 R$ 4,750.74 R$ 6,088.97 R$ 280,367.49 R$ 39,192.03 R$ 33,103.07 -R$ 267,925.33 R$ 30,694.19 -R$ 278,944.79 Critérios de avaliação 9 R$ 1,315.93 R$ 4,773.04 R$ 6,088.97 R$ 275,594.46 R$ 39,110.13 R$ 33,021.16 -R$ 234,904.17 R$ 30,330.45 -R$ 248,614.34 VPL R$ 1,037,756.33 10 R$ 1,293.53 R$ 4,795.44 R$ 6,088.97 R$ 270,799.02 R$ 39,026.30 R$ 32,937.33 -R$ 201,966.84 R$ 29,969.08 -R$ 218,645.26 VEU R$ 22,763.91 11 R$ 1,271.02 R$ 4,817.95 R$ 6,088.97 R$ 265,981.07 R$ 38,940.50 R$ 32,851.54 -R$ 169,115.30 R$ 29,610.05 -R$ 189,035.21 IL 2.94 12 R$ 1,248.41 R$ 4,840.56 R$ 6,088.97 R$ 261,140.51 R$ 38,852.73 R$ 32,763.76 -R$ 136,351.54 R$ 29,253.36 -R$ 159,781.85 TIR 6.11% 13 R$ 1,225.69 R$ 4,863.28 R$ 6,088.97 R$ 256,277.23 R$ 38,933.13 R$ 32,844.17 -R$ 103,507.37 R$ 29,049.51 -R$ 130,732.34 Payback Simples(mês) 17 14 R$ 1,202.86 R$ 4,886.11 R$ 6,088.97 R$ 251,391.12 R$ 39,013.69 R$ 32,924.72 -R$ 70,582.65 R$ 28,847.03 -R$ 101,885.31 Payback Descontado(mês) 18 15 R$ 1,179.93 R$ 4,909.04 R$ 6,088.97 R$ 246,482.08 R$ 39,094.40 R$ 33,005.43 -R$ 37,577.22 R$ 28,645.93 -R$ 73,239.39 Total de Juros Pagos R$ 47,580.21 16 R$ 1,156.89 R$ 4,932.08 R$ 6,088.97 R$ 241,550.00 R$ 39,175.25 R$ 33,086.29 -R$ 4,490.93 R$ 28,446.18 -R$ 44,793.20 17 R$ 1,133.74 R$ 4,955.23 R$ 6,088.97 R$ 236,594.77 R$ 39,256.26 R$ 33,167.29 R$ 28,676.36 R$ 28,247.79 -R$ 16,545.41 Inputs 18 R$ 1,110.48 R$ 4,978.49 R$ 6,088.97 R$ 231,616.28 R$ 39,337.42 R$ 33,248.45 R$ 61,924.81 R$ 28,050.74 R$ 11,505.33 Vida útil (anos) 5 19 R$ 1,087.11 R$ 5,001.85 R$ 6,088.97 R$ 226,614.43 R$ 39,418.72 R$ 33,329.76 R$ 95,254.57 R$ 27,855.03 R$ 39,360.36 Vida útil (meses) 60 20 R$ 1,063.63 R$ 5,025.33 R$ 6,088.97 R$ 221,589.10 R$ 39,500.18 R$ 33,411.22 R$ 128,665.78 R$ 27,660.64 R$ 67,021.00 Selic (%a.m) 0.17% 21 R$ 1,040.05 R$ 5,048.92 R$ 6,088.97 R$ 216,540.18 R$ 39,581.79 R$ 33,492.83 R$ 162,158.61 R$ 27,467.57 R$ 94,488.57 TMA (%a.m) 0.95% 22 R$ 1,016.35 R$ 5,072.62 R$ 6,088.97 R$ 211,467.56 R$ 39,663.56 R$ 33,574.59 R$ 195,733.20 R$ 27,275.81 R$ 121,764.38 IR 21.00% 23 R$ 992.54 R$ 5,096.42 R$ 6,088.97 R$ 206,371.14 R$ 39,745.47 R$ 33,656.50 R$ 229,389.70 R$ 27,085.35 R$ 148,849.73 Investimento Inicial R$ 534,885.95 24 R$ 968.62 R$ 5,120.35 R$ 6,088.97 R$ 201,250.79 R$ 39,827.53 R$ 33,738.57 R$ 263,128.27 R$ 26,896.18 R$ 175,745.91 25 R$ 944.59 R$5,144.38 R$ 6,088.97 R$ 196,106.42 R$ 39,933.98 R$ 33,845.02 R$ 296,973.29 R$ 26,727.43 R$ 202,473.34 26 R$ 920.44 R$ 5,168.52 R$ 6,088.97 R$ 190,937.89 R$ 40,040.72 R$ 33,951.75 R$ 330,925.05 R$ 26,559.70 R$ 229,033.04 27 R$ 896.18 R$ 5,192.78 R$ 6,088.97 R$ 185,745.11 R$ 40,147.74 R$ 34,058.78 R$ 364,983.82 R$ 26,392.98 R$ 255,426.03 28 R$ 871.81 R$ 5,217.16 R$ 6,088.97 R$ 180,527.96 R$ 40,255.05 R$ 34,166.09 R$ 399,149.91 R$ 26,227.28 R$ 281,653.30 29 R$ 847.32 R$ 5,241.64 R$ 6,088.97 R$ 175,286.31 R$ 40,362.65 R$ 34,273.68 R$ 433,423.59 R$ 26,062.57 R$ 307,715.87 30 R$ 822.72 R$ 5,266.24 R$ 6,088.97 R$ 170,020.07 R$ 40,470.53 R$ 34,381.57 R$ 467,805.16 R$ 25,898.86 R$ 333,614.73 31 R$ 798.00 R$ 5,290.96 R$ 6,088.97 R$ 164,729.11 R$ 40,578.71 R$ 34,489.74 R$ 502,294.90 R$ 25,736.14 R$ 359,350.87 32 R$ 773.17 R$ 5,315.80 R$ 6,088.97 R$ 159,413.31 R$ 40,687.17 R$ 34,598.21 R$ 536,893.10 R$ 25,574.40 R$ 384,925.27 33 R$ 748.22 R$ 5,340.75 R$ 6,088.97 R$ 154,072.56 R$ 40,795.93 R$ 34,706.96 R$ 571,600.06 R$ 25,413.65 R$ 410,338.92 34 R$ 723.15 R$ 5,365.81 R$ 6,088.97 R$ 148,706.75 R$ 40,904.97 R$ 34,816.01 R$ 606,416.07 R$ 25,253.87 R$ 435,592.79 35 R$ 697.97 R$ 5,391.00 R$ 6,088.97 R$ 143,315.75 R$ 41,014.31 R$ 34,925.34 R$ 641,341.41 R$ 25,095.05 R$ 460,687.84 36 R$ 672.66 R$ 5,416.30 R$ 6,088.97 R$ 137,899.45 R$ 41,123.94 R$ 35,034.98 R$ 676,376.39 R$ 24,937.20 R$ 485,625.04 37 R$ 647.24 R$ 5,441.72 R$ 6,088.97 R$ 132,457.73 R$ 41,226.43 R$ 35,137.47 R$ 711,513.86 R$ 24,775.07 R$ 510,400.11 38 R$ 621.70 R$ 5,467.26 R$ 6,088.97 R$ 126,990.47 R$ 41,329.18 R$ 35,240.22 R$ 746,754.08 R$ 24,613.96 R$ 535,014.07 39 R$ 596.04 R$ 5,492.93 R$ 6,088.97 R$ 121,497.54 R$ 41,432.19 R$ 35,343.22 R$ 782,097.30 R$ 24,453.87 R$ 559,467.94 40 R$ 570.26 R$ 5,518.71 R$ 6,088.97 R$ 115,978.83 R$ 41,535.45 R$ 35,446.49 R$ 817,543.78 R$ 24,294.79 R$ 583,762.73 41 R$ 544.36 R$ 5,544.61 R$ 6,088.97 R$ 110,434.22 R$ 41,638.97 R$ 35,550.01 R$ 853,093.79 R$ 24,136.71 R$ 607,899.44 42 R$ 518.33 R$ 5,570.63 R$ 6,088.97 R$ 104,863.59 R$ 41,742.75 R$ 35,653.79 R$ 888,747.58 R$ 23,979.64 R$ 631,879.08 43 R$ 492.19 R$ 5,596.78 R$ 6,088.97 R$ 99,266.81 R$ 41,846.79 R$ 35,757.83 R$ 924,505.40 R$ 23,823.55 R$ 655,702.63 44 R$ 465.92 R$ 5,623.05 R$ 6,088.97 R$ 93,643.76 R$ 41,951.09 R$ 35,862.13 R$ 960,367.53 R$ 23,668.46 R$ 679,371.09 45 R$ 439.53 R$ 5,649.44 R$ 6,088.97 R$ 87,994.32 R$ 42,055.65 R$ 35,966.69 R$ 996,334.22 R$ 23,514.34 R$ 702,885.43 46 R$ 413.01 R$ 5,675.96 R$ 6,088.97 R$ 82,318.36 R$ 42,160.48 R$ 36,071.51 R$ 1,032,405.73 R$ 23,361.21 R$ 726,246.64 47 R$ 386.37 R$ 5,702.60 R$ 6,088.97 R$ 76,615.77 R$ 42,265.56 R$ 36,176.60 R$ 1,068,582.32 R$ 23,209.04 R$ 749,455.67 48 R$ 359.60 R$ 5,729.36 R$ 6,088.97 R$ 70,886.40 R$ 42,370.91 R$ 36,281.94 R$ 1,104,864.27 R$ 23,057.83 R$ 772,513.50 49 R$ 332.71 R$ 5,756.25 R$ 6,088.97 R$ 65,130.15 R$ 42,476.52 R$ 36,387.55 R$ 1,141,251.82 R$ 22,907.58 R$ 795,421.09 50 R$ 305.69 R$ 5,783.27 R$ 6,088.97 R$ 59,346.88 R$ 42,582.39 R$ 36,493.43 R$ 1,177,745.25 R$ 22,758.29 R$ 818,179.37 51 R$ 278.55 R$ 5,810.42 R$ 6,088.97 R$ 53,536.46 R$ 42,688.53 R$ 36,599.57 R$ 1,214,344.81 R$ 22,609.94 R$ 840,789.31 52 R$ 251.28 R$ 5,837.69 R$ 6,088.97 R$ 47,698.77 R$ 42,794.94 R$ 36,705.97 R$ 1,251,050.79 R$ 22,462.53 R$ 863,251.84 53 R$ 223.88 R$ 5,865.09 R$ 6,088.97 R$ 41,833.68 R$ 42,901.61 R$ 36,812.64 R$ 1,287,863.43 R$ 22,316.05 R$ 885,567.89 54 R$ 196.35 R$ 5,892.62 R$ 6,088.97 R$ 35,941.07 R$ 43,008.55 R$ 36,919.58 R$ 1,324,783.01 R$ 22,170.51 R$ 907,738.40 55 R$ 168.69 R$ 5,920.27 R$ 6,088.97 R$ 30,020.80 R$ 43,115.75 R$ 37,026.79 R$ 1,361,809.80 R$ 22,025.89 R$ 929,764.29 56 R$ 140.91 R$ 5,948.06 R$ 6,088.97 R$ 24,072.73 R$ 43,223.22 R$ 37,134.26 R$ 1,398,944.05 R$ 21,882.18 R$ 951,646.47 57 R$ 112.99 R$ 5,975.98 R$ 6,088.97 R$ 18,096.76 R$ 43,330.97 R$ 37,242.00 R$ 1,436,186.05 R$ 21,739.39 R$ 973,385.86 58 R$ 84.94 R$ 6,004.03 R$ 6,088.97 R$ 12,092.73 R$ 43,438.98 R$ 37,350.01 R$ 1,473,536.07 R$ 21,597.51 R$ 994,983.37 59 R$ 56.76 R$ 6,032.21 R$ 6,088.97 R$ 6,060.52 R$ 43,547.26 R$ 37,458.29 R$ 1,510,994.36 R$ 21,456.52 R$ 1,016,439.89 60 R$ 28.45 R$ 6,060.52 R$ 6,088.97 -R$ 0.00 R$ 43,655.81 R$ 37,566.84 R$ 1,548,561.20 R$ 21,316.44 R$ 1,037,756.33 SOMA R$ 47,580.21 R$ 317,757.75 R$ 365,337.96 PRICE F. Completo -534885.95166666666 33624.325971548169 33555.271366727298 33484.451987338281 33411.844770271455 33337.426368795677 33261.173149098511 33183.061186784202 33103.066263329034 33021.163862493595 32937.329166691095 32851.537053311637 32763.762091001565 32844.167979132944 32924.723733143066 33005.429554873444 33086.285646083314 33167.292208447419 33248.449443553814 33329.757552901618 33411.216737898787 33492.827199859836 33574.589140003547 33656.502759450806 33738.568259222113 33845.018833752816 33951.754771896405 34058.776826625348 34166.085752856896 34273.682307457872 34381.567249249609 34489.741339012828 34598.205339492502 34706.960015402889 34816.006133432296 34925.34446224822 35034.975772502119 35137.467942366027 35240.216485763136 35343.222035014936 35446.485223973556 35550.006688025329 35653.787064094453 35757.826990646587 35862.127107692504 35966.688056791769 36071.510481056277 36176.595025154049 36281.94233531283 36387.55305932372 36493.427846544982 36599.56734790562 36705.972215909169 36812.643104637304 36919.580669753639 37026.785568507454 37134.258459737386 37242.000003875211 37350.010862949588 37458.291700589747 37566. 843182029406 FC Descontado -534885.95166666666 33308.270687980876 32927.423663949019 32549.077914911602 32173.213984355079 31799.812555927219 31428.854452419171 31060.320634754615 30694.192200986094 30330.450385298522 29969.0765570195 29610.052219636829 29253.359009822787 29049.505241282051 28847.03045853609 28645.9256897087 28446.182017988067 28247.790581321784 28050.742572113235 27855.029236919265 27660.641876149231 27467.571843765305 27275.810546984158 27085.349445980046 26896.180053588992 26727.430743864716 26559.700675194497 26392.984081274262 26227.27522439621 26062.568395351507 25898.857913332853 25736.138125836806 25574.403408565788 25413.648165330076 25253.866827949369 25095.053856154438 24937.203737488315 24775.07012915763 24613.960306091449 24453.868101194912 24294.787381501086 24136.712048014339 23979.63603555414 23823.553312599168 23668.457881131762 23514.343776482769 23361.205067176626 23209.035854777034 23057.830273732787 22907.582491224028 22758.286707008985 22609.937153270945 22462.528094465721 22316.053827169399 22170.508679926581 22025.887013098982 21882.183218714406 21739.3 91720316125 21597.506972812691 21456.523462328107 21316.435706052511 FCA -534885.95166666666 -501261.62569511851 -467706.3543283912 -434221.90234105289 -400810.05757078144 -367472.63120198576 -334211.45805288723 -301028.39686610305 -267925.33060277405 -234904.16674028046 -201966.83757358935 -169115.3005202777 -136351.53842927614 -103507.37045014321 -70582.646717000142 -37577.217162126697 -4490.9315160433835
Compartilhar