This video walks through how to model some key metrics for a Software as a Service business (lifetime value, customer acquisition cost with channel optimization, MRR / ARR, and valuation) based on simple pricing and churn assumptions.
I just did another video on SaaS recently, but I'm jumping right back to it because one of the problems for this weekend's @msexcelesports (FMWC) round is due to be a sequel to this question by the same author, so I thought it would be good to brush up!
If you want to try it yourself, you can buy the case materials (including the questions, instructions, Excel file with assumptions, and a worked solution) for $10 from the FMWC here:
https://www.fmworldcup.com/product/stage-12-2021-when-sally-upsells-harry/
Better yet, you can still get a ticket for this weekend's round here:
https://www.fmworldcup.com/product-category/regular-competition/
(To be clear, I don't get commission or anything like that for referring you, and you don't need to buy the case to watch the video)