
SpaceX IPO Update: Google, Cursor, Other Valuations, Modeling Process, and AI Tools
The video updates the recent SpaceX IPO, noting that the stock now trades above $200 per share, pushing the market cap past $2.5 trillion. The host walks through recent deals—Google’s compute‑rental agreement and the Kuiper acquisition—showing how each could lift the valuation by roughly $50 billion, though the overall overvaluation remains in the trillion‑dollar range. Key data points include SpaceX’s price‑to‑revenue multiples (over 131× trailing, 74× forward) and the author’s own valuation range of $1.65‑$1.1 trillion, contrasted with Morningstar’s $780 billion and Demotoran’s 2× revenue estimate. The analysis highlights assumptions around Starlink subscriber pricing, commercial fleet contracts, and market‑penetration caps drawn from telecom peers. Notable quotes: the presenter admits the Google deal “adds about $50 billion” and that the Kuiper deal’s net effect is “around $50 billion after subtracting the $60 billion purchase price.” He also stresses that AI tools like Grok are useful for data gathering but should not replace human judgment in model construction. Implications are clear: despite sizable partnership revenues, SpaceX remains dramatically overvalued by traditional metrics, and investors must scrutinize the underlying assumptions. The video also serves as a tutorial on building granular, scenario‑driven models for complex, multi‑segment firms, emphasizing disciplined sensitivity analysis over blanket optimism.

How AI Startups Hallucinate Their Revenue: CARR Vs. ARR
The video examines how AI startups manipulate revenue metrics, especially ARR versus contracted ARR, and why this creates misleading growth signals. It explains that legitimate ARR must come from fixed‑price, non‑cancellable annual contracts, not from month‑to‑month or usage‑based fees. The presenter...

EBITDAR: One Step Beyond Tony Soprano in Corporate Finance
The video introduces EBITDAR – earnings before interest, taxes, depreciation, amortization and rent – as a step beyond the more familiar EBITDA metric. After a brief nod to a mis‑used Sopranos clip, the presenter explains why adding back rental expense...

The Debt Service Reserve Account (DSRA) in Project Finance: Save the Lenders, Save the World
The video explains the Debt Service Reserve Account (DSRA), a core reserve mechanism in project‑finance models that guarantees sufficient cash to meet scheduled debt payments, especially for seasonal assets like solar and wind plants. It walks through a practical Excel...

Free Cash Flow in the Age of AI Hyperscalers: Time for an Update?
The video revisits the definition of free cash flow (FCF) and argues that the surge in AI‑driven spending by hyperscalers like Amazon warrants a refreshed calculation. Using Amazon (US GAAP) and SAP (IFRS) as case studies, the presenter walks through how...

LBO Valuation: The Power of Middle-School Math to Reverse a Model
The video walks viewers through converting a traditional LBO model into a flexible pricing tool by making the targeted IRR and exit year primary inputs. Instead of relying on Goal Seek, the instructor derives a simple algebraic expression that...

The Flow of Funds: How to Make Cap Tables Flow Like Water
The video explains how a flow‑of‑funds schedule translates a startup’s exit proceeds into payouts for each stakeholder in a venture‑backed transaction. It walks viewers through building the schedule in Excel, starting with the exit enterprise value—derived from a revenue multiple...

Cash Flow From Operations: Real Life Vs. Investopedia
The video walks through cash flow from operations, contrasting textbook simplicity with real‑world complexity, using Target, Watches of Switzerland and Telstra as case studies. It explains the indirect method—starting with net income, adding back depreciation, amortisation, deferred taxes and other non‑cash...

PE Fund Performance Metrics: TVPI Vs. MOIC Vs. DPI and Gross Vs. Net IRR
The video walks through private‑equity fund performance measurement, focusing on TVPI, MOIC, DPI and the distinction between gross and net IRR. Using a simplified Excel model, the instructor demonstrates how to calculate each metric, allocate management fees, and apply carried‑interest...