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

5. Outputs

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

1. Validate Input Presence

   • Verify the PDF can be opened.
   • Confirm Company Name, Fiscal Period, and Report PDF are provided.

2. Open the Report

   • Open the PDF and locate the three required statements: Income Statement, Balance Sheet, and Cash‑Flow Statement.

3. 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.

4. 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).

5. 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.

6. 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.

7. 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.”

8. Assemble the Output

   • Financial Summary heading and paragraph.
   • Key Financial Metrics heading and table.
   • Validation Log heading and bullet list.

9. Final Review

   • Read the whole output for clarity, correct formatting, and accurate numbers.

10. 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

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

1. 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.

2. How are percentages rounded? Percentages are rounded to two decimal places (e.g., 23.08%).

3. 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.

4. The report contains multiple years—what do I do? Process only the period specified in the “Fiscal Period” input. Other periods are ignored.

5. Can I request additional ratios? Yes. Add the desired ratio name to “Focus Areas”; the process will calculate it if the necessary data exists.

6. 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.”

7. Do I need separate PDFs for each statement? No. All statements should be included in the single PDF provided as input.

8. 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.

Key Financial Metrics

Validation Log

• All sections found.
• Values verified against source.
• Calculations correct.
• All checks passed.