AI will eventually build financial models in the future, though the timeframe is uncertain.

Financial modelers should learn Power Query because it provides value for data transformation and manipulation tasks.

Financial modelers generally should not learn Power BI, according to Carl's rapid-fire preference.

Horizontal model layouts are preferable to vertical layouts for organizing financial models.

Named ranges should generally be used in financial models to improve clarity and reduce errors.

Presenting an outdated financial model to a client due to failure to implement dynamic data ranges and automated updates represents a critical failure that causes lasting embarrassment and career trauma.

During the 2007-2008 recession, work availability and quality declined at consulting firms, but turnaround and restructuring work increased because distressed businesses need help.

Working in a boutique turnaround firm with minimal support structure (small team sizes, no standardized processes) forced deeper learning than large-firm environments, despite initial discomfort.

The most important mindset for financial modelers is to think strategically about where the work is heading and what future requests may come, rather than just delivering what was explicitly asked for in the current mandate.

Cash flow analysis acts as a diagnostic barometer that reveals underlying business problems across operations, sales, margins, pricing, and headcount, not as an isolated metric.

Distressed and chaotic business environments require the same core skills and advisory services as healthy businesses—the difference is context (failing vs succeeding), not fundamental approach.

The Certified Insolvency and Restructuring Advisor (CIRA) credential provides three primary benefits: formal education in distress situations, validation of expertise for clients, and valuable long-term professional networks.

Formal education institutions do not offer undergraduate or graduate degrees in bankruptcy, liquidation, or turnaround management, creating a gap filled by professional certifications like CIRA and CTP.

The bank or private equity investor bringing in advisors is typically the party identifying distress in larger companies, not the company itself, because they have financial stake and access to covenant information.

The engagement model shifted over Carl's career from bank-initiated distress consulting to company-initiated consulting, where the company itself identifies pain and seeks help rather than external lenders forcing intervention.

The ability to ask intelligent questions is more valuable than domain-specific knowledge, because cash flow patterns reveal business problems across industries if you know how to interpret and ask follow-up questions.

Dynamic arrays in Excel are a game-changing feature that eliminates manual workarounds and range updates, particularly the UNIQUE function for deduplication tasks.

The curiosity to ask 'what else can this do' beyond solving the immediate problem is what drives continuous improvement and innovation in modeling approaches.

F4 (cycling between relative and absolute references) is a time-saving Excel keyboard shortcut that eliminates the need to manually type dollar signs.

Practicing modeling on non-critical, back-office scenarios allows skill development without risk, whereas deploying untested techniques in front of stakeholders creates unnecessary risk.