ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Project Explanation
2
This financial model was created to support the sourcing of bridge financing, for which a term sheet was recieved but the client ultimately decided to self finance, and for an equity raise which is on-going. The model illustrates the expansion plan of the founding doctors for 3 scenarios based on the number clinics opened.
3
Financial Model Overview
4
Model Purpose: Illustrate the long-term expansion plan for [Redacted].

Time Period: Forward looking from Sept 2023 till end of 2028

Scenarios: Three scenarios considered for expansion:

Scenario 1)Existing Location + 1 new location in Saigon
Scenario 2)Existing Location + 2 new locations in Saigon
Scenario 3)Existing Location + 2 New locations in Saigon + 1 Flagship location in another major City (Da Nang).

Business Structure:

-Existing clinic serves as the Headquarter with the back office team handling majority of operations.
-Each location has its own micro team or additional staff in addition to the back office team.

Key Drivers:

-Number of Consultations (patients seen): Depends on Doctors and their capacity.
-Synergistic effect: Number of consultations of a doctor influences the number of surgeries of another, and vice versa. i.e LASIK doctor recommend other surgeries, General doctor can recommend LASIK surgery

Revenue Sensitivity and Cash Generation:

-The model demonstrates sensitivity to revenue changes.
-The business model has a strong ability to generate cash.

Background:

-Both founders are doctors.
-Seeking a strategic investor to provide business management expertise, enabling founders to focus on new location openings and quality assurance.

Internal Accounting Project:

A balance sheet is currently not included as internal accounting projects are currently underway and will be included in the model shortly.

Assumptions on historical data:
-Assumptions have the historical references beside the input, mostly 2022 averages due to 2021 being impacted by Covid.
-Some key assumptions revised down to represent the strategy of higher volume, lower price, enabled by a new operational approach from the founders.

Notes
-Pharmacy not included as currrently structered to not make a profit.
-Optical store not included as currently net profit comparably low. Undergoing further analysis as OPEX appears inflated.
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
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