Easier product forecasting

Easier product forecasting

Do you find it difficult to set appropriate financial targets for your product?  Recently I’ve been attempting to simplify the process as part of my planning for my company’s next fiscal year and wanted to share an approach I’ve found helpful with you.  I’ve created a straightforward spreadsheet, which you are welcome to download and adapt for your own purposes.

Current Performance #

First of all you need to know how your product is currently performing.  If you don’t know, you should. Go and speak to your Sales and Finance departments and find out.  Go on.

Product Life Cycle courtesy of Tom Spencer's consulting blog

Back now?  Jolly good.

Organic Growth (or Decline) #

With that knowledge, the next thing for you to consider is at what stage in its life cycle is your product.  Is it:

  • a new product being introduced and growing slowly (Introduction)
  • an existing product in its rapid growth phase (Growth)
  • an established product exhibiting slight or no growth (Maturity)
  • a product phasing out and in decline (Decline)

A good description of these phases, often referred to as the Product Life Cycle, can be found on Tom Spencer’s consulting blog.  This will allow you to predict how it’s revenue should be growing (or declining) irrespective of any new initiatives that will generate additional revenue.  This is your baseline financial performance resulting from new sales of your product.

Incremental Growth #

Then you need to consider any new initiatives that will generate additional revenue, such as a new feature release, an advertising campaign or a limited-time offer on upgrades at a discounted price.  This forms your product’s incremental performance resulting from new sales.

You also need to consider repeat business such as annual maintenance, or renewed subscriptions to your service.  The key considerations here are:

  • how much do customers pay in the second (and subsequent) years compared to what they paid in the first year?
  • how good is your company at retaining your customers from year to year?

Royalties or Licence Fees #

Lastly you need to factor in any royalties or licence fees that you need to pay third parties every time you sell your product.  This could be a licence of a bundled product, such as a PDF viewer or a reporting package.  You might need to pay these only at point of sale, on an ongoing basis each year a customer is using your product, or not at all.

Wrapping It Up #

With all this information at your fingertips, you can simply plug it into the Product Fiscal Forecast spreadsheet and it will calculate your forecast for you.  This is a good starting point to benchmark your product’s financial performance for the following year.

Caveat Lector #

This is definitely not a full accountancy tool.  It doesn’t take into account any associated product costs other than the royalties / licence fees payable to third parties.   What it does tell you is approximately how much you should expect your product to make in the next financial year.

Please feel free to post a comment if it has helped you, or if you have any suggestions for improvement.

References: #

  1. Product Life Cycle on Tom Spencer’s consulting blog.
  2. Product Fiscal Forecast spreadsheet

Get articles when they’re published

My articles get published irregularly (erratically, some might say). Never miss an article again by getting them delivered direct to your inbox as soon as they go live.  

Read more from Jock

The Practitioner's Guide to Product Management book cover

The Practitioner's Guide To Product Management

by Jock Busuttil

“This is a great book for Product Managers or those considering a career in Product Management.”

— Lyndsay Denton

Jock Busuttil is a product management and leadership coach, product leader and author. He has spent over two decades working with technology companies to improve their product management practices, from startups to multinationals. In 2012 Jock founded Product People Limited, which provides product management consultancy, coaching and training. Its clients include BBC, University of Cambridge, Ometria, Prolific and the UK’s Ministry of Justice and Government Digital Service (GDS). Jock holds a master’s degree in Classics from the University of Cambridge. He is the author of the popular book The Practitioner’s Guide To Product Management, which was published in January 2015 by Grand Central Publishing in the US and Piatkus in the UK. He writes the blog I Manage Products and weekly product management newsletter PRODUCTHEAD. You can find him on Mastodon, X (formerly Twitter) and LinkedIn.

1 Comment on “Easier product forecasting

Leave a Reply

Your email address will not be published. Required fields are marked *