Draft Long Term Financial Plan 2023 - 2033

Page 1

Long Term Financial Plan (Draft)

Record No: 23/18066

Version No: 1.0

2023 – 2033
Long Term Financial Plan 2023 - 2033 2 Contents 1 Introduction....................................................................................................................................................3 2 About Federation Council...............................................................................................................................5 3 Objectives.......................................................................................................................................................9 4 Financial sustainability................................................................................................................................. 10 5 Scenarios...................................................................................................................................................... 13 6 Sensitivity/Assumptions.............................................................................................................................. 15 7 Productivity Improvements and Cost Containment Strategies................................................................... 18 8 Capital Works Plan....................................................................................................................................... 23 9 Monitoring Key Performance Indicators..................................................................................................... 26 10 Financial statements................................................................................................................................ 30 APPENDIX A – FINANCIAL SUSTAINABILITY INDICATORS (PLANNED SCENARIO)................................................ 79 Document History Version Date Council resolution Changes / Amendments 1.0 23/04/2023 88/2023FC Prepared for in principle adoption 2.0 3.0

1 INTRODUCTION

This Long Term Financial Plan (LTFP) provides the strategic framework including ten year forward projections based on a range of scenarios to direct Council’s longer-term financial sustainability. The LTFP is updated annually to respond to any changes in the previous year, and to ensure it is always projecting out ten years, so itisessentiallyarollingplan. TheLTFPisalsoupdatedatothertimesasandifrequired. Forexample,torespond to significant impacts to Council’s forecast revenue and/or expenditure. This can be from things such as major emergency events, new grants being received for major projects, other unexpected expenditure requirements for example on Council assets/services, and as a result of any changes to rate income, such as from any special rate variations if applied for and received.

The information and scenarios allow Council to make decisions and adapt and respond to challenges and opportunities whilst managing its long-term financial sustainability. It also allows the establishment of key financial principles that when executed, will ensure Federation Council continues to be financially sustainable and responsible, as it delivers the services that are valued and in many cases required (for critical services) right across the vast Federation Council Local Government area.

Council is required to follow the Integrated Planning and Reporting requirements set out by the NSW Government. See below for a diagram of how these suite of strategic documents interact to inform from a 10 year horizon, down into Council’s 4 and 1 year plans (in orange). This LTFP is within the Resourcing Strategy set of plans.

The Community Strategic Plan outlines the needs and aspirations of the Federation community, delivered through the Delivery Program and Operational Plans of Council. The Resourcing Strategy is critical to ensuring Council has the capability and capacity to deliver the services as planned.

The LTFP aligns the delivery of services as outlined in the community expectations with the requirement for responsible management of Council’s current and future financial sustainability. The aim of the LTFP is to

Long Term Financial Plan 2023 - 2033 3
Figure 1 – NSW Local Government Integrated Planning and Reporting Framework

provide the Council with sound financial information upon which to make decisions. Decisions made by Council will likely require continual revision of the LTFP as estimates of revenues, expenditures and capital investments are refined and become more accurate.

As decisions are made, more detail can be added to the LTFP. For example, as the council finalises its Delivery Program, the first four years of the LTFP will become firmer. As the Operational Plan is completed, the detailed budget will form the first year of the LTFP.

The LTFP has been prepared following a detailed financial review, incorporating data now available from improved strategic asset management planning. This builds on service planning work undertaken in prior years where servicemanagers identified current levelsof service, forecast future service demand, identified the asset requirements and estimated the future incomes and expenditure. This work continues to be refined as grant funding is secured for key infrastructure, internal asset data improves and the external operating environment changes (for example, as a result of the inflation and flooding).

The October 2022 flooding caused significant damage to Council and community infrastructure. A majority of the cost of repairing flood damaged infrastructure will be claimable under Council’s insurance policy or NSW Disaster Assistance Arrangements. At the time of this plan being prepared, the damage was still being assessed and quantified. As a consequence, repairs to flood damages infrastructure, proceeds for the insurance policy and proceeds through disaster funding arrangements have not been included in the LTFP. The LTFP will be updated when this information is confirmed. This report presents a full suite of financial statements for 2023/24 to 2032/33.

Long Term Financial Plan 2023 - 2033 4

2 ABOUT FEDERATION COUNCIL

2.1 Federation Council area

Federation Council was formed in May 2016 as a newly merged Council from the former Urana and Corowa ShireCouncils. FederationCouncilislocated inthe Southern Riverina Murrayarea of New SouthWales. Council has an estimated resident population of 12,899 (ABS Census 2021), up from 12,377 in the 2016 census. The Council area is 5,685 square kilometres and comprises vast productive farming land (mostly dry land and some irrigation to the south and central areas), that is predominantly used for cereal cropping and to lesser extent livestock, including sheep, cattle and pigs. The larger towns in the south also support some other industry including Manufacturing and Construction, Retail, Transport and Agriculture related industries especially. The bulk of the population reside in the southern sections of the Council area, including in the Murray River towns of Corowa, Howlong and Mulwala whilst the rural areas of Corowa Rural and Urana and Surrounds contain a mix of small towns, villages, localities and those who live on farms.

Long Term Financial Plan 2023 - 2033 5

Whilst the Council area itself has only experienced moderate population growth since the last census, there is somegrowing discussion that the area will beganto see more accelerated growth patterns. Some of the factors for this including a growing awareness of the affordability of property in the region, and the relative close proximity to Melbourne and other attractive liveability features such as wineries and snowfields nearby, excellentsportingandcommunityamenitiesespecially,lowcrimeratesandgoodhealthandeducationservices.

The COVID-19 pandemic, and more recently the Federation Council Local Government Area being listed as one of the Top 10 affordable regional areas, in the nation, as part of PRD Real Estate report into stand out regions are other factors likely to see the next 10 years outstrip the last 10 years quite comfortably in growth. See –https://www.prd.com.au/documents/2145/PRD_Stand_Out_Regions_-_Top_10_Affordable_Regional_Areas_2021.pdf

2.2 Federation Council entity

Since merger Council has been successfully awarded significant grants funds to invest in many new and upgraded community assets right across the Council region. These include skate parks, tennis and netball courts, boat ramps, extensive playgrounds, a new year round pool in Corowa, a lakeside function facility for Urana, upgraded saleyards, upgraded Murray River foreshore facilities and the list goes on. This has been possible through Commonwealth and State Government funding programs, from Stronger Communities Fund, Stronger Country Communities Program, COVID Stimulus, Drought Funding, Active NSW and other grant programs.

New and improved facilities are enhancing the area’s reputation for liveability greatly. Council has also undertaken significant grant funded investment into its roads and related infrastructure network, however there remains a significant challenge in managing these assets with current revenue levels.

Council as an entity has experienced rapid changes and growth since its creation in May 2016. Both former Councils had historically low rate bases and disproportionateasset bases topopulation levels. Thesechallenges include a road network of 2,310 km of roads broken into 999 km of sealed roads and 1,311 km of gravel roads. Council also due to having 14 towns and villages, have a large amount of relatively low usage but high priority to the community, facilities, such as halls, courts and ovals. These are spread across the towns and villages of Corowa, Howlong, Mulwala, Urana, Balldale, Boree Creek, Buraja-Lowesdale, Coreen, Daysdale, Morundah, Oaklands, Rand, Rennie and Savernake. Council also has varying service levels across each of these facilities. Council’s total non-current assets are recorded at $670,200,000, with an annual depreciation amount of $13,034,000 from Council’s 2021/22 Financial Statements. Prior to the creation of Federation Council, both Councils had infrastructure backlogs, being $17,693,000 (Corowa Shire) and $3,433,000 (Urana Shire) as taken from the last financial statements from each Council. This backlog was attributed to due to low rate bases and historic issues of cost shifting from the State Government, and general underfunding from State and Federal Governments.

Council has maintained very low general rate charges over many decades. This has been due to rate pegging, strong consideration towards the rural rate base and economic factors. Some significant achievements have been made by the Council given the limited rate revenue and the high level of infrastructure and service demands.

Long Term Financial Plan 2023 - 2033 6

Currently average overall rates are amongst the lowest in NSW. When compared to other NSW rural councils with population between 10,0001 and 20,000, Federation Council average residential rates are the fourth lowest, as reported in the graph below.

2.3 Council Services

Council provides forty-five (45) separate services that include statutory responsibilities and other services that are not required under the current enabling legislation, the Local Government Act 1993, or other statutes. The provision of other services that require full or part subsidisation from the general rate revenue is a challenge for Council’s financial planning. Past cost-shifting from other levels of government to Council without adequate funding places further stresses upon the financial planning of Council.

The identified 45 services are as follows:

 Aerodrome

 Bridges

 Caravan Parks

 Cemeteries

 Communication & Engagement

 Community Services

 Corowa Saleyards

 Council Buildings

 Customer Services

 Depots

 Development Assessment & Building Control

 Directorate Support

 Domestic Waste

 Drainage

 Economic Development

 Electrical Services

 Emergency Management

 Engineering & Design

 Environmental Services & Natural Resources

 Event Management

 Executive Services

 Finance

 Fleet Management

 Footpaths

 Governance

 Grants

 Human Resources

 Information Technology

 Land Management

 Landfills

 Libraries

 Mobile Pre-School

 Procurement

 Quarries

 Regulation & Compliance

 Risk & Safety

 Roads

 Service NSW

 Sewerage Operations

 Sporting Playgrounds Presentation

 Strategic Land Use Planning

 Swimming Pools

 Tourism

 Waste Management

 Water Operations

Long Term Financial Plan 2023 - 2033 7

Mandatory services undertaken by Federation Council include the provision of roads, drainage, bridges, footpaths, cemeteries, waste, emergency management, environmental and natural resources, land management, regulation, water and sewerage, library, disability inclusion activities, as well as the community leadership, advocacy and management functions of the Council.

Some of the other service areas undertaken by Federation Council to support a stronger community include:

 Corowa Aquatic Centre and other swimming pools,

 Industrial Subdivision developments,

 Parks, gardens and sporting grounds,

 Corowa Saleyards,

 Corowa Aerodrome,

 Caravan Parks (Ball Park Caravan Park Corowa and Urana Caravan Park), and

 Services relating to Youth, Aged, Medical Services (GP) support, Mobile Preschools, Health, Early and Seniors Education, Social, Arts and Culture, Tourism and Economic Development.

Council values and acknowledges that these services are a priority, given that they make a place more liveable and a place that visitors want to visit, as has been communicated by the community in various forums over the past four years. In addition, Council acknowledges its role in supporting economic activity in the Council area, as evidenced by its commitment to developing industrial land and operating caravan parks and the Corowa Saleyards. These activities are able to generate economic activity for local businesses and result in more employment opportunities. In addition, over time these activities will be able to generate a financial return to Council which will assist in alleviating the rates burden.

It is the responsibility of Council to plan and prioritise services through the LTFP, which inevitably includes balancing financial needs of these services, as well as the affordability of the rate and charges burden upon the community.

Over the coming four years, levels of service provided in many areas will be reviewed in consultation with the community.

Long Term Financial Plan 2023 - 2033 8

3 OBJECTIVES

The objectives of the Federation Council LTFP are to:

 Understand thecumulativeeffectsof Council’s servicerequirements, assetmanagement commitments and the community aspirations.

 Identify the financial opportunities and threats confronting Council.

 Provide a basis for sound and strategic decision-making.

 Ensure that Council’s decision-making processes are undertaken within a framework of financial sustainability.

 Meet the requirements of the Office of Local Government (OLG) Integrated Planning and Reporting (IP&R) framework.

Long Term Financial Plan 2023 - 2033 9

4 FINANCIAL SUSTAINABILITY

Financial sustainability is about having the capacity to deliver services, absorb changes and shocks and make decisions in the best interests of the community over the long term (10 years plus). This focus is to ensure Council’s decisions made today regarding financial, physical and human resources take account of the longterm impacts, which include:

 meeting the agreed service needs of the community;

 maintaining, operating and upgrading infrastructure and equipment to an acceptable condition and capacity to meet service needs;

 absorbing foreseeable changes and unexpected shocks without having to make disruptive revenue or expenditure adjustments;

 having strong governance and management frameworks in place covering community engagement, planning, monitoring, reporting and decision making; and

 reflects the objectives of Federation Council to maintain a financially sustainable position across its 10-year planning horizon.

4.1 Approach to financial sustainability

Following the merger of the former Corowa and Urana Shire Councils in May 2016, Council’s priority had been establishing itself as new, larger, more mature organisation, and delivering on the significant community projects funded through the Stronger Communities Program.

With a more robust organisation now in place, Council has been strongly focused on its financial sustainability challenges. It is primarily doing this based on:

 engaging with the community on current services provided, reviewing service levels and obtaining clarity on community expectations.

 implementing improvements to asset management practices across all asset classes (moving from a reactive to a proactive approach and undertaking greater prioritisation of works).

 establishing targets and monitoring key financial performance measures to guide long term financial planning and improve Council’s financial position.

 implementing a finance services improvement strategy to ensure the organisation is well supported by its finance function and is able to make well-informed and considered decisions.

 identifying opportunities and implementing measures to improve productivity and contain costs.

 maximising the quality of grant applications into competitive Commonwealth and State Government funding programs

 maximising other revenue streams, such as income from the saleyards, caravan parks and aquatic centres.

Even with these measures, given the quantum of funds required to be invested into existing roads and other infrastructureassets(over$4millionperannum),Councilhaslittlechoicebuttoproceedwithincreasedgeneral rates (subject to IPART approval) to maintain and restore assets to the level expected by the community.

4.2 Financial sustainability ratios

Key financial performance measures to guide long term financial planning and improve Council’s financial position have been established. The table below provides a summary of the targets with the immediate focus on measures to address short term financial sustainability.

Long Term Financial Plan 2023 - 2033 10

Section 9 containsthe IP&R Key Performance Indicators for the Recommended Scenario at a consolidated level. Appendix A provides the financial ratios by fund. This provides a more meaningful analysis and enables better targeting of strategies to address ratios that do not meet recommended targets.

4.3 Asset management improvements

The State of our Council Infrastructure Asset (SOCIA) report was presented to the November 2022 Council meeting, providing a summary of the current situation of council’s assets based on a risk assessment approach. The report informs the Strategic Asset Management Plan (SAMP) and the report on infrastructure assets contained in the annual financial statements.

Council’s Strategic Asset Management Plan (SAMP) which was adopted in early 2023 defines its strategic direction(whereCouncilwants tobe,consideringthecurrent situation) andobjectivestokeep iton track.While the SOCIA Report identifies the cost of work required to bring all assets to a satisfactory standard, the SAMP outlines council’s limited financial capacity and utilising a risk management approach and prioritises the assets that can be brought to a satisfactory standard.

Long Term Financial Plan 2023 - 2033 11 Ratio Calculation Target Source Operatingperformance Totalcontinuingoperatingrevenueexcludingcapitalgrants andcontributionslessoperatingexpenses/Totalcontinuing operatingrevenueexcludingcapitalgrantsand contributions >0 IP&R Ownsourceoperating revenue Totalcontinuingoperatingrevenue1excludingallgrants andcontributions/Totalcontinuingoperatingrevenue1 inclusiveofallgrantsandcontributions >60% IP&R Unrestrictedcurrentratio Currentassetslessallexternalrestrictions/Current liabilitieslessspecificpurposeliabilities >1.5x IP&R Debtservicecoverratio Operatingresults1beforecapitalexcludinginterestand depreciation/impairment/amortisation/Principal repayments(fromtheStatementofCashFlows)+ borrowingcosts(fromtheIncomeStatement) >2x IP&R Ratesandannualcharges outstandingpercentage Ratesandannualchargesoutstanding/Ratesandannual chargescollectable <10% IP&R Cashexpenseratio (Currentyear’scashandcashequivalents+termdeposits/ Paymentsfromcashflowofoperatingandfinancing activities)x12 >3months IP&R Unrestrictedcash(effective) UnrestrictedcashlessFAGsadvancepaymentlesscreditors plusgovernmentdebtors >$1million Internal Internallyrestrictedreserve -waste Internallyrestrictedwastereserve/WasteManagement Levycollectedlessfundsincurredtorehabilitateclosed landfill/s(cumulative) 100% Internal Capitalexpenditureratio Capitalexpenditure/Depreciation >110% Tcorp Buildingsandinfrastructure renewalsratio Assetrenewals/Depreciation,amortisationand impairment >100% IP&R Infrastructurebacklogratio Estimatedcosttobringassetstoasatisfactorystandard/ Netcarryingamountofinfrastructureassets <2% IP&R Assetmaintenanceratio Actualassetmaintenance/Requiredassetmaintenance >100% IP&R

A Roads Strategy Committee was previously established to provide a better understanding of Council’s asset management and renewal requirements with respect to roads, enabling appropriate long term financial planning to be undertaken. Work will continue with this Committee in 2023/24 to progress improvements.

Long Term Financial Plan 2023 - 2033 12

5 SCENARIOS

Under the NSW Integrated Planning and Reporting framework, the development process for the LTFP should include financial modelling of different scenarios (e.g. planned/optimistic/conservative). The use of scenarios provides the Councilwith an idea of howmuch flexibility is in thePlan and how much latitudeit has withvarious projects and scenarios.

The scenarios modelled are important when discussing the financial implications of the Community Strategic Plan with residents and will also assist councillors in developing suitable actions for the Delivery Program.

If councils are considering applying for a special rate variation, one of the financial scenarios developed must address this option. This will help to enable the discussion with the community about the costs and benefits of any potential increases in rates.

For the purpose of the draft LTFP 2023-2033, three options have been prepared:

Planned Scenario (Recommended):

Council obtain approval for multiple year SRV commencing 2023/24 to 2026/27. Outcome to be announced in May 2023.

This scenario provides a $46 million annual operating program and $10.4m capital program for 2023/24 and a $170m total capital program over the 10 years.

It contains special rate variation increase for four years from 2023/24 to 2026/27 being 19%, 17%, 14% & 10%. This would provide capacity for Council to address the asset management demands of existing infrastructure over anextended period of time, improve service levels in infrastructure areas, maintain similar levels of service to those currently delivered in other areas and continue to improve its financial sustainability.

This would enable Council to address the concerns being raised within the community regarding Council’s local road network and other ageing infrastructure.

Baseline Scenario:

Council unsuccessful with the SRV application with future general rates income only increased by rate pegging.

This scenario provides a $45 million annual operating program and $9.4m capital program for 2023/24 and a $129m total capital program over 10 years.

It contains rate increases at 4.3% for 2023/24 as announced by IPART, followed by a rate increase of 2.5% for future years.

This scenario would reduce Council capacity to address the asset management demands of existing infrastructure, reduce levels of service in infrastructure areas from that expected by the community and critically deteriorate Council’s financial position. It would also require a significant reduction in levels of service to those currently delivered.

Alternate Scenario:

Council unsuccessful with the SRV application with consideration to address SRV commencing from 2024/25 to 2027/28.

This scenario provides a $45 million annual operating program and $9.4m capital program for 2023/24 and a $164m total capital program over 10 years.

It contains rate increases at 4.3% for 2023/24, followed by a special rate variation for four years from 2024/25 to 2027/28 being 19%, 17%, 14% & 10%.

This scenario would delay Council’s ability to address the concerns being raised within the community regarding Council’s local road network and other ageing infrastructure by another year.

Council manages its finances using a Funds accounting approach. Separate funds are established for water, sewerage and waste (kerbside collection) services and assist Council to manage its compliance with the Local Government Act, in that funds collected for these services are only able to be expended on these services. The remaining Council responsibilities and services are managed through the General Fund. The SRV is associated with the General Fund only.

Long Term Financial Plan 2023 - 2033 13

General Fund - Operating Performance ratio

The result of Operating Performance ratio on General Fund for all 3 scenarios against the OLG recommended target shown below.

The Operating Performance ratio measures Council’s net operating result relative to operating revenue. When this ratio is positive, Council is able to provide the existing range of services and appropriately plan for the renewal of assets. It may also mean that Council is able to invest more in discretionary services and infrastructure, such as sporting ovals and community halls.

When the ratio is negative, Council is unlikely to be able to both provide the existing range of services and appropriately plan for the renewal of assets. This means that compromises are made between delivering services and renewing Council assets, such as roads, footpaths, halls, etc. In the Recommended scenario (red in the graph below)the Operating Performance ratiowillsurpass zero by Year 8. Baseline scenariowill not achieve a positive ratio, however the Alternate Scenario will achieve an improved ratio earlier because the SRV will be applicable on 4.3% rate peg (FY2023/24) instead of current 2.5% (FY2022/23).

GeneralFund-OperatingPerformance

Long Term Financial Plan 2023 - 2033 14
-0.3 -0.2 -0.1 0 0.1 0.2 2023-242024-252025-262026-272027-282028-292029-302030-312031-322032-33
Figure 2 – Operating Performance Ratio (General Fund)
TargetPlannedBaselineAlternate

6 SENSITIVITY/ASSUMPTIONS

The following is an overview of key assumptions which have been in the preparation of the Operating, Delivery Program and Long Term Financial Plan:

6.1 Levels of Service

Current levels of service for infrastructure assets (roads, footpaths, bridges, halls, etc) are assumed to be unsatisfactory. This conclusion is drawn from community feedback received in relation to infrastructure assets and professional assessment of the assets and their current and future asset management needs. Council is seeking to address this through the proposed Special Rate Variation and this is planned for in this LTFP.

Current levels of service for other services are assumed to be satisfactory and have therefore been used as a baseline for the costing to financial projections. These service levels will be reviewed over the coming four years.

6.2 Asset Renewal Predictions

This LTFP has been informed by asset renewal predictions using broad assumptions at a program level. Condition and capacity assessments are improving, providing increased confidence in predictions of when individual assets will require renewal or upgrade. Asset management process improvements continue to be made, providing more detailed assessment and predictions of asset renewals at an asset level.

6.3 Indexation Rates

A range of indexation has been applied to the income, expenditures and capital works planning. The following table details the indexation rates that have been used with the financial statements for 2023/24.

6.4 Workforce Levels

Workforce levels have been budgeted based on the organisational structure that was adopted in September 2019 and minor amendments that have been made since that time. A Workforce Management Strategy was adopted inJune2022 and iscurrentlybeing implemented. Thisisdirectingcapacityand capability enhancement over the coming years, with a key focus on organisational culture.

TheSpecialRateVariationthatissubjecttoapprovalwillcommencefrom2023/2024andisproposedtoprovide increased investment in Council’s extensive asset network. If this is approved, over time there will be an increase in capital investment. As this progresses, analysis will be undertaken to deliver this increased capital investment in the most efficient and effective manner. This may result in an increase to workforce levels. Any changes will be included in updates to this plan.

Long Term Financial Plan 2023 - 2033 15
General Fund Water Fund Sewerage Fund Domestic Waste Income Rates and Annual Charges 19.0% 5.0% 6.0% Full cost recovery User Charges and Fees 4.3% 5.0% 6.0% Full cost recovery Other Revenues 2.0% 2.0% 2.0% 2.0% Expenses Employee Costs 5.0% 5.0% 5.0% 5.0% Borrowing Costs N/A 3.0% N/A N/A Materials and Services 7.5% 7.5% 7.5% 7.5% Other Expenses 2.75% 2.75% 2.75% 2.75%

6.5 Roads to Recovery Funding and Own Source of Funds Expenditure:

Council is required to maintain at least $1.975 million expenditure on roads per year, funded from own source funds such as rates and charges, to meet the requirements of the Roads to Recovery (RTR) funding agreement. This Federal Government RTR program provides Council withan averageamountof around $1.403m in funding, primarily for use on Council Local Roads and Streets.

6.6 Rate Income and Rate Pegging:

Modelled in this plan are scenarios with different rate pegging:

 Planned scenario (as recommended): 2023/24 to 2026/27 with SRV increase of 19%, 17%, 14% and 10%, then followed by 2.5% increase for the remainder of the LTFP.

 Baseline scenario: 2023/24 with 4.3% rate peg increase followed by 2.5% increase for the remainder of the LTFP.

 Alternate scenario: 2023/24 with 4.3% rate peg increase, 2024/25 to 2027/28 with SRV increase of 19%, 17%, 14% and 10%, then followed by 2.5% increase for remainder of the LTFP.

It is noted that the outcome of the SRV application, currently before IPART, will be announced in May 2023.

6.7 Water and Sewer Fees and Charges

A number of major upgrades in the Water and Sewerage Treatment Plants (Mulwala Water, Howlong and Corowa Sewerage) are expected to be planned, designed and costed (and in some case commenced) over the period of the LTFP.

Pricing in the areas of water and sewer will be more comprehensively reviewed in future years as more information becomes available for the detailed design and operations for the new treatment plants.

An increase of 6% has been applied to the sewer fees and charges across the 10 year LTFP.

Water Access fees have been increased to $220.50 for 20mm meter size to align charges with Best Practice Water Supply and Sewerage guidelines with an appropriate split between the revenue generated from access charges to consumption Charges (recommended 25/75, currently at 23/77), while usage fees have been increased by 5%.

The threshold for water consumption charges has been revised from 450 kl to 350 kl. Residential water usage charges will be increased to $1.90 per kl for water consumption up to 350 kl and at $2.85 per kl thereafter. This is to encourage the more sustainable use of water.

6.8 Fees and Charges

Federation Council applies a range of fees and charges for services provided to the community. These are reviewed annually and set as part of Council’s Revenue Policy. Regulatory fees have been increased in accordance with legislation. However, non legislated fees and charges increase:

 by rate peg of 4.3% for first 2 years;

 then 3% for subsequent two years; and

 finally, 2.5% for the remainder of the LTFP. The waste facility/environmentallevy remains at$65per propertytomeetthecost ofregulatoryrequirements with Council’s landfills.

Cemetery fees have also been reviewed to ensure that immediate costs are recovered.

6.9 Grants Provided for Operational Purposes

Financial Assistance Grants (FAGs) are received from the Commonwealth Government and are a major source of Council’s revenue.

Long Term Financial Plan 2023 - 2033 16

The amount of the FAGs provided to Council each year has varied over the past 10 years with variations ranging from no increments to an increase equivalent to CPI. Further lobbying is occurring both state and nationally to gain an increase in this funding.

Currently, Federation Council is also reliant on the Federal Government to maintain the Roads to Recovery Program for an average amount of $1.5million. This amount has also been noted as operational revenues though it can only be utilised for Capital Works associated with transport services.

A conservative grant index (CPI) of 1.5% has been applied to recurrent grants anticipated across the 10 year LTFP.

6.10 Capital Grants

Capital grants of a competitive nature have been included at the cost of the project, or the anticipated portion. Projects relying upon capital grants (competitive) will only continue if the funding expected is received, or otherwise prioritised by Council.

6.11 Expenditure - Maintenance Costs (Materials and contracts)

Maintenance budgets have been reviewed by respective management areas. Considering the current inflation, indexation is set at:

 7.5% for first 2 years;

 then 5% for subsequent two years; and

 finally, 2.5% for the remainder of the LTFP.

6.12 Expenditure - Wages Increase (inclusive of employee benefits and on-costs)

A labour indexation applied to wages over the LTFP are:

 5% for first year;

 then 3% for subsequent three years; and

 finally, 2.5% for the remainder of the LTFP.

6.13

Expenditure – Non-Capital (Depreciation and Amortisation)

Federation Council will continue to undertake a revaluation program on all Council assets as prescribed by the Office of Local Government.

Depreciation costs used in the LTFP relate to existing assets and any proposed capital works. The results of future asset revaluations may result in depreciation estimates being revised over time.

6.14 Expenditure –Other Operating Expenses

Approximately 85% of Council other expenses is made of contribution or levies to other levels of governments, i.e. emergency service levy.

A indexation of 2.75% for first four years and the remainder term of the LTFP at 2.5% were applied.

6.15 Borrowings

Council is forecast to have borrowings of approximately $12.67million by 30 June 2023, including the upgrade of Howlong Water system that is still in the pipeline.

The second part of the borrowings for the Howlong Water system upgrade, amounting to $1.05M, have been incorporatedintotheLTFPandwillcommencein2023/24.Otherborrowingstotalling$22.25Marealsoplanned for major Water and Sewer Treatment upgrade works in 2027/28, 2028/29 2031/32 & 2032/33. These borrowings provide for construction of a new Corowa Sewerage Treatment Plant and a new Mulwala Water Treatment Plant. And are subject to approval of grant funding.

Long Term Financial Plan 2023 - 2033 17

7 PRODUCTIVITY IMPROVEMENTS AND COST CONTAINMENT STRATEGIES

Council is committed to delivering services in an efficient and effective manner. To achieve this Council has a continuing focus on identifying and implementing opportunities to improve productivity and contain costs.

Productivity improvementsand costcontainment initiatives that Council has implemented in past years include the following:

Increase productivity of employees through training, the use of technology and implementation of different methods of working

Increased training supports employees to undertake their roles more efficiently and effectively. This results in tasks being completed in less time, reduces rework and thereby provides more time to progress other Council requirements and improve the level of service provided to the community. Examples of training initiatives implemented include:

o Implemented training and apprentice program to develop skills of local employees

o Trained a number of staff to become Aerodrome Reporting Officer (ARO) back up for the Corowa Aerodrome and save cost on outsourcing this function

Utilising technology to automate processes or reduce manual activities undertaken by employees, freeing their time available for other Council requirements or improving the level of service provided to the community. Initiatives implemented include:

o Introduced fully automated patching and developed disaster recovery plan to assist in the event of a cyber security incidents

o Implemented new Customer Request Management (CRM) system providing more in-depth information and providing the user with the ability to record additional types of requests from customers. This has enabled Council to provide an improved service to the community, where Council had a separate system with some requests being double handled. This resulted in better management and respond to matters raised; moving where possible to residents being able to submit online (increase from 6%-9%)

o Installed new phone reporting software providing greater insights into workloads and performance

o Implemented software to download applications from the Planning Portal directly to Council's Application Management System Programming

Implementing alternative ways of operating can increase the productivity of employees by improving their efficiency and/or effectiveness, Relevant initiatives implemented include:

o Applied regulator to reduce turf growth in parks and garden resulting in less frequent mowing and slashing requirements

o

o Digitised plans and hardcopy forms to electronic forms to reduce administrative time

o Sprayed the Corowa Aerodrome fields with growth retardant which has significantly reduced the requirements for larger amounts of slashing

o Reorganised depot workshop and stores to improve efficiencies for a more effective layout for tool/part availability

o Set up the ability to have video conferencing from 3 meetings room to cut down the cost and time spent on travelling between offices

o Migrated phones to VOIP from obsolete ISDN systems saving communication costs. Upgraded the PABX units to allow them to act as a single unified system, and deployed IP phones to all remote offices and sites over the Microwave network.

o Trialled an SMS pilot to test a more effective way of communicating with staff

Long Term Financial Plan 2023 - 2033 18

o Developed QR Codes to reduce printing quantity and direct customers/residents to digital platform to access information

o Implemented Hootsuite Social Media Management Software to reduce duplication of effort across communication platforms and provide better monitoring of usage

o Altered Community & Economic Development scheduling practices to ensure a more complete representation of workload on calendars

o Introduced Clearing House for all Portal uploaded development applications saving staff time later in the assessment process

Reduce cost of energy across Council operations

Council incurs approximately $1.9 million in energy (electricity, gas and fuel) costs across its operations each year. Reducing the cost of energy can be achieved through ensuring the pricing achieved is best value and by reducing energy consumption. Both of these approaches will result in cost savings to Council. Reducing energy usage also has environmental benefits to the broader community. Initiatives implemented in recent years include:

o Upgraded street lighting to LED, saving electricity costs

o Entered into Local Government Procurement state-wide purchasing contract for electricity

Dispose underutilised assets

Disposing underutilised assets results in two key outcomes: proceeds from the sale are achieved, and holding costs of the asset are removed from operating expenditure. Holding costs can includes general rates payable on a property, or more direct operating expenditure such as electricity, water usage and maintenance. Initiatives implemented in recent years include:

o Sales of vacant land in the Corowa Industrial Estate

o Sale of other underutilised property

Protect and increase revenue streams

A number of revenue streams have been introduced or reviewed including:

o Introduced fees for civil works at 1.2% of cost of works

o Introduced fees for reinspection

o Introduced Section 7.12 Development Contributions Plan

o Updated Section 64 Water and Sewer headworks charges

o Secured smart and skilled training funding to support Council’s training and apprentice program

Improve financial management practices

Council has had a focus on improving its financial management practices. This results in a range of improved outcomes such as, decision making being informed by the long term financial impact, increased capability of managers responsible for providing services, reduced expenditure overruns, and reduced expenditure.

Relevant initiatives implemented include:

o Increased financial reporting to Council and to management to drive increased accountability across the organisation

o Increased rigour around expenditure management (e.g., system controls to limit expenditure to budgets)

o Improved management of reserves including creating internal allocations for Financial Assistance Grants (FAGs) advance payment and industrial land proceeds for the Howlong and Mulwala industrial estates that is ahead of planned.

o Improved budgeting by improving. level of detail into budget preparation and level at which Council adopts

Long Term Financial Plan 2023 - 2033 19

o Reviewed fees and charges including adjustment to progress towards full cost recovery of providing relevant services

o Sold properties with rates outstanding more than 5 years

o Reduced employee leave entitlement balance, particularly excess leave

o Introduced monthly meetings to share updates on progress of grant funded projects, particularly the timing, financial and risk elements

o Introduced online procurement requisitions to streamline purchasing process and provide greater financial control

Other initiatives to reduce expenditure

o Evaluated and reviewed all positions when they become vacant before recruiting

o Postponed replacing staff in non-critical functions to save funds

o Reduced printable pages in the Urana Newsletter and printed front back cover to reduce overall print cost

o Upgraded Corowa Aerodrome drainage lines on runway 05/23 and taxiway which will reduce pavement failures

o Purchased a new emulsion tank that is fit for purpose to replace a makeshift old gas tanker to reduce cost of repairing when it breaks down and leaks.

o Purchased a second hand shed for the depot instead of a new shed

o Increased blast and production size run for the quarries to reduce mobilisation costs

o Upgraded the layout of Corowa and Howlong landfills to improve resource recovery and recycling opportunities (e-waste, polystyrene, cardboard, gyprock), this improved layout reduced the staffing level requirements by one operator

o Shredded green waste as opposed to burning it, then using this material to rehab the site which reduces the amount of material which must be imported

o Crushed concrete to use for onsite roads rather than burying it and buying materials in

o Worked together with neighbouring Councils for kerbside collection and Halve Waste initiatives

o Increased promotion of Exempt and Complying Development Codes to the community

Implement initiatives to reduce risk and avoid costs

o Continued to implement Council's ICT Strategy

o Installed new gate at depot with swipe card access to ensure only authorised persons can enter and all visitors must sign in

o Installed security fence at Balldale quarry to reduce unauthorised access

o Expanded annual Cyber Security training to include all staff and Councillors, and focused on “Cyber Hygiene” – the 10 simplest steps to improve your online security habits to prevent incidents for Council and staff personally

o Changed Anti-Virus software provider to a more advanced option with comprehensive protection

o Deployed a fully-integrated SIEM (Security Information and Event Management) for improved visibility of activity logs and cross-correlation of network security events.

o Completed Cyber Security Framework and IT Security Policy to tie in with the Disaster Recovery Plan.

o Completed a live-fire test of Disaster Recovery Plan, the results of which resulted in improved disaster response ability

o Assessed risks and implemented controls and procedures for public swimming pools

o Assessed risks and implemented controls for Corowa Saleyards

Changed service levels

Assessment of services to identify activities that could be reduced with minimal impact on the community has been undertaken and implemented. Changes include:

Long Term Financial Plan 2023 - 2033 20

o Reduced print run and distribution of the community calendar which used to be posted to every household

o Reduced Council-funded Seniors celebration to one location on one day in Seniors Week unless otherwise grant funded

o Reduced number of internal audits to two per annum

o Ceased the quarterly printed Community Conversations Newsletter, saving printing and postage costs

o Introduced electronic newsletters to provide more efficient and timely communication

Improve asset management practices

o Programming of works to be less reactive where possible, particularly with maintaining Council assets.

o Developed Strategic Asset Management Plan to better guide long term decision making with respect to assets

o Implemented cyclic maintenance grading schedules as opposed to reactive adhoc requests, enabling Council to better respond to an escalating number of customer requests for grading works

o Implemented stormwater maintenance program as opposed to reactive adhoc requests to ensure the community is better placed for storm events

o Utilised works staff based on skill sets to better allocate resources towards priority tasks

o Resealed Corowa Aerodrome runways to reduce ongoing pavement defects and minor patching

Productivity improvements and cost containment initiatives that Council intends to implement over future years include:

• Implement strategies to ensure full costing to grant funded projects, water, sewer and domestic waste services and business units (saleyards, caravan parks, other waste, etc).

• Undertake service reviews and implement service level changes where appropriate.

• Continue development of Asset Management Plans by asset category and enable better financial planning of long term asset needs.

• Ensure asset management planning provides for proactive asset management, which reduces reactive responses to emerging issues

• Implement Workforce Management Plan activities to increase productivity

The following estimated productivity improvements and cost containment strategies that were included in the SRV application have now been included in the LTFP.

Long Term Financial Plan 2023 - 2033 21
Long Term Financial Plan 2023 - 2033 22 StrategyInitiativesOutcomes achieved OtcometypeEstimated impact 2024/25 Estimated impact 2025/26 Estimated impact 2026/27 Reducecostofenergyacross Counciloperations Implementbestpracticefleet managementinaccordancewith IPWEAGuidelines Reduce vehiclecost Cost reduction 60,00060,00060,000 Protectandincreaserevenue streams Introducedfeesforcivilworksat 1.2%ofcostofworks Revenue increase Revenue increase 10,00010,00010,000 Securescmartandskilledtraining funding Revenue increase Revenue increase 19,72819,72819,728 IntroducedfeesforreinspectionRevenue increase Revenue increase 3,0003,0003,000 IntroductionofSection7.12 DevelopmentContributionsPlan Revenue increase Revenue increase 10,00010,00010,000 UpdatedSection64Waterand Sewerheadworkscharges Revenue increase Revenue increase 10,00010,00010,000 Analysedatafromwatersystem tobillingsystemtoidentify anomalies Revenue increase Revenue increase 30,00030,00030,000 Developandimplementleassing policy Revenue increase Revenue increase 30,00030,00030,000 Implementfeeforstromwater drainageimprovements Revenue increase Revenue increase 150,000 172,728172,728322,728

8 CAPITAL WORKS PLAN

Capital works are asset acquisitions or building and engineering works that construct an asset. Capital works projects would typically include purchase of plant and fleet, construction of new infrastructure and upgrade of existing infrastructure.

Capital expenditure is undertaken to;

 Renew or replace - existing asset or a component of an asset that has reached the end of its useful life. With the exception of land, assets have limited useful lives and decline in value due to wear and tear –for example, reseal an existing sealed road or replace a roof on a building such as a public hall.

 New - to construct an asset that did not previously exist.

 Upgrade (growth or enhancement) - to increase the capacity of existing assets beyond their original design capacity or service potential – for example, widen a bridge or extend a building.

 Disposal or decommission - to remove an asset from service that is no longer required.

Council’s Capital Works Plan has been extensively reviewed as an outcome of the Service Planning review and development of Asset Management Plans.

In developing the Capital Works Plan for the LTFP, Council has applied a disciplined approach to the selection and prioritisation of projects, as well as application of a project decision making framework. The decisionmaking framework includes the progression of projects through stages from concept through to execution and closure. Generally, only projects that have reached a stage of initiation have been included in the LTFP. Projects that are either at concept or planning phase require further definition before they can be included in the LTFP. This may require further prioritisation to remove or reduce the scope of projects currently included in the LTFP to enable further projects to the included.

Key water and sewer upgrades planned for in the ten year period include:

 Priority Howlong water network upgrade (2022/23-2023/24)

 Corowa sewage treatment plant (2026/27 – 2028/29)

 Mulwala water treatment plant (2030/31 – 2033/34).

This timing is estimated and is subject to grant funding being secured.

Long Term Financial Plan 2023 - 2033 23

The annual Capital Works Plan for 2023/24 included in all three scenarios is outlined below.

Long Term Financial Plan 2023 - 2033 24
LocalServicesProjectName PLANNED SCENARIO-SRV BASELINE& ALTERNATE SCENARIO FleetManagementFleetReplacementProgram1,906,0001,906,000 SubTotal-FleetManagement1,906,0001,906,000 InformationTechnologyInformationTechnologyCapitalProgram229,000229,000 Microwavenetworkupgrade25,00025,000 ElectricalUpgrades-AS3000complianceworks53,00053,000 SubTotal-InformationTechnology307,000307,000 RoadsREPAIRProgram-RegionalRoads330,000330,000 BlockGrant-RegionalRoads1,310,0001,310,000 RoadtoRecoveryGrantProgram2,284,0002,284,000 SubTotal-Roads3,924,0003,924,000 StormwaterDrainageSavageStStormwaterPumpStationMulwalaupgradeworks35,00035,000 MulwalaIndustrialEstateStormwaterPumpStationMulwalaupgradeworks35,00035,000 HammersleyRdStormwaterPumpStationCorowaupgradeworks65,00065,000 Stormwaterpumpstationpumpreplacementprogram32,50032,500 Stormwaterpumpstationelectricalupgrades10,00010,000 Stormwaterpumpstationswitchboardreplacementprogram45,50045,500 SubTotal-StormwaterDrainage223,000223,000 AdditionalCapitalWorksduetoSRV-SealedLocalRoadsResealofDrainLane(1.43km)59,000 ResealofBackBerriganRoad(1.75km)80,000 ResealofGreenvaleRoad(5km)169,000 ResealofEmuParkRoad(500m)42,000 ResealofEmuParkRoad(760m)77,000 ResealofGoombarganaRoad(4.57km)164,000 ResealofRiverRoad(550m)27,000 SubTotal-AdditionalCapitalWorksduetoSRV-SealedLocalRoads618,000AdditionalCapitalWorksduetoSRV-UnsealedLocalRoadsResheetingofWoodhouseRoad(1.24km)43,000 ResheetingofSwanLagoonRoad(1km)35,000 ResheetingofSandyRidgesRoad(2.3km)64,000 ResheetingofNarrowPlainsRoad(1.35km)49,000 SubTotal-AdditionalCapitalWorksduetoSRV-UnsealedLocalRoads191,000AdditionalCapitalWorksduetoSRV-UrbanStormwaterDrainageCorowaStormwaterDrainageImprovementsStage1161,000 SubTotal-AdditionalCapitalWorksduetoSRV-UrbanStormwaterDrainage161,000SubTotalGeneralFund7,330,0006,360,000

LocalServicesProjectName

PLANNED SCENARIO-SRV

BASELINE& ALTERNATE SCENARIO

SewerageCCTVInspections102,000102,000 SewerRelining122,500122,500 Infiltrationtesting35,00035,000

Locate,Inspect,CleanandMaintainhydrantsandmanholesthroughoutfivetowns137,500137,500 Pumpreplacementsasrequired,Alltowns210,000210,000 ReplaceSPSLids70,00070,000

MajorMicrowaveNetworkUpgrade-CorowaCivicCentretoUranaCouncilBuilding-Supply,InstallCommission17,50017,500

TreatmentPlants&PumpingStations-BackupGeneratorConnections-Treatmentworks11,00011,000

TreatmentPlants&PumpingStations-BackupGeneratorConnections-W&SPumpingStations16,00016,000

AnnualSwitchboardReplacement,Upgrade&MaintenanceProgram-SeweragePumpingStations77,00077,000 SewerVentStackInspection,removalandreplacementprogramme100,000100,000

PlantandEquipment66,50066,500

ImprovementWorksCorowaSTP127,000127,000

ImprovementWorksMulwalaSTP215,000215,000 ImprovementWorksUranaSTP45,00045,000

ImprovementWorksOaklandsSTP15,00015,000 SPSValvePitreplacementandwellupgrades100,000100,000 SCADA,TelemetryandCommunicationsnetworkupgrade11,00011,000 MotorDrive,energyefficiencyandcoolingupgrades83,00083,000

LocalServicesProjectName

WaterLocate,Inspect,CleanandMaintainhydrantsandmanholesthroughoutfourtowns140,000140,000 AnnualSwitchboardReplacement,Upgrade&MaintenanceProgram-WaterPumpingStations77,00077,000 IWCMPlan-NEW-S&SFunding60/40150,000150,000 Constructbulktankerchemicaldeliverybundedpadsandaccessmodifications-CorowaWFP,MulwalaWFPandHowlongWFP35,00035,000 WaterMainReplacement350,000350,000 HowlongWaterMainsAugmentation600,000600,000 VariableSpeedDriveInstallationwithRemoteMonitoring&Controlsystem11,00011,000 TreatmentPlants&PumpingStations-BackupGeneratorConnections-Treatmentworks55,00055,000 TreatmentPlants&PumpingStations-BackupGeneratorConnections-W&SPumpingStations11,00011,000 SCADA,TelemetryandCommunicationsnetworkupgrade11,00011,000 UPSReplacementProgram55,00055,000

Long Term Financial Plan 2023 - 2033 25 e
SubTotal-Sewerage1,561,0001,561,000
PLANNED SCENARIO-SRV BASELINE SCENARIORATEPEGONLY
SubTotal-Water1,495,0001,495,000 TOTAL-AllServices10,386,0009,416,000

9 MONITORING KEY PERFORMANCE INDICATORS

An important component of the LTFP is the ability to monitor the financial performance of Federation Council within the parameters of the plan. To achieve this, Council will closely monitor the financial performance of outcomes of the plan in accordance with the requirements of Fit for the Future performance measures.

Key Performance Indicators which will be reported on include:

A) Operating Performance Ratio

B) Own Source Revenue

C) Building and Infrastructure Asset Renewal

D) Infrastructure Backlog

E) Asset Maintenance Result

F) Debt Service

G) Real Operating Expenditure per Capita

H) Building and Infrastructure Renewal Ratio

I) Infrastructure Backlog Ratio

J) Asset Maintenance Ratio

Council will review the LTFP each year as part of the development of Council’s annual Operational Plan. The reviewwillinclude anassessmentofthepreviousyear’s performanceintermsofthe accuracyofthe projections made inthe LTFP compared to the actual results. Evaluation willinclude reviewing and amending estimatesand scenarios where long-term goals are not being achieved or where changes have affected set goals and strategies. Assumptions will also be revisited to improve the accuracy of the plan over time.

The following analysis of the performance ratios is based upon the Consolidated Fund Planned Scenario for the 2023/24 Budget and future years. Financial sustainability ratios by fund type are included at Appendix A.

9.1 Operating Performance Ratio

Operating Revenue (excl Capital Grants & Contributions) minus Operating Expenses over Operating Revenue (excl Capital Grants & Contributions)

Figure 3 indicates that Council is producing a negative operating performance ratio. This is due to the heavy reliance upon grant fundingfor regional roads andothergrant funded asset renewals– the formulafor the ratio removes capital grants and contributions – while the depreciation expense is included in the operating expenditure.

The key for sustainability is whether Council can produce sufficient cash over the long term to replace assets when required. This is more accurately reflected in the Statement of Cashflows, where the cash required for asset renewals is based upon the asset management planning and the Capital Works Plan.

This ratio improves over time due to the proposed Special Rate Variation and the implementation of productivity improvements and cost containment strategies.

Long Term Financial Plan 2023 - 2033 26
Figure 3 – Operating Performance Ratio

9.2 Own Source Revenue

Total Continuing operating revenue minus all grants & contributions over Total Continuing operating revenue inclusive of Capital Grant

Figure 4 indicates that Council’s own source revenue as a percentage of the total revenue improves over the 10-year period of the LTFP. This reflects a decreasing reliance upon grants as the proposed Special Rate Variation is implemented.

9.3 Building and Infrastructure Asset Renewal Ratio

Asset renewals (building & infrastructure) over Depreciation, amortisation & impairment (building & infrastructure).

Figure 5 indicates that Council has invested heavily in the years 2020, 2021 and 2023 on renewal of assets and continues to plan to invest in renewals in the future years. Following this period, Council plans to invest and move towards surpassing the benchmark in the later years of the LTFP. This is only possible through the funds received under the proposed Special Rate Variation.

Long Term Financial Plan 2023 - 2033 27
Figure 4 – Own Source Revenue Ratio Figure 5 – Building and Infrastructure Asset Renewal Ratio

9.4 Infrastructure Backlog Ratio

Estimated cost to bring assets to a satisfactory condition over Total Written Down Value of infrastructure, building, other structures & land improvements

Figure 6 indicates that Council plans to expend sufficient funding in the renewal of existing assets to reduce the backlog by each year across the 10 years of the LTFP. This is possible only if additional funds obtained through the SpecialRateVariation are invested in renewingexisting assets.This ratiohas deteriorated in2022 as further asset management has been undertaken and a better understanding of the condition of assets is obtained. The impact of the 2022 flood event has not yet been included as it is still being assessed and quantified.

9.5 Asset Maintenance Result Ratio

Actual Asset Maintenance over Required Asset Maintenance

Figure 7 indicates that Council wasbelow in theinvestment onmaintenance in 2020 to2021 but have exceeded the benchmark in 2022 and plans to maintain the investment on maintenance in the future years. This is a key outcome expected from the focus upon enhanced asset management capability.

Long Term Financial Plan 2023 - 2033 28
Figure 6 – Infrastructure Backlog Ratio Figure 7 – Asset Maintenance Ratio

9.6 Debt Service Ratio

Cost of debt service (interest expenses & principal repayments) over Total continuing operating revenue (excluding capital grants & contrib.).

Figure 8 indicates that Council maintains affordable borrowings over the 10 yearLTFP. This is reliant upon a low interest rate and 20 year term for the new and proposed loans throughout the LTFP.

9.7 Real Operating Expenditure per Capita ratio Real Operating Expenditure over Population

Long Term Financial Plan 2023 - 2033 29
Figure 8 – Debt Service Ratio Figure 9 – Real Operating Expenditure per Capita

10 FINANCIAL STATEMENTS

The pages following contain the 10 year financial statements for the following:

Planned (Recommended) Scenario Statements

 2023/24 to 2032/33 – Consolidated & Individual Funds Income Statements

 2023/24 to 2032/33 – Consolidated & Individual Funds Balance Sheets

 2023/24 to 2032/33 – Consolidated & Individual Funds Cash Flow Statements

 2023/24 to 2032/33 – Capital Works Statement

Baseline (Rate peg only) Scenario Statements

 2023/24 to 2032/33 – Consolidated & Individual Funds Income Statements

 2023/24 to 2032/33 – Consolidated & Individual Funds Balance Sheets

 2023/24 to 2032/33 – Consolidated & Individual Funds Cash Flow Statements

 2023/24 to 2032/33 – Capital Works Statement

Alternate (Delayed SRV) Scenario Statements

 2023/24 to 2032/33 – Consolidated & Individual Funds Income Statements

 2023/24 to 2032/33 – Consolidated & Individual Funds Balance Sheets

 2023/24 to 2032/33 – Consolidated & Individual Funds Cash Flow Statements

 2023/24 to 2032/33 – Capital Works Statement

Long Term Financial Plan 2023 - 2033 30

PLANNED SCENARIO FINANCIAL STATEMENTS - CONSOLIDATED INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 31
FederationCouncilLongTermFinancialPlan2021/22-2031/32 IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges17,14017,50219,80622,20824,68126,65827,57528,53529,52730,56431,64332,769 UserChargesandFees9,4219,4669,62610,18810,60811,19611,37111,82812,30412,80113,32113,865 Interest&InvestmentRevenue318228236236236236236236236236236236 OtherRevenues457446407415423432443454465477489501 Grants&ContributionsforOperatingPurposes15,04312,00314,11412,89613,04313,19013,34213,49513,65113,81013,97114,134 Grants&ContributionsforCapitalPurposes-Cash11,7945,6118529292,3553,1115,6114,0352,4215,3206,3155,617 NetGainsfromtheDisposalofAssets1,5027921,040500500500500500500500500500 TotalIncomefromContinuingOperations 55,67546,04846,08147,37351,84655,32359,07859,08359,10563,70766,47467,622 ExpensesfromContinuingOperations EmployeeCosts13,97816,44017,43517,86218,11318,56618,94019,32319,71720,12020,53120,954 BorrowingCosts3953835205164804646868768167557271,058 MaterialsandServices14,45916,09017,75318,99519,44020,15620,46920,98221,13621,48621,87822,432 Depreciation13,09515,13314,49114,49114,49114,49114,49114,49114,49114,49114,49114,491 NetLossesfromtheDisposalofAssets-----------OtherExpenses465663678697716735754773792812832853 TotalExpensesfromContinuingOperations 42,39248,70950,87752,56153,24054,41255,34056,44556,95257,66458,45959,788 OperatingResultfromContinuingOperations Surplus/(Deficit) 13,283(2,661)(4,796)(5,188)(1,393)9113,7382,6392,1536,0438,0157,834 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) 1,489(8,272)(5,648)(6,117)(3,749)(2,200)(1,873)(1,396)(269)7231,7002,217

PLANNED SCENARIO FINANCIAL STATEMENTS - GENERAL FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 32
FederationCouncilLongTermFinancialPlan2021/22-2031/32 GeneralFund-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges9,4049,51811,18813,03914,95016,41516,81817,23217,65518,08918,53418,991 UserChargesandFees4,4674,0544,0114,2864,4114,6904,5484,6624,7794,8985,0205,146 Interest&InvestmentRevenue1588080808080808080808080 OtherRevenues203345295301307313321329337346354363 Grants&ContributionsforOperatingPurposes13,73211,78913,90112,67912,82112,96413,11013,25813,40813,56013,71513,872 Grants&ContributionsforCapitalPurposes-Cash9,9815,578330330330330330330330330330330 NetGainsfromtheDisposalofAssets1,2187921,040500500500500500500500500500 TotalIncomefromContinuingOperations 39,16332,15630,84531,21533,39935,29235,70736,39137,08937,80338,53339,282 ExpensesfromContinuingOperations EmployeeCosts9,16210,98711,60511,88912,09212,39212,64012,89513,15613,42313,69613,977 BorrowingCosts2222101991871741611471331191069584 MaterialsandServices10,2749,26310,11310,84010,89511,28411,43511,78411,76911,94612,16012,532 Depreciation10,76411,72011,08811,08811,08811,08811,08811,08811,08811,08811,08811,088 NetLossesfromtheDisposalofAssets-----------OtherExpenses216584678697716735754773792812832853 TotalExpensesfromContinuingOperations 30,63832,76433,68334,70034,96535,66036,06436,67336,92437,37537,87138,534 OperatingResultfromContinuingOperations Surplus/(Deficit) 8,525(608)(2,838)(3,486)(1,566)(368)(357)(282)165428662748 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) (1,456)(6,186)(3,168)(3,816)(1,896)(698)(687)(612)(165)98332418

PLANNED SCENARIO FINANCIAL STATEMENTS - WATER FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 33
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Water-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges1,2091,3961,4571,5371,6201,7081,8001,8971,9982,1052,2172,335 UserChargesandFees4,3534,6354,8205,0585,3025,5585,8236,1066,4026,7147,0427,385 Interest&InvestmentRevenue878085858585858585858585 OtherRevenues625369707273757779818385 Grants&ContributionsforOperatingPurposes7896866676970727475777981 Grants&ContributionsforCapitalPurposes-Cash974334973434356957147873,6123,7124,104 TotalIncomefromContinuingOperations 7,6586,2656,9946,8517,1827,5298,5508,9529,42612,67413,21814,075 ExpensesfromContinuingOperations EmployeeCosts2,3732,7002,9453,0152,9883,0643,1263,1893,2553,3223,3903,460 BorrowingCosts-7161176159142124105846373445 MaterialsandServices1,1462,3572,6142,7822,8933,0103,0563,1023,1503,1993,2493,301 Depreciation1,1401,7121,7071,7071,7071,7071,7071,7071,7071,7071,7071,707 NetLossesfromtheDisposalofAssets-----------OtherExpenses249----------TotalExpensesfromContinuingOperations 4,9086,7767,4277,6807,7477,9238,0138,1038,1968,2918,4198,913 OperatingResultfromContinuingOperations Surplus/(Deficit) 2,750(511)(433)(828)(565)(394)5378501,2304,3844,7985,161 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) 1,776(544)(930)(862)(600)(429)(158)1364437721,0871,058

PLANNED SCENARIO FINANCIAL STATEMENTS - SEWERAGE FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 34
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Sewerage-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges4,4784,5754,8005,0975,4105,7436,0966,4706,8667,2867,7318,203 UserChargesandFees6017777958448959481,0001,0601,1231,1891,2591,334 Interest&InvestmentRevenue655560606060606060606060 OtherRevenues1924843444546474849505253 Grants&ContributionsforOperatingPurposes4456667687071737577788082 Grants&ContributionsforCapitalPurposes-Cash839-255661,9912,7464,5872,9911,3051,3772,2731,183 NetGainsfromtheDisposalofAssets100----------TotalIncomefromContinuingOperations 6,7205,5215,7906,6798,4709,61411,86210,7049,47910,04111,45510,916 ExpensesfromContinuingOperations EmployeeCosts2,2112,5882,6922,7592,8282,8992,9583,0183,0793,1423,2063,272 BorrowingCosts173166160154146161414638613587559529 MaterialsandServices1,1202,6232,7672,9453,0633,1863,2353,2843,3353,3873,4413,495 Depreciation1,1911,7011,6961,6961,6961,6961,6961,6961,6961,6961,6961,696 NetLossesfromtheDisposalofAssets-----------OtherExpenses-----------TotalExpensesfromContinuingOperations 4,6957,0787,3157,5547,7337,9428,3038,6368,7238,8128,9028,992 OperatingResultfromContinuingOperations Surplus/(Deficit) 2,025(1,557)(1,525)(875)7371,6723,5592,0687561,2292,5541,924 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) 1,186(1,557)(1,550)(1,440)(1,254)(1,074)(1,028)(923)(549)(148)280741

PLANNED SCENARIO FINANCIAL STATEMENTS - WASTE FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 35
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Waste-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges2,0492,0132,3612,5352,7012,7922,8612,9363,0083,0843,1613,240 UserChargesandFees-----------Interest&InvestmentRevenue81311111111111111111111 OtherRevenues-----------Grants&ContributionsforOperatingPurposes778080828385878991949698 Grants&ContributionsforCapitalPurposes-Cash-----------TotalIncomefromContinuingOperations 2,1342,1062,4522,6282,7952,8882,9593,0363,1103,1893,2683,349 ExpensesfromContinuingOperations EmployeeCosts232165193199205211216221227233239245 BorrowingCosts-----------MaterialsandServices1,9191,8472,2592,4282,5892,6762,7432,8122,8822,9543,0283,104 Depreciation-----------NetLossesfromtheDisposalofAssets-----------OtherExpenses-79---------TotalExpensesfromContinuingOperations 2,1512,0912,4522,6272,7942,8872,9593,0333,1093,1873,2673,349 OperatingResultfromContinuingOperations Surplus/(Deficit) (17)15-111031210 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) (17)15-111031210

PLANNED SCENARIO FINANCIAL STATEMENTS - CONSOLIDATED BALANCE SHEET

Long Term Financial Plan 2023 - 2033 36
FederationCouncilLongTermFinancialPlan2021/22-2031/32 BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents16,71928,19828,03625,22723,90827,13128,35926,88326,94124,16728,43833,961 Investments26,111----------Receivables9,1443,9873,9104,0924,4884,8015,1265,1235,1135,5385,7685,870 Inventories2,9731,8351,8351,8351,8351,8351,8351,8351,8351,8351,8351,835 Other(IncludesAssetsHeldforSale)183190190190190190190190190190190190 TotalCurrentAssets 55,13034,21033,97131,34430,42133,95735,51034,03134,07831,73036,23141,855 Non-CurrentAssets Investments4,529----------Receivables606060606060606060606060 Infrastructure,Property,Plant&Equipment670,200573,433580,797577,448587,185588,064604,289607,150618,298625,544644,586652,091 Other307585585585585585585585585585585585 TotalNon-CurrentAssets 675,096574,078581,442578,093587,830588,709604,934607,795618,943626,189645,231652,736 TotalAssets730,226608,288615,412609,437618,251622,666640,444641,826653,021657,918681,462694,591 CurrentLiabilities Payables15,1792,8663,0973,2553,3263,4323,4713,5623,6133,6703,7313,827 Borrowings5348679459811,0191,1781,3471,4061,2021,2401,4851,358 Provisions432----------Other2,8203,4463,4463,4463,4463,4463,4463,4463,4463,4463,4463,446 TotalCurrentLiabilities 18,9657,1797,4887,6827,7918,0568,2648,4148,2618,3568,6628,631 NonCurrentLiabilities Borrowings9,98812,01812,16011,17910,15913,39816,46915,06313,86112,62217,82023,144 Provisions 7091,1411,1411,1411,1411,1411,1411,1411,1411,1411,1411,141 Other276377377377377377377377377377377377 TotalNonCurrentLiabilities 10,97313,53613,67812,69711,67714,91617,98716,58115,37914,14019,33824,662 TotalLiabilities29,93820,71521,16720,37919,46822,97226,25224,99523,64122,49527,99933,294 NetAssets700,288587,573594,246589,058598,783599,694614,192616,832629,381635,423653,463661,298 Equity RetainedEarnings516,196523,986519,190514,002512,608513,519517,258519,896522,049528,092536,107543,941 RevaluationReserves184,09263,58775,05675,05686,17486,17496,93596,935107,332107,332117,357117,357 TotalEquity700,288587,573594,245589,057598,782599,693614,193616,831629,381635,423653,464661,298

PLANNED SCENARIO FINANCIAL STATEMENTS - GENERAL FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 37
FederationCouncil
TermFinancialPlan
SheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents10,26110,83111,50010,94211,16411,46711,85112,21212,61712,93913,30113,795 Investments15,406----------Receivables4,4482,7252,5792,6732,8623,0303,0583,1263,1863,2523,3073,380 Inventories2,9731,8351,8351,8351,8351,8351,8351,8351,8351,8351,8351,835 Other(IncludesAssetsHeldforSale)183190190190190190190190190190190190 TotalCurrentAssets 33,27115,58116,10415,64016,05016,52216,93417,36317,82818,21618,63319,200 Non-CurrentAssets Investments2,626----------Receivables606060606060606060606060 Infrastructure,Property,Plant&Equipment565,484470,905476,565473,098479,755478,410485,993484,748492,498492,221500,526500,418 Other307585585585585585585585585585585585 TotalNon-CurrentAssets 568,477471,550477,210473,743480,400479,055486,638485,393493,143492,866501,171501,063 TotalAssets601,748487,131493,314489,383496,450495,577503,572502,755510,971511,082519,804520,263 CurrentLiabilities Payables14,8861,7931,9242,0202,0442,1052,1352,1952,2172,2572,2942,359 Borrowings451539541553567580594609357343355366 Provisions432----------Other2,8202,8422,8422,8422,8422,8422,8422,8422,8422,8422,8422,842 TotalCurrentLiabilities 18,5895,1745,3075,4155,4535,5275,5715,6465,4165,4425,4915,567 NonCurrentLiabilities Borrowings7,7857,4126,8826,3285,7625,1824,5873,9793,6223,2792,9242,558 Provisions 7091,1411,1411,1411,1411,1411,1411,1411,1411,1411,1411,141 Other276377377377377377377377377377377377 TotalNonCurrentLiabilities 8,7708,9308,4007,8467,2806,7006,1055,4975,1404,7974,4424,076 TotalLiabilities27,35914,10413,70713,26212,73212,22711,67711,14310,55610,2399,9339,643 NetAssets574,389473,027479,607476,122483,718483,350491,895491,612500,415500,843509,871510,620 Equity RetainedEarnings412,688424,968422,130418,644417,078416,710416,352416,070416,235416,663417,325418,073 RevaluationReserves161,70148,05957,47757,47766,64066,64075,54375,54384,18084,18092,54692,546 TotalEquity574,389473,027479,607476,121483,718483,350491,895491,613500,415500,843509,871510,620
Long
2021/22-2031/32 GeneralFund-Balance

PLANNED SCENARIO FINANCIAL STATEMENTS - WATER FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 38
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Water-BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents4,19610,50011,13110,21710,34110,74010,34610,20810,6148,21312,85616,933 Investments5,744----------Receivables2,1735746065986276587427808211,1251,1701,249 TotalCurrentAssets 12,11311,07411,73710,81510,96911,39811,08810,98811,4359,33814,02618,183 Non-CurrentAssets Investments1,042----------Infrastructure,Property,Plant&Equipment46,15947,59348,33348,13848,00946,86048,19348,77249,96656,02263,12670,174 TotalNon-CurrentAssets 47,20147,59348,33348,13848,00946,86048,19348,77249,96656,02263,12670,174 TotalAssets59,31458,66760,07058,95358,97858,25859,28159,76061,40165,36077,15188,356 CurrentLiabilities Payables288435484506522541537549563562571583 Borrowings-240311328345363383403424447651480 Other-264264264264264264264264264264264 TotalCurrentLiabilities 2889391,0591,0981,1311,1681,1841,2161,2511,2731,4861,327 NonCurrentLiabilities Borrowings-2,4903,2542,9262,5812,2181,8361,4331,0085616,59312,795 TotalNonCurrentLiabilities -2,4903,2542,9262,5812,2181,8361,4331,0085616,59312,795 TotalLiabilities2883,4294,3134,0253,7123,3863,0202,6492,2591,8348,07814,122 NetAssets59,02655,23855,75754,92855,26654,87256,26157,11159,14363,52669,07374,235 Equity RetainedEarnings53,81853,15052,71751,88951,32350,93051,46652,31653,54657,93062,72867,890 RevaluationReserves5,2082,0883,0403,0403,9423,9424,7954,7955,5965,5966,3456,345 TotalEquity59,02655,23855,75754,92955,26654,87256,26157,11159,14263,52669,07374,234

PLANNED SCENARIO FINANCIAL STATEMENTS - SEWERAGE FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 39
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Sewerage-BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents2,2606,8005,3373,9992,3334,8536,0914,3893,6342,9372,2033,154 Investments4,961----------Receivables2,3594995065857498541,0619468268751,000940 TotalCurrentAssets 9,5807,2995,8424,5843,0825,7077,1525,3344,4603,8123,2024,094 Non-CurrentAssets Investments861----------Infrastructure,Property,Plant&Equipment58,55754,93555,89956,21259,42162,79470,10473,63175,83477,30180,93481,499 TotalNon-CurrentAssets 59,41854,93555,89956,21259,42162,79470,10473,63175,83477,30180,93481,499 TotalAssets68,99862,23461,74160,79662,50268,50177,25678,96580,29481,11384,13685,592 CurrentLiabilities Payables5450470493509526534545555564573585 Borrowings838893100108235370395421449479511 Other-340340340340340340340340340340340 TotalCurrentLiabilities 888789039339571,1011,2441,2801,3161,3531,3921,436 NonCurrentLiabilities Borrowings2,2032,1162,0241,9241,8165,99910,0469,6529,2318,7828,3037,791 TotalNonCurrentLiabilities 2,2032,1162,0241,9241,8165,99910,0469,6529,2318,7828,3037,791 TotalLiabilities2,2912,9942,9282,8572,7747,10011,29010,93210,54610,1359,6959,227 NetAssets66,70759,24058,81457,93959,72861,40165,96568,03369,74870,97874,44176,365 Equity RetainedEarnings49,52445,80044,27543,40044,13745,80949,36851,43652,19253,42255,97557,899 RevaluationReserves17,18313,44014,53914,53915,59215,59216,59816,59817,55617,55618,46618,466 TotalEquity66,70759,24058,81457,93959,72961,40165,96668,03469,74870,97874,44176,365

PLANNED SCENARIO FINANCIAL STATEMENTS - WASTE FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 40
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Waste-BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents26769697071717476787979 Receivables164189219235250259264272279286292300 TotalCurrentAssets 166256288304321330336346355363371379 Non-CurrentAssets Cash&CashEquivalents-----------TotalNon-CurrentAssets TotalAssets166256288304321330336346355363371379 CurrentLiabilities Payables-188220236251259265272279286293301 TotalCurrentLiabilities -188220236251259265272279286293301 NonCurrentLiabilities Payables-----------TotalNonCurrentLiabilities TotalLiabilities-188220236251259265272279286293301 NetAssets1666868697071717475777879 Equity RetainedEarnings1666868697071717475777879 TotalEquity1666868697071717475777879

PLANNED SCENARIO FINANCIAL STATEMENTS - CONSOLIDATED CASH FLOW STATEMENT

FederationCouncilLongTermFinancialPlan2021/22-2031/32

CashFlowStatementProjections

Long Term Financial Plan 2023 - 2033 41
ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities51,66045,09245,83547,25751,54955,13458,90759,22359,28763,54566,51267,798 Payments-OperatingActivities(27,870)(31,506)(35,417)(36,898)(37,536)(38,488)(38,831)(39,940)(40,791)(41,001)(41,648)(42,770) NetCashProvidedby(orusedin)OperatingActivities23,79013,58610,41810,35914,01316,64620,07519,28318,49722,54424,86425,028 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment1821,2011,144550550550550550550550550550 Purchases-Infrastructure,Property,Plant&Equipment(17,576)(20,501)(11,425)(12,256)(14,421)(16,907)(21,951)(19,087)(16,766)(23,911)(25,859)(24,196) Receipts/Purchases-OtherAssets2,91315,454 NetCashProvidedby(orusedin)InvestingActivities(14,481)(3,846)(10,281)(11,706)(13,871)(16,357)(21,401)(18,537)(16,216)(23,361)(25,309)(23,646) CashFlowfromFinancingActivities Receipts-LoanBorrowings -2,7501,050--4,4274,427---6,6976,697 Payments-PrincipalRepayments (588)(629)(829)(945)(981)(1,029)(1,188)(1,347)(1,406)(1,202)(1,254)(1,499) Payments-FinanceCosts(395)(382)(520)(516)(480)(464)(686)(876)(816)(755)(727)(1,058) NetCashProvidedby(orusedin)FinancingActivities(983)1,739(300)(1,461)(1,461)2,9342,553(2,222)(2,222)(1,957)4,7164,140 NetIncrease/(Decrease)inCashAssetsHeld 8,32611,479(162)(2,809)(1,319)3,2231,228(1,476)58(2,774)4,2715,523 CashandCashEquivalentsatBeginningofReporting Period 8,39316,71928,19828,03625,22723,90827,13128,35926,88326,94124,16728,438 CashandCashEquivalentsatEndofReportingPeriod16,71928,19828,03625,22723,90827,13128,35926,88326,94124,16728,43833,961 plusInvestmentsonHand-EndofReportingPeriod 30,640----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod47,35928,19828,03625,22723,90827,13128,35926,88326,94124,16728,43833,961

PLANNED SCENARIO FINANCIAL STATEMENTS – GENERAL FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 42
FederationCouncilLongTermFinancialPlan2021/22-2031/32
ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities35,45831,26130,12130,66332,75034,66835,21335,86036,56537,27838,01738,748 Payments-OperatingActivities(18,620)(19,983)(21,805)(22,661)(22,910)(23,470)(23,906)(24,494)(24,762)(25,151)(25,637)(26,288) NetCashProvidedby(orusedin)OperatingActivities16,83811,2788,3158,0039,84011,19811,30711,36611,80412,12712,38012,460 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment1821,2011,144550550550550550550550550550 Purchases-Infrastructure,Property,Plant&Equipment(9,854)(10,714)(8,063)(8,383)(9,440)(10,717)(10,745)(10,827)(11,221)(11,892)(12,130)(12,078) Receipts/Purchases-OtherAssets1,243(458) NetCashProvidedby(orusedin)InvestingActivities(8,429)(9,971)(6,919)(7,833)(8,890)(10,167)(10,195)(10,277)(10,671)(11,342)(11,580)(11,528) CashFlowfromFinancingActivities Receipts-LoanBorrowingsPayments-PrincipalRepayments (511)(527)(528)(541)(553)(567)(580)(594)(609)(357)(343)(355) Payments-FinanceCosts (222)(210)(199)(187)(174)(161)(147)(133)(119)(106)(95)(84) NetCashProvidedby(orusedin)FinancingActivities(733)(737)(728)(728)(728)(728)(728)(728)(728)(462)(438)(438) NetIncrease/(Decrease)inCashAssetsHeld 7,676570669(558)222303384361405323362494 CashandCashEquivalentsatBeginningofReporting Period 2,58510,26110,83111,50010,94211,16411,46711,85112,21212,61712,93913,301 CashandCashEquivalentsatEndofReportingPeriod10,26110,83111,50010,94211,16411,46711,85112,21212,61712,93913,30113,795 plusInvestmentsonHand-EndofReportingPeriod 18,032----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod28,29310,83111,50010,94211,16411,46711,85112,21212,61712,93913,30113,795
GeneralFund-CashFlowStatementProjections

PLANNED SCENARIO FINANCIAL STATEMENTS – WATER FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 43
CouncilLongTermFinancialPlan2021/22-2031/32
-CashFlowStatementProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities7,4746,2507,4517,3727,6908,0629,0569,53310,03313,08413,88614,745 Payments-OperatingActivities(3,768)(4,548)(5,850)(6,136)(6,335)(6,562)(6,557)(6,669)(6,830)(6,459)(6,537)(6,624) NetCashProvidedby(orusedin)OperatingActivities3,7061,7021,6011,2361,3551,4992,4982,8643,2036,6257,3498,122 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment-Purchases-Infrastructure,Property,Plant&Equipment(3,750)(6,054)(1,645)(1,663)(744)(614)(2,406)(2,515)(2,310)(8,539)(8,868)(9,631) Receipts/Purchases-OtherAssets1,0617,933 NetCashProvidedby(orusedin)InvestingActivities(2,689)1,879(1,645)(1,663)(744)(614)(2,406)(2,515)(2,310)(8,539)(8,868)(9,631) CashFlowfromFinancingActivities Receipts-LoanBorrowings -2,7501,050-------6,6976,697 Payments-PrincipalRepayments -(20)(215)(311)(328)(345)(363)(383)(403)(424)(462)(665) Payments-FinanceCosts -(7)(161)(176)(159)(142)(124)(105)(84)(63)(73)(445) NetCashProvidedby(orusedin)FinancingActivities -2,723674(487)(487)(487)(487)(487)(487)(487)6,1625,586 NetIncrease/(Decrease)inCashAssetsHeld 1,0176,304631(914)124399(394)(137)406(2,401)4,6434,077 CashandCashEquivalentsatBeginningofReporting Period 3,1794,19610,50011,13110,21710,34110,74010,34610,20810,6148,21312,856 CashandCashEquivalentsatEndofReportingPeriod4,19610,50011,13110,21710,34110,74010,34610,20810,6148,21312,85616,933 plusInvestmentsonHand-EndofReportingPeriod 6,786----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod10,98210,50011,13110,21710,34110,74010,34610,20810,6148,21312,85616,933
Federation
Water

PLANNED SCENARIO FINANCIAL STATEMENTS – SEWERAGE FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 44
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Sewerage-CashFlowStatementProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities6,6205,4725,8236,6098,3289,52511,68510,8019,58510,00011,34710,963 Payments-OperatingActivities(3,331)(4,881)(5,323)(5,490)(5,510)(5,577)(5,415)(5,751)(6,097)(6,210)(6,213)(6,517) NetCashProvidedby(orusedin)OperatingActivities3,2895915011,1192,8173,9486,2705,0503,4883,7905,1344,446 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment-Purchases-Infrastructure,Property,Plant&Equipment(3,972)(3,733)(1,717)(2,210)(4,237)(5,576)(8,800)(5,745)(3,235)(3,479)(4,861)(2,487) Receipts/Purchases-OtherAssets6097,929 NetCashProvidedby(orusedin)InvestingActivities(3,363)4,196(1,717)(2,210)(4,237)(5,576)(8,800)(5,745)(3,235)(3,479)(4,861)(2,487) CashFlowfromFinancingActivities Receipts-LoanBorrowings ---4,4274,427----Payments-PrincipalRepayments (77)(82)(86)(93)(100)(117)(245)(370)(395)(421)(449)(479) Payments-FinanceCosts (173)(165)(160)(154)(146)(161)(414)(638)(613)(587)(559)(529) NetCashProvidedby(orusedin)FinancingActivities(250)(247)(247)(247)(247)4,1493,768(1,008)(1,008)(1,008)(1,008)(1,008) NetIncrease/(Decrease)inCashAssetsHeld (324)4,540(1,463)(1,338)(1,666)2,5201,238(1,703)(755)(697)(734)951 CashandCashEquivalentsatBeginningofReporting Period 2,5842,2606,8005,3373,9992,3334,8536,0914,3893,6342,9372,203 CashandCashEquivalentsatEndofReportingPeriod2,2606,8005,3373,9992,3334,8536,0914,3893,6342,9372,2033,154 plusInvestmentsonHand-EndofReportingPeriod 5,822----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod8,0826,8005,3373,9992,3334,8536,0914,3893,6342,9372,2033,154

PLANNED SCENARIO FINANCIAL STATEMENTS – WASTE FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 45
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Waste-CashFlowStatementProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities2,1082,1092,4412,6132,7812,8802,9543,0293,1043,1823,2623,342 Payments-OperatingActivities(2,151)(2,094)(2,439)(2,612)(2,780)(2,879)(2,954)(3,026)(3,103)(3,181)(3,261)(3,341) NetCashProvidedby(orusedin)OperatingActivities(43)152111032211 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment-Purchases-Infrastructure,Property,Plant&Equipment-Receipts/Purchases-OtherAssets-50 NetCashProvidedby(orusedin)InvestingActivities -50---------CashFlowfromFinancingActivities Receipts-LoanBorrowingsPayments-PrincipalRepayments Payments-FinanceCosts NetCashProvidedby(orusedin)FinancingActivities NetIncrease/(Decrease)inCashAssetsHeld (43)652111032211 CashandCashEquivalentsatBeginningofReporting Period 45267686970717174757778 CashandCashEquivalentsatEndofReportingPeriod26768697071717475777879 plusInvestmentsonHand-EndofReportingPeriod TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod26768697071717475777879

PLANNED SCENARIO FINANCIAL STATEMENTS – CAPITAL WORKS STATEMENT PROJECTION

Long Term Financial Plan 2023 - 2033 46
FederationCouncilLongTermFinancialPlan2021/22-2031/32 CapitalWorksStatementProjections Proposed Budget YearEnding2024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s SealedRoads3,9243,1403,1403,1403,1403,1403,1403,1403,1403,140 StormwaterDrainage223919451----47Sewerage1,5612,0093,8525,0698,0005,2232,9413,1634,4192,261 Water1,4951,5126765582,1872,2862,1007,7638,0628,755 Plant,machineryandequipment1,9062,0002,0002,0002,0002,0002,0002,0002,0002,000 Computersandtelecommunications307380259162368203101250250250 AdditionalCapitalWorksduetoSRV-SealedLocalRoads6181,1971,8922,4722,5492,5102,5492,7812,7612,761 AdditionalCapitalWorksduetoSRV-UnsealedLocalRoads191371586766790778790862856856 AdditionalCapitalWorksduetoSRV-UrbanStormwaterDrainage161292461602621612621678673673 AdditionalCapitalWorksduetoSRV-Assetmanagementandfinancialsustainabilityneeds-1501505503006001,0001,1001,3001,300 TotalCapitalWorks 10,38611,14213,11015,37019,95517,35215,24221,73723,50821,996

BASELINE SCENARIO FINANCIAL STATEMENTS - CONSOLIDATED INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 47
FederationCouncilLongTermFinancialPlan2021/22-2031/32 IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges17,14017,50218,44119,23120,03820,80021,52022,32723,16524,04324,95925,917 UserChargesandFees9,4219,4669,62610,18810,60811,19611,37111,82812,30412,80113,32113,865 Interest&InvestmentRevenue318228236236236236236236236236236236 OtherRevenues457446407415423432443454465477489501 Grants&ContributionsforOperatingPurposes15,04312,00314,11412,89613,04313,19013,34213,49513,65113,81013,97114,134 Grants&ContributionsforCapitalPurposes-Cash11,7945,6118529292,3553,1115,6114,0352,4215,3206,3155,617 NetGainsfromtheDisposalofAssets1,5027921,040500500500500500500500500500 TotalIncomefromContinuingOperations 55,67546,04844,71644,39647,20349,46553,02352,87552,74357,18659,79060,770 ExpensesfromContinuingOperations EmployeeCosts13,97816,44017,43517,86218,11318,56618,94019,32319,71720,12020,53120,954 BorrowingCosts3953835205164804646868768167557271,058 MaterialsandServices14,45916,09017,50918,76019,29520,05120,46920,98221,13621,48621,87822,432 Depreciation13,09515,13314,49114,49114,49114,49114,49114,49114,49114,49114,49114,491 NetLossesfromtheDisposalofAssets-----------OtherExpenses465663678697716735754773792812832853 TotalExpensesfromContinuingOperations 42,39248,70950,63352,32653,09554,30755,34056,44556,95257,66458,45959,788 OperatingResultfromContinuingOperations Surplus/(Deficit) 13,283(2,661)(5,917)(7,930)(5,891)(4,842)(2,317)(3,569)(4,209)(478)1,331982 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) 1,489(8,272)(6,769)(8,859)(8,247)(7,953)(7,928)(7,604)(6,631)(5,798)(4,984)(4,635)

BASELINE SCENARIO FINANCIAL STATEMENTS - GENERAL FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 48
FederationCouncilLongTermFinancialPlan2021/22-2031/32 GeneralFund-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges9,4049,5189,82310,06210,30710,55710,76311,02411,29311,56811,85012,139 UserChargesandFees4,4674,0544,0114,2864,4114,6904,5484,6624,7794,8985,0205,146 Interest&InvestmentRevenue1588080808080808080808080 OtherRevenues203345295301307313321329337346354363 Grants&ContributionsforOperatingPurposes13,73211,78913,90112,67912,82112,96413,11013,25813,40813,56013,71513,872 Grants&ContributionsforCapitalPurposes-Cash9,9815,578330330330330330330330330330330 NetGainsfromtheDisposalofAssets1,2187921,040500500500500500500500500500 TotalIncomefromContinuingOperations 39,16332,15629,48028,23828,75629,43429,65230,18330,72731,28231,84932,430 ExpensesfromContinuingOperations EmployeeCosts9,16210,98711,60511,88912,09212,39212,64012,89513,15613,42313,69613,977 BorrowingCosts2222101991871741611471331191069584 MaterialsandServices10,2749,2639,86910,60510,75011,17911,43511,78411,76911,94612,16012,532 Depreciation10,76411,72011,08811,08811,08811,08811,08811,08811,08811,08811,08811,088 NetLossesfromtheDisposalofAssets-----------OtherExpenses216584678697716735754773792812832853 TotalExpensesfromContinuingOperations 30,63832,76433,43934,46534,82035,55536,06436,67336,92437,37537,87138,534 OperatingResultfromContinuingOperations Surplus/(Deficit) 8,525(608)(3,959)(6,228)(6,064)(6,121)(6,412)(6,490)(6,197)(6,093)(6,022)(6,104) NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) (1,456)(6,186)(4,289)(6,558)(6,394)(6,451)(6,742)(6,820)(6,527)(6,423)(6,352)(6,434)

BASELINE SCENARIO FINANCIAL STATEMENTS - WATER FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 49
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Water-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges1,2091,3961,4571,5371,6201,7081,8001,8971,9982,1052,2172,335 UserChargesandFees4,3534,6354,8205,0585,3025,5585,8236,1066,4026,7147,0427,385 Interest&InvestmentRevenue878085858585858585858585 OtherRevenues625369707273757779818385 Grants&ContributionsforOperatingPurposes7896866676970727475777981 Grants&ContributionsforCapitalPurposes-Cash974334973434356957147873,6123,7124,104 TotalIncomefromContinuingOperations 7,6586,2656,9946,8517,1827,5298,5508,9529,42612,67413,21814,075 ExpensesfromContinuingOperations EmployeeCosts2,3732,7002,9453,0152,9883,0643,1263,1893,2553,3223,3903,460 BorrowingCosts-7161176159142124105846373445 MaterialsandServices1,1462,3572,6142,7822,8933,0103,0563,1023,1503,1993,2493,301 Depreciation1,1401,7121,7071,7071,7071,7071,7071,7071,7071,7071,7071,707 NetLossesfromtheDisposalofAssets-----------OtherExpenses249----------TotalExpensesfromContinuingOperations 4,9086,7767,4277,6807,7477,9238,0138,1038,1968,2918,4198,913 OperatingResultfromContinuingOperations Surplus/(Deficit) 2,750(511)(433)(828)(565)(394)5378501,2304,3844,7985,161 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) 1,776(544)(930)(862)(600)(429)(158)1364437721,0871,058

BASELINE SCENARIO FINANCIAL STATEMENTS - SEWERAGE FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 50
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Sewerage-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges4,4784,5754,8005,0975,4105,7436,0966,4706,8667,2867,7318,203 UserChargesandFees6017777958448959481,0001,0601,1231,1891,2591,334 Interest&InvestmentRevenue655560606060606060606060 OtherRevenues1924843444546474849505253 Grants&ContributionsforOperatingPurposes4456667687071737577788082 Grants&ContributionsforCapitalPurposes-Cash839-255661,9912,7464,5872,9911,3051,3772,2731,183 NetGainsfromtheDisposalofAssets100----------TotalIncomefromContinuingOperations 6,7205,5215,7906,6798,4709,61411,86210,7049,47910,04111,45510,916 ExpensesfromContinuingOperations EmployeeCosts2,2112,5882,6922,7592,8282,8992,9583,0183,0793,1423,2063,272 BorrowingCosts173166160154146161414638613587559529 MaterialsandServices1,1202,6232,7672,9453,0633,1863,2353,2843,3353,3873,4413,495 Depreciation1,1911,7011,6961,6961,6961,6961,6961,6961,6961,6961,6961,696 NetLossesfromtheDisposalofAssets-----------OtherExpenses-----------TotalExpensesfromContinuingOperations 4,6957,0787,3157,5547,7337,9428,3038,6368,7238,8128,9028,992 OperatingResultfromContinuingOperations Surplus/(Deficit) 2,025(1,557)(1,525)(875)7371,6723,5592,0687561,2292,5541,924 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) 1,186(1,557)(1,550)(1,440)(1,254)(1,074)(1,028)(923)(549)(148)280741

BASELINE SCENARIO FINANCIAL STATEMENTS - WASTE FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 51
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Waste-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges2,0492,0132,3612,5352,7012,7922,8612,9363,0083,0843,1613,240 UserChargesandFees-----------Interest&InvestmentRevenue81311111111111111111111 OtherRevenues-----------Grants&ContributionsforOperatingPurposes778080828385878991949698 Grants&ContributionsforCapitalPurposes-Cash-----------TotalIncomefromContinuingOperations 2,1342,1062,4522,6282,7952,8882,9593,0363,1103,1893,2683,349 ExpensesfromContinuingOperations EmployeeCosts232165193199205211216221227233239245 BorrowingCosts-----------MaterialsandServices1,9191,8472,2592,4282,5892,6762,7432,8122,8822,9543,0283,104 Depreciation-----------NetLossesfromtheDisposalofAssets-----------OtherExpenses-79---------TotalExpensesfromContinuingOperations 2,1512,0912,4522,6272,7942,8872,9593,0333,1093,1873,2673,349 OperatingResultfromContinuingOperations Surplus/(Deficit) (17)15-111031210 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) (17)15-111031210

BASELINE SCENARIO FINANCIAL STATEMENTS - CONSOLIDATED BALANCE SHEET

Long Term Financial Plan 2023 - 2033 52
FederationCouncilLongTermFinancialPlan2021/22-2031/32 BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents16,71928,19827,98524,58622,01123,98523,44120,27318,94515,08818,27922,555 Investments26,111----------Receivables9,1443,9873,7883,8294,0804,2824,5944,5764,5484,9575,1745,260 Inventories2,9731,8351,8351,8351,8351,8351,8351,8351,8351,8351,8351,835 Other(IncludesAssetsHeldforSale)183190190190190190190190190190190190 TotalCurrentAssets 55,13034,21033,79830,44028,11630,29330,06026,87325,51822,07025,47729,839 Non-CurrentAssets Investments4,529----------Receivables606060606060606060606060 Infrastructure,Property,Plant&Equipment670,200573,433579,827574,468581,116577,605589,570587,931594,119595,944609,396611,311 Other307585585585585585585585585585585585 TotalNon-CurrentAssets 675,096574,078580,472575,113581,761578,250590,215588,576594,764596,589610,041611,956 TotalAssets730,226608,288614,269605,553609,877608,543620,275615,449620,282618,658635,518641,795 CurrentLiabilities Payables15,1792,8663,0753,2343,3133,4223,4713,5623,6133,6703,7313,827 Borrowings5348679459811,0191,1781,3471,4061,2021,2401,4851,358 Provisions432----------Other2,8203,4463,4463,4463,4463,4463,4463,4463,4463,4463,4463,446 TotalCurrentLiabilities 18,9657,1797,4667,6617,7788,0468,2648,4148,2618,3568,6628,631 NonCurrentLiabilities Borrowings9,98812,01812,16011,17910,15913,39816,46915,06313,86112,62217,82023,144 Provisions 7091,1411,1411,1411,1411,1411,1411,1411,1411,1411,1411,141 Other276377377377377377377377377377377377 TotalNonCurrentLiabilities 10,97313,53613,67812,69711,67714,91617,98716,58115,37914,14019,33824,662 TotalLiabilities29,93820,71521,14520,35819,45522,96326,25224,99523,64122,49527,99933,294 NetAssets700,288587,573593,125585,195590,422585,580594,023590,455596,642596,163607,519608,502 Equity RetainedEarnings516,196523,986518,069510,139504,247499,405497,089493,519489,310488,832490,163491,145 RevaluationReserves184,09263,58775,05675,05686,17486,17496,93596,935107,332107,332117,357117,357 TotalEquity700,288587,573593,124585,194590,421585,579594,024590,454596,642596,163607,520608,502

BASELINE SCENARIO FINANCIAL STATEMENTS - GENERAL FUND BALANCE SHEET

FederationCouncilLongTermFinancialPlan2021/22-2031/32

GeneralFund-BalanceSheetProjections

Long Term Financial Plan 2023 - 2033 53
ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents10,26110,83111,44910,3019,2678,3216,9335,6024,6213,8613,1422,389 Investments15,406----------Receivables4,4482,7252,4572,4102,4532,5112,5262,5782,6222,6702,7122,770 Inventories2,9731,8351,8351,8351,8351,8351,8351,8351,8351,8351,8351,835 Other(IncludesAssetsHeldforSale)183190190190190190190190190190190190 TotalCurrentAssets 33,27115,58115,93114,73613,74512,85711,48410,2059,2688,5567,8797,184 Non-CurrentAssets Investments2,626----------Receivables606060606060606060606060 Infrastructure,Property,Plant&Equipment565,484470,905475,595470,118473,686467,951471,274465,529468,319462,621465,336459,638 Other307585585585585585585585585585585585 TotalNon-CurrentAssets 568,477471,550476,240470,763474,331468,596471,919466,174468,964463,266465,981460,283 TotalAssets601,748487,131492,171485,499488,076481,453483,403476,378478,232471,822473,860467,467 CurrentLiabilities Payables14,8861,7931,9021,9992,0302,0962,1352,1952,2172,2572,2942,359 Borrowings451539541553567580594609357343355366 Provisions432----------Other2,8202,8422,8422,8422,8422,8422,8422,8422,8422,8422,8422,842 TotalCurrentLiabilities 18,5895,1745,2855,3945,4395,5185,5715,6465,4165,4425,4915,567 NonCurrentLiabilities Borrowings7,7857,4126,8826,3285,7625,1824,5873,9793,6223,2792,9242,558 Provisions 7091,1411,1411,1411,1411,1411,1411,1411,1411,1411,1411,141 Other276377377377377377377377377377377377 TotalNonCurrentLiabilities 8,7708,9308,4007,8467,2806,7006,1055,4975,1404,7974,4424,076 TotalLiabilities27,35914,10413,68513,24012,71912,21711,67711,14310,55610,2399,9339,643 NetAssets574,389473,027478,486472,259475,357469,236471,726465,235467,676461,583463,927457,824 Equity RetainedEarnings412,688424,968421,009414,781408,717402,596396,183389,693383,496377,403371,381365,277 RevaluationReserves161,70148,05957,47757,47766,64066,64075,54375,54384,18084,18092,54692,546 TotalEquity574,389473,027478,486472,258475,357469,236471,726465,236467,676461,583463,927457,824

BASELINE SCENARIO FINANCIAL STATEMENTS - WATER FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 54
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Water-BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents4,19610,50011,13110,21710,34110,74010,34610,20810,6148,21312,85616,933 Investments5,744----------Receivables2,1735746065986276587427808211,1251,1701,249 TotalCurrentAssets 12,11311,07411,73710,81510,96911,39811,08810,98811,4359,33814,02618,183 Non-CurrentAssets Investments1,042----------Infrastructure,Property,Plant&Equipment46,15947,59348,33348,13848,00946,86048,19348,77249,96656,02263,12670,174 TotalNon-CurrentAssets 47,20147,59348,33348,13848,00946,86048,19348,77249,96656,02263,12670,174 TotalAssets59,31458,66760,07058,95358,97858,25859,28159,76061,40165,36077,15188,356 CurrentLiabilities Payables288435484506522541537549563562571583 Borrowings-240311328345363383403424447651480 Other-264264264264264264264264264264264 TotalCurrentLiabilities 2889391,0591,0981,1311,1681,1841,2161,2511,2731,4861,327 NonCurrentLiabilities Borrowings-2,4903,2542,9262,5812,2181,8361,4331,0085616,59312,795 TotalNonCurrentLiabilities -2,4903,2542,9262,5812,2181,8361,4331,0085616,59312,795 TotalLiabilities2883,4294,3134,0253,7123,3863,0202,6492,2591,8348,07814,122 NetAssets59,02655,23855,75754,92855,26654,87256,26157,11159,14363,52669,07374,235 Equity RetainedEarnings53,81853,15052,71751,88951,32350,93051,46652,31653,54657,93062,72867,890 RevaluationReserves5,2082,0883,0403,0403,9423,9424,7954,7955,5965,5966,3456,345 TotalEquity59,02655,23855,75754,92955,26654,87256,26157,11159,14263,52669,07374,234

BASELINE SCENARIO FINANCIAL STATEMENTS - SEWERAGE FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 55
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Sewerage-BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents2,2606,8005,3373,9992,3334,8536,0914,3893,6342,9372,2033,154 Investments4,961----------Receivables2,3594995065857498541,0619468268751,000940 TotalCurrentAssets 9,5807,2995,8424,5843,0825,7077,1525,3344,4603,8123,2024,094 Non-CurrentAssets Investments861----------Infrastructure,Property,Plant&Equipment58,55754,93555,89956,21259,42162,79470,10473,63175,83477,30180,93481,499 TotalNon-CurrentAssets 59,41854,93555,89956,21259,42162,79470,10473,63175,83477,30180,93481,499 TotalAssets68,99862,23461,74160,79662,50268,50177,25678,96580,29481,11384,13685,592 CurrentLiabilities Payables5450470493509526534545555564573585 Borrowings838893100108235370395421449479511 Other-340340340340340340340340340340340 TotalCurrentLiabilities 888789039339571,1011,2441,2801,3161,3531,3921,436 NonCurrentLiabilities Borrowings2,2032,1162,0241,9241,8165,99910,0469,6529,2318,7828,3037,791 TotalNonCurrentLiabilities 2,2032,1162,0241,9241,8165,99910,0469,6529,2318,7828,3037,791 TotalLiabilities2,2912,9942,9282,8572,7747,10011,29010,93210,54610,1359,6959,227 NetAssets66,70759,24058,81457,93959,72861,40165,96568,03369,74870,97874,44176,365 Equity RetainedEarnings49,52445,80044,27543,40044,13745,80949,36851,43652,19253,42255,97557,899 RevaluationReserves17,18313,44014,53914,53915,59215,59216,59816,59817,55617,55618,46618,466 TotalEquity66,70759,24058,81457,93959,72961,40165,96668,03469,74870,97874,44176,365

BASELINE SCENARIO FINANCIAL STATEMENTS - WASTE FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 56
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Waste-BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents26769697071717476787979 Receivables164189219235250259264272279286292300 TotalCurrentAssets 166256288304321330336346355363371379 Non-CurrentAssets Cash&CashEquivalents-----------TotalNon-CurrentAssets TotalAssets166256288304321330336346355363371379 CurrentLiabilities Payables-188220236251259265272279286293301 TotalCurrentLiabilities -188220236251259265272279286293301 NonCurrentLiabilities Payables-----------TotalNonCurrentLiabilities TotalLiabilities-188220236251259265272279286293301 NetAssets1666868697071717475777879 Equity RetainedEarnings1666868697071717475777879 TotalEquity1666868697071717475777879

BASELINE SCENARIO FINANCIAL STATEMENTS - CONSOLIDATED CASH FLOW STATEMENT

FederationCouncilLongTermFinancialPlan2021/22-2031/32

CashFlowStatementProjections

Long Term Financial Plan 2023 - 2033 57
ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities51,66045,09244,58244,41347,04349,37652,86753,02952,93857,03759,84060,962 Payments-OperatingActivities(27,870)(31,506)(35,282)(36,855)(37,683)(38,808)(39,250)(40,388)(41,283)(41,539)(42,206)(43,329) NetCashProvidedby(orusedin)OperatingActivities23,79013,5869,3007,5589,36010,56813,61712,64111,65515,49817,63517,633 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment1821,2011,144550550550550550550550550550 Purchases-Infrastructure,Property,Plant&Equipment(17,576)(20,501)(10,358)(10,045)(11,023)(12,078)(17,265)(14,137)(11,310)(17,948)(19,710)(18,047) Receipts/Purchases-OtherAssets2,91315,454 NetCashProvidedby(orusedin)InvestingActivities(14,481)(3,846)(9,214)(9,495)(10,473)(11,528)(16,715)(13,587)(10,760)(17,398)(19,160)(17,497) CashFlowfromFinancingActivities Receipts-LoanBorrowings -2,7501,050--4,4274,427---6,6976,697 Payments-PrincipalRepayments (588)(629)(829)(945)(981)(1,029)(1,188)(1,347)(1,406)(1,202)(1,254)(1,499) Payments-FinanceCosts(395)(382)(520)(516)(480)(464)(686)(876)(816)(755)(727)(1,058) NetCashProvidedby(orusedin)FinancingActivities(983)1,739(300)(1,461)(1,461)2,9342,553(2,222)(2,222)(1,957)4,7164,140 NetIncrease/(Decrease)inCashAssetsHeld 8,32611,479(213)(3,399)(2,575)1,974(544)(3,168)(1,328)(3,857)3,1914,276 CashandCashEquivalentsatBeginningofReporting Period 8,39316,71928,19827,98524,58622,01123,98523,44120,27318,94515,08818,279 CashandCashEquivalentsatEndofReportingPeriod16,71928,19827,98524,58622,01123,98523,44120,27318,94515,08818,27922,555 plusInvestmentsonHand-EndofReportingPeriod 30,640----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod47,35928,19827,98524,58622,01123,98523,44120,27318,94515,08818,27922,555

BASELINE SCENARIO FINANCIAL STATEMENTS – GENERAL FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 58
ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities35,45831,26128,86727,81928,24428,91029,17329,66630,21630,77031,34531,912 Payments-OperatingActivities(18,620)(19,983)(21,670)(22,617)(23,058)(23,790)(24,324)(24,942)(25,254)(25,689)(26,195)(26,847) NetCashProvidedby(orusedin)OperatingActivities16,83811,2787,1975,2025,1865,1204,8484,7244,9625,0815,1505,064 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment1821,2011,144550550550550550550550550550 Purchases-Infrastructure,Property,Plant&Equipment(9,854)(10,714)(6,996)(6,172)(6,042)(5,888)(6,059)(5,877)(5,765)(5,929)(5,981)(5,929) Receipts/Purchases-OtherAssets1,243(458) NetCashProvidedby(orusedin)InvestingActivities(8,429)(9,971)(5,852)(5,622)(5,492)(5,338)(5,509)(5,327)(5,215)(5,379)(5,431)(5,379) CashFlowfromFinancingActivities Receipts-LoanBorrowingsPayments-PrincipalRepayments (511)(527)(528)(541)(553)(567)(580)(594)(609)(357)(343)(355) Payments-FinanceCosts (222)(210)(199)(187)(174)(161)(147)(133)(119)(106)(95)(84) NetCashProvidedby(orusedin)FinancingActivities(733)(737)(728)(728)(728)(728)(728)(728)(728)(462)(438)(438) NetIncrease/(Decrease)inCashAssetsHeld 7,676570618(1,148)(1,034)(946)(1,388)(1,331)(981)(760)(719)(753) CashandCashEquivalentsatBeginningofReporting Period 2,58510,26110,83111,44910,3019,2678,3216,9335,6024,6213,8613,142 CashandCashEquivalentsatEndofReportingPeriod10,26110,83111,44910,3019,2678,3216,9335,6024,6213,8613,1422,389 plusInvestmentsonHand-EndofReportingPeriod 18,032----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod28,29310,83111,44910,3019,2678,3216,9335,6024,6213,8613,1422,389
FederationCouncilLongTermFinancialPlan2021/22-2031/32 GeneralFund-CashFlowStatementProjections

BASELINE SCENARIO FINANCIAL STATEMENTS – WATER FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 59
CouncilLongTermFinancialPlan2021/22-2031/32
-CashFlowStatementProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities7,4746,2507,4517,3727,6908,0629,0569,53310,03313,08413,88614,745 Payments-OperatingActivities(3,768)(4,548)(5,850)(6,136)(6,335)(6,562)(6,557)(6,669)(6,830)(6,459)(6,537)(6,624) NetCashProvidedby(orusedin)OperatingActivities3,7061,7021,6011,2361,3551,4992,4982,8643,2036,6257,3498,122 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment-Purchases-Infrastructure,Property,Plant&Equipment(3,750)(6,054)(1,645)(1,663)(744)(614)(2,406)(2,515)(2,310)(8,539)(8,868)(9,631) Receipts/Purchases-OtherAssets1,0617,933 NetCashProvidedby(orusedin)InvestingActivities(2,689)1,879(1,645)(1,663)(744)(614)(2,406)(2,515)(2,310)(8,539)(8,868)(9,631) CashFlowfromFinancingActivities Receipts-LoanBorrowings -2,7501,050-------6,6976,697 Payments-PrincipalRepayments -(20)(215)(311)(328)(345)(363)(383)(403)(424)(462)(665) Payments-FinanceCosts -(7)(161)(176)(159)(142)(124)(105)(84)(63)(73)(445) NetCashProvidedby(orusedin)FinancingActivities -2,723674(487)(487)(487)(487)(487)(487)(487)6,1625,586 NetIncrease/(Decrease)inCashAssetsHeld 1,0176,304631(914)124399(394)(137)406(2,401)4,6434,077 CashandCashEquivalentsatBeginningofReporting Period 3,1794,19610,50011,13110,21710,34110,74010,34610,20810,6148,21312,856 CashandCashEquivalentsatEndofReportingPeriod4,19610,50011,13110,21710,34110,74010,34610,20810,6148,21312,85616,933 plusInvestmentsonHand-EndofReportingPeriod 6,786----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod10,98210,50011,13110,21710,34110,74010,34610,20810,6148,21312,85616,933
Federation
Water

BASELINE SCENARIO FINANCIAL STATEMENTS – SEWERAGE FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 60
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Sewerage-CashFlowStatementProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities6,6205,4725,8236,6098,3289,52511,68510,8019,58510,00011,34710,963 Payments-OperatingActivities(3,331)(4,881)(5,323)(5,490)(5,510)(5,577)(5,415)(5,751)(6,097)(6,210)(6,213)(6,517) NetCashProvidedby(orusedin)OperatingActivities3,2895915011,1192,8173,9486,2705,0503,4883,7905,1344,446 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment-Purchases-Infrastructure,Property,Plant&Equipment(3,972)(3,733)(1,717)(2,210)(4,237)(5,576)(8,800)(5,745)(3,235)(3,479)(4,861)(2,487) Receipts/Purchases-OtherAssets6097,929 NetCashProvidedby(orusedin)InvestingActivities(3,363)4,196(1,717)(2,210)(4,237)(5,576)(8,800)(5,745)(3,235)(3,479)(4,861)(2,487) CashFlowfromFinancingActivities Receipts-LoanBorrowings ---4,4274,427----Payments-PrincipalRepayments (77)(82)(86)(93)(100)(117)(245)(370)(395)(421)(449)(479) Payments-FinanceCosts (173)(165)(160)(154)(146)(161)(414)(638)(613)(587)(559)(529) NetCashProvidedby(orusedin)FinancingActivities(250)(247)(247)(247)(247)4,1493,768(1,008)(1,008)(1,008)(1,008)(1,008) NetIncrease/(Decrease)inCashAssetsHeld (324)4,540(1,463)(1,338)(1,666)2,5201,238(1,703)(755)(697)(734)951 CashandCashEquivalentsatBeginningofReporting Period 2,5842,2606,8005,3373,9992,3334,8536,0914,3893,6342,9372,203 CashandCashEquivalentsatEndofReportingPeriod2,2606,8005,3373,9992,3334,8536,0914,3893,6342,9372,2033,154 plusInvestmentsonHand-EndofReportingPeriod 5,822----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod8,0826,8005,3373,9992,3334,8536,0914,3893,6342,9372,2033,154

BASELINE SCENARIO FINANCIAL STATEMENTS – WASTE FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 61
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Waste-CashFlowStatementProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities2,1082,1092,4412,6132,7812,8802,9543,0293,1043,1823,2623,342 Payments-OperatingActivities(2,151)(2,094)(2,439)(2,612)(2,780)(2,879)(2,954)(3,026)(3,103)(3,181)(3,261)(3,341) NetCashProvidedby(orusedin)OperatingActivities(43)152111032211 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment-Purchases-Infrastructure,Property,Plant&Equipment-Receipts/Purchases-OtherAssets-50 NetCashProvidedby(orusedin)InvestingActivities -50---------CashFlowfromFinancingActivities Receipts-LoanBorrowingsPayments-PrincipalRepayments Payments-FinanceCosts NetCashProvidedby(orusedin)FinancingActivities NetIncrease/(Decrease)inCashAssetsHeld (43)652111032211 CashandCashEquivalentsatBeginningofReporting Period 45267686970717174757778 CashandCashEquivalentsatEndofReportingPeriod26768697071717475777879 plusInvestmentsonHand-EndofReportingPeriod TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod26768697071717475777879

BASELINE SCENARIO FINANCIAL STATEMENTS – CAPITAL WORKS STATEMENT PROJECTION

Long Term Financial Plan 2023 - 2033 62
Federation
CapitalWorksStatementProjections Proposed Budget YearEnding2024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s SealedRoads3,9243,1403,1403,1403,1403,1403,1403,1403,1403,140 StormwaterDrainage223919451----47Sewerage1,5612,0093,8525,0698,0005,2232,9413,1634,4192,261 Water1,4951,5126765582,1872,2862,1007,7638,0628,755 Plant,machineryandequipment1,9062,0002,0002,0002,0002,0002,0002,0002,0002,000 Computersandtelecommunications307380259162368203101250250250 TotalCapitalWorks 9,4169,13210,02110,98015,69512,85210,28216,31617,91816,406
CouncilLongTermFinancialPlan2021/22-2031/32

ALTERNATE SCENARIO FINANCIAL STATEMENTS - CONSOLIDATED INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 63
FederationCouncilLongTermFinancialPlan2021/22-2031/32 IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges17,14017,50218,44120,80223,29125,79227,83128,79629,79530,83931,92533,057 UserChargesandFees9,4219,4669,62610,18810,60811,19611,37111,82812,30412,80113,32113,865 Interest&InvestmentRevenue318228236236236236236236236236236236 OtherRevenues457446407415423432443454465477489501 Grants&ContributionsforOperatingPurposes15,04312,00314,11412,89613,04313,19013,34213,49513,65113,81013,97114,134 Grants&ContributionsforCapitalPurposes-Cash11,7945,6118529292,3553,1115,6114,0352,4215,3206,3155,617 NetGainsfromtheDisposalofAssets1,5027921,040500500500500500500500500500 TotalIncomefromContinuingOperations 55,67546,04844,71645,96750,45654,45759,33459,34459,37363,98266,75667,910 ExpensesfromContinuingOperations EmployeeCosts13,97816,44017,43517,86218,11318,56618,94019,32319,71720,12020,53120,954 BorrowingCosts3953835205164804646868768167557271,058 MaterialsandServices14,45916,09017,50918,99519,53020,19620,57420,98221,13621,48621,87822,432 Depreciation13,09515,13314,49114,49114,49114,49114,49114,49114,49114,49114,49114,491 NetLossesfromtheDisposalofAssets-----------OtherExpenses465663678697716735754773792812832853 TotalExpensesfromContinuingOperations 42,39248,70950,63352,56153,33054,45255,44556,44556,95257,66458,45959,788 OperatingResultfromContinuingOperations Surplus/(Deficit) 13,283(2,661)(5,917)(6,594)(2,873)53,8892,9002,4216,3188,2978,122 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) 1,489(8,272)(6,769)(7,523)(5,229)(3,106)(1,722)(1,135)(1)9981,9822,505

ALTERNATE SCENARIO FINANCIAL STATEMENTS - GENERAL FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 64
FederationCouncilLongTermFinancialPlan2021/22-2031/32 GeneralFund-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges9,4049,5189,82311,63313,56015,54917,07417,49317,92318,36418,81619,279 UserChargesandFees4,4674,0544,0114,2864,4114,6904,5484,6624,7794,8985,0205,146 Interest&InvestmentRevenue1588080808080808080808080 OtherRevenues203345295301307313321329337346354363 Grants&ContributionsforOperatingPurposes13,73211,78913,90112,67912,82112,96413,11013,25813,40813,56013,71513,872 Grants&ContributionsforCapitalPurposes-Cash9,9815,578330330330330330330330330330330 NetGainsfromtheDisposalofAssets1,2187921,040500500500500500500500500500 TotalIncomefromContinuingOperations 39,16332,15629,48029,80932,00934,42635,96336,65237,35738,07838,81539,570 ExpensesfromContinuingOperations EmployeeCosts9,16210,98711,60511,88912,09212,39212,64012,89513,15613,42313,69613,977 BorrowingCosts2222101991871741611471331191069584 MaterialsandServices10,2749,2639,86910,84010,98511,32411,54011,78411,76911,94612,16012,532 Depreciation10,76411,72011,08811,08811,08811,08811,08811,08811,08811,08811,08811,088 NetLossesfromtheDisposalofAssets-----------OtherExpenses216584678697716735754773792812832853 TotalExpensesfromContinuingOperations 30,63832,76433,43934,70035,05535,70036,16936,67336,92437,37537,87138,534 OperatingResultfromContinuingOperations Surplus/(Deficit) 8,525(608)(3,959)(4,892)(3,046)(1,274)(206)(21)4337039441,036 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) (1,456)(6,186)(4,289)(5,222)(3,376)(1,604)(536)(351)103373614706

ALTERNATE SCENARIO FINANCIAL STATEMENTS - WATER FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 65
FederationCouncil
FinancialPlan2021/22-
IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges1,2091,3961,4571,5371,6201,7081,8001,8971,9982,1052,2172,335 UserChargesandFees4,3534,6354,8205,0585,3025,5585,8236,1066,4026,7147,0427,385 Interest&InvestmentRevenue878085858585858585858585 OtherRevenues625369707273757779818385 Grants&ContributionsforOperatingPurposes7896866676970727475777981 Grants&ContributionsforCapitalPurposes-Cash974334973434356957147873,6123,7124,104 TotalIncomefromContinuingOperations 7,6586,2656,9946,8517,1827,5298,5508,9529,42612,67413,21814,075 ExpensesfromContinuingOperations EmployeeCosts2,3732,7002,9453,0152,9883,0643,1263,1893,2553,3223,3903,460 BorrowingCosts-7161176159142124105846373445 MaterialsandServices1,1462,3572,6142,7822,8933,0103,0563,1023,1503,1993,2493,301 Depreciation1,1401,7121,7071,7071,7071,7071,7071,7071,7071,7071,7071,707 NetLossesfromtheDisposalofAssets-----------OtherExpenses249----------TotalExpensesfromContinuingOperations 4,9086,7767,4277,6807,7477,9238,0138,1038,1968,2918,4198,913 OperatingResultfromContinuingOperations Surplus/(Deficit) 2,750(511)(433)(828)(565)(394)5378501,2304,3844,7985,161 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) 1,776(544)(930)(862)(600)(429)(158)1364437721,0871,058
LongTerm
2031/32 Water-

ALTERNATE SCENARIO FINANCIAL STATEMENTS - SEWERAGE FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 66
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Sewerage-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges4,4784,5754,8005,0975,4105,7436,0966,4706,8667,2867,7318,203 UserChargesandFees6017777958448959481,0001,0601,1231,1891,2591,334 Interest&InvestmentRevenue655560606060606060606060 OtherRevenues1924843444546474849505253 Grants&ContributionsforOperatingPurposes4456667687071737577788082 Grants&ContributionsforCapitalPurposes-Cash839-255661,9912,7464,5872,9911,3051,3772,2731,183 NetGainsfromtheDisposalofAssets100----------TotalIncomefromContinuingOperations 6,7205,5215,7906,6798,4709,61411,86210,7049,47910,04111,45510,916 ExpensesfromContinuingOperations EmployeeCosts2,2112,5882,6922,7592,8282,8992,9583,0183,0793,1423,2063,272 BorrowingCosts173166160154146161414638613587559529 MaterialsandServices1,1202,6232,7672,9453,0633,1863,2353,2843,3353,3873,4413,495 Depreciation1,1911,7011,6961,6961,6961,6961,6961,6961,6961,6961,6961,696 NetLossesfromtheDisposalofAssets-----------OtherExpenses-----------TotalExpensesfromContinuingOperations 4,6957,0787,3157,5547,7337,9428,3038,6368,7238,8128,9028,992 OperatingResultfromContinuingOperations Surplus/(Deficit) 2,025(1,557)(1,525)(875)7371,6723,5592,0687561,2292,5541,924 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) 1,186(1,557)(1,550)(1,440)(1,254)(1,074)(1,028)(923)(549)(148)280741

ALTERNATE SCENARIO FINANCIAL STATEMENTS - WASTE FUND INCOME STATEMENT

Long Term Financial Plan 2023 - 2033 67
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Waste-IncomeStatementProjections ActualBudgetProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s IncomefromContinuingOperations RatesandAnnualCharges2,0492,0132,3612,5352,7012,7922,8612,9363,0083,0843,1613,240 UserChargesandFees-----------Interest&InvestmentRevenue81311111111111111111111 OtherRevenues-----------Grants&ContributionsforOperatingPurposes778080828385878991949698 Grants&ContributionsforCapitalPurposes-Cash-----------TotalIncomefromContinuingOperations 2,1342,1062,4522,6282,7952,8882,9593,0363,1103,1893,2683,349 ExpensesfromContinuingOperations EmployeeCosts232165193199205211216221227233239245 BorrowingCosts-----------MaterialsandServices1,9191,8472,2592,4282,5892,6762,7432,8122,8822,9543,0283,104 Depreciation-----------NetLossesfromtheDisposalofAssets-----------OtherExpenses-79---------TotalExpensesfromContinuingOperations 2,1512,0912,4522,6272,7942,8872,9593,0333,1093,1873,2673,349 OperatingResultfromContinuingOperations Surplus/(Deficit) (17)15-111031210 NetOperatingResultfortheyearbeforeGrantsand ContributionsprovidedforCapitalPurposes Surplus/(Deficit) (17)15-111031210

ALTERNATE SCENARIO FINANCIAL STATEMENTS - CONSOLIDATED BALANCE SHEET

Long Term Financial Plan 2023 - 2033 68
FederationCouncilLongTermFinancialPlan2021/22-2031/32 BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents16,71928,19827,98524,83423,12126,69327,84426,86327,65025,61130,33036,139 Investments26,111----------Receivables9,1443,9873,7883,9684,3664,7195,1495,1435,1315,5565,7905,893 Inventories2,9731,8351,8351,8351,8351,8351,8351,8351,8351,8351,8351,835 Other(IncludesAssetsHeldforSale)183190190190190190190190190190190190 TotalCurrentAssets 55,13034,21033,79830,82729,51133,43835,01734,03034,80533,19338,14544,057 Non-CurrentAssets Investments4,529----------Receivables606060606060606060606060 Infrastructure,Property,Plant&Equipment670,200573,433579,827575,438584,096583,674600,029602,650613,338620,123638,996646,501 Other307585585585585585585585585585585585 TotalNon-CurrentAssets 675,096574,078580,472576,083584,741584,319600,674603,295613,983620,768639,641647,146 TotalAssets730,226608,288614,269606,910614,252617,757635,692637,325648,788653,960677,786691,203 CurrentLiabilities Payables15,1792,8663,0753,2553,3343,4363,4813,5623,6133,6703,7313,827 Borrowings5348679459811,0191,1781,3471,4061,2021,2401,4851,358 Provisions432----------Other2,8203,4463,4463,4463,4463,4463,4463,4463,4463,4463,4463,446 TotalCurrentLiabilities 18,9657,1797,4667,6827,7998,0608,2748,4148,2618,3568,6628,631 NonCurrentLiabilities Borrowings9,98812,01812,16011,17910,15913,39816,46915,06313,86112,62217,82023,144 Provisions 7091,1411,1411,1411,1411,1411,1411,1411,1411,1411,1411,141 Other276377377377377377377377377377377377 TotalNonCurrentLiabilities 10,97313,53613,67812,69711,67714,91617,98716,58115,37914,14019,33824,662 TotalLiabilities29,93820,71521,14520,37919,47722,97626,26124,99523,64122,49527,99933,294 NetAssets700,288587,573593,125586,531594,776594,781609,430612,331625,148631,465649,787657,910 Equity RetainedEarnings516,196523,986518,069511,475508,601508,606512,496515,395517,816524,134532,431540,553 RevaluationReserves184,09263,58775,05675,05686,17486,17496,93596,935107,332107,332117,357117,357 TotalEquity700,288587,573593,124586,530594,775594,780609,431612,330625,148631,465649,788657,910

ALTERNATE SCENARIO FINANCIAL STATEMENTS - GENERAL FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 69
FederationCouncilLongTermFinancialPlan2021/22-2031/32
ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents10,26110,83111,44910,54910,37611,02911,33612,19113,32614,38415,19415,973 Investments15,406----------Receivables4,4482,7252,4572,5492,7392,9493,0813,1453,2043,2703,3293,403 Inventories2,9731,8351,8351,8351,8351,8351,8351,8351,8351,8351,8351,835 Other(IncludesAssetsHeldforSale)183190190190190190190190190190190190 TotalCurrentAssets 33,27115,58115,93115,12315,14016,00216,44217,36218,55519,67920,54721,402 Non-CurrentAssets Investments2,626----------Receivables606060606060606060606060 Infrastructure,Property,Plant&Equipment565,484470,905475,595471,088476,666474,020481,733480,248487,538486,800494,936494,828 Other307585585585585585585585585585585585 TotalNon-CurrentAssets 568,477471,550476,240471,733477,311474,665482,378480,893488,183487,445495,581495,473 TotalAssets601,748487,131492,171486,856492,451490,667498,819498,254506,738507,124516,128516,875 CurrentLiabilities Payables14,8861,7931,9022,0202,0522,1092,1452,1952,2172,2572,2942,359 Borrowings451539541553567580594609357343355366 Provisions432----------Other2,8202,8422,8422,8422,8422,8422,8422,8422,8422,8422,8422,842 TotalCurrentLiabilities 18,5895,1745,2855,4155,4615,5315,5815,6465,4165,4425,4915,567 NonCurrentLiabilities Borrowings7,7857,4126,8826,3285,7625,1824,5873,9793,6223,2792,9242,558 Provisions 7091,1411,1411,1411,1411,1411,1411,1411,1411,1411,1411,141 Other276377377377377377377377377377377377 TotalNonCurrentLiabilities 8,7708,9308,4007,8467,2806,7006,1055,4975,1404,7974,4424,076 TotalLiabilities27,35914,10413,68513,26212,74012,23011,68611,14310,55610,2399,9339,643 NetAssets574,389473,027478,486473,595479,711478,437487,133487,111496,182496,885506,195507,232 Equity RetainedEarnings412,688424,968421,009416,117413,071411,797411,590411,569412,002412,705413,649414,685 RevaluationReserves161,70148,05957,47757,47766,64066,64075,54375,54384,18084,18092,54692,546 TotalEquity574,389473,027478,486473,594479,711478,437487,133487,112496,182496,885506,195507,232
GeneralFund-BalanceSheetProjections

ALTERNATE SCENARIO FINANCIAL STATEMENTS - WATER FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 70
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Water-BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents4,19610,50011,13110,21710,34110,74010,34610,20810,6148,21312,85616,933 Investments5,744----------Receivables2,1735746065986276587427808211,1251,1701,249 TotalCurrentAssets 12,11311,07411,73710,81510,96911,39811,08810,98811,4359,33814,02618,183 Non-CurrentAssets Investments1,042----------Infrastructure,Property,Plant&Equipment46,15947,59348,33348,13848,00946,86048,19348,77249,96656,02263,12670,174 TotalNon-CurrentAssets 47,20147,59348,33348,13848,00946,86048,19348,77249,96656,02263,12670,174 TotalAssets59,31458,66760,07058,95358,97858,25859,28159,76061,40165,36077,15188,356 CurrentLiabilities Payables288435484506522541537549563562571583 Borrowings-240311328345363383403424447651480 Other-264264264264264264264264264264264 TotalCurrentLiabilities 2889391,0591,0981,1311,1681,1841,2161,2511,2731,4861,327 NonCurrentLiabilities Borrowings-2,4903,2542,9262,5812,2181,8361,4331,0085616,59312,795 TotalNonCurrentLiabilities -2,4903,2542,9262,5812,2181,8361,4331,0085616,59312,795 TotalLiabilities2883,4294,3134,0253,7123,3863,0202,6492,2591,8348,07814,122 NetAssets59,02655,23855,75754,92855,26654,87256,26157,11159,14363,52669,07374,235 Equity RetainedEarnings53,81853,15052,71751,88951,32350,93051,46652,31653,54657,93062,72867,890 RevaluationReserves5,2082,0883,0403,0403,9423,9424,7954,7955,5965,5966,3456,345 TotalEquity59,02655,23855,75754,92955,26654,87256,26157,11159,14263,52669,07374,234

ALTERNATE SCENARIO FINANCIAL STATEMENTS - SEWERAGE FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 71
FederationCouncilLongTermFinancialPlan2021/22-2031/32
-BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents2,2606,8005,3373,9992,3334,8536,0914,3893,6342,9372,2033,154 Investments4,961----------Receivables2,3594995065857498541,0619468268751,000940 TotalCurrentAssets 9,5807,2995,8424,5843,0825,7077,1525,3344,4603,8123,2024,094 Non-CurrentAssets Investments861----------Infrastructure,Property,Plant&Equipment58,55754,93555,89956,21259,42162,79470,10473,63175,83477,30180,93481,499 TotalNon-CurrentAssets 59,41854,93555,89956,21259,42162,79470,10473,63175,83477,30180,93481,499 TotalAssets68,99862,23461,74160,79662,50268,50177,25678,96580,29481,11384,13685,592 CurrentLiabilities Payables5450470493509526534545555564573585 Borrowings838893100108235370395421449479511 Other-340340340340340340340340340340340 TotalCurrentLiabilities 888789039339571,1011,2441,2801,3161,3531,3921,436 NonCurrentLiabilities Borrowings2,2032,1162,0241,9241,8165,99910,0469,6529,2318,7828,3037,791 TotalNonCurrentLiabilities 2,2032,1162,0241,9241,8165,99910,0469,6529,2318,7828,3037,791 TotalLiabilities2,2912,9942,9282,8572,7747,10011,29010,93210,54610,1359,6959,227 NetAssets66,70759,24058,81457,93959,72861,40165,96568,03369,74870,97874,44176,365 Equity RetainedEarnings49,52445,80044,27543,40044,13745,80949,36851,43652,19253,42255,97557,899 RevaluationReserves17,18313,44014,53914,53915,59215,59216,59816,59817,55617,55618,46618,466 TotalEquity66,70759,24058,81457,93959,72961,40165,96668,03469,74870,97874,44176,365
Sewerage

ALTERNATE SCENARIO FINANCIAL STATEMENTS - WASTE FUND BALANCE SHEET

Long Term Financial Plan 2023 - 2033 72
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Waste-BalanceSheetProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CurrentAssets Cash&CashEquivalents26769697071717476787979 Receivables164189219235250259264272279286292300 TotalCurrentAssets 166256288304321330336346355363371379 Non-CurrentAssets Cash&CashEquivalents-----------TotalNon-CurrentAssets TotalAssets166256288304321330336346355363371379 CurrentLiabilities Payables-188220236251259265272279286293301 TotalCurrentLiabilities -188220236251259265272279286293301 NonCurrentLiabilities Payables-----------TotalNonCurrentLiabilities TotalLiabilities-188220236251259265272279286293301 NetAssets1666868697071717475777879 Equity RetainedEarnings1666868697071717475777879 TotalEquity1666868697071717475777879

ALTERNATE SCENARIO FINANCIAL STATEMENTS - CONSOLIDATED CASH FLOW STATEMENT

FederationCouncilLongTermFinancialPlan2021/22-2031/32

CashFlowStatementProjections

Long Term Financial Plan 2023 - 2033 73
ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities51,66045,09244,58245,85550,15854,22559,07159,48459,55563,81966,79468,086 Payments-OperatingActivities(27,870)(31,506)(35,282)(36,982)(37,726)(38,661)(38,930)(39,969)(40,835)(41,047)(41,667)(42,772) NetCashProvidedby(orusedin)OperatingActivities23,79013,5869,3008,87312,43215,56420,14119,51418,72022,77225,12625,314 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment1821,2011,144550550550550550550550550550 Purchases-Infrastructure,Property,Plant&Equipment(17,576)(20,501)(10,358)(11,112)(13,234)(15,476)(22,094)(18,823)(16,260)(23,404)(25,673)(24,196) Receipts/Purchases-OtherAssets2,91315,454 NetCashProvidedby(orusedin)InvestingActivities(14,481)(3,846)(9,214)(10,562)(12,684)(14,926)(21,544)(18,273)(15,710)(22,854)(25,123)(23,646) CashFlowfromFinancingActivities Receipts-LoanBorrowings -2,7501,050--4,4274,427---6,6976,697 Payments-PrincipalRepayments (588)(629)(829)(945)(981)(1,029)(1,188)(1,347)(1,406)(1,202)(1,254)(1,499) Payments-FinanceCosts(395)(382)(520)(516)(480)(464)(686)(876)(816)(755)(727)(1,058) NetCashProvidedby(orusedin)FinancingActivities(983)1,739(300)(1,461)(1,461)2,9342,553(2,222)(2,222)(1,957)4,7164,140 NetIncrease/(Decrease)inCashAssetsHeld 8,32611,479(213)(3,151)(1,714)3,5731,151(981)787(2,039)4,7195,809 CashandCashEquivalentsatBeginningofReporting Period 8,39316,71928,19827,98524,83423,12126,69327,84426,86327,65025,61130,330 CashandCashEquivalentsatEndofReportingPeriod16,71928,19827,98524,83423,12126,69327,84426,86327,65025,61130,33036,139 plusInvestmentsonHand-EndofReportingPeriod 30,640----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod47,35928,19827,98524,83423,12126,69327,84426,86327,65025,61130,33036,139

ALTERNATE SCENARIO FINANCIAL STATEMENTS – GENERAL FUND CASH FLOW STATEMENT

FederationCouncilLongTermFinancialPlan2021/22-2031/32

GeneralFund-CashFlowStatementProjections

Long Term Financial Plan 2023 - 2033 74
ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities35,45831,26128,86729,26131,35933,75935,37736,12036,83337,55338,29939,036 Payments-OperatingActivities(18,620)(19,983)(21,670)(22,744)(23,101)(23,642)(24,004)(24,523)(24,806)(25,197)(25,657)(26,290) NetCashProvidedby(orusedin)OperatingActivities16,83811,2787,1976,5178,25810,11611,37211,59712,02712,35612,64212,746 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment1821,2011,144550550550550550550550550550 Purchases-Infrastructure,Property,Plant&Equipment(9,854)(10,714)(6,996)(7,239)(8,253)(9,286)(10,888)(10,563)(10,715)(11,385)(11,944)(12,078) Receipts/Purchases-OtherAssets1,243(458) NetCashProvidedby(orusedin)InvestingActivities(8,429)(9,971)(5,852)(6,689)(7,703)(8,736)(10,338)(10,013)(10,165)(10,835)(11,394)(11,528) CashFlowfromFinancingActivities Receipts-LoanBorrowingsPayments-PrincipalRepayments (511)(527)(528)(541)(553)(567)(580)(594)(609)(357)(343)(355) Payments-FinanceCosts (222)(210)(199)(187)(174)(161)(147)(133)(119)(106)(95)(84) NetCashProvidedby(orusedin)FinancingActivities(733)(737)(728)(728)(728)(728)(728)(728)(728)(462)(438)(438) NetIncrease/(Decrease)inCashAssetsHeld 7,676570618(900)(173)6533078561,1341,058810780 CashandCashEquivalentsatBeginningofReporting Period 2,58510,26110,83111,44910,54910,37611,02911,33612,19113,32614,38415,194 CashandCashEquivalentsatEndofReportingPeriod10,26110,83111,44910,54910,37611,02911,33612,19113,32614,38415,19415,973 plusInvestmentsonHand-EndofReportingPeriod 18,032----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod28,29310,83111,44910,54910,37611,02911,33612,19113,32614,38415,19415,973

ALTERNATE SCENARIO FINANCIAL STATEMENTS – WATER FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 75
CouncilLongTermFinancialPlan2021/22-2031/32
-CashFlowStatementProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities7,4746,2507,4517,3727,6908,0629,0569,53310,03313,08413,88614,745 Payments-OperatingActivities(3,768)(4,548)(5,850)(6,136)(6,335)(6,562)(6,557)(6,669)(6,830)(6,459)(6,537)(6,624) NetCashProvidedby(orusedin)OperatingActivities3,7061,7021,6011,2361,3551,4992,4982,8643,2036,6257,3498,122 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment-Purchases-Infrastructure,Property,Plant&Equipment(3,750)(6,054)(1,645)(1,663)(744)(614)(2,406)(2,515)(2,310)(8,539)(8,868)(9,631) Receipts/Purchases-OtherAssets1,0617,933 NetCashProvidedby(orusedin)InvestingActivities(2,689)1,879(1,645)(1,663)(744)(614)(2,406)(2,515)(2,310)(8,539)(8,868)(9,631) CashFlowfromFinancingActivities Receipts-LoanBorrowings -2,7501,050-------6,6976,697 Payments-PrincipalRepayments -(20)(215)(311)(328)(345)(363)(383)(403)(424)(462)(665) Payments-FinanceCosts -(7)(161)(176)(159)(142)(124)(105)(84)(63)(73)(445) NetCashProvidedby(orusedin)FinancingActivities -2,723674(487)(487)(487)(487)(487)(487)(487)6,1625,586 NetIncrease/(Decrease)inCashAssetsHeld 1,0176,304631(914)124399(394)(137)406(2,401)4,6434,077 CashandCashEquivalentsatBeginningofReporting Period 3,1794,19610,50011,13110,21710,34110,74010,34610,20810,6148,21312,856 CashandCashEquivalentsatEndofReportingPeriod4,19610,50011,13110,21710,34110,74010,34610,20810,6148,21312,85616,933 plusInvestmentsonHand-EndofReportingPeriod 6,786----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod10,98210,50011,13110,21710,34110,74010,34610,20810,6148,21312,85616,933
Federation
Water

ALTERNATE SCENARIO FINANCIAL STATEMENTS – SEWERAGE FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 76
CouncilLongTermFinancialPlan2021/22-2031/32
-CashFlowStatementProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities6,6205,4725,8236,6098,3289,52511,68510,8019,58510,00011,34710,963 Payments-OperatingActivities(3,331)(4,881)(5,323)(5,490)(5,510)(5,577)(5,415)(5,751)(6,097)(6,210)(6,213)(6,517) NetCashProvidedby(orusedin)OperatingActivities3,2895915011,1192,8173,9486,2705,0503,4883,7905,1344,446 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment-Purchases-Infrastructure,Property,Plant&Equipment(3,972)(3,733)(1,717)(2,210)(4,237)(5,576)(8,800)(5,745)(3,235)(3,479)(4,861)(2,487) Receipts/Purchases-OtherAssets6097,929 NetCashProvidedby(orusedin)InvestingActivities(3,363)4,196(1,717)(2,210)(4,237)(5,576)(8,800)(5,745)(3,235)(3,479)(4,861)(2,487) CashFlowfromFinancingActivities Receipts-LoanBorrowings ---4,4274,427----Payments-PrincipalRepayments (77)(82)(86)(93)(100)(117)(245)(370)(395)(421)(449)(479) Payments-FinanceCosts (173)(165)(160)(154)(146)(161)(414)(638)(613)(587)(559)(529) NetCashProvidedby(orusedin)FinancingActivities(250)(247)(247)(247)(247)4,1493,768(1,008)(1,008)(1,008)(1,008)(1,008) NetIncrease/(Decrease)inCashAssetsHeld (324)4,540(1,463)(1,338)(1,666)2,5201,238(1,703)(755)(697)(734)951 CashandCashEquivalentsatBeginningofReporting Period 2,5842,2606,8005,3373,9992,3334,8536,0914,3893,6342,9372,203 CashandCashEquivalentsatEndofReportingPeriod2,2606,8005,3373,9992,3334,8536,0914,3893,6342,9372,2033,154 plusInvestmentsonHand-EndofReportingPeriod 5,822----------TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod8,0826,8005,3373,9992,3334,8536,0914,3893,6342,9372,2033,154
Federation
Sewerage

ALTERNATE SCENARIO FINANCIAL STATEMENTS – WASTE FUND CASH FLOW STATEMENT

Long Term Financial Plan 2023 - 2033 77
FederationCouncilLongTermFinancialPlan2021/22-2031/32 Waste-CashFlowStatementProjections ActualForecastProposed Budget YearEnding202220232024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s$000s CashFlowsfromOperatingActivities Receipts-OperatingActivities2,1082,1092,4412,6132,7812,8802,9543,0293,1043,1823,2623,342 Payments-OperatingActivities(2,151)(2,094)(2,439)(2,612)(2,780)(2,879)(2,954)(3,026)(3,103)(3,181)(3,261)(3,341) NetCashProvidedby(orusedin)OperatingActivities(43)152111032211 CashFlowsfromInvestingActivities Receipts-Infrastructure,Property,Plant&Equipment-Purchases-Infrastructure,Property,Plant&Equipment-Receipts/Purchases-OtherAssets-50 NetCashProvidedby(orusedin)InvestingActivities -50---------CashFlowfromFinancingActivities Receipts-LoanBorrowingsPayments-PrincipalRepayments Payments-FinanceCosts NetCashProvidedby(orusedin)FinancingActivities NetIncrease/(Decrease)inCashAssetsHeld (43)652111032211 CashandCashEquivalentsatBeginningofReporting Period 45267686970717174757778 CashandCashEquivalentsatEndofReportingPeriod26768697071717475777879 plusInvestmentsonHand-EndofReportingPeriod TotalCash,CashEquivalentsandInvestmentsatEndof ReportingPeriod26768697071717475777879

ALTERNATE SCENARIO FINANCIAL STATEMENTS – CAPITAL WORKS STATEMENT PROJECTION

FederationCouncilLongTermFinancialPlan2021/22-2031/32 CapitalWorksStatementProjections

Long Term Financial Plan 2023 - 2033 78
Proposed Budget YearEnding2024202520262027202820292030203120322033 $000s$000s$000s$000s$000s$000s$000s$000s$000s$000s SealedRoads3,9243,1403,1403,1403,1403,1403,1403,1403,1403,140 StormwaterDrainage223919451----47Sewerage1,5612,0093,8525,0698,0005,2232,9413,1634,4192,261 Water1,4951,5126765582,1872,2862,1007,7638,0628,755 Plant,machineryandequipment1,9062,0002,0002,0002,0002,0002,0002,0002,0002,000 Computersandtelecommunications307380259162368203101250250250 AdditionalCapitalWorksduetoSRV-SealedLocalRoads-6181,1971,8922,4722,5492,5102,5492,7812,761 AdditionalCapitalWorksduetoSRV-UnsealedLocalRoads-191371586766790778790862856 AdditionalCapitalWorksduetoSRV-UrbanStormwaterDrainage-161292461602621612621678673 AdditionalCapitalWorksduetoSRV-Assetmanagementandfinancialsustainabilityneeds--1501505503006001,0001,1001,300 TotalCapitalWorks 9,41610,10212,03114,06920,08517,11214,78221,27623,33921,996

APPENDIX A – FINANCIAL SUSTAINABILITY INDICATORS (PLANNED SCENARIO)

Assetmaintenanceratio>100%IP&R74.15%62.56%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00% Operatingperformance>0IP&R9.47%21.66%-8.73%-14.31%-12.64%-8.39%-5.72%-2.01%1.65%5.13%8.51%11.43%10.61%

Buildingsandinfrastructurerenewalsratio>100%IP&R0.00%76.28%321.50%87.58%88.58%39.60%32.69%128.12%133.92%123.02%454.77%472.29%512.89% Infrastructurebacklogratio<2%IP&R28.25%62.10%54.42%53.59%51.11%48.69%47.39%43.77%41.09%38.10%32.29%27.22%23.26% Assetmaintenanceratio>100%IP&R90.63%636.56%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%

Long Term Financial Plan 2023 - 2033 79
RATIOS Fund/sRatioTargetSource2021202220232024202520262027202820292030203120322033 actualactualbudgetLTFPLTFPLTFPLTFPLTFPLTFPLTFPLTFPLTFPLTFP Operatingperformance>0IP&R-10.95%-8.00%-23.27%-10.38%-12.35%-5.73%-2.00%-1.94%-1.70%-0.45%0.26%0.87%1.07% Ownsourceoperatingrevenue>60%IP&R39.09%40.64%45.99%53.86%58.32%60.62%62.33%62.36%62.66%62.96%63.26%63.55%63.85% Unrestrictedcurrentratio>1.5xIP&R2.802.882.993.022.872.932.973.023.063.273.333.383.43 Debtservicecoverratio>2xIP&R12.9011.8411.499.288.5510.7812.2018.9219.2320.2320.8721.3621.59 Ratesandannualchargesoutstandingpercentage<10%IP&R5.07%5.58%5.58%5.58%5.58%5.58%5.58%5.58%5.58%5.58%5.58%5.58%5.58% Cashexpenseratio>3monthsIP&R12.4117.010.22-1.362.232.342.172.041.942.012.943.223.43 Unrestrictedcash(effective)>$1millionInternal2,590,000-3,146,000-2,217,0002,685,8241,927,9131,949,6962,052,6042,237,0532,397,9092,602,8452,725,4792,887,2453,180,932 Internallyrestrictedreserve-waste100%Internal0.00%0.00%0.00%6.71%11.39%14.85%17.50%19.60%21.31%22.72%23.91%24.93%25.80% Capitalexpenditureratio>110%Tcorp217.26%91.55%91.42%72.72%75.61%85.14%96.66%96.90%97.65%101.20%107.25%109.39%108.93% Buildingsandinfrastructurerenewalsratio>100%IP&R156.39%86.67%83.10%66.11%68.73%77.40%87.87%88.10%88.77%92.00%97.50%99.45%99.03% Infrastructurebacklogratio<2%IP&R6.75%17.44%18.79%18.57%17.77%16.65%15.86%14.83%14.13%13.21%12.56%11.73%11.15%
Ownsourceoperatingrevenue>60%IP&R97.80%76.41%98.39%91.95%98.53%98.57%98.60%91.03%91.20%90.85%70.89%71.32%70.27% Unrestrictedcurrentratio>1.5xIP&R20.8342.0610.399.848.648.538.638.257.958.096.308.5512.71 Debtservicecoverratio>2xIP&R--43.522.502.102.602.923.434.004.595.225.362.89 Ratesandannualchargesoutstandingpercentage<10%IP&R4.43%3.58%27.91%17.31%17.31%17.31%17.31%17.31%17.31%17.31%17.31%17.31%17.31% Cashexpenseratio>3monthsIP&RNANA22.4621.4618.5118.1918.2817.6217.1217.4114.1921.8126.27 Capitalexpenditureratio>110%Tcorp22.84%328.95%353.62%96.34%97.43%43.56%35.96%140.93%147.31%135.33%500.25%519.52%564.18%
GENERAL FUND WATER FUND

Cashexpenseratio>3monthsIP&RNANA21.6611.508.374.869.9512.037.796.144.883.665.03 Capitalexpenditureratio>110%Tcorp4.34%333.50%219.46%101.24%130.30%249.83%328.77%518.87%338.76%190.75%205.15%286.61%146.65% Buildingsandinfrastructurerenewalsratio>100%IP&R0.00%77.39%199.53%92.04%118.46%227.12%298.88%471.70%307.96%173.41%186.50%260.55%133.31% Infrastructurebacklogratio<2%IP&R7.38%19.27%19.30%18.96%17.91%16.10%14.47%12.32%11.14%10.28%9.58%8.69%8.20% Assetmaintenanceratio>100%IP&R89.42%167.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%

Ratios:

Operatingperformanceratio=Totalcontinuingoperatingrevenueexcludingcapitalgrantsandcontributionslessoperatingexpenses/Totalcontinuingoperatingrevenueexcludingcapitalgrantsandcontributions

Ownsourceoperatingrevenueratio=Totalcontinuingoperatingrevenueexcludingallgrantsandcontributions/Totalcontinuingoperatingrevenue1inclusiveofallgrantsandcontributions

Unrestrictedcurrentratio=Currentassetslessallexternalrestrictions/Currentliabilitieslessspecificpurposeliabilities

Debtservicecoverratio=Operatingresultsbeforecapitalexcludinginterestanddepreciation/impairment/amortisation/Principalrepayments(fromtheStatementofCashFlows)+borrowingcosts(fromtheIncomeStatement)

Ratesandannualchargesoutstandingpercentage=Ratesandannualchargesoutstanding/Ratesandannualchargescollectable

Cashexpenseratio=(Currentyear’scashandcashequivalents+termdeposits/Paymentsfromcashflowofoperatingandfinancingactivities)x12

Unrestrictedcash(effective)=UnrestrictedcashlessFinancialAssistanceGrantsadvancepaymentlesscreditorsplusgovernmentdebtors

Internallyrestrictedreserve-waste=Internallyrestrictedwastereserve/WasteManagementLevycollectedlessfundsincurredtorehabilitateclosedlandfill/s(cumulative)

Capitalexpenditureratio=Capitalexpenditure/Depreciation

Buildingandinfrastructurerenewalsratio=Assetrenewals/Depreciation,amortisation&impairment

Infrastructurebacklogratio=Estimatedcosttobringassetstoasatisfactorycondition/TotalWrittenDownValueofinfrastructure,building,otherstructures&landimprovements

Assetmaintenanceratio=ActualAssetMaintenance/RequiredAssetMaintenance

Long Term Financial Plan 2023 - 2033 80 RATIOS Fund/sRatioTargetSource2021202220232024202520262027202820292030203120322033 actualactualbudgetLTFPLTFPLTFPLTFPLTFPLTFPLTFPLTFPLTFPLTFP Operatingperformance>0IP&R6.86%17.06%3.06%-26.89%-23.56%-19.35%-15.64%-14.13%-11.97%-6.71%-1.71%3.05%7.61% Ownsourceoperatingrevenue>60%IP&R97.32%80.60%96.14%98.41%90.51%75.67%70.69%60.72%71.36%85.43%85.50%79.45%88.40% Unrestrictedcurrentratio>1.5xIP&R8.67108.8610.595.003.491.843.984.683.132.381.841.351.93 Debtservicecoverratio>2xIP&R8.789.224.841.241.662.392.811.641.401.752.122.522.94 Ratesandannualchargesoutstandingpercentage<10%IP&R8.48%8.64%23.29%10.89%10.89%10.89%10.89%10.89%10.89%10.89%10.89%10.89%10.89%
SEWER FUND

Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.