Model the economics of an equity negotiation by connecting an expected exit value, an investor’s required return, the timing of each investment round, and the ownership split between investors and founders.
This Excel workbook is designed for startup funding discussions in which both sides need to see how valuation assumptions and deal terms affect future value, ownership, return on investment (ROI), and internal rate of return (IRR). Users enter the operating and investment assumptions shown in the model, then review calculated results for as many as three investment rounds.
Frame a defensible valuation discussion
Translate forecast annual free cash flow and an exit multiple into an estimated future company value that can anchor a negotiation.
Test investor return expectations
See the future value, ROI, and IRR associated with the required return, investment amount, holding period, and negotiated ownership share.
Track dilution across rounds
Review cumulative investor ownership and the founders’ remaining share as the company moves through up to three financing rounds.
What does the template help you analyze?
The workbook organizes the core assumptions behind a venture-style investment negotiation and makes their financial consequences visible. It is useful for testing a proposed deal before a term-sheet discussion or for comparing alternative combinations of valuation, return target, timing, and equity share.
Estimate future company value. Combine forecast annual free cash flow with a user-entered valuation multiple and exit year.
Model round-specific investment terms. Enter the month of investment, amount invested, required IRR, and investment duration for the first, second, and third rounds.
Calculate the investor’s required future value. See the value the investment must reach to satisfy the stated return requirement over the modeled duration.
Review ownership allocation. Follow cumulative investor share and the corresponding founders’ share as financing rounds are added.
Evaluate negotiated economics by investor. Compare the individual investor’s future value, ROI, and IRR under the entered ownership percentage.
What is inside the workbook?
The visible model is structured around editable assumptions and calculated outputs. Yellow cells identify the deal and valuation assumptions to be entered, while the output rows summarize implied future values, ownership percentages, and investor return measures. The layout keeps the three potential rounds side by side so users can compare their terms without separating the negotiation into disconnected calculations.
Valuation assumptions
Inputs include the exit year, forecast annual free cash flow, and valuation multiple. The workbook uses them to calculate the company’s estimated value at the modeled exit.
Investment-round assumptions
Each round provides fields for investment timing, required IRR, investment amount, duration, and the individual investor’s negotiated share.
Negotiation outputs
Calculated rows show required future value, cumulative ownership, founders’ remaining share, investor future value, ROI, and IRR.
The worksheet places valuation inputs above three financing-round columns, followed by cumulative investor and founder ownership and the negotiated future value, ROI, and IRR for each investor.
See valuation, ownership, and returns in one view
The worksheet connects a proposed exit value to the terms of each investment round. As assumptions change, the related ownership and return outputs can be reviewed in the same table. This helps founders and investors identify whether a proposed equity percentage is consistent with the investment amount, holding period, and target return rather than discussing each term in isolation.
How do you use the template?
Set the exit assumptions
Enter the expected valuation year, forecast annual free cash flow, and valuation multiple to establish the modeled future company value.
Enter investment-round terms
For each applicable round, add the investment month, required IRR, amount invested, and duration of the investment.
Test the ownership proposal
Enter the individual investor’s proposed share and review the cumulative investor share and founders’ remaining ownership.
Review return outputs
Compare the investor’s future value, ROI, and IRR with the required future value implied by the return target.
Refine the negotiation
Adjust valuation or deal assumptions to evaluate another proposal while keeping the relationship between investment, ownership, and return visible.
Who is this template for?
The workbook is suited to startup founders preparing for equity discussions, analysts evaluating proposed financing terms, investors testing target returns, and finance advisers helping both sides understand dilution and exit economics. It is most relevant when the negotiation can be represented through an expected future company value, discrete investment rounds, a target IRR, and an agreed equity share. The model supports negotiation analysis; the quality of its output still depends on the reasonableness of the cash-flow, multiple, timing, and return assumptions entered.
For a second valuation perspective, use the DCF Calculator to examine value through discounted cash flow assumptions. When a financing decision also involves leverage or lender constraints, the Financial Debt Ratios Calculator can help place the equity negotiation alongside debt capacity and coverage considerations.
Choosing a selection results in a full page refresh.
