ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Nexlink Financial Simulation (Best Case)
2
3
Start Date1-Sep-24
4
Sales Incentive (%)5%
5
Price Tier 1 50,000
6
Price Tier 2 125,000
7
Price Tier 3 200,000
8
9
A.
Injected Capital (Bangkit Incubation)
 140,000,000
10
11
B.Investment Cost 29,902,675
12
Play Store Developer Account 400,000
13
Legal 4,000,000
14
Research/Ops 20,000,000
15
Contingency fund 5,502,675
16
17
18
19
… - Q1Q2Q3Y1Q1Q2Q3Y2
20
21
Staff Plan 7 7 7 7 7 7 7 7 8 8 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
22
1. Founder & Management 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
23
2. Development 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5
24
3. QA & App Support 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
25
4. Digital Marketing - - - - - - - - 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
26
5. Sales - - - - - - - - - - 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
27
6. Admin & Support - - - - - - - - - - 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
28
29
Average Salary 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000
30
32
Financial Item
Sep-24Oct-24Nov-24Dec-24Jan-25Feb-25Mar-25Apr-25May-25Jun-25Jul-25Aug-25Sep-25Oct-25Nov-25Dec-25Jan-26Feb-26Mar-26Apr-26May-26Jun-26Jul-26Aug-26Sep-26
33
34
A. Income
35
Number of Users 1,000 1,200 1,440 1,728 2,074 2,488 2,986 3,583 4,300 5,160 6,192 7,430 8,916 10,699 12,839 15,407 18,488 22,186 26,623 31,948 38,338 46,005 55,206 66,247 79,497
36
Number of Customers Tiers 1 50 60 72 86 104 124 224 269 322 516 619 743 892 1,070 1,284 1,541 1,849 2,219 2,662 3,195 3,834 4,601 5,521 6,625 7,950
37
Number of Customers Tiers 2 13 15 18 22 26 31 56 67 81 129 155 186 223 267 321 385 462 555 666 799 958 1,150 1,380 1,656 1,987
38
Number of Customers Tiers 3 3 4 5 5 6 8 14 17 20 32 39 46 56 67 80 96 116 139 166 200 240 288 345 414 497
39
40
Income from Customer Tiers 1 2,500,000 3,000,000 3,600,000 4,320,000 5,184,000 6,220,800 11,197,440 13,436,928 16,124,314 25,798,902 30,958,682 37,150,419 44,580,502 53,496,603 64,195,923 77,035,108 92,442,129 110,930,555 133,116,666 159,740,000 191,688,000 230,025,600 276,030,719 331,236,863 397,484,236
41
Income from Customer Tiers 2 1,562,500 1,875,000 2,250,000 2,700,000 3,240,000 3,888,000 6,998,400 8,398,080 10,077,696 16,124,314 19,349,176 23,219,012 27,862,814 33,435,377 40,122,452 48,146,942 57,776,331 69,331,597 83,197,917 99,837,500 119,805,000 143,766,000 172,519,200 207,023,040 248,427,648
42
Income from Customer Tiers 3 625,000 750,000 900,000 1,080,000 1,296,000 1,555,200 2,799,360 3,359,232 4,031,078 6,449,725 7,739,671 9,287,605 11,145,126 13,374,151 16,048,981 19,258,777 23,110,532 27,732,639 33,279,167 39,935,000 47,922,000 57,506,400 69,007,680 82,809,216 99,371,059
43
Other Source of Income 468,750 562,500 675,000 810,000 972,000 1,166,400 2,099,520 2,519,424 3,023,309 4,837,294 5,804,753 6,965,703 8,358,844 10,030,613 12,036,736 14,444,083 17,332,899 20,799,479 24,959,375 29,951,250 35,941,500 43,129,800 51,755,760 62,106,912 74,528,294
44
TOTAL INCOME 5,156,250 6,187,500 7,425,000 8,910,000 10,692,000 12,830,400 23,094,720 27,713,664 33,256,397 53,210,235 63,852,282 76,622,738 91,947,286 110,336,743 132,404,092 158,884,910 190,661,892 228,794,270 274,553,124 329,463,749 395,356,499 474,427,799 569,313,359 683,176,031 819,811,237
45
46
B. Expense
47
Staff Expense 9,111,667 9,111,667 9,111,667 9,111,667 9,111,667 9,111,667 9,111,667 9,111,667 10,413,333 10,413,333 13,016,667 13,016,667 41,416,667 41,416,667 41,416,667 41,416,667 41,416,667 41,416,667 41,416,667 41,416,667 41,416,667 41,416,667 41,416,667 41,416,667 41,416,667
48
1. Founder & Management 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000
49
2. Development 5,500,000 5,500,000 5,500,000 5,500,000 5,500,000 5,500,000 5,500,000 5,500,000 5,500,000 5,500,000 5,500,000 5,500,000 17,500,000 17,500,000 17,500,000 17,500,000 17,500,000 17,500,000 17,500,000 17,500,000 17,500,000 17,500,000 17,500,000 17,500,000 17,500,000
50
3. QA & App Support 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000
51
4. Digital Marketing - - - - - - - - 1,100,000 1,100,000 1,100,000 1,100,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000
52
5. Sales - - - - - - - - - - 1,100,000 1,100,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000
53
6. Admin & Support - - - - - - - - - - 1,100,000 1,100,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000
54
BPJS 770,000 770,000 770,000 770,000 770,000 770,000 770,000 770,000 880,000 880,000 1,100,000 1,100,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000
55
THR (Cadangan) 641,667 641,667 641,667 641,667 641,667 641,667 641,667 641,667 733,333 733,333 916,667 916,667 2,916,667 2,916,667 2,916,667 2,916,667 2,916,667 2,916,667 2,916,667 2,916,667 2,916,667 2,916,667 2,916,667 2,916,667 2,916,667
56
57
Sales & Marketing Expense 4,234,375 4,281,250 4,337,500 4,405,000 4,486,000 4,583,200 5,049,760 5,259,712 5,511,654 6,418,647 6,902,376 7,482,852 12,179,422 13,015,307 14,018,368 15,222,041 16,666,450 18,399,740 20,479,687 22,975,625 25,970,750 29,564,900 33,877,880 39,053,456 45,264,147
58
Sales Incentive 234,375 281,250 337,500 405,000 486,000 583,200 1,049,760 1,259,712 1,511,654 2,418,647 2,902,376 3,482,852 4,179,422 5,015,307 6,018,368 7,222,041 8,666,450 10,399,740 12,479,687 14,975,625 17,970,750 21,564,900 25,877,880 31,053,456 37,264,147
59
Marketing Cost 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000
60
61
Other Expense 4,850,000 4,850,000 4,850,000 4,850,000 4,850,000 4,850,000 4,850,000 4,850,000 4,850,000 4,850,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000 5,100,000
62
Working Space 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000
63
Cloud Services & License 600,000 600,000 600,000 600,000 600,000 600,000 600,000 600,000 600,000 600,000 850,000 850,000 850,000 850,000 850,000 850,000 850,000 850,000 850,000 850,000 850,000 850,000 850,000 850,000 850,000
64
Accounting System 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000
65
Internet, Electicity, Water, utilities 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000
66
Others 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000
67
… - - - - - - - - - - - - - - - - - - - - - - - - -
68
69
TOTAL EXPENSE 18,196,042 18,242,917 18,299,167 18,366,667 18,447,667 18,544,867 19,011,427 19,221,379 20,774,988 21,681,980 25,019,043 25,599,518 58,696,089 59,531,973 60,535,034 61,738,708 63,183,116 64,916,406 66,996,354 69,492,292 72,487,417 76,081,567 80,394,547 85,570,123 91,780,814
70
 29,902,675
71
C. Profit & Loss
72
Gross Profit/Loss(42,942,467)(12,055,417)(10,874,167)(9,456,667)(7,755,667)(5,714,467) 4,083,293 8,492,285 12,481,409 31,528,255 38,833,239 51,023,220 33,251,197 50,804,770 71,869,057 97,146,202 127,478,776 163,877,864 207,556,770 259,971,458 322,869,083 398,346,232 488,918,812 597,605,908 728,030,423
73
Tax (UMKM 0,5% Omset) 25,781 30,938 37,125 44,550 53,460 64,152 115,474 138,568 166,282 266,051 319,261 383,114 459,736 551,684 662,020 794,425 953,309 1,143,971 1,372,766 1,647,319 1,976,782 2,372,139 2,846,567 3,415,880 4,099,056
74
Net Profit/Loss After Tax(42,968,248)(12,086,354)(10,911,292)(9,501,217)(7,809,127)(5,778,619) 3,967,820 8,353,717 12,315,127 31,262,203 38,513,977 50,640,106 32,791,461 50,253,086 71,207,037 96,351,777 126,525,466 162,733,893 206,184,005 258,324,139 320,892,300 395,974,093 486,072,245 594,190,028 723,931,367
75
76
Cash Flow
77
Net Cashflow 97,031,752 (12,086,354)(10,911,292)(9,501,217)(7,809,127)(5,778,619) 3,967,820 8,353,717 12,315,127 31,262,203 38,513,977 50,640,106 32,791,461 50,253,086 71,207,037 96,351,777 126,525,466 162,733,893 206,184,005 258,324,139 320,892,300 395,974,093 486,072,245 594,190,028 723,931,367
78
Accumulated Cashflow 97,031,752 84,945,398 74,034,106 64,532,890 56,723,763 50,945,144 54,912,964 63,266,681 75,581,808 106,844,011 145,357,989 195,998,095 228,789,556 279,042,642 350,249,678 446,601,456 573,126,922 735,860,815 942,044,820 1,200,368,959 1,521,261,259 1,917,235,352 2,403,307,598 2,997,497,625 3,721,428,992
79
80
81
Key Summary
83
Positive Cashflow (Break Even) 6 month
85
Capital Break Even 10 month
86
ROI 2Y416%
87
Additional Capital Requirement 0
88
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104