Instant Financial Snapshots for Busy Analysts

Mateo Cardenas

Three weeks ago• 2 min read

When a fresh earnings report lands in your inbox, the race to pull numbers, verify calculations, and craft a concise narrative can steal valuable time from strategic work. Logic’s automated research workflow turns that scramble into a streamlined, error‑free process, letting you focus on insight rather than data wrangling.

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

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.