Summary
Claude in Excel | Sami Miettinen | Neuvottelija +. Sami Miettinen demos how an equity savings account (OST) is converted from a Nordnet portfolio into Excel format. He also calculates the key relative valuation figures EV/EBITDA, EV/Sales and EV/Capital Employed.
Transcript
English transcript derived from validated English subtitles (WebVTT · SRT). Timestamps link to the original video.
00:00 Alright, you wanted to see, among these AI tools, this Claude Excel. So in a way this now makes Excel users either really efficient, or it makes mediocre types really good. I’ll put a portfolio on the line here, so this is this Nordnet equity savings account. It now has a market value of 87,735 euros. Originally 50 grand was put into it, and sure there’s a good return here, but there have been some illogical moves made. I mean I’ve been buying way too many US stocks. They have of course performed very well. There you see Alphabet and Shopify, so 180 percent. But I mean, tax-efficiently it wouldn’t make sense to invest only in British and Finnish stocks, because those US stocks carry a 12 percent withholding tax that doesn’t get refunded in this equity savings account. I could actually code this too, then, um, into Claude Excel here, as a suggestion to sell those tax-inefficient stocks.
01:10 Now let’s go over to the Excel side. Let’s open this Claude in Excel, and this is installed as an Excel add-on. And now I’ll put in here to copy the attached portfolio so that the euro-denominated amount is correct. And the companies’ tickers can also be found from external sources. Pay attention to the exchange rates, Euro, GBP, and USD. Alright, then let’s get this moving. Then we’ll just watch as Claude gets to work.
02:12 So it now notices those exchange rates and starts digging into them. Here, by the way, this Unilever has split these off into that Magnum Ice Cream Company, and it’s been such a small investment that I hadn’t even noticed, but that’s how these are going now. And then here it is, it starts calculating these portfolio values, and since this Nordnet portfolio report doesn’t have quite all the information, for example about the original acquisition cost, it has to, in a way, calculate those itself from that return change there. And then when this exchange rate is still being fixed here, it then has to take that into account too. From there it’s now digging up these figures, and in quite the right direction,
03:15 and yeah, and from there it ended up with nearly the same amount, there, I mean, it could be that there’s that exchange rate rounding, that is, 87,488, wasn’t quite the same as that starting value there, Or then, well, the share prices are only to two decimal places, let’s see. I could go ahead and instruct it there to arrive at exactly the right figure. Yeah, well, it actually noticed it itself, so — yes, thanks. I’m used to being polite to this AI, so I said yes, thank you. And that thanks needed to be added here. Then the calculations run. There, we arrived at that exact figure. Awesome. Well, then that’s a bit of an ugly table. In a way the logic is that the totals are just in black, well, it is what it is.
04:16 Let’s ask it to also add this classic — add a relative valuation table below. Calculate EV/EBITDA, EV/Sales, EV/Capital Employed for each stock using the 2025 consensus forecast. There we go, it starts doing that too now. So this Claude and Microsoft alliance also includes the use of these external data sources, which is absolutely amazing. Here in Translink’s databases we now have, for example, something like S&P Capital IQ, so it could pull these ticker values from there too, which would be a fun demo as well.
05:22 But here now it’s from its own sources, and one of them, among others, is Bloomberg, so it starts calculating these multiples. This is, in investment and investment-banking terms, relative valuation — if this multiple is high, then it may possibly be an expensive stock, and vice versa. Of course you pay for quality, so since here we have some of the world’s best companies, like Alphabet, Shopify, Microsoft and Apple, they do deserve higher multiples than, say, our Nokia or Mandatum or Sampo, not to mention Neste. But this now starts calculating these multiples and then also adds the source and then the median and the average then calculates that for it. Pretty expensive stuff I’ve got, so here as the median
06:23 4.5 times sales, and 16.2 times EBITDA. This is now this kind of thing, I’ve indeed had this kind of wild portfolio, since in principle the idea of this equity savings account is that in it you could take a bit more risk, and because the gain there then isn’t taxed before it’s withdrawn, so like that — and it moves on and then asks these kinds of whether to add, like, reasonable assumptions, that is whether to add price-to-earnings multiples, so let’s put those in, with a yes, thanks, once again — no need to keep thanking it, but I’ve been polite about this. Well but this is Claude in Excel, an absolutely great thing. This indeed gets installed as an add-on here in Excel. And then you need to have this — a Claude license, Pro is enough, but I of course have Max, so there are enough tokens to then do both coding and this kind of Excel work.
07:26 Alright, send feedback and also subscribe to the Neuvottelija channel. Thanks.