Excel Circularity in Financial Models: Safe Interest and Revolver Techniques
Excel Debt Schedules Without Circular References A circular reference in Excel is a formula that points back to itself, directly […]
Investment Banking
Acquisition vs. Greenfield: Comparing Buy vs. Build Models in Investment Banking
Buy vs. Build: Acquisition or Greenfield, a Modeling Guide Acquisition means buying control of an operating business or asset. Greenfield
IPO Valuation and Pricing: A Simple Model for ECM Analysts
IPO Valuation Model: Price, Float, Allocation An IPO valuation model translates a company’s fundamentals, peer trading levels, and live investor
Leveraged Finance (LevFin) Modeling Basics: Lightweight Credit Models for Analysts
Lightweight LevFin Models: Structure, Tests, Decisions Leveraged finance modeling underwrites a capital structure, not a business valuation. A lightweight credit
New York LBO Modeling Test Guide: Wall Street Cases, Timing Expectations
LBO Modeling Tests: Formats, Scoring, 60-Minute Plan An LBO modeling test is a timed build of a leveraged buyout model
London Analyst LBO Modelling Tests: What UK Banks and Boutiques Expect
Ace the London LBO Modeling Test: IFRS, SONIA, Tips An LBO modeling test is a timed exercise where you build
5 Steps to Build a Lean LBO Model for Timed Interview Tests
Lean LBO Modeling: A 60-90 Minute Interview Playbook A leveraged buyout model forecasts how a business performs under significant debt
Modeling PIK Interest and Toggle Notes: Line Items and Compounding Logic
PIK Interest and Toggle Notes: Mechanics and Modeling Payment-in-kind (PIK) interest adds unpaid interest to the debt balance instead of
Covenant Modelling in Syndicated Loans: Types and Headroom Tracking
Covenant Modeling for Syndicated Loans: A Practical Guide Covenant modeling takes a negotiated credit agreement and turns it into numbers
How to Calculate Credit Ratios for Leveraged Deals in IB Models
Credit Ratios and Covenant Modeling: A Practical Playbook Credit ratios are the yardsticks lenders and sponsors use to judge how