Baixe o app para aproveitar ainda mais
Leia os materiais offline, sem usar a internet. Além de vários outros recursos!
planilha tais tutor corrigida.xlsx 112 (1)
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Plan1 Demonstração do Resultado do Exercício - DRE .......... JAN FEV MAR ABRIL MAI JUN JULH AGOS SETEM OUTU NOVEM DEZEM TOTAL Preço de vendas ... 550.00 550.00 550.00 550.00 550.00 550.00 550.00 550.00 550.00 550.00 550.00 550.00 Quantidade ... 1,500 1,500 1,500 1,750 1,750 1.750. 1,900 1,900 1,900 1,900 1,900 1,900 Rceita Bruta ... 825,000.00 825,000.00 825,000.00 962,500.00 962,500.00 962,500.00 1,045,000.00 1,045,000.00 1,045,000.00 1,045,000.00 1,045,000.00 1,045,000.00 11632500 ICMS 12.00% 99,000.00 99,000.00 99,000.00 115,500.00 115.500.00 115,500.00 125,400.00 125,400.00 125,400.00 125,400.00 125,400.00 125,400.00 1280400 PIS 1.65% 13,613.25 13,613.25 13,613.25 15,881.25 15,881.25 15,881.25 17,242.50 17,242.50 17,242.50 17,242.50 17,242.50 17,242.50 191938.5 COFINS 7.60% 62,700.00 62,700.00 62,700.00 73.150.00 73,150.00 73,150.00 79,420.00 79,420.00 79,420.00 79,420.00 79,420.00 79,420.00 810920 Receita Liquida ... 649,687.75 649,687.75 649,687.75 757,968.75 757,968.75 757,967.75 822,937.50 822,937.50 822,937.50 822.937.50 822,937.50 822,937.50 8337656 CPV 280.00 420.000.00 420,000.00 420,000.00 490,000.00 490,000.00 490,000.00 532,000.00 532,000.00 532,000.00 532,000.00 532,000.00 532,000.00 5502000 Lucro Bruto ... 229,687.25 229,687.25 229,687.25 267,968.75 267,968.75 267,968.75 290.937.50 290,937.50 290,937.50 290,937.50 290,937.50 290,937.50 2947655.5 Água - luz - telefone ... 12,900.00 12,900.00 12,900.00 12,900.00 12,900.00 12,900.00 12,900.00 12,900.00 12,900.00 12,900.00 12,900.00 12,900.00 154800 Prolabore ... 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 192000 Salário + encargos ... 131,350.00 131,350.00 131,350.00 131,350.00 131,350.00 131,350.00 131,350.00 131,350.00 132,350 131,350.00 131,350.00 131,350.00 1577200 Comissão 3% 24,750.00 24,750.00 24,750,00 28,875.00 28,875.00 28,875.00 31,350.00 31,350.00 31,350.00 31,350.00 31,350.00 31,350.00 324225 Transporte ... 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 261600 Marketig ... 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 108000 Depreciação ... 7,600.00 7,600.00 7,600.00 7,600.00 7,600.00 7,600.00 7,600.00 7,600.00 7,600.00 7,600.00 7,600.00 7,600.00 91200 Lucro Operacional ... 6,287.75 6,287.75 6,287.75 40,443.75 40,443.75 40,443.75 60,937.50 60,937.50 60,937.50 60,937.50 60,937.50 60,937.50 505819.5 IR 15.00% 943.13 943.13 943.13 6.066.57 6.066.57 6.066.57 9,140.63 9,140.63 9,140.63 9,140.63 9,140.63 9,140.63 57673.17 CSLL 9.00% 565.85 565.85 565.85 3,639.94 3,639.94 3,639.94 5,484.38 5,484.38 5,484.38 5,484.38 5,484.38 5,484.38 45523.65 Lucro Liquido ... 4,778.50 4,778.50 4,778.50 30,737.24 30,737.24 30,737.24 46,312.49 46,312.49 46,312.49 46,312.49 46,312.49 46,312.49 384422.16 Contas a Receber Valor mês 1 mês 2 mês 3 mês 4 mês 5 mês 6 mês 7 mês 8 mês 9 mês 10 mês 11 mês 12 mês 1 * 825,000.00 * 275,000.00 * 275,000.00 * 275,000.00 mês 2 * 825,000.00 * 275,000.00 * 275,000.00 * 275,000.00 mês 3 * 825,000.00 * 275,000.00 * 275,000.00 * 275,000.00 mês 4 * 962,500.00 * 320,833.33 * 320,833.33 * 320,833.33 mês 5 * 962,500.00 * 320,833.33 * 320,833.33 * 320,833.33 mês 6 * 962,500.00 * 320,833.33 * 320,833.33 * 320,833.33 mês 7 * 1,045,000.00 * 348,333.33 * 348,333.33 * 348,333.33 mês 8 * 1,045,000.00 * 348,333.33 * 348,333.33 * 348,333.33 mês 9 * 1,045,000.00 * 348,333.33 * 348,333.33 * 348,333.33 mês 10 * 1,045,000.00 * 348,333.33 * 348,333.33 * 348,333.33 mês 11 * 1,045,000.00 * 348,333.33 * 348,333.33 mês 12 * 1,045,000.00 * 348,333.33 Total * 275,000.00 * 550,000.00 * 825,000.00 * 870,833.33 * 916,666.66 * 962,499.99 * 989,999.99 * 1,017,499.99 1.044,999,99 * 1,044,999.99 * 1,044,999.99 * 1,044,999.99 Fornecedores Valor mês 1 mês 2 mês 3 mês 4 mês 5 mês 6 mês 7 mês 8 mês 9 mês 10 mês 11 mês 12 mês 1 420.000.00 210.00,00 * 210,000.00 mês 2 * 420,000.00 * 210,000.00 * 210,000.00 mês 3 * 420,000.00 * 210,000.00 * 210,000.00 mês 4 * 490,000.00 * 245,000.00 * 245,000.00 mês 5 * 490,000.00 * 245,000.00 * 245,000.00 mês 6 * 490,000.00 * 245,000.00 * 245,000.00 mês 7 * 532,000.00 * 266,000.00 * 266,000.00 mês 8 * 532,000.00 * 266,000.00 * 266,000.00 mês 9 * 532,000.00 * 266,000.00 * 266,000.00 mês 10 * 532,000.00 * 266,000.00 * 266,000.00 mês 11 * 532,000.00 * 266,000.00 * 266,000.00 mês 12 * 532,000.00 * 266,000.00 Total 0.0 * 420,000.00 * 420,000.00 * 455,000.00 * 490,000.00 * 490,000.00 * 511,000.00 * 532,000.00 * 532,000.00 * 532,000.00 * 532,000.00 * 532,000.00 Fluxo de Caixa ................... ... Jan Fev Mar Abr Mai Jun Julh Agos Setem Outu Novem Dezem Saldo Inicial ... ... 476,200.00 175,578.52 149,957.04 135,168.86 79,620.76 69,958.00 327,380.49 346,302.98 392,725.48 984,048.48 1,030,470.98 Entradas com Vendas ... 275,000.00 550,000.00 825,000.00 870,833.33 916,666.66 962,500.00 989,999.99 1,017,499.99 1,045,000.00 1,045,000.00 1,045,000.00 1,045,000.00 Capital Integralizado ... 480,000.00 - - - - - - - - - - Saldo em Caixa ... 755,000.00 1,026,200.00 1,000,578.52 1,020,790.37 1,051,835.52 1,042,120.76 1,059,957.99 1,344,880.48 1,391,302.98 1,437,725.48 2,029,048.48 2,075,470.98 Fornecedores - CPV ... 210,000.00 420,000.00 420,000.00 455,000.00 490,000.00 490,000.00 266,000.00 532,000.00 532,000.00 532.000.00 532,000 532,000.00 Água - Luz - telefone ... - 12,900.00 12,900 12,900.00 12,900.00 12,900.00 12,900.00 12,900.00 12,900.00 12.900.00 12,900.00 12,900.00 Prolabore ... - 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 Sálario + Encargos ... - 131,350.00 131,350.00 131,350.00 131,350.00 131,350.00 131,350.00 131,350.00 131,350.00 131,350.00 131,350.00 131.350.00 Transporte ... 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 21,800.00 Marketing ... 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 IRPJ 15% 943.13 943.13 943.13 6,066.57 6,066.57 15,715.00 15,715.00 15,715.00 15,715.00 15,715.00 15,715.00 CSLL 9% 565.85 565.85 565.88 3,639.94 3,639.94 15,150.00 15,150.00 15,150.00 15,150.00 15,150.00 15,150.00 Comissão 3% 24,750.00 24,750.00 24,750.00 28,875.00 28,875.00 31,350.00 31,350.00 31,350.00 31,350.00 31,350.00 31,350.00 ICMS 12% 99,000.00 99,000.00 99,000.00 125,500.00 125,500.00 99,000.00 99,000.00 99,000.00 99,000.00 99,000.00 99,000.00 PIS 1.65% 13,612.50 13,612.50 13,612.50 15,881.25 15,881.25 13,612.50 13,612.50 13,612.50 13,612.00 13,612.50 13,612.50 COFINS 7.60% 62,700.00 62,700.00 62,700.00 73,150.00 73,150.00 62,700.00 62,700.00 62,700.00 62,700.00 62,700.00 62,700.00 Aquisição de Maquinas e Equipamentos ... 38,000.00 38,000.00 38,000.00 38,000.00 38,000.00 38,000.00 38,000.00 38,000.00 38,000.00 38,000.00 38,000.00 38,000.00 Total de Saídas ... 278,800.00 850,621.48 850,621.48 885,621.51 972,162.76 972,162.76 732,577.50 998,577.50 998,577.50 453,677.00 998,577.50 867,227.50 Fluxo de caixa Livre ... -3,800.00 -300,621.48 -25,621.48 -14,788.18 -55,514.10 -9,662.76 257,422.49 18,922.49 46,422.50 591,323.00 46,422.50 177,772.50 Saldo final de caixa ... 476,200.00 175,578.52 149,957.04 135,168.86 79,620.76 69,958.00 327,380.49 346,302.98 392,725.48 984,048.48 1,030,470.98 1,208,243.48 Orçamento de vendas 1 Trimestre 2 Trimestre 3 Trimestre Jan Fev Mar TOTAL Abr Mai Jun TOTAL Agos Setem Outu TOTAL Previsão de Vendas(unidades) .... 1,500 1500 1,500 4,500.00 1,750 1,750 1,750 5,250.00 1,900 1,900 1,900 5,700 Preço (unitário) .... 550.00 550.00 550.00 .... 550.00 550.00 550.00 .... 550.00 550.00 550.00 ..... - Total de Vendas - R$ (Receita Bruta) .... 825,000.00 825,000.00 825,000.00 2,475,000.00 962,500.00 962,500.00 962,500.00 2,887,500.00 1,045,000.00 1,045,000.00 1,045,000.00 3,135,000.00 Impostos 21.30% 175,725.00 175,725.00 175,725.00 527,175.00 205,012.50 205,012.50 205,012.50 615,037.50 222,585.00 222,585.00 222,585.00 667,755.00 Receita Liquida .... 649,275.00 649,275.00 649,275.00 1,947,825.00 757,487.50 757,487.50 757,487.50 2,272,462.50 822,415.00 822,415.00 822,415.00 2,467,245.00 Orçamento de Produção 1 Trimestre 2 Trimestre 3 Trimestre Jan Fev Mar TOTAL Abri Mai Jun TOTAL Julh Agos Setem TOTAL Previsão de Venda (unidades) .... 1,500 1,500 1,500 ..... 1,750 1,750 1,750 .... 1,900 1,900 1,900 .... (+) Estoque final .... 2,250 2,250 2,250 ..... 2,625 2,625 2,625 .... 2,850 2,850 2,850 .... Total Prev. Necessária .... 3,750 3,750 3,750 ..... 4,375 4,375 4,375 .... 4,750 4,750 4,750 .... (-) Estoque inicial .... 0 2,250 2,250 ..... 2,250 2,625 2,625 .... 2,625 2,850 2,850 .... (=) Previsão de Produção .... 3,750 1,500 1,500 6,750 2,125 1,750 1,750 5,625 2,125 1,900 1,900 5,925 Mercado De Capitais LPA ( Lucro por Ação) R$ 192.21 Payout ( Pagamento) 6% Dividendo Yield ( Recebimento de Dividendos) 60% Índice P/L (Tempo de retorno do investimento) 0.1058731642 Plan2 Página3
Compartilhar
Continue navegando
Materiais relacionados
100 pág.
24 pág.
Perguntas relacionadas
Compartilhar