📊PlanilhaTransação Financeira95%Outro85%Transação Financeira95%Outro80%Transação Financeira95%Outro85%Transação Financeira95%Transação Financeira95%Outro85%Transação Financeira95%Outro85%Transação Financeira95%Outro85%Transação Financeira95%Outro85%Transação Financeira95%Transação Financeira95%Outro85%Transação Financeira95%Transação Financeira95%Outro85%Transação Financeira95%Outro80%
6528F19340581D8274C483C86B93E03C
Arquivo
6528F19340581D8274C483C86B93E03C.xlsx
Categorias(geradas por IA — sujeitas a revisão)
Transação Financeira95%
O documento detalha custos de construção, preços de venda de unidades, valor de terreno, VGV (Valor Geral de Vendas) e outros indicadores financeiros relacionados a um empreendimento imobiliário, caracterizando uma transação financeira ou planejamento de investimento.
Outro85%
Embora 'transacao_financeira' seja a categoria principal, o documento também contém informações específicas sobre um 'empreendimento imobiliário' (tipo de construção, número de unidades, fases, área privativa, dormitórios), que não se encaixa perfeitamente nas outras categorias fornecidas, sendo 'outro' a melhor opção para capturar essa especificidade.
Transação Financeira95%
O documento contém uma planilha com detalhes financeiros de um empreendimento imobiliário, incluindo custos, preços de venda, VGV (Valor Geral de Vendas) e resultados brutos de incorporação, indicando uma transação financeira complexa e planejamento econômico.
Outro80%
Embora o foco principal seja financeiro, o documento também detalha aspectos de um 'empreendimento imobiliário', como tipo de construção, número de unidades, fases e área privativa, que não se encaixam perfeitamente em outras categorias fornecidas, mas são relevantes para o contexto do projeto.
Transação Financeira95%
O documento contém uma planilha detalhada com informações financeiras e de custos de um empreendimento imobiliário, incluindo preço de terreno, custo por m², preço de venda de unidades, VGV (Valor Geral de Vendas), e resultados de incorporação. Estes são dados diretamente relacionados a transações financeiras e planejamento econômico.
Outro85%
Embora o foco seja financeiro, o documento também descreve aspectos de um 'empreendimento imobiliário' ou 'projeto de construção', como tipo de construção (casas), número de unidades, fases e área privativa. Estas informações, embora ligadas ao financeiro, representam o detalhamento de um projeto físico de construção, que não se encaixa perfeitamente nas outras categorias fornecidas, sendo mais abrangente que apenas 'transação financeira'.
Transação Financeira95%
O documento contém uma planilha detalhada com dados financeiros de um empreendimento imobiliário, incluindo custos por m², preço de venda por unidade, VGV (Valor Geral de Vendas), custo por fase, e resultado bruto de incorporação. Estes são indicadores financeiros diretos de uma transação ou projeto financeiro.
Transação Financeira95%
O documento contém uma planilha com dados financeiros detalhados de um empreendimento imobiliário, incluindo custos (terreno, m2, área privativa, área construída), preços de venda por unidade, VGV (Valor Geral de Vendas), e resultados brutos de incorporação. Estes são indicadores claros de transações e projeções financeiras.
Outro85%
Embora não haja uma categoria exata para 'projeto imobiliário' ou 'construção', o documento detalha aspectos de um empreendimento de construção (tipo de construção, número de unidades, fases, dormitórios, área privativa), o que o torna um tipo de documento técnico/operacional relacionado ao setor imobiliário que não se encaixa perfeitamente nas outras categorias fornecidas.
Transação Financeira95%
O documento detalha custos de construção (Custo m2, Custo Área Privativa, Custo Área Construída), preços de venda (Preço Venda Unid.), valor de terreno, e resultados brutos de incorporação, indicando uma análise financeira de um empreendimento imobiliário.
Outro85%
Embora o foco seja financeiro, o documento também contém dados específicos de engenharia e planejamento de construção, como Tipo Construção, Núm.Unidades, Fases, Unid. p/ Fases, Área Privativa (m2) e Dormitórios, que não se encaixam perfeitamente nas outras categorias fornecidas, sendo mais adequados a uma categoria mais genérica de 'planejamento de projeto' ou 'dados de construção'.
Transação Financeira95%
O documento detalha informações financeiras e de custo de um empreendimento imobiliário, incluindo preço de terreno, custo por m², preço de venda por unidade, VGV (Valor Geral de Vendas), e resultados brutos de incorporação, que são elementos centrais de transações financeiras e análise de viabilidade econômica.
Outro85%
Embora 'transacao_financeira' seja a categoria principal, o documento também se enquadra em um contexto mais específico de 'planejamento e análise de empreendimento imobiliário', que não está diretamente listado. A categoria 'outro' pode ser usada para cobrir essa especificidade, focando na gestão e detalhamento de um projeto de construção civil.
Transação Financeira95%
O documento contém uma planilha com dados financeiros detalhados de um empreendimento imobiliário, incluindo custos de terreno, custo por m², preço de custo por unidade, custo de área privativa, custo de área construída, preço de venda por unidade, VGV (Valor Geral de Vendas) e resultado bruto de incorporação. Estes são indicadores financeiros diretos de uma transação ou projeto financeiro.
Outro85%
Embora 'transacao_financeira' seja a categoria principal, o documento também detalha aspectos de um 'empreendimento imobiliário' ou 'construção civil', como tipo de construção (casas), número de unidades, fases, área privativa e número de dormitórios. Como não há uma categoria específica para 'construção' ou 'imobiliário', 'outro' pode abranger este aspecto complementar da informação.
Transação Financeira95%
O documento contém dados detalhados sobre custos, preços de venda, VGV (Valor Geral de Vendas), e resultados financeiros de um empreendimento imobiliário, indicando uma análise de transação financeira e viabilidade econômica.
Transação Financeira95%
O documento detalha custos de construção, preço de venda por unidade, valor de terreno, VGV (Valor Geral de Vendas) e resultados brutos de incorporação, que são todos elementos financeiros de um projeto.
Outro85%
Embora 'transacao_financeira' seja a categoria principal, o documento também descreve detalhes de um empreendimento imobiliário ('Nome Empreendimento', 'Tipo Construção', 'Núm.Unidades', 'Fases', 'Dormitórios', 'Área Privativa'), que se encaixaria melhor em uma categoria como 'construção' ou 'imobiliário', mas como não existe, 'outro' é a opção mais adequada para capturar o contexto do projeto.
Transação Financeira95%
O documento contém uma planilha com diversos dados financeiros e de custos relacionados a um empreendimento imobiliário, incluindo preços de terreno, custos de construção, valores de venda, VGV (Valor Geral de Vendas), entre outros indicadores financeiros.
Transação Financeira95%
O documento detalha custos, preços de venda, VGV (Valor Geral de Vendas), e outros valores monetários relacionados a um empreendimento imobiliário, indicando uma análise financeira de um projeto.
Outro85%
Embora o foco seja financeiro, o documento também contém dados específicos de um projeto de construção (tipo de construção, número de unidades, fases, área privativa, dormitórios), que se encaixam em uma categoria mais ampla de 'projeto imobiliário' ou 'construção', que não está explicitamente nas opções, sendo 'outro' a melhor alternativa para capturar esse aspecto.
Transação Financeira95%
O documento detalha custos de construção, preço de venda de unidades, valor de terreno, VGV (Valor Geral de Vendas) e outros indicadores financeiros relacionados a um empreendimento imobiliário, caracterizando uma transação financeira ou planejamento financeiro de grande porte.
Outro80%
Embora 'transacao_financeira' seja a categoria principal, o documento também contém informações específicas sobre um 'Empreendimento Imobiliário', como tipo de construção, número de unidades, fases e área privativa, que não se encaixam perfeitamente nas outras categorias fornecidas, mas são cruciais para o contexto.
Perguntar à IA sobre este documento
A IA analisará o conteúdo completo deste documento para responder sua pergunta. Exemplos: "Quem é mencionado neste texto?", "Há valores financeiros?", "Qual o contexto desta conversa?"
Conteúdo do Documento
[Planilha: 1.Araraquara-Resid Campo Belo]
Nome Empreendimento, Campo Belo ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, casas ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades," 1,230 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 4 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 308 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, 370 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, 92.6 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 48.40 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 63,766 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 78,432,219 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 94,118,663 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 23,529,666 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 135,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 40,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 76,519 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resultado Bruto Incorporação," 18,481 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 166,050,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 29,012,500 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$)," 29,012,500 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 3 (R$)," 29,012,500 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 4 (R$)," 29,012,500 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, 370 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$)," 50,000,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,," 41,512,500 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,, Vendas Fase - 3 ,,,,,,,,,,,, Vendas Fase - 4 ,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,
,,,,,,,,,,,,,,5.00%,7.50%,7.50%,10.00%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,15.00%,15.00%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,5.00%,5.00%,15.00%,15.00%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,5.00%,5.00%,15.00%,15.00%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,5.00%,5.00%,,,,,,,,,,
,,,,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,15-Feb-21,17-Mar-21,16-Apr-21,16-May-21,15-Jun-21,15-Jul-21,14-Aug-21,13-Sep-21,13-Oct-21,12-Nov-21,12-Dec-21,11-Jan-22,10-Feb-22,12-Mar-22,11-Apr-22,11-May-22,10-Jun-22,10-Jul-22,9-Aug-22,8-Sep-22,8-Oct-22,7-Nov-22,7-Dec-22,6-Jan-23
,, Sinal/Negócio ,, Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação , Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,, Vendas Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,," (1,800,000)",,," (50,000)"," (350,000)"," (850,000)"," (260,000)"," (360,000)"," (3,670,000)"," (1,660,500)"," (200,000)"," (150,000)"," 2,075,625 "," 3,113,438 "," 3,113,438 "," 4,151,250 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 4,151,250 "," 4,151,250 "," 5,189,063 "," 6,226,875 "," 6,226,875 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 2,075,625 "," 2,075,625 "," 6,226,875 "," 6,226,875 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 2,075,625 "," 2,075,625 "," 6,226,875 "," 6,226,875 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 3,113,438 "," 2,075,625 "," 2,075,625 ",,,,,,,,,,
,,,,,,,,,,,,,, 15 , 23 , 23 , 31 , 23 , 23 , 23 , 23 , 23 , 31 , 31 , 38 , 46 , 46 , 23 , 23 , 23 , 23 , 23 , 23 , 23 , 23 , 15 , 15 , 46 , 46 , 23 , 23 , 23 , 23 , 23 , 23 , 23 , 23 , 15 , 15 , 46 , 46 , 23 , 23 , 23 , 23 , 23 , 23 , 23 , 23 , 15 , 15 ,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase - 2 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase - 3 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -4 ,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," 615,000 "," 922,500 "," 922,500 "," 1,230,000 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 1,230,000 "," 1,230,000 "," 1,537,500 "," 1,845,000 "," 1,845,000 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 615,000 "," 615,000 "," 1,845,000 "," 1,845,000 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 615,000 "," 615,000 "," 1,845,000 "," 1,845,000 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 922,500 "," 615,000 "," 615,000 ",,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,," (117,648)"," (235,297)"," (823,538)"," (1,058,835)"," (1,294,132)"," (1,764,725)"," (1,882,373)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (1,411,780)"," (1,294,132)"," (1,294,132)"," (941,187)"," (705,890)"," (705,890)",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,," 105,883 "," 211,767 "," 741,184 "," 952,951 "," 1,164,718 "," 1,588,252 "," 1,694,136 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,270,602 "," 1,164,718 "," 1,164,718 "," 847,068 "," 635,301 "," 635,301 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, (714)," (1,428)"," (4,999)"," (6,427)"," (7,855)"," (10,711)"," (11,425)"," (12,140)"," (12,140)"," (12,140)"," (12,140)"," (12,140)"," (8,569)"," (7,855)"," (7,855)"," (5,713)"," (4,285)"," (4,285)",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,," 27,316 "," 52,437 "," 145,101 "," 166,796 "," 179,708 "," 179,181 "," 173,560 "," 165,743 "," 165,743 "," 165,743 "," 165,743 "," 165,743 "," 182,870 "," 179,708 "," 179,708 "," 157,047 "," 130,960 "," 130,960 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,," (117,648)"," (235,297)"," (823,538)"," (1,058,835)"," (1,294,132)"," (1,764,725)"," (1,882,373)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (1,411,780)"," (1,294,132)"," (1,294,132)"," (941,187)"," (705,890)"," (705,890)",,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,," 105,883 "," 211,767 "," 741,184 "," 952,951 "," 1,164,718 "," 1,588,252 "," 1,694,136 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,270,602 "," 1,164,718 "," 1,164,718 "," 847,068 "," 635,301 "," 635,301 ",,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,, (714)," (1,428)"," (4,999)"," (6,427)"," (7,855)"," (10,711)"," (11,425)"," (12,140)"," (12,140)"," (12,140)"," (12,140)"," (12,140)"," (8,569)"," (7,855)"," (7,855)"," (5,713)"," (4,285)"," (4,285)",,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 27,316 "," 52,437 "," 145,101 "," 166,796 "," 179,708 "," 179,181 "," 173,560 "," 165,743 "," 165,743 "," 165,743 "," 165,743 "," 165,743 "," 182,870 "," 179,708 "," 179,708 "," 157,047 "," 130,960 "," 130,960 ",,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,15-Feb-21,17-Mar-21,16-Apr-21,16-May-21,15-Jun-21,15-Jul-21,14-Aug-21,13-Sep-21,13-Oct-21,12-Nov-21,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," (117,648)"," (235,297)"," (823,538)"," (1,058,835)"," (1,294,132)"," (1,764,725)"," (1,882,373)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (1,411,780)"," (1,294,132)"," (1,294,132)"," (941,187)"," (705,890)"," (705,890)",,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 105,883 "," 211,767 "," 741,184 "," 952,951 "," 1,164,718 "," 1,588,252 "," 1,694,136 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,270,602 "," 1,164,718 "," 1,164,718 "," 847,068 "," 635,301 "," 635,301 ",,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, (714)," (1,428)"," (4,999)"," (6,427)"," (7,855)"," (10,711)"," (11,425)"," (12,140)"," (12,140)"," (12,140)"," (12,140)"," (12,140)"," (8,569)"," (7,855)"," (7,855)"," (5,713)"," (4,285)"," (4,285)",,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 27,316 "," 52,437 "," 145,101 "," 166,796 "," 179,708 "," 179,181 "," 173,560 "," 165,743 "," 165,743 "," 165,743 "," 165,743 "," 165,743 "," 182,870 "," 179,708 "," 179,708 "," 157,047 "," 130,960 "," 130,960 ",,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 4 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,15-Jun-21,15-Jul-21,14-Aug-21,13-Sep-21,13-Oct-21,12-Nov-21,12-Dec-21,11-Jan-22,10-Feb-22,12-Mar-22,11-Apr-22,11-May-22,10-Jun-22,10-Jul-22,9-Aug-22,8-Sep-22,8-Oct-22,7-Nov-22,7-Dec-22,6-Jan-23
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 4 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," (117,648)"," (235,297)"," (823,538)"," (1,058,835)"," (1,294,132)"," (1,764,725)"," (1,882,373)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (2,000,022)"," (1,411,780)"," (1,294,132)"," (1,294,132)"," (941,187)"," (705,890)"," (705,890)",,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 4 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 105,883 "," 211,767 "," 741,184 "," 952,951 "," 1,164,718 "," 1,588,252 "," 1,694,136 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,800,019 "," 1,270,602 "," 1,164,718 "," 1,164,718 "," 847,068 "," 635,301 "," 635,301 ",,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 4 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, (714)," (1,428)"," (4,999)"," (6,427)"," (7,855)"," (10,711)"," (11,425)"," (12,140)"," (12,140)"," (12,140)"," (12,140)"," (12,140)"," (8,569)"," (7,855)"," (7,855)"," (5,713)"," (4,285)"," (4,285)",,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 4 ,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 27,316 "," 52,437 "," 145,101 "," 166,796 "," 179,708 "," 179,181 "," 173,560 "," 165,743 "," 165,743 "," 165,743 "," 165,743 "," 165,743 "," 182,870 "," 179,708 "," 179,708 "," 157,047 "," 130,960 "," 130,960 "
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,15-Feb-21,17-Mar-21,16-Apr-21,16-May-21,15-Jun-21,15-Jul-21,14-Aug-21,13-Sep-21,13-Oct-21,12-Nov-21,12-Dec-21,11-Jan-22,10-Feb-22,12-Mar-22,11-Apr-22,11-May-22,10-Jun-22,10-Jul-22,9-Aug-22,8-Sep-22,8-Oct-22,7-Nov-22,7-Dec-22,6-Jan-23
,1,2,3,4,5,6,7,8,9,10,13,11,12,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,61,62,63,64,65,66,67,68,69,70,71
Cash Flow,,,,,,,,,,"( 3,670,000)","( 1,660,500)","( 200,000)","( 150,000)", 0," 573,611"," 860,416"," 860,416"," 1,147,221"," 860,416"," 885,894"," 909,323"," 995,752"," 1,015,987"," 1,314,835"," 1,314,343"," 1,595,906"," 1,875,420"," 1,875,420"," 1,015,004"," 1,040,482"," 1,063,912"," 1,166,315"," 1,183,600"," 1,195,643"," 1,174,016"," 1,144,442"," 850,345"," 728,199"," 1,875,420"," 1,875,420"," 1,015,004"," 1,056,456"," 1,076,937"," 1,163,365"," 1,162,464"," 1,150,176"," 1,149,685"," 1,022,295"," 728,199"," 728,199"," 1,875,420"," 1,875,420"," 1,015,004"," 1,056,456"," 1,076,937"," 1,163,365"," 1,162,464"," 1,150,176"," 1,149,685"," 1,022,295"," 728,199"," 728,199"," 154,588"," 154,588"," 154,588"," 170,563"," 167,614"," 167,614"," 146,477"," 122,146"," 122,146"
Cash Flow Accum.,,,,,,,,,,"( 3,670,000)","( 5,330,500)","( 5,530,500)","( 5,680,500)","( 5,680,500)","( 5,106,890)","( 4,246,474)","( 3,386,058)","( 2,238,837)","( 1,378,421)","( 492,528)"," 416,796"," 1,412,548"," 2,428,534"," 3,743,369"," 5,057,712"," 6,653,618"," 8,529,038"," 10,404,458"," 11,419,462"," 12,459,944"," 13,523,856"," 14,690,170"," 15,873,771"," 17,069,414"," 18,243,429"," 19,387,871"," 20,238,216"," 20,966,415"," 22,841,835"," 24,717,255"," 25,732,259"," 26,788,716"," 27,865,653"," 29,029,018"," 30,191,482"," 31,341,658"," 32,491,342"," 33,513,637"," 34,241,836"," 34,970,035"," 36,845,455"," 38,720,875"," 39,735,879"," 40,792,336"," 41,869,273"," 43,032,638"," 44,195,102"," 45,345,278"," 46,494,963"," 47,517,258"," 48,245,457"," 48,973,656"," 49,128,244"," 49,282,833"," 49,437,421"," 49,607,984"," 49,775,597"," 49,943,211"," 50,089,688"," 50,211,835"," 50,333,981"
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 2.Sorocaba-Ferroban]
Nome Empreendimento, Ferroban ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Vertical - 5 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 1.5 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 414 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 4 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 104 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, 41 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, 10.3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 38.40 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 50,591 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 20,944,770 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 25,133,724 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 6,283,431 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 122,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 60,709 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resultado Bruto Incorporação," 26,291 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 50,508,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 11,364,300 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$)," 11,364,300 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 3 (R$)," 11,364,300 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 4 (R$)," 11,364,300 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, 41 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$)," 5,050,800 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,, Vendas Fase - 3 ,,,,,,,,,,,, Vendas Fase - 4 ,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,
,,,,,,,,,,,5.00%,7.50%,7.50%,10.00%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,15.00%,15.00%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,5.00%,5.00%,15.00%,15.00%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,5.00%,5.00%,15.00%,15.00%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,5.00%,5.00%,,,,,,,,,,
,,,,,,,20-Oct-17,20-Oct-17,19-Nov-17,19-Nov-17,19-Nov-17,19-Dec-17,18-Jan-18,17-Feb-18,19-Mar-18,18-Apr-18,18-May-18,17-Jun-18,17-Jul-18,16-Aug-18,15-Sep-18,15-Oct-18,14-Nov-18,14-Dec-18,13-Jan-19,12-Feb-19,14-Mar-19,13-Apr-19,13-May-19,12-Jun-19,12-Jul-19,11-Aug-19,10-Sep-19,10-Oct-19,9-Nov-19,9-Dec-19,8-Jan-20,7-Feb-20,8-Mar-20,7-Apr-20,7-May-20,6-Jun-20,6-Jul-20,5-Aug-20,4-Sep-20,4-Oct-20,3-Nov-20,3-Dec-20,2-Jan-21,1-Feb-21,3-Mar-21,2-Apr-21,2-May-21,1-Jun-21,1-Jul-21,31-Jul-21,30-Aug-21,29-Sep-21,29-Oct-21,28-Nov-21,28-Dec-21,27-Jan-22,26-Feb-22,28-Mar-22,27-Apr-22,27-May-22,26-Jun-22,26-Jul-22
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação , Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,, Vendas Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (750,000)",," (60,000)"," (150,000)"," (230,000)"," (120,000)"," (130,000)"," (1,440,000)"," (505,080)"," (120,000)"," (70,000)"," 631,350 "," 947,025 "," 947,025 "," 1,262,700 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 1,262,700 "," 1,262,700 "," 1,578,375 "," 1,894,050 "," 1,894,050 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 631,350 "," 631,350 "," 1,894,050 "," 1,894,050 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 631,350 "," 631,350 "," 1,894,050 "," 1,894,050 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 947,025 "," 631,350 "," 631,350 ",,,,,,,,,,
,,,,,,,,,,, 5 , 8 , 8 , 10 , 8 , 8 , 8 , 8 , 8 , 10 , 10 , 13 , 16 , 16 , 8 , 8 , 8 , 8 , 8 , 8 , 8 , 8 , 5 , 5 , 16 , 16 , 8 , 8 , 8 , 8 , 8 , 8 , 8 , 8 , 5 , 5 , 16 , 16 , 8 , 8 , 8 , 8 , 8 , 8 , 8 , 8 , 5 , 5 ,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase - 2 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase - 3 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -4 ,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,," 181,125 "," 271,688 "," 271,688 "," 362,250 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 362,250 "," 362,250 "," 452,813 "," 543,375 "," 543,375 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 181,125 "," 181,125 "," 543,375 "," 543,375 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 181,125 "," 181,125 "," 543,375 "," 543,375 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 271,688 "," 181,125 "," 181,125 ",,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,19-Mar-18,18-Apr-18,18-May-18,17-Jun-18,17-Jul-18,16-Aug-18,15-Sep-18,15-Oct-18,14-Nov-18,14-Dec-18,13-Jan-19,12-Feb-19,14-Mar-19,13-Apr-19,13-May-19,12-Jun-19,12-Jul-19,11-Aug-19,10-Sep-19,10-Oct-19,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," (31,417)"," (62,834)"," (219,920)"," (282,754)"," (345,589)"," (471,257)"," (502,674)"," (534,092)"," (534,092)"," (534,092)"," (534,092)"," (534,092)"," (377,006)"," (345,589)"," (345,589)"," (251,337)"," (188,503)"," (188,503)",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," 28,275 "," 56,551 "," 197,928 "," 254,479 "," 311,030 "," 424,132 "," 452,407 "," 480,682 "," 480,682 "," 480,682 "," 480,682 "," 480,682 "," 339,305 "," 311,030 "," 311,030 "," 226,204 "," 169,653 "," 169,653 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, (191), (381)," (1,335)"," (1,716)"," (2,098)"," (2,860)"," (3,051)"," (3,242)"," (3,242)"," (3,242)"," (3,242)"," (3,242)"," (2,288)"," (2,098)"," (2,098)"," (1,526)"," (1,144)"," (1,144)",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,," 13,507 "," 26,816 "," 90,402 "," 114,455 "," 137,718 "," 181,876 "," 192,422 "," 202,771 "," 202,771 "," 202,771 "," 202,771 "," 202,771 "," 149,054 "," 137,718 "," 137,718 "," 102,527 "," 78,079 "," 78,079 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,13-Jan-19,12-Feb-19,14-Mar-19,13-Apr-19,13-May-19,12-Jun-19,12-Jul-19,11-Aug-19,10-Sep-19,10-Oct-19,9-Nov-19,9-Dec-19,8-Jan-20,7-Feb-20,8-Mar-20,7-Apr-20,7-May-20,6-Jun-20,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,," (31,417)"," (62,834)"," (219,920)"," (282,754)"," (345,589)"," (471,257)"," (502,674)"," (534,092)"," (534,092)"," (534,092)"," (534,092)"," (534,092)"," (377,006)"," (345,589)"," (345,589)"," (251,337)"," (188,503)"," (188,503)",,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,," 28,275 "," 56,551 "," 197,928 "," 254,479 "," 311,030 "," 424,132 "," 452,407 "," 480,682 "," 480,682 "," 480,682 "," 480,682 "," 480,682 "," 339,305 "," 311,030 "," 311,030 "," 226,204 "," 169,653 "," 169,653 ",,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, (191), (381)," (1,335)"," (1,716)"," (2,098)"," (2,860)"," (3,051)"," (3,242)"," (3,242)"," (3,242)"," (3,242)"," (3,242)"," (2,288)"," (2,098)"," (2,098)"," (1,526)"," (1,144)"," (1,144)",,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,," 13,507 "," 26,816 "," 90,402 "," 114,455 "," 137,718 "," 181,876 "," 192,422 "," 202,771 "," 202,771 "," 202,771 "," 202,771 "," 202,771 "," 149,054 "," 137,718 "," 137,718 "," 102,527 "," 78,079 "," 78,079 ",,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,8-Jan-20,7-Feb-20,8-Mar-20,7-Apr-20,7-May-20,6-Jun-20,6-Jul-20,5-Aug-20,4-Sep-20,4-Oct-20,3-Nov-20,3-Dec-20,2-Jan-21,1-Feb-21,3-Mar-21,2-Apr-21,2-May-21,1-Jun-21,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," (31,417)"," (62,834)"," (219,920)"," (282,754)"," (345,589)"," (471,257)"," (502,674)"," (534,092)"," (534,092)"," (534,092)"," (534,092)"," (534,092)"," (377,006)"," (345,589)"," (345,589)"," (251,337)"," (188,503)"," (188,503)",,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 28,275 "," 56,551 "," 197,928 "," 254,479 "," 311,030 "," 424,132 "," 452,407 "," 480,682 "," 480,682 "," 480,682 "," 480,682 "," 480,682 "," 339,305 "," 311,030 "," 311,030 "," 226,204 "," 169,653 "," 169,653 ",,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, (191), (381)," (1,335)"," (1,716)"," (2,098)"," (2,860)"," (3,051)"," (3,242)"," (3,242)"," (3,242)"," (3,242)"," (3,242)"," (2,288)"," (2,098)"," (2,098)"," (1,526)"," (1,144)"," (1,144)",,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 13,507 "," 26,816 "," 90,402 "," 114,455 "," 137,718 "," 181,876 "," 192,422 "," 202,771 "," 202,771 "," 202,771 "," 202,771 "," 202,771 "," 149,054 "," 137,718 "," 137,718 "," 102,527 "," 78,079 "," 78,079 ",,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 4 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,2-Jan-21,1-Feb-21,3-Mar-21,2-Apr-21,2-May-21,1-Jun-21,1-Jul-21,31-Jul-21,30-Aug-21,29-Sep-21,29-Oct-21,28-Nov-21,28-Dec-21,27-Jan-22,26-Feb-22,28-Mar-22,27-Apr-22,27-May-22,26-Jun-22,26-Jul-22
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 4 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," (31,417)"," (62,834)"," (219,920)"," (282,754)"," (345,589)"," (471,257)"," (502,674)"," (534,092)"," (534,092)"," (534,092)"," (534,092)"," (534,092)"," (377,006)"," (345,589)"," (345,589)"," (251,337)"," (188,503)"," (188,503)",,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 4 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 28,275 "," 56,551 "," 197,928 "," 254,479 "," 311,030 "," 424,132 "," 452,407 "," 480,682 "," 480,682 "," 480,682 "," 480,682 "," 480,682 "," 339,305 "," 311,030 "," 311,030 "," 226,204 "," 169,653 "," 169,653 ",,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 4 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, (191), (381)," (1,335)"," (1,716)"," (2,098)"," (2,860)"," (3,051)"," (3,242)"," (3,242)"," (3,242)"," (3,242)"," (3,242)"," (2,288)"," (2,098)"," (2,098)"," (1,526)"," (1,144)"," (1,144)",,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 4 ,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 13,507 "," 26,816 "," 90,402 "," 114,455 "," 137,718 "," 181,876 "," 192,422 "," 202,771 "," 202,771 "," 202,771 "," 202,771 "," 202,771 "," 149,054 "," 137,718 "," 137,718 "," 102,527 "," 78,079 "," 78,079 "
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,20-Oct-17,20-Oct-17,19-Nov-17,19-Nov-17,19-Nov-17,19-Dec-17,18-Jan-18,17-Feb-18,19-Mar-18,18-Apr-18,18-May-18,17-Jun-18,17-Jul-18,16-Aug-18,15-Sep-18,15-Oct-18,14-Nov-18,14-Dec-18,13-Jan-19,12-Feb-19,14-Mar-19,13-Apr-19,13-May-19,12-Jun-19,12-Jul-19,11-Aug-19,10-Sep-19,10-Oct-19,9-Nov-19,9-Dec-19,8-Jan-20,7-Feb-20,8-Mar-20,7-Apr-20,7-May-20,6-Jun-20,6-Jul-20,5-Aug-20,4-Sep-20,4-Oct-20,3-Nov-20,3-Dec-20,2-Jan-21,1-Feb-21,3-Mar-21,2-Apr-21,2-May-21,1-Jun-21,1-Jul-21,31-Jul-21,30-Aug-21,29-Sep-21,29-Oct-21,28-Nov-21,28-Dec-21,27-Jan-22,26-Feb-22,28-Mar-22,27-Apr-22,27-May-22,26-Jun-22,26-Jul-22
,,,,,,,1,4,2,3,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,61,62
Cash Flow,,,,,,,"( 1,440,000)","( 505,080)","( 120,000)","( 70,000)", 0," 168,935"," 253,403"," 253,403"," 337,871"," 253,403"," 266,001"," 278,414"," 337,721"," 360,155"," 466,320"," 507,507"," 601,811"," 695,931"," 695,931"," 442,528"," 455,125"," 467,539"," 476,743"," 488,604"," 510,302"," 518,666"," 505,700"," 430,885"," 358,060"," 695,931"," 695,931"," 442,528"," 405,023"," 406,864"," 466,170"," 455,782"," 454,677"," 495,864"," 432,875"," 358,060"," 358,060"," 695,931"," 695,931"," 442,528"," 405,023"," 406,864"," 466,170"," 455,782"," 454,677"," 495,864"," 432,875"," 358,060"," 358,060"," 189,125"," 189,125"," 189,125"," 139,022"," 128,450"," 128,450"," 95,627"," 72,825"," 72,825"
Cash Flow Accum.,,,,,,,"( 1,440,000)","( 1,945,080)","( 2,065,080)","( 2,135,080)","( 2,135,080)","( 1,966,145)","( 1,712,742)","( 1,459,339)","( 1,121,468)","( 868,065)","( 602,065)","( 323,651)"," 14,070"," 374,225"," 840,545"," 1,348,052"," 1,949,863"," 2,645,793"," 3,341,724"," 3,784,251"," 4,239,377"," 4,706,916"," 5,183,659"," 5,672,263"," 6,182,566"," 6,701,231"," 7,206,932"," 7,637,816"," 7,995,876"," 8,691,807"," 9,387,738"," 9,830,265"," 10,235,288"," 10,642,152"," 11,108,322"," 11,564,104"," 12,018,781"," 12,514,645"," 12,947,520"," 13,305,581"," 13,663,641"," 14,359,571"," 15,055,502"," 15,498,029"," 15,903,052"," 16,309,916"," 16,776,087"," 17,231,868"," 17,686,546"," 18,182,409"," 18,615,285"," 18,973,345"," 19,331,405"," 19,520,530"," 19,709,654"," 19,898,779"," 20,037,801"," 20,166,251"," 20,294,701"," 20,390,328"," 20,463,152"," 20,535,977"
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 3.Guarulhos]
Nome Empreendimento, Vila Rosalia ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Vertical 15 pav + 3 Sub ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 62 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 62 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, 22 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, 22.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 119.90 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 3 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 157,966 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 9,793,883 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 11,752,659 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 11,752,659 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 230,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 189,559 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resutlado Bruto Incorporação," 5,441 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 14,260,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 9,200,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$), n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, 22 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$)," 5,500,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,
,,,,,,,,,,,5.00%,7.50%,7.50%,10.00%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação , Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (530,000)", - ," (25,000)"," (100,000)"," (70,000)"," (50,000)"," (40,000)"," (815,000)"," (180,000)"," (140,000)"," (80,000)"," 713,000 "," 1,069,500 "," 1,069,500 "," 1,426,000 "," 1,069,500 "," 1,069,500 "," 1,069,500 "," 1,069,500 "," 1,069,500 "," 1,426,000 "," 1,426,000 "," 1,782,500 ",,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, 3 , 5 , 5 , 6 , 5 , 5 , 5 , 5 , 5 , 6 , 6 , 8 ,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,," 108,500 "," 162,750 "," 162,750 "," 217,000 "," 162,750 "," 162,750 "," 162,750 "," 162,750 "," 162,750 "," 217,000 "," 217,000 "," 271,250 ", - , - , - , - , - , - , - , - , - , - , - , - ,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,
,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,
,,,,,,,,,,,,,,,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," (58,763)"," (117,527)"," (411,343)"," (528,870)"," (646,396)"," (881,449)"," (940,213)"," (998,976)"," (998,976)"," (998,976)"," (998,976)"," (998,976)"," (705,160)"," (646,396)"," (646,396)"," (470,106)"," (352,580)"," (352,580)",,,,,,,,,,,,
,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," 52,887 "," 105,774 "," 370,209 "," 475,983 "," 581,757 "," 793,305 "," 846,191 "," 899,078 "," 899,078 "," 899,078 "," 899,078 "," 899,078 "," 634,644 "," 581,757 "," 581,757 "," 423,096 "," 317,322 "," 317,322 ",,,,,,,,,,,,
,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, (357), (713)," (2,497)"," (3,210)"," (3,923)"," (5,350)"," (5,707)"," (6,064)"," (6,064)"," (6,064)"," (6,064)"," (6,064)"," (4,280)"," (3,923)"," (3,923)"," (2,853)"," (2,140)"," (2,140)",,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,," 1,687 "," 3,373 "," 11,807 "," 15,180 "," 18,554 "," 25,301 "," 26,987 "," 28,674 "," 28,674 "," 28,674 "," 28,674 "," 28,674 "," 20,240 "," 18,554 "," 18,554 "," 13,494 "," 10,120 "," 10,120 ",,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , -
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,,,,,,,,,,
,,,,,,,1,4,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,,,,,,,,,,
Cash Flow,,,,,,,"( 815,000)","( 180,000)","( 140,000)","( 80,000)", 0," 101,198"," 151,797"," 151,797"," 202,396"," 151,797"," 153,370"," 154,943"," 162,809"," 165,956"," 219,701"," 225,994"," 278,166"," 26,744"," 26,744"," 26,744"," 26,744"," 26,744"," 18,878"," 17,305"," 17,305"," 12,586"," 9,439"," 9,439",,,,,,,,,,
Cash Flow Accum.,,,,,,,"( 815,000)","( 995,000)","( 1,135,000)","( 1,215,000)","( 1,215,000)","( 1,113,802)","( 962,005)","( 810,208)","( 607,812)","( 456,015)","( 302,645)","( 147,702)"," 15,107"," 181,063"," 400,764"," 626,758"," 904,923"," 931,668"," 958,412"," 985,156"," 1,011,900"," 1,038,644"," 1,057,523"," 1,074,828"," 1,092,133"," 1,104,718"," 1,114,157"," 1,123,597",,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 4.Sao Bernardo]
Nome Empreendimento, Joao Basso ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, 3 Vertical 20 pav ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 247 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 124 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 48.00 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 63,239 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 15,620,043 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 18,744,051 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 9,372,026 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 170,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 75,887 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resultado Bruto Incorporação," 59,113 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 41,990,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 20,995,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$)," 20,995,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$)," 12,000,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Vendas ,,,,,,,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,15.00%,15.00%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,5.00%,5.00%,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,1-Sep-18,1-Sep-18,1-Oct-18,1-Oct-18,1-Oct-18,31-Oct-18,30-Nov-18,30-Dec-18,29-Jan-19,28-Feb-19,30-Mar-19,29-Apr-19,29-May-19,28-Jun-19,28-Jul-19,27-Aug-19,26-Sep-19,26-Oct-19,25-Nov-19,25-Dec-19,24-Jan-20,23-Feb-20,24-Mar-20,23-Apr-20,23-May-20,22-Jun-20,22-Jul-20,21-Aug-20,20-Sep-20,20-Oct-20,19-Nov-20,19-Dec-20,18-Jan-21,17-Feb-21,19-Mar-21,18-Apr-21,18-May-21,17-Jun-21,,,,,,
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação ,,,,,,, Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (940,000)", - ," (60,000)"," (150,000)"," (230,000)"," (120,000)"," (130,000)",,,,,,," (1,630,000)"," (419,900)"," (120,000)"," (70,000)"," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 2,099,500 "," 2,099,500 "," 2,624,375 "," 3,149,250 "," 3,149,250 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,574,625 "," 1,049,750 "," 1,049,750 ",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,, 9 , 9 , 9 , 9 , 9 , 9 , 9 , 9 , 9 , 12 , 12 , 15 , 19 , 19 , 9 , 9 , 9 , 9 , 9 , 9 , 9 , 9 , 6 , 6 ,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Recebimento Lotes/Frações ,,,,,,,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 432,250 "," 432,250 "," 540,313 "," 648,375 "," 648,375 "," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 324,188 "," 216,125 "," 216,125 ",,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Construção / Fase - 1 ,,,,,,,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,29-Jan-19,28-Feb-19,30-Mar-19,29-Apr-19,29-May-19,28-Jun-19,28-Jul-19,27-Aug-19,26-Sep-19,26-Oct-19,25-Nov-19,25-Dec-19,24-Jan-20,23-Feb-20,24-Mar-20,23-Apr-20,23-May-20,22-Jun-20,,,,,,,,,,,,,,,,,,
Construção / Fase - 1 ,,,,,,,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,," (46,860)"," (93,720)"," (328,021)"," (421,741)"," (515,461)"," (702,902)"," (749,762)"," (796,622)"," (796,622)"," (796,622)"," (796,622)"," (796,622)"," (562,322)"," (515,461)"," (515,461)"," (374,881)"," (281,161)"," (281,161)",,,,,,,,,,,,,,,,,,
Financiamento / Fase -1 ,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,," 42,174 "," 84,348 "," 295,219 "," 379,567 "," 463,915 "," 632,612 "," 674,786 "," 716,960 "," 716,960 "," 716,960 "," 716,960 "," 716,960 "," 506,089 "," 463,915 "," 463,915 "," 337,393 "," 253,045 "," 253,045 ",,,,,,,,,,,,,,,,,,
Custo Financiamento / Fase -1 ,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,, (284), (569)," (1,991)"," (2,560)"," (3,129)"," (4,266)"," (4,551)"," (4,835)"," (4,835)"," (4,835)"," (4,835)"," (4,835)"," (3,413)"," (3,129)"," (3,129)"," (2,275)"," (1,707)"," (1,707)",,,,,,,,,,,,,,,,,,
Medição / Recebimentos Fase -1 ,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,," 36,502 "," 73,005 "," 255,517 "," 328,521 "," 401,526 "," 547,536 "," 584,038 "," 620,540 "," 620,540 "," 620,540 "," 620,540 "," 620,540 "," 438,028 "," 401,526 "," 401,526 "," 292,019 "," 219,014 "," 219,014 ",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Construção / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,25-Nov-19,25-Dec-19,24-Jan-20,23-Feb-20,24-Mar-20,23-Apr-20,23-May-20,22-Jun-20,22-Jul-20,21-Aug-20,20-Sep-20,20-Oct-20,19-Nov-20,19-Dec-20,18-Jan-21,17-Feb-21,19-Mar-21,18-Apr-21,18-May-21,17-Jun-21,,,,,,
Construção / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," (46,860)"," (93,720)"," (328,021)"," (421,741)"," (515,461)"," (702,902)"," (749,762)"," (796,622)"," (796,622)"," (796,622)"," (796,622)"," (796,622)"," (562,322)"," (515,461)"," (515,461)"," (374,881)"," (281,161)"," (281,161)",,,,,,,,
Financiamento / Fase -2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 46,860 "," 93,720 "," 328,021 "," 421,741 "," 515,461 "," 702,902 "," 749,762 "," 796,622 "," 796,622 "," 796,622 "," 796,622 "," 796,622 "," 562,322 "," 515,461 "," 515,461 "," 374,881 "," 281,161 "," 281,161 ",,,,,,,,
Custo Financiamento / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, (316), (632)," (2,212)"," (2,844)"," (3,476)"," (4,740)"," (5,056)"," (5,373)"," (5,373)"," (5,373)"," (5,373)"," (5,373)"," (3,792)"," (3,476)"," (3,476)"," (2,528)"," (1,896)"," (1,896)",,,,,,,,
Medição / Recebimentos Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 36,502 "," 73,005 "," 255,517 "," 328,521 "," 401,526 "," 547,536 "," 584,038 "," 620,540 "," 620,540 "," 620,540 "," 620,540 "," 620,540 "," 438,028 "," 401,526 "," 401,526 "," 292,019 "," 219,014 "," 219,014 ",,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,1-Sep-18,1-Sep-18,1-Oct-18,1-Oct-18,1-Oct-18,31-Oct-18,30-Nov-18,30-Dec-18,29-Jan-19,28-Feb-19,30-Mar-19,29-Apr-19,29-May-19,28-Jun-19,28-Jul-19,27-Aug-19,26-Sep-19,26-Oct-19,25-Nov-19,25-Dec-19,24-Jan-20,23-Feb-20,24-Mar-20,23-Apr-20,23-May-20,22-Jun-20,22-Jul-20,21-Aug-20,20-Sep-20,20-Oct-20,19-Nov-20,19-Dec-20,18-Jan-21,17-Feb-21,19-Mar-21,18-Apr-21,18-May-21,17-Jun-21,,,,,,
,1,2,3,4,5,6,7,8,9,10,11,12,13,16,14,15,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,,,,,,
Cash Flow,,,,,,,,,,,,,"( 1,630,000)","( 419,900)","( 120,000)","( 70,000)", 0," 302,370"," 302,370"," 302,370"," 302,370"," 302,370"," 336,415"," 370,461"," 540,690"," 608,782"," 777,663"," 913,846"," 1,048,682"," 1,183,517"," 1,183,517"," 881,148"," 915,193"," 949,239"," 949,239"," 983,285"," 1,051,376"," 1,085,422"," 1,051,376"," 984,632"," 780,358"," 578,778"," 578,778"," 578,778"," 408,549"," 374,503"," 374,503"," 272,366"," 204,275"," 204,275",,,,,,
Cash Flow Accum.,,,,,,,,,,,,,"( 1,630,000)","( 2,049,900)","( 2,169,900)","( 2,239,900)","( 2,239,900)","( 1,937,530)","( 1,635,161)","( 1,332,791)","( 1,030,421)","( 728,052)","( 391,636)","( 21,175)"," 519,515"," 1,128,297"," 1,905,960"," 2,819,806"," 3,868,487"," 5,052,005"," 6,235,522"," 7,116,669"," 8,031,863"," 8,981,102"," 9,930,341"," 10,913,626"," 11,965,003"," 13,050,425"," 14,101,801"," 15,086,433"," 15,866,791"," 16,445,569"," 17,024,347"," 17,603,125"," 18,011,674"," 18,386,178"," 18,760,681"," 19,033,047"," 19,237,322"," 19,441,596",,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 5.Sao Paulo - Morumbi]
Nome Empreendimento, Near Morumbi ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Vertical 17 pav ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 60 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 60 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, 6 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, 22.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 61.71 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 81,302 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 4,878,101 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 5,853,722 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 5,853,722 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 220,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 97,562 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resutlado Bruto Incorporação," 87,438 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 13,200,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 8,360,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$), n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, 6 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$)," 1,300,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,
,,,,,,,,,,,5.00%,7.50%,7.50%,10.00%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação , Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (830,000)", - ," (25,000)"," (100,000)"," (70,000)"," (50,000)"," (40,000)"," (1,115,000)"," (180,000)"," (140,000)"," (80,000)"," 660,000 "," 990,000 "," 990,000 "," 1,320,000 "," 990,000 "," 990,000 "," 990,000 "," 990,000 "," 990,000 "," 1,320,000 "," 1,320,000 "," 1,650,000 ",,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, 3 , 5 , 5 , 6 , 5 , 5 , 5 , 5 , 5 , 6 , 6 , 8 ,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,," 105,000 "," 157,500 "," 157,500 "," 210,000 "," 157,500 "," 157,500 "," 157,500 "," 157,500 "," 157,500 "," 210,000 "," 210,000 "," 262,500 ", - , - , - , - , - , - , - , - , - , - , - , - ,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,
,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,
,,,,,,,,,,,,,,,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," (29,269)"," (58,537)"," (204,880)"," (263,417)"," (321,955)"," (439,029)"," (468,298)"," (497,566)"," (497,566)"," (497,566)"," (497,566)"," (497,566)"," (351,223)"," (321,955)"," (321,955)"," (234,149)"," (175,612)"," (175,612)",,,,,,,,,,,,
,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," 26,342 "," 52,683 "," 184,392 "," 237,076 "," 289,759 "," 395,126 "," 421,468 "," 447,810 "," 447,810 "," 447,810 "," 447,810 "," 447,810 "," 316,101 "," 289,759 "," 289,759 "," 210,734 "," 158,050 "," 158,050 ",,,,,,,,,,,,
,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, (178), (355)," (1,244)"," (1,599)"," (1,954)"," (2,665)"," (2,842)"," (3,020)"," (3,020)"," (3,020)"," (3,020)"," (3,020)"," (2,132)"," (1,954)"," (1,954)"," (1,421)"," (1,066)"," (1,066)",,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,," 26,231 "," 52,463 "," 183,620 "," 236,083 "," 288,545 "," 393,471 "," 419,702 "," 445,934 "," 445,934 "," 445,934 "," 445,934 "," 445,934 "," 314,777 "," 288,545 "," 288,545 "," 209,851 "," 157,388 "," 157,388 ",,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , -
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
,,,,,,,1,4,2,3,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
Cash Flow,,,,,,,"( 1,115,000)","( 180,000)","( 140,000)","( 80,000)", 0," 97,934"," 146,900"," 146,900"," 195,867"," 146,900"," 171,366"," 195,832"," 318,162"," 367,094"," 464,993"," 562,857"," 636,290"," 415,922"," 415,922"," 415,922"," 415,922"," 415,922"," 293,592"," 269,126"," 269,126"," 195,728"," 146,796"," 146,796", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
Cash Flow Accum.,,,,,,,"( 1,115,000)","( 1,295,000)","( 1,435,000)","( 1,515,000)","( 1,515,000)","( 1,417,067)","( 1,270,166)","( 1,123,266)","( 927,399)","( 780,499)","( 609,132)","( 413,300)","( 95,138)"," 271,957"," 736,950"," 1,299,807"," 1,936,097"," 2,352,019"," 2,767,942"," 3,183,864"," 3,599,786"," 4,015,709"," 4,309,301"," 4,578,427"," 4,847,553"," 5,043,282"," 5,190,078"," 5,336,874"," 5,336,874"," 5,336,874"," 5,336,874"," 5,336,874"," 5,336,874"," 5,336,874"," 5,336,874"," 5,336,874"," 5,336,874"," 5,336,874"
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 6.Mogi Mirim]
Nome Empreendimento,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Casas Terreas ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 303 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 152 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, 33 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, 16.7 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 48.00 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 63,239 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 19,161,429 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 22,993,715 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 11,496,857 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 120,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 75,887 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resultado Bruto Incorporação," 9,113 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 36,360,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 16,180,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$)," 16,180,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, 33 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$)," 4,000,000 ",Sendo 2M em dinheiro,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Vendas ,,,,,,,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,15.00%,15.00%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,5.00%,5.00%,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,,,,,,
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação ,,,,,,, Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (930,000)", - ," (60,000)"," (150,000)"," (230,000)"," (120,000)"," (130,000)",,,,,,," (1,620,000)"," (363,600)"," (120,000)"," (70,000)"," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,818,000 "," 1,818,000 "," 2,272,500 "," 2,727,000 "," 2,727,000 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 1,363,500 "," 909,000 "," 909,000 ",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,, 11 , 11 , 11 , 11 , 11 , 11 , 11 , 11 , 11 , 15 , 15 , 19 , 23 , 23 , 11 , 11 , 11 , 11 , 11 , 11 , 11 , 11 , 8 , 8 ,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Recebimento Lotes/Frações ,,,,,,,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 530,250 "," 530,250 "," 662,813 "," 795,375 "," 795,375 "," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 397,687 "," 265,125 "," 265,125 ",,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Construção / Fase - 1 ,,,,,,,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,,,,,,,,,,,,,,,,,,
Construção / Fase - 1 ,,,,,,,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,," (57,484)"," (114,969)"," (402,390)"," (517,359)"," (632,327)"," (862,264)"," (919,749)"," (977,233)"," (977,233)"," (977,233)"," (977,233)"," (977,233)"," (689,811)"," (632,327)"," (632,327)"," (459,874)"," (344,906)"," (344,906)",,,,,,,,,,,,,,,,,,
Financiamento / Fase -1 ,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,," 51,736 "," 103,472 "," 362,151 "," 465,623 "," 569,094 "," 776,038 "," 827,774 "," 879,510 "," 879,510 "," 879,510 "," 879,510 "," 879,510 "," 620,830 "," 569,094 "," 569,094 "," 413,887 "," 310,415 "," 310,415 ",,,,,,,,,,,,,,,,,,
Custo Financiamento / Fase -1 ,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,, (349), (698)," (2,442)"," (3,140)"," (3,838)"," (5,234)"," (5,583)"," (5,932)"," (5,932)"," (5,932)"," (5,932)"," (5,932)"," (4,187)"," (3,838)"," (3,838)"," (2,791)"," (2,093)"," (2,093)",,,,,,,,,,,,,,,,,,
Medição / Recebimentos Fase -1 ,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,," 6,903 "," 13,806 "," 48,322 "," 62,129 "," 75,935 "," 103,548 "," 110,451 "," 117,355 "," 117,355 "," 117,355 "," 117,355 "," 117,355 "," 82,839 "," 75,935 "," 75,935 "," 55,226 "," 41,419 "," 41,419 ",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Construção / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,,,,,,
Construção / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," (57,484)"," (114,969)"," (402,390)"," (517,359)"," (632,327)"," (862,264)"," (919,749)"," (977,233)"," (977,233)"," (977,233)"," (977,233)"," (977,233)"," (689,811)"," (632,327)"," (632,327)"," (459,874)"," (344,906)"," (344,906)",,,,,,,,
Financiamento / Fase -2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 57,484 "," 114,969 "," 402,390 "," 517,359 "," 632,327 "," 862,264 "," 919,749 "," 977,233 "," 977,233 "," 977,233 "," 977,233 "," 977,233 "," 689,811 "," 632,327 "," 632,327 "," 459,874 "," 344,906 "," 344,906 ",,,,,,,,
Custo Financiamento / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, (388), (775)," (2,714)"," (3,489)"," (4,264)"," (5,815)"," (6,203)"," (6,591)"," (6,591)"," (6,591)"," (6,591)"," (6,591)"," (4,652)"," (4,264)"," (4,264)"," (3,101)"," (2,326)"," (2,326)",,,,,,,,
Medição / Recebimentos Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 6,903 "," 13,806 "," 48,322 "," 62,129 "," 75,935 "," 103,548 "," 110,451 "," 117,355 "," 117,355 "," 117,355 "," 117,355 "," 117,355 "," 82,839 "," 75,935 "," 75,935 "," 55,226 "," 41,419 "," 41,419 ",,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,,,,,,
,1,2,3,4,5,6,7,8,9,10,11,12,13,16,14,15,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,,,,,,
Cash Flow,,,,,,,,,,,,,"( 1,620,000)","( 363,600)","( 120,000)","( 70,000)", 0," 370,923"," 370,923"," 370,923"," 370,923"," 370,923"," 377,362"," 383,800"," 415,994"," 428,871"," 565,389"," 591,144"," 721,223"," 851,303"," 851,303"," 480,380"," 486,818"," 493,257"," 493,257"," 499,696"," 512,573"," 519,012"," 512,573"," 395,370"," 356,739"," 109,457"," 109,457"," 109,457"," 77,264"," 70,825"," 70,825"," 51,509"," 38,632"," 38,632",,,,,,
Cash Flow Accum.,,,,,,,,,,,,,"( 1,620,000)","( 1,983,600)","( 2,103,600)","( 2,173,600)","( 2,173,600)","( 1,802,677)","( 1,431,754)","( 1,060,831)","( 689,907)","( 318,984)"," 58,377"," 442,178"," 858,171"," 1,287,042"," 1,852,431"," 2,443,575"," 3,164,798"," 4,016,101"," 4,867,404"," 5,347,784"," 5,834,602"," 6,327,859"," 6,821,116"," 7,320,812"," 7,833,385"," 8,352,396"," 8,864,969"," 9,260,340"," 9,617,078"," 9,726,535"," 9,835,992"," 9,945,448"," 10,022,712"," 10,093,537"," 10,164,362"," 10,215,871"," 10,254,502"," 10,293,134",,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 7.Piracicaba]
Nome Empreendimento, Pau Queimado ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Casas Terreas ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 421 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 211 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 48.00 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 63,239 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 26,623,636 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 31,948,363 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 15,974,182 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 130,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 75,887 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resultado Bruto Incorporação," 19,113 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 54,730,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 27,365,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$)," 27,365,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$)," 18,000,000 ",Sendo 5 em dinheiro e o restante em parceria,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Vendas ,,,,,,,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,15.00%,15.00%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,5.00%,5.00%,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,,,,,,
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação ,,,,,,, Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (960,000)", - ," (60,000)"," (150,000)"," (230,000)"," (120,000)"," (130,000)",,,,,,," (1,650,000)"," (547,300)"," (120,000)"," (70,000)"," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,736,500 "," 2,736,500 "," 3,420,625 "," 4,104,750 "," 4,104,750 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 2,052,375 "," 1,368,250 "," 1,368,250 ",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,, 16 , 16 , 16 , 16 , 16 , 16 , 16 , 16 , 16 , 21 , 21 , 26 , 32 , 32 , 16 , 16 , 16 , 16 , 16 , 16 , 16 , 16 , 11 , 11 ,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Recebimento Lotes/Frações ,,,,,,,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 736,750 "," 736,750 "," 920,938 "," 1,105,125 "," 1,105,125 "," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 552,563 "," 368,375 "," 368,375 ",,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Construção / Fase - 1 ,,,,,,,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,,,,,,,,,,,,,,,,,,
Construção / Fase - 1 ,,,,,,,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,," (79,871)"," (159,742)"," (559,096)"," (718,838)"," (878,580)"," (1,198,064)"," (1,277,935)"," (1,357,805)"," (1,357,805)"," (1,357,805)"," (1,357,805)"," (1,357,805)"," (958,451)"," (878,580)"," (878,580)"," (638,967)"," (479,225)"," (479,225)",,,,,,,,,,,,,,,,,,
Financiamento / Fase -1 ,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,," 71,884 "," 143,768 "," 503,187 "," 646,954 "," 790,722 "," 1,078,257 "," 1,150,141 "," 1,222,025 "," 1,222,025 "," 1,222,025 "," 1,222,025 "," 1,222,025 "," 862,606 "," 790,722 "," 790,722 "," 575,071 "," 431,303 "," 431,303 ",,,,,,,,,,,,,,,,,,
Custo Financiamento / Fase -1 ,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,, (485), (970)," (3,394)"," (4,363)"," (5,333)"," (7,272)"," (7,757)"," (8,241)"," (8,241)"," (8,241)"," (8,241)"," (8,241)"," (5,818)"," (5,333)"," (5,333)"," (3,878)"," (2,909)"," (2,909)",,,,,,,,,,,,,,,,,,
Medição / Recebimentos Fase -1 ,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,," 20,117 "," 40,233 "," 140,816 "," 181,049 "," 221,283 "," 301,749 "," 321,865 "," 341,982 "," 341,982 "," 341,982 "," 341,982 "," 341,982 "," 241,399 "," 221,283 "," 221,283 "," 160,933 "," 120,700 "," 120,700 ",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Construção / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,,,,,,
Construção / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," (79,871)"," (159,742)"," (559,096)"," (718,838)"," (878,580)"," (1,198,064)"," (1,277,935)"," (1,357,805)"," (1,357,805)"," (1,357,805)"," (1,357,805)"," (1,357,805)"," (958,451)"," (878,580)"," (878,580)"," (638,967)"," (479,225)"," (479,225)",,,,,,,,
Financiamento / Fase -2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 79,871 "," 159,742 "," 559,096 "," 718,838 "," 878,580 "," 1,198,064 "," 1,277,935 "," 1,357,805 "," 1,357,805 "," 1,357,805 "," 1,357,805 "," 1,357,805 "," 958,451 "," 878,580 "," 878,580 "," 638,967 "," 479,225 "," 479,225 ",,,,,,,,
Custo Financiamento / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, (539)," (1,077)"," (3,771)"," (4,848)"," (5,925)"," (8,080)"," (8,619)"," (9,157)"," (9,157)"," (9,157)"," (9,157)"," (9,157)"," (6,464)"," (5,925)"," (5,925)"," (4,309)"," (3,232)"," (3,232)",,,,,,,,
Medição / Recebimentos Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 20,117 "," 40,233 "," 140,816 "," 181,049 "," 221,283 "," 301,749 "," 321,865 "," 341,982 "," 341,982 "," 341,982 "," 341,982 "," 341,982 "," 241,399 "," 221,283 "," 221,283 "," 160,933 "," 120,700 "," 120,700 ",,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,,,,,,
,1,2,3,4,5,6,7,8,9,10,11,12,13,16,14,15,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,,,,,,
Cash Flow,,,,,,,,,,,,,"( 1,650,000)","( 547,300)","( 120,000)","( 70,000)", 0," 515,375"," 515,375"," 515,375"," 515,375"," 515,375"," 534,138"," 552,901"," 646,714"," 684,240"," 893,557"," 968,608"," 1,159,162"," 1,349,717"," 1,349,717"," 834,342"," 853,104"," 871,867"," 871,867"," 890,630"," 928,155"," 946,918"," 928,155"," 775,127"," 662,550"," 318,967"," 318,967"," 318,967"," 225,153"," 206,390"," 206,390"," 150,102"," 112,576"," 112,576",,,,,,
Cash Flow Accum.,,,,,,,,,,,,,"( 1,650,000)","( 2,197,300)","( 2,317,300)","( 2,387,300)","( 2,387,300)","( 1,871,925)","( 1,356,550)","( 841,175)","( 325,800)"," 189,575"," 723,713"," 1,276,614"," 1,923,328"," 2,607,568"," 3,501,124"," 4,469,732"," 5,628,895"," 6,978,612"," 8,328,328"," 9,162,670"," 10,015,774"," 10,887,642"," 11,759,509"," 12,650,139"," 13,578,294"," 14,525,213"," 15,453,368"," 16,228,494"," 16,891,045"," 17,210,011"," 17,528,978"," 17,847,945"," 18,073,097"," 18,279,488"," 18,485,878"," 18,635,980"," 18,748,556"," 18,861,133",,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 8.Campinas]
Nome Empreendimento, Nova Aparecida ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Vertical 7 pav ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 199 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 199 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, 19 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, 22.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 52.45 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 69,102 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 13,751,263 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 16,501,516 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 16,501,516 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 150,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 82,922 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resutlado Bruto Incorporação," 32,078 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 29,850,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 26,550,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$), n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, 19 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$)," 5,000,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,
,,,,,,,,,,,5.00%,7.50%,7.50%,10.00%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Sep-19,2-Sep-19,2-Oct-19,2-Oct-19,2-Oct-19,1-Nov-19,1-Dec-19,31-Dec-19,30-Jan-20,29-Feb-20,30-Mar-20,29-Apr-20,29-May-20,28-Jun-20,28-Jul-20,27-Aug-20,26-Sep-20,26-Oct-20,25-Nov-20,25-Dec-20,24-Jan-21,23-Feb-21,25-Mar-21,24-Apr-21,24-May-21,23-Jun-21,23-Jul-21,22-Aug-21,21-Sep-21,21-Oct-21,20-Nov-21,20-Dec-21,19-Jan-22,18-Feb-22,20-Mar-22,19-Apr-22,19-May-22,18-Jun-22
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação , Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (830,000)", - ," (25,000)"," (100,000)"," (70,000)"," (50,000)"," (40,000)"," (1,115,000)"," (180,000)"," (140,000)"," (80,000)"," 1,492,500 "," 2,238,750 "," 2,238,750 "," 2,985,000 "," 2,238,750 "," 2,238,750 "," 2,238,750 "," 2,238,750 "," 2,238,750 "," 2,985,000 "," 2,985,000 "," 3,731,250 ",,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, 10 , 15 , 15 , 20 , 15 , 15 , 15 , 15 , 15 , 20 , 20 , 25 ,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,," 348,250 "," 522,375 "," 522,375 "," 696,500 "," 522,375 "," 522,375 "," 522,375 "," 522,375 "," 522,375 "," 696,500 "," 696,500 "," 870,625 ", - , - , - , - , - , - , - , - , - , - , - , - ,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,
,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,
,,,,,,,,,,,,,,,30-Jan-20,29-Feb-20,30-Mar-20,29-Apr-20,29-May-20,28-Jun-20,28-Jul-20,27-Aug-20,26-Sep-20,26-Oct-20,25-Nov-20,25-Dec-20,24-Jan-21,23-Feb-21,25-Mar-21,24-Apr-21,24-May-21,23-Jun-21,23-Jul-21,22-Aug-21,21-Sep-21,21-Oct-21,20-Nov-21,20-Dec-21,19-Jan-22,18-Feb-22,20-Mar-22,19-Apr-22,19-May-22,18-Jun-22
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," (82,508)"," (165,015)"," (577,553)"," (742,568)"," (907,583)"," (1,237,614)"," (1,320,121)"," (1,402,629)"," (1,402,629)"," (1,402,629)"," (1,402,629)"," (1,402,629)"," (990,091)"," (907,583)"," (907,583)"," (660,061)"," (495,045)"," (495,045)",,,,,,,,,,,,
,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," 74,257 "," 148,514 "," 519,798 "," 668,311 "," 816,825 "," 1,113,852 "," 1,188,109 "," 1,262,366 "," 1,262,366 "," 1,262,366 "," 1,262,366 "," 1,262,366 "," 891,082 "," 816,825 "," 816,825 "," 594,055 "," 445,541 "," 445,541 ",,,,,,,,,,,,
,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, (501)," (1,002)"," (3,506)"," (4,507)"," (5,509)"," (7,512)"," (8,013)"," (8,514)"," (8,514)"," (8,514)"," (8,514)"," (8,514)"," (6,010)"," (5,509)"," (5,509)"," (4,006)"," (3,005)"," (3,005)",,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,," 31,917 "," 63,835 "," 223,422 "," 287,257 "," 351,092 "," 478,761 "," 510,679 "," 542,596 "," 542,596 "," 542,596 "," 542,596 "," 542,596 "," 383,009 "," 351,092 "," 351,092 "," 255,339 "," 191,505 "," 191,505 ",,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , -
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Sep-19,2-Sep-19,2-Oct-19,2-Oct-19,2-Oct-19,1-Nov-19,1-Dec-19,31-Dec-19,30-Jan-20,29-Feb-20,30-Mar-20,29-Apr-20,29-May-20,28-Jun-20,28-Jul-20,27-Aug-20,26-Sep-20,26-Oct-20,25-Nov-20,25-Dec-20,24-Jan-21,23-Feb-21,25-Mar-21,24-Apr-21,24-May-21,23-Jun-21,23-Jul-21,22-Aug-21,21-Sep-21,21-Oct-21,20-Nov-21,20-Dec-21,19-Jan-22,18-Feb-22,20-Mar-22,19-Apr-22,19-May-22,18-Jun-22
,,,,,,,1,4,2,3,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
Cash Flow,,,,,,,"( 1,115,000)","( 180,000)","( 140,000)","( 80,000)", 0," 324,813"," 487,219"," 487,219"," 649,626"," 487,219"," 516,989"," 546,758"," 695,605"," 755,144"," 977,089"," 1,096,166"," 1,288,342"," 506,079"," 506,079"," 506,079"," 506,079"," 506,079"," 357,233"," 327,463"," 327,463"," 238,155"," 178,616"," 178,616", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
Cash Flow Accum.,,,,,,,"( 1,115,000)","( 1,295,000)","( 1,435,000)","( 1,515,000)","( 1,515,000)","( 1,190,187)","( 702,968)","( 215,749)"," 433,877"," 921,096"," 1,438,084"," 1,984,842"," 2,680,447"," 3,435,591"," 4,412,679"," 5,508,846"," 6,797,188"," 7,303,267"," 7,809,346"," 8,315,426"," 8,821,505"," 9,327,585"," 9,684,817"," 10,012,280"," 10,339,743"," 10,577,898"," 10,756,515"," 10,935,131"," 10,935,131"," 10,935,131"," 10,935,131"," 10,935,131"," 10,935,131"," 10,935,131"," 10,935,131"," 10,935,131"," 10,935,131"," 10,935,131"
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 9.Parada Inglesa]
Nome Empreendimento, Dona Gabriela ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Vertical 18 pav + 4 Sub ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 152 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 152 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, 42 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, 22.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 51.66 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 68,061 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 10,345,275 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 12,414,329 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 12,414,329 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 180,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 81,673 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resutlado Bruto Incorporação," 63,327 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 27,360,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 23,400,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$), n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, 42 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$)," 7,500,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,
,,,,,,,,,,,5.00%,7.50%,7.50%,10.00%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Sep-18,2-Sep-18,2-Oct-18,2-Oct-18,2-Oct-18,1-Nov-18,1-Dec-18,31-Dec-18,30-Jan-19,1-Mar-19,31-Mar-19,30-Apr-19,30-May-19,29-Jun-19,29-Jul-19,28-Aug-19,27-Sep-19,27-Oct-19,26-Nov-19,26-Dec-19,25-Jan-20,24-Feb-20,25-Mar-20,24-Apr-20,24-May-20,23-Jun-20,23-Jul-20,22-Aug-20,21-Sep-20,21-Oct-20,20-Nov-20,20-Dec-20,19-Jan-21,18-Feb-21,20-Mar-21,19-Apr-21,19-May-21,18-Jun-21
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação , Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (850,000)", - ," (25,000)"," (100,000)"," (70,000)"," (50,000)"," (40,000)"," (1,135,000)"," (180,000)"," (140,000)"," (80,000)"," 1,368,000 "," 2,052,000 "," 2,052,000 "," 2,736,000 "," 2,052,000 "," 2,052,000 "," 2,052,000 "," 2,052,000 "," 2,052,000 "," 2,736,000 "," 2,736,000 "," 3,420,000 ",,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, 8 , 11 , 11 , 15 , 11 , 11 , 11 , 11 , 11 , 15 , 15 , 19 ,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,," 266,000 "," 399,000 "," 399,000 "," 532,000 "," 399,000 "," 399,000 "," 399,000 "," 399,000 "," 399,000 "," 532,000 "," 532,000 "," 665,000 ", - , - , - , - , - , - , - , - , - , - , - , - ,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,
,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,
,,,,,,,,,,,,,,,30-Jan-19,1-Mar-19,31-Mar-19,30-Apr-19,30-May-19,29-Jun-19,29-Jul-19,28-Aug-19,27-Sep-19,27-Oct-19,26-Nov-19,26-Dec-19,25-Jan-20,24-Feb-20,25-Mar-20,24-Apr-20,24-May-20,23-Jun-20,23-Jul-20,22-Aug-20,21-Sep-20,21-Oct-20,20-Nov-20,20-Dec-20,19-Jan-21,18-Feb-21,20-Mar-21,19-Apr-21,19-May-21,18-Jun-21
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," (62,072)"," (124,143)"," (434,502)"," (558,645)"," (682,788)"," (931,075)"," (993,146)"," (1,055,218)"," (1,055,218)"," (1,055,218)"," (1,055,218)"," (1,055,218)"," (744,860)"," (682,788)"," (682,788)"," (496,573)"," (372,430)"," (372,430)",,,,,,,,,,,,
,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," 55,864 "," 111,729 "," 391,051 "," 502,780 "," 614,509 "," 837,967 "," 893,832 "," 949,696 "," 949,696 "," 949,696 "," 949,696 "," 949,696 "," 670,374 "," 614,509 "," 614,509 "," 446,916 "," 335,187 "," 335,187 ",,,,,,,,,,,,
,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, (377), (754)," (2,637)"," (3,391)"," (4,144)"," (5,651)"," (6,028)"," (6,405)"," (6,405)"," (6,405)"," (6,405)"," (6,405)"," (4,521)"," (4,144)"," (4,144)"," (3,014)"," (2,261)"," (2,261)",,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,," 48,128 "," 96,257 "," 336,898 "," 433,155 "," 529,412 "," 721,925 "," 770,054 "," 818,182 "," 818,182 "," 818,182 "," 818,182 "," 818,182 "," 577,540 "," 529,412 "," 529,412 "," 385,027 "," 288,770 "," 288,770 ",,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , -
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Sep-18,2-Sep-18,2-Oct-18,2-Oct-18,2-Oct-18,1-Nov-18,1-Dec-18,31-Dec-18,30-Jan-19,1-Mar-19,31-Mar-19,30-Apr-19,30-May-19,29-Jun-19,29-Jul-19,28-Aug-19,27-Sep-19,27-Oct-19,26-Nov-19,26-Dec-19,25-Jan-20,24-Feb-20,25-Mar-20,24-Apr-20,24-May-20,23-Jun-20,23-Jul-20,22-Aug-20,21-Sep-20,21-Oct-20,20-Nov-20,20-Dec-20,19-Jan-21,18-Feb-21,20-Mar-21,19-Apr-21,19-May-21,18-Jun-21
,,,,,,,1,4,2,3,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
Cash Flow,,,,,,,"( 1,135,000)","( 180,000)","( 140,000)","( 80,000)", 0," 248,098"," 372,147"," 372,147"," 496,196"," 372,147"," 417,037"," 461,926"," 686,373"," 776,151"," 989,979"," 1,169,536"," 1,338,475"," 763,118"," 763,118"," 763,118"," 763,118"," 763,118"," 538,672"," 493,782"," 493,782"," 359,115"," 269,336"," 269,336", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
Cash Flow Accum.,,,,,,,"( 1,135,000)","( 1,315,000)","( 1,455,000)","( 1,535,000)","( 1,535,000)","( 1,286,902)","( 914,755)","( 542,607)","( 46,411)"," 325,737"," 742,773"," 1,204,699"," 1,891,072"," 2,667,223"," 3,657,202"," 4,826,738"," 6,165,212"," 6,928,331"," 7,691,449"," 8,454,567"," 9,217,686"," 9,980,804"," 10,519,476"," 11,013,258"," 11,507,041"," 11,866,155"," 12,135,491"," 12,404,827"," 12,404,827"," 12,404,827"," 12,404,827"," 12,404,827"," 12,404,827"," 12,404,827"," 12,404,827"," 12,404,827"," 12,404,827"," 12,404,827"
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 10.Campinas]
Nome Empreendimento, Taquaral ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Vertical 16 pav ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 98 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 98 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, 18 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, 22.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 51.66 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 68,061 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 6,669,980 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 8,003,976 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 8,003,976 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 320,000.00 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 81,673 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resutlado Bruto Incorporação," 203,327 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 31,360,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 24,320,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$), n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, 18 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$)," 7,500,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,
,,,,,,,,,,,5.00%,7.50%,7.50%,10.00%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,4-Apr-19,4-Apr-19,4-May-19,4-May-19,4-May-19,3-Jun-19,3-Jul-19,2-Aug-19,1-Sep-19,1-Oct-19,31-Oct-19,30-Nov-19,30-Dec-19,29-Jan-20,28-Feb-20,29-Mar-20,28-Apr-20,28-May-20,27-Jun-20,27-Jul-20,26-Aug-20,25-Sep-20,25-Oct-20,24-Nov-20,24-Dec-20,23-Jan-21,22-Feb-21,24-Mar-21,23-Apr-21,23-May-21,22-Jun-21,22-Jul-21,21-Aug-21,20-Sep-21,20-Oct-21,19-Nov-21,19-Dec-21,18-Jan-22
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação , Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (980,000)", - ," (25,000)"," (100,000)"," (70,000)"," (50,000)"," (40,000)"," (1,265,000)"," (180,000)"," (140,000)"," (80,000)"," 1,568,000 "," 2,352,000 "," 2,352,000 "," 3,136,000 "," 2,352,000 "," 2,352,000 "," 2,352,000 "," 2,352,000 "," 2,352,000 "," 3,136,000 "," 3,136,000 "," 3,920,000 ",,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, 5 , 7 , 7 , 10 , 7 , 7 , 7 , 7 , 7 , 10 , 10 , 12 ,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,," 171,500 "," 257,250 "," 257,250 "," 343,000 "," 257,250 "," 257,250 "," 257,250 "," 257,250 "," 257,250 "," 343,000 "," 343,000 "," 428,750 ", - , - , - , - , - , - , - , - , - , - , - , - ,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,
,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,
,,,,,,,,,,,,,,,1-Sep-19,1-Oct-19,31-Oct-19,30-Nov-19,30-Dec-19,29-Jan-20,28-Feb-20,29-Mar-20,28-Apr-20,28-May-20,27-Jun-20,27-Jul-20,26-Aug-20,25-Sep-20,25-Oct-20,24-Nov-20,24-Dec-20,23-Jan-21,22-Feb-21,24-Mar-21,23-Apr-21,23-May-21,22-Jun-21,22-Jul-21,21-Aug-21,20-Sep-21,20-Oct-21,19-Nov-21,19-Dec-21,18-Jan-22
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," (40,020)"," (80,040)"," (280,139)"," (360,179)"," (440,219)"," (600,298)"," (640,318)"," (680,338)"," (680,338)"," (680,338)"," (680,338)"," (680,338)"," (480,239)"," (440,219)"," (440,219)"," (320,159)"," (240,119)"," (240,119)",,,,,,,,,,,,
,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," 36,018 "," 72,036 "," 252,125 "," 324,161 "," 396,197 "," 540,268 "," 576,286 "," 612,304 "," 612,304 "," 612,304 "," 612,304 "," 612,304 "," 432,215 "," 396,197 "," 396,197 "," 288,143 "," 216,107 "," 216,107 ",,,,,,,,,,,,
,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, (243), (486)," (1,700)"," (2,186)"," (2,672)"," (3,644)"," (3,887)"," (4,129)"," (4,129)"," (4,129)"," (4,129)"," (4,129)"," (2,915)"," (2,672)"," (2,672)"," (1,943)"," (1,457)"," (1,457)",,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,," 99,630 "," 199,260 "," 697,411 "," 896,671 "," 1,095,931 "," 1,494,452 "," 1,594,082 "," 1,693,712 "," 1,693,712 "," 1,693,712 "," 1,693,712 "," 1,693,712 "," 1,195,561 "," 1,095,931 "," 1,095,931 "," 797,041 "," 597,781 "," 597,781 ",,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , -
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,4-Apr-19,4-Apr-19,4-May-19,4-May-19,4-May-19,3-Jun-19,3-Jul-19,2-Aug-19,1-Sep-19,1-Oct-19,31-Oct-19,30-Nov-19,30-Dec-19,29-Jan-20,28-Feb-20,29-Mar-20,28-Apr-20,28-May-20,27-Jun-20,27-Jul-20,26-Aug-20,25-Sep-20,25-Oct-20,24-Nov-20,24-Dec-20,23-Jan-21,22-Feb-21,24-Mar-21,23-Apr-21,23-May-21,22-Jun-21,22-Jul-21,21-Aug-21,20-Sep-21,20-Oct-21,19-Nov-21,19-Dec-21,18-Jan-22
,,,,,,,1,4,2,3,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
Cash Flow,,,,,,,"( 1,265,000)","( 180,000)","( 140,000)","( 80,000)", 0," 159,958"," 239,937"," 239,937"," 319,916"," 239,937"," 332,862"," 425,787"," 890,412"," 1,076,262"," 1,342,091"," 1,713,791"," 1,886,695"," 1,579,725"," 1,579,725"," 1,579,725"," 1,579,725"," 1,579,725"," 1,115,100"," 1,022,175"," 1,022,175"," 743,400"," 557,550"," 557,550", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
Cash Flow Accum.,,,,,,,"( 1,265,000)","( 1,445,000)","( 1,585,000)","( 1,665,000)","( 1,665,000)","( 1,505,042)","( 1,265,105)","( 1,025,168)","( 705,252)","( 465,315)","( 132,453)"," 293,335"," 1,183,747"," 2,260,009"," 3,602,100"," 5,315,892"," 7,202,587"," 8,782,312"," 10,362,037"," 11,941,763"," 13,521,488"," 15,101,213"," 16,216,313"," 17,238,489"," 18,260,664"," 19,004,064"," 19,561,614"," 20,119,164"," 20,119,164"," 20,119,164"," 20,119,164"," 20,119,164"," 20,119,164"," 20,119,164"," 20,119,164"," 20,119,164"," 20,119,164"," 20,119,164"
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 11.Leme]
Nome Empreendimento, Resid dos Ipes ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Casas Térreas ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 417 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 209 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 49.50 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 65,215 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 27,194,763 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 32,633,716 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 16,316,858 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 115,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 78,258 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resultado Bruto Incorporação," 1,742 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 47,955,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 23,977,500 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$)," 23,977,500 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$), - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Vendas ,,,,,,,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,15.00%,15.00%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,7.50%,5.00%,5.00%,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,,,,,,
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação ,,,,,,, Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (940,000)", - ," (60,000)"," (150,000)"," (230,000)"," (120,000)"," (130,000)",,,,,,," (1,630,000)"," (479,550)"," (120,000)"," (70,000)"," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 2,397,750 "," 2,397,750 "," 2,997,188 "," 3,596,625 "," 3,596,625 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,798,313 "," 1,198,875 "," 1,198,875 ",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,, 16 , 16 , 16 , 16 , 16 , 16 , 16 , 16 , 16 , 21 , 21 , 26 , 31 , 31 , 16 , 16 , 16 , 16 , 16 , 16 , 16 , 16 , 10 , 10 ,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Recebimento Lotes/Frações ,,,,,,,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 729,750 "," 729,750 "," 912,188 "," 1,094,625 "," 1,094,625 "," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 547,313 "," 364,875 "," 364,875 ",,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Construção / Fase - 1 ,,,,,,,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,,,,,,,,,,,,,,,,,,
Construção / Fase - 1 ,,,,,,,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,," (81,584)"," (163,169)"," (571,090)"," (734,259)"," (897,427)"," (1,223,764)"," (1,305,349)"," (1,386,933)"," (1,386,933)"," (1,386,933)"," (1,386,933)"," (1,386,933)"," (979,011)"," (897,427)"," (897,427)"," (652,674)"," (489,506)"," (489,506)",,,,,,,,,,,,,,,,,,
Financiamento / Fase -1 ,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,," 73,426 "," 146,852 "," 513,981 "," 660,833 "," 807,684 "," 1,101,388 "," 1,174,814 "," 1,248,240 "," 1,248,240 "," 1,248,240 "," 1,248,240 "," 1,248,240 "," 881,110 "," 807,684 "," 807,684 "," 587,407 "," 440,555 "," 440,555 ",,,,,,,,,,,,,,,,,,
Custo Financiamento / Fase -1 ,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,, (495), (990)," (3,466)"," (4,457)"," (5,447)"," (7,428)"," (7,923)"," (8,418)"," (8,418)"," (8,418)"," (8,418)"," (8,418)"," (5,942)"," (5,447)"," (5,447)"," (3,962)"," (2,971)"," (2,971)",,,,,,,,,,,,,,,,,,
Medição / Recebimentos Fase -1 ,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,," 1,816 "," 3,631 "," 12,710 "," 16,341 "," 19,973 "," 27,236 "," 29,051 "," 30,867 "," 30,867 "," 30,867 "," 30,867 "," 30,867 "," 21,789 "," 19,973 "," 19,973 "," 14,526 "," 10,894 "," 10,894 ",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Construção / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,,,,,,
Construção / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," (81,584)"," (163,169)"," (571,090)"," (734,259)"," (897,427)"," (1,223,764)"," (1,305,349)"," (1,386,933)"," (1,386,933)"," (1,386,933)"," (1,386,933)"," (1,386,933)"," (979,011)"," (897,427)"," (897,427)"," (652,674)"," (489,506)"," (489,506)",,,,,,,,
Financiamento / Fase -2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 81,584 "," 163,169 "," 571,090 "," 734,259 "," 897,427 "," 1,223,764 "," 1,305,349 "," 1,386,933 "," 1,386,933 "," 1,386,933 "," 1,386,933 "," 1,386,933 "," 979,011 "," 897,427 "," 897,427 "," 652,674 "," 489,506 "," 489,506 ",,,,,,,,
Custo Financiamento / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, (550)," (1,100)"," (3,852)"," (4,952)"," (6,052)"," (8,253)"," (8,803)"," (9,354)"," (9,354)"," (9,354)"," (9,354)"," (9,354)"," (6,603)"," (6,052)"," (6,052)"," (4,402)"," (3,301)"," (3,301)",,,,,,,,
Medição / Recebimentos Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," 1,816 "," 3,631 "," 12,710 "," 16,341 "," 19,973 "," 27,236 "," 29,051 "," 30,867 "," 30,867 "," 30,867 "," 30,867 "," 30,867 "," 21,789 "," 19,973 "," 19,973 "," 14,526 "," 10,894 "," 10,894 ",,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21,,,,,,
,1,2,3,4,5,6,7,8,9,10,11,12,13,16,14,15,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,,,,,,
Cash Flow,,,,,,,,,,,,,"( 1,630,000)","( 479,550)","( 120,000)","( 70,000)", 0," 510,478"," 510,478"," 510,478"," 510,478"," 510,478"," 512,172"," 513,865"," 522,333"," 525,720"," 699,266"," 706,041"," 877,893"," 1,049,746"," 1,049,746"," 539,268"," 540,962"," 542,655"," 542,655"," 544,349"," 547,736"," 549,429"," 547,736"," 379,270"," 369,109"," 28,790"," 28,790"," 28,790"," 20,322"," 18,629"," 18,629"," 13,548"," 10,161"," 10,161",,,,,,
Cash Flow Accum.,,,,,,,,,,,,,"( 1,630,000)","( 2,109,550)","( 2,229,550)","( 2,299,550)","( 2,299,550)","( 1,789,072)","( 1,278,593)","( 768,115)","( 257,637)"," 252,842"," 765,014"," 1,278,879"," 1,801,212"," 2,326,932"," 3,026,199"," 3,732,239"," 4,610,133"," 5,659,879"," 6,709,625"," 7,248,893"," 7,789,855"," 8,332,510"," 8,875,165"," 9,419,514"," 9,967,250"," 10,516,679"," 11,064,414"," 11,443,684"," 11,812,793"," 11,841,582"," 11,870,372"," 11,899,162"," 11,919,484"," 11,938,113"," 11,956,741"," 11,970,289"," 11,980,450"," 11,990,611",,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 12.Aluminio]
Nome Empreendimento, Aluminio ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Casas Térreas ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 174 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 174 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, 22.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 49.50 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 65,215 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 11,347,455 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 13,616,946 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 13,616,946 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 130,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 78,258 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resutlado Bruto Incorporação," 16,742 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 22,620,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 19,760,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$), n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$), - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,
,,,,,,,,,,,5.00%,7.50%,7.50%,10.00%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação , Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (970,000)", - ," (25,000)"," (150,000)"," (100,000)"," (80,000)"," (40,000)"," (1,365,000)"," (230,000)"," (150,000)"," (80,000)"," 1,131,000 "," 1,696,500 "," 1,696,500 "," 2,262,000 "," 1,696,500 "," 1,696,500 "," 1,696,500 "," 1,696,500 "," 1,696,500 "," 2,262,000 "," 2,262,000 "," 2,827,500 ",,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, 9 , 13 , 13 , 17 , 13 , 13 , 13 , 13 , 13 , 17 , 17 , 22 ,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,," 304,500 "," 456,750 "," 456,750 "," 609,000 "," 456,750 "," 456,750 "," 456,750 "," 456,750 "," 456,750 "," 609,000 "," 609,000 "," 761,250 ", - , - , - , - , - , - , - , - , - , - , - , - ,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,
,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,
,,,,,,,,,,,,,,,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," (68,085)"," (136,169)"," (476,593)"," (612,763)"," (748,932)"," (1,021,271)"," (1,089,356)"," (1,157,440)"," (1,157,440)"," (1,157,440)"," (1,157,440)"," (1,157,440)"," (817,017)"," (748,932)"," (748,932)"," (544,678)"," (408,508)"," (408,508)",,,,,,,,,,,,
,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," 61,276 "," 122,553 "," 428,934 "," 551,486 "," 674,039 "," 919,144 "," 980,420 "," 1,041,696 "," 1,041,696 "," 1,041,696 "," 1,041,696 "," 1,041,696 "," 735,315 "," 674,039 "," 674,039 "," 490,210 "," 367,658 "," 367,658 ",,,,,,,,,,,,
,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, (413), (827)," (2,893)"," (3,719)"," (4,546)"," (6,199)"," (6,612)"," (7,025)"," (7,025)"," (7,025)"," (7,025)"," (7,025)"," (4,959)"," (4,546)"," (4,546)"," (3,306)"," (2,480)"," (2,480)",,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,," 14,565 "," 29,131 "," 101,957 "," 131,087 "," 160,218 "," 218,479 "," 233,044 "," 247,610 "," 247,610 "," 247,610 "," 247,610 "," 247,610 "," 174,783 "," 160,218 "," 160,218 "," 116,522 "," 87,392 "," 87,392 ",,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , -
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
,,,,,,,1,4,2,3,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
Cash Flow,,,,,,,"( 1,365,000)","( 230,000)","( 150,000)","( 80,000)", 0," 284,007"," 426,011"," 426,011"," 568,014"," 426,011"," 439,596"," 453,181"," 521,106"," 548,276"," 717,450"," 771,790"," 927,378"," 230,945"," 230,945"," 230,945"," 230,945"," 230,945"," 163,020"," 149,435"," 149,435"," 108,680"," 81,510"," 81,510", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
Cash Flow Accum.,,,,,,,"( 1,365,000)","( 1,595,000)","( 1,745,000)","( 1,825,000)","( 1,825,000)","( 1,540,993)","( 1,114,982)","( 688,971)","( 120,957)"," 305,054"," 744,649"," 1,197,830"," 1,718,936"," 2,267,212"," 2,984,662"," 3,756,451"," 4,683,830"," 4,914,775"," 5,145,720"," 5,376,666"," 5,607,611"," 5,838,557"," 6,001,577"," 6,151,012"," 6,300,448"," 6,409,128"," 6,490,638"," 6,572,148"," 6,572,148"," 6,572,148"," 6,572,148"," 6,572,148"," 6,572,148"," 6,572,148"," 6,572,148"," 6,572,148"," 6,572,148"," 6,572,148"
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: 13.Itapetininga]
Nome Empreendimento, Nascentes ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Tipo Construção, Casas Térreas ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Faixa MCMV, 2.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Núm.Unidades, 99 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fases, 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Unid. p/ Fases, 99 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço terreno por fase, 22.0 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo m2," 1,317 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Área Privativa (m2), 53.70 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Dormitórios, 2 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Custo Unid. (R$)," 70,749 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Privativa (R$)," 7,004,119 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fator, 1.20 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Área Construída (R$)," 8,404,943 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo por Fase (R$)," 8,404,943 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Preço Venda Unid. (R$)," 130,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Lote/Fração Ideal," 35,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Valor Obras," 84,898 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Resutlado Bruto Incorporação," 10,102 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV (R$)," 12,870,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 1 (R$)," 10,010,000 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
VGV Fase ISO - 2 (R$), n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Terreno, Permuta ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Física, - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Permuta Financeira, n/a ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Terreno (R$), - ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Custo Financiamento (a.a.),8.40%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Porcentagem Financ.CEF,90.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Marketing,1.00%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Infra Não-Incidente,n/a,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Alíquota IR,6.73%,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, Vendas Fase - 1 ,,,,,,,,,,,, Vendas Fase - 2 ,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,,,,,,,,,,
,,,,,,,,,,,5.00%,7.50%,7.50%,10.00%,7.50%,7.50%,7.50%,7.50%,7.50%,10.00%,10.00%,12.50%,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
Sinal/Negócio , Despesas Terreno , Estudo Preliminar , Despesas Aprovação , ITBI/SPE , Projeto Legal , Incorporação , Total Desembolsos , Marketing , Plantão , Modelo , Vendas Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
" (780,000)", - ," (25,000)"," (100,000)"," (70,000)"," (50,000)"," (40,000)"," (1,065,000)"," (180,000)"," (140,000)"," (80,000)"," 643,500 "," 965,250 "," 965,250 "," 1,287,000 "," 965,250 "," 965,250 "," 965,250 "," 965,250 "," 965,250 "," 1,287,000 "," 1,287,000 "," 1,608,750 ",,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,, 5 , 7 , 7 , 10 , 7 , 7 , 7 , 7 , 7 , 10 , 10 , 12 ,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -1 ,,,,,,,,,,,, Recebimento Lotes/Frações Ideiais / Fase -2 ,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,," 173,250 "," 259,875 "," 259,875 "," 346,500 "," 259,875 "," 259,875 "," 259,875 "," 259,875 "," 259,875 "," 346,500 "," 346,500 "," 433,125 ", - , - , - , - , - , - , - , - , - , - , - , - ,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,,,,,,,,,,,
,,,,,,,,,,,,,,,0.50%,1.00%,3.50%,4.50%,5.50%,7.50%,8.00%,8.50%,8.50%,8.50%,8.50%,8.50%,6.00%,5.50%,5.50%,4.00%,3.00%,3.00%,,,,,,,,,,,,
,,,,,,,,,,,,,,,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
,,,,,,,,,,,,,,, Construção Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," (42,025)"," (84,049)"," (294,173)"," (378,222)"," (462,272)"," (630,371)"," (672,395)"," (714,420)"," (714,420)"," (714,420)"," (714,420)"," (714,420)"," (504,297)"," (462,272)"," (462,272)"," (336,198)"," (252,148)"," (252,148)",,,,,,,,,,,,
,,,,,,,,,,,,,,, Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,," 37,822 "," 75,644 "," 264,756 "," 340,400 "," 416,045 "," 567,334 "," 605,156 "," 642,978 "," 642,978 "," 642,978 "," 642,978 "," 642,978 "," 453,867 "," 416,045 "," 416,045 "," 302,578 "," 226,933 "," 226,933 ",,,,,,,,,,,,
,,,,,,,,,,,,,,, Custo Financiamento Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,, (255), (510)," (1,786)"," (2,296)"," (2,806)"," (3,826)"," (4,081)"," (4,336)"," (4,336)"," (4,336)"," (4,336)"," (4,336)"," (3,061)"," (2,806)"," (2,806)"," (2,041)"," (1,530)"," (1,530)",,,,,,,,,,,,
,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,," 5,000 "," 10,001 "," 35,002 "," 45,003 "," 55,003 "," 75,004 "," 80,005 "," 85,005 "," 85,005 "," 85,005 "," 85,005 "," 85,005 "," 60,003 "," 55,003 "," 55,003 "," 40,002 "," 30,002 "," 30,002 ",,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, Construção Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,, Custo Financiamento Fase - 2 ,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, Medição / Recebimento Obras / Fase - 2 ,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,, - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , - , -
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,2-Apr-18,2-Apr-18,2-May-18,2-May-18,2-May-18,1-Jun-18,1-Jul-18,31-Jul-18,30-Aug-18,29-Sep-18,29-Oct-18,28-Nov-18,28-Dec-18,27-Jan-19,26-Feb-19,28-Mar-19,27-Apr-19,27-May-19,26-Jun-19,26-Jul-19,25-Aug-19,24-Sep-19,24-Oct-19,23-Nov-19,23-Dec-19,22-Jan-20,21-Feb-20,22-Mar-20,21-Apr-20,21-May-20,20-Jun-20,20-Jul-20,19-Aug-20,18-Sep-20,18-Oct-20,17-Nov-20,17-Dec-20,16-Jan-21
,,,,,,,1,4,2,3,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
Cash Flow,,,,,,,"( 1,065,000)","( 180,000)","( 140,000)","( 80,000)", 0," 161,590"," 242,385"," 242,385"," 323,181"," 242,385"," 247,049"," 251,713"," 275,032"," 284,359"," 374,482"," 393,137"," 478,596"," 79,284"," 79,284"," 79,284"," 79,284"," 79,284"," 55,965"," 51,301"," 51,301"," 37,310"," 27,983"," 27,983", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
Cash Flow Accum.,,,,,,,"( 1,065,000)","( 1,245,000)","( 1,385,000)","( 1,465,000)","( 1,465,000)","( 1,303,410)","( 1,061,024)","( 818,639)","( 495,458)","( 253,073)","( 6,024)"," 245,689"," 520,721"," 805,080"," 1,179,562"," 1,572,699"," 2,051,295"," 2,130,579"," 2,209,863"," 2,289,147"," 2,368,431"," 2,447,716"," 2,503,681"," 2,554,982"," 2,606,284"," 2,643,594"," 2,671,576"," 2,699,559"," 2,699,559"," 2,699,559"," 2,699,559"," 2,699,559"," 2,699,559"," 2,699,559"," 2,699,559"," 2,699,559"," 2,699,559"," 2,699,559"
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[Planilha: Somente Novos]
,,VGV Total,2-Apr-18,2-May-18,1-Jun-18,1-Jul-18,1-Aug-18,1-Sep-18,2-Oct-18,2-Nov-18,3-Dec-18,2-Jan-19,2-Feb-19,4-Mar-19,4-Apr-19,5-May-19,4-Jun-19,4-Jul-19,3-Aug-19,2-Sep-19,2-Oct-19,2-Nov-19,3-Dec-19,2-Jan-20,2-Feb-20,3-Mar-20,3-Apr-20,4-May-20,3-Jun-20,3-Jul-20,2-Aug-20,1-Sep-20,1-Oct-20,31-Oct-20,30-Nov-20,30-Dec-20,30-Jan-21,28-Feb-21,31-Mar-21,30-Apr-21,31-May-21,30-Jun-21,31-Jul-21,30-Aug-21,30-Sep-21,30-Oct-21,30-Nov-21,30-Dec-21,30-Jan-22,28-Feb-22,,,
Araraquara, 1," 166,050,000"," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 "," 1,048,625 ",,,
Ferroban, 2," 50,508,000"," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 "," 427,833 ",,,
Guarulhos, 3," 14,260,000"," 93,633 "," 93,633 "," 93,633 "," 93,633 "," 93,633 "," 93,633 "," 93,633 "," 93,633 "," 93,633 "," 93,633 "," 93,633 "," 93,633 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
São Bernardo, 4," 41,990,000",,,,,," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 "," 810,067 ",,,,,,,,,,,,,,,,,,,,,,
SP - Morumbi, 5," 13,200,000"," 444,740 "," 444,740 "," 444,740 "," 444,740 "," 444,740 "," 444,740 "," 444,740 "," 444,740 "," 444,740 "," 444,740 "," 444,740 "," 444,740 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Mogi Mirim, 6," 36,360,000"," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 "," 428,881 ",,,,,,,,,,,,,,,,,,,,,,,,,,,
Piracicaba, 7," 54,730,000"," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 "," 785,881 ",,,,,,,,,,,,,,,,,,,,,,,,,,,
Campinas, 8," 29,850,000",,,,,,,,,,,,,,,,,," 911,261 "," 911,261 "," 911,261 "," 911,261 "," 911,261 "," 911,261 "," 911,261 "," 911,261 "," 911,261 "," 911,261 "," 911,261 "," 911,261 ",,,,,,,,,,,,,,,,,,,,,,
SP - Parada Inglesa, 9," 27,360,000",,,,,,,,,,,,,,,,,," 1,033,736 "," 1,033,736 "," 1,033,736 "," 1,033,736 "," 1,033,736 "," 1,033,736 "," 1,033,736 "," 1,033,736 "," 1,033,736 "," 1,033,736 "," 1,033,736 "," 1,033,736 ",,,,,,,,,,,,,,,,,,,,,,
Taquaral, 10," 31,360,000",,,,,,,,,,,,," 1,676,597 "," 1,676,597 "," 1,676,597 "," 1,676,597 "," 1,676,597 "," 1,676,597 "," 1,676,597 "," 1,676,597 "," 1,676,597 "," 1,676,597 "," 1,676,597 "," 1,676,597 ",,,,,,,,,,,,,,,,,,,,,,,,,,,
Leme, 11," 47,955,000"," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 "," 499,609 ",,,,,,,,,,,,,,,,,,,,,,,,,,,
Alumínio, 12," 22,620,000"," 547,679 "," 547,679 "," 547,679 "," 547,679 "," 547,679 "," 547,679 "," 547,679 "," 547,679 "," 547,679 "," 547,679 "," 547,679 "," 547,679 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Itapetininga, 13," 12,870,000"," 224,963 "," 224,963 "," 224,963 "," 224,963 "," 224,963 "," 224,963 "," 224,963 "," 224,963 "," 224,963 "," 224,963 "," 224,963 "," 224,963 ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fluxo de caixa mensal,," 190,647,731"," 4,501,842"," 4,501,842"," 4,501,842"," 4,501,842"," 4,501,842"," 5,311,909"," 5,311,909"," 5,311,909"," 5,311,909"," 5,311,909"," 5,311,909"," 5,311,909"," 5,677,491"," 5,677,491"," 5,677,491"," 5,677,491"," 5,677,491"," 7,622,487"," 7,622,487"," 7,622,487"," 7,622,487"," 7,622,487"," 7,622,487"," 7,622,487"," 4,231,520"," 4,231,520"," 4,231,520"," 4,231,520"," 4,231,520"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457"," 1,476,457",,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Fluxo de caixa acumulado,,," 4,501,842"," 9,003,684"," 13,505,527"," 18,007,369"," 22,509,211"," 27,821,120"," 33,133,028"," 38,444,937"," 43,756,846"," 49,068,754"," 54,380,663"," 59,692,572"," 65,370,063"," 71,047,554"," 76,725,044"," 82,402,535"," 88,080,026"," 95,702,513"," 103,325,001"," 110,947,488"," 118,569,976"," 126,192,463"," 133,814,950"," 141,437,438"," 145,668,958"," 149,900,478"," 154,131,999"," 158,363,519"," 162,595,040"," 164,071,497"," 165,547,955"," 167,024,412"," 168,500,870"," 169,977,327"," 171,453,785"," 172,930,242"," 174,406,699"," 175,883,157"," 177,359,614"," 178,836,072"," 180,312,529"," 181,788,987"," 183,265,444"," 184,741,902"," 186,218,359"," 187,694,816"," 189,171,274"," 190,647,731",,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,