Join Rudolph Rosenberg for an in-depth discussion in this video Determining revenue per customer, part of Financial Analysis: Analyzing the Top Line with Excel.
…Let's look now at the revenue you generate by customer.…This analysis is about understanding if your revenue is…generated through a few big customers, many smaller ones, or a blend of the two.…And to see the significant chunk of your revenue is dependent on…very few customers, which could become an issue down the road.…We will talk more about that in a later video.…It is also about analyzing how your revenue evolves by customer,…compared to the past.…The reason?…We need to make sure we develop our business with each of our…current customers.…
So, if we pick up a decline in revenue with a customer, then,…it is a sign that he is potentially speaking with the competition.…To do so, just simply take the pivot table that we already have, and, thanks to that,…we will see how the revenue of each customer is evolving year over year.…Let's first de-select the year, so that we get the revenue for both 2013, and 2014.…Now, the revenue that you see here by customer is a blend of the two years, so…what we want to do is take the year column and…
Also check out the companion course, Financial Analysis: Analyzing the Bottom Line with Excel.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Preparing your revenue information
- Comparing past performance
- Analyzing customer data
- Analyzing product information
- Identifying exceptional revenue