Gerador de Projeção de Fluxo de Caixa
PROPrevisão de cash flow mensal para PMEs com otimização DSO/DPO, análise de padrões sazonais, deteção de risco de shortfall e planeamento de cenários para visibilidade 3-12 meses.
Exemplo de Uso
Preciso projetar meu fluxo de caixa pros próximos 6 meses. Me ajuda a criar cenários otimista e pessimista.
Como Usar Este Skill
Copiar o skill usando o botão acima
Colar no seu assistente de IA (Claude, ChatGPT, etc.)
Preencha suas informações abaixo (opcional) e copie para incluir com seu prompt
Envie e comece a conversar com sua IA
Personalização Sugerida
| Descrição | Padrão | Seu Valor |
|---|---|---|
| Number of months to forecast (3, 6, or 12) | 12 months | |
| Target minimum cash balance to maintain | $50,000 | |
| Days Sales Outstanding - average collection period | 45 days | |
| Days Payable Outstanding - average payment period | 30 days | |
| Total fixed operating costs per month | $50,000 | |
| Expected monthly revenue growth rate | 5% |
O que você vai obter
- 12-month rolling cash flow projection with monthly closing balances
- Shortfall risk alerts with timing, magnitude, and root cause analysis
- Working capital optimization recommendations (DSO/DPO improvements)
- Scenario analysis comparing base, upside, downside, and stress cases
- Actionable mitigation strategies when shortfalls are detected
- Monthly update process for keeping forecasts current
Business vs. Personal Cash Flow
This skill is designed for SMB businesses ($1M-$100M revenue) with:
- Accounts receivable and customer payment tracking
- Supplier relationships and payment terms
- Seasonal revenue patterns
- Working capital optimization needs
For personal cash flow tracking, see the related Cash Flow Projector skill.
Fontes de Pesquisa
Este skill foi criado usando pesquisa destas fontes confiáveis:
- Free Financial Projection and Forecasting Templates - Smartsheet Professional templates and methodology for financial projections including cash flow forecasting.
- 12 Month Cash Flow Statement Template - SCORE SBA partner resource for cash flow planning with downloadable templates.
- Cash Flow Projection - The Complete Guide - HighRadius Comprehensive guide covering DSO optimization, working capital management, and forecasting best practices.
- How to Create and Use a Cash-Flow Forecast Template - American Express American Express guide to cash flow forecasting for small businesses.
- Cash Conversion Cycle Explained - Investopedia Detailed explanation of CCC, DSO, DPO, and DIO metrics with calculation examples.
- Working Capital Management - CFI Corporate Finance Institute guide to optimizing working capital and cash flow.
- Days Sales Outstanding Best Practices - Billtrust Industry benchmarks and strategies for improving DSO and accelerating collections.