ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Assumptions
2
3
Projections made for 60 months
4
5
6
7
8
Revenues
9
10
PS1 Price (Monthly Subscription)Rp45,000.00
11
PS2 Price (Interstitial Ads Income/150 Impressions [monthly])Rp750,000.00
12
13
14
15
16
17
Maximum number of PS2 customers in a Tier 1 city4000
18
19
Costs
20
21
Core Team Salaries
22
Monthly salaryRp25,000,000.00
CEO, CMO & CCO, COO & CPO, CTO, CFO & CHRO
23
24
Sales Team + Infrastructure Salaries
25
26
Monthly expense - Base employees' salaries
27
EmployeesSalariesNo. of employees - Y1No. of employees - Y2No. of employees - Y3No. of employees - Y4No. of employees - Y5
28
Developer & TechRp13,500,000.005791113
29
Data teamRp8,500,000.0002468
30
UI & UXRp8,000,000.0023456
31
Marketing (Design, Media(Visual & Social Media), Admin, General Affairs)Rp6,500,000.005791113
32
Business DevelopmentRp7,000,000.0003579
33
Sales ManagementRp6,500,000.00357911
34
Product ManagementRp7,000,000.00246810
35
Finance & AccountingRp8,000,000.0002468
36
total employees1733486378
37
Employee salary Y1Rp149,500,000.00Rp0.00
38
Employee salary Y2Rp297,995,000.00
(+7% average yearly increment for employees)
39
Employee salary Y3Rp458,532,450.00
40
Employee salary Y4Rp640,084,967.50
41
Employee salary Y5Rp844,808,028.45
42
Running ExpensesCost
43
Outsource medical data updateRp50,000,000.00
44
Cyber securityRp6,000,000.00
45
App Server & CloudRp30,000,000.00
46
47
Running costRp86,000,000.00
48
49
One time expense - initial setup; Primarily deposit for the city office and laptops for employees
50
ApplicationsRp40,000,000.00
51
Legal feesRp20,000,000.00
52
Historical Medical DataRp400,000,000.00
53
Setup for monthly expensesRp100,000,000.00
54
Online early advertisingRp130,000,000.00
55
56
one time costRp690,000,000.00
57
58
59
60
Head Office + Other expenses
61
62
Monthly rent (for 18 employees, adding 15 each year)Rp27,000,000.00
(+12,500,000 /annum)
63
Utilities Expenses - internet, electricity, housekeeping etcRp3,500,000.00
(+1,500,000 /annum)
64
65
66
Monthly expense towards officeRp30,500,000.00
(+14,000,000/annum)
67
68
One time expense towards office:
69
Cost of 5 laptopsRp75,000,000.00
70
71
Total one time head office expenseRp75,000,000.00
72
73
Q3 Y1 One-time expense
74
75
Server & feature expansion, marketing outsourcingRp35,000,000.00
76
77
Q1 Y2 One-time expense
78
79
Server & feature expansion, marketing outsourcingRp35,000,000.00
80
Tools MaintenanceRp10,000,000.00
81
Additional 2 laptopsRp30,000,000.00
82
Total one time Q1 Y2 expenseRp75,000,000.00
83
84
One-time expense for each annum Y3 & above
85
86
Tools MaintenanceRp10,000,000.00
87
Additional 2 laptopsRp30,000,000.00
88
Total annual expenseRp40,000,000.00
89
90
91
92
93
94
95
96
97
98
99
100