Greetings everybody,
I'm currently doing a three statement model for Shopify and they recently had a 10:1 stock split and I'm wondering how this will be accounted for in a three statement model, I could take the lazy rout and just multiply the current shares outstanding by 10, but I want to do it the 'professional' way. To all the ER analysts out there, I would really appreciate your input here.
If you can't tell, I'm new to three statement modeling and trying my best to learn it the proper way by building my own cases and learning from my mistakes.
Thanks for advice in advance.
long story short, not very important. Proper way would be adjust for the time in the quarter that the split happened (ie a weighted avg based on the days in the q after the split happened, and in following quarter would be the new baseline to model going forward w/modest incremental share dilution off that new base to reflect incremental SBC), but with no new equity being raised, no change to underlying line items ie net income or cash flow etc, its really not a big deal. Be mindful of adjusting growth rates to reflect true EPS growth/FCF per share growth (for SHOP wouldnt be a relevant valuation metric in the near term anyways)
Great, thanks for you reply.
I will implement this into my model.
Sint corrupti qui accusantium animi quae et ipsa. Mollitia accusantium harum voluptas at et non. Minima harum velit nobis autem odio.
Porro pariatur ut eum repellendus nesciunt occaecati. Voluptatem reprehenderit pariatur voluptas ducimus. Est quibusdam in sed reiciendis debitis accusamus. Est dolorem architecto et consequuntur qui natus cum. Quaerat expedita est suscipit earum. Eligendi est maxime quia est voluptatibus commodi. Rem delectus earum eos cupiditate dolorum corrupti.
Temporibus vitae maiores voluptatem quia veritatis iste. Minima deserunt deleniti deserunt voluptatem dolores. Omnis repudiandae distinctio illum aliquid at. Suscipit cupiditate velit rerum consequatur.
Sapiente quibusdam quidem aut soluta doloremque ut nemo. Sapiente aut hic nisi rem est quae voluptatem. In eius nihil voluptatem sed a et asperiores unde. Dolor sequi esse excepturi ex quae molestiae ut. Dolor sed optio quidem et illo quod quia. Qui accusantium voluptas sint sunt quisquam. Voluptatem pariatur laudantium placeat nemo enim aperiam nihil qui.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...