DocsRevenuesStandard Model

Revenues

The default revenue model in the Standard Financial Model is prebuilt to handle a wide variety of business models. Here's an explainer on how it works.

The Revenues sheet is the core revenue model in the Standard Financial Model, prebuilt to be applicable to a wide range of revenue models.

How to use

The prebuilt revenue model lives across two sheets:

  • Get Started is where the most important inputs live, and is intended to be the primary place for user interation
  • Forecast is where the calculations live, and is intended to be the place for more detailed assumptions and detailed insights into the business

The assumptions, detailed in the video above, can be modified on the Forecast sheet to change and shape the assumptions over time.

How it works

At a high-level, the prebuilt structure models growth of a metric, which then converts into a metric, then models retention (churn) of that metric, and then revenues and billings resulting from that.

Written documention on this is coming, at the moment consult the video above, which covers how the Revenues section works in detail, and read the notes in the model itself for line-by-line instructions.

Inputs

The most important inputs are on the Get Started sheet, and for some inputs there is the potential for additional modifications for rates of change over time on the Forecast sheet. Detailed in above video.

Common Modifications

The prebuilt revenue model is highly customizable, there are a couple common modifications:

  • Adding extra growth channels. By default there are 1 growth channel, which can reflect a mix of total organic and paid acquisitions. Additional growth channels can be added on Forecast, using whatever custom logic you want to use, and then summed into the total that is used for the conversion calculations.
  • Adding additional conversion steps. To add additional conversion steps, we just edit the calculations on Forecast - and often add in the inputs into Get Started, for a consistent user experience - to capture additional conversions, to whatever level of detail is useful for the business.
  • Adding additional revenue streams. The model allows you to use the prebuilt drivers in the Revenues section to quickly model any revenues that are based off an operating metric calculated in the revenue model, simply by selecting that metric in the drivers, and then assuming the $ per metric that applies (i.e. # of subscribers from the prebuilt section, and then assume an average monthly revenue for that specific line).
  • Adding in custom revenue models. You can also build in any new revenue source based on any business logic you want, simply by pulling your model or sheets into the workbook, and linking the revenues, billings, and optionally the operating metrics into the Forecast sheet in the top Forecast section.

Questions, support, or customization help, contact me.