ModeLoop: Financial Modelling in Excel
by Samir Asadov, CFA
Excel formulas: 20-question quiz
About this podcast
Practical financial modelling in Excel and AI-assisted workflows from ModeLoop, created by Samir Asadov, CFA. Learn how to define assumptions, build calculations and check the numbers through focused lessons and illustrative examples. Follow for financial-modelling techniques and the Financial Modelling with AI curriculum. Episodes use synthetic narration; hypothetical examples are identified in each description. Not financial advice.
Episodes
The newest 20 of 58 episodes
- Excel formulas: 20-question quiz · 21 minA 20-question Excel formulas quiz for financial modelling. Choose A, B or C, take 10 seconds of quiet thinking time, then hear the worked answer.Covers absolute and mixed…
- Make or buy? 20-question quiz · 20 minThis is a twenty-question make-or-buy quiz. All examples are synthetic. For each question choose A, B or C before the explanation. You have ten seconds of quiet thinking time…
- Five points is not five percent · 8 minSuppose you ask AI to explain a conversion forecast. The old conversion rate is twenty percent and the new scenario is twenty-five percent. An invented draft answer says…
- P3E18 | Revenue without double counting · 8 minA revenue forecast can look precise and still pay for the same electricity twice. In this lesson, we will connect energy, contract terms and prices before asking AI to draft a…
- P3E17 | Project finance with AI: connect construction, operations and funding · 7 minSynthetic annual end-period project finance teaching case in pounds thousands, with two-voice synthetic narration. Connect one construction year to five operating years…
- Margin vs markup: the denominator that changes the answer · 7 minSynthetic unit-cost teaching example, excluding VAT, with two-voice synthetic narration. Cost £100 and price £130 give £30 gross profit, 30% markup on cost and about 23.08% gross…
- Revenue bridge explained: price vs volume variance · 6 minA revenue bridge should add back to the actual result. Follow a single-product example before drawing a business conclusion. In this episode: - Calculate the volume and price…
- DCF with AI: check cash flows, WACC and terminal value · 8 minThe most convincing DCF answer can still use the wrong timing. Follow a hypothetical valuation and review its assumptions. Financial Modelling with AI: Part 3, lesson 16. In this…
- Forecast precision: do more decimal places help? · 7 minA precise-looking forecast is not the same as a reliable forecast. Two teaching voices debate what the extra decimals tell you. In this episode: - Keep input precision separate…
- 3-statement model with AI: prove the cash-flow links · 8 minA balanced model can still contain the wrong cash-flow logic. Work through a synthetic one-month case. Financial Modelling with AI: Part 3, lesson 15. In this episode: - Trace…
- CAGR vs average growth: rebuild the endpoint · 7 minDoes the growth answer actually reach the ending value? Use an endpoint check to distinguish three different measures. In this episode: - Separate total growth, arithmetic mean…
- Financial model structure: plan before AI writes formulas · 7 minBefore asking AI for formulas, give it a model it can follow. Start with scope and dependencies. Financial Modelling with AI: Part 3, lesson 14. In this episode: - Define outputs…
- Financial model assumptions: give every number a source · 7 minAn assumption needs more than a plausible number. Build a record that another modeller can trace. Financial Modelling with AI: Part 3, lesson 13. In this episode: - Record source…
- Operating margin: why the average can mislead · 6 minGroup margin can move even when each division keeps its own margin. Listen for the revenue weights. In this episode: - Calculate operating profit divided by revenue. - Weight…
- Power Query and AI: reconcile your data refresh · 7 minA tidy dataset can still be the wrong dataset. Keep a bridge from raw rows to accepted inputs. Financial Modelling with AI: Part 3, lesson 12. In this episode: - Preserve the raw…
- Loan term vs total interest: the cheaper-payment trap · 7 minA lower monthly payment need not mean a lower total bill. Compare two hypothetical amortising loans. In this episode: - Keep principal and rate conventions comparable. - Separate…
- Annual reports to model inputs: an AI extraction checklist · 7 minA number copied from a PDF is only a candidate input. Keep the evidence that makes it usable. Financial Modelling with AI: Part 3, lesson 11. In this episode: - Record the source…
- Python in Excel: define, test and reconcile model checks · 6 minAn independent benchmark makes a model check more useful. Follow a synthetic four-month revenue case. Financial Modelling with AI: Part 3, lesson 10. In this episode: - Define…
- Profit vs cash flow: spot the working-capital error · 5 minWhy can profit rise while cash falls? Follow the working-capital bridge in a synthetic teaching case. In this episode: - Trace receivables. - Trace inventory. - Reconcile…
- Price cuts and profit: can 10% lower prices pay off? · 7 minA 10% price cut and 10% more units do not automatically preserve profit. Keep the targets distinct. In this episode: - Calculate revenue recovery separately. - Find zero-profit…







