Learn financial modelling in Excel through practical lessons on model structure, three-statement models, DCF and essential Excel functions. ModeLoop is created by Samir Asadov, CFA, with 15 years in M&A, project finance and structured finance for offshore wind and renewables.
Each episode has a written blog post and a YouTube lecture.
Blog: https://modeloop.net/Blog
YouTube: https://www.youtube.com/@Mod3Loop
Courses: https://modeloop.net/Course
Models: https://modeloop.net/Store
P2E17: Excel Charts for Financial Models - Visualise Your Financial Data Effectively
Charting essentials for financial models in Excel: how to pick the right chart for the question, build charts that update with every scenario, and format them so a lender or investment committee gets the message in seconds.
In this episode:
Start with the one-sentence message, then choose line, bar, stacked column, waterfall or tornado
The coverage combo chart: CFADS vs debt service with DSCR and covenant lines
Debt balance profiles, EBITDA and value bridges, tornado sensitivities and scenario comparisons
Charts that update with the model: output blocks, Excel Tables, named ranges and linked titles
Board-ready formatting: axes from zero, less clutter, colour with meaning, one label on the point that matters
📺 Watch the video lecture: https://youtu.be/n5hRPMbiFAw (https://youtu.be/n5hRPMbiFAw)
🎓 Courses: Excel for Financial Modelling (https://www.udemy.com/course/excel-for-financial-modelling/) | AI in Project Finance Modelling (https://www.udemy.com/course/ai-in-financial-modelling/)
🌐 modeloop.net (https://modeloop.net)
ModeLoop is created by Samir Asadov, CFA, with 15 years in M&A and project finance for renewables.
18 Oct 2026
P2E16: Goal Seek and Solver in Excel - Work Backwards to the Answer You Need
Goal Seek and Solver in Excel let your financial model work backwards from the answer you need: the breakeven price, the bid tariff that hits the hurdle IRR, or the maximum debt a project can carry. We use both on real project finance, M&A and FP&A problems.
In this episode:
Goal Seek step by step: breakeven price, bid pricing, maximum purchase price, covenant headroom
Goal Seek rules: formula-driven targets, hard-coded inputs, precision and starting points
Solver for debt sizing: maximise senior debt subject to DSCR, gearing and tenor constraints
Choosing GRG Nonlinear, Simplex LP or Evolutionary
The traps: circularity macros, hidden hard-codes, local optima and reproducibility
📖 Full blog post: https://modeloop.net/Blog/P2E16-Goal-Seek-and-Solver-in-Excel-Work-Backwards-to-the-Answer-You-Need (https://modeloop.net/Blog/P2E16-Goal-Seek-and-Solver-in-Excel-Work-Backwards-to-the-Answer-You-Need)
📺 Watch the video lecture: https://youtu.be/fA2MaT7dhZo (https://youtu.be/fA2MaT7dhZo)
🎓 Courses: Excel for Financial Modelling (https://www.udemy.com/course/excel-for-financial-modelling/) | AI in Project Finance Modelling (https://www.udemy.com/course/ai-in-financial-modelling/)
🌐 modeloop.net (https://modeloop.net)
ModeLoop is hosted by Samir Asadov, CFA, ranked top 3 financial modeller worldwide (FMWC), with 15 years in M&A and project finance for renewables.
18 Oct 2026
P2E15: Data Tables in Excel for Sensitivity Analysis - Test Hundreds of Scenarios in One Grid
Data Tables in Excel for sensitivity analysis let you test hundreds of scenarios in one grid without touching your base case. We build one-variable and two-variable Data Tables for equity IRR, minimum DSCR and NPV, using project finance, DCF, M&A and FP&A examples.
In this episode:
What a Data Table does and why the base case never changes
Sensitivity flex cells such as Capex × (1 + Flex%)
One-variable and two-variable tables via Data › What-If Analysis › Data Table
Classic views: DSCR vs P90 and opex, IRR vs capex and COD delay, EV vs WACC and growth
The traps: slow recalcs, macro-broken circularities, cross-sheet inputs, checking the centre cell
📖 Full blog post: https://modeloop.net/Blog/P2E15-Data-Tables-in-Excel-for-Sensitivity-Analysis-Test-Hundreds-of-Scenarios-in-One-Grid (https://modeloop.net/Blog/P2E15-Data-Tables-in-Excel-for-Sensitivity-Analysis-Test-Hundreds-of-Scenarios-in-One-Grid)
📺 Watch the video lecture: https://youtu.be/nukPPx55mgM (https://youtu.be/nukPPx55mgM)
🎓 Courses: Excel for Financial Modelling (https://www.udemy.com/course/excel-for-financial-modelling/) | AI in Project Finance Modelling (https://www.udemy.com/course/ai-in-financial-modelling/)
🌐 modeloop.net (https://modeloop.net)
ModeLoop is hosted by Samir Asadov, CFA, ranked top 3 financial modeller worldwide (FMWC), with 15 years in M&A and project finance for renewables.
Contact ModeLoop
Guest appearances
Does not typically book guests
Based on episode analysis; this does not confirm that the show is currently accepting guests.
Host of ModeLoop?
Claim your podcast to manage its listing and keep your show details accurate.
Pod Engine is an independent podcast discovery and analytics service and is not affiliated with or endorsed by this podcast. Artwork and show content belong to their owners. Full legal notice.
Explore this show Podcast research with Pod Engine
