SARS Cash flow Projection - Project.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Cash Flow Projection
2	SARS
3	Starting date	Jan-22
4	Cash balance alert minimum
5
6		Beginning	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Total
7	Cash on hand (beginning of month)			30,668	42,000	40,181	36,179	36,447	24,919	40,589	29,036	27,912	55,956	57,113	357,211
8
9	CASH RECEIPTS		Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Total
10	Cash sales (Family health insurance)		34,608	34,608	46,144	23,072	46,144	34,608	46,144	34,608	46,144	57,680	46,144	23,072	472,976
11	cash sales ( Building insurance)		600	730	608	1,049	750	738	1,795	600	746	760	604	608	7,012
12	cash sales ( Car insurance)		2,060	2,060	2,884	1,648	2,472	2,472	1,648	2,060	3,708	1,648	2,472	2,060	27,192
13	cash sales ( Heaith care cash plan insurance)		1,368	1,710	1,368	1,710	2,052	2,394	1,710	1,710	2,052	3,078	2,394	2,736	24,282
14	Interest, other income
15	Loan proceeds
16	Owner contributions		45,000	23,000		20,000			15,000			15,000			118,000
17	TOTAL CASH RECEIPTS		78,916	57,258	44,628	43,134	45,724	34,530	61,206	34,258	44,488	74,110	46,066	23,748	649,462
18	Total cash available	0	78,916	87,926	86,628	83,315	81,903	70,977	86,125	74,847	73,524	102,022	102,022	80,861	1,009,066
19
20	CASH PAID OUT		Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Total
21	Rent (office in London)		24,800	24,800	24,800	24,800	24,800	24,800	24,800	24,800	24,800	24,800	24,800	24,800	297,600
22	Advertising		562	562	562	562	562	562	562	630	630	630	630	630	7,084
23	Website expense		11,256	764	764	764	764	764	764	764	764	764	764	764	19,660
24	Registration charge		23	0	0	0	0	0	0	0	0	0	0	0	23
25	Materials and supplies (office supplies)		730	730	730	730	730	730	730	730	730	730			7,300
26	Interest expense														0
27	Insurance (other than health)		41.6	41.6	41.6	41.6	41.6	41.6	41.6	41.6	41.6	41.6	41.6	41.6	499.2
28	Commissions and fees		0	60	200	400	0	200	0	300	250	150	0	0	1,560
29	Mortgage interest		0	0	0	0	0	0	0	0	0	0	0	0	0
30	Office expense		2,644	1,844	1,932	1,722	1,389	1,562	1,448	1,352	1,289	1,377	1,429	1,328	19,316
31	Other interest expense														0
32	Pension and profit-sharing plan														0
33	Meals and entertainment (xmas meal)		0	0	0	0	0	0	0	0	0	0	0	429	429
34	Equipment (printers)		450	0	0	0	0	0	0	0	0	0	0	0	450
35	Repairs and maintenance		0	0	175	820	0	291	0	0	0	388	0	0	1,674
36	Supplies (not in COGS)		126	77	86	86	97	72	79	114	84	99	76	93	1,089
37	Taxes and licenses		2,866	2,866	2,866	2,866	2,866	2,866	2,866	2,866	2,866	2,866	2,866	2,866	34,392
38	Travel (fuel reimbursement)		96	0	52	131	0	0	84	36	0	42	98	0	539
39	Utilities		264	223	281	255	249	211	203	220	199	221	246	230	2,802
40	Wages (5 employees)		13,958	13,958	13,958	13,958	13,958	13,958	13,958	13,958	13,958	13,958	13,958	13,958	167,496
41	SUBTOTAL		57,817	45,926	46,448	47,136	45,457	46,058	45,536	45,812	45,612	46,067	44,909	45,140	561,913
42	CASH PAID OUT		Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Total
43	Loan principal payment														0
44	Capital purchases														0
45	Other startup costs														0
46	To reserve and/or escrow														0
47	Owners' withdrawal		0	0	0	0	0	0	0	0	0	0	0	0	0
48	TOTAL CASH PAID OUT		57,817	45,926	46,448	47,136	45,457	46,058	45,536	45,812	45,612	46,067	44,909	45,140
49	Cash on hand (end of month)	0	21,100	42,000	40,181	36,179	36,447	24,919	40,589	29,036	27,912	55,956	57,113	35,721	447,153
50
51	Net Cahflow		30,668	41,076	38,333	33,407	32,751	19,649	33,746	20,686	18,056	44,594	44,245	21,348
52	Discount factor		0.909	0.909	0.909	0.909	0.909	0.909	0.909	0.909	0.909	0.909	0.909	0.909
53	Present Value		27877.212	37338.084	34844.697	30366.963	29770.659	17860.941	30675.114	18803.574	16412.904	40535.946	40218.705	19405.332
54
55	NPV		344110.131
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