Extract data from a financial document and update a model

Overview

Analysts often spend significant time manually reading annual reports, extracting key figures, and transferring them into financial models, a process prone to error and inefficiency.

Comet can read an attached annual report, identify and extract key financial data (revenue, margins, capex, debt levels), summarise the strategic narrative, and populate or update a connected spreadsheet with the extracted figures.

This compresses what was a multi-hour task into a single prompt.

Key output

Expand

Tips

• Specify the exact fields you need: Tell Comet which line items matter: 'focus on segment revenue breakdowns and capex by division' so it extracts precisely the data your model requires
• Ask for variance callouts: Request that Comet 'flag any figures that differ materially from the prior year and include management's stated explanation from the MD&A section'
• Attach the model template first: Share your existing spreadsheet so Comet maps extracted values to the correct rows and columns rather than creating a new structure from scratch