ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Dookki Vincom Tran Duy Hung — 12-Month Revenue & P&L Forecast
3
Single-store Korean rice-cake hotpot buffet | FY2027 monthly forecast (Jan-Dec)
4
5
Client / Company
Dookki Vietnam — Vincom Tran Duy Hung outlet (illustrative)
6
Title
12-Month Revenue Build & P&L Forecast — Base, Scenario & Sensitivity Analysis
7
Prepared by
OCD Consulting
8
Date
15 August 2026
9
Version
v1.0
10
Currency / Units
VND million (VND mn), except average spend per guest which is in VND
11
12
Important note on data source
13
No actual store financials were provided for this exercise. All revenue drivers, cost ratios and fixed costs below are ILLUSTRATIVE / SYNTHETIC, built to be internally consistent and directionally realistic for a single-outlet Korean hotpot-buffet concept in a prime Hanoi mall (Vincom Tran Duy Hung). Replace every blue cell on the Inputs sheet with the store's actual figures before using this model for a real decision.
14
15
16
17
18
Color code (legend)
19
■Blue textHardcoded input or assumption — safe to change
20
■Black textFormula / calculation — driven by other cells, do not overtype
21
■Green textLink pulling from another sheet in this workbook
22
■Red textLink to an external file (not used in this model)
23
■Yellow fillKey assumption / scenario lever that most affects the output
24
25
Workbook map
26
Inputs
Store, footfall, cost, and scenario-delta assumptions. The only sheet with hardcoded numbers.
27
Monthly_PnL
Full monthly P&L, Jan-Dec, Base case, plus FY Total column. Analysis sheet — every cell is a formula or a link.
28
Scenario_Analysis
Best / Base / Worst case FY P&L side-by-side.
29
Sensitivity
Two-way sensitivity grids: FY Net Income to occupancy/ASP; FY EBITDA margin to cost drivers.
30
Output_Overview
Client-ready one-page summary with monthly KPI trend and scenario comparison.
31
Checks
Zero-defect control sheet — ties out every month and flags any error.
32
33
Key limitations
34
•
All figures are illustrative, not the operator's actual reported numbers — treat the shape of the model, not the absolute VND figures, as the takeaway.
35
•
The model is a standalone monthly P&L; it excludes a balance sheet, cash flow statement, and working-capital build.
36
•
Revenue is modelled as Seats x Turns x Occupancy x Operating days x Seasonality x ASP — a simplified single-formula build, not a bottom-up channel/daypart model.
37
•
Fixed costs (staff, rent, D&A, interest) are held constant across all 12 months in the Base case; no mid-year rent step-up or headcount ramp is modelled.
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100