Whisky Portfolio

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Current Whisky Holdings
2		MALTS							GRAINS
3	Distillery	DIST TTL LPA	DIST TTL £	MALT - # LPA	Cost/LPA	TTL Cost		Distillery	DIST TTL LPA	DIST TTL £	GRAIN - # LPA	Cost/LPA	TTL Cost
4	Benrinnes	0	£0					Cameronbridge	0	£0
5	Malt, Refill butt 2022 Q1				3.08	0		Grain, Refill hogshead 2021 Q4			0	0	0	Sold 850
6	Malt, Refill butt 2021 Q3				2.76	0		Grain, Refill hogshead 2022 Q1			0	1.26	0	Sold 149 - 23/09/22
7	Blair Athol	0	£0					Grain, Refill butt, 2022 Q2			0	1.26	0	Sold 339 - 23/09/22
8	Malt, Refill hogshead 2021 Q4				2.77	0		North British	0	£0
9	Bunnahabhain	0	£0					Grain, Refill hogshead 2022 Q1			0	1.31	0.00	Sold 300 - 23/09/22
10	Malt, Refill bourbon 2022 Q2				4.72	0
11	Malt, Refill bourbon 2022 Q2				4.71	0		Refill hogshead, 2022 Q2			0	1.31	0	Sold 129 - 23/09/22
12	Malt, Refill bourbon 2021 Q4				2.91	0
13	Dailuaine	0	£0
14	Malt, Refill hogshead 2020 Q1				3.20	0
15	Malt, Refill hogshead 2018 Q1				0.00	0	Sold 65 08/07/22
16	Deanston	0	£0
17	Malt, Refill bourbon 2021 Q2				2.87	0
18	Malt, Refill bourbon 2021 Q4				2.81	0	Sold 350 - 09/09/22
19	Glen Elgin	0	£0
20	Malt, Refill hogshead 2022 Q1				3.08	0
21	Malt, Refill hogshead 2021 Q3				2.76	0	Sold 350 - 23/09/22
22	Glenlossie	0	£0
23	Malt, Refill hogshead 2021 Q4				2.77	0	Sold 350 - 21/09/22
24	Malt, Refill hogshead 2022 Q1				3.08	0
25	Glen Moray	0	£0
26	Malt, Refill bourbon 2022 Q2				2.99	0
27	Malt, First fill bourbon 2018 Q4				0.00	0	Sold 50 - 08/07/22
28	Malt, Refill bourbon 2021 Q4				2.66	0
29	Glen Spey	0	£0
30	Malt, Refill bourbon 2018 Q1				0.00	0	Sold 50 - 08/07/22
31	Inchgower	0	£0
32	Malt, Refill hogshead 2017 Q4				4.33	0
33	Malt, Refill hogshead 2021 Q3				2.76	0
34	Malt, Refill hogshead 2021 Q4				2.77	0	Sold 350 - 23/09/22
35	Malt, Refill hogshead 2022 Q1				3.08	0
36	Kirkcowan	0	£0
37	Malt, Rfill Sherry Hogshead 2022 Q1				3.64	0
38	Kirkinna	0	£0
39	Malt, Firstfill bourbon 2022 Q2				3.76	0
40	Ledaig	0	£0
41	Malt, First fill bourbon 2021 Q3				3.61	0
42	Linkwood	0	£0
43	Malt, Refill hogshead 2021 Q4				2.77	0	Sold 350 - 09/09/22
44	Mannochmore	0	£0
45	Malt, Refill hogshead 2021 Q3				2.76	0
46	Nethermill	0	£0
47	Malt, Refill hogshead 2018 Q2				3.96	0
48	Strathenry	0	£0
49	Malt, Refill bourbon 2022 Q1				2.72	0
50	Malt, Refill bourbon 2019 Q1				3.25	0
51	Strathmill	0	£0
52	Malt, Refill bourbon 2018 Q4				3.82	0
53	Teaninich	0	£0
54	Malt, Refill hogshead 2018 Q4				3.80	0
55	Tobermory	0	£0
56	Malt, Refill bourbon 2022 Q1				5.01	0
57	Tullibardine	0	£0
58	Malt, Refill bourbon 2022 Q2				3.01	0
59	Malt, Refill hogshead 2022 Q1				3.01	0
60	Malt, First fill bourbon 2019 Q3				3.55	0
61	Malt, First fill bourbon 2021 Q2				3.07	0
62	Malt, First fill bourbon 2021 Q4				2.87	0	Sold 254 -28/09/22
63
64
65			MALTS # LPA	Avg £ Per LPA	Total Malt Cost			GRAINS # LPA	Avg £ Per LPA	Total Grains Cost		TOTAL LPA	0
66			0	#DIV/0!	£0.00			0	#DIV/0!	£0.00		TOTAL COST	£0.00
67
68	Date	Malt £	Grain £	Cash £	+/- Capial	Total Invested £	Total Acct Value £	Profit/Loss £	Profit %
69	08/2021	1,960.60	0.00	2.85	2,000.00	2,000.00	1,963.45	-36.55	-1.86%
70	09/2021	2,007.36	0.00	20.90	27.57	2,027.57	2,028.26	0.69	0.03%
71	10/2021	5,864.39	0.00	209.35	4,134.33	6,161.90	6,073.74	-88.16	-1.45%
72	11/2021	8,230.91	0.00	89.13	2,218.10	8,380.00	8,320.04	-59.96	-0.72%
73	12/2021	12,507.60	892.50	244.75	5,000.00	13,380.00	13,644.85	264.85	1.94%
74	01/2022	14,863.30	892.50	1.68	2,050.00	15,430.00	15,757.48	327.48	2.08%
75	02/2022	15,465.25	998.75	392.92		15,430.00	16,856.92	1,426.92	8.46%
76	03/2022	18,011.23	1,491.35	254.40	1,500.00	16,930.00	19,756.98	2,826.98	14.31%
77	04/2022	19,125.34	813.75	332.48	300.00	17,230.00	20,271.57	3,041.57	15.00%
78	05/2022	20,620.42	822.67	2.27	1,075.00	18,305.00	21,445.36	3,140.36	14.64%
79	06/2022	22,563.54	1,232.47	-0.52	500.00	18,805.00	23,795.49	4,990.49	20.97%
80	07/2022	21,871.59	1,247.81	1,211.61	0.00	18,805.00	24,331.01	5,526.01	22.71%
81	08/2022	22,705.28	1,294.24	-33.15	-1,000.00	17,805.00	23,966.37	6,161.37	25.71%
82	09/2022	20,384.54	0.00	43.34	-4,268.00	13,537.00	20,427.88	6,890.88	33.73%
83	10/2022	0.00	0.00	18.37	-22,030.91	-8,493.91	18.37	8,512.28	55.99%
86						-8,493.91		XIRR %	55.99%
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102