Overview
-
Learn how to use Excel for key managerial accounting tasks. In this hands-on course, explore performing variance analysis, doing activity-based costing, and using ratio analysis.
Syllabus
-
Introduction
- Welcome
- Managerial accounting and FP&A
- Variance analysis in managerial accounting
- Activity-based costing and applications
- Uses of ratio analysis
- Variances in Excel
- Waterfall charts in Excel
- Interpreting a variance bridge chart
- Profit drivers and variance analysis
- Interpreting financial results
- Basics of ABC
- Assigning direct costs
- Assigning indirect costs
- Product line profitability
- ABC vs. traditional accounting
- Recommendations from ABC analysis
- Review of financial statements
- Liquidity ratios in Excel
- Debt ratios in Excel
- Profitability ratios in Excel
- Operational ratios in Excel
- The DuPont system
- Next steps
