This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Round
A
B
C
D
E
Sale/IPO
Year
Investment ($k)
Pre-money enterprise value ($k)
Post-money enterprise value ($k)
Pure Equity
Founders holdings
Founders value ($k)
Debt + Equity
% debt financing
Amount of debt ($k)
Net amount of equity ($k)
Debt + equity invested ($k)
Total debt outstanding ($k)
Cost of debt ($k)
Cumulative interest ($k)
Post-money equity value ($k)
Founders holdings
Founders value ($k)
Interest Rate (%)
Pure Equity
Debt + Equity
Cost of equity
Cost of debt
0
Total cost
Sale/IPO value
Less: outstanding debt
0
Founders net proceeds
Print