Scenarios analysis and planning in financial modeling

Creating different scenarios for your financial model is the process of examining and evaluating possible events or scenarios that would impact your assumptions and, in turn, change the result of your projections.

Why is scenario analysis useful

Different scenarios breakdown

  • Base case scenario: it is the most likely scenario, the one that you think about when you create the financial model in the first place. This should be the most likely outcome with the most likely assumptions.
  • Worst case scenario: this is the most severe scenario, where all the bad things that could happen have happened. This is what you should think about when planning for the worst case. This is where you use your “bad assumptions”, for instance you could insert a very high churn rate, or a very low conversion rate.
  • Best case scenario: this is the ideal scenario, where all the pieces fall in right place and you instantly find product-market-fit. This is usually the scenario that plays out for unicorn companies. This is where you use very optimistic assumptions, like a very high organic traffic, or a high ARPU.

Using scenario planning for financial modeling in Excel

  1. Group all the assumptions that you want to use in the scenarios.
  2. Copy and paste all the assumptions according to the number of scenarios that you want to create (base, worst, best) and label them accordingly.
  3. Change you assumptions according to the scenario in which they are.
  4. Create a new cell called “Live Scenario”. This is used to switch between the different scenarios using the function CHOOSE.
  5. Link the “Live Scenario” numbers to the rest of the financial model.
an example of changing a scenario

The pros of using scenario analysis

  • Investors can get a peek into the risk involved in the business.
  • You can be aggressive in planning for the worst case so that even in the worst possible case you can continue to operate your business at top efficiency.
  • You can project future profit for a potential good case for an exit.

The cons

  • It is time consuming.
  • Even with different scenarios you still can’t model every possible case.

Conclusion

Creating a scenario is a matter of just one click, we pre-populate the assumptions for the new scenario for you, starting from your base case scenario assumptions. Of course you can still go in and edit everything you want.

If you have any question please, feel free to contact us, we are always happy to talk to like-minded people. Also, if you are a startup founder or are interested in running a startup in the future you might like what we have built here at Sturppy, a financial modeling tool for startups that is fast and easy.

Good luck on your journey.

Founder of Sturppy.com