{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Fluxo de Caixa"],"not_rendered":{"charts":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Fluxo de Caixa","index":0,"n_rows":71,"n_cols":6,"rows_kept":71}
[null,"Fluxo de Caixa "]
[null,"(PREENCHER APENAS AS CÉLULAS A AMARELO)"]
[]
[null,"RECEITAS",2021,{"$f":"C4+1","v":2022},{"$f":"D4+1","v":2023},{"$f":"E4+1","v":2024}]
[null,"Produto/Serviço 1"]
[null,"Preço",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"v":100,"d":"100 €"}]
[null,"Quantidade",1000,2000,2500,3000]
[null,"Sub-total",{"$f":"C6*C7","v":{"v":100000,"d":"100,000 €"}},{"$f":"D6*D7","v":{"v":200000,"d":"200,000 €"}},{"$f":"E6*E7","v":{"v":250000,"d":"250,000 €"}},{"$f":"F6*F7","v":{"v":300000,"d":"300,000 €"}}]
[null,"Produto/Serviço 2"]
[null,"Preço",{"v":1000,"d":"1,000 €"},{"v":1000,"d":"1,000 €"},{"v":1000,"d":"1,000 €"},{"v":1000,"d":"1,000 €"}]
[null,"Quantidade",50,100,200,350]
[null,"Sub-total",{"$f":"C10*C11","v":{"v":50000,"d":"50,000 €"}},{"$f":"D10*D11","v":{"v":100000,"d":"100,000 €"}},{"$f":"E10*E11","v":{"v":200000,"d":"200,000 €"}},{"$f":"F10*F11","v":{"v":350000,"d":"350,000 €"}}]
[null,"TOTAL RECEITAS",{"$f":"C12+C8","v":{"v":150000,"d":"150,000 €"}},{"$f":"D12+D8","v":{"v":300000,"d":"300,000 €"}},{"v":450000,"d":"450,000 €"},{"v":650000,"d":"650,000 €"}]
[]
[null,"CUSTO DAS VENDAS (CMVC)",2021,{"$f":"C15+1","v":2022},{"$f":"D15+1","v":2023},{"$f":"E15+1","v":2024}]
[null,{"$f":"B5","v":"Produto/Serviço 1"}]
[null,"Custo das Vendas  (% das receitas totais)",{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"}]
[null,"Custos Distribuição /Comissões (  % das receitas totais)",{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"}]
[null,"Royalties  (% das receitas para licenciamento patentes)",{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"}]
[null,"Sub-Total",{"$f":"(C8*C17)+(C8*C18)+(C8*C19)","v":{"v":60000,"d":"60,000 €"}},{"$f":"(D8*D17)+(D8*D18)+(D8*D19)","v":{"v":120000,"d":"120,000 €"}},{"$f":"(E8*E17)+(E8*E18)+(E8*E19)","v":{"v":150000,"d":"150,000 €"}},{"$f":"(F8*F17)+(F8*F18)+(F8*F19)","v":{"v":180000,"d":"180,000 €"}}]
[null,{"$f":"B9","v":"Produto/Serviço 2"}]
[null,"Custo das Vendas  (% das receitas totais)",{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"}]
[null,"Custos Distribuição /Comissões (  % das receitas totais)",{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"}]
[null,"Royalties  (% das receitas para licenciamento patentes)",{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"}]
[null,"Sub-Total",{"$f":"(C24*C12)+(C23*C12)+(C22*C12)","v":{"v":30000,"d":"30,000 €"}},{"$f":"(D24*D12)+(D23*D12)+(D22*D12)","v":{"v":60000,"d":"60,000 €"}},{"$f":"(E24*E12)+(E23*E12)+(E22*E12)","v":{"v":120000,"d":"120,000 €"}},{"$f":"(F24*F12)+(F23*F12)+(F22*F12)","v":{"v":210000,"d":"210,000 €"}}]
[null,"TOTAL CUSTO DAS VENDAS",{"$f":"C25+C20","v":{"v":90000,"d":"90,000 €"}},{"$f":"D25+D20","v":{"v":180000,"d":"180,000 €"}},{"v":270000,"d":"270,000 €"},{"v":390000,"d":"390,000 €"}]
[]
[null,"CUSTO SERVIÇOS EXTERNOS ",2021,{"$f":"C28+1","v":2022},{"$f":"D28+1","v":2023},{"$f":"E28+1","v":2024}]
[null,"Aluguer Escritório (sugestão: 500€/mês)",{"v":6000,"d":"6,000 €"},{"v":6000,"d":"6,000 €"},{"v":6000,"d":"6,000 €"},{"v":6000,"d":"6,000 €"}]
[null,"Aluguer Laboratório se necessário (sugestão: 1000 euros/mês)",{"v":12000,"d":"12,000 €"},{"v":12000,"d":"12,000 €"},{"v":12000,"d":"12,000 €"},{"v":12000,"d":"12,000 €"}]
[null,"Electricidade, Água e Outro (sugestão: 100€/mês)",{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"}]
[null,"Contabilista (sugestão: 500€/mês)",{"v":6000,"d":"6,000 €"},{"v":6000,"d":"6,000 €"},{"v":6000,"d":"6,000 €"},{"v":6000,"d":"6,000 €"}]
[null,"Telecomunicações (sugestão: 100€/mês)",{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"}]
[null,"Marketing (sugestão: 500€/mês)",{"v":6000,"d":"6,000 €"},{"v":6000,"d":"6,000 €"},{"v":6000,"d":"6,000 €"},{"v":6000,"d":"6,000 €"}]
[null,"Outros..",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[null,"TOTAL CUSTO SERVIÇOS EXTERNOS",{"$f":"SUM(C29:C35)","v":{"v":32400,"d":"32,400 €"}},{"$f":"SUM(D29:D35)","v":{"v":32400,"d":"32,400 €"}},{"v":32400,"d":"32,400 €"},{"v":32400,"d":"32,400 €"}]
[]
[null,"CUSTO PESSOAL",2021,{"$f":"C38+1","v":2022},{"$f":"D38+1","v":2023},{"$f":"E38+1","v":2024}]
[null,"CEO - Gestor",1,1,1,1]
[null,"Salário Mensal  (sugestão: 1.200€/mês)",{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"}]
[null,"Total Custo Empresa",{"$f":"C39*(C40*12*1.8)","v":{"v":25920,"d":"25,920 €"}},{"$f":"D39*(D40*12*1.8)","v":{"v":25920,"d":"25,920 €"}},{"v":25920,"d":"25,920 €"},{"v":25920,"d":"25,920 €"}]
[null,"Marketing and Sales Manager",1,1,1,1]
[null,"Salário Mensal   (sugestão: 1.500€/mês)",{"v":1500,"d":"1,500 €"},{"v":1500,"d":"1,500 €"},{"v":1500,"d":"1,500 €"},{"v":1500,"d":"1,500 €"}]
[null,"Total Custo Empresa",{"$f":"C42*(C43*12*1.8)","v":{"v":32400,"d":"32,400 €"}},{"$f":"D42*(D43*12*1.8)","v":{"v":32400,"d":"32,400 €"}},{"v":32400,"d":"32,400 €"},{"v":32400,"d":"32,400 €"}]
[null,"Creative Director",0,0,1,1]
[null,"Salário Mensal   (sugestão: 1.200€/mês)",{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"}]
[null,"Total Custo Empresa",{"$f":"C45*(C46*12*1.8)","v":{"v":0,"d":"0 €"}},{"$f":"D45*(D46*12*1.8)","v":{"v":0,"d":"0 €"}},{"v":25920,"d":"25,920 €"},{"v":25920,"d":"25,920 €"}]
[null,"Accountant",0,1,1,1]
[null,"Salário Mensal   (sugestão: 1.000€/mês)",{"v":1000,"d":"1,000 €"},{"v":1000,"d":"1,000 €"},{"v":1000,"d":"1,000 €"},{"v":1000,"d":"1,000 €"}]
[null,"Total Custo Empresa",{"$f":"C48*(C49*12*1.8)","v":{"v":0,"d":"0 €"}},{"$f":"D48*(D49*12*1.8)","v":{"v":21600,"d":"21,600 €"}},{"v":21600,"d":"21,600 €"},{"v":21600,"d":"21,600 €"}]
[null,"Technology and Product Development",0,0,1,1]
[null,"Salário Mensal   (sugestão: 1.100€/mês)",{"v":1100,"d":"1,100 €"},{"v":1100,"d":"1,100 €"},{"v":1100,"d":"1,100 €"},{"v":1100,"d":"1,100 €"}]
[null,"Total Custo Empresa",{"$f":"C51*(C52*12*1.8)","v":{"v":0,"d":"0 €"}},{"$f":"D51*(D52*12*1.8)","v":{"v":0,"d":"0 €"}},{"$f":"E51*(E52*12*1.8)","v":{"v":23760,"d":"23,760 €"}},{"$f":"F51*(F52*12*1.8)","v":{"v":23760,"d":"23,760 €"}}]
[null,"TOTAL CUSTO PESSOAL",{"$f":"C41+C44+C47+C50+C53","v":{"v":58320,"d":"58,320 €"}},{"$f":"D41+D44+D47+D50+D53","v":{"v":79920,"d":"79,920 €"}},{"$f":"E41+E44+E47+E50+E53","v":{"v":129600,"d":"129,600 €"}},{"$f":"F41+F44+F47+F50+F53","v":{"v":129600,"d":"129,600 €"}}]
[]
[null,"INVESTIMENTO",2021,{"$f":"C56+1","v":2022},{"$f":"D56+1","v":2023},{"$f":"E56+1","v":2024}]
[null,"Activos Fixos (Maquinas / Computadores / Etç)",{"v":5000,"d":"5,000 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[null,"Desenvolvimento (investigação, plataformas, produtos)",{"v":35000,"d":"35,000 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[null,"TOTAL INVESTIMENTOS",{"$f":"SUM(C57+C58)","v":{"v":40000,"d":"40,000 €"}},{"$f":"SUM(D57+D58)","v":{"v":0,"d":"0 €"}},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[]
[null,"FUNDO DE MANEIO",2021,{"$f":"C61+1","v":2022},{"$f":"D61+1","v":2023},{"$f":"E61+1","v":2024}]
[null,"Necessidades de Fundo ",{"$f":"0.02*C13","v":{"v":3000,"d":"3,000 €"}},{"$f":"0.02*D13","v":{"v":6000,"d":"6,000 €"}},{"$f":"0.02*E13","v":{"v":9000,"d":"9,000 €"}},{"$f":"0.02*F13","v":{"v":13000,"d":"13,000 €"}}]
[]
[]
[null,null,2021,{"$f":"C65+1","v":2022},{"$f":"D65+1","v":2023},{"$f":"E65+1","v":2024}]
[null,"RECEITAS TOTAIS",{"$f":"C13","v":{"v":150000,"d":"150,000 €"}},{"$f":"D13","v":{"v":300000,"d":"300,000 €"}},{"v":450000,"d":"450,000 €"},{"v":650000,"d":"650,000 €"}]
[null,"CUSTOS TOTAIS",{"$f":"C26+C36+C54","v":{"v":180720,"d":"180,720 €"}},{"$f":"D59+D54+D36+D26","v":{"v":292320,"d":"292,320 €"}},{"$f":"E59+E54+E36+E26","v":{"v":432000,"d":"432,000 €"}},{"$f":"F59+F54+F36+F26","v":{"v":552000,"d":"552,000 €"}}]
[null,"FLUXO DE CAIXA OPERACIONAL",{"$f":"C66-C67","v":{"v":-30720,"d":"-30,720 €"}},{"$f":"D66-D67","v":{"v":7680,"d":"7,680 €"}},{"v":18000,"d":"18,000 €"},{"v":98000,"d":"98,000 €"}]
[null,"INVESTIMENTO E FUNDO DE MANEIO",{"$f":"C59+C62","v":{"v":43000,"d":"43,000 €"}},{"$f":"D59+D62","v":{"v":6000,"d":"6,000 €"}},{"v":9000,"d":"9,000 €"},{"v":13000,"d":"13,000 €"}]
[null,"FLUXO DE CAIXA ",{"$f":"C68-C69","v":{"v":-73720,"d":"-73,720 €"}},{"$f":"D68-D69","v":{"v":1680,"d":"1,680 €"}},{"v":9000,"d":"9,000 €"},{"v":85000,"d":"85,000 €"}]
[null,"FLUXO DE CAIXA ACUMULADO",{"$f":"C70","v":{"v":-73720,"d":"-73,720 €"}},{"$f":"C71+D70","v":{"v":-72040,"d":"-72,040 €"}},{"$f":"D71+E70","v":{"v":-63040,"d":"-63,040 €"}},{"$f":"E71+F70","v":{"v":21960,"d":"21,960 €"}}]