Financial Analysis, Accounting, Decision Support
Automated Financial Statement & Ratio Analysis Model (Excel)
An automated Excel-based financial analysis model compatible with Screener-style data, combining ratio computation and an integrated dashboard to support structured company evaluation.

Project Detail
Context
Equity analysis often starts with financial data exported from platforms such as
Screener, but raw data alone is not decision-ready. Analysts typically spend
significant time cleaning inputs, recalculating ratios, and building views to
interpret performance trends.
This friction slows down screening and introduces inconsistency across analyses.
What I Built
I built an automated Excel-based financial analysis model designed to work with
Screener-compatible financial data formats.
The model ingests standardized financial statements, structures them
automatically, computes key financial ratios, and presents insights through an
integrated Excel dashboard for quick interpretation.
What the Model Enables
The model supports:
- Direct ingestion of Screener-exported financial data
- Automated structuring of income statement, balance sheet, and cash flow data
- Formula-driven computation of profitability, liquidity, and leverage ratios
- Trend analysis across reporting periods
- A dashboard view summarizing key financial metrics and signals
- Rapid identification of strengths, weaknesses, and potential red flags
The emphasis is on speed, consistency, and repeatability of analysis.
Design Decisions That Matter
- Input sheets aligned with Screener’s export structure
- Clear separation between raw inputs, calculations, and dashboard outputs
- Automation through formulas rather than manual recalculation
- Ratios and visuals chosen for analytical relevance, not quantity
This design allows the sheet to function as a reusable screening and analysis
tool rather than a one-off spreadsheet.
Why This Matters
This project demonstrates a strong foundation in accounting and financial
analysis, along with the ability to translate raw financial data into structured,
decision-ready insights.
It reflects practical analyst workflows and serves as a base layer for more
advanced automation and AI-driven financial systems.