Advanced Accounting Worked Examples
Summary: This playbook provides worked examples in advanced accounting, including DuPont financial analysis, data analytics in auditing, revenue recognition, and variance analysis. Each example is drawn from published case studies at leading business schools.
Table of Contents
Chapter 1: DuPont Financial Analysis Framework
1.1 Traditional vs. Modified DuPont Analysis
The DuPont framework provides methodical evaluation of business performance. The traditional decomposition breaks Return on Equity (ROE) into profit margin, asset turnover, and financial leverage. The modified (additive/alternate) DuPont approach separates operating assets and liabilities from financing assets and liabilities, allowing analysts to see how financing activities versus operating activities amplify performance. This modified framework is particularly useful when companies hold large cash balances that affect traditional calculations.
Worked Example: In comparing Bata India versus Relaxo (2016), analysts applied both frameworks. Bata held significant cash reserves while Relaxo did not. The modified DuPont approach revealed that Bata's ROE was depressed by large cash holdings that traditional analysis incorrectly treated as operating assets. When cash was reclassified as a financing asset, the true operating performance gap between the companies became clearer.
Chapter 2: Data Analytics in Auditing
2.1 Using Visualization to Identify Accounting Anomalies
Case Study: Toby Biotech Inc. (2021)
Company: Toby Biotech Inc. (fictitious publicly-held company)
Year: 2021
Decision: Audit team used Tableau data analytics software to analyze financial statement accounts
Data Used: Accounts Receivable (AR), Allowance for Credit Losses (ACL), Reserve for Returns and Allowances (RRA), and revenue recognition data
Outcome: Students identified anomalies, pinpointed risks of material misstatement, developed responsive audit procedures, and prepared for simulated audit client meeting
Live Link: Berkeley Haas Case Series - Toby Biotech
Key learning objective: Apply data visualization tools to audit financial statements, focusing on contra accounts and revenue recognition while identifying risks through visual pattern analysis.
Chapter 3: Revenue Recognition & Expense Policies
3.1 SaaS Company Accounting Analysis
Case Study: Workday, Inc.
Company: Workday, Inc. (cloud-based HCM and FM software provider)
Year: 2016
Decision: Investment fund Southern Cross LLC evaluating Workday for SaaS portfolio addition
Data Used: Revenue and expense recognition methods, cash flow, profitability, leverage, liquidity, price-to-book valuation
Key Accounting Issues Analyzed:
- Workday deferred revenue until services were performed
- Company capitalized and amortized commissions paid to direct sales force for customer solicitation
- Analysts scrutinized whether these methods were consistent with GAAP
Outcome: Students evaluated whether Workday's $89 per share price represented fair value using P/B and discounted cash flow models
Live Link: Thunderbird School of Global Management - Case A01-16-0006
Chapter 4: Budget Variance Analysis
4.1 Multi-divisional Variance Analysis Framework
Case Study: Airinit (Division of ArgentAxis Holdings)
Company: Airinit (air freshener manufacturer)
Year: 2024
Decision: Diagnose why financial outcomes deviated adversely from original profit plans
Data Used: Detailed budget variance analysis prepared by accounting department
Learning Objectives Demonstrated:
1. Understanding nature, purpose, and significance of budget variances for controlling multidivisional operations
2. Applying systematic approach to analyze budget variances for enhanced decision-making
3. Assessing practical utilization of budget variances to improve control of business operations
4. Using economic theory to generate improvement ideas for poorly controlled operations
Outcome: Students diagnose internal financial health using enterprise-wide variance analysis framework, from raw inputs through manufacturing to marketing and distribution
Live Link: Darden Business Publishing - Case C-2442
Chapter 5: Downloadable Analysis Template
5.1 Financial Ratio Analysis Worksheet
This worksheet provides a structured template for performing DuPont analysis, variance calculations, and audit risk assessment based on the frameworks demonstrated in the case studies above.
SECTION A: DuPont Analysis (Traditional)
ROE = Net Profit Margin × Asset Turnover × Equity Multiplier
Net Profit Margin: ______ (Net Income / Revenue)
Asset Turnover: ______ (Revenue / Average Assets)
Equity Multiplier: ______ (Average Assets / Average Equity)
SECTION B: Modified DuPont (Operating vs Financing)
Operating ROE = (Operating ROA × Financial Leverage) + (Financing Leverage × Spread)
Operating ROA: ______ (Operating Income / Operating Assets)
Cash Holdings Adjustment: ______
SECTION C: Audit Risk Assessment
Inherent Risk: Low / Medium / High
Control Risk: Low / Medium / High
Detection Risk: Low / Medium / High
SECTION D: Variance Analysis Framework
Budgeted Amount: ______
Actual Amount: ______
Total Variance: ______
Price Variance: ______
Quantity/Efficiency Variance: ______
5.2 Failure Case Study: Lessons from Accounting Misstatements
Key Lessons from Audit Failures: The Toby Biotech case demonstrates that without proper data visualization and analytics, auditors may miss anomalies in accounts receivable and allowance for credit losses. Common failure points identified include insufficient analysis of contra accounts, failure to separate operating from financing activities (as shown in the Bata vs. Relaxo modified DuPont example), and inadequate revenue recognition scrutiny. Successful audit procedures require systematic variance analysis at the transaction level rather than relying solely on aggregate financial statement review.
FAQ
What is the modified DuPont framework and when should I use it?
The modified (additive/alternate) DuPont approach separates operating assets and liabilities from financing assets and liabilities. Use it when a company holds large cash reserves or significant financing activities that distort traditional ROE calculations, as demonstrated in the Bata India versus Relaxo comparison where traditional analysis failed to properly account for Bata's cash holdings effect on performance metrics.
How does data analytics improve audit quality?
Data analytics tools like Tableau enable auditors to identify anomalies, pinpoint risks of material misstatement, and visualize patterns across entire populations of transactions rather than relying on sampling. The Toby Biotech case shows how visualization of accounts receivable, allowance for credit losses, and reserve for returns and allowances helps audit teams ask better client questions and develop responsive audit procedures.
What are the key variances to analyze in multi-divisional businesses?
The Airinit case identifies price variances, quantity/efficiency variances, and their components across the value chain from raw inputs through manufacturing to marketing and distribution. Systematic analysis helps diagnose why adverse deviations occur and whether actions can prevent recurrence across divisions.