Docsity
Docsity

Prepare-se para as provas
Prepare-se para as provas

Estude fácil! Tem muito documento disponível na Docsity


Ganhe pontos para baixar
Ganhe pontos para baixar

Ganhe pontos ajudando outros esrudantes ou compre um plano Premium


Guias e Dicas
Guias e Dicas


fluxo de caixa modelo, Esquemas de Matemática Financeira

modelo fluxo de caixa diario, semanal e mensal

Tipologia: Esquemas

2019

Compartilhado em 11/10/2019

aline-bezerra-22
aline-bezerra-22 🇧🇷

1 documento

1 / 20

Toggle sidebar

Esta página não é visível na pré-visualização

Não perca as partes importantes!

bg1
pz7x24-cash_flow.xlsx - Set19 - 10/11/2019 - 18:13:21
MANZONI INDUSTRIAL LTDA
Fluxo de Caixa Diário
Setembro 2019
Week 36 Week 37 Week 38 Week 39
TOTAL MENSALR$'000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
P P P P P P P P P P P P P P P P P P P P
Cash In
Customers 0
Credit card 0
Cash sales 0
Others 0
Total Cash In 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cash Out
Local suppliers 0
Import costs 0
Freight 0
Advance payments 0
Payroll (Labor+SG&A) 0
Building & Occupancy 0
Utilities 0
Services 0
Other net expenses 0
Taxes 0
Other Cash Out 0
Total Cash Out 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Operational Cash Flow 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Non Operational CF : 0
Non operacional income 0
Capital increase 0
Bank loan 0
Financial income 0
Capex 0
Interest 0
Principal Amortization 0
Tax Debts 0
Other interest / penalties 0
Bank charges 0
IOF 0
Income Tax / CSLL 0
Net Cash Flow 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Net Cash Position (660)
Bank Accounts
Bank Investiments
Working capital loans
Leasing contracts
Finimp
Net Cash Position (NCP) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Bank investiment (inflow) 0
Bank investiment (outflow) 0
Guarantee accounts
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14

Pré-visualização parcial do texto

Baixe fluxo de caixa modelo e outras Esquemas em PDF para Matemática Financeira, somente na Docsity!

pz7x24-cash_flow.xlsx - Set19 - 10/11/2019 - 18:13:

MANZONI INDUSTRIAL LTDA

Fluxo de Caixa Diário

Setembro 2019

Week 36 Week 37 Week 38 Week 39

R$'000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 TOTAL MENSAL

P P P P P P P P P P P P P P P P P P P P

Cash In

Customers 0

Credit card 0

Cash sales 0

Others 0

Total Cash In 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Cash Out

Local suppliers 0

Import costs 0

Freight 0

Advance payments 0

Payroll (Labor+SG&A) 0

Building & Occupancy 0

Utilities 0

Services 0

Other net expenses 0

Taxes 0

Other Cash Out 0

Total Cash Out 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Operational Cash Flow 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Non Operational CF : 0

Non operacional income 0

Capital increase 0

Bank loan 0

Financial income 0

Capex 0

Interest 0

Principal Amortization 0

Tax Debts 0

Other interest / penalties 0

Bank charges 0

IOF 0

Income Tax / CSLL 0

Net Cash Flow 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Net Cash Position (660)

Bank Accounts

Bank Investiments

Working capital loans

Leasing contracts

Finimp

Net Cash Position (NCP) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Bank investiment (inflow) 0

Bank investiment (outflow) 0

Guarantee accounts

MANZONI INDUSTRIAL LTDA Fluxo de Caixa Diário Outubro 2019 R$'000 1 2 Week 40 3 4 5 6 7 8 9 Week 41 10 11 12 13 14 15 16 Week 42 17 18 19 20 21 22 23 Week 43 24 25 26 27 28 29 Week 44 30 31 MonthTOTAL Previsão Real X Previsto Bank accounts 0 P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P^ P Bank investiments 0 0 Cash In Customers 0 0 Credit card Cash sales (^00 ) Total Cash In^ Others^ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 0 00 Cash Out Local suppliers 0 0 Import costs Freight (^00 ) Advance payments Payroll (Labor+SG&A) (^00 ) Building & Occupancy Utilities (^00 ) Services Other net expenses (^00 ) Taxes Other Cash Out (^00 ) Total Cash Out 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Operational Cash Flow 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Non Operational CF : Non operacional income 0 0 Capital increase Bank loan 00 (^00) Financial income Capex 00 (^00) Interest Principal Amortization (^) 00 (^00) Tax Debts Other interest / penalties 00 (^00) Bank charges IOF 00 (^00) Net Cash Flow^ Income Tax / CSLL^ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 0^0 0 Net Cash Position Bank Accounts (^) 0 Bank Investiments Working capital loans Leasing contracts Finimp Net Cash Position (NCP) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Bank investiment (inflow) Bank investiment (outflow) (^00) Guarantee accounts 100200 300400 500600 700800 1,000 900 Net Cash Position (NCP)

MANZONI INDUSTRIAL LTDA Fluxo de Caixa Diário Dezembro 2019 Week 49 R$'000 1 2 3 4 5 6 7 8 P P P P P Bank accounts ( as 28.02.2014) 0 Bank investiments ( as 28.02.2014) 0 Cash In Customers Credit card Cash sales Others Total Cash In 0 0 0 0 0 0 0 0 Cash Out Local suppliers Import costs Freight Advance payments Payroll (Labor+SG&A) Building & Occupancy Utilities Services Other net expenses Taxes Other Cash Out Total Cash Out 0 0 0 0 0 0 0 0 Operational Cash Flow (^0 0 0 0 0 0 0 ) Non Operational CF : Non operacional income Capital increase Bank loan Financial income Capex Interest Principal Amortization Tax Debts Other interest / penalties Bank charges IOF Income Tax / CSLL

Net Cash Flow 0 0 0 0 0 0 0 0 Net Cash Position Bank Accounts Bank Investiments Working capital loans Leasing contracts Finimp Net Cash Position (NCP) (^0 0 0 0 0 0 ) Bank investiment (inflow) Bank investiment (outflow) Guarantee accounts (^0 0 0 0 0 0 ) 0 100 200 300 400 500 600 700 800 900 1,

Net Cash Position (NCP)

Week 52 21 22 23 24 25 26 27 28 29 30 31 P P P P P P 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

TOTAL Month Previsão Real X Previsto 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0

MANZONI IND Fluxo de caixa Atual Atual Atual Atual Atual Atual R$'000 Jan Fev Mar Abr Mai Jun Beggining Balance 0 0 0 0 0 0 Cash In Customers Credit card Cash sales Others Total Cash In 0 0 0 0 0 0 Cash Out Local suppliers Import costs Freight Advance payments Payroll (Labor+SG&A) Building & Occupancy Utilities Services Other net expenses Taxes Other Cash Out Total Cash Out 0 0 0 0 0 0 Operational Cash Flow 0 0 0 0 0 0 Non Operational CF Capital increase Bank loan Financial income Capex Interest Principal Amortization Tax Debts Other interest / penalties Bank charges IOF Income Tax / CSLL Net Cash Flow 0 0 0 0 0 0 Ending Balance (^0 0 0 0 0 ) Net Cash Position Bank Accounts Bank Investiments Working capital loans Leasing contracts

Finimp

Net Cash Position (NCP) 0 0 0 0 0

Jan Fev Mar Abr Mai Jun Jul Ago

Net Cash Position (NCP)

Cash In

Cash Out

MANZONI INDUSTRIAL LTDA Fluxo de caixa mensal 2019 Atual Atual Budget Total Jul Ago Set Out Nov Dez 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Jul Ago Set Out Nov Dez

on (NCP)

t

Previsão Real X Previsto 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0