
The video walks viewers through a curated suite of AI applications that cover every stage of a financial analyst’s workflow, from initial company research to the final pitch‑deck. It highlights tools such as FinTool for investment thesis drafting, AlphaSense for global market research, Quadratic for PDF data extraction, Excel‑based Copilot and Trace Light for modeling, and Claude’s PowerPoint integration for presentation creation. Key insights include FinTool’s superior accuracy over Claude and ChatGPT for US‑equity theses, its limitation to U.S. markets, and AlphaSense as a complementary global alternative. Quadratic demonstrates near‑perfect balance‑sheet extraction from an 80‑page Apple 10‑K, while also supporting live bank‑feed connections. In Excel, the Copilot function reliably extracts dates and categorizes transactions, whereas Trace Light builds dynamic profit‑and‑loss statements with scenario toggles, though both require user verification due to occasional formula errors. Notable examples feature an instant investment thesis for Microsoft, an insider‑buying screen flagging GameStop’s CEO, a loan amortization table generated by Copilot that mis‑numbered months, and Claude’s PowerPoint slide that auto‑populated Apple’s company profile and allowed on‑the‑fly background changes. The presenter also stresses the importance of data validation, proper formatting, and data‑validation rules to prevent model breakage. The overall implication is that AI can shave hours off repetitive finance tasks, but analysts must treat outputs as drafts, not final products. Selecting the right tool for each workflow segment—research, data ingestion, modeling, and presentation—can boost productivity while maintaining analytical rigor.

Trace Light is an AI‑powered Excel add‑in designed for consulting, banking and private‑equity professionals, promising to turn raw spreadsheets into polished financial models in seconds. The video walks through five escalating use‑cases—from basic formatting to a full discounted cash‑flow valuation—showcasing...

The video walks viewers through constructing a dynamic cohort analysis template in Excel, enabling businesses to track customer behavior, revenue generation, and acquisition profitability across monthly cohorts. It begins by defining assumptions—initial customers, month‑over‑month growth, average revenue per user, acquisition cost,...

The video demonstrates how to build fully clickable, color‑changing tabs inside a single Excel worksheet, turning a static table into an interactive budget dashboard. The process starts by converting raw data into an Excel table (Ctrl T), naming a cell “selected_month”, and...