Home
cd ../playbooks
Finance & AccountingIntermediate

S&P Global Company Tear Sheet Generator

Generate professional company tear sheets and one-pagers using S&P Capital IQ data, tailored to equity research, M&A, corporate development, or sales audiences.

5 minutes
By anthropicSource
#S&P Global#tear-sheet#company-profile#capital-iq#financial-analysis#M&A

Building a company tear sheet means toggling between a dozen Capital IQ screens, copying numbers into a template, and hoping nothing is stale by the time you present it. This skill pulls live data and formats a polished, audience-specific one-pager in minutes.

Who it's for: equity research analysts, investment banking associates, corporate development professionals, sales and business development teams, M&A deal teams

Example

"Create a tear sheet for Snowflake for our M&A team" → Professional DOCX company one-pager with financials, valuation, ownership, and competitive positioning tailored for investment banking audience

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

Or install from your terminal:
npx ccplaybooks add spglobal-tear-sheet

# Financial Tear Sheet Generator

Generate audience-specific company tear sheets by pulling live data from S&P Capital IQ via the S&P Global MCP tools and formatting the result as a professional Word document.

## Style Configuration

These are sensible defaults. To customize for your firm's brand, modify this section — common changes include swapping the color palette, changing the font (Calibri is standard at many banks), and updating the disclaimer text.

**Colors:**
- Primary (header banner background, section header text): #1F3864
- Accent (signature section highlights): #2E75B6

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

Generates professional company tear sheets using live S&P Capital IQ data via the Kensho LLM-ready API MCP server. Supports four audience types -- equity research, investment banking/M&A, corporate development, and sales/business development -- with each producing a differently structured one-pager. Works for both public and private companies.


Quick Start

Step 1: Create a Project Folder

mkdir -p ~/tear-sheets

Step 2: Download the Template

Click Download above, then move the file into your project folder as CLAUDE.md.

Step 3: Start Working

cd ~/tear-sheets
claude

Say: "Generate a tear sheet for Stripe for our corporate development team"


Audience Types

Audience Focus Areas
Equity Research Valuation multiples, consensus estimates, earnings trends
Investment Banking / M&A Enterprise value, deal comps, ownership structure
Corporate Development Strategic fit, competitive positioning, acquisition rationale
Sales / BD Company overview, decision makers, budget signals

Important Notes

  • If the user does not specify an audience type, the skill will ask before proceeding.
  • All derived metrics (EV/Revenue, margins, growth rates) are calculated with explicit intermediate steps and verified.
  • Intermediate data files are saved to protect against context window compression.
  • Output format is DOCX with professional formatting and consistent styling.
  • Requires S&P Capital IQ MCP server and Kensho LLM-ready API MCP server to be configured.

$Related Playbooks

Finance & Accounting

SOX Testing Workpaper

SOX sample selections, testing workpapers, and internal control assessments

10 minutes
Advanced
Finance & Accounting

QuickBooks Automation

Automate QuickBooks accounting workflows including invoicing, expenses, reporting, and bank reconciliation

10 minutes
Advanced
Finance & Accounting

Budget Scenario Modeler

Model multiple budget scenarios side-by-side with trade-off analysis, sensitivity testing, and executive-ready recommendations.

15 minutes
Intermediate
Finance & Accounting

Financial Analysis & Trend Interpreter

Analyze financial data to identify trends, anomalies, and actionable insights with executive-ready commentary.

15 minutes
Intermediate
Finance & Accounting

VAT Return Automation with Browser Control

Automate HMRC VAT MTD submissions using Claude Code and Playwright MCP to navigate forms, calculate figures, and file returns.

15 minutes
Advanced
Finance & Accounting

Bookkeeping & Tax Prep Workspace

Point Claude at a folder of W-2s, 1099s, bank statements, and receipts — get back an organized archive, a master bookkeeping spreadsheet, a tax summary with refund estimate, and a one-page accountant briefing.

15 minutes
Intermediate
Finance & Accounting

Account Reconciliation Assistant

GL-to-subledger and bank reconciliation with variance identification

10 minutes
Advanced
Finance & Accounting

Browser-Assisted Tax Filing

Use Claude Cowork with browser automation to prepare and file taxes - organize documents, fill forms, and submit filings.

15 minutes
Advanced
Finance & Accounting

Bank Statement CSV Merger

Combine multiple bank statement CSV files into one unified spreadsheet with consistent formatting.

5 minutes
Beginner
Finance & Accounting

E-Commerce VAT Integration with Stripe

Build and manage European VAT compliance for e-commerce using Claude Code with Stripe MCP for tax calculation, invoicing, and cross-border sales.

15 minutes
Advanced
Finance & Accounting

3-Statement Financial Model Builder

Build integrated 3-statement financial models with proper cross-statement linkages, scenario analysis, and professional formatting in Excel.

5 minutes
Intermediate
Finance & Accounting

Spreadsheet and Financial Model Auditor

Systematically audit spreadsheets and financial models for formula errors, broken linkages, logic issues, and reasonableness problems with severity-based reporting.

5 minutes
Beginner

Browse all Finance & Accounting playbooks →