Join Rudolph Rosenberg for an in-depth discussion in this video Finding the data points, part of Financial Analysis: Analyzing the Top Line with Excel.
…So where can we find the revenue of the company in the underlying detail data?…We need to analyze the revenue performance of the business.…The one and single answer to this question is in your invoices.…This is a standard invoice.…And even though each company has its own custom format.…Most of the information shown here should be the same on your invoices.…The information we're interested in are, customer name,…customer ID number, invoice number, customer location.…
For customer location this needs to relevant to your needs.…It could be just a city, a state, a country.…If you have different billing and…shipping locations, select the one that is the most relevant to your business.…Or just take them both down.…If you're wondering which one is the most relevant for…you, just think about what you can do with the information.…If you deliver products by mail, for example,…shipping addresses could be interesting as you might have logistics decisions to…make depending on the concentration of customers in a certain location.…
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