---
title: Financial Statement Analyzer
emoji: 📈
colorFrom: blue
colorTo: green
sdk: docker
pinned: false
app_port: 7860
short_description: AI financial analysis portal with free BYOK models.
---

# 📈 Financial Statement Analyzer

Cloud-hosted AI analysis portal. Fetches financial statements for any listed company (Indian NSE/BSE or global NYSE/NASDAQ), computes ratios, generates AI narratives, and produces downloadable Excel, Word, and PowerPoint reports.

**Bring Your Own Key (BYOK)** — keys stay in your browser session only, never stored.

## 🆓 Free AI Options (No Credit Card Needed)

| Provider | Model | Where to get key |
|---|---|---|
| **Groq** *(recommended)* | Llama 3.3 70B | [console.groq.com](https://console.groq.com/keys) — instant signup |
| **Google Gemini** | Gemini 2.0 Flash | [aistudio.google.com](https://aistudio.google.com/app/apikey) — free tier |

## 💳 Optional Paid AIs

| Provider | Model | Where to get key |
|---|---|---|
| Anthropic Claude | Claude Haiku | [console.anthropic.com](https://console.anthropic.com/) |
| OpenAI | GPT-4o mini | [platform.openai.com](https://platform.openai.com/api-keys) |

## How to Use

1. Open the app → paste a **free Groq or Gemini key** in the sidebar
2. Enter a company name/ticker (e.g. TCS, Reliance, AAPL)
3. Pick formats (Excel / Word / PowerPoint) and click **Analyze**
4. Download your reports instantly

## Features

- 🔍 **Smart Ticker Resolution** — resolves company names via yfinance + FMP
- 📊 **Financial Data** — Income statement, balance sheet, cash flow, 5–10 year history
- 🧮 **Ratio Engine** — 30+ ratios + DuPont decomposition
- 🤖 **Multi-Model AI** — Use multiple providers simultaneously; outputs combined with attribution
- 📥 **Export Reports** — Excel workbook, Word summary, PowerPoint pitch deck
- 📜 **Audit Trail** — Every run logged with user, ticker, formats, and AI models used

## Optional: Persistent Audit Logs (Supabase)

Without Supabase, logs reset on redeploy. To persist them:

| Secret | Value |
|---|---|
| `SUPABASE_URL` | Your Supabase project URL |
| `SUPABASE_KEY` | Supabase anon public key |

## Tech Stack

- **Frontend**: Streamlit with custom dark glassmorphism CSS
- **Data**: yfinance (primary), FMP API (secondary), screener.in (Indian fallback)  
- **AI**: Groq/Llama (free), Gemini (free tier), Claude, ChatGPT
- **Reports**: openpyxl (Excel), python-docx (Word), python-pptx (PowerPoint)
- **Audit**: SQLite (local) or Supabase (cloud persistent)
- **Container**: Docker on Python 3.11-slim