Cap Table & Fundraising Model v2.0 — Professional Edition | SAFEs, Vesting, Exit Waterfall, Anti-Dilution | 20 Tabs
The most comprehensive cap table model on the market. 20 tabs. 20 integrity checks. Zero circular references.Built by finance professionals for founders who are serious about fundraising. If you're raising a Seed, Series A, or Series B round — or preparing for an exit — this is the model your investors expect you to have. --- WHAT'S INCLUDED: 20 TABS --- CORE ENGINE: Assumptions, Scenarios (Base/High/Low), Rounds (Pre-Seed to Series B + Bridge), Pro-Forma per-round snapshot. EQUITY & OWNERSHIP: Cap Table (shares, % FD, value, MOIC), Dilution waterfall, Option Pool with pool shuffle attribution. INSTRUMENTS & TERMS: SAFEs & convertible notes (MFN, pro rata, interest accrual), Share Class Terms (liquidation preference, participation cap, seniority, pay-to-play, dividends), Anti-Dilution (weighted average AND full ratchet). PEOPLE & COMPENSATION: Vesting engine (cliff, monthly, single/double-trigger acceleration, revesting), ESOP Grants (20-row ledger with hiring plan, pool burn rate, exhaustion date). EXIT & RETURNS: Liquidation preference waterfall at 5 exit values, MOIC and IRR by investor class, stacked bar chart visualization.SCENARIO PLANNING: What-If simulator, 2D Sensitivity Matrix (pre-money x raise → investor %, PPS, founder %) — 3 tables, 25 scenarios each. QUALITY & DILIGENCE: 20 error checks (PASS/FAIL), clean Export View for investor handouts, Change Log for audit trail, Cover/Dashboard with KPI cards. --- KEY FORMULAS --- Option Pool Shuffle (closed-form, zero circular references)SAFE Conversion: MIN(Cap / Pre-money FD Shares, Round PPS x (1 - Discount%))Weighted Average Anti-DilutionVesting with cliff and accelerationIRR approximation (CAGR method) All formulas include Explain This comments — hover any key cell for a plain-English explanation. --- FILE DETAILS --- Format: Microsoft Excel (.xlsx)Compatible with Excel 2016+ and Excel 36520 tabs, fully unlocked — customize for your companyInstant download after purchaseBuyer FAQQ: Does it work in Google Sheets?A: Best in Excel. Most features transfer to Google Sheets, but some chart and conditional formatting may not render perfectly.Q: What does 'no circular references' mean?A: Most cap table models break because the option pool depends on total shares, and total shares depends on the pool. This model uses a closed-form algebraic formula that solves it directly — no iteration needed.Q: Can I use this for investor due diligence?A: Yes. The Export View tab produces a clean, print-ready investor handout. The Change Log lets you document every change for diligence purposes.
Get it → furnish7.gumroad.com