1. Major Tasks in Managerial Accounting
Managerial accounting and FP&A
()
Variance analysis in managerial accounting
()
Activity-based costing and applications
()
Uses of ratio analysis
()
2. Variance Analysis in Excel
Variances in Excel
()
Waterfall charts in Excel
()
Interpreting a variance bridge chart
()
Profit drivers and variance analysis
()
Interpreting financial results
()
3. Activity-Based Costing in Excel
Basics of ABC
()
Assigning direct costs
()
Assigning indirect costs
()
Product line profitability
()
ABC vs. traditional accounting
()
Recommendations from ABC analysis
()
4. Ratio Analysis in Excel
Review of financial statements
()
Liquidity ratios in Excel
()
Debt ratios in Excel
()
Profitability ratios in Excel
()
Operational ratios in Excel
()
The DuPont system
()
Ex_Files_Excel_Management_Accounting.zip
(471 KB)
Glossary_Excel_Management_Accounting.zip
(1000 KB)