Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesBusiness & StrategyStartup PlanningCap Table

SpreadsheetStartup PlanningFree

Cap Table

Shareholders, share classes and option pool with ownership before and after a new funding round.

Shown with sample data

Colour

Cap Table

Shareholders, share classes and option pool with ownership before and after a new funding round.

Price per share
0.8
Pre-money ÷ existing shares
New shares to investors
2,500,000
New investors own
20%
Post-money valuation
$10,000,000
Ownership after the round
  • Asha Rao (CEO)32%40%
  • Marco Diaz (CTO)24%30%
  • Angel investors9.6%12%
  • Option pool (unissued)8%10%
  • Early employees4.8%6%
  • Adviser shares1.6%2%

How to use it

  1. 1List every holder with their share class and number of shares.
  2. 2Include the unissued option pool as its own row.
  3. 3Enter pre-money valuation and the amount to raise.
  4. 4Read ownership after the round and the dilution for each holder.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

See who owns what and what a raise does to it. List each holder’s shares; enter the pre-money valuation and the amount you plan to raise on the Settings sheet, and the table calculates the new share price, shares issued to investors and everyone’s ownership before and after.

Who it’s for

  • Planning a priced round
  • Explaining dilution to co-founders
  • Keeping a simple early-stage record

What’s included

  • Holders sheet: Every holder and their shares.
  • Settings sheet: The round.

How to use it

  1. 1List every holder with their share class and number of shares.
  2. 2Include the unissued option pool as its own row.
  3. 3Enter pre-money valuation and the amount to raise.
  4. 4Read ownership after the round and the dilution for each holder.
Related searchescap tablecapitalization tablestartup equitydilutionfunding round

Details

Format
Spreadsheet
Category
Startup Planning
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetStartup PlanningFree

Cap Table

Shareholders, share classes and option pool with ownership before and after a new funding round.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Startup Planning
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More startup planning templates

View all
Startup Financial Model2 sheets

MRR in month 12

$27,234

Average monthly burn

$61,419

Cash at month 12

$162,967

ABCD
1MonthCustomersRevenueCost of revenue
2M1120$10,680$1,922
3M2139$12,371$2,227
4M3158$14,062$2,531
5M4176$15,664$2,820
Model
SpreadsheetStartup Planning

Startup Financial Model

Monthly revenue, costs, burn and runway for the next 12 months.

45 min setupPreview

Company Name: Investor Update, Month Year

TL;DR: One sentence on the month.

Key metrics

MetricThis monthLast month
Revenue (MRR)$42,500$38,900
Customers318291

Highlights

  • •Win 1
  • •Win 2

Lowlights

  • •Challenge and what we're doing about it
DocumentStartup Planning

Investor Update

A monthly founder update: highlights, metrics, lowlights, asks and runway.

30 min setupPreview
Business Startup Costs Calculator2 sheets

One-time costs

$53,300

Monthly costs

$13,090

Total funding needed

$151,616

ABCD
1TypeCategoryItemEstimated cost
2One-timePremisesLease deposit (2 months)$6,400
3One-timeEquipmentEspresso machine + grinders$14,500
4One-timePremisesFit-out and furniture$22,000
5One-timeLegal & licencesCompany setup, permits$2,100
Costs
SpreadsheetStartup Planning

Business Startup Costs Calculator

Estimate one-time and monthly costs to launch and how much funding you need.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ