PLEASE MAKE A COPY - Dot #8: Financial Planning - Part Three

	B	D	E	F	R	AD	AP
1			Act	Frc	Frc	Frc	Frc
2	All inputs in GBP or equivalent		Dec-22	Jan-23	Jan-24	Jan-25	Jan-26
3
4	Revenues			Mth 1	Mth 13	Mth 25	Mth 37
5					3	3	3
6	1			Jan-23	Jan-24	Jan-25	Jan-26
7		Total New Clients per month		2.0	6.0	18.0	54.0
8		Blended Fee		7,500	7,500	7,500	7,500
9		Cash Revenues		15,000	45,000	135,000	405,000
10		Contribution Margin		(12,487)	5,973	32,337	170,360
11		Contribution Margin per New Client		(6,243)	996	1,796	3,155
12		#Clients to Breakeven		na	64	35	20
13
14		Total Costs Structure		(90,843)	(102,383)	(166,019)	(297,996)
15		Servicing (people) Sales		(11,800)	(11,800)	(35,400)	(53,100)
16		Servicing (people) Sales-Commission		(1,770)	(5,310)	(15,930)	(47,790)
17		Servicing People Support		(4,917)	(4,917)	(9,833)	(14,750)
18		Servicing Other		(5,000)	(5,000)	(5,500)	(11,000)
19		Marketing Spend		(4,000)	(12,000)	(36,000)	(108,000)
20		Contribution Margin Costs		(27,487)	(39,027)	(102,663)	(234,640)
21		Non Servicing People		(53,356)	(53,356)	(53,356)	(53,356)
22		Overheads		(10,000)	(10,000)	(10,000)	(10,000)
23		Other Costs		(63,356)	(63,356)	(63,356)	(63,356)
24
25	Contribution Margin Costs
26
27	1	Payroll Data	Dec-22	Jan-23	Jan-24	Jan-25	Jan-26
69
70	2	Servicing - People Sales		Jan-23	Jan-24	Jan-25	Jan-26
81
82	3	Servicing - People Support		Jan-23	Jan-24	Jan-25	Jan-26
91
92	4	Servicing Other		Jan-23	Jan-24	Jan-25	Jan-26
98
99	5	Marketing Spend		Jan-23	Jan-24	Jan-25	Jan-26
104
105	Other Costs
106
107	1	Non Servicing People		Jan-23	Jan-24	Jan-25	Jan-26
110		Turn Off Additional Hires (0=off; 1=on)		-
111
112	2	Overheads	Dec-22	Jan-23	Jan-24	Jan-25	Jan-26
122
123	3	Non Recuring Items		Jan-23	Jan-24	Jan-25	Jan-26
136
137
138	Settings
139
140	A	TIME PERIOD
141		Factor		1,000
142		M=Month / Q=Quarter / Y = Year		Q
143		Last Actual Month For Forecast		Dec-22
144		Last Actual For Output		Jun-22
145
146	B	Pipe Actuals
147		File > PLEASE MAKE A COPY - Dot #8: Actuals Live
148		Range
149