ABCDEFGHIJKLMNOPQRSTUVWXYZ
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 Rate1%
17
Volatility32.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 Function0.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