RE: Craig.....28 May 2021 09:54
Vas,
I have amended my previous calculations to extend through to end of June 2022.........
RNS states 2,000 stores in April (end of). Expected 3,500 by July (lets assume end of July) so adding 500 stores per month (which I believe is in line with previous RNS). And lets also assume continue to add 500 stores per month till June 2022, total 9,000 stores (I am not 100% sure when the 10,000 target number is expected to be hit).
Working on your two units per day (30 days per month) per existing store and each new store takes a cabinet of 48 units......
June 2,500 existing @2 units per day @$5 revenue ($750k) plus 500 new @48 units @$5 rev ($120k) equals $870k rev
July 3,000 existing @2 units per day @5 revenue ($900k) plus 500 new @48 units @$5 rev($120k) equals $1,020k rev
Aug 3,500 existing @2 units per day @$5 revenue ($1,050k) plus 500 new @48 units @$5 rev($120k) equals $1.170k rev
Sept 4,000 existing @2 units per day @5 revenue ($1,200k) plus 500 new @48 units @$5 rev ($120k) equals $1,320k rev
Oct 4,500 existing @2 units per day @5 revenue ($1,350k) plus 500 new @48 units @$5 rev ($120k) equals $1,440k rev
Nov 5,000 existing @2 units per day @$5 revenue ($1,500k) plus 500 new @48 units @$5 rev($120k) equals $1,620k rev
Dec 5,500 existing @2 units per day @$5 revenue ($1,650k) plus 500 new @48units @$5 rev ($120k) equals $1,770k rev
Jan 6,000 existing @2 units per day @$5 revenue ($1,800k) plus 500 new @48 units @$5 rev ($120k) equals $1,920k rev
Feb 6,500 existing @2 units per day @$5 revenue ($1,950K) plus 500 new @48 units @$5 rev ($120k) equals $2,070k rev
Mar 7,000 existing @2 units per day @$5 revenue ($2,100k) plus 500 new @48 units @$5 rev ($120k) equals $2,220k rev
Apr 7,500 existing @2 units per day @$5 revenue ($2,250k) plus 500 new @48 units @$5 rev ($120k) equals $2,370k rev
May 8,000 existing @2 units per day @$5 revenue ($2,400k) plus 500 new @48 units @$5 rev ($120k) equals $2,520k rev
June 8,500 existing @2 units per day @$5 revenue ($2,550k) plus 500 new @48 units @$5 rev ($120k) equals $2,670k rev
So Q2 2021 rev should be $340k (April) plus $1,000k (May) plus $870k equals $2,210k
So Q3 2021 rev should be $1,020k plus $1,170k plus $1,320k equals $3,510k
So Q4 2021 rev should be $1,440k plus $1,620 plus $1,770 equals $4,830k
So Q1 2022 rev should be $1,920k plus $2,070k plus $2,220k equals $6,210k
So Q2 2022 rev should be $2,370k plus $2,520k plus $2,670k equals $7,560k
So taking Q2 2022 in isolation, I have calculated revenue of $7,560. Multiply this by four to annualise gives $30,240k annual revenue, up to 50% margin gives approx $15,120 profit. X10 PE gives mcap $151m (£107m) so sp of approx 50p. However, if you multiply by two and a half (to take product sold per day to 5 rather than 2), you get a sp of approx £1.25 which is very similar to your sp of £1.32 in a year's time !!!!!!
In summary, 500 stores pm selling 2 units per day, my sp (x10PE) is 50p.
500 stores pm selling 5 units per