Financial
Year |
|
2005-2006 |
2006-2007 |
2007-2008 |
2008-2009 |
2009-2010 |
2010-2011 |
2011-2012 |
TOTALS |
|
2012-2013 |
2013-2014 |
2014-2015 |
2015-2016 |
2016-1017 |
2017-2018 |
2018-2019 |
2019-2020 |
2020-2021 |
2021-2022 |
2022-2023 |
2023-2024 |
2024-2025 |
2025-2026 |
2026-2027 |
2027-2028 |
TOTALS |
|
|
|
2005-2012 |
|
2012-2028 |
Cremations P/A |
|
1,330 |
1,342 |
1,354 |
1,366 |
1,378 |
1,390 |
1,402 |
|
1,414 |
1,426 |
1,438 |
1,450 |
1,462 |
1,474 |
1,486 |
1,498 |
1,510 |
1,522 |
1,534 |
1,546 |
1,558 |
1,570 |
1,582 |
1,594 |
|
|
|
|
Cost of Basic Cremation |
|
|
420 |
444 |
469 |
496 |
524 |
554 |
|
586 |
619 |
654 |
692 |
731 |
773 |
817 |
863 |
913 |
965 |
1,020 |
1,078 |
1,139 |
1,204 |
1,273 |
1,345 |
|
Inflation @ 2.7% |
|
|
11 |
23 |
36 |
49 |
64 |
|
79 |
94 |
111 |
129 |
147 |
167 |
188 |
210 |
233 |
258 |
284 |
312 |
341 |
371 |
404 |
438 |
|
(a) 3% above inflation
increase p/a |
|
|
|
13 |
26 |
40 |
55 |
71 |
|
87 |
105 |
123 |
143 |
164 |
186 |
209 |
233 |
259 |
287 |
316 |
346 |
379 |
413 |
449 |
487 |
|
New surplus created (less inflation) |
|
|
|
17,060 |
35,404 |
55,114 |
76,277 |
98,986 |
282,841 |
|
123,340 |
149,444 |
177,411 |
207,358 |
239,412 |
273,708 |
310,389 |
349,605 |
391,519 |
436,301 |
484,135 |
535,213 |
589,742 |
647,941 |
710,041 |
776,291 |
6,401,847 |
|
|
|
|
|
|
|
Cost of Basic Cremation |
|
|
420 |
463 |
510 |
562 |
619 |
683 |
|
752 |
829 |
913 |
1,007 |
1,109 |
1,222 |
1,347 |
1,485 |
1,636 |
1,803 |
1,987 |
2,189 |
2,413 |
2,659 |
2,930 |
3,229 |
|
Inflation @ 2.7% |
|
|
11 |
24 |
38 |
53 |
70 |
|
88 |
108 |
131 |
155 |
182 |
212 |
245 |
282 |
322 |
366 |
415 |
468 |
528 |
593 |
664 |
744 |
|
(b) 7.5% above inflation
increase p/a |
|
|
|
32 |
66 |
104 |
147 |
193 |
|
244 |
301 |
363 |
431 |
507 |
590 |
682 |
783 |
894 |
1,017 |
1,152 |
1,301 |
1,465 |
1,646 |
1,846 |
2,065 |
|
New surplus created (less inflation) |
|
|
|
42,651 |
90,447 |
143,955 |
203,805 |
270,695 |
751,553 |
|
345,400 |
428,780 |
521,789 |
625,485 |
741,042 |
869,762 |
1,013,090 |
1,172,628 |
1,350,152 |
1,547,635 |
1,767,262 |
2,011,456 |
2,282,907 |
2,584,595 |
2,919,827 |
3,292,267 |
23,474,079 |
|
|
|
|
|
|
|
|
|
Cost of Basic Cremation |
|
|
420 |
500 |
500 |
500 |
500 |
500 |
|
500 |
500 |
|
|
Inflation @ 2.7% |
|
|
11 |
23 |
35 |
47 |
60 |
|
73 |
86 |
|
|
(c) increase to £500 |
|
|
|
69 |
57 |
45 |
33 |
20 |
|
7 |
- 6 |
|
|
New surplus created (less effect of
inflation) |
|
|
|
92,966 |
77,881 |
62,083 |
45,550 |
28,256 |
306,736 |
|
10,179 |
- 8,709 |
|
|
(NB
value of new surplus gradually reduced due to inflation) |
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross Revenue Surplus p/a |
|
259,000 |
250,000 |
250,000 |
250,000 |
250,000 |
250,000 |
250,000 |
|
less
Bereavement Services Budget Allocation (200,000) |
|
50,000 |
50,000 |
50,000 |
50,000 |
50,000 |
50,000 |
300,000 |
|
|
|
|
|
|
|
|
Disposal of Assets (including inflation @ 2.7%) |
|
|
|
|
|
|
Crematorium lodge |
|
250,000 |
256,750 |
263,682 |
270,802 |
278,113 |
285,622 |
293,334 |
|
|
301,254 |
309,388 |
317,742 |
326,321 |
335,131 |
344,180 |
353,473 |
363,016 |
372,818 |
382,884 |
393,222 |
403,839 |
414,742 |
425,940 |
437,441 |
449,252 |
|
Ventnor Lodge |
|
170,000 |
174,590 |
179,304 |
184,145 |
189,117 |
194,223 |
199,467 |
|
204,853 |
210,384 |
216,064 |
221,898 |
227,889 |
234,042 |
240,361 |
246,851 |
253,516 |
260,361 |
267,391 |
274,610 |
282,025 |
289,640 |
297,460 |
305,491 |
|
Total |
|
420,000 |
431,340 |
442,986 |
454,947 |
467,230 |
479,846 |
492,801 |
492,801 |
|
506,107 |
519,772 |
533,806 |
548,219 |
563,020 |
578,222 |
593,834 |
609,868 |
626,334 |
643,245 |
660,613 |
678,449 |
696,767 |
715,580 |
734,901 |
754,743 |
754,743 |
(including
inflation @ 5%) |
|
|
|
|
|
|
Crematorium lodge |
|
250,000 |
262,500 |
275,625 |
289,406 |
303,877 |
319,070 |
335,024 |
|
|
351,775 |
369,364 |
387,832 |
407,224 |
427,585 |
448,964 |
471,412 |
494,983 |
519,732 |
545,719 |
573,005 |
601,655 |
631,738 |
663,324 |
696,491 |
731,315 |
|
Ventnor Lodge |
|
170,000 |
178,500 |
187,425 |
196,796 |
206,636 |
216,968 |
227,816 |
|
239,207 |
251,167 |
263,726 |
276,912 |
290,758 |
305,296 |
320,560 |
336,588 |
353,418 |
371,089 |
389,643 |
409,125 |
429,582 |
451,061 |
473,614 |
497,294 |
|
Total |
|
420,000 |
441,000 |
463,050 |
486,203 |
510,513 |
536,038 |
562,840 |
562,840 |
|
590,982 |
620,531 |
651,558 |
684,136 |
718,343 |
754,260 |
791,973 |
831,571 |
873,150 |
916,807 |
962,648 |
1,010,780 |
1,061,319 |
1,114,385 |
1,170,104 |
1,228,610 |
1,228,610 |
|
|
|
|
|
|
Grounds
Maintenance Contract (Expires Dec 2007) |
250,000 |
|
|
|
|
|
10% reduction |
|
|
|
|
25,000 |
25,000 |
25,000 |
25,000 |
100,000 |
|
|
|
|
|
|
|
|
Memorialisation
Income Projections (excluding inflation) |
|
|
|
|
|
b) 10% increase in sales
volume p/a |
|
41,000 |
41,000 |
45,100 |
49,610 |
54,571 |
60,028 |
66,031 |
|
|
72,634 |
79,897 |
87,887 |
96,676 |
106,343 |
116,978 |
128,676 |
141,543 |
155,697 |
171,267 |
188,394 |
207,233 |
227,957 |
250,752 |
275,827 |
303,410 |
|
Gross additional receipts |
|
|
|
4,100 |
8,610 |
13,571 |
19,028 |
25,031 |
70,340 |
|
31,634 |
38,897 |
46,887 |
55,676 |
65,343 |
75,978 |
87,676 |
100,543 |
114,697 |
130,267 |
147,394 |
166,233 |
186,957 |
209,752 |
234,827 |
262,410 |
1,955,173 |
Net additional receipts |
|
|
|
2,050 |
4,305 |
6,786 |
9,514 |
12,515 |
35,170 |
|
15,817 |
19,449 |
23,444 |
27,838 |
32,672 |
37,989 |
43,838 |
50,272 |
57,349 |
65,134 |
73,697 |
83,117 |
93,478 |
104,876 |
117,414 |
131,205 |
977,586 |
|
|
|
|
|
|
|
|
b) 12.5% increase in sales
volume p/a |
|
41,000 |
41,000 |
46,125 |
51,891 |
58,377 |
65,674 |
73,883 |
|
|
81,272 |
89,399 |
98,339 |
108,173 |
118,990 |
130,889 |
143,978 |
158,375 |
174,213 |
191,634 |
210,798 |
231,878 |
255,065 |
280,572 |
308,629 |
339,492 |
|
Gross additional receipts |
|
|
5,125 |
10,891 |
17,377 |
24,674 |
32,883 |
90,950 |
|
40,272 |
48,399 |
57,339 |
67,173 |
77,990 |
89,889 |
102,978 |
117,375 |
133,213 |
150,634 |
169,798 |
190,878 |
214,065 |
239,572 |
267,629 |
298,492 |
2,265,694 |
Net additional receipts |
|
|
2,563 |
5,445 |
8,688 |
12,337 |
16,442 |
45,475 |
|
20,136 |
24,199 |
28,669 |
33,586 |
38,995 |
44,944 |
51,489 |
58,688 |
66,607 |
75,317 |
84,899 |
95,439 |
107,033 |
119,786 |
133,815 |
149,246 |
1,132,847 |
|
|
|
|
|
b) 15% increase in sales
volume p/a |
|
41,000 |
41,000 |
47,150 |
54,223 |
62,356 |
71,709 |
82,466 |
|
|
90,712 |
99,783 |
109,762 |
120,738 |
132,812 |
146,093 |
160,702 |
176,772 |
194,450 |
213,895 |
235,284 |
258,813 |
284,694 |
313,163 |
344,479 |
378,927 |
|
Gross additional receipts |
|
|
6,150 |
13,223 |
21,356 |
30,709 |
41,466 |
112,903 |
|
49,712 |
58,783 |
68,762 |
79,738 |
91,812 |
105,093 |
119,702 |
135,772 |
153,450 |
172,895 |
194,284 |
217,813 |
243,694 |
272,163 |
303,479 |
337,927 |
2,605,079 |
Net additional receipts |
|
|
|
3,075 |
6,611 |
10,678 |
15,355 |
20,733 |
56,452 |
|
24,856 |
29,392 |
34,381 |
39,869 |
45,906 |
52,546 |
59,851 |
67,886 |
76,725 |
86,447 |
97,142 |
108,906 |
121,847 |
136,082 |
151,740 |
168,964 |
1,302,540 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
b) 10% increase in sales
pricing p/a |
|
41,000 |
41,000 |
45,100 |
49,610 |
54,571 |
60,028 |
66,031 |
|
|
72,634 |
79,897 |
87,887 |
96,676 |
106,343 |
116,978 |
128,676 |
141,543 |
155,697 |
171,267 |
188,394 |
207,233 |
227,957 |
250,752 |
275,827 |
303,410 |
|
Net additional receipts |
|
|
|
4,100 |
8,610 |
13,571 |
19,028 |
25,031 |
70,340 |
|
31,634 |
38,897 |
46,887 |
55,676 |
65,343 |
75,978 |
87,676 |
100,543 |
114,697 |
130,267 |
147,394 |
166,233 |
186,957 |
209,752 |
234,827 |
262,410 |
1,955,173 |
|
|
|
|
|
|
|
|
b) 12.5% increase in sales
pricing p/a |
|
41,000 |
41,000 |
46,125 |
51,891 |
58,377 |
65,674 |
73,883 |
|
|
81,272 |
89,399 |
98,339 |
108,173 |
118,990 |
130,889 |
143,978 |
158,375 |
174,213 |
191,634 |
210,798 |
231,878 |
255,065 |
280,572 |
308,629 |
339,492 |
|
Net additional receipts |
|
|
5,125 |
10,891 |
17,377 |
24,674 |
32,883 |
90,950 |
|
40,272 |
48,399 |
57,339 |
67,173 |
77,990 |
89,889 |
102,978 |
117,375 |
133,213 |
150,634 |
169,798 |
190,878 |
214,065 |
239,572 |
267,629 |
298,492 |
2,265,694 |
|
|
|
|
|
b) 15% increase in sales
volume p/a |
|
41,000 |
41,000 |
47,150 |
54,223 |
62,356 |
71,709 |
82,466 |
|
|
90,712 |
99,783 |
109,762 |
120,738 |
132,812 |
146,093 |
160,702 |
176,772 |
194,450 |
213,895 |
235,284 |
258,813 |
284,694 |
313,163 |
344,479 |
378,927 |
|
Net additional receipts |
|
|
6,150 |
13,223 |
21,356 |
30,709 |
41,466 |
112,903 |
|
49,712 |
58,783 |
68,762 |
79,738 |
91,812 |
105,093 |
119,702 |
135,772 |
153,450 |
172,895 |
194,284 |
217,813 |
243,694 |
272,163 |
303,479 |
337,927 |
2,605,079 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
b) 10% increase in sales
volume and pricing p/a |
|
41,000 |
41,000 |
49,200 |
58,220 |
68,142 |
79,056 |
91,062 |
|
|
104,268 |
118,795 |
134,774 |
152,352 |
171,687 |
192,956 |
216,351 |
242,086 |
270,395 |
301,534 |
335,788 |
373,467 |
414,913 |
460,505 |
510,655 |
565,820 |
|
Gross additional receipts |
|
|
|
8,200 |
17,220 |
27,142 |
38,056 |
50,062 |
140,680 |
|
63,268 |
77,795 |
93,774 |
111,352 |
130,687 |
151,956 |
175,351 |
201,086 |
229,395 |
260,534 |
294,788 |
332,467 |
373,913 |
419,505 |
469,655 |
524,820 |
3,910,345 |
Net additional receipts |
|
|
|
6,150 |
12,915 |
20,357 |
28,542 |
37,546 |
105,510 |
|
47,451 |
58,346 |
70,331 |
83,514 |
98,015 |
113,967 |
131,513 |
150,815 |
172,046 |
195,401 |
221,091 |
249,350 |
280,435 |
314,628 |
352,241 |
393,615 |
2,932,759 |
|
|
|
|
|
|
|
b) 12.5% increase in sales
volume and pricing p/a |
|
41,000 |
41,000 |
51,250 |
62,781 |
75,754 |
90,348 |
106,767 |
|
|
121,543 |
137,798 |
155,677 |
175,345 |
196,980 |
220,778 |
246,955 |
275,751 |
307,426 |
342,269 |
380,596 |
422,755 |
469,131 |
520,144 |
576,258 |
637,984 |
|
Gross additional receipts |
|
|
10,250 |
21,781 |
34,754 |
49,348 |
65,767 |
181,900 |
|
80,543 |
96,798 |
114,677 |
134,345 |
155,980 |
179,778 |
205,955 |
234,751 |
266,426 |
301,269 |
339,596 |
381,755 |
428,131 |
479,144 |
535,258 |
596,984 |
4,531,389 |
Net additional receipts |
|
|
7,688 |
16,336 |
26,065 |
37,011 |
49,325 |
136,425 |
|
60,407 |
72,598 |
86,008 |
100,759 |
116,985 |
134,833 |
154,467 |
176,063 |
199,820 |
225,952 |
254,697 |
286,316 |
321,098 |
359,358 |
401,444 |
447,738 |
3,398,542 |
|
|
|
|
|
b) 15% increase in sales
volume and pricing p/a |
|
41,000 |
41,000 |
53,300 |
67,445 |
83,712 |
102,419 |
123,931 |
|
|
140,424 |
158,567 |
178,524 |
200,476 |
224,623 |
251,186 |
280,404 |
312,545 |
347,899 |
386,789 |
429,568 |
476,625 |
528,388 |
585,326 |
647,959 |
716,855 |
|
Gross additional receipts |
|
|
12,300 |
26,445 |
42,712 |
61,419 |
82,931 |
225,807 |
|
99,424 |
117,567 |
137,524 |
159,476 |
183,623 |
210,186 |
239,404 |
271,545 |
306,899 |
345,789 |
388,568 |
435,625 |
487,388 |
544,326 |
606,959 |
675,855 |
5,210,159 |
Net additional receipts |
|
|
9,225 |
19,834 |
32,034 |
46,064 |
62,198 |
169,355 |
|
74,568 |
88,175 |
103,143 |
119,607 |
137,718 |
157,639 |
179,553 |
203,659 |
230,175 |
259,342 |
291,426 |
326,719 |
365,541 |
408,245 |
455,219 |
506,891 |
3,907,619 |
|
|
|
b) £125 average sale based on 35% sales |
|
|
41,000 |
59,238 |
59,763 |
60,288 |
60,813 |
61,338 |
|
|
61,863 |
62,388 |
62,913 |
63,438 |
63,963 |
64,488 |
65,013 |
65,538 |
66,063 |
66,588 |
67,113 |
67,638 |
68,163 |
68,688 |
69,213 |
69,738 |
|
|
|
|
18,238 |
17,188 |
17,188 |
17,188 |
17,188 |
86,990 |
|
20,863 |
21,388 |
21,913 |
22,438 |
22,963 |
23,488 |
24,013 |
24,538 |
25,063 |
25,588 |
26,113 |
26,638 |
27,163 |
27,688 |
28,213 |
28,738 |
396,800 |
|
|
|
|
|
|
|
Investment Required (including inflation @ 2.7%) |
|
|
|
|
|
|
|
|
3x Cremators and Emissions Reduction
Technology |
|
900,000 |
924,300 |
949,256 |
974,886 |
1,001,208 |
1,028,241 |
1,056,003 |
-1,056,003 |
|
|
|
2x Cremators and Emissions Reduction
Technology |
|
650,000 |
667,550 |
685,574 |
704,084 |
723,095 |
742,618 |
762,669 |
-
762,669 |
|
|
|
|
|
|
|
|
|
|
Prudential borrowing |
|
Fixed repayment 15 year
repayment schedule |
|
650,000 |
|
- 70,995 |
|
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
- 70,995 |
|
- 1,064,920 |
|
|
|
|
|
|
|
Leasing |
|
|
|
|
|
|
|
Fixed repayment 15 year
repayment schedule |
|
650,000 |
|
- 74,080 |
|
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
- 74,080 |
|
- 1,111,195 |
|
|
|
|
|
|
|
Crematorium Market Value |
|
2,000,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Potential
Caprital Receipt |
|
2,000,000 |
|
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
|
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
2,000,000 |
|
Interest p/a at 4.5% |
|
|
|
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
450,000 |
|
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
90,000 |
|
Annual Bereavement Services Deficit |
|
200,000 |
|
-
130,000 |
- 133,510 |
- 137,115 |
- 140,817 |
- 144,619 |
- 686,061 |
|
- 148,524 |
- 152,534 |
- 156,652 |
- 160,882 |
- 165,226 |
- 169,687 |
- 174,268 |
- 178,973 |
- 183,806 |
- 188,769 |
- 193,865 |
- 199,100 |
- 204,475 |
- 209,996 |
- 215,666 |
- 221,489 |
|
Interest less deficit (excluding
inflation) |
|
|
|
- 40,000 |
- 43,510 |
- 47,115 |
- 50,817 |
- 54,619 |
- 236,061 |
|
- 58,524 |
- 62,534 |
- 66,652 |
- 70,882 |
- 75,226 |
- 79,687 |
- 84,268 |
- 88,973 |
- 93,806 |
- 98,769 |
- 103,865 |
- 109,100 |
- 114,475 |
- 119,996 |
- 125,666 |
- 131,489 |
- 1,483,911 |
|
Financial Year |
|
2005-2006 |
2006-2007 |
2007-2008 |
2008-2009 |
2009-2010 |
2010-2011 |
2011-2012 |
TOTALS |
|
2012-2013 |
2013-2014 |
2014-2015 |
2015-2016 |
2016-1017 |
2017-2018 |
2018-2019 |
2019-2020 |
2020-2021 |
2021-2022 |
2022-2023 |
2023-2024 |
2024-2025 |
2025-2026 |
2026-2027 |
2027-2028 |
TOTALS |
|
|
|
2005-2012 |
|
2012-2028 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|