{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["How to use this template","Securities Ledger","Summary Cap Table"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"How to use this template","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,1,7,2],[29,1,29,2]]}
[]
[null,"Instructions:"]
[]
[null,null,"Start in the Securities Ledger tab.  Fill in the \"Shares Authorized\" cells. Your authorized shares are the total available shares and can typically be found within the first couple pages of your Articles of Incorportation (C-Corp) or Operating Agreement (LLC)."]
[null,null,"After you've added Shares Authorized, review and delete the example securities. For context, a securities ledger is a list of all current and historical securities on a cap table and this tab will update the Summary Cap Table tab automatically."]
[null,null,"Enter your common and preferred stock (as applicable), and be sure to fill out every column in each row. \"Security Type\" and \"Share Class\" fields are a drop down/pick list."]
[null,null,"View your auto-populated summary cap table in the Summary Cap Table tab.  Do not edit this tab as it's entirely formula driven."]
[null,"Raised less than $1M and have fewer than 25 security holders? \nSee if you qualify for our Launch plan (basic cap table management available for free through law firms)."]
[]
[null,"Notes:"]
[]
[null,null,"This spreadsheet does not take into account liquidation preferences or securities types beyond common or preferred stock."]
[null,null,"Preferred stock is assumed to have a 1:1 conversion ratio"]
[]
[]
[null,"Definitions:"]
[]
[null,null,"Share Class: A designation applied to a specific type of security of stock.  For example, Common Class A and Preferred Series A Stock are share class names."]
[null,null,"Security ID Prefix: Letters of identification for the respective share class"]
[null,null,"Security Type: A designnation applied to a specific type of security.  For example, there's Certificates, Option Grants, RSAs, Convertible Notes, etc. "]
[null,null,"Shares Authorized: The number of shares an entity is legally allowed to issue per share class."]
[null,null,"Name: First and last name of security holder or name of investment fund"]
[null,null,"Security ID: Unique identifier for a security that begins with the \"Security ID Prefix\"  For example, CS-1 is Security ID"]
[null,null,"Quantity: The number of shares granted to a respective security"]
[null,null,"Issue Date: Date on which a security is issued."]
[null,null,"Price per Share: Price at which the security was granted or purchased."]
[null,null,"Cash Paid: Total dollar amount paid to Company excluding any taxes and transaction fees."]
[]
[]
[null,"DISCLOSURE: This calculator is provided for your informational purposes only by eShares, Inc. dba Carta, Inc. (“Carta”). Carta does not provide legal, tax, or financial advice, and the use of this calculator is not a substitute for such professional advice or services nor should it be used as a basis for any decision or action that may affect your business or interests. USE OF THIS CALCULATOR IS ENTIRELY AT YOUR OWN RISK, AND CARTA ASSUMES NO LIABILITY FOR THE USE OF OR RELIANCE ON THIS CALCULATOR. Carta provides no assurances of this calculator’s applicability or accuracy with respect to your particular circumstances. This calculator is provided “as is” without warranty of any kind, either express, implied, or statutory, including without limitation, warranties of merchantability, fitness for a particular purpose, satisfactory purpose, title or noninfringement. Some jurisdictions do not allow the exclusion of implied warranties, so these exclusions may not apply to you. ©2025 eShares, Inc. dba Carta, Inc. All rights reserved. Reproduction prohibited.\t"]

{"sheet":"Securities Ledger","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,2,0,4]]}
[]
[null,"Share Class",null,"Security ID Prefix","Security Type","Shares Authorized"]
[null,"Common",null,"CS","Certificate"]
[null,"Preferred",null,"PA","Certificate"]
[]
[null,"Name","Security ID","Security Type","Quantity","Issue Date","Share Class","Price Per Share","Cash Paid "]
[null,"Emily Palmer","CS-1","Certificate",1000.0,"2018-12-14","Common",1.0E-4,0.0]
[null,"Fake Ventures","PA-2","Certificate",4000.0,"2019-01-01","Preferred",10.0,50000.0]

{"sheet":"Summary Cap Table","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DO NOT EDIT//Formula Driven"]
[null,"Shares","Shares Authorized","Shares issued and outstanding","Fully Diluted Shares [1]","Fully Diluted Ownership","Cash Raised"]
[null,{"$f":"IF('Securities Ledger'!B3=\"\",\"\",'Securities Ledger'!B3)","v":"Common"},{"$f":"IF(B4=\"\",\"\",'Securities Ledger'!F3)","v":""},{"$f":"IF(B4=\"\",\"\",SUMIF('Securities Ledger'!G7:G120,\"Common\",'Securities Ledger'!E7:E120))","v":1000},{"$f":"D4","v":1000},{"$f":"IFERROR(E4/E8,0)","v":0.2},{"$f":"IF(E4=\"\",\"\",SUMIF('Securities Ledger'!G7:G120,\"Common\",'Securities Ledger'!I7:I120))","v":0}]
[null,{"$f":"IF('Securities Ledger'!B4=\"\",\"\",'Securities Ledger'!B4)","v":"Preferred"},{"$f":"IF(B5=\"\",\"\",'Securities Ledger'!F4)","v":""},{"$f":"IF(B5=\"\",\"\",SUMIF('Securities Ledger'!G8:G121,\"Preferred\",'Securities Ledger'!E8:E121))","v":4000},4000,{"$f":"IFERROR(E5/E8,0)","v":0.8},{"$f":"IF(E5=\"\",\"\",SUMIF('Securities Ledger'!G8:G121,\"Preferred\",'Securities Ledger'!I8:I121))","v":50000}]
[null,"Total Common & Preferred Stock issued and outstanding",null,{"$f":"SUM(D4:D5)","v":5000},5000,{"$f":"IFERROR(E6/E8,0)","v":1},{"$f":"SUM(G2:G5)","v":50000}]
[]
[null,"Totals",null,null,{"$f":"E6","v":5000},1,{"$f":"SUM(G4+G5)","v":50000}]
[]
[]
[null,"[1] This example assumes that Preferred converts into Common Stock at a 1:1 ratio."]