Mohalla_Watt_Financial_Model.xlsx

	A	B
1	MOHALLA WATT \| Financial Model
2	Community solar on the neighbourhood transformer - Pakistan. Graphiques Innovation Challenge 2026.

3
4
5	WHAT THIS MODEL SHOWS
6		The full economics of one 'Mohalla Node' - a 60 kWp solar canopy on a mosque/school roof that sells
7		locked-price electricity to ~100 households on the same low-voltage distribution transformer - plus the
8		household case, the utility (DISCO) case, the national rollout, and sensitivity testing.
9
10	HOW TO USE IT
11		1. Open the 'Assumptions' tab. Every BLUE number is an input you can change.
12		2. Cells with a YELLOW fill are the key levers that drive the result.
13		3. Everything in BLACK is a formula. Everything in GREEN links to another sheet. Do not overwrite them.
14		4. Change an input and the whole workbook recalculates.
15
16	TABS
17	Assumptions	All inputs: site, technical, cost, tariff, financing, macro. Single source of truth.
18	Node Economics	One node: CAPEX build-up, 25-year generation, revenue, OPEX, cash flow, IRR / NPV / payback.
19	Household Impact	What a subscribing household pays and saves over 10 years vs the escalating grid tariff.
20	DISCO Case	Why the distribution company gains rather than loses - avoided losses, deferred capex, retained load.
21	Musharakah	The Shariah-compliant ownership transfer: how the mohalla buys the asset out by Year 8.
22	National Scale	Rollout to 2036: nodes, capacity, households reached, capital required, household savings, CO2.
23	Sensitivity	How the result moves when yield, CAPEX, tariff and collection rate move against us.
24	Sources	Every external figure used, with its source.
25
26	COLOUR LEGEND
27	Blue text	Hardcoded input - edit this.
28	Black text	Formula - do not edit.
29	Green text	Link to another sheet - do not edit.
30	Yellow fill	Key assumption / main lever.
31
32	CURRENCY	All figures in Pakistani Rupees (PKR) unless marked. USD conversion at Rs 277 / US$ (13 Sep 2026).
33	IMPORTANT	This is a concept-stage model built for an innovation challenge, not an investment prospectus.
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