StartupTools - Black-Scholes

	A	B	C
1	Black-Scholes Model Warrant Value Calculation
2
3	This spreadsheet is a part of Warrant Guide for Swedish Startups by Erik Byrenius at www.startuptools.org
4	The document is in view-only mode. To edit it, make a copy (File > Make a copy) and play around with the copy.
5
6	Disclaimer: This document contains general information, which is not advice, and should not be treated as such.
7	The information is provided "as is" without any representations or warranties, expressed or implied.
8
9		Edit blue cells
10	Input Values
11	Current Company Valuation	10,000,000
12	Current Number of Shares	5,000,000
13	Current Share Price	2.00
14	Strike Price	4.00
15	Expiry Date (Years From Today)	5.00
16	Compounded Risk-Free Interest Rate	1%
17	Volatility	32.50%
18	Number of Warrants	100,000	(corresponds to 2% pre-dilution = 1.96% post-dilution)
19
20	Premium (total amount to pay by employee)	20,000.00
21	Premium per warrant (used in documents)	0.20
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56	Internal B&S Formula Parameters (Ignore)
57	Strike Price in Present Value PV(EX)	3.8049
58	Volatility * sqrt(Time)	0.7267
59	d1	-0.5216
60	d2	-1.2484
61	Delta N(d1) Normal Cumulative Density Function	0.3010
62	Bank Loan N(d2)*PV(EX)	0.4031
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100