Cap Table with Derivative Instruments, Returns and Charts   Excel template (XLSX)
$35.00

Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Flevy is the marketplace for business best practices.
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Cap Table with Derivative Instruments, Returns and Charts (Excel template (XLSX)) Preview Image
Arrow   Click main image to view in full screen.

Cap Table with Derivative Instruments, Returns and Charts (Excel XLSX)

Excel (XLSX)

$35.00
This model is developed by a former Big 4 and Fortune 100 consultant and enthusiast of financial modeling
Add to Cart
  


Immediate download
Fully editable Excel
Free lifetime updates

BENEFITS OF THIS EXCEL DOCUMENT

  1. A professional template to model investor contributions into a JV startup with a complex structure
  2. Incorporates granular inputs
  3. Produces detailed reports, calculations and charts

PRIVATE EQUITY EXCEL DESCRIPTION

This product (Cap Table with Derivative Instruments, Returns and Charts) is an Excel template (XLSX), which you can download immediately upon purchase.

Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make its first steps. If the business idea proves feasible, there will be the first real funding round ("seed" funding) when the company receives financing from external parties (often referred to as "angel investors").

If, following this round, the company performs well, there can be further drawdowns of external financing to keep the business growing. In most real-life examples there will be up to three rounds (Series A, Series B and Series C), after which the company can go public or be sold to a strategic investor. At each funding round there will be changes in equity shares held by current shareholders based on the amounts contributed by the new investors and the market value of the company.

This template allows to model up to six investment rounds and full exit for up to 12 common-stock investors. It includes key profitability metrics for each investor (IRR, equity multiple and gross return).

The model also includes calculations for a SAFE (simple agreement for future equity), employee stock options and convertible notes.

You can use this cap table to keep track of your investors or to build it into your financial models and analyze financing alternatives.

The table is accompanied by five professionally designed magazine-quality charts showing:

•  changes in company valuation resulting from investor contributions and market value uplifts
•  composition of final equity value by investor and overall equity value increase
•  a snapshot of each investors contributions, distributions and profitability
•  holding period for each investor
•  equity share by shareholder and by investing round

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Private Equity, Financing Excel: Cap Table with Derivative Instruments, Returns and Charts Excel (XLSX) Spreadsheet, Andrei Okhlopkov


$35.00
This model is developed by a former Big 4 and Fortune 100 consultant and enthusiast of financial modeling
Add to Cart
  

ABOUT THE AUTHOR

Author image
Additional documents from author: 35

- Financial Modeling
•  Business Analysis
•  Excel Fundamentals
•  Visual Basic for Applications

Ask the Author a Question

You must be logged in to contact the author.

Click here to log in Click here register

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided best practices to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab




Read Customer Testimonials

 
"My FlevyPro subscription provides me with the most popular frameworks and decks in demand in today’s market. They not only augment my existing consulting and coaching offerings and delivery, but also keep me abreast of the latest trends, inspire new products and service offerings for my practice, and educate me "

– Bill Branson, Founder at Strategic Business Architects
 
"I have found Flevy to be an amazing resource and library of useful presentations for lean sigma, change management and so many other topics. This has reduced the time I need to spend on preparing for my performance consultation. The library is easily accessible and updates are regularly provided. A wealth of great information."

– Cynthia Howard RN, PhD, Executive Coach at Ei Leadership
 
"One of the great discoveries that I have made for my business is the Flevy library of training materials.

As a Lean Transformation Expert, I am always making presentations to clients on a variety of topics: Training, Transformation, Total Productive Maintenance, Culture, Coaching, Tools, Leadership Behavior, etc. Flevy "

– Ed Kemmerling, Senior Lean Transformation Expert at PMG
 
"As a consultant requiring up to date and professional material that will be of value and use to my clients, I find Flevy a very reliable resource.

The variety and quality of material available through Flevy offers a very useful and commanding source for information. Using Flevy saves me time, enhances my expertise and ends up being a good decision."

– Dennis Gershowitz, Principal at DG Associates
 
"FlevyPro provides business frameworks from many of the global giants in management consulting that allow you to provide best in class solutions for your clients."

– David Harris, Managing Director at Futures Strategy
 
"[Flevy] produces some great work that has been/continues to be of immense help not only to myself, but as I seek to provide professional services to my clients, it gives me a large "tool box" of resources that are critical to provide them with the quality of service and outcomes they are expecting."

– Royston Knowles, Executive with 50+ Years of Board Level Experience
 
"As a small business owner, the resource material available from FlevyPro has proven to be invaluable. The ability to search for material on demand based our project events and client requirements was great for me and proved very beneficial to my clients. Importantly, being able to easily edit and tailor "

– Michael Duff, Managing Director at Change Strategy (UK)
 
"As a niche strategic consulting firm, Flevy and FlevyPro frameworks and documents are an on-going reference to help us structure our findings and recommendations to our clients as well as improve their clarity, strength, and visual power. For us, it is an invaluable resource to increase our impact and value."

– David Coloma, Consulting Area Manager at Cynertia Consulting


Your Recently Viewed Documents


Customers Also Like These Documents

Related Management Topics


Private Equity Fundraising Deal Structuring Integrated Financial Model ROI Real Estate Valuation Model Example Entrepreneurship Venture Capital

Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more.