Prompt Details
Model
(gemini-3.7-flash)
Token size
631
Example input
[COMPANY NAME AND INDUSTRY SECTOR]: Apex Industrial Manufacturing Ltd, Industrial Equipment Sector
[REPORTING PERIOD AND ACCOUNTING STANDARD]: FY 2024 vs FY 2025 comparison under IFRS standard
[PRIMARY AUDIT OBJECTIVE OR STAKEHOLDER FOCUS]: M&A Buy-Side Financial Due Diligence and Leverage Assessment
[PRIMARY FINANCIAL CONCERN OR STRATEGIC QUESTION]: Margin compression due to rising raw material costs and deteriorating Cash Conversion Cycle
[FINANCIAL STATEMENT DATA OR DATASET SUMMARY]: FY 2024 Revenue $120M, EBITDA $24M 20%, Net Debt $48M. FY 2025 Revenue $128M, EBITDA $21.76M 17%, Net Debt $55M. DSO increased from 45 to 62 days, DIO increased from 30 to 42 days, DPO flat at 35 days. Operating Cash Flow dropped from $18M to $11M.
Example output
1. EXECUTIVE FINANCIAL HEALTH SUMMARY
• Overall Financial Risk Rating: Medium to High Risk
• Primary Capital Allocation Leak: Severe working capital bloat driven by receivables and inventory accumulation alongside gross margin degradation
• Estimated EBITDA Margin Improvement Potential: 250 basis point margin recovery upon working capital optimization and raw material cost pass-through
Variance Analysis Overview:
Despite top-line revenue growth of 6.7%, operational efficiency degraded significantly. EBITDA contracted by 9.3%, reducing margins from 20.0% to 17.0%. Net Financial Debt expanded by 14.6% to $55M, increasing leverage from 2.0x to 2.53x Net Debt to EBITDA.
2. FINANCIAL PERFORMANCE AND KPI DASHBOARD TABLE
| Financial Metric | Prior Period | Current Period | Variance Change | Industry Benchmark Comparison |
| Revenue | $120.0M | $128.0M | +6.7% Growth | Below Sector Average Growth |
| EBITDA Margin | 20.0% | 17.0% | -300 bps | Below Top-Quartile Performers |
| Net Debt to EBITDA | 2.00x | 2.53x | +0.53x Increase | Moderate Leverage Warning |
| Cash Conversion Cycle | 40 Days | 69 Days | +29 Days Deterioration | Severe Working Capital Inefficiency |
3. PROFITABILITY, LEVERAGE AND LIQUIDITY BREAKDOWN
• Margins and Return on Capital Analysis: Gross margin compression directly impacted EBITDA performance, reducing overall Return on Invested Capital ROIC from 14.2% to 10.8%
• Debt Sustainability and Interest Coverage Audit: Increasing Net Debt to $55M combined with lower EBITDA weakened Interest Coverage from 6.0x to 4.1x, elevating refinancing risk
• Working Capital and Cash Conversion Cycle Breakdown: Cash Conversion Cycle expanded by 29 days due to DSO increasing by 17 days and DIO by 12 days, locking up $9.8M of trapped liquidity
4. STRATEGIC RECOMMENDATIONS AND CAPITAL OPTIMIZATION PROTOCOL
• Near-Term Operational Efficiency Initiatives Under 6 Months: Enforce strict credit control protocols to reduce DSO back toward 45 days and implement dynamic pricing surcharges for raw materials
• Medium-Term Capital Structure and Debt Management 6 to 18 Months: Reallocate operating cash flow toward debt paydown to restore Net Debt to EBITDA ratio below 2.0x prior to maturity refinancing
• Governance and Risk Mitigation Controls: Implement weekly cash flow forecasting dashboards and mandate dual-signoff for inventory purchases exceeding standard replenishment thresholds
5. SCENARIO STRESS TEST AND SENSITIVITY MATRIX TABLE
| Stress Scenario | Operational Impact Trigger | Mitigating Financial Rule | Required Executive Action |
| Revenue Contraction | 10% volume decline | Variable cost reduction trigger | Immediate hiring freeze and CapEx deferral |
| Interest Rate Shock | 200 bps rate increase | Minimum 3.5x interest coverage ceiling | Execute interest rate swaps for floating debt |
| Working Capital Expansion | DSO exceeds 70 days | Customer credit suspension rule | Mandatory legal collection protocol initiation |
By purchasing this prompt, you agree to our terms of service
GEMINI-3.7-FLASH
Transform raw financial data into an institutional-grade corporate finance audit. Designed for CFOs, M&A advisors, and analysts, this advanced AI prompt acts as a Quantitative Financial Analyst and Investment Banker. It evaluates balance sheet strength, profitability, working capital (DSO, DIO, DPO), leverage sustainability, and cash flow conversion. Includes executive health scores, scenario stress test matrices, and actionable capital optimization roadmaps. Tested on GPT-4o, Gemini & Claude.
...more
Added over 1 month ago
