Financial Modeling for Analysts to Build Clear, Structured Models for Better Decisions with Shreya

5 May 2026 · 39 min
38:59

In this episode of Financial Modelers Corner, host Paul Barnhurst interviews Shreya Bhatt, a manager at Cross Boundary Group with over eight years of experience in infrastructure and project finance modeling. Shreya shares her modeling philosophy, emphasizing that a model is never finished and must tell a clear story by linking inputs to outputs. She recounts a "horror" corporate model plagued by poor structure, random links, and tangled formulas, illustrating the importance of clear sheet purpose, input shading, and consistent labeling. Shreya describes her role building and reviewing financial models for renewable energy and infrastructure projects, focusing on portfolio roll‑up models for solar, where she monitors commercial, technical, and financial variables. She enjoys project‑finance models, especially a multi‑country template covering eleven nations, and highlights the balance between flexibility and clarity. Regarding modeling standards, she adopts a blended approach: FAST for smaller, user‑friendly models and SMART for large, complex portfolios, stressing consistency and organizational alignment. The conversation turns to AI, where Shreya is enthusiastic about AI as a partner that can accelerate calculations and enhance dashboards, but she warns that judgment, structure, and insight remain human responsibilities. She offers career advice about patience, self‑kindness, and continuous learning, and shares practical Excel tips such as the F5 shortcut, VBA usage, Power Query, Power BI, and XLOOKUP. In a rapid‑fire segment, she provides concise opinions on topics like lambdas, three‑statement models, cash‑flow focus, and preferred language models (Copilot). The episode concludes with a reminder to stay curious, help others learn, and connect via LinkedIn.

Chapters

More from Paul

0:48
youtube.com

Great decisions need healthy pushback.

1d ago
31:52
youtube.com

The State of the Finance Stack 2026: Live Findings

1d ago
0:54
youtube.com

A level-five FP&A team isn’t enough.

1d ago
1:04:03
youtube.com

Trust and Leadership Lessons for FP&A From 100+ Top Leaders with CFO Jon Laudie

1d ago
59:52
youtube.com

Excel Hour - Learn to Excel with The FP&A Guy

2d ago
1:03
youtube.com

AI can build its own rules.

6d ago
0:43
youtube.com

You can’t vibe your way through planning.

1w ago
0:41
youtube.com

Excel has survived every challenger.

1w ago
0:32
youtube.com

Vibe coding needs serious guardrails.

1w ago
1:02
youtube.com

Stop chasing tools. Learn orchestration.

1w ago
50:05
youtube.com

Will AI Replace Enterprise Performance Management? | David den Boer

1w ago
See all content