Financial Model: Various Rounds of Investment Affecting Ownership, Waterfall Analysis, and IRR/Return Multiple Analysis

Excel Financial model for entrepreneurs looking to raise capital

financial modelfinancial returninvestmentraising a seedwaterfall analysis

First time entrepreneurs often don’t understand how ownership of their company changes with each round of capital raised and how capital is distributed to investors and founders in the event of an acquisition or liquidation. Below is a financial model that your startup can use to understand the key concepts when raising capital and whether your startup is a good candidate for venture capital (IRR’s for investors need to be at or north of 30%).

This Financial Model Demonstrates:

-> Various rounds of investment affecting ownership using pre-money and post-money valuations.

-> Raising a Seed Round: Using a Valuation Cap and/or a Discount that converts into the Series A round.

-> Waterfall Analysis: Preferred Stock Return with liquidation preferences vs. Common Stock Return.

-> Anti-Dilution Rights: How ownership changes in the event of a down round with anti-dilution protection for investors.

-> Full-Rachet Anti-Dilution vs. Weighted Average Anti-Dilution.

-> IRR / Return Multiple Analysis: Given an acquisition/liquidation, what is the financial return to investors vs. founders?

- J. Skyler Fernandes

This business tool includes
1 Excel Template

J. Skyler Fernandes offers you this business tool for free!

Download for free



  • No review yet!

Any questions on Financial Model: Various Rounds Of Investment Affecting Ownership, Waterfall Analysis, And IRR/Return Multiple Analysis?

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

please wait...