Company Financial Research

1. Overview

The process extracts key financial figures from a company's annual or quarterly report, condenses them into a short narrative summary and a concise table of key metrics, and provides a validation log. The output gives a clear snapshot of the company’s financial performance for a single reporting period.

2. Business Value

Provides a quick, consistent snapshot of a company’s financial health for investment, credit, or internal analysis.
Saves analysts time by automating the extraction of numbers and the calculation of common ratios.
Reduces manual errors and ensures all analysts work from the same set of figures and wording style.

3. Operational Context

When it runs: Whenever a new company financial report (annual or quarterly) is released and a financial analyst needs a concise financial summary.
Who uses it: Financial analysts, portfolio managers, corporate finance teams, and anyone who needs a quick financial overview.
Frequency: Whenever a new report is published (quarterly, annually) or on an ad‑hoc basis for a particular company.

4. Inputs

Name/Label	Type	Details Provided
Company Name	Text (short)	Legal name of the company (e.g., “Acme Corp”).
Fiscal Period	Text (e.g., “FY2023”, “Q2 2023”)	The reporting period covered in the report (year, quarter, or month).
Financial Report	PDF Document	Full annual or quarterly report containing the Income Statement, Balance Sheet, and Cash‑Flow Statement.
Focus Areas (optional)	Text	Specific financial areas the analyst wants highlighted (e.g., “Revenue growth”, “Liquidity”).
Reference Date (optional)	Date	The date the analysis is performed (for context in the narrative).
Additional Notes (optional)	Text	Any extra instructions or points of interest for the analyst.

5. Outputs

Name/Label	Type	Contents
Summary Narrative	Text (paragraph)	A 2‑4‑sentence overview that describes overall performance, notable trends, and any unusual items for the specified period.
Financial Metrics Table	Table	Rows of key financial figures and ratios (e.g., Revenue, Net Income, Total Assets) each with Value, Unit, and a brief comment (e.g., “↑ 12% YoY”).
Validation Log	Text (bulleted)	Summary of any issues (missing sections, extraction problems) and overall success status.
Output Format	Plain Text	All content delivered as plain text, using markdown headings and a simple markdown table for the metrics. No files are generated.

Formatting Rules

Summary Narrative – Title “Financial Summary” in bold, followed by a short paragraph in a neutral, professional tone.
Metrics Table – Markdown table with columns Metric, Value, Unit, Comment. No nested tables.
Validation Log – Title “Validation Log” in bold, then bullet points of any warnings or “All checks passed.”
Use commas for thousand separators and two decimal places for monetary values (e.g., $5,200,000.00). Use “M” for millions, “B” for billions (e.g., $5.2 M). Percentages are shown with two decimal places (e.g., 23.08%).
Use “↑” for increase, “↓” for decrease, and “→” for no change in the comment column.

6. Detailed Plan & Execution Steps

Validate Input Presence
- Verify the PDF can be opened.
- Confirm Company Name, Fiscal Period, and Report PDF are provided.
Open the Report
- Open the PDF and locate the three required statements: Income Statement, Balance Sheet, and Cash‑Flow Statement.
Extract Core Figures
- Income Statement: Revenue, Cost of Goods Sold (if present), Operating Income, Net Income.
- Balance Sheet: Total Assets, Total Liabilities, Shareholder’s Equity (if present).
- Cash‑Flow Statement: Operating Cash Flow, Investing Cash Flow, Financing Cash Flow, Net Change in Cash.
Calculate Key Ratios (if required data exists)
- Profit Margin = Net Income ÷ Revenue × 100 (percentage).
- Return on Assets (ROA) = Net Income ÷ Total Assets × 100 (percentage).
- Debt‑to‑Equity Ratio = Total Liabilities ÷ Shareholder’s Equity.
- Current Ratio = Current Assets ÷ Current Liabilities (only if both are provided).
Populate the Metrics Table
- For each metric, record:
  - Metric (e.g., “Revenue”).
  - Value (formatted with commas, two decimals; use “M” for millions).
  - Unit (e.g., USD, %).
  - Comment – indicate YoY change (use “↑ X%”, “↓ X%”, or “→” if unchanged), or “N/A” if not calculable.
Draft the Summary Narrative
- Begin with the company name, fiscal period, and overall performance (e.g., “Acme Corp reported a 12% increase in revenue for FY2023…”).
- Note key highlights (e.g., “Net income rose 18% to $1.2 M”).
- Mention any unusual items (e.g., “One‑off gain of $10 M from asset sale”).
- Keep it to 2‑4 sentences in a neutral, professional tone.
Create the Validation Log
- Verify each extracted figure matches the source PDF.
- Confirm each ratio calculation is correct.
- If any required figure is missing, note “Missing [Statement]” and set the affected metric to “N/A”.
- If all data is present and accurate, record “All checks passed.”
Assemble the Output
- Financial Summary heading and paragraph.
- Key Financial Metrics heading and table.
- Validation Log heading and bullet list.
Final Review
- Read the whole output for clarity, correct formatting, and accurate numbers.
Deliver
- Return the entire output as plain text, using only the headings and table described above. No external files are created.

7. Validation & Quality Checks

Section Presence: Ensure Income Statement, Balance Sheet, and Cash‑Flow Statement are all present in the PDF.
Number Accuracy: Check each extracted figure against the PDF line‑by‑line to confirm exact match.
Calculation Accuracy: Re‑calculate each ratio and confirm the result matches the entry in the Metrics Table.
Formatting Check:
- Money: commas for thousands, two decimals, “M” for millions.
- Percentages: two decimal places, followed by “%”.
- Use “↑”, “↓”, “→” correctly.
Consistency: Ensure the comment in the metrics table matches the direction of change (if YoY data is given).
Validation Log: Must list any missing data or errors. If no issues, log “All checks passed.”

8. Special Rules / Edge Cases

Missing Statement: If any of the three statements is absent, place “N/A” for every metric derived from that statement and record a “Missing [Statement]” entry in the Validation Log.
Non‑Numeric Figures: If a value is expressed as a range (e.g., “$2‑3 M”) or includes text (e.g., “$5.0–5.5 M”), set the metric to “N/A” and note “Non‑numeric value – manual review required.”
Zero or Negative Base Values:
- If Revenue is zero, profit‑margin and ROA are set to “N/A” and noted in the log.
- Negative numbers are allowed (e.g., net loss) and used in ratio calculations.
Different Currency: Use the currency symbol found in the report (e.g., €) in the “Value” column. Add a comment “Currency: €” if it differs from USD.
Multiple Periods in One Report: Process only the period specified in the “Fiscal Period” input; ignore other periods.
Unreadable PDF: If the PDF cannot be opened or OCR fails, output “Error: Unable to open PDF. Please provide a readable PDF document.” and stop the process.

9. Example

Input Example

Company Name: Acme Corp
Fiscal Period: FY2023
Financial Report: PDF titled “Acme_Corp_Annual_Report_2023.pdf” (contains Income Statement, Balance Sheet, and Cash‑Flow Statement).
Focus Areas: Revenue growth, cash flow.
Reference Date: 2025‑08‑11

(Extracted data from the PDF)

Income Statement (FY2023)

Revenue: $5,200,000
Cost of Goods Sold: $2,300,000
Operating Income: $2,000,000
Net Income: $1,200,000

Balance Sheet (FY2023)

Total Assets: $12,500,000
Total Liabilities: $4,800,000
Shareholder’s Equity: $7,700,000

Cash‑Flow Statement (FY2023)

Operating Cash Flow: $1,500,000
Investing Cash Flow: -$300,000
Financing Cash Flow: $200,000
Net Change in Cash: $1,400,000

Output Example

Financial Summary Acme Corp reported a solid 12% increase in revenue for FY2023, driven by strong sales of $5.2 M. Net income rose 18% to $1.2 M, and operating cash flow increased by $200 K YoY, resulting in a net cash increase of $1.4 M.

Key Financial Metrics

Metric	Value	Unit	Comment
Revenue	$5.2 M	USD	↑ 12% YoY
Net Income	$1.2 M	USD	↑ 18% YoY
Total Assets	$12.5 M	USD	–
Total Liabilities	$4.8 M	USD	–
Shareholder’s Equity	$7.7 M	USD	–
Operating Cash Flow	$1.5 M	USD	↑ $200 K YoY
Profit Margin	23.08%	%	↑ 2.5 pp YoY
ROA	9.60%	%	–
Debt‑to‑Equity Ratio	0.62	–	–
Current Ratio	N/A	–	Data not provided
Net Change in Cash	$1.4 M	USD	–
Cash Flow from Operating	$1.5 M	USD	↑ $200 K YoY

Validation Log

All three statements (Income, Balance Sheet, Cash‑Flow) were found.
All numbers match the source PDF.
All calculations verified.
All checks passed.

Appendix A – FAQ

What if the report uses a different currency? The currency symbol from the report (e.g., €) appears in the “Value” column. A note in the comment column indicates the currency when it differs from USD.
How are percentages rounded? Percentages are rounded to two decimal places (e.g., 23.08%).
What does “N/A” mean in the table? “N/A” indicates the data was unavailable or a calculation could not be performed due to missing information.
The report contains multiple years—what do I do? Process only the period specified in the “Fiscal Period” input. Other periods are ignored.
Can I request additional ratios? Yes. Add the desired ratio name to “Focus Areas”; the process will calculate it if the necessary data exists.
What if the PDF is scanned and not searchable? The system will attempt OCR. If OCR fails, the Validation Log will state “Unable to extract data – manual review required.”
Do I need separate PDFs for each statement? No. All statements should be included in the single PDF provided as input.
Why is a Validation Log included? To confirm that all data was successfully extracted and calculated, and to highlight any missing or problematic information.

Appendix B – Glossary

Revenue (Sales): Total money earned from selling goods or services before any costs are deducted.
Cost of Goods Sold (COGS): Direct costs tied to producing the goods sold.
Operating Income: Profit after subtracting operating expenses (e.g., salaries, rent, depreciation) from gross profit.
Net Income: Bottom‑line profit after all expenses, taxes, and interest are deducted.
Total Assets: Total economic resources owned by the company.
Total Liabilities: All debts and obligations the company owes.
Shareholder’s Equity: Residual interest after deducting liabilities from assets.
Operating Cash Flow: Cash generated from core business operations.
Profit Margin: Net Income ÷ Revenue × 100; measures profit per dollar of revenue.
Return on Assets (ROA): Net Income ÷ Total Assets × 100; measures profitability relative to assets.
Debt‑to‑Equity Ratio: Total Liabilities ÷ Shareholder’s Equity; measures leverage.
Current Ratio: Current Assets ÷ Current Liabilities; measures short‑term liquidity.

Appendix C – Reference Materials

A. Numeric Formatting Guidelines

Thousands separator: comma (e.g., 1,234,567).
Decimals: period (.) with two decimal places for monetary values (e.g., $5,200,000.00).
Abbreviations: “M” for millions, “B” for billions (e.g., $5.2 M).
Currency Symbol: prepend (e.g., $ for USD, € for Euro).
Percentages: two decimal places followed by “%” (e.g., 23.08%).

B. Narrative Tone

Neutral and professional: Avoid colloquial language.
Active voice: “Acme Corp reported…”, not “It was reported that”.
Concise: 2‑4 sentences.
Direction Indicators: “↑” for increase, “↓” for decrease, “→” for no change.

C. Ratio Calculation Details

Profit Margin = (Net Income ÷ Revenue) × 100.
ROA = (Net Income ÷ Total Assets) × 100.
Debt‑to‑Equity = Total Liabilities ÷ Shareholder’s Equity.
Current Ratio = Current Assets ÷ Current Liabilities (if both provided).

D. Validation Log Standard Phrases

All checks passed. – when every step succeeded.
Missing [Statement/Metric]. – list each missing component.
Error: Unable to open PDF. – when the file cannot be opened or is corrupted.

E. Sample Worked Output (for reference)

Financial Summary XYZ Inc. posted a 7% revenue decline in FY2022, with a net loss of $2.3 M and operating cash flow of $500 K.