FFH IIR calculator.xlsx

	A	B	C	D	E	F	G	H
1	Year	Penetration Rate (%)	Cumulative Homes Connected	New Connections	Revenue per Year ($)	Installation Costs ($)	Net Cash Flow ($)	ROI
2	0	0%	0	0	0	0	-11,700,000
3	1	10%	900	900	756,000	630,000	50,400	0.43%
4	2	10%	900	0	756,000	0	680,400	5.82%
5	3	35%	3150	2250	2,646,000	1,575,000	806,400	6.89%
6	4	35%	3150	0	2,646,000	0	2,381,400	20.35%
7	5	60%	5400	2250	4,536,000	1,575,000	2,507,400	21.43%
8	6	60%	5400	0	4,536,000	0	4,082,400	34.89%
9	7	90%	8100	2700	6,804,000	1,890,000	4,233,600	36.18%
10	8	90%	8100	0	6,804,000	0	6,123,600	52.34%
11	9	90%	8100	0	6,804,000	0	6,123,600	52.34%
12	10	90%	8100	0	6,804,000	0	6,123,600	52.34%
13	11	90%	8100	0	6,804,000	0	6,123,600	52.34%
14	12	90%	8100	0	6,804,000	0	6,123,600	52.34%
15	13	90%	8100	0	6,804,000	0	6,123,600	52.34%
16	14	90%	8100	0	6,804,000	0	6,123,600	52.34%
17	15	90%	8100	0	6,804,000	0	6,123,600	52.34%
18	16	90%	8100	0	6,804,000	0	6,123,600	52.34%
19	17	90%	8100	0	6,804,000	0	6,123,600	52.34%
20	18	90%	8100	0	6,804,000	0	6,123,600	52.34%
21	19	90%	8100	0	6,804,000	0	6,123,600	52.34%
22	20	90%	8100	0	6,804,000	0	6,123,600	52.34%
23
24		Homes	9000
25		ARPU	70
26		Passing Cost	1300
27		Install Cost	700
28		Discount Rate	10%
29		IRR	22%
30
31		Variable Costs	10.00%
32
33
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