DSW grant size, costs and RFMF_2021

	A	B	C	D	E	F	G	H	I	J
1	Grant size - 2021
2	Grant size
3	DSW expected budget
4			Malawi	Uganda	Kenya	Other	Total	% of total	Source/notes
5	Scale up		$5,366,822	$5,516,885			$10,883,707	14%	Calc
6	Maintenance		$19,491,346	$20,046,129	$10,118,022		$49,655,497	64%	Calc
7		Current footprint	$6,242,251	$7,600,053	$10,118,022		$23,960,325		Calc
8		Expansion	$13,249,095	$12,446,077			$25,695,172		Calc
9	Exit		$7,864,604	$8,035,737			$15,900,340	21%	Calc
10		Current footprint	$2,684,593	$3,173,340			$5,857,932		Calc
11		Expansion	$5,180,011	$4,862,397			$10,042,408		Calc
12	Scoping					$976,942	$976,942	1%	Calc
13	Total						$77,416,486	100%	Calc
14
15	DSW expected revenue
16		Funds received by DSW from non-GW donors, 4 years	$ 10,573,106						'Source:DSW fundraising' tab
17		Cash on hand	$ 2,120,000						'Source:DSW fundraising' tab
18	Total		$ 12,693,106				$12,693,106
19
20	Grant size		$64,723,380				$64,723,380		Calc
21		Exit grant	$15,900,340						Calc. We do not subtract DSW expected revenue from the exit grant, since it is in the spirit of the grant that we absorb the cost of exit.
22		Grant for maintenance, scale up and scoping	$48,823,040						Calc
23
24	DSW grant - fine grained. N.b. we subtract DSW revenue from maintenance and scale up costs but not from exit costs
25			Malawi	Uganda	Kenya	Other	Total (by project phase)	% of total (by project phase)
26	Scale up		$4,259,444	$4,378,543			$8,637,987	13%	Calc
27	Maintenance		$15,469,545	$15,909,855	$8,030,291		$39,409,691	61%	Calc
28		Current footprint	$4,954,239	$6,031,875	$8,030,291		$19,016,405		Calc
29		Expansion	$10,515,306	$9,877,980			$20,393,287		Calc
30	Exit		$7,864,604	$8,035,737			$15,900,340	25%	Calc
31		Current footprint	$2,684,593	$3,173,340			$5,857,932		Calc
32		Expansion	$5,180,011	$4,862,397			$10,042,408		Calc
33	Scoping					$775,362	$775,362	1%	Calc
34	Total						$64,723,380	100%	Calc
35
36	Total (by country)		$27,593,592	$28,324,135	$8,030,291	$775,362	$64,723,380		Calc
37	% of total (by country)		43%	44%	12%	1%	100%		Calc
38
39	Extension of DSW's current footprint in Kenya, Malawi, and Uganda		$24,874,337						Calc
40	Expansion of DSW's footprint in Malawi and Uganda		$39,073,681						Calc
41
42	DSW budget - fine grained
43	Scale up split
44		Program management and material	$4,978,162						Calc	Includes chlorine procurement, dispenser parts, fuel and vehicle costs for delivery, community and promoter engagement materials, etc.
45		Personnel	$2,488,139						Calc	Includes staff salaries and employee benefits
46		Office-related expenses	$809,992						Calc	Includes Offices expenses, Information Technology, and Occupancy
47		Other	$2,607,415						Calc	Includes Contract Services, Staff Travel, Non-Staff Travel, Insurance, Conference and Meetings, Depreciation and Amortization, Other, and Indirect Costs
48		Total	$10,883,707						Calc
49
50	Maintenance split
51		Program management and material	$15,917,489						Calc	As above
52		Personnel	$16,939,299						Calc	As above
53		Office-related expenses	$4,324,221						Calc	As above
54		Other	$12,474,487						Calc	As above
55		Total	$49,655,496						Calc
56
57	Exit split
58		Program management and material	$5,147,393						Calc	As above
59		Personnel	$5,332,462						Calc	As above
60		Office-related expenses	$1,395,678						Calc	As above
61		Other	$4,024,807						Calc	As above
62		Total	$15,900,340						Calc
63	Scoping split
64		Salaries	$456,167
65		Contract services	$220,000
66		Travel	$104,400
67		Other	$196,375
68		Total	$976,942
69
70	Disbursement schedule
71	Note - cells highlighted in yellow mark exit grants. Exit grants are conditional on GW deciding to terminate support for this program and Evidence Action deciding to discontinue its operations.
72			Y1	Y2	Y3	Y4	Y5	Y6	Y7	All years
73	Buget		2022	2023	2024	2025	2026	2026	2026
74		Scoping	$976,942
75		Current footprint - maintenance	$6,421,104	$6,742,155	$7,079,263	$3,717,803
76		Expansion - scale up and maintenance	$10,883,707	$5,961,584	$6,259,663	$6,572,646	$6,901,278
77		Current footprint - exit					$3,841,267	$2,016,665
78		Expansion - exit						$6,573,825	$3,468,583
79		TOTAL	$18,281,753	$12,703,739	$13,338,926	$10,290,449	$10,742,545	$8,590,491	$3,468,583	$77,416,485
80	Revenue		$2,120,000	$3,868,175	$2,234,977	$2,234,977	$2,234,977			$12,693,106
81	Disbursement, with max exit funds		$16,161,753	$8,835,564	$11,103,949	$8,055,472	$8,507,568	$8,590,491	$3,468,583	$64,723,379
82	Disbursement, without exit funds		$16,161,753	$8,835,564	$11,103,949	$8,055,472	$4,666,301	$0	$0
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100