A concern, which I come across in almost every financial modeling exercise leading to valuation, is how to estimate the revenue drivers of the company I am modeling for. This question is also raised every time I assign a company to my team of analysts and associates for modeling. In every classroom, I encounter similar concerns without fail. Industrialists and business owners emphasize that one needs to be an industry / business expert to identify the revenue drivers and then model them.
I agree to such an opinion but only partly. I vouch that one acquires the art of identification of appropriate revenue drivers by experience, but I am a very strong believer of the fact that most of it is common sense, once you broadly understand what a company does to earn revenue.
For all the discussions in this article, let’s assume that we are undertaking a financial modeling exercise leading to valuation. The first line item that needs to be projected is “Revenue”. Now ponder over the questions below:
- Should “Revenue Build Up” be given a rigorous treatment?
- Is “Revenue” a line item that needs special attention and rigor?
- Why spend so much time on building up the revenue in a model hen it’s like any other line item in the entire exercise?
Exercise on building up More Revenue:
“Revenue Build Up” exercise in a financial model should be rigorous and deserves utmost attention because:
- Revenue Build Up typically will be the first piece to be modeled. This is the first module that your client, top management, seniors, reviewers, investors, lenders etc will go through before they move to the next section of your model. Rigorously projected revenue speaks a lot about the analytical skills, thought process, business understanding and industry understanding of a modeler. It gives the flavor of the rigor that rest of the model is expected to have.
- Revenue, per se, is an extremely important line item in modeling. Many analysts, in the absence of relevant and required information about the cost drivers, typically use revenue line item to project the cost line items (costs expressed as a %age of sales / revenue / turnover). A rigor in revenue build up also ensures a rigor in costs projections.
- In the absence of information about the capital expenditure plans and depreciation policy of the company, an analyst may again choose “Revenue” to project capital expenditure and depreciation in future years. And it’s not hidden how important capital expenditure as a line item is in the entire exercise of financial modeling leading to valuation.
Now that we understand the importance of revenue build up in a financial model, let’s proceed to identify revenue drivers. How should we identify the revenue drivers?
Want to know more about Financial Modeling?
Talk to our expert career counselors who guide you in getting right information on Financial Modeling Course and how it can benefit your career.
Way to Identify Revenue Drivers
Simplest way to identify revenue drivers is to think what are the variables when mathematically operated might give you the revenue. Let’s look at few examples below:
Revenue should have following components:
- Revenue from Passenger Movement
- Revenue Cargo Movement
- Others – Foods & Beverages sold inside the flight (in case of lo cost carriers), any promotional schemes advertised inside the flight during journey etc.
Let’s break it down further.
Revenue from Passenger Movement
We understand from our own experience that airlines seats belong to different classes and are priced differently on different days. They start cheap but become expensive closer to the date of journey. This implies slab wise airfare modeling. Hence, the drivers will be:
- Total number of seats
- Split between different classes (Business, Economy etc)
- Utilization / Occupancy
- Split between different airfare slabs
- Airfare in each slabs: Requires growth rates in airfare
Let’s say a carrier has 180 seats out of which 60 seats are for Business Class and balance in Economy Class. The flight has historically seen 90% occupancy and have 2 tiered tariff slabs in Business Class (T1, & T2) and 5 tiered tariff slabs in Economy Class (T3, T4, T5, T6, & T7). I am using some arbitrary additional assumptions to roll out my assumption sheets:
So, the revenue drivers can now be easily obtained as indicated below:
No. of seats in T5 sub category of Economy Class in Year 1 = 180 x 66.7% x 91.0% x 20.0%
Similarly, for revenue from Cargo movement, the drivers will be:
1. Quantum of Cargo which in turn will be made up of
- Cargo carrying capacity
- Utilization / Occupancy
2. Unit Rate per ton of Cargo: This in turn will require growth rate
Other revenue can be linked to passenger count.
Based on my own experience and conversation with some of my friends in Investment Banking, I am compiling below the key revenue drivers for some of the industries. Remember that they are not sacrosanct and a different modeler / analyst may come up with a different set of drivers. After all, one should choose a revenue driver that is easy to comprehend, explain, quantify and model.
Do you have any different thought process on the revenue drivers?
Have a different driver for an industry in your mind?
Need any further explanation on the drivers listed above? Feel free to start a discussion thread below.
Do you have any query about Financial Modeling?