Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
  • Cap Table Excel Model
Originally published: 23/03/2017 13:24
Last version published: 12/06/2018 15:47
Publication number: ELQ-92315-3
View all versions & Certificate
certified

Cap Table Excel Model

An Excel Cap Table and Exit Waterfall for Entrepreneurs

cap tablecapitalizationcapitalization tableexit analysisexit waterfallstartupsvaluationventure capital

Description
Create a capitalization table through multiple rounds of investments, and forecast how investment rounds impact ownership, dilution, valuations, and distribution of proceeds to entrepreneurs and investors through a detailed exit waterfall.

Includes a core capitalization table, exit waterfall, and cap table summary that can be used by a company to model their cap table over time.

Contains a series of instructional sheets explaining how to issue equity, how to create an option pool (premoney and postmoney), how to issue and convert a convertible instrument (with three different conversion methods), how to create an exit waterfall (and showing how different types of liquidation preferences impact the distribution of proceeds), and how to value a company through multiple rounds of investment, helping teach how cap tables work so you can build your own specific to your situation if needed.

(More details and instructional videos at https://foresight.is/learn/cap-table-overview )

Used by investors, founders, executives — CEO, CFO, COO, VP of Finance — or advisors, mentors, or consultants to build a cap table of exit waterfall for an idea-stage, pre-seed, seed, A, or B stage company.

Standards-based, extensively tested and used by thousands of companies across a wide variety of business types, revenue models, and needs.

All cells and formulas are unlocked for editing and transparency, add on or edit for your specific situation.

Built by a professional financial modeler with experience as an investor and running forecasting inside startups. Responsive, personal support — chat, call, or email — and available for custom services.

This business tool includes
1 Excel Cap Table Template Workbook

Taylor Davidson offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

Forecast how rounds of financing impact ownership, valuation, dilution, and exit proceeds. Provide an integrated, working cap table and exit waterfall that companies can use across a wide variety of capitalization situations. Provide a set of simpler instructional tools that focus on teaching users how to issue equity rounds, how to convert convertibles, and how to issue option pools.

Startups raising investment funds through equity, convertible notes or SAFE. Investors looking to value prospective investments.

Reviews

  • Marko Krneta(last updated: 18/07/2018 13:18)
  • Alycia Purcell(last updated: 13/07/2018 14:05)
  • Ana Clara Cavalcante(last updated: 11/07/2018 01:24)
  • Maggie Norris(last updated: 28/06/2018 04:15)
  • Will Drummond(last updated: 26/06/2018 22:47)
  • Wenyuan ZHOU, CFA(last updated: 20/06/2018 09:01)
  • Saminathan Subramania panchapakesa(last updated: 19/06/2018 16:47)
  • Xavier Barata Teixidó(last updated: 18/06/2018 12:16)
  • Metman82(last updated: 14/06/2018 11:59)
  • Edwin Contreras(last updated: 13/06/2018 13:08)
  • Maurice van Sabben(last updated: 01/06/2018 23:04)
  • Milan Nayani(last updated: 01/06/2018 13:28)
  • Martin Randolph(last updated: 31/05/2018 02:28)
  • Luis Fernando Sánchez Villena(last updated: 15/05/2018 09:08)
  • K.M.FARHAD ALAM(last updated: 14/05/2018 09:12)
  • Santino Letizia(last updated: 08/05/2018 22:03)
  • William Böll496(last updated: 13/04/2018 13:32)
  • Spencer Brown(last updated: 03/04/2018 23:12)
    Easy to use and great for modeling investment
    Awesome tool. Easy to use. I have looked at a lot of cap tables including creating my own but to be able to model the different investment options this is the best (easiest) that I have seen out there. Thanks Taylor!
  • Cristian Lorenzetto(last updated: 02/04/2018 08:37)
  • Sandeep Maoh(last updated: 15/03/2018 14:36)
    Very good
    It's well explained. Thanks!
  • Putra Kesuma(last updated: 07/03/2018 09:43)
  • Angela Kahn(last updated: 08/02/2018 12:59)
  • Ron Sheridan(last updated: 15/12/2017 16:58)
    Found and achieved exactly what I needed.
    I urgently needed to be able to model Cap Table scenarios internally and the with a prospective investor for my startup.Taylor's Cap table model was perfect and I was able to reach out to Taylor and engage his services to help me answer questions I had and gain deeper insight into the subject matter.
  • Didzis Silis(last updated: 15/12/2017 07:52)
    Great
    A great and very useful tool!
  • Aaron Lane(last updated: 21/11/2017 06:59)
    So easy to understand - thanks
    Thanks for the video and very useful tool - makes a potentially complex process very easy.
  • Jianping Wu(last updated: 01/11/2017 11:24)
    Very Helpful Cap Table!
    It was a very helpful Cap Table Excel Worksheet helping me a lot for my raising capital assignment. I Learned so much! Thanks a lot Taylor!
  • Tianyao(Michelle) Xiao(last updated: 04/10/2017 22:14)

keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Cap Table Excel Model

The user community and author are here to help. Go ahead!

  • Didzis Silis
    Hi Taylor,

    thanks for building and sharing this - a great and very useful tool!

    I just wanted to clarify a minor issue regarding the formula in Cell V32 (Sheet 'Cap Table') - for 'Options - Granted' in 'Series A - Equity' round.
    This formula refers to I33+I34. However, in 'Series B - Equity' round the same formula (in Cell AC32) refers to X33+X34 (not V33+V34).
    Should then the formula in Cell V32 also be corrected from I33+I34 to K33+K34 (to have the same logic as in all subsequent rounds)?
    This perhaps does not have any real impact, but I still wanted to share with you, just in case :)

    Best,
    Didzis
    1arrow_drop_uparrow_drop_downReply reply
    • Taylor Davidson
      Hi!

      It could be changed, but for all practical purposes it will have no impact. The difference between column I and K is that I are the options impacts that happen in that round, K are the total for all rounds. Since the way the model is structured, the first time to create an option pool is in that first round, I and K will be the same anyway (meaning the way it is setup, the things that happen in that round are the same as the total, so I should = K), so for 99% of uses it won't matter whether the formula draws from I or K. Obviously, if you were to use this and change how the option pool works around the "Founding" and initial setup, then you'd want to revisit the formulas to see if any edits were necessary.

      But to be complete, sure, it could be changed to draw from K instead of I.


      Thanks!
      arrow_drop_uparrow_drop_downReply reply
      • Didzis Silis
        Thanks a lot for the quick confirmation!

        One more question, if I may:
        the Postmoney Valuation formula for Seed Round (Cell D51) states that IF 'Premoney Valuation' = 0, then 'Postmoney Valuation' will in all cases be = 0 too. Is there any particular reason for this? Why is the Postmoney Valuation formula simply not = 'Premoney Valuation' + '$ invested' (as for all subsequent Rounds)?
        arrow_drop_uparrow_drop_downReply reply
        • Taylor Davidson
          It's just a way to test to see if there should be a postmoney valuation; if the round is debt (SAFE or note, for example), then there would be a raise amount, and premoney and postmoney valuation should be zero (since there's no valuation, there's just a note with a cap and other terms). If the formula was just raise + premoney, then with a debt round it would output a postmoney valuation = the raise amount, which isn't true, because there really isn't a postmoney valuation. It could be accomplished in other ways, say an if statement for the type of round, and output zero for the postmoney valuation if it's not an equity round. Make sense?
          arrow_drop_uparrow_drop_downReply reply
        • Taylor Davidson
          Btw, if you're looking in depth in the formulas, one of these days I'm going to unpack the waterfall calcs (H77 to H84) to make it more transparent what's going on :)
          arrow_drop_uparrow_drop_downReply reply
    • Juan Jose Rosas
      Hi Taylor,

      Im new using Cap Tables and I have a question: What if the investment round is both equity and convertible note? Basically some investors do equity and some do convertible note.

      Thank you,
      Juan Jose
      arrow_drop_uparrow_drop_downReply reply
      • Taylor Davidson
        Meaning, they do convertible note and equity in the same round? There's lots of reasons to do equity and debt in the same round, practically speaking, I've never seen equity and convertible notes in the same round. You could do them around the same time, but they would likely be separate rounds.

        That said, you could use the current structure for equity and convertible notes in the first round, just by inputting some investors as equity and some as debt, and changing the postmoney valuation so that it only reflected the premoney + the equity fundraise; it would largely work, albeit with other little changes so the math flowed through.
        arrow_drop_uparrow_drop_downReply reply
      please wait...