FilingIntel
Product Requirements Document
Product Name: Filing Intel
Version: 1.0
Date: May 28th 2025
Product Manager & Developer: Tharun Poduru
1. Introduction
Goals:
- To provide users with rapid, easily digestible, and accurate financial insights from public company SEC filings.
- To leverage AI to offer a preliminary analysis of a company's financial health, saving users time and effort.
- To become a go-to tool for quick financial assessments of publicly traded companies.
Vision: FilingIntel aims to democratize access to financial data analysis, empowering individual investors, students, and professionals to make more informed decisions without needing to be SEC filing experts or spend hours on manual data extraction.
2. Target Audience
Primary Users:
- Retail Investors: Seeking to understand the financial health of companies before investing.
- Financial Analysts: Requiring quick access to standardized financial metrics and ratios for initial assessments.
- Business & Finance Students: Learning about financial statement analysis.
Secondary Users:
- Journalists/Reporters: Needing quick financial facts for articles.
- Small Business Owners/Consultants: Performing competitor analysis on publicly traded companies.
3. User Stories & Use Cases
- US1: As a retail investor, I want to quickly search for a company by its ticker symbol and see its key financial trends (like revenue, net income, OCF) over the past two years, so I can gauge its recent performance.
- US2: As a financial analyst, I want to view calculated ratios like Debt-to-Equity, Free Cash Flow, and ROE without manually sifting through 10-K/10-Q filings.
- US4: As any user, I want an AI-generated summary of a company's financial strengths and weaknesses upon loading its data.
- US5: As a user, I want to visualize financial data like revenue and net income in clear charts.
- US6: As a user, I want the application to handle inconsistencies in SEC reporting robustly.
4. Key Features
F1: Company Search & Dashboard Access
- F1.1: Ability to search for U.S. publicly traded companies by ticker symbol or company name.
- F1.2: Selection of a company loads its dedicated financial dashboard.
F2: Financial Dashboard
- F2.1: Overview & AI Insights (Initial View)
- Display basic company identifiers (Name, Ticker, CIK).
- Strategic Loading Screen for essential data.
- Prominently display the AI-generated context summary.
- F2.2: Financials Tab
- Quarterly display (up to the latest 8 unique quarters) of core financial metrics: Revenue, Net Income, Total Assets, OCF, Total Liabilities, Shareholder Equity.
- Interactive line or bar charts for each metric.
- F2.3: Key Metrics Tab
- Display calculated financial ratios: EPS, FCF, Current Ratio, Quick Ratio, Debt to Equity, ROE, ROA, Working Capital.
- Display percentage change from the prior comparable period.
F3: Data Sourcing & Processing Engine
- F3.1: SEC Data Acquisition via SEC EDGAR API with a backend proxy.
- F3.2: Focused Filing Scope (latest 11 primary filings).
- F3.3: Intelligent XBRL Tag Resolution mapping.
- F3.4: Accurate Quarterly Data Aggregation & derivation of Q4 from 10-K and 10-Q.
- F3.5: Data Integrity & Normalization (deduplication, date alignment, debt calculation).
- F3.6: Unit Conversion (Standardize to millions of USD).
5. Key Technical Decisions & Considerations
- API Strategy: Utilize a server-side proxy (e.g., Firebase Cloud Function) for SEC EDGAR API. Use Gemini API for AI-driven analysis.
- Data Processing Logic: Node.js backend logic for parsing, cleaning, transforming XBRL data, and robust error handling.
- Technology Stack: Node.js with TypeScript for backend; React (with Vite) for frontend; ApexCharts or Chart.js for visualization.