Forum Topics StockVal
Rick
2 years ago

Separating wheat from the chaff?

9141c8dc62f7ac855c5e91174abccecf32829b.jpeg

What do you use as your first filter when adding a new business to your portfolio?

For me it’s simple…Return on Equity (ROE). From my time on Strawman I realise the first filter is very different for each investor. For some it might be ‘a long runway for growth’ and for others ‘the next big thing’. For some it might be very low risk business with a good fully franked dividend?

For the largest part of my investment decisions ROE is the first cut, and the higher the ROE the better! So I start by looking for businesses where analysts are forecasting ROE to be more than 20% in the foreseeable future. However, not all my investments IRL have forecast ROE greater than 20%!

There are plenty of businesses on the ASX that have ROE greater than 20%, so it shouldn’t be that hard for me to load up my portfolio…Right?

Well, it seems everybody wants a business with a very high ROE and generally none are cheap. So the question is, what is a fair price to pay for a business based on its future ROE?

I heard recently that Buffet said something like: if you hold onto a business for long enough YOUR returns get closer to the ROE of that business. I haven’t proved this but It does makes sense to me.

Let’s do a few examples for businesses that reinvest all their earnings at different ROEs using an online compound interest calculator.

To make it really simple we will invest $1 for 10 years at five different ROEs ( 5%, 10% , 20%, 40%, 80%) allowing the net profits to compound annually at the same ROE.

Here are our total returns after investing $1 for 10 years:

At 5% interest = $1.63

At 10% interest = $2.59

At 20% interest = $6.19

At 40% interest = $28.93 and

At 80% interest = $357.05

a10135827d853ae07e4074c8fde1a837e7496f.jpeg

Example of $1 invested at ROE of 5% for 10 years https://www.calculatorsoup.com/calculators/financial/compound-interest-calculator.php

Now I haven’t found too many banks that will pay me 5% interest on my investment, let alone 80%. But I do know there was at least one business on the ASX with a ROE of over 90% in FY22 (Lovisa, ASX:LOV). What’s more, analysts are forecasting earnings that will put Lovisa’s ROE over 100% going forward?

Now, if investing were only that simple I could put all my money in Lovisa and let it compound forever!

OK, let’s look at Lovisa with its big ROE of > 90%. This represents over 90% return on YOUR EQUITY in the business (Book Value). Yesterday you could have bought one Lovisa share for $22.73. How much equity do you get in Lovisa for your $22.73 per share? Just $0.60, yes that’s right, 60 cents per share! So there’s the catch!

There is so much completion in the market to own a high quality, well-run business that investors are willing to pay 38 TIMES the EQUITY they will own in Lovisa. The million dollar question…Is Lovisa worth 38 times Equity. What multiple of the Book Value in Lovisa can you afford to pay and still get a very good return? What is a really good return on your investment? What are the risks if Lovisa’s ROE drops to 70%? So many questions. Too many questions to explore before breakfast…and I need to oil our deck this morning! But, I WILL BE BACK in the near future to explore some of these questions.

Cheers,

Rick

Disc: I sold all my Lovisa shares recently…but perhaps I should have held?

20

Rick
2 years ago

Hi @Dutchy…the steps are all stained, I’ll tackle the deck another day!

In relation to ROE and BV, I think there is one obvious truth.

In most cases a business is only worth more than its BV if the ROE is higher than YOUR required rate of return.

I think with interest rates on the rise, we should be looking for at least a 10% to 15% return, better still closer to 20%, as a target. So we need a business with at least double digit ROE.

Lets say we are happy with a 10% return on our investment. ANZ is an example of a business that has averaged ROE of about 10% and analysts are forecasting about 10% ROE going forward.

The BV for ANZ was $22.40 at end September 2021. The valuation will be slightly higher than BV because the dividends are fully franked.

To make these adjustments for dividends and franking I rely on McNiven’s StockVal formula:

V = (APC/RR x RI + D)/RR x E

Where:

APC = Adopted Performance Criteria (I use forecast ROE)

RR = Your Required Rate of Return (say 10%)

RI = Reinvested Income, portion of APC (For ANZ = 0.4 x10 is the reinvested component)

D = Dividends, portion of APC and grossed up for franking credits (ANZ = 0.6 x 10/0.7) is the franked dividend value. )

E = Shareholder Equity or Book Value (ANZ = $22.40)

For ANZ:

V = (10/10 x 0.4 x 10 + 0.6 x 10/0.7)/10 x $22.40

= 1.257 x $22.40

= $28.16

(I have a spreadsheet for this)

Today ANZ closed at $23.84. About reasonable value given the bad loan risks going forward.

For interest sake, Suncorp has a Forecast ROE of 9.3% including the insurance component. I can’t see any improvement in ANZ’s ROE coming from the Suncorp acquisition!

And as for Lovisa, valuation based on a required return of 10%:

StockVal = $20 using a forward ROE of 90%, and $28.38 on a forward ROE of 110% (forecast by some analysts). If the ROE dropped to 70% Lovisa would be worth $13.

The share price is way up there at $23.25 (today). The risk versus reward is too high for my liking, which is why I sold.

10
Rick
2 years ago

I’ve just put together a spreadsheet for the McNiven StockVal formula. @PortfolioPlus asked if I had one. I do now (screenshot below).

If you would like to try it, please DM me with your email and I will share a time limited OneDrive link so you can download and try it. The grey columns contain formula so don’t change these. Some of the grey columns are hidden. You can play around with all the other columns including the Required Annual Return so that the current valuation matches the current price. I usually start with a Required Annual Return of 10% which is generally my minimum buy requirement.

cheers

Rick

03b88675f8adf81b82304331d4426295116ddf.jpeg

11

Macca571
2 years ago

Thankyou for sharing Rick. I would love to try this, but not sure how to "DM" you with my email. Would you mind clarifying.

Regards Macca

5

Rick
2 years ago

Hi @Macca571, There have been quite a few requests for the Valuation spreadsheet. It might be easier if I just put the link up here: https://1drv.ms/x/s!AopyjBLFeffngoNmZA6o0GEbYhnNKw 

The link is view only, but I am hoping you can download and use it. Let me know if you have any problems. There are some instructions on the second sheet.

Cheers,

Rick

9