Home / Case Studies / Restaurant Forecast & DCF Valuation Model
CASE STUDY
InteractiveRestaurant Forecast & DCF Valuation Model
A restaurant roll-out forecast with unit economics, three statements, WACC and a DCF valuation of the group.
Business challenge
A growing restaurant group needed to know what the business is worth today and how much of that value depends on new openings.
Outcome
Owners and investors see the value of the existing estate vs the pipeline, unit payback and the valuation range across cases.
Overview
A restaurant roll-out forecast with unit economics, three statements, WACC and a DCF valuation of the group. Inside: unit economics and cash-on-cash return; prime cost and four-wall EBITDA; fixed asset register roll-forward; WACC build-up; DCF with exit-multiple cross-check; value split: existing vs new restaurants. How to use this model: on the Dashboard sheet, use the drop-down in cell C4 to pick the case: Worst Case, Base Case or Best Case.
Approach
Openings, unit volumes, same-store growth and channel mix drive a restaurant P&L with prime cost and four-wall EBITDA. Capex, debt and working capital complete the statements; WACC and a normalised terminal year drive the DCF, cross-checked with exit multiples.
Capabilities
Skills
LET'S WORK TOGETHER
Need something like this for your business?
Tell me what you are trying to solve. I’ll respond with a practical view of how I can help.