This session was presented at a previous EA Ignite event. To explore upcoming sessions, please visit our current agenda.
In this masterclass, we will perform vertical and horizontal analysis in Excel using an income statement and balance sheet. We will use Excel to perform period-over-period analysis and year-over-year analysis. Later in the session, we will use break-even analysis for a single product and then look at multiple products using a mixture of products in break-even analysis.
You will get the most out of this session if you:
- Need to analyze data in Excel quickly
- Want to understand how the Financial Statements are related to each other
- Need to use PivotTables to show various date ranges – month, quarter, or year
You will walk away knowing how to:
- Create a break-even analysis
- Work with timelines in Excel
- Analyze an income statement and balance sheet
- Use Excel for forecasting