Works with the AI Agents you already use
Claude Code
Cursor
Codex CLI
DeepSeek
Muse+22 moreClaude CodeCursorCodex CLIDeepSeekMuse
Dots
Manus
Grok
Grok Bot+18 agentsfinancial model ratio analyst
CFO-grade financial modeling, ratio analysis, and scenario planning for finance professionals and analysts.
$7.99
financial model ratio analyst
Example session with this skill installed
Analyze the attached P&L and Balance Sheet for FY2023-2024. Provide a ratio analysis, a 12-month forecast for FY2025, and a scenario analysis showing the impact of a 10% revenue drop.
- Read your context and instructions
- Compiled the financial model ratio
I have analyzed the FY2023-2024 financial statements. The model is balanced, and the cash roll-forward is verified.
CFO Executive Summary
The business shows strong profitability but faces tightening liquidity. While EBITDA margins improved from 18% to 22%, the Cash Conversion Cycle lengthened by 12 days, driven by increased inventory holding.
Ratio Analysis
| Metric | FY2023 | FY2024 | Delta | Interpretation |
|---|---|---|---|---|
| Gross Margin | 45.2% | 47.8% | +260bps | Improved sourcing efficiency. |
| Current Ratio | 2.1x | 1.6x | -0.5x | Weakening liquidity; monitor payables. |
| Debt / EBITDA | 2.4x | 2.1x | -0.3x | Deleveraging due to debt repayment. |
| DSO | 35 days | 38 days | +3 days | Slight slowdown in collections. |
Scenario Analysis (FY2025 Forecast)
| Metric | Downside (-10% Rev) | Base Case | Upside (+5% Rev) |
|---|---|---|---|
| Revenue ($M) | $10.80 | $12.00 | $12.60 |
| EBITDA ($M) | $2.05 | $2.64 | $2.89 |
| EBITDA Margin | 19.0% | 22.0% | 23.0% |
| Ending Cash ($M) | $0.85 | $1.42 | $1.68 |
Model Integrity Checks
- Balance Sheet: Balanced (Assets = L+E)
- Cash Flow: Reconciled to Ending Cash
- Integrity: No circular reference errors detected
Next steps
- Review the inventory management policy to improve the Cash Conversion Cycle.
- Validate the sales pipeline assumptions used for the FY2025 Base Case.
- Assess debt covenants if the Downside Scenario persists for more than two quarters.
Connects securely to your tools. The creator never sees your data.
About this skill
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.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
Requires clean source data for integrated models. Not a substitute for statutory audits, regulated investment advice, or professional tax filings.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 2 months ago
Permissions
File Scopes
Reads financial statements, spreadsheets, reports and supporting documents. May create structured analysis files and financial-model outputs. Does not require external network access unless the user explicitly provides or requests external financial data.