Financial

Strategic Cash Flow & Liquidity Risk Analysis

πŸ”₯ 82 trend score πŸ‘ 0 uses
#finance#cash-flow#treasury#analysis
Category
Financial
Trend Score
82/100
Total Uses
0
Prompt Template
Act as a Senior Financial Analyst and Treasury Consultant with 15+ years of experience in corporate finance. Your objective is to perform a comprehensive diagnostic and strategic analysis of the cash flow situation for [COMPANY_NAME], a firm operating in the [INDUSTRY_SECTOR] sector.

I will provide you with the following data: [INSERT_FINANCIAL_DATA_OR_SUMMARY].

Please execute the following tasks in a structured report:

1. **Cash Flow Driver Analysis**: Identify the primary drivers behind Operating Cash Flow (OCF), Investing Cash Flow (ICF), and Financing Cash Flow (FCF). Distinguish between sustainable cash generation and one-time balance sheet movements.

2. **Working Capital Efficiency**: Analyze the efficiency of the cash conversion cycle. Specifically, evaluate the current [DSO/DPO/DIO] metrics compared to industry benchmarks for [INDUSTRY_SECTOR] and suggest specific levers to optimize liquidity.

3. **Liquidity & Solvency Assessment**: Calculate the current Cash Burn Rate (if applicable) and the 'Runway' under current conditions. Assess the company’s ability to meet short-term obligations and capital expenditure requirements without external financing.

4. **Sensitivity & Scenario Analysis**: Based on the provided data, simulate two scenarios:
   - Scenario A: A 15% decrease in top-line revenue.
   - Scenario B: A 10% increase in COGS due to inflationary pressures.
   How do these scenarios impact the net cash position over the next [TIME_PERIOD]?

5. **Strategic Recommendations**: Provide 3-5 actionable, high-impact recommendations to improve free cash flow (FCF) and mitigate identified liquidity risks.

**Output Format**:
- **Executive Summary**: 3-bullet points for the CFO.
- **Detailed Analysis Tables**: Organize metrics clearly.
- **Risk Matrix**: High/Medium/Low risk categorization for liquidity factors.
- **Conclusion**: Final assessment of financial health.

Maintain a professional, objective, and analytical tone throughout the response.
Browse more Financial prompts