SaaS Revenue Waterfall Excel Chart Template
Originally published: 16/02/2018 14:23
Publication number: ELQ-84601-1
View all versions & Certificate
certified

SaaS Revenue Waterfall Excel Chart Template

A SaaS Excel Model to help you forecast revenue waterfall in simple, automated charts.

Description
This simple Excel model represents a great way to visually demonstrate and analyse your SaaS revenue forecast.

This Excel tool uses formulas to create an automated waterfall chart based on the changes in your revenue forecast, giving you a quick and easy way to track your revenue.

The second tab uses two charts to allow you to easily visualise your Recurring Revenue Waterfall for two periods, giving a great visual representation of Revenue growth based on previous year churn, previous year new impact, previous year expansion, current year new business, current year expansion and current year churn, giving you a forecast of growth for the next year.

The third tab offers 3 charts giving you the chance to analyse MRR inflow aand outflow, the trends of new and lost customers as well as the services backlog in months.

This tool includes:

- Customer Waterfall
- Renewal Waterfall
- Churn Input
- ARR Inputs
- MRR Waterfall
- Recurring Revenue Waterfall charts
- MRR Inflow / Outflow chart
- Customer Trends chart
- Services Backlog chart

This Best Practice includes
1 Excel Spreadsheet

Ben Murray offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.8 / 5 (43 votes)

please wait...