Private Company Valuation & IPO Pricing Simulator

1. Assumptions

Current Revenue ($)

Current EBITDA ($)

Current Net Income ($)

Current Cash & Equivalents ($)

Total Debt ($)

Current Shares Outstanding

Projection Years

Annual Revenue Growth Rate (%)

Target EBITDA Margin (%)

Tax Rate (%)

CAPEX as % of Revenue (%)

Change in NWC as % of Revenue (%)

Risk-Free Rate (%)

Market Risk Premium (%)

Levered Beta

Cost of Debt (%)

Equity % in Capital Structure (for WACC)

Terminal Growth Rate (DCF) (%)

Comparable EV/EBITDA Multiple (x)

Comparable P/E Multiple (x)

Private Company Discount (%)

DCF Weight in Blended Valuation (%)

Capital to Raise in IPO ($)

Underwriting Fees (% of Capital Raised)

Approx. % of Company to Sell in IPO