ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Company: BD technologies
2
All sums in $ 000'
3
4
Year
5
Stage of developmentR&DSalesSalesSalesSalesSales
6
Project year123456
7
8
Benefits
9
Sales ($ 000')0,00100,00250,00320,00550,00700,00
10
Total benefits ($ 000')0,00100,00250,00320,00550,00700,00
11
12
Costs ($m)
13
Development costs50,0050,00
14
15
OverheadsCOGGs10%10,0025,0032,0055,0070,00
16
S&M25%25,0062,5080,00137,50175,00
17
Incremental G&M3%3,007,509,6016,5021,00
18
19
Patent maintenance costsTotal for all patents3,005,0010,0010,0010,0010,00
20
21
22
Total costs ($ 000')53,0093,00105,00131,60219,00276,00
23
24
Contribution ($ 000') = Benefits - Costs-53,007,00145,00188,40331,00424,00
25
26
Discount factors10,0%1,000,910,830,750,680,62
27
Risk Factors
28
29
DCFs-53,006,36119,83141,55226,08263,27
30
31
Prob. of reaching this point (%)80%80,00%80,00%80,00%80,00%80,00%80,00%
32
Risk Adjusted contribution ($000')-42,45,6116150,72264,8339,2
33
raDCFs ($m)-42,405,0995,87113,24180,86210,62
34
35
36
37
Net Present Value ($000') to year 5 of sales
704,09
38
Expected Net Present Value to year 5 of sales
563,28
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
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