Assignment 3

Original PDF ↗ Official solution ↓

Lecturer's official Excel solution (Moodle) — covers Q1 (CoreWeave ratios) only; there is no official answer for the Q2 DCF. Note his "Growth %" is revenue Y2÷Y1 (the multiple, e.g. 8.37 for FY2024), so his Rule of 40 runs ~100pp higher than the true YoY change used below.

Toolkit

Terms

ratio-analysis current-ratio quick-ratio ebitda roe rule-of-40 free-cash-flow dcf-model terminal-value wacc net-present-value working-capital gross-profit-margin

Lectures

Session 5 — Financial Statements Analysis Session 6 — Financial Planning & Analysis (FP&A)

setup

Ratio-analysing a hyper-growth AI-infrastructure IPO (CoreWeave), then building a 5-year DCF valuation for your own startup (SababaSnacks).
1

CoreWeave (CRWV) Ratio Analysis
2

SababaSnacks Inc. DCF Valuation

Sources

Our worked solution: Problem Sets/Assignment 3/Assignment 3 Solutions.xlsx (Q1 ratios + Q2 DCF), SababaSnacks DCF - Explainer.docx, SababaSnacks Presentation.pptx
CoreWeave Inc. registration statement (10-K / S-1)

Accounting — subject hub
Session 5 - Financial Statements Analysis — ratios, Rule of 40, DCF mechanics
Session 6-Financial Planning and Analysis — projections & assumptions discipline
Assignment 1 - ABC Inc Full-Year Accounting — the ABC Inc. base this DCF builds on

Assignment 3

Sources

Related Notes