Skip to main content

Build a DCF Model

Create discounted cash flow valuations from scratch.
Build a DCF based on the forecasted financials in this model.
1. Extrapolate the explicit forecast (if needed) to get an 8-year 
   forecast period which smoothly decays to the terminal year. 
   Use perpetual growth at terminal.
2. Build a WACC calculation with rationales for each component 
   (risk-free rate, equity risk premium, beta, debt cost) that 
   I can tweak later. Document sources or reasoning.
3. Calculate enterprise value using DCF methodology. Show each 
   net debt component as available in the EV-equity bridge to 
   arrive at equity value.

Trading Comps Analysis

Build comparable company analysis with relevant multiples.
Create a trading comps table for Nordic SaaS companies. Include 
EV/Revenue, EV/EBITDA, and EV/EBIT multiples for LTM and NTM. Add 
revenue growth rates (LTM and NTM) and EBITDA margins. Pull the 
data from the attached broker reports and calculate median, mean, 
and 25th/75th percentiles. Format as a standard comps output table.
Research online to see if there exists better peers.

Transaction Comps

Analyze precedent transactions for M&A benchmarking.
Build a precedent transactions table for European fintech 
acquisitions 2022-2026. Include acquirer, target, deal value, 
EV/Revenue and EV/EBITDA multiples, and premium paid. Research 
each transaction and add a column noting strategic rationale. 
Sort by date descending and calculate median multiples.
Add clickable links for every fact point in a separate table.

Merger Model / Accretion-Dilution

Build merger analysis for M&A transactions.
Build an accretion/dilution analysis for the proposed acquisition. 
Model 3 scenarios: all-cash, all-stock, and 50/50 mix. Use the 
buyer's current share price and shares outstanding from the 
Inputs tab. Calculate pro forma EPS impact for years 1-3 post-close. 
Include synergy phasing (25% Y1, 75% Y2, 100% Y3) and show breakeven 
synergies needed for each funding mix.

Football Field Valuation

Create summary valuation range table.
Build a valuation summary table showing implied equity value 
ranges from each methodology: DCF, trading comps, and precedent 
transactions. For each method, show the low, mid, and high case 
values. Include a column for implied share price at each level. 
Add rows for current share price and 52-week high/low as 
reference points. Format as a clear summary output.

Credit Analysis

Add credit metrics and debt capacity analysis.
Below the debt schedule section, insert rows to build a credit 
metrics section showing net debt / EBITDA, net debt / (EBITDA - 
Capex), Interest / EBITDA and Interest / (EBITDA - Capex). Add 
similar metrics for each debt tranche - senior and mezz. Match 
the formatting style of the existing debt schedule section.