Spice Portfolio.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1
2
3
4			Portfolio Dashboard
5		Discount Rate	10%
6	Include 1/0	Projects		Phase Starts					Cost $M				Probability of Success				Sales parameters					KPI's
7	Include 1/0	Project name	current phase	Ph1	Ph2	Ph3	Reg	Launch	Ph1	Ph2	Ph3	Reg	Ph1	Ph2	Ph3	Reg	PYS	Time to peak	COGS	M&S	LOE	Project	launch Date	Launch Year	Prob. Of Launch	NPV	Cost to Launch	Nominal CTL
8	1	Anise	PH3			4-Apr-21	7-May-24	23-May-25			140	15	100%	100%	65%	90%	750	3	5%	8%	25-Oct-29	Anise	23-May-25	2025	59%	512.82	106.35	116.02
9	1	Basil	PH2		2-Feb-23	18-Jun-24	10-Oct-25	18-Sep-26		42	150	12	100%	50%	80%	95%	500	4	5%	8%	21-Nov-29	Basil	18-Sep-26	2026	38%	30.69	96.93	121.80
10	1	Caper	PH1	22-May-22	5-Jun-23	12-Sep-25	4-Apr-28	17-Feb-29	10	35	200	15	70%	30%	65%	90%	800	5	5%	8%	6-Nov-33	Caper	17-Feb-29	2029	12%	3.19	56.78	78.55
11	1	Cardamom	PH1	10-Dec-21	30-Oct-23	15-Nov-25	15-Sep-27	31-Jul-28	10	60	250	20	60%	45%	70%	90%	600	4	5%	8%	13-May-32	Cardamom	31-Jul-28	2028	17%	4.04	82.45	116.96
12	1	Cinnamon	PH1	15-Sep-22	12-Nov-23	3-Feb-26	16-May-29	18-Mar-30	8	27	400	12	70%	50%	55%	90%	900	1	5%	8%	13-Oct-36	Cinnamon	18-Mar-30	2030	17%	142.24	104.01	169.21
13	1	Coriander	PH2		3-Mar-23	8-Aug-24	13-Sep-27	22-Jul-28		40	255	8	100%	35%	85%	90%	1200	2	5%	8%	16-Jan-33	Coriander	22-Jul-28	2028	27%	383.75	96.91	131.63
14	1	Dill	PH3			27-Apr-22	3-Jun-24	21-Jan-26			200	10	100%	100%	80%	90%	750	5	5%	8%	18-May-33	Dill	21-Jan-26	2026	72%	756.29	188.92	208.00
15	1	Fennel	PH1	30-Nov-22	4-Feb-24	3-Jan-25	12-Oct-26	22-Dec-28	15	60	180	13	60%	35%	65%	95%	750	3	5%	8%	28-May-33	Fennel	22-Dec-28	2028	13%	56.60	70.01	90.57
16	1	Garlic	PH2		5-Jun-22	19-Dec-23	19-Dec-25	24-Dec-26		30	309	20	100%	50%	65%	90%	700	1	5%	8%	29-Dec-30	Garlic	24-Dec-26	2026	29%	209.98	151.75	190.98
17	1	Ginger	REGISTRATION				4-Oct-22	25-Dec-23				12	100%	100%	100%	90%	350	4	5%	8%	20-Feb-28	Ginger	25-Dec-23	2023	90%	586.67	11.04	12.00
18	1	Jasmine	PH1	5-Jun-22	7-Aug-23	28-Aug-25	3-Nov-27	14-Jan-29	12	50	250	14	60%	35%	70%	90%	750	2	5%	8%	27-Feb-34	Jasmine	14-Jan-29	2029	13%	63.32	70.28	96.56
19	0	Lavender	PH2		22-Sep-21	12-Nov-24	12-Jan-27	17-Nov-27		46	388	15	100%	35%	80%	90%	1300	5	5%	8%	14-Jan-35	Lavender	17-Nov-27	2027	0%	0.00	0.00	0.00
20	0	Mint	PH1	8-Jan-23	3-Dec-23	19-May-25	12-Dec-27	1-Nov-28	10	33	316	12	55%	35%	65%	88%	1500	6	5%	8%	15-Aug-36	Mint	1-Nov-28	2028	0%	0.00	0.00	0.00
21	0	Nutmeg	PH3			17-Oct-21	5-Dec-23	31-Oct-24			282	8	100%	100%	77%	90%	750	3	5%	8%	17-Jan-31	Nutmeg	31-Oct-24	2024	0%	0.00	0.00	0.00
22	0	Paprika	PH1	11-Jul-22	8-Oct-23	23-Oct-25	1-Dec-28	19-Jan-30	11	22	214	9	60%	35%	65%	90%	500	1	5%	8%	2-May-33	Paprika	19-Jan-30	2030	0%	0.00	0.00	0.00
23	0	Saffron	PH2		25-Aug-22	5-Jun-24	17-Jul-28	31-Aug-29		45	201	6	100%	35%	55%	95%	750	3	5%	8%	18-May-37	Saffron	31-Aug-29	2029	0%	0.00	0.00	0.00
24	0	Thyme	PH1	3-Apr-22	30-May-23	6-Nov-24	19-Dec-27	2-Feb-29	15	35	382	10	65%	35%	65%	90%	750	2	5%	8%	8-Jul-36	Thyme	2-Feb-29	2029	0%	0.00	0.00	0.00
25																							Portfolio NPV $M			2749.58
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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73				2022	2023	2024	2025	2026	2027	2028	2029	2030	2031	2032	2033	2034	2035	2036	2037	2038	2039	2040
74			On Market Sales	1500	1480	1450	1260	1080	840	620	410	250	110	0	0	0	0	0	0	0	0	0
75			Target	1500	1522.5	1545.3375	1568.517563	1592.045326	1615.926006	1640.164896	1664.767369	1689.73888	1715.084963	1740.811238	1766.923406	1793.427257	1820.328666	1847.633596	1875.3481	1903.478321	1932.030496	1961.010954
76			Dev Cost Budget	280	282.8	285.628	288.48428	291.3691228	294.282814	297.2256422	300.1978986	303.1998776	306.2318764	309.2941951	312.3871371	315.5110084	318.6661185	321.8527797	325.0713075	328.3220206	331.6052408	334.9212932
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100