Generador de Proyección de Flujo de Caja
PROPronostica flujo de caja mensual para PYMEs con optimización DSO/DPO, análisis de patrones estacionales, detección de riesgo de shortfall y planificación de escenarios para visibilidad de 3-12 meses.
Ejemplo de Uso
Aquí están mis ingresos y gastos de los últimos 6 meses. Proyecta mi flujo de caja para los próximos 6 meses e identifica posibles problemas de liquidez.
Prompt del Skill
Este skill funciona mejor cuando lo copias desde findskill.ai — incluye variables y formato que podrían no transferirse correctamente desde otros sitios.
Cómo Usar Este Skill
1
Copiar el skill usando el botón de arriba
2
Pegar en tu asistente de IA (Claude, ChatGPT, etc.)
3
Completa tus datos abajo (opcional) y copia para incluir con tu prompt
4
Envía y comienza a chatear con tu IA
Personalización Sugerida
| Descripción | Por defecto | Tu 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% |
What You’ll Get
- 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.
Fuentes de Investigación
Este skill fue creado usando investigación de estas fuentes autorizadas:
- 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.