Pricing

The optional Pricing sheet is used to model multiple products, SKUs or subscriptions, and is key to more detailed SaaS and Ecommerce strategies.

The Standard Financial Model by default supports any transaction or subscription business, and can support modeling up to hundreds of different subscription plans, products, SKUs, enterprise clients, projects, or more, using the Pricing sheet.

One of the biggest questions people face is how to model multiple subscription plans or multiple products. Generally, I advise modeling at an “average order” or “average subscription” level until you have the data or decision-making process with an operational business to utilize the additional level of detail behind modeling each product, SKU, subscription plan, or customer type. The Standard Model and its variants support both of these types through the “average” or “multiple” selection on Get Started; if you find yourself bogged down in detail, start simpler and build out more detail when you can take advantage of it.

If you do want to model multiple products or subscription types, this is where the Pricing sheet comes in.

How it works

This sheet is prelinked into the model through the Forecasting Methods to create an average revenue per subscriber/user/etc. to feed into the core revenue calculations on Forecast. It is only used if, on the revenues asumptions on Get Started, you select “multiple” as the option for calculating average revenue for one or more of the channels or conversion steps.

If selected, the assumptions for the average disappear, and the settings inside the model change automatically to use the numbers generated from Pricing.

Inputs

The inputs here allow you to:

  • Use one row for each unique product or subscription you want to model.
  • Input the date the product is first offered, it’s price, and use the forecasting methods to change the price over time, if needed.
  • Input the number of this product purchased per order/subscriber/etc. For subscriptions, you wil generally want the total for all subscriptions per type to add up to 1 or 100%, for transaction businesses, it could be > 1 as people can buy more than 1 product per order.

This creates an average revenue per order or average monthly revenue per subscription that reflects the weighted average of price and popularity.

This structurally assumes the same churn cycles, repeat cycles, growth per product or subscription per channel or conversion step. To create separate forecasts of this, create multiple sales channels with different revenue calculations, contact me.

Common Modifications

No common edits to this sheet other than inserting additional rows to cover additional SKUs or subscriptions.

Was this helpful? Yes / No

Thanks, I appreciate the feedback.