| 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 | ||||||||||||||||||||||||||