100 Best Gemini Cash Flow Forecasting Prompts for Insurance Agents
These Gemini prompts help with cash flow forecasting for insurance agents using practical instructions, clear constraints, and reusable output formats.
Best For
Insurance agency owners, financial managers, and insurance agents who build and rely on cash flow forecasts.
Prompt Use Cases
- Cash flow forecasting
- Scenario planning
- Budgeting
- Financial risk assessment
- Commission-related cash flow analysis
- Agency profitability modeling
- Forecast dashboards
- What-if analysis
- Operational planning
- Liquidity planning
Direct Answer
The best Gemini prompts for cash flow forecasting for insurance agents are tailored prompts that guide Gemini to produce accurate, scenario-aware forecasts for premiums, commissions, claims, and expenses. They emphasize baselines, seasonality, liquidity, and risk signals, while providing clear outputs and formats. Note that results depend on data quality and specific assumptions used in the prompts.
Introduction
This page is a practical prompt library focused on cash flow forecasting for insurance agents. It helps finance teams, agency managers, and analysts generate precise cash flow projections, detect liquidity risks, and plan for growth.
Whether you manage a small agency or a large firm, these prompts are designed to be copy-paste ready and immediately actionable to improve forecasting accuracy and decision speed.
How to Use These Gemini Prompts
- Replace placeholders like [agency], [data], [constraints], [tone], and [format] with your real values before running the prompt.
- Add constraints to reflect your regulatory requirements, internal policies, and risk thresholds.
- Request outputs in your preferred format (CSV, JSON, or tables) and include summaries for quick review.
- Verify outputs by comparing forecasted vs actual cash movements over the last 12 to 24 months and adjust inputs accordingly.
- Combine multiple prompts to create a forecasting workflow that covers revenue, expenses, and liquidity in one run.
100 Best Gemini Cash Flow Forecasting Prompts for Insurance Agents
- Forecast baseline revenue: You are a financial analyst for an insurance agency. Role: Gemini AI assistant. Task: Produce a baseline 12-month cash flow forecast. Context: Use last 24 months of gross written premiums, commissions, renewals, and claims payout trends. Output: a month-by-month cash balance table with beginning balance, cash inflows, cash outflows, net cash flow, and ending balance. Constraints: assume no major one-time events, adjust for seasonality, consider reserve requirements. Deliver as: CSV-style rows with headers: Month, Beginning Balance, Inflows, Outflows, Net Cash, Ending Balance.
- Model renewal cash inflows: You are a forecasting specialist for an insurance agency. Role: Gemini AI consultant. Task: Forecast monthly renewal cash inflows for the next year. Context: Use historical renewal rates by policy type and client aging. Output: table with month, policy type, renewal count, renewal amount, expected churn adjustment. Constraints: include best-case, base-case, and worst-case scenarios. Format: JSON array of objects.
- Claims payout projection: Role: Insurance finance advisor. Task: Project monthly claims payouts for the next 12 months. Context: Include paid, reserved, and incurred-but-not-reported (IBNR) amounts by line of business. Output: stacked bar style data with lines for paid, reserved, IBNR. Constraints: seasonality adjustments and reserve adequacy flags. Format: YAML-like blocks per month.
- Expense forecast by category: Role: Finance planner. Task: Break down fixed and variable expenses for the agency for the next 12 months. Context: Include commissions, staff salaries, marketing, IT, and overhead. Output: per-month expense table with category and variance vs last year. Constraints: highlight any cost-saving opportunities.
- Cash burn risk score: Role: Risk analyst for an agency. Task: Compute a risk score indicating potential cash burn over the next 6 months. Context: Inputs are liquidity ratio, reserve adequacy, and cash runway. Output: a score from 0 to 100 with interpretation guide and recommended mitigations. Constraints: provide tie-breakers for close scores.
- Product mix sensitivity: Role: Portfolio analyst. Task: Assess how product mix impacts cash flow under scenarios. Context: Include life, health, auto, and property lines. Output: sensitivity matrix showing cash flow delta per percentage shift in market share. Constraints: show at least three scenarios.
- Commission timing analysis: Role: Commission analyst. Task: Model timing of commissions receipts over 12 months. Context: Include front-loaded and trailing commissions, with holdbacks. Output: timeline chart data and cash impact notes. Constraints: identify months with potential shortfalls.
- Liquidity scenario planning: Role: Planning lead. Task: Run three liquidity scenarios (base, optimistic, stressed) for the next 12 months. Context: Include cash reserves, lines of credit, and expected claim spikes. Output: scenario comparison table with liquidity gaps and mitigation steps.
- Pricing impact forecast: Role: Pricing strategist. Task: Estimate cash flow impact of price changes on policies enacted in the quarter. Context: Include premium adjustments, policy lapses, and timing. Output: forecast table with revenue, churn, and cash flow effect. Constraints: limit to changes within 5 percent.
- Runway vs. commitments: Role: Finance officer. Task: Compare cash runway to outstanding contracts and agency commitments. Context: Include renewal pipelines and debt facilities. Output: verdict and actions to extend runway. Constraints: provide warning signals if runway falls below threshold.
- Expense variance drill: Role: Controller. Task: Analyze 12-month expense variance vs forecast. Context: Break down by month and category. Output: variance report with explanations and corrective actions. Constraints: link variances to cash impact.
- AR aging cash forecast: Role: Accounts receivable lead. Task: Forecast cash receipts based on aging of client receivables. Context: Use net terms, early payment incentives, and client concentration. Output: aging-to-cash projection with monthly receipts. Constraints: flag high-risk accounts.
- New business influx: Role: Growth analyst. Task: Model cash flow influence of new agency clients expected this quarter. Context: Include onboarding costs and first-year premiums. Output: cash impact by month and cumulative effect. Constraints: assume a moderate win rate.
- Forecast accuracy audit: Role: Quality auditor. Task: Audit the forecasting model for accuracy and bias. Context: Compare historical forecast vs actuals for 24 months. Output: accuracy metrics and recommended model improvements. Constraints: document data quality issues.
- Seasonality calibration: Role: Data specialist. Task: Calibrate seasonality factors for premium cycles. Context: Include monthly premiums by product line. Output: seasonality-adjusted forecast. Constraints: report confidence intervals.
- Reserve adequacy check: Role: Actuarial analyst. Task: Check reserve adequacy against forecast cash outflows. Context: Include IBNR, case reserves, and development. Output: adequacy score and recommended reserve adjustments. Constraints: avoid over-reserving.
- Policy lapse risk: Role: Risk manager. Task: Forecast cash impact of policy lapses. Context: Use lapse rates by policy type and customer segment. Output: monthly cash impact and mitigation plan. Constraints: test alternative retention strategies.
- Credit line utilization: Role: Treasury analyst. Task: Model maximum utilization of credit facilities under stress. Context: Include interest costs and covenants. Output: utilization plan and cost impact by month. Constraints: keep covenant breach risk low.
- Marketing spend ROI: Role: Marketing finance lead. Task: Forecast cash flow impact of marketing campaigns. Context: Include attribution window and CAC. Output: monthly ROI-adjusted cash flow and payback period. Constraints: limit new campaigns to confirmed budgets.
- Client concentration risk: Role: Risk strategist. Task: Assess cash flow exposure to top clients. Context: Include client dependency, concentration ratios, and diversification plan. Output: risk dashboard and mitigation steps. Constraints: propose diversification actions.
- Premium timing forecast: Role: Billing coordinator. Task: Forecast timing of premium inflows by payment method. Context: Include EFT, card, and checks. Output: method-specific cash flow by month. Constraints: highlight any payment method bottlenecks.
- Expense cap proposal: Role: CFO assistant. Task: Propose an expense cap to protect cash flow. Context: Include contingency categories and variance triggers. Output: cap plan with phased implementation. Constraints: ensure compliance with policy.
- Billing dispute impact: Role: Collections manager. Task: Estimate cash impact from likely billing disputes. Context: Include dispute resolution time and write-off risk. Output: cash flow delta and resolution timeline. Constraints: prioritize high-value disputes.
- Vendor payment terms: Role: AP lead. Task: Optimize vendor payment terms to improve liquidity. Context: Include early payoff discounts and net terms. Output: recommended terms by vendor and projected cash impact. Constraints: balance supplier relations.
- Cash flow dashboard: Role: Financial analyst. Task: Build a monthly cash flow dashboard for executives. Context: Include key metrics, trends, and alerts. Output: dashboard data and visualization-ready fields. Constraints: maintain simplicity.
- Forecast governance: Role: PMO lead. Task: Define governance for forecasts including schedule, owners, and approvals. Context: Include change control log. Output: governance doc and sample approval flow. Constraints: keep updates weekly.
- Client onboarding costs: Role: Onboarding manager. Task: Forecast cash impact of new client onboarding. Context: Include setup fees and first-year premium. Output: monthly cash impact and payback. Constraints: account for churn risk.
- Lapse recovery path: Role: Client success. Task: Model effect of lapse reversal campaigns on cash flow. Context: Include win-back cost and conversion rate. Output: monthly impact and ROI by campaign. Constraints: cap spend.
- Seasonal promo effects: Role: Promotions analyst. Task: Forecast cash flow from seasonal promotions. Context: Include forecast uplift and costs. Output: monthly cash flow with scenario ranges. Constraints: exclude unrelated promotions.
- Line-of-business mix: Role: Portfolio manager. Task: Analyze cash flow by line of business. Context: Include premiums, commissions, and claims. Output: breakdown and cross-sell opportunities. Constraints: highlight profitable lines.
- Interest expense forecast: Role: Treasurer. Task: Forecast interest costs on debt facilities. Context: Include amortization schedule and rates. Output: monthly interest expense and cumulative cost. Constraints: factor debt covenants.
- Operational cash flow: Role: Ops finance. Task: Separate operating cash flow from financing and investing. Context: Include working capital changes. Output: monthly operating cash flow details. Constraints: identify non-cash adjustments.
- Tax cash flow: Role: Tax advisor. Task: Forecast quarterly tax payments and refunds. Context: Include estimated assessments and credits. Output: tax cash flow calendar with due dates. Constraints: align with accounting method.
- Payroll cash timing: Role: HR finance. Task: Forecast payroll cash timing under different headcounts. Context: Include payroll taxes and benefits. Output: monthly payroll cash outflow and variance. Constraints: seasonally adjust.
- Capital expenditure plan: Role: Capex planner. Task: Forecast 12-month capital expenditures and depreciation. Context: Include project phasing and ROI. Output: monthly capex cash outflow and NPV signals. Constraints: prioritize critical projects.
- Regulatory fees: Role: Compliance finance. Task: Forecast regulatory and licensing fees. Context: Include renewal cycles and penalties. Output: monthly cash outflow with risk flags. Constraints: stay within budget.
- Credit risk reserve: Role: Credit risk analyst. Task: Forecast reserves for bad debts. Context: Use historical loss rates by client segment. Output: reserve suggestion and impact on cash flow. Constraints: avoid over-reserving.
- Cash flow milestones: Role: Program manager. Task: Define cash flow milestones for a growth program. Context: Include funding gates and release constraints. Output: milestone-based forecast and alerts. Constraints: link to quarterly objectives.
- Debt service schedule: Role: Treasury manager. Task: Forecast debt service payments. Context: Include principal and interest by loan. Output: monthly debt service cash outflow. Constraints: ensure debt covenants remain satisfied.
- Policy renewal timing: Role: Policy operations. Task: Forecast renewal timing impact on cash flow. Context: Include mid-term policy reviews and renewal lags. Output: monthly renewal cash impact and alerts. Constraints: align with marketing campaigns.
- Agent commission forecast: Role: Commission analyst. Task: Forecast agent commissions based on closed premiums. Context: Include tiered commission structures and payout delays. Output: monthly commission cash flow with variance. Constraints: reflect accelerator rates.
- Payments channel mix: Role: Finance ops. Task: Forecast cash flow by payment channel. Context: Include EFT, card, check, and mobile pay. Output: channel-specific monthly cash flow. Constraints: identify channel inefficiencies.
- Friends and family discounts: Role: Pricing lead. Task: Model cash flow impact of referral discounts. Context: Include forecasted premium changes and claim rates. Output: monthly cash flow with scenario ranges. Constraints: avoid adverse selection.
- Seasonal reserves planning: Role: Actuarial planner. Task: Plan season-specific reserves. Context: Include peak months and non-peak months. Output: reserve requirements by month and risk flags. Constraints: maintain solvency margins.
- Client churn forecast: Role: Retention analyst. Task: Forecast cash impact of client churn. Context: Include churn rate by segment and recovery actions. Output: monthly churn cash impact and action plan. Constraints: quantify ROI of retention efforts.
- Vendor risk matrix: Role: Procurement finance. Task: Build a vendor risk-adjusted cash flow model. Context: Include supplier risk scores and payment terms. Output: risk-adjusted cash flow and mitigations. Constraints: diversify supplier base.
- New product launch: Role: Product finance. Task: Forecast cash flow around a new product launch. Context: Include launch costs and expected premiums. Output: monthly cash impact and breakeven point. Constraints: set confidence targets.
- Emergency liquidity plan: Role: Crisis finance lead. Task: Create emergency liquidity plan. Context: Include contingency funds and credit lines. Output: action steps and trigger-based funding plan. Constraints: maintain minimum liquidity.
- Reinsurance impact: Role: Reinsurance analyst. Task: Forecast cash flow with reinsurance costs. Context: Include premium ceding and recoveries. Output: monthly cash flow with net effect. Constraints: consider different treaty terms.
- Interest income forecast: Role: Treasury analyst. Task: Forecast interest income on cash balances. Context: Include rate scenarios and investment mix. Output: monthly interest income and cumulative yield. Constraints: reflect liquidity posture.
- Regulatory timeline: Role: Compliance CFO. Task: Align forecast with regulatory reporting timelines. Context: Include filing windows and penalties. Output: cash flow alignment plan and timing map. Constraints: maintain accuracy.
- Client credit check: Role: Credit risk manager. Task: Forecast cash flow with client credit checks. Context: Include credit limits and payment terms. Output: risk-adjusted cash flow and recommended actions. Constraints: prioritize high-risk accounts.
- Budget vs actuals: Role: Budget controller. Task: Compare forecast to actual cash movements. Context: Include month-by-month deltas. Output: variance analysis and corrective actions. Constraints: tie variances to cash impact.
- Tax timing optimization: Role: Tax strategist. Task: Optimize quarterly tax cash outlays. Context: Include credits and deductions. Output: timing plan and cash savings. Constraints: synchronize with accounting method.
- Cash flow drills: Role: Scenario planner. Task: Run quick drills for cash flow stress. Context: Include 3 scenarios with distinct assumptions. Output: drill results and recommended actions. Constraints: limit drill duration to one hour.
- Premium aging projection: Role: Premium analytics. Task: Forecast aging of premiums receivable. Context: Include aging buckets and collection rates. Output: monthly aging-to-cash forecast. Constraints: signal aging risk early.
- Commission acceleration: Role: Commissions ops. Task: Model accelerated commission payout in high-growth months. Context: Include clawbacks and holdbacks. Output: cash flow uplift and risk notes. Constraints: limit acceleration to threshold.
- Policy lapse forecasting: Role: Retention strategist. Task: Forecast policy lapse scenarios and cash impact. Context: Include lapse rates by product and client segment. Output: monthly impact and retention plan. Constraints: test recovery offers.
- Premium inception timing: Role: Billing supervisor. Task: Forecast premium inception timing for new policies. Context: Include effective dates and billing cycles. Output: monthly cash flow with timing signals. Constraints: minimize mid-cycle disruptions.
- Debt covenants watch: Role: Treasurer. Task: Monitor debt covenant risk in forecast. Context: Include leverage ratios and interest coverage. Output: covenant breach flags and mitigation steps. Constraints: adjust forecast to stay compliant.
- Forecast data quality: Role: Data steward. Task: Ensure forecast data quality and lineage. Context: Include data sources and refresh cadence. Output: data quality score and remediation plan. Constraints: document inaccuracies.
- Product profitability cadence: Role: Product finance. Task: Track cash flow by product with cadence. Context: Include quarterly reviews and updates. Output: profitability cadence report and action list. Constraints: align with board expectations.
- Seasonal staffing plan: Role: HR finance. Task: Forecast payroll needs around peak seasons. Context: Include overtime and contractor costs. Output: monthly payroll cash outflow and staffing gap notes. Constraints: stay within budget.
- Acquisition cash model: Role: M&A finance. Task: Model cash impact of potential acquisition. Context: Include purchase price, financing mix, and integration costs. Output: 12-month cash flow projection and synergy estimates. Constraints: sensitivity to financing terms.
- Reserves vs forecasts: Role: Actuarial finance. Task: Compare reserve levels to forecast needs. Context: Include development patterns. Output: gap analysis and reserve adjustment plan. Constraints: avoid under-reserving.
- Cash flow confidence: Role: Analytics lead. Task: Quantify forecast confidence intervals. Context: Include data quality and model reliance. Output: interval ranges and drivers. Constraints: document uncertainty sources.
- Invoice dispute tracker: Role: A/R lead. Task: Track disputes affecting cash receipts. Context: Include dispute duration and resolution probability. Output: forecast-adjusted receipts and risk notes. Constraints: escalate high-value cases.
- Profit share planning: Role: Compensation planner. Task: Forecast impact of profit-sharing on cash flow. Context: Include payout timing and performance targets. Output: monthly cash outflow and planned reserves. Constraints: cap on incentives.
- Policy cross-sell impact: Role: Sales finance. Task: Evaluate cash flow impact of cross-sell campaigns. Context: Include incremental premiums and costs. Output: month-by-month cash flow and ROI. Constraints: avoid cannibalization.
- Claims timing sensitivity: Role: Claims finance. Task: Analyze timing of large claims on cash flow. Context: Include seasonality and payment plans. Output: cash flow impact by month with risk flags. Constraints: plan for quiet months.
- Retention ROI forecast: Role: Retention consultant. Task: Forecast cash flow impact of retention initiatives. Context: Include costs and reduced churn. Output: monthly impact and ROI. Constraints: track payback period.
- Credit line reprice: Role: Treasury strategist. Task: Model impact of interest rate changes on credit lines. Context: Include drawdown patterns and fees. Output: monthly net cash impact. Constraints: plan for rate volatility.
- Capital scheduling: Role: CFO assistant. Task: Schedule capital outlays with cash constraints. Context: Include project dependencies. Output: monthly capex plan and funding mix. Constraints: prioritize critical path.
- Policyholder dividends: Role: Compliance finance. Task: Forecast potential dividends to policyholders. Context: Include regulatory limitations. Output: monthly cash outflow and compliance flags. Constraints: maintain solvency margins.
- Forecast governance charter: Role: PMO finance. Task: Draft governance charter for forecasting process. Context: Include review cadence and approvals. Output: charter and template documents. Constraints: ensure audit trail.
- Lapsed policy recovery: Role: Retention manager. Task: Forecast cash flow if lapsed policies are reinstated. Context: Include reactivation costs and premium changes. Output: monthly cash impact and ROI. Constraints: prioritize high-value policies.
- Reinsurance liquidity: Role: Reinsurance controller. Task: Forecast liquidity with reinsurance timing. Context: Include premium ceding and recoveries. Output: monthly net cash flow and risk flags. Constraints: align with treaties.
- Agency debt capacity: Role: Finance planner. Task: Assess debt capacity for the agency. Context: Include service costs and covenants. Output: recommended debt capacity and timing. Constraints: avoid breaching covenants.
- Forecast data sources: Role: Data manager. Task: List primary data sources for forecasts. Context: Include data lineage and freshness. Output: data source map and reliability score. Constraints: document data gaps.
- Seasonal buffer strategy: Role: Planning lead. Task: Propose seasonal buffers for cash flow. Context: Include worst-case buffers. Output: buffer plan and trigger metrics. Constraints: keep buffers proportional to risk.
- Agent onboarding costs: Role: Onboarding finance. Task: Forecast costs to onboard new agents. Context: Include training, systems access, and commissions. Output: monthly cash impact and ROI. Constraints: cap onboarding batch size.
- Policy renewal forecast: Role: Operations finance. Task: Forecast policy renewals and related cash flow. Context: Include renewal rates by product. Output: monthly renewal cash flow and trend line. Constraints: flag declining segments.
- Client segment forecast: Role: Segment analyst. Task: Forecast cash flow by client segment. Context: Include premium generators and retention rates. Output: segment-level cash flow with drivers. Constraints: tailor actions per segment.
- Pricing competitiveness: Role: Pricing strategist. Task: Forecast cash flow impact of price competitiveness changes. Context: Include market share effects. Output: monthly cash flow and breakeven shifts. Constraints: avoid price wars.
- Automation benefits: Role: Automation lead. Task: Forecast cash flow impact of automation investments. Context: Include upfront costs and efficiency gains. Output: monthly cash flow with ROI. Constraints: track payback period.
- Regulatory penalty risk: Role: Compliance risk. Task: Forecast penalties and fines impact on cash flow. Context: Include probability and severity. Output: monthly cash impact and mitigation. Constraints: ensure controls.
- Client payment delays: Role: Collections lead. Task: Model impact of client payment delays on cash flow. Context: Include historical delay durations. Output: monthly cash shortfalls and mitigation steps. Constraints: prioritize high-value invoices.
- Seasonal marketing schedule: Role: Marketing finance. Task: Forecast cash flow with seasonal marketing schedule. Context: Include campaign windows and lift. Output: monthly cash impact and risk notes. Constraints: cap spend.
- Policy bundle profitability: Role: Product finance. Task: Forecast profitability of bundled policies. Context: Include discounts and cross-sell revenue. Output: monthly cash flow by bundle. Constraints: optimize bundle mix.
- Claims settlement plan: Role: Claims finance lead. Task: Forecast cash settlements by quarter. Context: Include settlement delays and approval times. Output: quarterly cash outflow and risk flags. Constraints: minimize settlement variance.
- Automation risk flags: Role: Risk analyst. Task: Identify cash flow risks from automation vendors. Context: Include dependency risk and outage costs. Output: risk matrix and mitigation steps. Constraints: require vendor SLAs.
- Sales pipeline cash: Role: Revenue planner. Task: Forecast cash from the sales pipeline. Context: Include conversion rates and timing. Output: monthly cash inflows and confidence score. Constraints: discount front-loading.
- Brokerage commissions: Role: Brokerage finance. Task: Forecast third-party commissions. Context: Include payout schedules and offsets. Output: monthly cash flow and risk flags. Constraints: ensure accurate offsets.
- Ancillary revenue forecast: Role: Revenue analyst. Task: Forecast cash from ancillary services. Context: Include uptake rates and renewal opportunities. Output: monthly cash flow and indicators. Constraints: limit cannibalization.
- Seasonal liquidity gates: Role: Treasury planner. Task: Define liquidity gates by season. Context: Include trigger thresholds. Output: gate-based cash plan and actions. Constraints: automate alerts.
- Cash flow anomaly detection: Role: Data scientist. Task: Detect anomalies in monthly cash flow. Context: Include outliers and data gaps. Output: anomaly report with root causes and fixes. Constraints: alert on deviations.
- Policyholder behavior: Role: Behavioral analytics. Task: Forecast cash impact of policyholder behavior changes. Context: Include claim frequency shifts and premium sensitivity. Output: monthly cash flow with scenario ranges. Constraints: avoid overfitting.
- Recovery plan simulation: Role: Recovery planner. Task: Simulate recovery plans after a revenue shock. Context: Include costed initiatives and payback. Output: multiple scenario cash flows and recommended actions. Constraints: test at least three plans.
- Forecasting checklist: Role: Forecasting lead. Task: Generate a checklist for forecast readiness. Context: Include data quality, assumptions, approvals, and documentation. Output: checklist with status indicators. Constraints: ensure auditability.
- Executive briefing pack: Role: Finance director. Task: Compile a briefing pack focused on cash flow forecast outcomes. Context: Include key metrics, risks, and recommended actions. Output: briefing narrative and slides-ready data. Constraints: concise and decision-focused.
Markdown Template
100 Best Gemini Cash Flow Forecasting Prompts for Insurance Agents
# 100 Best Gemini Cash Flow Forecasting Prompts for Insurance Agents
**Forecast baseline revenue**: You are a financial analyst for an insurance agency. Role: Gemini AI assistant. Task: Produce a baseline 12-month cash flow forecast. Context: Use last 24 months of gross written premiums, commissions, renewals, and claims payout trends. Output: a month-by-month cash balance table with beginning balance, cash inflows, cash outflows, net cash flow, and ending balance. Constraints: assume no major one-time events, adjust for seasonality, consider reserve requirements. Deliver as: CSV-style rows with headers: Month, Beginning Balance, Inflows, Outflows, Net Cash, Ending Balance.
**Model renewal cash inflows**: You are a forecasting specialist for an insurance agency. Role: Gemini AI consultant. Task: Forecast monthly renewal cash inflows for the next year. Context: Use historical renewal rates by policy type and client aging. Output: table with month, policy type, renewal count, renewal amount, expected churn adjustment. Constraints: include best-case, base-case, and worst-case scenarios. Format: JSON array of objects.
**Claims payout projection**: Role: Insurance finance advisor. Task: Project monthly claims payouts for the next 12 months. Context: Include paid, reserved, and incurred-but-not-reported (IBNR) amounts by line of business. Output: stacked bar style data with lines for paid, reserved, IBNR. Constraints: seasonality adjustments and reserve adequacy flags. Format: YAML-like blocks per month.
**Expense forecast by category**: Role: Finance planner. Task: Break down fixed and variable expenses for the agency for the next 12 months. Context: Include commissions, staff salaries, marketing, IT, and overhead. Output: per-month expense table with category and variance vs last year. Constraints: highlight any cost-saving opportunities.
**Cash burn risk score**: Role: Risk analyst for an agency. Task: Compute a risk score indicating potential cash burn over the next 6 months. Context: Inputs are liquidity ratio, reserve adequacy, and cash runway. Output: a score from 0 to 100 with interpretation guide and recommended mitigations. Constraints: provide tie-breakers for close scores.
**Product mix sensitivity**: Role: Portfolio analyst. Task: Assess how product mix impacts cash flow under scenarios. Context: Include life, health, auto, and property lines. Output: sensitivity matrix showing cash flow delta per percentage shift in market share. Constraints: show at least three scenarios.
**Commission timing analysis**: Role: Commission analyst. Task: Model timing of commissions receipts over 12 months. Context: Include front-loaded and trailing commissions, with holdbacks. Output: timeline chart data and cash impact notes. Constraints: identify months with potential shortfalls.
**Liquidity scenario planning**: Role: Planning lead. Task: Run three liquidity scenarios (base, optimistic, stressed) for the next 12 months. Context: Include cash reserves, lines of credit, and expected claim spikes. Output: scenario comparison table with liquidity gaps and mitigation steps.
**Pricing impact forecast**: Role: Pricing strategist. Task: Estimate cash flow impact of price changes on policies enacted in the quarter. Context: Include premium adjustments, policy lapses, and timing. Output: forecast table with revenue, churn, and cash flow effect. Constraints: limit to changes within 5 percent.
**Runway vs. commitments**: Role: Finance officer. Task: Compare cash runway to outstanding contracts and agency commitments. Context: Include renewal pipelines and debt facilities. Output: verdict and actions to extend runway. Constraints: provide warning signals if runway falls below threshold.
**Expense variance drill**: Role: Controller. Task: Analyze 12-month expense variance vs forecast. Context: Break down by month and category. Output: variance report with explanations and corrective actions. Constraints: link variances to cash impact.
**AR aging cash forecast**: Role: Accounts receivable lead. Task: Forecast cash receipts based on aging of client receivables. Context: Use net terms, early payment incentives, and client concentration. Output: aging-to-cash projection with monthly receipts. Constraints: flag high-risk accounts.
**New business influx**: Role: Growth analyst. Task: Model cash flow influence of new agency clients expected this quarter. Context: Include onboarding costs and first-year premiums. Output: cash impact by month and cumulative effect. Constraints: assume a moderate win rate.
**Forecast accuracy audit**: Role: Quality auditor. Task: Audit the forecasting model for accuracy and bias. Context: Compare historical forecast vs actuals for 24 months. Output: accuracy metrics and recommended model improvements. Constraints: document data quality issues.
**Seasonality calibration**: Role: Data specialist. Task: Calibrate seasonality factors for premium cycles. Context: Include monthly premiums by product line. Output: seasonality-adjusted forecast. Constraints: report confidence intervals.
**Reserve adequacy check**: Role: Actuarial analyst. Task: Check reserve adequacy against forecast cash outflows. Context: Include IBNR, case reserves, and development. Output: adequacy score and recommended reserve adjustments. Constraints: avoid over-reserving.
**Policy lapse risk**: Role: Risk manager. Task: Forecast cash impact of policy lapses. Context: Use lapse rates by policy type and customer segment. Output: monthly cash impact and mitigation plan. Constraints: test alternative retention strategies.
**Credit line utilization**: Role: Treasury analyst. Task: Model maximum utilization of credit facilities under stress. Context: Include interest costs and covenants. Output: utilization plan and cost impact by month. Constraints: keep covenant breach risk low.
**Marketing spend ROI**: Role: Marketing finance lead. Task: Forecast cash flow impact of marketing campaigns. Context: Include attribution window and CAC. Output: monthly ROI-adjusted cash flow and payback period. Constraints: limit new campaigns to confirmed budgets.
**Client concentration risk**: Role: Risk strategist. Task: Assess cash flow exposure to top clients. Context: Include client dependency, concentration ratios, and diversification plan. Output: risk dashboard and mitigation steps. Constraints: propose diversification actions.
**Premium timing forecast**: Role: Billing coordinator. Task: Forecast timing of premium inflows by payment method. Context: Include EFT, card, and checks. Output: method-specific cash flow by month. Constraints: highlight any payment method bottlenecks.
**Expense cap proposal**: Role: CFO assistant. Task: Propose an expense cap to protect cash flow. Context: Include contingency categories and variance triggers. Output: cap plan with phased implementation. Constraints: ensure compliance with policy.
**Billing dispute impact**: Role: Collections manager. Task: Estimate cash impact from likely billing disputes. Context: Include dispute resolution time and write-off risk. Output: cash flow delta and resolution timeline. Constraints: prioritize high-value disputes.
**Vendor payment terms**: Role: AP lead. Task: Optimize vendor payment terms to improve liquidity. Context: Include early payoff discounts and net terms. Output: recommended terms by vendor and projected cash impact. Constraints: balance supplier relations.
**Cash flow dashboard**: Role: Financial analyst. Task: Build a monthly cash flow dashboard for executives. Context: Include key metrics, trends, and alerts. Output: dashboard data and visualization-ready fields. Constraints: maintain simplicity.
**Forecast governance**: Role: PMO lead. Task: Define governance for forecasts including schedule, owners, and approvals. Context: Include change control log. Output: governance doc and sample approval flow. Constraints: keep updates weekly.
**Client onboarding costs**: Role: Onboarding manager. Task: Forecast cash impact of new client onboarding. Context: Include setup fees and first-year premium. Output: monthly cash impact and payback. Constraints: account for churn risk.
**Lapse recovery path**: Role: Client success. Task: Model effect of lapse reversal campaigns on cash flow. Context: Include win-back cost and conversion rate. Output: monthly impact and ROI by campaign. Constraints: cap spend.
**Seasonal promo effects**: Role: Promotions analyst. Task: Forecast cash flow from seasonal promotions. Context: Include forecast uplift and costs. Output: monthly cash flow with scenario ranges. Constraints: exclude unrelated promotions.
**Line-of-business mix**: Role: Portfolio manager. Task: Analyze cash flow by line of business. Context: Include premiums, commissions, and claims. Output: breakdown and cross-sell opportunities. Constraints: highlight profitable lines.
**Interest expense forecast**: Role: Treasurer. Task: Forecast interest costs on debt facilities. Context: Include amortization schedule and rates. Output: monthly interest expense and cumulative cost. Constraints: factor debt covenants.
**Operational cash flow**: Role: Ops finance. Task: Separate operating cash flow from financing and investing. Context: Include working capital changes. Output: monthly operating cash flow details. Constraints: identify non-cash adjustments.
**Tax cash flow**: Role: Tax advisor. Task: Forecast quarterly tax payments and refunds. Context: Include estimated assessments and credits. Output: tax cash flow calendar with due dates. Constraints: align with accounting method.
**Payroll cash timing**: Role: HR finance. Task: Forecast payroll cash timing under different headcounts. Context: Include payroll taxes and benefits. Output: monthly payroll cash outflow and variance. Constraints: seasonally adjust.
**Capital expenditure plan**: Role: Capex planner. Task: Forecast 12-month capital expenditures and depreciation. Context: Include project phasing and ROI. Output: monthly capex cash outflow and NPV signals. Constraints: prioritize critical projects.
**Regulatory fees**: Role: Compliance finance. Task: Forecast regulatory and licensing fees. Context: Include renewal cycles and penalties. Output: monthly cash outflow with risk flags. Constraints: stay within budget.
**Credit risk reserve**: Role: Credit risk analyst. Task: Forecast reserves for bad debts. Context: Use historical loss rates by client segment. Output: reserve suggestion and impact on cash flow. Constraints: avoid over-reserving.
**Cash flow milestones**: Role: Program manager. Task: Define cash flow milestones for a growth program. Context: Include funding gates and release constraints. Output: milestone-based forecast and alerts. Constraints: link to quarterly objectives.
**Debt service schedule**: Role: Treasury manager. Task: Forecast debt service payments. Context: Include principal and interest by loan. Output: monthly debt service cash outflow. Constraints: ensure debt covenants remain satisfied.
**Policy renewal timing**: Role: Policy operations. Task: Forecast renewal timing impact on cash flow. Context: Include mid-term policy reviews and renewal lags. Output: monthly renewal cash impact and alerts. Constraints: align with marketing campaigns.
**Agent commission forecast**: Role: Commission analyst. Task: Forecast agent commissions based on closed premiums. Context: Include tiered commission structures and payout delays. Output: monthly commission cash flow with variance. Constraints: reflect accelerator rates.
**Payments channel mix**: Role: Finance ops. Task: Forecast cash flow by payment channel. Context: Include EFT, card, check, and mobile pay. Output: channel-specific monthly cash flow. Constraints: identify channel inefficiencies.
**Friends and family discounts**: Role: Pricing lead. Task: Model cash flow impact of referral discounts. Context: Include forecasted premium changes and claim rates. Output: monthly cash flow with scenario ranges. Constraints: avoid adverse selection.
**Seasonal reserves planning**: Role: Actuarial planner. Task: Plan season-specific reserves. Context: Include peak months and non-peak months. Output: reserve requirements by month and risk flags. Constraints: maintain solvency margins.
**Client churn forecast**: Role: Retention analyst. Task: Forecast cash impact of client churn. Context: Include churn rate by segment and recovery actions. Output: monthly churn cash impact and action plan. Constraints: quantify ROI of retention efforts.
**Vendor risk matrix**: Role: Procurement finance. Task: Build a vendor risk-adjusted cash flow model. Context: Include supplier risk scores and payment terms. Output: risk-adjusted cash flow and mitigations. Constraints: diversify supplier base.
**New product launch**: Role: Product finance. Task: Forecast cash flow around a new product launch. Context: Include launch costs and expected premiums. Output: monthly cash impact and breakeven point. Constraints: set confidence targets.
**Emergency liquidity plan**: Role: Crisis finance lead. Task: Create emergency liquidity plan. Context: Include contingency funds and credit lines. Output: action steps and trigger-based funding plan. Constraints: maintain minimum liquidity.
**Reinsurance impact**: Role: Reinsurance analyst. Task: Forecast cash flow with reinsurance costs. Context: Include premium ceding and recoveries. Output: monthly cash flow with net effect. Constraints: consider different treaty terms.
**Interest income forecast**: Role: Treasury analyst. Task: Forecast interest income on cash balances. Context: Include rate scenarios and investment mix. Output: monthly interest income and cumulative yield. Constraints: reflect liquidity posture.
**Regulatory timeline**: Role: Compliance CFO. Task: Align forecast with regulatory reporting timelines. Context: Include filing windows and penalties. Output: cash flow alignment plan and timing map. Constraints: maintain accuracy.
**Client credit check**: Role: Credit risk manager. Task: Forecast cash flow with client credit checks. Context: Include credit limits and payment terms. Output: risk-adjusted cash flow and recommended actions. Constraints: prioritize high-risk accounts.
**Budget vs actuals**: Role: Budget controller. Task: Compare forecast to actual cash movements. Context: Include month-by-month deltas. Output: variance analysis and corrective actions. Constraints: tie variances to cash impact.
**Tax timing optimization**: Role: Tax strategist. Task: Optimize quarterly tax cash outlays. Context: Include credits and deductions. Output: timing plan and cash savings. Constraints: synchronize with accounting method.
**Cash flow drills**: Role: Scenario planner. Task: Run quick drills for cash flow stress. Context: Include 3 scenarios with distinct assumptions. Output: drill results and recommended actions. Constraints: limit drill duration to one hour.
**Premium aging projection**: Role: Premium analytics. Task: Forecast aging of premiums receivable. Context: Include aging buckets and collection rates. Output: monthly aging-to-cash forecast. Constraints: signal aging risk early.
**Commission acceleration**: Role: Commissions ops. Task: Model accelerated commission payout in high-growth months. Context: Include clawbacks and holdbacks. Output: cash flow uplift and risk notes. Constraints: limit acceleration to threshold.
**Policy lapse forecasting**: Role: Retention strategist. Task: Forecast policy lapse scenarios and cash impact. Context: Include lapse rates by product and client segment. Output: monthly impact and retention plan. Constraints: test recovery offers.
**Premium inception timing**: Role: Billing supervisor. Task: Forecast premium inception timing for new policies. Context: Include effective dates and billing cycles. Output: monthly cash flow with timing signals. Constraints: minimize mid-cycle disruptions.
**Debt covenants watch**: Role: Treasurer. Task: Monitor debt covenant risk in forecast. Context: Include leverage ratios and interest coverage. Output: covenant breach flags and mitigation steps. Constraints: adjust forecast to stay compliant.
**Forecast data quality**: Role: Data steward. Task: Ensure forecast data quality and lineage. Context: Include data sources and refresh cadence. Output: data quality score and remediation plan. Constraints: document inaccuracies.
**Product profitability cadence**: Role: Product finance. Task: Track cash flow by product with cadence. Context: Include quarterly reviews and updates. Output: profitability cadence report and action list. Constraints: align with board expectations.
**Seasonal staffing plan**: Role: HR finance. Task: Forecast payroll needs around peak seasons. Context: Include overtime and contractor costs. Output: monthly payroll cash outflow and staffing gap notes. Constraints: stay within budget.
**Acquisition cash model**: Role: M&A finance. Task: Model cash impact of potential acquisition. Context: Include purchase price, financing mix, and integration costs. Output: 12-month cash flow projection and synergy estimates. Constraints: sensitivity to financing terms.
**Reserves vs forecasts**: Role: Actuarial finance. Task: Compare reserve levels to forecast needs. Context: Include development patterns. Output: gap analysis and reserve adjustment plan. Constraints: avoid under-reserving.
**Cash flow confidence**: Role: Analytics lead. Task: Quantify forecast confidence intervals. Context: Include data quality and model reliance. Output: interval ranges and drivers. Constraints: document uncertainty sources.
**Invoice dispute tracker**: Role: A/R lead. Task: Track disputes affecting cash receipts. Context: Include dispute duration and resolution probability. Output: forecast-adjusted receipts and risk notes. Constraints: escalate high-value cases.
**Profit share planning**: Role: Compensation planner. Task: Forecast impact of profit-sharing on cash flow. Context: Include payout timing and performance targets. Output: monthly cash outflow and planned reserves. Constraints: cap on incentives.
**Policy cross-sell impact**: Role: Sales finance. Task: Evaluate cash flow impact of cross-sell campaigns. Context: Include incremental premiums and costs. Output: month-by-month cash flow and ROI. Constraints: avoid cannibalization.
**Claims timing sensitivity**: Role: Claims finance. Task: Analyze timing of large claims on cash flow. Context: Include seasonality and payment plans. Output: cash flow impact by month with risk flags. Constraints: plan for quiet months.
**Retention ROI forecast**: Role: Retention consultant. Task: Forecast cash flow impact of retention initiatives. Context: Include costs and reduced churn. Output: monthly impact and ROI. Constraints: track payback period.
**Credit line reprice**: Role: Treasury strategist. Task: Model impact of interest rate changes on credit lines. Context: Include drawdown patterns and fees. Output: monthly net cash impact. Constraints: plan for rate volatility.
**Capital scheduling**: Role: CFO assistant. Task: Schedule capital outlays with cash constraints. Context: Include project dependencies. Output: monthly capex plan and funding mix. Constraints: prioritize critical path.
**Policyholder dividends**: Role: Compliance finance. Task: Forecast potential dividends to policyholders. Context: Include regulatory limitations. Output: monthly cash outflow and compliance flags. Constraints: maintain solvency margins.
**Forecast governance charter**: Role: PMO finance. Task: Draft governance charter for forecasting process. Context: Include review cadence and approvals. Output: charter and template documents. Constraints: ensure audit trail.
**Lapsed policy recovery**: Role: Retention manager. Task: Forecast cash flow if lapsed policies are reinstated. Context: Include reactivation costs and premium changes. Output: monthly cash impact and ROI. Constraints: prioritize high-value policies.
**Reinsurance liquidity**: Role: Reinsurance controller. Task: Forecast liquidity with reinsurance timing. Context: Include premium ceding and recoveries. Output: monthly net cash flow and risk flags. Constraints: align with treaties.
**Agency debt capacity**: Role: Finance planner. Task: Assess debt capacity for the agency. Context: Include service costs and covenants. Output: recommended debt capacity and timing. Constraints: avoid breaching covenants.
**Forecast data sources**: Role: Data manager. Task: List primary data sources for forecasts. Context: Include data lineage and freshness. Output: data source map and reliability score. Constraints: document data gaps.
**Seasonal buffer strategy**: Role: Planning lead. Task: Propose seasonal buffers for cash flow. Context: Include worst-case buffers. Output: buffer plan and trigger metrics. Constraints: keep buffers proportional to risk.
**Agent onboarding costs**: Role: Onboarding finance. Task: Forecast costs to onboard new agents. Context: Include training, systems access, and commissions. Output: monthly cash impact and ROI. Constraints: cap onboarding batch size.
**Policy renewal forecast**: Role: Operations finance. Task: Forecast policy renewals and related cash flow. Context: Include renewal rates by product. Output: monthly renewal cash flow and trend line. Constraints: flag declining segments.
**Client segment forecast**: Role: Segment analyst. Task: Forecast cash flow by client segment. Context: Include premium generators and retention rates. Output: segment-level cash flow with drivers. Constraints: tailor actions per segment.
**Pricing competitiveness**: Role: Pricing strategist. Task: Forecast cash flow impact of price competitiveness changes. Context: Include market share effects. Output: monthly cash flow and breakeven shifts. Constraints: avoid price wars.
**Automation benefits**: Role: Automation lead. Task: Forecast cash flow impact of automation investments. Context: Include upfront costs and efficiency gains. Output: monthly cash flow with ROI. Constraints: track payback period.
**Regulatory penalty risk**: Role: Compliance risk. Task: Forecast penalties and fines impact on cash flow. Context: Include probability and severity. Output: monthly cash impact and mitigation. Constraints: ensure controls.
**Client payment delays**: Role: Collections lead. Task: Model impact of client payment delays on cash flow. Context: Include historical delay durations. Output: monthly cash shortfalls and mitigation steps. Constraints: prioritize high-value invoices.
**Seasonal marketing schedule**: Role: Marketing finance. Task: Forecast cash flow with seasonal marketing schedule. Context: Include campaign windows and lift. Output: monthly cash impact and risk notes. Constraints: cap spend.
**Policy bundle profitability**: Role: Product finance. Task: Forecast profitability of bundled policies. Context: Include discounts and cross-sell revenue. Output: monthly cash flow by bundle. Constraints: optimize bundle mix.
**Claims settlement plan**: Role: Claims finance lead. Task: Forecast cash settlements by quarter. Context: Include settlement delays and approval times. Output: quarterly cash outflow and risk flags. Constraints: minimize settlement variance.
**Automation risk flags**: Role: Risk analyst. Task: Identify cash flow risks from automation vendors. Context: Include dependency risk and outage costs. Output: risk matrix and mitigation steps. Constraints: require vendor SLAs.
**Sales pipeline cash**: Role: Revenue planner. Task: Forecast cash from the sales pipeline. Context: Include conversion rates and timing. Output: monthly cash inflows and confidence score. Constraints: discount front-loading.
**Brokerage commissions**: Role: Brokerage finance. Task: Forecast third-party commissions. Context: Include payout schedules and offsets. Output: monthly cash flow and risk flags. Constraints: ensure accurate offsets.
**Ancillary revenue forecast**: Role: Revenue analyst. Task: Forecast cash from ancillary services. Context: Include uptake rates and renewal opportunities. Output: monthly cash flow and indicators. Constraints: limit cannibalization.
**Seasonal liquidity gates**: Role: Treasury planner. Task: Define liquidity gates by season. Context: Include trigger thresholds. Output: gate-based cash plan and actions. Constraints: automate alerts.
**Cash flow anomaly detection**: Role: Data scientist. Task: Detect anomalies in monthly cash flow. Context: Include outliers and data gaps. Output: anomaly report with root causes and fixes. Constraints: alert on deviations.
**Policyholder behavior**: Role: Behavioral analytics. Task: Forecast cash impact of policyholder behavior changes. Context: Include claim frequency shifts and premium sensitivity. Output: monthly cash flow with scenario ranges. Constraints: avoid overfitting.
**Recovery plan simulation**: Role: Recovery planner. Task: Simulate recovery plans after a revenue shock. Context: Include costed initiatives and payback. Output: multiple scenario cash flows and recommended actions. Constraints: test at least three plans.
**Forecasting checklist**: Role: Forecasting lead. Task: Generate a checklist for forecast readiness. Context: Include data quality, assumptions, approvals, and documentation. Output: checklist with status indicators. Constraints: ensure auditability.
**Executive briefing pack**: Role: Finance director. Task: Compile a briefing pack focused on cash flow forecast outcomes. Context: Include key metrics, risks, and recommended actions. Output: briefing narrative and slides-ready data. Constraints: concise and decision-focused.Best Practices
- Maintain high-quality input data (historic cash flows by month, line of business, and client segment).
- Reuse prompts with different data slices to build a robust forecast library.
- Validate outputs with a monthly reconciliation process against actual cash movements.
- Document assumptions and provide versioned forecast outputs for auditability.
- Keep prompts concise but specific about output formats and decision points.
Common Mistakes to Avoid
- Assuming perfect data without validation leads to misleading forecasts.
- Using generic prompts that don’t fix outputs to a monthly cash flow table.
- Overcomplicating prompts with unnecessary placeholders that slow processing.
- Neglecting seasonality and one-time events in the forecast.
- Failing to define acceptable error margins or confidence intervals.
FAQ
What is cash flow forecasting for insurance agents?
It is the process of predicting the agency's cash inflows and outflows over a future horizon to manage liquidity, plan for expenses, and support strategic decisions.
Why use Gemini prompts for forecasting?
Gemini prompts standardize input, clarify outputs, and enable repeatable, scenario-aware cash flow models tailored to insurance operations.
How should I format forecast outputs?
Prefer tabular formats (CSV or Excel-ready tables) with clearly labeled columns for month, inflows, outflows, net cash, and ending balance.
What data is essential for accurate forecasts?
Historical premiums, commissions, renewals, claims, expenses, client mix, payment terms, and reserve levels.
How can I improve forecast accuracy?
Regularly validate against actuals, adjust seasonality factors, and document all assumptions in a versioned forecast workbook.
Can prompts handle multiple scenarios?
Yes, structure prompts to produce base, optimistic, and stressed scenarios with corresponding outputs and recommended actions.