Capital Expenditure

Item Unit Cost/unit Total

Bình ủ trà 2 400,000 800,000
Fridge 2 13,000,000 26,000,000
Furniture 20 1,500,000 30,000,000
Cash register, printer 1 12,000,000 12,000,000
Software management software 1 3,000,000 3,000,000
System sound 1 5,000,000 5,000,000
System cameras 2 5,000,000 10,000,000
Wifi 2 2,000,000 4,000,000
Induction cooker 2 3,000,000 6,000,000
Egg beater 1 500,000 500,000
Preparation tools 5,000,000 5,000,000
Ice grinder 1 2,000,000 2,000,000
Repair and decorate the store 40,000,000
Air conditioning 4 5,000,000 20,000,000
Fire protection system 2 5,000,000 10,000,000
Blender 1 47,000,000 47,000,000
Other cost 70,000,000
Total 291,300,000

Other initial investment

Items Unit Price Total
Business Registration 1 5,000,000 5,000,000
Fire protection installation expense 1 5,000,000 5,000,000
Design logos, menus 2,000,000 2,000,000
Uniform Resource Locator 3,000,000 3,000,000
Markertig expense 70,000,000 70,000,000
Training Employees
Deposit for space rental 15,000,000 15,000,000
6 month 20,000,000 120,000,000
Total 220,000,000

Ingredients
Unit Packing Price Unit price
Thai tea gram 1000 300,000 300
Condensed milk ml 380 25,000 66
Fresh milk ml 1000 25,000 25
Sugar gram 1000 20,000 20
Cream cheese gram 1000 80,000 80
Pearls, jelly,,, gram 1000 50,000 50
Grapefruit gram 1000 50,000 50
Lemon gram 1000 30,000 30
Plastic cup(500ml+nắp) piece 1 700 700
Drinking straws piece 1 163 163
Ice gram 5000 10,000 2
Total
 Gía vốn bán hàng, giá cost menu
Product Ingredient Unit Quantitative Price cost
Thai tea gram 10 3,000
Condensed milk ml 60 3,947
Fresh milk ml 70 1,750
Sugar gram 50 1,000
Trà sữa thá́i xanh
Pearls gram 30 1,500
Plastic cup piece 1 700
Drinking straws piece 1 163
Ice gram 50 100
Thai tea gram 10 3,000
Condensed milk ml 60 3,947
Fresh milk ml 70 1,750
Trà sữa thái đỏ Sugar gram 50 1,000
Pearls gram 30 1,500
Plastic cup piece 1 700
Drinking straws piece 1 163
Ice gram 50 100
Thai tea gram 10 3,000
Condensed milk ml 60 3,947
Fresh milk ml 70 1,750
Sugar gram 50 1,000
Trà thái xanh đá xay Pearls gram 30 1,500
Plastic cup piece 1 700
Drinking straws piece 1 163
Ice gram 50 100
Thai tea gram 10 3,000
Condensed milk ml 60 3,947
Fresh milk ml 70 1,750
Sugar gram 50 1,000
Trà thái đỏ đá xay
Pearls gram 30 1,500
Plastic cup piece 1 700
Drinking straws piece 1 163
Ice gram 50 100
Thai tea gram 10 3,000
Condensed milk ml 60 3,947
Fresh milk ml 70 1,750
Sugar gram 50 1,000
Trà thái đỏ bưởi hồng Pearls gram 30 1,500
Plastic cup piece 1 700
Drinking straws piece 1 163
Grapefruit gram 40 2,000
Ice gram 50 100
Thai tea gram 10 3,000

Trà thái xanh chanh vàng

 Condensed milk ml 60 3,947
Fresh milk ml 70 1,750
Sugar gram 50 1,000
Trà thái xanh chanh vàng Pearls gram 30 1,500
Plastic cup piece 1 700
Drinking straws piece 1 163
Lemon ml 20 600
Ice gram 50 100
Thai tea gram 10 3,000
Condensed milk ml 60 3,947
Fresh milk ml 70 1,750
Sugar gram 50 1,000
Trà chanh thái xanh Pearls gram 30 1,500
Plastic cup piece 1 700
Drinking straws piece 1 163
Lemon ml 26 780
Ice gram 50 100
Thai tea gram 10 3,000
Condensed milk ml 60 3,947
Fresh milk ml 70 1,750
Sugar gram 50 1,000
Trà chanh thái đỏ Pearls gram 30 1,500
Plastic cup piece 1 700
Drinking straws piece 1 163
Lemon ml 26 780
Ice gram 50 100
Thai tea gram 10 3,000
Condensed milk ml 60 3,947
Fresh milk ml 70 1,750
Sugar gram 50 1,000
Trà sữa thái xanh kem trứng Pearls gram 30 1,500
Plastic cup piece 1 700
Drinking straws piece 1 163
Cream cheese gram 26 2,080
Ice gram 50 100
Thai tea gram 10 3,000
Condensed milk ml 60 3,947
Fresh milk ml 70 1,750
Sugar gram 50 1,000
Trà sữa thái đỏ̉ kem trứng Pearls gram 30 1,500
Plastic cup piece 1 700
Drinking straws piece 1 163
Cream cheese gram 26 2,080
Ice gram 50 100

Estimated Sale in first year

Product Number/day Price per unit Total per day Total per year(360 days)
Trà sữa thá́i xanh 15 35,000 525,000 189,000,000
Trà sữa thái đỏ 15 35,000 525,000 189,000,000
Trà thái xanh đá xay 20 40,000 800,000 288,000,000
Trà thái đỏ đá xay 15 40,000 600,000 216,000,000
Trà thái đỏ bưởi hồng 15 40,000 600,000 216,000,000
Trà thái xanh chanh vàng 15 35,000 525,000 189,000,000
Trà chanh thái xanh 20 30,000 600,000 216,000,000
Trà chanh thái đỏ 15 30,000 450,000 162,000,000
Trà sữa thái xanh kem trứng 10 40,000 400,000 144,000,000
Trà sữa thái đỏ̉ kem trứng 10 40,000 400,000 144,000,000
Total 150 1,953,000,000
Quantity /day COGs/day COGS/year
1,500 450,000 162,000,000
9,000 225,000 81,000,000
10,500 262,500 94,500,000
7,500 150,000 54,000,000
520 41,600 14,976,000
4,500 225,000 81,000,000
600 30,000 10,800,000
1,210 36,300 13,068,000
150 10,500 3,780,000
150 24,450 8,802,000
7,500 15,000 5,400,000
529,326,000
Total cost Selling Price

12,160 35,000

12,160 35,000

12,160 40,000

12,160 40,000

14,160 40000

12,760 35000
12,760 35000

12,940 30000

12,940 30000

14,240 40000

14,240 40000
 Operating expenses
Fixed cost
Item Unit Quantity Price
Internet expense month 12 1,000,000
Employee salaries month 12 53,000,000
Rent month 12 20,000,000
Waste expense month 12 400,000
Telephone expense month 12 100,000
Depreciation expense
Total

Variable cost
Item year 1
Other expense 110,000,000
Utilities(Electricity,Water expense) 94,128,000
Total 204,128,000

Depreciation & Amortisation Expense

Capital assets Quantity Price Estimate useful life

Amortisation
Certificate of Food Hygiene and Safety 1 1,200,000 5
Signing up the trademark 1 1,900,000 5
Fire protection certificate 1 6,100,000 5
Depreciation
Fridge 2 26,000,000 5
Cash register, printer 1 12,000,000 5
System sound 1 5,000,000 5
System cameras 2 10,000,000 5
Induction cooker 2 6,000,000 5
Ice grinder 1 2,000,000 5
Wifi 2 4,000,000 5
Air conditioning 2 20,000,000 5
Fire protection system 4 10,000,000 5
Blender 1 47000000 5
Total

Sale and COGS growth rate in Scenario 1

Year 1 2 3
Assumption of expected Growth rate 107% 5% 4%
COGS 566,378,820.00 594,697,761.00 618,485,671.44
Sale 2,089,710,000.00 2,194,195,500.00 2,281,963,320.00
 Sale and COGS growth rate in Scenario 2
Year 1 2 3
Assumption of expected Growth rate 100% 3% 2%
COGS 529,326,000.00 545,205,780.00 556,109,895.60
Sale 1,953,000,000.00 2,011,590,000.00 2,051,821,800.00

Sale and COGS growth rate in Scenario 3

Year 1 2 3
Assumption of expected Growth rate 85% 2% 1%
COGS 449,927,100.00 458,925,642.00 463,514,898.42
Sale 1,660,050,000.00 1,693,251,000.00 1,710,183,510.00
 Total per year
12,000,000
636,000,000
240,000,000
4,800,000
1,200,000
30,240,000
924,240,000

Depreciation expense per year

240000
380000
1220000

5,200,000
2,400,000
1,000,000
2,000,000
1,200,000
400,000
800,000
4,000,000
2,000,000
9,400,000
30,240,000

nario 1
4 5
3% 2%
637,040,241.58 649,781,046.41
2,350,422,219.60 2,397,430,663.99
enario 2
4 5
2% 1%
567,232,093.51 572,904,414.45
2,092,858,236.00 2,113,786,818.36

enario 3
4 5
0% -1%
463,514,898.42 458,879,749.44
1,710,183,510.00 1,693,081,674.90
 Scenario 1 Cash Flow Assumption for Scenario 1
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Financial ratio year 1 year 2 year 3 year 4 year 5
Start- up expenses Gross profit margin 0.728967741935484 0.728967741935484 0.72896774193548 0.728967741936845 0.728967741937287
CAPEX (291,300,000.00) Net profit margin 0.099626332840442 0.117770670480365 0.13115535538406 0.140150012202684 0.144987616207993
Other initial investment (220,000,000.00) Operating profit margin 0.124532916050552 0.147213338100456 0.16394419423008 0.175187515253355 0.181234520259991
Net sales 2,089,710,000.00 2,194,195,500.00 2,281,963,320.00 2,350,422,219.60 2,397,430,663.99
Cash operating expenses 1,799,232,320.00 1,840,940,656.00 1,877,608,682.24 1,908,417,591.15 1,932,693,467.75 DISCOUNTED PAYBACK PERIOD
Fixed Cost 924,240,000.00 924,240,000.00 924,240,000.00 924,240,000.00 924,240,000.00 Year NCF Discounted NCF Cumulative NCF Cumulative discounted NCF
Utilities expense 94,128,000.00 97,893,120.00 101,808,844.80 105,881,198.59 110,116,446.54 0 (511,300,000.00) (511,300,000.00) (511,300,000.00) (511,300,000.00)
Marketing expense 104,485,500.00 109,709,775.00 114,098,166.00 117,521,110.98 119,871,533.20 1 238,430,144.00 211,000,127.43 (272,869,856.00) (300,299,872.57)
Other expense 110,000,000.00 114,400,000.00 118,976,000.00 123,735,040.00 128,684,441.60 2 288,651,875.20 226,056,758.71 15,782,019.20 (46,813,097.29)
COGS 566,378,820.00 594,697,761.00 618,485,671.44 637,040,241.58 649,781,046.41 3 329,531,710.21 228,382,005.24 345,313,729.41 244,164,024.44
EBITDA 290,477,680.00 353,254,844.00 404,354,637.76 442,004,628.45 464,737,196.24 4 359,651,702.76 220,581,124.74 704,965,432.17 565,894,854.15
D&A 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 5 377,837,757.00 205,075,196.81 1,082,803,189.16 910,040,628.97
EBIT 260,237,680.00 323,014,844.00 374,114,637.76 411,764,628.45 434,497,196.24 Estimated cost of capital (k) 13%
Tax expenses 0.20 0.20 0.20 0.20 0.20 Possibility 31%
NOPAT ( Net income ) 208,190,144.00 258,411,875.20 299,291,710.21 329,411,702.76 347,597,757.00 NPV 910,040,628.97
D&A 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 IRR 49%
Cash flow opns 238,430,144.00 288,651,875.20 329,531,710.21 359,651,702.76 377,837,757.00 Payback period 1.94532507648161
CAPEX - - - - - Discounted Payback period 2.20497717076817
Additinal working capital - - - - - PI 2.77985650102023
CFI/FCF 238,430,144.00 288,651,875.20 329,531,710.21 359,651,702.76 377,837,757.00 ARR 112.88%
Salvage Value - - - - -
Deposit fee Return - - - - -
Net Cash Flows (511,300,000.00) 238,430,144.00 288,651,875.20 329,531,710.21 359,651,702.76 377,837,757.00

Scenario 2 Cash Flow Assumption for Scenario 2

Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Financial ratio year 1 year 2 year 3 year 4 year 5
Start- up expenses Gross profit margin 0.728967741935484 0.728967741935484 0.72896774193548 0.728967741935484 0.728967741935484
CAPEX (291,300,000.00) Net profit margin 0.0765779825908858 0.0879657504759916 0.09458896954891 0.101058210802578 0.102982218054293
Other initial investment (220,000,000.00) Operating profit margin 0.0957224782386073 0.10995718809499 0.11823621193614 0.126322763503223 0.128727772567866
Net sales 1,953,000,000.00 2,011,590,000.00 2,051,821,800.00 2,092,858,236.00 2,113,786,818.36
Cash operating expenses 1,735,814,000.00 1,760,161,220.00 1,778,982,162.80 1,798,242,600.01 1,811,443,749.55 DISCOUNTED PAYBACK PERIOD
Fixed Cost 924,240,000.00 924,240,000.00 924,240,000.00 924,240,000.00 924,240,000.00 Year NCF Discounted NCF Cumulative NCF Cumulative discounted NCF
Utilities expense 94,128,000.00 96,951,840.00 99,860,395.20 102,856,207.06 105,941,893.27 0 (511,300,000.00) (511,300,000.00) (511,300,000.00) (511,300,000.00)
Marketing expense 78,120,000.00 80,463,600.00 82,072,872.00 83,714,329.44 84,551,472.73 1 179,796,800.00 159,112,212.39 (331,503,200.00) (352,187,787.61)
Other expense 110,000,000.00 113,300,000.00 116,699,000.00 120,199,970.00 123,805,969.10 2 207,191,024.00 162,260,963.27 (124,312,176.00) (169,242,236.73)
COGS 529,326,000.00 545,205,780.00 556,109,895.60 567,232,093.51 572,904,414.45 3 224,319,709.76 155,464,811.25 100,007,533.76 31,152,635.25
EBITDA 217,186,000.00 251,428,780.00 272,839,637.20 294,615,635.99 302,343,068.81 4 241,740,508.79 148,263,981.28 341,748,042.55 248,271,515.04
D&A 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 5 247,922,455.05 134,562,375.84 589,670,497.60 476,310,418.39
EBIT 186,946,000.00 221,188,780.00 242,599,637.20 264,375,635.99 272,103,068.81 Estimated cost of capital (k) 13%
Tax expenses 0.20 0.20 0.20 0.20 0.20 Possibility 46%
NOPAT ( Net income ) 149,556,800.00 176,951,024.00 194,079,709.76 211,500,508.79 217,682,455.05 NPV 476,310,418.39
D&A 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 IRR 30%
Cash flow opns 179,796,800.00 207,191,024.00 224,319,709.76 241,740,508.79 247,922,455.05 Payback period 2.55417411217678
CAPEX - - - - - Discounted Payback period 3.08862086132186
Additinal working capital - - - - - PI 1.93156741323807
CFI/FCF 179,796,800.00 207,191,024.00 224,319,709.76 241,740,508.79 247,922,455.05 ARR 74.30%
Salvage Value - - - - -
Deposit fee Return - - - - -
Net Cash Flows (511,300,000.00) 179,796,800.00 207,191,024.00 224,319,709.76 241,740,508.79 247,922,455.05

Scenario 3 Cash Flow Assumption for Scenario 3

Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Financial ratio year 1 year 2 year 3 year 4 year 5
Start- up expenses Gross profit margin 0.728967741935484 0.728967741935484 0.72896774193548 0.728967741935484 0.728967741933003
Capital Expenditure (291,300,000.00) Net profit margin 0.0008257100689738 0.00984485725979196 0.01333580164388 0.0113488825095734 0.00376816470215
Other initial investment (220,000,000.00) Operating profit margin 0.0010321375862173 0.01230607157474 0.01666975205485 0.0141861031369668 0.004710205877688
Net sales 1,660,050,000.00 1,693,251,000.00 1,710,183,510.00 1,710,183,510.00 1,693,081,674.90
Cash operating expenses 1,628,096,600.00 1,642,173,732.00 1,651,435,174.92 1,655,682,670.34 1,654,866,911.64 DISCOUNTED PAYBACK PERIOD
Fixed Cost 924,240,000.00 924,240,000.00 924,240,000.00 924,240,000.00 924,240,000.00 Year NCF Discounted NCF Cumulative NCF Cumulative discounted NCF
Utilities expense 94,128,000.00 96,010,560.00 97,930,771.20 99,889,386.62 101,887,174.36 0 (511,300,000.00) (511,300,000.00) (511,300,000.00) (511,300,000.00)
Marketing expense 49,801,500.00 50,797,530.00 51,305,505.30 51,305,505.30 50,792,450.25 1 31,610,720.00 27,974,088.50 (479,689,280.00) (483,325,911.50)
Other expense 110,000,000.00 112,200,000.00 114,444,000.00 116,732,880.00 119,067,537.60 2 46,909,814.40 36,737,265.57 (432,779,465.60) (442,952,014.43)
COGS 449,927,100.00 458,925,642.00 463,514,898.42 463,514,898.42 458,879,749.44 3 53,046,668.06 36,764,001.91 (379,732,797.54) (396,015,463.69)
EBITDA 31,953,400.00 51,077,268.00 58,748,335.08 54,500,839.66 38,214,763.26 4 49,648,671.72 30,450,460.17 (330,084,125.81) (349,282,337.36)
D&A 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 5 36,619,810.61 19,875,766.06 (293,464,315.21) (310,208,359.75)
EBIT 1,713,400.00 20,837,268.00 28,508,335.08 24,260,839.66 7,974,763.26 Estimated cost of capital (k) 13%
Tax expenses 0.20 0.20 0.20 0.20 0.20 Possibility 23%
NOPAT ( Net income ) 1,370,720.00 16,669,814.40 22,806,668.06 19,408,671.72 6,379,810.61 NPV (310,208,359.75)
D&A 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 30,240,000.00 IRR -23%
Cash flow opns 31,610,720.00 46,909,814.40 53,046,668.06 49,648,671.72 36,619,810.61 Payback period -
CAPEX - - - - - Discounted Payback period -
Additinal working capital - - - - - PI 0.393294817620182
CFI/FCF 31,610,720.00 46,909,814.40 53,046,668.06 49,648,671.72 36,619,810.61 ARR 5.21%
Salvage Value - - - - -
Deposit fee Return - - - - -
Net Cash Flows (511,300,000.00) 31,610,720.00 46,909,814.40 53,046,668.06 49,648,671.72 36,619,810.61
Unit: VND Position Quantity Pay Salary per 1 person Total per month
1 Manager 1 10,000,000 10,000,000
2 Bartender 3 7,000,000 21,000,000
3 Kitchen Staff 2 7,000,000 14,000,000
4 Treasuser 1 8,000,000 8,000,000
Total 7 32,000,000 53,000,000
Total per year
120,000,000
252,000,000
168,000,000
96,000,000
636,000,000