When valuing anything for probate, it’s all about the value on the date of death. In this post we’ll take you through, step-by-step, how to value shares on the stock exchange. To do this, we’ll need the highest and lowest prices on the date of death. After that, there is a simple calculation to do which we describe below.
We’ll use the example of 500 shares in BT (British Telecom) for someone that died on the 24th of June 2022.
Type the name of the company into Google with the words ‘share price’ after it. This should bring up its share profile where you can find their legal name. For BT, you can see they are listed as ‘BT Group’.
Type the name into the search box of the Yahoo Finance website and select the correct option.
You’ll notice on the right hand side it says ‘LSE’ - this is the ‘London Stock Exchange’. Some companies are listed on multiple stock exchanges, so it’s important to get the right one. If you’re unsure which stock exchange to use, it should say it on the share certificates you have.
Alternatively, contact the company that manages the registration of the company’s shares. There are 3 main companies that do this: Equiniti, Computershare, and Link Asset Services.
After clicking on the correct company in the search results above, you’ll land on the company’s share price page. Click on ‘Historical data’ - you may have to scroll down a bit to see this.
Use the date selector to select the date of death and the following day (make sure you have the correct year as it will usually be set a year earlier by default).
If the date of death was on the weekend, select the Friday and Monday on either side - you may use the lower of the two days’ price in your calculations below. Click the blue ‘Apply’ button when you’ve selected the correct dates.
To calculate the share price to use in your inventory, you need to work out what’s known as the ‘quarter-up’ price. This is the lower price, plus one quarter of the difference between the higher and lower prices.
In our example, to calculate the quarter-up price, you would:
So, the quarter-up price is 185.475p. This should be rounded to 185.48p.
To calculate the value of the shares, we multiply the number of shares by the share price. 500 x 185.48p = 92740p. The answer is in pence so we convert it to pounds by dividing by 100 to get £927.40.
When entering shareholdings into the inventory page of your C1, it’s best to list them under the company that manages the registration of the shares as it is to them that you need to show the probate/confirmation document to. There are 3 main companies that do this: Equiniti, Computershare, and Link Asset Services.
Filling in the C1 form can be a fiddly business. This is made worse because the official guidance from the Sheriff Courts and HMRC is ambiguous and incomplete. The Sheriff Courts are also incredibly strict about the wording and layout of the forms (standards that they don’t share with the public).
We can help you complete the forms with our Probate Support Service, which includes:
My Probate Partner is the trading name of DIY Executor Ltd. Company number SC612617.
Registered Address
5 South Charlotte Street, Edinburgh, EH2 4AN
Please note: we do not accept post at this address.
Please email us instead.