Considering factors like divisional allocations, geography, currency, capacity constraints, operational changes, and contingent revenue.
Candidates may be asked to build a cost schedule, considering issues like economies of scale, multi-currency costing, and semi-variable costs.
Candidates may be asked to build a depreciation schedule, considering different methodologies, purchases, disposals, and fully depreciating assets.
Candidates may need to create a working capital schedule, considering issues like inventory continuity and monthly or quarterly working capital.
Candidates may be asked to build a tax schedule, considering factors like tax losses, tax loss continuity, tax depreciation, multiple jurisdictions, and effective tax rates.
Candidates may model aspects of this, including various debt features, covenants, debt sculpting, and refinancing.
Candidates should track common and preferred equity balances, dividends, and retained earnings. They may also model other equity issues like issuances, buybacks, dilutive securities, and tiered equity returns.
Subsidiaries may be covered, Including non-controlling interest, equity method investments, and long-term investments.
Creating an easy-to-interpret summary page and automating it to show results of multiple scenarios. Candidates must know how to build a dynamic summary page.
Candidates may be asked to create automated timing switches for product launches, financing transactions, and other key issues.
Efficiently finding and correcting errors in a financial model is a critical skill. Candidates must use Excel techniques to identify and fix errors without third-party tools and include checks within the model.
Financial modelers should manage large datasets for trend analysis and assumptions. Candidates may be given data to extract information using Excel tools and formulas.
