financial model ratio analyst

The problem

Manual financial analysis is slow and prone to formula errors. Finance teams often struggle to turn raw trial balances or fragmented spreadsheets into structured, decision-ready CFO reports under tight deadlines.

What it does

• Performs multi-period ratio analysis covering profitability, liquidity, leverage, and efficiency metrics.
• Builds integrated three-statement financial models including Income Statement, Balance Sheet, and Cash Flow reconciliations.
• Generates Base, Upside, and Downside scenarios based on explicit driver assumptions.
• Conducts automated data quality checks to verify balance sheet equilibrium and cash roll-forwards.
• Produces executive summaries with management focus areas and risk assessments.

Why this beats prompting it yourself

Generic prompts often hallucinate missing figures or fail to maintain balance sheet integrity. This skill enforces strict accounting logic, ensures sign-convention consistency, and mandates rigorous model integrity checks that catch circular reasoning or out-of-balance statements.

Use cases

• Building a detailed 3-year forecast for board meetings or investor due diligence.
• Analyzing working capital trends to identify cash tied up in inventory or receivables.
• Performing stress tests on debt covenants through sensitivity and scenario analysis.
• Reviewing historical management accounts to pinpoint margin erosion drivers.

Known limitations

Does not provide statutory audits, tax advice, or regulated investment certifications. Requires sufficient historical data to build integrated models.