Learn how to analyze the bottom line (or profitability) of your company, by analyzing your gross margin and operating expenses with Excel.
- [Voiceover] Hi, I'm Rudolph Rosenberg and welcome to Financial Analysis: Analyzing the Bottom Line with Excel. In this course we'll look at a very practical technique to analyze the profitability of a company, and learn how to identify the sources of under or over performance. To do so, we will be talking about financial concepts necessary to the understanding of gross margin and operating expenses performance. And learning techniques using Microsoft Excel to gather, prepare, and analyze data that every company has access to.
Now let's get started with Financial Analysis: Analyzing the Bottom Line with Excel.
Also check out the companion course, Financial Analysis: Analyzing the Top 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.
- Finding data points
- Prepping data
- Calculating standard cost and gross margins
- Analyzing overall gross margin performance
- Analyzing individual and overall expenses