Childcare as a Platform - Financial Model (Merchant Monks Live)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
2
INCOME STATEMENT
3
Fiscal year 2020P (Q1)2020P (Q2)2020P (Q3)2020P (Q4)2020P2021P2022P2023P
4
Fiscal year end date3/31/20206/31/20209/31/202012/31/202012/31/202012/31/202112/31/202212/31/2023
5
6
Revenue18,000.0028,800.0036,000.0036,000.00118,800.00345,600.001,382,400.002,304,000.00
7
Cost of sales (enter as -)(12,600.00)(20,160.00)(25,200.00)(25,200.00)(83,160.00)(241,920.00)(967,680.00)(1,612,800.00)
8
Gross Profit5,400.008,640.0010,800.0010,800.0035,640.00103,680.00414,720.00691,200.00
9
Research & development (enter as -)
10
Selling, general & administrative (enter as -)(3,300.00)(3,300.00)(3,300.00)(3,300.00)(13,200.00)(39,600.00)(158,400.00)(264,000.00)
11
Operating profit (EBIT)2,100.005,340.007,500.007,500.0022,440.0064,080.00256,320.00427,200.00
12
Interest income
13
Interest expense (enter as -)
14
Other expense (enter as -)
15
Pretax profit2,100.005,340.007,500.007,500.0022,440.0064,080.00256,320.00427,200.00
16
Taxes (enter expense as -)(525.00)(1,335.00)(1,875.00)(1,875.00)(5,610.00)(16,020.00)(64,080.00)(106,800.00)
17
Net income1,575.004,005.005,625.005,625.0016,830.0048,060.00192,240.00320,400.00
18
19
Tax rate25%25%25%25%25%25%25%25%
20
21
SEGMENTS
22
Fiscal year 2020P (Q1)2020P (Q2)2020P (Q3)2020P (Q4)2020P2021P2022P2023P
23
Fiscal year end date3/31/20206/31/20209/31/202012/31/202012/31/202012/31/202112/31/202212/31/2023
24
25
Revenue Split w/ Childcare Provider (P)
26
70%
27
28
Childcare Enrollment ($/month)
29
$1,200
30
31
Product
32
Childcare Services (P) - revenue share (enter as -)(12,600.00)(20,160.00)(25,200.00)(25,200.00)(83,160.00)(241,920.00)(967,680.00)(1,612,800.00)
33
Childcare Services (O) - revenue share5,400.008,640.0010,800.0010,800.0035,640.00103,680.00414,720.00691,200.00
34
Total18,000.0028,800.0036,000.0036,000.00118,800.00345,600.001,382,400.002,304,000.00
35
36
Unit
37
Average enrollment per location5810108.25888
38
39
Locations
40
workspace parterships1111131220
41
42
ASPs ($/month)
43
Childcare Services$1,200.00$1,200.00$1,200.00$1,200.00$1,200.00$1,200.00$1,200.00$1,200.00
44
45
46
WORKING CAPITAL
47
Fiscal year 2020P (Q1)2020P (Q2)2020P (Q3)2020P (Q4)2020P2021P2022P2023P
48
Fiscal year end date3/31/20206/31/20209/31/202012/31/202012/31/202012/31/202112/31/202212/31/2023
49
50
Lease rate ($/month/location)
51
800
52
53
SG&A lease (workspace lease)
54
Beginning of period0.002,400.002,400.002,400.0009,600.0028,800.00115,200.00
55
Increases / (decreases)2,400.000.000.000.009,600.0019,200.0086,400.0076,800.00
56
End of period2,400.002,400.002,400.002,400.009,600.0028,800.00115,200.00192,000.00
57
58
Lease as % of SG&A----72.7%72.7%72.7%72.7%
59
60
Misc. ($/month/location)
61
300
62
63
SG&A misc. (accounting, legal, marketing, supplies)
64
Beginning of period0.00900.00900.00900.0003,600.0010,800.0043,200.00
65
Increases / (decreases)900.000.000.000.007,200.0032,400.0028,800.00
66
End of period900.00900.00900.00900.003,600.0010,800.0043,200.0072,000.00
67
68
Misc. as % of SG&A----27.3%27.3%27.3%27.3%
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
Loading...