Builds linked financial statements, values the business with a DCF, and estimates sponsor returns in an LBO. Use to forecast a company’s operating plan and compare its value and transaction returns under different assumptions.
Historical resultsEnter two years of reported results and the opening balance sheet.
AssumptionsSet the inputs used across the forecast, valuation, and transaction schedules.
Operating forecastForecast each business line from its underlying volume and price drivers through EBITDA.
StatementsLink the income statement, balance sheet, and indirect cash-flow statement for every forecast year.
DCFValue the operating plan using unlevered free cash flow.
LBOLay out entry sources and uses, the exit value, and sponsor proceeds.
ScenariosDefine base, downside, and upside cases with explicit changes to operating assumptions.