Home
cd ../playbooks
Investment BankingIntermediate

IB Pitch Deck Template Populator

Populate investment banking pitch deck templates with financial data, ensuring number consistency, proper formatting, and institutional presentation standards.

5 minutes
By anthropicSource
#pitch deck#PowerPoint#investment banking#presentation

Populating a pitch deck template with live deal data means hours of copy-paste between Excel and PowerPoint, manually checking that the same revenue figure matches across 15 slides -- and one inconsistency can undermine your credibility in the room.

Who it's for: investment banking analysts, associates, vice presidents, managing directors

Example

"Populate this pitch deck template with data from our source Excel file" → Completed pitch deck with all placeholder sections filled, numbers cross-checked across slides, tables formatted as proper objects, and professional presentation standards applied

CLAUDE.md Template

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

Or install from your terminal:
npx ccplaybooks add ib-pitch-deck
# Populating Investment Banking Pitch Deck Templates

Populates investment banking pitch deck templates with data from source files. Use when: user provides a PowerPoint template to fill in, user has source data (Excel/CSV) to populate into slides, user mentions populating or filling a pitch deck template, or user needs to transfer data into existing slide layouts. Not for creating presentations from scratch.

## Reference Files

**Read all reference files at task start before beginning any work.** These contain critical patterns and anti-patterns that will affect your approach. Do not wait until you encounter issues.

| File | Purpose |
|------|---------|
| `formatting-standards.md` | Text, bullets, tables, charts, alignment |
| `slide-templates.md` | Content mapping guidance for common slide types |

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

This playbook populates investment banking pitch deck templates with financial data from source files (Excel, CSV, PDF). It follows a 5-phase workflow -- data extraction, content mapping, template population, validation, and final verification -- to ensure number consistency, proper formatting, and institutional presentation standards across every slide.

Note: This is for populating existing templates with data, not for creating presentations from scratch.


Quick Start

Step 1: Create a Project Folder

Create a folder for your deal workspace and place the downloaded template inside as CLAUDE.md.

mkdir -p ~/Documents/PitchDeck-ProjectNova

Step 2: Download the Template

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

mv ~/Downloads/ib-pitch-deck.md ~/Documents/PitchDeck-ProjectNova/CLAUDE.md

Step 3: Add Your Files

Place these in the same folder:

  • PowerPoint template (.pptx) to be populated
  • Source data files (Excel, CSV, PDF)
  • Any reference files mentioned in the template (formatting standards, slide templates, etc.)

Step 4: Start Working

cd ~/Documents/PitchDeck-ProjectNova
claude

Try prompts like:

"Populate this pitch deck template with data from the source Excel file"
"Fill in the market overview slides using the industry report PDF"
"Update all financial tables to reflect the latest Q4 numbers"
"Validate that revenue figures are consistent across all slides"

5-Phase Workflow

Phase Purpose
1. Data Extraction Extract and validate data from source materials
2. Content Mapping Map source data to template placeholder sections
3. Template Population Fill slides with data, apply formatting
4. Validation Loop Convert to images, check, fix, repeat (up to 3 cycles)
5. Final Verification Run quality checklist before delivery

Critical Anti-Patterns to Avoid

  • Do not populate data INTO colored placeholder boxes -- the placeholder tells you what content goes there; replace it with properly formatted content
  • Do not create text-based tables using pipes or tabs -- always use actual PowerPoint table objects
  • Do not inherit placeholder contrast -- production slides typically use dark text on light backgrounds

Formatting Standards

Element Typical Size Style
Slide title 40-48pt Bold
Section header 14-16pt Regular
Body text 11-14pt Regular
Table header 10-12pt Bold
Table body 9-11pt Regular
Footnotes 8-9pt Italic

Tips and Best Practices

  • Always back up the original template before making any modifications
  • Cross-slide consistency is critical -- the same metric must show the same number on every slide where it appears
  • Tables must be actual table objects, never pipe-separated or tab-separated text
  • Validate visually by converting slides to images after population
  • The final file should be reviewed in Microsoft PowerPoint before distribution, as LibreOffice rendering may differ
  • Include source citations in slide footnotes for all data points

Example Prompts

"Populate the situation overview slide with the company description and key metrics"
"Fill in the comparable companies table from the comps Excel sheet"
"Update the football field valuation slide with the latest ranges"
"Check all slides for number consistency and flag any mismatches"
"Format the financial summary table to match the template styling"

$Related Playbooks

Investment Banking

M&A Process Letter Drafter

Draft professional process letters for sell-side M&A transactions with timeline, bid requirements, and procedural guidelines for prospective buyers.

5 minutes
Intermediate
Investment Banking

Company Strip Profile Generator

Create concise one-page company profiles for M&A buyer lists with financial summary, strategic rationale, and M&A activity tracking.

5 minutes
Beginner
Investment Banking

M&A Teaser (Blind Profile) Writer

Draft anonymous sell-side teasers that generate buyer interest while protecting company identity, with investment highlights and financial overview.

5 minutes
Intermediate
Investment Banking

M&A Buyer List Builder

Build and prioritize a universe of strategic and financial buyers for sell-side M&A processes with tiered outreach planning.

5 minutes
Intermediate
Investment Banking

Confidential Information Memorandum (CIM) Builder

Structure and draft professional CIMs for sell-side M&A with consistent formatting, data-driven narrative, and investor-ready presentation.

5 minutes
Advanced
Investment Banking

Financial Data Pack Builder

Transform financial data from CIMs, SEC filings, and other sources into standardized Excel workbooks ready for investment committee review.

5 minutes
Advanced
Investment Banking

Investment Banking Deal Tracker

Track multiple live M&A deals with milestones, deadlines, action items, and weekly review summaries for managing a deal pipeline.

5 minutes
Beginner
Investment Banking

Merger Model & Accretion/Dilution Analysis

Build M&A merger models with pro forma EPS analysis, synergy sensitivities, purchase price allocation, and breakeven calculations.

5 minutes
Advanced

Browse all Investment Banking playbooks →