SaaS Revenue Waterfall Chart Ugh, Budget Season! For most of us, we are beginning budget season or we are in the midst of budget season spending crazy hours manipulating numbers, building models, and meeting with department heads to create a workable first draft of the budget. I won’t dive into the pro’s and con’s of […]
Charts
SaaS Revenue Forecast Model
SaaS Revenue Forecast Model I try to keep my financial statement models as simple as possible. I don’t forecast on one tab, but I also don’t have 30+ tabs of assumptions and formulas. I build my models around the operations of the business and the important metrics. Enough detail to be accurate and supportable but […]
How to Calculate Customer Lifetime Value (CLTV)
What is Customer Lifetime Value (CLTV) Customer Lifetime Value (CLTV) is the revenue or margin that you receive from one customer over the lifetime of that customer. The term “Customer Lifetime Value” is known by many words. It’s also known as Lifetime Value (LTV) or CLTV. In this post, I explain how to calculate Customer […]
How to Create the Dreaded Excel Waterfall Chart
Excel Waterfall Chart Somewhere along the line, we’ve all been asked to create an Excel waterfall chart for a Board or management presentation. Waterfall charts are a very “simple” and powerful visual method to present year-over-year changes or whatever time period you are measuring. Presenting variances via a bunch of numbers on a spreadsheet can […]