Master model
Three statements, WACC, DCF, trading comps, precedent deals and LBO linked in one workbook, down to the football field.
Eleven financial models, from the WACC calculator to the master model that links them all: enter your assumptions, see the result live, download an Excel file with live formulas.
Three statements, WACC, DCF, trading comps, precedent deals and LBO linked in one workbook, down to the football field.
CAPM, unlevered and relevered beta (Hamada), after-tax cost of debt, target structure.
IRR, MOIC and NPV for a series of cash flows: investment, dividends, exit.
Integrated income statement, balance sheet and cash flow, working capital, capex, debt.
FCFF, Gordon growth and exit multiple terminal values, EV to equity bridge.
Entry price, leverage, exit EBITDA and multiple: IRR and MOIC on one page.
Sources & uses, debt tranches, cash sweep, management package, sensitivities.
EV/Sales, EV/EBITDA, EV/EBIT, P/E, quartiles and implied target value.
Comparable deal multiples and implied value.
Valuation ranges summarised in a native Excel chart.
EPS accretion or dilution, synergies, and the mix of shares, cash and debt.
What is the company worth? The answer in a minute, explained, with the report and the Excel model.
Value a company