Long Term Financial Plan 2017/2027

Page 1

2017/2027 Wagga Wagga City Council LONG TERM FINANCIAL PLAN


What is this document all about? What is the Long Term Financial Plan? The Long Term Financial Plan is a 10 year plan that outlines Council’s financial capacity to meet those objectives of the Community Strategic Plan that fall under the auspices of Council. The Long Term Financial Plan is formulated by using a number of estimates and assumptions to project the future revenue and expenditure required of Council to deliver those services and projects expected by the community. In doing so it addresses the resources that impact on Council’s ability to fund its services and capital works whilst remaining financially sustainable. The Long Term Financial Plan is one element of the resourcing strategy that ensures the community’s ideas and aspirations for the future are realistically achievable. The other elements of the resourcing strategy include the Asset Management Plan and the Workforce Plan. The Asset Management Plan aims to predict infrastructure consumption and renewal needs, as well as consider infrastructure requirements to meet future community needs. The Workforce Plan is designed to ensure that Council has the necessary staff to deliver current services and operational needs for the community now and in the future.

2

These interrelated plans give consideration to the capacity of Council to deliver on its responsibilities within the Community Strategic Plan. Each element informs the Delivery Plan which outlines the strategies in place to meet these responsibilities. Council has reviewed the previous Long Term Financial Plan and significant changes have been made to both operational and capital items in the formulation of this 2017/27 Long Term Financial Plan. Council reviews any significant changes to the Long Term Financial Plan via the Monthly Finance Report to Council. The Monthly Finance Report assesses Council’s performance against budget each month. Any ongoing changes to budget that result from this process are included in the Long Term Financial Plan and reported to Council. A comprehensive review of the Long Term Financial Plan is conducted annually during the Operational Plan process.


Table of contents ABOUT THIS PLAN. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 EXECUTIVE SUMMARY. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 FIT FOR THE FUTURE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 SPECIAL RATE VARIATION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 FINANCIAL STRATEGIES. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Financial Financial Financial Financial Financial Financial

Strategy Strategy Strategy Strategy Strategy Strategy

1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 3. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 4. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 5. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 6. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

PLANNING ASSUMPTIONS. . . . . . . . . . . . . . . . . . . . . . . . . . . 14 FINANCIAL FORECAST ASSUMPTIONS. . . . . . . . 19 SENSITIVITY ANALYSIS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 FINANCIAL SCENARIOS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Base Case Scenario. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 Asset Management Scenarios.. . . . . . . . . . . . . . . . . . . . . . . . . . 28

APPENDICES. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29

Appendix 1 Budgeted Income Statement. . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Appendix 2 Balance Sheet Forecast. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Appendix 3 Cashflow Statement Forecast.. . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Appendix 4 Financial Sustainability Indicators. . . . . . . . . . . . . . . . . . . . . . . 36 Appendix 5 Budgeted External Restrictions. . . . . . . . . . . . . . . . . . . . . . . . . . 37 Appendix 6 Budgeted Internal Restrictions. . . . . . . . . . . . . . . . . . . . . . . . . . . 38 Appendix 7 External Loan Projects and Debt Servicing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 Appendix 8 a) One-Off Capital Projects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 b) Recurrent Capital Projects.. . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 c) Capital Program Concepts List. . . . . . . . . . . . . . . . . . . . . . . 61 Appendix 9 Wagga Wagga Regional Airport Ten Year Financial Plan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 Appendix 10 Livestock Marketing Centre Ten Year Financial Plan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66

Appendix 11 Sewerage Services Ten Year Financial Plan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 Appendix 12 Solid Waste Services Ten Year Financial Plan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Appendix 13 Stormwater Levy Ten Year Financial Plan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71 Appendix 14 Budgeted Income Statement by Function. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72

CONTACT US. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

3


Our executive summary

4


The Long Term Financial Plan (LTFP) is an essential element of the resourcing strategy which details how the strategic aspirations of Council outlined in the Community Strategic Plan can be achieved in terms of time, money, assets and people. The Resourcing Strategy focuses on long term strategies in three key areas: • Financial Planning - addresses the financial resources that impact on Wagga Wagga City Council’s ability to fund its services and capital works whilst remaining financially sustainable. • Workforce Planning - ensures that Council has the staffing capacity with the required skills and experience to deliver current services and operational needs for the community now and in the future. • Asset Management Planning - aims to predict infrastructure consumption and renewal needs, as well as consider infrastructure requirements to meet future community needs. These interrelated plans give consideration to the capacity of Council to deliver its responsibilities within the Community Strategic Plan that fall under the auspices of Wagga Wagga City Council. Each element informs the Delivery Plan which outlines the strategies in place to meet these responsibilities. Wagga Wagga City Council’s Long Term Financial Plan is a 10 year financial planning document with an emphasis

on long-term financial sustainability. Financial sustainability is one of the key issues facing local government, due to several contributing factors, including growing demands for community services and facilities, constrained revenue growth and ageing infrastructure.

the budget that result from this process they are reported to Council and adjusted in the Long Term Financial Plan.

The Long Term Financial Plan is formulated, using a number of estimates and assumptions, to project the future revenue and expenditure required of Wagga Wagga City Council to deliver those services and projects expected by the community. In doing so, it addresses the resources that impact Council’s ability to fund its services and capital works whilst remaining financially sustainable.

The objectives of Wagga Wagga City Council’s Long Term Financial Plan are:

Council have reviewed the previous Long Term Financial Plan and significant changes have been made as part of this process. The draft budget for the 10 years 2017/18 to 2026/27 are balanced, and this position has been achieved with significant changes to both operational and capital budgets, including savings over the 10 year period of $11.5M for salaries, $4.6M in utility costs and $9.1M in operating savings from Council’s continuous improvement program. These changes have been necessary to assist Wagga Wagga City Council in overcoming unfavourable adjustments to revenue sources, which have included: • The 2% reduction in the forecasted future year Federal Government’s Financial Assistance Grant ($7.2M) • Reduction of the rate peg from 1.8% to 1.5% ($16.3M) • A reduction of investment income of ($2.3M) for the 10 years of the Long Term Financial Plan due to sustained lower interest rates

Long Term Financial Plan Objectives • to provide a forecast financial position over 10 years to ensure that Council remains financially sustainable • to support the implementation of Wagga View: Community Strategic Plan 2040 • to identify and highlight future challenges, issues and financial trends to ensure that they are proactively addressed • to ensure compliance with legislative requirements of integrated planning and reporting contained in the Local Government Act and the guidelines produced by the NSW Office of Local Government • continuing trend towards meeting all seven of the ‘Fit for the Future’ ratios.

Wagga Wagga City Council have also reviewed changes to the Long Term Financial Plan via the Monthly Financial Performance Report presented to Council. This report assesses Wagga Wagga City Council’s performance against budget each month. If there are any changes to WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

5


Fit for the future

6


Fit for the Future The Minister for Local Government, in response to the findings of a comprehensive three-year independent review of local government, announced the ‘Fit for the Future’ Local Government reform package. As part of this package all councils were requested by 30 June 2015 to assess their current financial situation, consider whether or not they have the appropriate scale and capacity to meet the future needs of their communities and to develop a plan to ensure they are financially sustainable in the future.

increased revenue targets of $300K from 2016/17. Wagga Wagga City Council will direct these funds towards the renewal of infrastructure and maintenance of assets which will assist in reducing the infrastructure backlog. A key consideration in Council’s decision making, as part of this improvement plan is the ongoing commitment to improving our financial position and sustainability. This includes maintaining and improving the unrestricted cash and investments result whilst achieving a balanced or preferably a surplus budget each financial year.

A Fit for the Future council is one that is: • Sustainable • Efficient • Effectively manages infrastructure and delivers services for communities • Has the scale and capacity to engage effectively across community, industry and government. In October 2015, IPART deemed Wagga Wagga City Council ‘Fit for the Future’ as a stand-alone organisation based on the actions and strategies identified in Council’s improvement proposal. The action plan outlines how Wagga Wagga City Council is committed to a number of key improvement strategies to meet five of the benchmarks and trend towards the remaining two benchmarks by 2019/20. Council’s improvement proposal can be accessed on Wagga Wagga City Council’s internet page http://www.wagga.nsw.gov.au/__data/assets/pdf_ file/0007/35917/Fit-For-the-Future-Council-ImprovementProposal.pdf The key improvement strategies to be implemented to improve Council’s financial position and sustainability as part of the 2017/27 budget process include targeted efficiency (service) reviews of $800K annually and WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

7


Special rate variation

8


Wagga Wagga City Council has been planning an upgrade to the levee system since 2007, and recently completed detailed designs for the Main City and North Wagga Levee Upgrade Project. Following extensive community consultation, Council resolved to upgrade the Main City Levee to a 1 in 100 year level of protection. The full impact of upgrading the North Wagga Levee is still to be considered in a review of the Floodplain Risk Management Study. The upgrade of the Main City Levee will ensure the protection of both residences and businesses in Central Wagga in the event of a 1 in 100 year flood. This will reduce the likelihood that the area will need to be evacuated during a flood event, which can also have an immediate social and economic impact. In some flood events the upgrade will mean that flood levels in parts of the floodplain upstream and outside of the Main City Levee will increase slightly.

drought farmers have experienced over the past decade, Council resolved to charge the Farmland rate category a lower percentage than all other rate categories: Rates Category

SRV – Levee Upgrade component

Farmland

1.9%

All other rates categories

4.1%

As the SRV is a temporary variation, at the end of the five year period, rates payable in (2021/22) will revert back to the equivalent level to that if an SRV had not occurred.

The total estimated cost of upgrading the Main City Levee to a 1 in 100 year level of protection and upgrading the North Wagga Levee to a 1 in 20 year level of protection is $23.3M*: Location

Level of Protection Estimated cost

Main City Levee System

1 in 100 year

$14,598,443

North Wagga Levee System

1 in 20 year

$8,654,863

Total Estimated Cost

$23,253,306

*The above estimated project costs are based on estimates provided by NSW Public Works. The funding ratio for the project is 2:1, with two-thirds ($15.5M) funded by Federal and State Grants and one third ($7.78M) funded by Council via a temporary Special Rate Variation (SRV) over a five year period. This SRV commenced from 1 July 2016. Due to the extensive

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

9


Our financial strategy

10


Wagga Wagga City Council is committed to operating in a financially sustainable framework, to ensure that its community and other stakeholders can rely upon the ongoing provision of a full and diverse range of high quality community services, facilities and infrastructure. Council plans to maintain its financial position and performance, to ensure resilience and a capacity to adapt and respond to arising community needs in a measured and equitable manner. The six key principles employed in Wagga Wagga City Council’s financial planning process are:

Financial Strategy 1 Financial sustainability is the ability for Council to provide the facilities, services and infrastructure that the community needs and expects over the medium to longer term.

positive unrestricted cash and investments balance. This position gives flexibility to maintain liquidity and fund any unforeseen expenditures or discretionary funding deficits. The Base Case budget detailed in the Long Term Financial Plan indicates Wagga Wagga City Council will maintain a balanced budget over the next 10 financial years. Arriving at this balanced position was a complex and challenging task with each area of the organisation having to contribute significant budget reductions and operational efficiencies to achieve this goal. These savings will have a substantial impact on the delivery of projects and services, which will require Wagga Wagga City Council to be highly innovative and efficient in delivering the Operational Plan and Delivery Plan items. Although Council has managed to arrive at balanced budgets for the next 10 financial years, it maintains a heavy reliance on Capital Grants and Contributions. The graph below details Council’s Operating Result (Surplus)/

Deficits before accounting for Capital Grants and Contributions and including Depreciation expense. Maintain Unrestricted Cash and Investments: Unrestricted cash and investments represent a measure of liquidity/ net financial position. Council’s unrestricted cash and investments allows for day to day liquidity and ensures the organisation is able to survive any budget shocks during the year – i.e. unforseen expenditure overruns and income shortfalls. Wagga Wagga City Council, as a prudent financial manager, has set a minimum level of $3.5M which should be maintained. This level ensures it retains an appropriate level of liquidity on an ongoing basis and is able to control/determine the value of its annual budget surplus or deficit. The forecasted available unrestricted cash and investments for the 10 years of the Long Term Financial Plan is maintained due to each year of the budget being balanced.

Over the past few years, Council has faced significant challenges in maintaining a stable position in previous Long Term Financial Plans. During the development of the 2014/24 Long Term Financial Plan, Wagga Wagga City Council implemented critical decision making processes adjusting its operations to ensure a more financially sustainable path. The announcement in May 2014 of the freeze on the indexation of the Financial Assistance Grant and the reduction of the rate peg in 2017/18 from 1.8% down to 1.5% has added additional pressure with remaining financially sustainable into the future. Council has again made significant budget savings for this 2017/27 Long Term Financial Plan, which demonstrates its commitment to remaining financially sustainable. Balanced Budgets: With each annual budget process Council aims at a minimum, to achieve a balanced budget which allows the organisation to maintain a WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

11


Financial Strategy 2

Financial Strategy 4

Prudent financial investment

Maintain tight control over expenditure and staff numbers, while still maintaining best value services, facilities and infrastructure

Wagga Wagga City Council will continue to carefully manage its cash reserves and investments, to ensure that appropriate financial reserves are available to meet Council’s liabilities and commitments, and manage cash flow demands to ensure responsible financial management control. While externally restricted reserves will be maintained in accordance with legislative requirements, a number of internally restricted reserves are used to ensure that funds are available to directly support the Community Strategic Plan initiatives and projects. Council will closely monitor its investment performance and publish a number of key financial indicators within its monthly and quarterly budget reviews to demonstrate its financial health and sustainability.

Financial Strategy 3 Effective utilisation of funding sources to fund capital works The Long Term Capital Works Program identifies the various funding sources proposed for each capital project. Council will utilise grant funding where available, internal reserves where applicable, and borrowings where valid. Wagga Wagga City Council as a result of being ‘deemed fit’ will also have access if approved to lower cost borrowings offered through T-Corp to fund capital works which will reduce future debt-servicing costs.

12

Wagga Wagga City Council is committed to the ongoing review of its service delivery as part of the continual improvement process. Specifically, Council is seeking to identify if the services it delivers are relevant and necessary to their community as well as appropriate in the current environment. This includes determining if the services meet the needs and expectations of the community articulated in the Community Strategic Plan. The Service Review process aims to achieve the following objectives: • Assist in informing Councillors, the community and Council’s staff on what, how and why it delivers the current list of services. It endeavours to answer questions surrounding the need to provide the service, service delivery alternatives such as contracting resources, outsourcing some activities, joint delivery with other councils, what can be provided at what cost and can any efficiencies be found. • Finding savings that are real, sustainable, and are able to be entrenched into future budgets. This strategic approach to budget management is to identify lasting solutions for the provision of services in contrast to common short term budget management strategies which include delaying the implementation of projects onto a concepts list or unfunded activities, or by making budget cuts that may not align with the Community Strategic Plan. • Continue moving the organisational culture to one of a “can do attitude & approach”. By creating an expectation of better service delivery, Council is

empowering its staff with the tools and processes to make better decisions. • Embedding the realisation of continuous improvement. In providing an environment where continuous improvement to service delivery is expected, staff are encouraged and supported to identify opportunities to make Wagga Wagga City Council services the best value for its community. • Identifying a clear set of recommendations on proposed changes following each service reviewed. These recommendations will include as a minimum consideration of options for costs and efficient service delivery which may include process, resourcing and delivery changes. A number of other initiatives have been implemented to assist in identifying budget efficiencies, which include: • Targeted savings for employee costs included in Wagga Wagga City Council’s recent organisational restructure • Controlled expenses • Review of fees and charges to ensure closer alignment with costs • Energy savings and carbon reduction initiatives • E-Business and online service initiatives • Improved information management systems and technology • Review of capital project processes, procedures and outcomes • Utilisation of allowable reserves for internal loans in preference to external borrowings where possible • Utilisation of lower cost borrowings where possible


Financial Strategy 5

Financial Strategy 6

Maintain/move towards above benchmark results against key performance indicators

Narrow the Infrastructure Funding Gap

As indicated in Wagga Wagga City Council’s Fit for the Future Criteria Results which was based on a three year average, Council did not meet three out of the seven benchmarks. The key improvement strategies to be implemented to improve our financial position and sustainability as part of the 2017/27 budget process have included targeted efficiency (service) reviews of $800K annually and increased revenue targets of $300K which was introduced as part of the 2016/17 budget process. Council will direct these funds towards the renewal of infrastructure and maintenance of assets which will assist in reducing the infrastructure backlog ratio.

Wagga Wagga City Council’s Asset Management Plan identifies a shortfall in current expenditure on the maintenance and renewal of infrastructure assets. This represents a risk to the organisation that a significant number of assets may fail due to inadequate maintenance. If this issue is not addressed it will have an adverse impact on Council’s financial position in the medium and longer term. Council is attempting to address this issue by: • Increasing recurrent levels of maintenance and renewal budgets by identifying budget savings and efficiency gains from all parts of the organisation • Maintaining a reserve for Infrastructure Replacement and allocating additional funds towards this reserve as a priority when budget improvements are realised, and allocating the proceeds from the sale of non-core assets • Increasing the use of low cost borrowings to fund infrastructure renewals through T-Corp as a result of being deemed ‘fit’ as part of Council’s Fit for the Future proposal. • Reassessing asset condition and what constitutes “satisfactory” condition.

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

13


Our planning assumptions

14


Population and Demographics The level of population increase and population demographics have a significant impact on demand for services, and are key drivers for Wagga Wagga City Council’s planning for new infrastructure and the type of infrastructure incorporated in the Long Term Financial Plan. The forthcoming census data release from the Australian Bureau of Statistics is expected to show that Wagga Wagga’s population grew to 65,000 people in 2016, representing an annual growth rate of over 1%. This strong growth trend is expected to continue into the future, with a population of around 80,000 forecast by 2036 in a baseline scenario presented by the NSW Department of Planning and Environment. Between 2016 and 2026, the population age structure forecasts for the city indicate a 15.8% increase in population under working age, a 32.3% increase in population of retirement age, and a 7.0% increase in population of working age. This profile is reflected in Wagga Wagga City Council’s 10 year capital works program, committing resources to facilities and infrastructure designed to cater for a changing demographic.

Economic Conditions and Growth Economic conditions and growth have a significant external impact to Wagga’s financial position and the Long Term Financial Plan. Some key factors include the following: • The state of financial markets (including official interest rates) • Inflation rates

• Labour force and unemployment rate • Population growth rate Interest rate fluctuations will have a direct impact on the returns earned on Council’s investment portfolio. Inflation rate fluctuations impact both income and expenditure and what products can be purchased for in real terms. When the general price level rises, each unit of currency buys fewer goods and services. Consequently, inflation reflects a reduction in the purchasing power per unit of money. Wagga Wagga has a strong and diverse economy without a reliance on a single sector, allowing the city to maintain growth and prosperity. The local economy (as measured by the Gross Regional Product statistic) grew by 3.1% to stand at $3.6 billion in the most recent data released by the ABS for 2015. The labour force is also expanding, to stand at 35,200 in the final quarter of 2016, with an unemployment rate of 4.3%. This rate is lower than the NSW average unemployment rate of 5%, and the 5.8% rate measured nationally for this quarter.

Major Projects Included in Council’s 2017/27 Long Term Financial Plan are four significant projects: Project

Estimated year(s) of construction

Estimated cost

Riverina Intermodal Freight and Logistic - Bomen Roadworks Stage 1

2016/17 + 2017/18

$35.1M

Multi Purpose Stadiums Equex and Bolton Park

2016/17, 2017/18 + 2018/19

$14.9M

Levee Bank System Upgrades

2016/17 – 2019/20

$23.3M

Eunony Bridge Road Bridge 2016/17 + 2017/18 Replacement

$10.6M

The potential uncertainties around some of Council’s planned major projects have the ability to have a significant impact on the Long Term Financial Plan, both in regards to timing and costing. While the Bomen Road works Stage 1 project has commenced, the other three major projects are still in the initiation stages.

Riverina Intermodal Freight and Logistics

The Riverina Intermodal Freight and Logistics (RIFL) hub project involves the construction of new major rail and road infrastructure and a freight terminal on 95 hectares of land north of Wagga Wagga at the Bomen Business Park. The project also includes the development of an agricultural bulk goods facility (grain terminal) and will be a key economic driver of growth in the Riverina. Stage 1 construction has commenced in 2016/17 which includes the construction of enabling roads. Stage 2 construction includes land purchases and construction of rail tracks but is currently not budgeted in the Long Term Financial Plan. The uncertainties associated with the RIFL project continue to reduce as the project matures through the project phases.

Multi Purpose Stadiums

The scope of the project is to deliver two Multi Purpose Stadiums (both sport and conference facilities), the first site located at The Exhibition Centre, consisting of a large sports building next to the existing Netball Clubhouse. The facility will provide three full sized indoor multi-purpose courts, change room amenities, office spaces, an elevated seating gallery, a function area and catering facilities. This project is currently scheduled to commence construction during 2017 with $9.1M funding allocated.

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

15


The second site which is still in the concept phase for $4.6M in 2018/19 is an expansion to the Bolton Park Stadium’s existing gymnasium building. There is funding of $150K allowed in 2016/17 to investigate options and complete a masterplan for the Bolton Park precinct which will include the Oasis facility.

Levee Bank Upgrades - Upgrades of Main City Levee and North Wagga Levees

Wagga Wagga City Council recently completed detailed designs for the Main City and North Wagga Levee Upgrade Project and following extensive community consultation has resolved to proceed with the upgrade of the Main City Levee to a 1 in 100 year level of protection. The full impact of upgrading the North Wagga Levee to a 1 in 20 year level of protection is still to be considered in a review of the Floodplain Risk Management Study. The estimated cost of upgrading the Main City Levee to a 1 in 100 year level of protection and upgrading the North Wagga Levee to a 1 in 20 year level of protection is $23.3M. The total capital cost indexed over the five year period is as follows: Project

Indexed Grant Estimated funding Cost (proposed)

Council’s one-third share

Upgrade of Main City Levee System

$14.6M

$9.7M

$4.9M

Upgrade of North Wagga Levee System

$8.7M

$5.8M

$2.9M

$23.3M

$15.5M

$7.8M

Total

16

With the commitment of Federal and State funding for the project, Council is committed to funding its one-third share of the cost from a Special Rate Variation (SRV) commencing in 2016/17 which is maintained for five years. The modelling assumes a construction period of five years but this is conditional of the timing and conditions of funding from NSW OEH.

Eunony Bridge Road Bridge Replacement

This project is for the replacement of the existing Eunony Bridge with a structure capable of catering for Heavy Mass Limit (HML) vehicles. This project is key to the implementation of the Bomen Strategic Master Plan as the replacement of the bridge will facilitate increased productivity into the Bomen Business Park by allowing operators to use larger vehicles. The budget for this project is estimated at $10.6M with construction to commence in 2016/17. Wagga Wagga City Council has been successful in securing grant funding for the project of $9.8M, with Council contributing $0.8M towards the project.

Family Day Care Wagga Wagga City Council has recently been advised by the Australian Government Department of Education and Training that its annual Community Support Program will cease after 2017/18. This program provided $200,000 a year in grant funding for the Wagga Wagga Regional Family Day Care service. To ensure the sustainability and viability of this service into the future, structural changes are currently being implemented to reduce ongoing operational costs whilst still ensuring it continues to meet the needs of the community and facilitates a high level of care and education. The operational changes that have been made for the Family Day Care service have recently come into effect in April 2017. The service under this new funding model will continue to be sustainable until 2020/21. Ongoing reviews will occur over the next 4 years to determine whether further efficiencies can be made, increased revenue raised or new funding obtained for this service to continue into the future. There is also the option that Wagga Wagga City Council may resolve to subsidise this service. If this was to occur the current Family Day Care deficits included in the Long Term Financial Plan from 2021/22 which would impact on Council’s bottom line are as follows: 2017/18

2018/19 0

2022/23 121,262

2019/20 0

2023/24 190,541

2020/21 0

2024/25 258,047

2021/22 0

2025/26 323,556

50,420 2026/27 386,741


Contributions, Grants and Donations provided by Council to the Community

Ashmont Public School Learn to swim for disadvantaged youth

Wagga Wagga City Council contributes to the community utilising a variety of methods, via contributions, donations or grant program funding, totalling over $1.4M annually. The proposed 2017/18 contributions, grants and donations are shown in the below table:

Wagga Autism Support Group annual walk

Community Donations - Section 356 Community Leases Rental Subsidy Rural Villages Leaps and Bounds Early Childhood program Community Resource Centre

872,665 20,450 649

730

Friends of the Botanic Gardens - hire of play hall

1,000

Suicide Prevention Network meeting room hire

1,150

Wagga and Riverina Orienteers - annual school championships

85 150

Breast Cancer Group Inc. (Wagga Wagga)Mothers Day Walk

85

Country Hope - Walk for Hope

85

Melanoma Institute - March Walk

85

Wagga Wagga & District Family History Society

498

North Wagga Residents Association

498

Rotary Club of Wagga Wagga Shine Awards

240

Walk 4 William

80

CSU Photography Grad Show

600

Specialist Medical Resource Foundation

620

Make A Wish Foundation

200

Henwood Park Football Club

498

Total - Community Donations - Section 356 Cultural Donations - Section 356 Eastern Riverina Arts Program Contribution

2,500

Eisteddfod Donation

3,090

Summer School for Strings

2,500

Riverina Conservatorium of Music events

4,727

Cantelina Singers

1,000

ADFAS Riverina

1,836

Total - Cultural Donations - Section 356

3,700

Ladysmith Memorial Hall Committee

498

Regional Heritage Transport Association

1,085

Over 60’s Touch Football Group

550

Wagga Wagga Show Society

9,850

Cancer Council – Biggest Morning Tea

Senior Citizens Week Contributions

2,200

Mangoplah Cookardina Eastlakes United Football and Netball Club

550

Collingullie Soldiers Memorial Hall

498

Annual Grants Program - Various

110

Community Development Grants

Tolland Public School swimming lessons for the disadvantage youth

940

Riverina Down Syndrome hire of Music Bowl

170

Salvation Army Red Shield Appeal

Cancer Council hire of Paramore Park

570

Combined Riders of Wagga Bolton Park Stadium Toy Run

115

Uranquinty Neighbourhood Centre Management Committee

Kurrajong Waratah hire of Music Bowl and Civic Theatre -Christmas Spectacular

2,200

Rotary Circus Quirkus

2,200

Rotary Club Street Banners Murrumbidgee Rotary Club Teddy Bears Picnic Legacy Civic Theatre Hire Kurrajong Waratah hire of Links Art Gallery

115 390 2,500 280

1,170

Wagga Women’s Health Centre

850

Wagga Wagga Rescue Squad

100

Miss Wagga Sponsorship Motor Neurone Disease Research Wagga Wagga The Arbonne Charitable Foundation

2000 100 80

Mini all-ympics disability Sports Event

385

EU3A

300

21,004

School of Arts Contribution

Wagga Women's Bowling Club

80

$933,954

$36,657

Scholarships Riverina Conservatorium Scholarship

2,000

Riverina Academy of Sport

4,000

Total - Scholarships

$6,000 30,000

Sustainable Environments Grants S356

7,000

Neighbourhood/Rural Village Grants

22,000

Arts & Culture Grants

25,000

Event Grants

20,000

Local Heritage Fund

16,000

Sporting and Cultural Facility Improvement Grants

30,000

Rural Hall Infrastructure Grants

25,000

Total - Annual Grants Program - Various

$175,000

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

17


Road Closures - Various ANZAC Day Parade Lake to Lagoon Fun Run

5,500 10,000

Wagga Gold Cup Chariot Race

3,000

Remembrance Day

2,000

Reserve Forces Day

1,500

Christmas Toy Run Total - Road Closures - Various

2,000 $24,000

Other New Major Events Sponsorship

100,000

Small Business (New Category)

12,500

Parkes Shire Council Event Rural Counselling Service

1,000 10,000

Committee 4 Wagga

7,500

Community S356 Program

4,238

Total - Other Total Contributions, Grants and Donations

$135,238 $1,310,849

In addition to the above $1.3M funding provided by Council to community groups and individuals, Council also currently offers community members Free Tip Days 4 times per year. The annual cost of the free tip days is currently costed at approximately $98,000 each year. This cost is in effect a fee waiver that Council’s community members receive. Council also offers Library members alternative methods to pay library book fines in December of each year, via the “Food for Fines Program”. It is currently estimated that $5,000 in fines are waived each year by Council offering this program to the community.

18


Financial forecast assumptions

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

19


Operating Revenue The below chart represents Wagga Wagga City Council’s budgeted operating revenue for the 2017/18 financial year displayed as a percentage. Total Operating Revenue Budget $109M

the 2016/17 rate peg of 1.8%. The assumed increase in rates for 2018/19 onwards is in line with rate pegging of 1.8% with an additional 1% growth factor (for residential only) in additional rateable properties for the Long Term Financial Plan. The risk that Wagga Wagga City Council may incur in relation to the amount of rates revenue forecast in the Long Term Financial Plan is that the rate peg announced annually by IPART may be below the assumed annual forecasted percentages that have been used.

Annual Charges – Domestic & Commercial Waste

Annual charges for waste are modelled at recovering a reasonable estimated cost of providing the service which includes a component for future site rehabilitation. The rate used in the base case and all scenarios is an annual increase of 3%.

Rates & Annual Charges (including Special Rate Variation) Rates

The Independent Pricing and Regulatory Tribunal (IPART) determine the rate peg based on a Local Government Cost Index, a productivity factor, as well as any other pertinent legislative and industry factors. This is to ensure that a balance is made between Wagga Wagga City Council meeting the increasing costs of delivering services and that productivity gains are shared with ratepayers. The base case scenario includes an ordinary rate increase for 2017/18 of 1.5% as announced by IPART in December 2016, with a 1% growth in rateable properties for residential only. This was a significant reduction on

20

Sewer Charges

Sewer charges are also modelled at achieving full cost recovery including a component for future site rehabilitation and depreciation consistent with Council’s Return on Investment Policy for council businesses. The rate used in the base case scenario which is included in the 2017/27 Long Term Financial Plan is: For the first 4 years - 5% increase plus a 1% residential growth factor. For the remaining 6 years - 2% increase plus a 1% residential growth factor.

Stormwater Services

The maximum amount for annual stormwater services is prescribed by legislation. This is currently $25 per residential and business property per annum, which is the amount used in the base case and all scenarios of the Long Term Financial Plan.

User Fees & Charges

The base case scenario of the Long Term Financial Plan includes a projected increase in user fees and charges generally between 3%-5%. A number of fees are prescribed by legislation and some fees are set at a level to recover the actual cost of providing the service. All fees have been reviewed in line with Wagga Wagga City Council’s fees and charges policy. The key improvement strategies to be implemented to improve our financial position and sustainability as part of Wagga Wagga City Council’s Fit for the Future improvement proposal has included increased revenue targets of $300K.

Interest & Investment Revenue

Given the relatively low cash rate it is difficult for Wagga Wagga City Council to ascertain with certainty what actual returns are likely to be over the 10 years of the plan. It is not likely that Council can continue to rely on additional investment income over the life of the Long Term Financial Plan given the current balance of the portfolio, and the reserves that are identified to be expended. The reduction in investment income and overall portfolio balance places further funding pressures on Council in the future. Wagga Wagga City Council’s investment revenue is linked to the expected balance of the portfolio over the life of the Long Term Financial Plan. For the base case scenario, the projected interest rates are: Years

Financial Year

Predicted interest rate earnings

Years 1-5

2017/18 - 2021/22

2.81% - 3.21%

Years 6-10

2022/23 - 2026/27

2.86% - 3.35%


Grants & Contributions Grants

It is assumed in the base case scenario that the current level of grant funding from the State and Federal Governments will continue. Grants are a significant source of funding for local government and as such any fluctuation in current levels is likely to have a substantial effect on the delivery of services and projects identified in the Long Term Financial Plan. 2016/17 represented the third year of the three year freeze on indexation for the Financial Assistance Grant. The freeze has had a significant impact on Council’s previous Long Term Financial Plan’s, with adjustments to population and future assumptions resulting in a further $7.2M adjustment to the 2017/27 Long Term Financial Plan’s 10 year starting point. The base case and all scenarios assume that the indexation of the Financial Assistance Grant will recommence from 1 July 2017.

Developer Contributions

Developer contributions have been projected in line with each contribution plan over the life of the Long Term Financial Plan. These plans are subject to review annually with each year of the plan updated accordingly.

Other Revenues

Other revenue includes fines, income from sale of goods as well as diesel fuel rebates and income from insurance claims and rebates. Revenue from these sources is difficult to ascertain with any certainty as they are generally influenced by factors outside of Wagga Wagga City Council’s control. As a result, for the purposes of the Long Term Financial Plan other revenue has been projected at a 3% increase from the 2016/17 financial year budget which corresponds to historical trends.

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

21


Operating Expenditure The below chart represents Wagga Wagga City Council’s budgeted operating expenses for the 2017/18 financial year, displayed as a percentage. Total Operating Expenditure- $119.8M

If rates increase substantially above the 7% then Wagga Wagga City Council will have to adjust the borrowings program as well as capital programs so that an affordable level of debt is always maintained. There is also the potential to source lower cost borrowings through T-Corp as part of Wagga Wagga City Council’s Fit for the Future proposal. All projects assumed term of loan is 10 years, other than the Multi Purpose Stadiums Projects (15 years) and Riverina Intermodal Freight Logistics Hub project (20 years).

Materials & Contracts

The cost of materials and contracts is to be maintained within existing budgets.

Employee Benefits and On Costs

Depreciation

Under the NSW Local Government Award, on average staff receive a 2.8% pay increase each year. Combining the award increase, performance based increase and the associated on costs, the budgeted employee costs increase is 4%.

Depreciation is forecast to increase by 5.5% each year of the Long Term Financial Plan. This is reflective of the new capital additions and purchases over the term of the Long Term Financial Plan. Depreciation levels are subject to ongoing review with each year of the plan.

In addition to the above, a salary cap of 2.5% was introduced in 2015/16 in the base case budget for three years of the Long Term Financial Plan, which then reverts back to the above award and salary progression system from 2018/19.

Other Expenses

Borrowing Costs

Borrowing costs have been conservatively forecast as follows: • 4% • 5% • 6% • 7% 22

-

2017/18 2018/19 to 2020/21 2021/22 to 2023/24 2024/25 to 2026/27

Insurance

It has been assumed that property insurance premiums will not increase for 2017/18 due to the removal of the Emergency Services Levy from Council’s premium. All other insurances have been incremented by 5% excluding liability insurance which factors in an increase of 7% for 2017/18. Future year increases for all insurances are 5% and 7% for liability insurance.

Other Operating Expenses

The cost of other operating expenses other than Utilities and Insurance costs are to be maintained within existing budgets. The below graph demonstrates the relationship between operating revenue and operating expenditure.

Utilities

An increase has been projected in the Long Term Financial Plan for electricity of 7% and gas and water costs of 5% per annum. Wagga Wagga City Council is actively pursuing efficient alternative sources of energy and other energy saving initiatives in order to reduce the effect of these costs where possible and these projected savings have been included in the Long Term Financial Plan.

As can be seen from the above graph, Wagga Wagga City Council’s operating expenditure including depreciation is greater than its operating income for the 10 years of the LTFP. This indicates that Council still has a long way to go to be able to fund depreciation and maintain financial sustainability.


Our sensitivity analysis

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

23


Sensitivity Analysis Although the assumptions listed in the previous section are Wagga Wagga City Council’s current informed estimate based on a range of reliable sources, Long Term Financial Plans are inherently uncertain. They contain a wide range of assumptions, including assumptions about interest rate movements and the potential effect of inflation on revenues and expenditures which are largely outside of Council’s control.

Employee Costs

Salary growth is largely subject to the NSW Local Government Award. Council has factored in a 4% annual increase in employee expenses. If the Award increases by 0.5%, the effect on the Long Term Financial Plan base case budget deficits before Capital Grants and Contributions is shown below:

The below section illustrates the financial effect on the result if certain assumptions were to change.

Rates

Rates comprise 56% of Wagga Wagga City Council’s total operating income. As stated earlier, rates are capped by the State Government and Wagga Wagga City Council can only increase rates above the rate pegging percentage if a Special Rate Variation is submitted and approved. If rates are held 0.5% p.a. below the predicted rate pegging percentage, the effect on the Long Term Financial Plan base case budget deficits before Capital Grants and Contributions is shown below:

24

Combined impact

The chart below shows the combined impact of a 0.5% unfavourable variance in our assumptions for Rates and Employee Costs:


Financial scenarios

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

25


Scenarios – Financial Modelling Base Case Scenario The commentary and analysis provided in the document to this point describe the base case model of the Long Term Financial Plan. It is this model inclusive of the previously detailed assumptions that will be recommended to Council for adoption. BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

(61,594,518)

(63,549,361)

(65,580,046)

(67,690,089)

(69,430,948)

(71,218,328)

(73,053,512)

(74,937,818)

(76,872,604)

(78,859,261)

Special Rate Variation

(1,495,484)

(1,531,293)

(1,567,996)

(1,605,615)

0

0

0

0

0

0

User Charges & Fees

(25,947,798)

(27,193,118)

(28,382,024)

(29,632,855)

(30,808,320)

(31,827,551)

(32,883,024)

(33,978,223)

(34,838,674)

(35,412,530)

Interest & Investment Revenue

(3,154,163)

(3,547,537)

(4,090,189)

(4,575,550)

(5,192,762)

(5,160,225)

(5,764,824)

(6,397,672)

(7,170,418)

(8,259,789)

Other Revenues

Revenue From Continuing Operations Rates & Annual Charges

(2,984,954)

(3,051,550)

(3,106,855)

(3,177,714)

(3,250,055)

(3,324,623)

(3,401,487)

(3,480,738)

(3,539,427)

(3,596,172)

Grants & Contributions provided for Operating Purposes

(13,910,429)

(13,727,432)

(13,931,483)

(14,191,429)

(14,501,702)

(14,715,669)

(14,987,459)

(15,265,202)

(15,548,729)

(15,838,474)

Grants & Contributions provided for Capital Purposes

(13,704,984)

(11,356,285)

(10,771,077)

(11,024,043)

(7,638,053)

(7,706,010)

(7,640,721)

(7,702,737)

(7,766,614)

(7,832,407)

(122,792,330)

(123,956,576)

(127,429,670)

(131,897,296)

(130,821,840)

(133,952,405)

(137,731,025)

(141,762,390)

(145,736,466)

(149,798,634)

42,591,754

44,062,952

45,638,415

47,451,141

49,336,308

51,296,811

53,335,662

55,455,996

57,659,612

59,947,401

3,591,092

3,842,095

3,992,143

3,746,195

3,488,574

3,266,186

2,984,178

2,701,582

2,449,694

2,498,603

Materials & Contracts

30,138,577

29,751,202

29,979,922

30,397,381

30,624,614

30,751,592

31,247,159

31,540,893

31,140,143

30,853,860

Depreciation & Amortisation

34,477,729

36,364,189

38,373,584

40,472,317

42,689,627

45,047,216

47,566,161

50,180,940

52,956,788

53,025,049

9,015,285

9,435,103

9,883,776

10,659,410

10,862,195

11,393,800

11,956,007

12,850,711

13,109,332

13,702,170

Expenses From Continuing Operations

119,814,437

123,455,541

127,867,839

132,726,443

137,001,317

141,755,604

147,089,167

152,730,123

157,315,570

160,027,083

Net Operating (Profit)/Loss

(2,977,893)

(501,035)

438,169

829,147

6,179,477

7,803,199

9,358,142

10,967,732

11,579,104

10,228,449

Revenue From Continuing Operations

Expenses From Continuing Operations Employee Benefits & On-Costs Borrowing Costs

Other Expenses

26


Base Case Scenario continued BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

Capital and Reserve Movements Capital Expenditure - Renewals

24,002,536

21,813,807

19,797,987

22,322,945

17,327,706

16,094,246

18,287,678

19,796,377

24,894,032

18,351,862

Capital Expenditure - New Projects

17,530,887

8,459,557

2,407,532

2,788,701

3,476,403

3,746,506

4,806,997

38,371

539,766

41,217

Capital Expenditure - Project Concepts

11,800,337

16,666,525

8,856,711

4,489,054

4,369,934

1,455,947

1,543,000

8,422,768

1,343,000

1,343,000

2,474,343

3,231,506

3,793,743

4,018,531

4,255,481

4,649,724

4,470,418

4,174,207

3,958,218

4,494,419

New Loan Borrowings

(7,215,980)

(6,762,097)

0

0

(750,000)

0

0

0

(4,200,000)

0

Proceeds from Sale of intangible & tangible Assets

(4,678,401)

(1,354,100)

(792,182)

(835,808)

(1,383,000)

(739,100)

(977,700)

(1,396,850)

(1,148,900)

(1,250,650)

Net Movements to/(from) Reserves

(6,458,101)

(5,189,974)

3,871,625

6,859,747

9,213,627

12,036,694

10,077,627

8,178,336

15,991,568

19,816,753

Total Capital and Reserve Movements

37,455,621

36,865,224

37,935,415

39,643,170

36,510,151

37,244,017

38,208,019

39,213,208

41,377,684

42,796,600

Net Result after Depreciation

34,477,728

36,364,189

38,373,585

40,472,317

42,689,627

45,047,216

47,566,161

50,180,940

52,956,788

53,025,049

Add back Depreciation Expense (non-cash)

34,477,729

36,364,189

38,373,584

40,472,317

42,689,627

45,047,216

47,566,161

50,180,940

52,956,788

53,025,049

Cash Budget (Surplus)/Deficit

0

0

0

0

0

0

0

0

0

0

Loan Repayments

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

27


Financial Scenarios – Asset Management Renewal Shortfalls Wagga Wagga City Council has the following five asset management plans: • Buildings • Recreational assets • Sewer • Stormwater • Transport infrastructure networks Each plan sets out the level of service Wagga Wagga City Council provides the community in relation to its assets. The plans use financial information and technical asset data, compared to service levels to identify funding shortfalls in managing the assets. In order to eliminate Wagga Wagga City Council’s renewal shortfall, funds of $63,818,936 are required as detailed in the table below. Please note that this does not include maintenance (including condition assessments), upgrades or new asset funding gaps. Asset Category Transport

$50,945,895 $8,469,799

Buildings

$3,147,096

Stormwater**

$1,174,133

Total

$82,053 $63,818,936

* one off – allocate to one year of work ** this figure only relates to pipe renewal (4.6kms) identified in the 2013 condition assessment. AMP has advised that Council need to complete another condition assessment before producing a renewal plan to accurately determine the required renewal and the potential funding shortfall.

28

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

$7,512,178 $5,336,704 $5,035,094 $4,890,960 $6,122,205 $5,516,507 $4,479,868 $4,249,475 $4,020,480 $3,782,424

Wagga Wagga City Council’s current external loan borrowings assumptions used in the Long Term Financial Plan are as follows: • 4% • 5% • 6% • 7%

-

2016/17 2018/19 2021/22 2024/25

to to to to

2017/18 2020/21 2023/24 2026/27

– – – –

10 10 10 10

year year year year

term term term term

Scenario 1 – Fund 10 year Transport only Renewal Shortfall from External Loan Borrowings If Wagga Wagga City Council was to fund the Transport renewal shortfall of $51M from external borrowings, this would result in an increase to the bottom line for debt servicing repayments of $33M as follows: 2017/18 $0

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

$926,183 $1,617,310 $2,269,378 $2,902,780 $3,734,591 $4,484,108 $5,092,779 $5,697,808 $6,270,234

Scenario 2 – Fund 10 year All Assets Renewal Shortfall from External Loan Borrowings

Shortfall

Recreational Assets

Sewer*

The Transport renewal shortfall of $50,945,895 is allocated across the 10 years of the Long Term Financial Plan as follows:

If Wagga Wagga City Council was to fund all Asset category’s renewal shortfall of $63,818,936 from external borrowings, this would result in an increase to Council’s bottom line for debt servicing repayments of $40.6M over 10 years as follows: 2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

$0 $1,084,896 $1,942,735 $2,761,515 $3,561,629 $4,568,343 $5,492,763 $6,276,337 $7,064,649 $7,820,358


Long term financial plan appendices

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

29


Appendices The following summary documents are provided as appendixes to the Long Term Financial Plan document. They provide a summary of the financial projections of Wagga Wagga City Council over the next 10 years. It is important that these documents are considered as a total package and not in isolation to gain a clear picture of Council’s budgeted financial position over the next 10 years. Appendix 1 Budgeted Income Statement Appendix 2 Balance Sheet Forecasts Appendix 3 Cash Flow Statement Forecasts Appendix 4 Financial Sustainability Indicators Appendix 5 Budgeted External Restrictions Appendix 6 Budgeted Internal Restrictions Appendix 7 External Loan Projects and Debt Servicing Appendix 8 Capital Works Program + Concepts List Appendix 9 Wagga Wagga Regional Airport Ten Year Financial Plan Appendix 10 Livestock Marketing Centre Ten Year Financial Plan

30

Appendix 11 Sewerage Services Ten Year Financial Plan Appendix 12 Solid Waste Services Ten Year Financial Plan Appendix 13 Stormwater Levy Ten Year Financial Plan Appendix 14 Budgeted Income Statement by Function


Appendix 1 - Budgeted Income Statement BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

(61,594,518)

(63,549,361)

(65,580,046)

(67,690,089)

(69,430,948)

(71,218,328)

(73,053,512)

(74,937,818)

(76,872,604)

(78,859,261)

Special Rate Variation

(1,495,484)

(1,531,293)

(1,567,996)

(1,605,615)

0

0

0

0

0

0

User Charges & Fees

(25,947,798)

(27,193,118)

(28,382,024)

(29,632,855)

(30,808,320)

(31,827,551)

(32,883,024)

(33,978,223)

(34,838,674)

(35,412,530)

Interest & Investment Revenue

(3,154,163)

(3,547,537)

(4,090,189)

(4,575,550)

(5,192,762)

(5,160,225)

(5,764,824)

(6,397,672)

(7,170,418)

(8,259,789)

Other Revenues

(2,984,954)

(3,051,550)

(3,106,855)

(3,177,714)

(3,250,055)

(3,324,623)

(3,401,487)

(3,480,738)

(3,539,427)

(3,596,172)

Grants & Contributions provided for Operating Purposes

(13,910,429)

(13,727,432)

(13,931,483)

(14,191,429)

(14,501,702)

(14,715,669)

(14,987,459)

(15,265,202)

(15,548,729)

(15,838,474)

Grants & Contributions provided for Capital Purposes

(13,704,984)

(11,356,285)

(10,771,077)

(11,024,043)

(7,638,053)

(7,706,010)

(7,640,721)

(7,702,737)

(7,766,614)

(7,832,407)

(122,792,330)

(123,956,576)

(127,429,670)

(131,897,296)

(130,821,840)

(133,952,405)

(137,731,025)

(141,762,390)

(145,736,466)

(149,798,634)

42,591,754

44,062,952

45,638,415

47,451,141

49,336,308

51,296,811

53,335,662

55,455,996

57,659,612

59,947,401

3,591,092

3,842,095

3,992,143

3,746,195

3,488,574

3,266,186

2,984,178

2,701,582

2,449,694

2,498,603

Materials & Contracts

30,138,577

29,751,202

29,979,922

30,397,381

30,624,614

30,751,592

31,247,159

31,540,893

31,140,143

30,853,860

Depreciation & Amortisation

34,477,729

36,364,189

38,373,584

40,472,317

42,689,627

45,047,216

47,566,161

50,180,940

52,956,788

53,025,049

Other Expenses

9,015,285

9,435,103

9,883,776

10,659,410

10,862,195

11,393,800

11,956,007

12,850,711

13,109,332

13,702,170

119,814,437

123,455,541

127,867,839

132,726,443

137,001,317

141,755,604

147,089,167

152,730,123

157,315,570

160,027,083

Net Operating Result (Surplus)/Deficit

(2,977,893)

(501,035)

438,169

829,147

6,179,477

7,803,199

9,358,142

10,967,732

11,579,104

10,228,449

Net Operating Result before Grants and Contributions provided for Capital Purposes

10,727,091

10,855,250

11,209,246

11,853,189

13,817,530

15,509,209

16,998,862

18,670,470

19,345,718

18,060,857

Revenue From Continuing Operations Rates & Annual Charges

Revenue From Continuing Operations

Expenses From Continuing Operations Employee Benefits & OnCosts Borrowing Costs

Expenses From Continuing Operations

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

31


Appendix 2 - Balance Sheet Forecast BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

Cash & Cash Equivalents

10,985,803

12,158,171

13,139,550

14,388,616

15,958,701

17,463,096

18,877,843

20,400,035

22,314,163

24,341,307

Investments

45,766,500

50,650,546

54,738,941

59,942,511

66,483,434

72,750,696

78,644,483

84,985,888

92,960,083

101,405,102

Receivables

12,334,877

12,435,244

12,699,004

13,025,006

12,903,249

13,116,887

13,347,918

13,588,346

13,724,042

13,794,895

Inventories

2,631,610

2,597,785

2,617,756

2,654,207

2,674,049

2,685,136

2,728,407

2,754,055

2,719,063

2,694,066

518,752

519,182

528,157

543,964

549,661

558,387

572,401

588,147

586,264

590,326

72,237,541

78,360,928

83,723,408

90,554,305

98,569,095

106,574,203

114,171,052

122,316,471

132,303,616

142,825,696

53,105,724

58,772,988

63,517,008

69,555,035

77,144,876

84,417,171

91,256,100

98,614,427

107,867,383

117,666,665

Infrastructure, Property, Plant & Equipment

1,394,646,774

1,403,868,375

1,395,764,838

1,384,057,413

1,365,158,829

1,340,669,212

1,316,763,026

1,293,442,751

1,266,113,862

1,231,574,241

Investments Accounted for using the equity method

1,865,352

1,865,352

1,865,352

1,865,352

1,865,352

1,865,352

1,865,352

1,865,352

1,865,352

1,865,352

Investment Property

3,330,000

3,330,000

3,330,000

3,330,000

3,330,000

3,330,000

3,330,000

3,330,000

3,330,000

3,330,000

Total Non-Current Assets

1,452,947,851

1,467,836,715

1,464,477,198

1,458,807,800

1,447,499,056

1,430,281,735

1,413,214,477

1,397,252,530

1,379,176,597

1,354,436,258

TOTAL ASSETS

1,525,185,391

1,546,197,643

1,548,200,606

1,549,362,106

1,546,068,151

1,536,855,938

1,527,385,529

1,519,569,001

1,511,480,213

1,497,261,954

14,427,431

13,885,020

12,466,626

12,511,375

12,150,270

11,886,047

12,369,747

12,904,886

12,799,210

12,189,464

Borrowings

3,231,506

3,793,743

4,018,531

4,255,481

4,649,724

4,470,418

4,174,207

3,958,218

4,494,419

4,718,389

Provisions

12,614,560

12,614,560

12,614,560

12,614,560

12,614,560

12,614,560

12,614,560

12,614,560

12,614,560

12,614,560

Total Current Liabilities

30,273,497

30,293,323

29,099,718

29,381,416

29,414,554

28,971,025

29,158,514

29,477,663

29,908,189

29,522,413

ASSETS Current Assets

Other Total Current Assets Non-Current Assets Investments

LIABILITIES Current Liabilities Payables

32


Appendix 2 - Balance Sheet Forecast continued BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

Non-Current Liability Borrowings

66,673,982

69,642,336

65,623,805

61,368,324

57,468,601

52,998,183

48,823,976

44,865,759

44,571,340

39,852,951

Provisions

1,578,115

1,578,115

1,578,115

1,578,115

1,578,115

1,578,115

1,578,115

1,578,115

1,578,115

1,578,115

Total Non-Current Liabilities

68,252,097

71,220,451

67,201,920

62,946,439

59,046,716

54,576,298

50,402,092

46,443,874

46,149,455

41,431,066

TOTAL LIABILITIES

98,525,594

101,513,774

96,301,638

92,327,855

88,461,270

83,547,323

79,560,606

75,921,537

76,057,644

70,953,479

1,426,659,797

1,444,683,869

1,451,898,968

1,457,034,250

1,457,606,882

1,453,308,615

1,447,824,924

1,443,647,464

1,435,422,569

1,426,308,474

Retained Earnings

853,088,135

871,112,207

878,327,307

883,462,588

884,035,219

879,736,953

874,253,261

870,075,802

861,850,907

852,736,812

Revaluation Reserves

573,571,662

573,571,662

573,571,662

573,571,662

573,571,662

573,571,662

573,571,662

573,571,662

573,571,662

573,571,662

1,426,659,797

1,444,683,869

1,451,898,969

1,457,034,250

1,457,606,881

1,453,308,615

1,447,824,923

1,443,647,464

1,435,422,569

1,426,308,474

NET ASSETS EQUITY

TOTAL EQUITY

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

33


Appendix 3 - Cash Flow Statement Forecast BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

Rates & Annual Charges

62,925,724

64,959,078

67,021,780

69,164,539

69,422,688

71,109,166

72,941,431

74,822,737

76,754,440

78,737,929

User Charges & Fees

25,560,723

27,032,622

28,233,359

29,476,018

30,666,510

31,714,222

32,765,522

33,856,030

34,758,012

35,381,674

3,135,859

3,335,480

3,933,635

4,441,538

5,040,645

4,957,528

5,569,737

6,213,086

6,972,470

8,000,366

28,845,105

25,234,359

24,725,240

25,184,952

22,322,768

22,404,903

22,615,892

22,947,723

23,294,672

23,649,726

2,092,274

2,968,482

3,007,153

3,050,768

3,190,775

3,208,140

3,282,411

3,356,242

3,438,813

3,505,073

Cash Flows from Operating Activities Receipts:

Interest & Investment Revenue Received Grants & Contributions Other Payments: Employee Benefits & On-Costs

(42,591,754) (44,062,952) (45,638,415) (47,451,141) (49,336,308) (51,296,811) (53,335,662) (55,455,996) (57,659,612) (59,947,401)

Materials & Contracts

(32,588,287) (32,945,402) (33,727,515) (34,344,622) (34,860,248) (35,352,874) (35,669,886) (35,644,362) (35,087,412) (35,295,578)

Borrowing Costs

(3,591,092)

(3,842,095)

(3,992,143)

(3,746,195)

(3,488,574)

(3,266,186)

(2,984,178)

(2,701,582)

(2,449,694)

(2,498,603)

Other

(7,792,689)

(8,175,829)

(8,586,724)

(9,323,446)

(9,486,152)

(9,976,476) (10,496,164) (11,347,073) (11,605,694) (12,198,531)

Net Cash provided/(used in) Operating Activities

35,995,862

34,503,743

34,976,369

36,452,412

33,472,105

33,501,613

34,689,102

36,046,804

38,415,995

39,334,654

39,569,451

34,364,748

19,830,333

18,774,697

16,342,447

14,252,453

16,638,983

18,363,972

6,044,689

4,495,071

4,678,401

1,354,100

792,182

835,808

1,383,000

739,100

977,700

1,396,850

1,148,900

1,250,650

Cash Flows from Investing Activities Receipts: Sale of Investment Securities Sale of Infrastructure, Property, Plant & Equipment Payments: Purchase of Investment Securities

(30,000,000) (25,000,000) (20,000,000) (20,000,000) (20,000,000) (20,000,000) (20,000,000) (20,000,000) (20,000,000) (18,000,000)

Purchase of Infrastructure, Property, Plant & Equipment

(50,995,265) (46,321,542) (29,526,710) (29,459,356) (24,745,943) (20,921,724) (24,960,779) (28,607,589) (26,633,599) (19,055,174)

Contributions Paid to Joint Ventures & Associates Net Cash provided/(used in) Investing Activities

34

(1,222,595)

(1,259,273)

(1,297,052)

(1,335,964)

(1,376,043)

(1,417,323)

(1,459,843)

(1,503,638)

(1,503,638)

(1,503,638)

(37,970,009) (36,861,967) (30,201,247) (31,184,815) (28,396,539) (27,347,494) (28,803,939) (30,350,405) (40,943,649) (32,813,091)


Appendix 3 - Cash Flow Statement Forecast continued BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

Cash Flows from Financing Activities Receipts: Proceeds from Borrowings & Advances

7,215,980

6,762,097

0

0

750,000

0

0

0

4,200,000

0

(2,474,343)

(3,231,506)

(3,793,743)

(4,018,531)

(4,255,481)

(4,649,724)

(4,470,418)

(4,174,207)

241,782

(4,494,419)

4,741,637

3,530,591

(3,793,743)

(4,018,531)

(3,505,481)

(4,649,724)

(4,470,418)

(4,174,207)

4,441,782

(4,494,419)

2,767,489

1,172,367

981,380

1,249,066

1,570,086

1,504,395

1,414,746

1,522,192

1,914,129

2,027,144

8,218,314

10,985,803

12,158,170

13,139,550

14,388,616

15,958,702

17,463,097

18,877,842

20,400,035

22,314,163

Cash & Cash Equivalents - end of the year

10,985,803

12,158,170

13,139,550

14,388,616

15,958,702

17,463,097

18,877,842

20,400,035

22,314,163

24,341,307

Cash & Cash Equivalents - end of the year

10,985,803

12,158,170

13,139,550

14,388,616

15,958,702

17,463,097

18,877,842

20,400,035

22,314,163

24,341,307

Investments - end of the year

98,872,224 109,423,535 118,255,950 129,497,547 143,628,310 157,167,867 169,900,583 183,600,315 200,827,466 219,071,767

Payments: Repayment of Borrowings & Advances Net Cash provided/(used in) in Financing Activities Net Increase/(Decrease) in Cash & Cash Equivalents

plus: Cash & Cash Equivalents - beginning of year

Cash, Cash Equivalents & Investments - end of the year

109,858,027 121,581,705 131,395,500 143,886,163 159,587,012 174,630,964 188,778,425 204,000,350 223,141,629 243,413,074

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

35


Appendix 4 - Financial Sustainability Indicators ACTUALS 2015/16 -13.90%

BUDGET 2017/18 Operating Performance Ratio

-9.83%

BUDGET 2018/19 -9.64%

BUDGET 2019/20 -9.61%

BUDGET 2020/21 -9.81%

BUDGET 2021/22 -11.22%

BUDGET 2022/23 -12.28%

BUDGET 2023/24 -13.07%

BUDGET 2024/25 -13.93%

BUDGET 2025/26 -14.02%

BUDGET 2026/27 -12.72%

Office of Local Government Benchmark >= 0.00%

69.27%

Revenue from Continuing Operations excluding Capital Grants & Contributions less Operating Expenses

(10,727,091) (10,855,250) (11,209,246) (11,853,189) (13,817,530) (15,509,209) (16,998,862) (18,670,470) (19,345,718) (18,060,857)

Revenue from Continuing Operations excluding Capital Grants & Contributions

109,087,346 112,600,291 116,658,593 120,873,253 123,183,787 126,246,395 130,090,305 134,059,653 137,969,852 141,966,226

Own Source Operating Revenue Ratio

77.51%

79.76%

80.61%

80.88%

83.08%

83.26%

83.57%

83.80%

84.00%

84.20%

Office of Local Government Benchmark >= 60.00% Revenue from Continuing Operations excluding all Grants & Contributions Revenue from Continuing Operations 3.39

95,176,917

98,872,859 102,727,110 106,681,824 108,682,085 111,530,727 115,102,846 118,794,451 122,421,123 126,127,753

122,792,330 123,956,576 127,429,670 131,897,296 130,821,840 133,952,405 137,731,025 141,762,390 145,736,466 149,798,634

Unrestricted Current Ratio

2.92

3.15

3.57

3.79

4.10

4.52

4.78

5.03

5.31

5.83

Current Assets less all External Restrictions

48,489,140

52,353,692

55,784,274

60,156,078

65,180,124

70,261,589

75,097,685

80,277,909

86,578,476

93,207,253

Current Liabilities less Specific Purpose Liabilities

16,608,727

16,624,984

15,646,228

15,877,220

15,904,393

15,540,700

15,694,441

15,956,143

16,309,174

15,992,838

4.50

4.98

Office of Local Government Benchmark >= 1.50

4.03

Debt Service Cover Ratio

4.51

4.15

4.00

4.17

4.18

4.14

5.63

5.36

Office of Local Government Benchmark >= 2.00 Operating Result before Capital excluding Interest and Depreciation Principal Repayments plus Borrowing Costs

36

27,341,730

29,351,035

31,156,481

32,365,322

32,360,671

32,804,193

33,551,477

34,212,053

36,060,764

37,462,796

6,065,435

7,073,601

7,785,886

7,764,726

7,744,055

7,915,909

7,454,596

6,875,788

6,407,912

6,993,022


Appendix 4 - Financial Sustainability Indicators continued ACTUALS 2015/16 5.91%

BUDGET 2017/18 Rates, Annual Charges, Interest & Extra Charges Outstanding Percentage

BUDGET 2018/19

6.37%

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

6.36%

6.36%

6.36%

6.36%

6.36%

6.35%

6.36%

6.36%

6.35%

4,301,224

4,436,938

4,577,885

4,724,303

4,733,524

4,855,380

4,980,496

5,108,960

5,240,866

5,376,309

67,574,951

69,748,255

71,967,845

74,273,682

74,573,349

76,388,764

78,365,465

80,395,433

82,458,683

84,577,246

56.96%

83.49%

57.25%

53.50%

33.82%

35.19%

35.44%

32.88%

32.62%

31.23%

Wagga Wagga City Council Organisational Target <= 6.00% Rates, Annual & Extra Charges Outstanding Rates, Annual & Extra Charges Collectible 31.31%

Building & Infrastructure Renewals Ratio

Office of Local Government Benchmark >= 100.00% Asset Renewals (Building & Infrastructure Assets)

17,061,875

26,423,934

19,143,590

18,900,429

12,622,130

13,876,715

14,763,021

14,470,277

15,169,525

15,341,678

Depreciation of Building and Infrastructure Assets

29,956,121

31,648,642

33,436,791

35,325,969

37,321,887

39,430,573

41,658,400

44,012,100

46,498,784

49,125,965

Appendix 5 - Budgeted External Restrictions RESERVE NAME

ESTIMATED CLOSING BALANCE 2016/17

CLOSING BALANCE 2017/18

CLOSING BALANCE 2018/19

CLOSING BALANCE 2019/20

CLOSING BALANCE 2020/21

CLOSING BALANCE 2021/22

CLOSING BALANCE 2022/23

CLOSING BALANCE 2023/24

CLOSING BALANCE 2024/25

CLOSING BALANCE 2025/26

CLOSING BALANCE 2026/27

Sewer Reserve

15,374,507

14,194,516

13,762,241

16,627,956

19,366,885

22,777,018

28,049,837

32,443,804

39,475,862

47,122,173

55,351,680

Solid Waste Reserve

11,780,049

6,902,040

8,674,523

7,349,983

9,726,697

12,812,499

16,271,818

19,426,509

17,287,059

21,493,080

26,063,933

2,601,864

3,189,069

583,775

583,775

583,775

583,775

583,775

583,775

583,775

583,775

583,775

11,737,967

8,140,371

3,252,311

2,015,657

2,417,604

2,624,744

5,088,590

7,669,761

9,195,500

11,828,763

14,501,155

S94A Developer Contributions

611,128

334,475

124,822

165,169

105,516

(54,137)

(13,790)

26,557

66,904

107,251

147,598

S94 (Old Plan 1993-2004) Developer Contributions

244,257

244,257

122,419

122,419

122,419

122,419

122,419

122,419

122,419

122,419

122,419

4,056,118

4,556,118

4,423,307

4,923,307

4,604,612

4,604,612

4,604,612

4,604,612

4,604,612

4,604,612

4,604,612

46,405,890

37,560,847

30,943,398

31,788,266

36,927,508

43,470,930

54,707,262

64,877,437

71,336,131

85,862,073

101,375,173

Stormwater Levy Reserve S94 Developer Contributions

S64 Developer Contributions (Stormwater) TOTAL

* Unexpended Grants are also classified as externally restricted funds - however these are not shown in this table WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

37


Appendix 6 - Budgeted Internal Restrictions RESERVE NAME Airport Reserve

ESTIMATED CLOSING BALANCE 2016/17

CLOSING BALANCE 2017/18

CLOSING BALANCE 2018/19

CLOSING BALANCE 2019/20

CLOSING BALANCE 2020/21

CLOSING BALANCE 2021/22

CLOSING BALANCE 2022/23

CLOSING BALANCE 2023/24

CLOSING BALANCE 2024/25

CLOSING BALANCE 2025/26

CLOSING BALANCE 2026/27

(300,017)

(686,677)

(528,892)

(474,474)

(412,987)

(802,202)

(1,050,393)

(1,528,419)

(1,912,549)

(23,811)

(400,130)

(34,490)

(55,490)

(58,990)

(62,490)

(65,990)

(69,490)

(72,990)

(76,490)

(79,990)

(83,490)

(86,990)

Ashmont Community Facility Reserve

(4,500)

(6,000)

(7,500)

(9,000)

(10,500)

(12,000)

(13,500)

(15,000)

(16,500)

(18,000)

(19,500)

Bridge Replacement Reserve

(86,667)

(186,667)

(286,667)

(386,667)

(486,667)

(586,667)

(686,667)

(786,667)

(886,667)

(986,667)

(1,086,667)

(969,958)

(969,958)

(969,958)

(969,958)

(969,958)

(969,958)

(969,958)

(969,958)

(969,958)

(969,958)

(969,958)

CCTV Reserve

(64,476)

(74,476)

(84,476)

(66,476)

(48,476)

(30,476)

(12,476)

0

0

0

0

Cemetery Perpetual Reserve

(13,521)

(138,667)

(268,046)

(401,777)

(539,979)

(682,778)

(840,693)

(1,052,052)

(1,318,671)

(1,585,291)

(1,851,911)

Cemetery Reserve

(173,734)

(335,064)

(411,774)

(604,171)

(812,567)

(1,065,598)

(1,182,950)

(1,268,632)

(1,321,263)

(839,401)

(825,321)

Civic Theatre Operating Reserve

(100,000)

(150,000)

(200,000)

(98,500)

(148,500)

(198,500)

(248,500)

(298,500)

(348,500)

(398,500)

(448,500)

Civic Theatre Technical Infrastructure Reserve

(105,450)

(155,450)

(205,450)

(255,450)

(305,450)

(355,450)

(405,450)

(455,450)

(505,450)

(555,450)

(605,450)

Civil Projects Reserve

(155,883)

(155,883)

(131,883)

(131,883)

(103,083)

(103,083)

(103,083)

(103,083)

(103,083)

(103,083)

(103,083)

(5,685)

(5,685)

(5,685)

(5,685)

(5,685)

(5,685)

(5,685)

(5,685)

(5,685)

(5,685)

(5,685)

Council Election Reserve

(181,058)

(254,153)

(326,891)

(399,262)

(161,253)

(232,854)

(304,053)

(374,838)

(135,197)

(195,117)

(255,036)

Economic Development Incentives Reserve

(19,500)

(19,500)

(19,500)

(19,500)

(19,500)

(19,500)

(19,500)

(19,500)

(19,500)

(19,500)

(19,500)

0

0

0

0

0

0

0

0

0

0

0

(3,352,639)

(3,352,639)

(3,352,639)

(3,352,639)

(3,352,639)

(3,352,639)

(3,352,639)

(3,352,639)

(3,352,639)

(3,352,639)

(3,352,639)

Estella Community Centre Reserve

(230,992)

(230,992)

(52,473)

(52,473)

(52,473)

(52,473)

(52,473)

(52,473)

(52,473)

(52,473)

(52,473)

Family Day Care Reserve

(121,002)

(244,946)

(169,632)

(95,198)

(21,792)

50,420

121,262

190,541

258,047

323,556

386,741

Fit for the Future Reserve

(2,823,284)

(5,089,009)

(5,381,416)

(5,367,454)

(5,778,342)

(6,157,361)

(5,449,006)

(4,996,534)

(4,588,684)

(4,338,612)

(4,157,020)

Generic Projects Reserve

(627,116)

(607,116)

(607,116)

(607,116)

(282,015)

104,191

156,995

156,995

156,995

156,995

156,995

Art Gallery Reserve

CBD Carparking Facilities Reserve

Community Amenities Reserve

Emergency Events Reserve Employee Leave Entitlements Gen Fund Reserve

38


Appendix 6 - Budgeted Internal Restrictions continued RESERVE NAME

ESTIMATED CLOSING BALANCE 2016/17

CLOSING BALANCE 2017/18

CLOSING BALANCE 2018/19

CLOSING BALANCE 2019/20

CLOSING BALANCE 2020/21

CLOSING BALANCE 2021/22

CLOSING BALANCE 2022/23

CLOSING BALANCE 2023/24

CLOSING BALANCE 2024/25

CLOSING BALANCE 2025/26

CLOSING BALANCE 2026/27

Glenfield Community Centre Reserve

(17,704)

(19,704)

(21,704)

(23,704)

(25,704)

(27,704)

(29,704)

(31,704)

(33,704)

(35,704)

(37,704)

Grassroots Cricket Reserve

(60,942)

(60,942)

(60,942)

(60,942)

(60,942)

(60,942)

(60,942)

(60,942)

(60,942)

(60,942)

(60,942)

(738,010)

(738,010)

(738,010)

(738,010)

(738,010)

(738,010)

(738,010)

(738,010)

(738,010)

(738,010)

(738,010)

(50,454)

(50,454)

(50,454)

(50,454)

(50,454)

(50,454)

(50,454)

(50,454)

(50,454)

(50,454)

(50,454)

Industrial Land Development Reserve

(328,851)

(328,851)

(328,851)

(328,851)

(328,851)

(328,851)

(328,851)

(328,851)

(328,851)

(328,851)

(328,851)

Information Services / E-Business Reserve

(378,713)

(128,713)

(160,856)

(439,851)

(536,696)

(491,392)

(817,935)

(1,134,323)

(1,482,556)

(1,283,631)

(1,252,962)

Infrastructure Replacement Reserve

(50,142)

(98,213)

(107,738)

(139,200)

(165,366)

(192,411)

(196,471)

(198,648)

(219,568)

(254,306)

(289,044)

Insurance Variations Reserve

(28,644)

(28,644)

(28,644)

(28,644)

(28,644)

(28,644)

(28,644)

(28,644)

(28,644)

(28,644)

(28,644)

(1,474,205)

(2,325,999)

(3,168,241)

(4,010,263)

(4,902,057)

(5,685,740)

(6,409,547)

(7,111,816)

(7,801,151)

(8,125,154)

(8,203,563)

(182)

(50,182)

(100,182)

(150,182)

(200,182)

(250,182)

(300,182)

(350,182)

(400,182)

(450,182)

(500,182)

(17,181)

(2,545)

(2,545)

(2,545)

(2,545)

(2,545)

(2,545)

(2,545)

(2,545)

(2,545)

(2,545)

(3,574,732)

(4,754,749)

(6,311,765)

(8,095,027)

(10,123,253)

(12,418,585)

(12,021,055)

(11,138,370)

(13,828,925)

(16,662,436)

(19,411,056)

Lloyd E2 Environmental Works Reserve

(101,371)

(101,371)

(101,371)

(101,371)

(101,371)

(101,371)

(101,371)

(101,371)

(101,371)

(101,371)

(101,371)

Museum Acquisitions Reserve

(39,378)

(39,378)

(39,378)

(39,378)

(39,378)

(39,378)

(39,378)

(39,378)

(39,378)

(39,378)

(39,378)

Oasis Building Renewal Reserve

(51,000)

(83,147)

(56,147)

(75,847)

(75,847)

(75,847)

(114,747)

(164,747)

(214,747)

(264,747)

(314,747)

(1,115,347)

(1,025,347)

(835,347)

(745,347)

(520,347)

(630,347)

(740,347)

(655,347)

(765,347)

(875,347)

(985,347)

(5,288)

(5,288)

(5,288)

(5,288)

(5,288)

(5,288)

(5,288)

(5,288)

(5,288)

(5,288)

(5,288)

(48,031)

0

0

0

0

0

0

0

0

0

0

(5,138,305)

(3,333,372)

(3,042,426)

(3,501,458)

(2,831,925)

(1,771,261)

(2,195,695)

(1,900,709)

(9,893)

(750,536)

(1,088,753)

Gravel Pit Restoration Reserve Gurwood Street Property Reserve

Internal Loans Reserve Lake Albert Improvements Reserve LEP Preparation Reserve Livestock Marketing Centre Reserve

Oasis Plant Reserve Parks & Recreation Projects Reserve Pedestrian River Crossing Reserve Plant Replacement Reserve

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

39


Appendix 6 - Budgeted Internal Restrictions continued RESERVE NAME

ESTIMATED CLOSING BALANCE 2016/17

CLOSING BALANCE 2017/18

CLOSING BALANCE 2018/19

CLOSING BALANCE 2019/20

CLOSING BALANCE 2020/21

CLOSING BALANCE 2021/22

CLOSING BALANCE 2022/23

CLOSING BALANCE 2023/24

CLOSING BALANCE 2024/25

CLOSING BALANCE 2025/26

CLOSING BALANCE 2026/27

Playground Equipment Replacement Reserve

(51,230)

(156,909)

(87,415)

(253,142)

(369,498)

(616,907)

(895,814)

(1,126,676)

(1,269,973)

(1,266,202)

(1,615,880)

Public Art Reserve

(10,711)

(34,379)

(34,099)

(6,316)

20,344

39,915

33,835

15,746

29,959

(34,690)

(24,897)

Robertson Oval Redevelopment Reserve

(86,697)

(86,697)

(86,697)

(86,697)

(86,697)

(86,697)

(86,697)

(86,697)

(86,697)

(86,697)

(86,697)

Senior Citizens Centre Reserve

(13,627)

(15,627)

(17,627)

(19,627)

(21,627)

(23,627)

(25,627)

(27,627)

(29,627)

(31,627)

(33,627)

Silverlite Reserve

(29,980)

(29,980)

(29,980)

(29,980)

(29,980)

(29,980)

(29,980)

(29,980)

(29,980)

(29,980)

(29,980)

Sister Cities Reserve

(35,914)

(45,914)

(55,914)

(65,914)

(75,914)

(85,914)

(95,914)

(105,914)

(115,914)

(125,914)

(135,914)

Stormwater Drainage Reserve

(173,678)

(173,678)

(144,078)

(144,078)

(144,078)

(144,078)

(144,078)

(144,078)

(144,078)

(144,078)

(144,078)

Strategic Real Property Reserve

(319,209)

(319,209)

(319,209)

(319,209)

(319,209)

(319,209)

(319,209)

(319,209)

(319,209)

(319,209)

(319,209)

(74,755)

(104,755)

(134,755)

(164,755)

(194,755)

(224,755)

(254,755)

(284,755)

(314,755)

(344,755)

(374,755)

Subdivision Tree Planting Reserve

(155,795)

(175,795)

(195,795)

(215,795)

(175,795)

(195,795)

(215,795)

(235,795)

(255,795)

(275,795)

(295,795)

Sustainable Energy Reserve

(520,442)

(485,442)

(515,442)

(547,842)

(582,834)

(610,442)

(610,442)

(610,442)

(610,442)

(610,442)

(610,442)

(50,000)

(100,000)

(150,000)

(200,000)

(250,000)

(300,000)

(350,000)

(400,000)

(450,000)

(500,000)

(550,000)

(163,087)

(163,087)

(163,087)

(163,087)

(163,087)

(163,087)

(163,087)

(163,087)

(163,087)

(163,087)

(163,087)

(24,273,575)

(27,784,752)

(30,162,973)

(34,112,974)

(36,707,846)

(40,201,630)

(41,830,486)

(42,568,226)

(45,072,919)

(47,037,127)

(51,519,327)

Street Lighting Replacement Reserve

Traffic Committee Reserve Unexpended External Loans Reserve TOTAL

40


Appendix 7 - External Loan Projects and Debt Servicing BORROW YEAR

CAPITAL PROJECT

Amount Borrowed

2016/17

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

TOTALS

General Fund Capital Projects 2011/12

2011/12

2011/12

2011/12

2011/12

Wiradjuri Boat Ramp - 6.44% - 15 years

Replace Substation Jubilee Park - 6.44% - 15 years

Replace Bridge Over Model Railway at Botanic Gardens 6.44% - 15 years

Upgrade Docker Street Pedestrian Rail Crossing 6.44% - 15 years

Upgrade Tarcutta Main Street 6.44% - 15 Years

421,603 Interest

21,710

20,350

18,616

16,986

15,203

13,298

11,268

9,163

6,781

4,341

1,718

139,433

Principal

22,363

23,723

25,457

27,087

28,870

30,774

32,805

34,910

37,292

39,732

42,355

345,367

44,073

44,073

44,073

44,073

44,073

44,073

44,073

44,073

44,073

44,073

44,073

484,801

Interest

17,199

16,122

14,748

13,457

12,044

10,535

8,927

7,259

5,372

3,439

1,361

110,461

Principal

17,716

18,794

20,167

21,459

22,871

24,380

25,988

27,656

29,543

31,476

33,554

273,605

34,915

34,915

34,915

34,915

34,915

34,915

34,915

34,915

34,915

34,915

34,915

384,066

Interest

2,730

2,559

2,341

2,136

1,912

1,673

1,417

1,152

853

546

216

17,537

Principal

2,813

2,984

3,202

3,407

3,631

3,871

4,126

4,391

4,690

4,997

5,327

43,437

5,543

5,543

5,543

5,543

5,543

5,543

5,543

5,543

5,543

5,543

5,543

60,973

Interest

20,892

19,584

17,915

16,346

14,630

12,798

10,844

8,818

6,525

4,177

1,653

134,183

Principal

21,521

22,829

24,498

26,067

27,783

29,615

31,569

33,595

35,888

38,236

40,760

332,361

42,413

42,413

42,413

42,413

42,413

42,413

42,413

42,413

42,413

42,413

42,413

466,544

Interest

15,448

14,480

13,247

12,087

10,818

9,463

8,018

6,520

4,825

3,089

1,222

99,217

Principal

15,913

16,880

18,114

19,274

20,543

21,898

23,343

24,841

26,536

28,272

30,139

245,753

31,361

31,361

31,361

31,361

31,361

31,361

31,361

31,361

31,361

31,361

31,361

344,970

334,000

51,306

400,000

300,000

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

41


Appendix 7 - External Loan Projects and Debt Servicing continued BORROW YEAR

CAPITAL PROJECT

2011/12

Upgrade Civic Theatre Sound Systems - 6.44% - 15 years

2011/12

2011/12

2012/13

2011/12

2013/14

42

Australian Carbon Trust Project - 5% - 4 years

Robertson Oval - 6.44% - 15 years

Robertson Oval - 5.42% - 10 years

Equestrian Audit Recommendations - 6.44% 15 years

Equestrian Audit Recommendations - 4.84% 5 years + 6% 5 years

Amount Borrowed

2016/17

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

TOTALS

172,000 Interest

8,857

8,302

7,595

6,930

6,202

5,425

4,597

3,738

2,766

1,771

701

56,884

Principal

9,123

9,678

10,386

11,051

11,778

12,555

13,383

14,242

15,214

16,209

17,280

140,898

17,980

17,980

17,980

17,980

17,980

17,980

17,980

17,980

17,980

17,980

17,980

197,783

Interest

2,224

377

0

0

0

0

0

0

0

0

0

2,601

Principal

38,863

20,030

0

0

0

0

0

0

0

0

0

58,893

41,087

20,407

0

0

0

0

0

0

0

0

0

61,494

Interest

172,144

161,362

147,612

134,688

120,550

105,448

89,349

72,657

53,767

34,419

13,619

1,105,614

Principal

177,324

188,106

201,856

214,780

228,918

244,021

260,119

276,811

295,701

315,049

335,849

2,738,535

Interest

7,939

6,902

5,875

4,818

3,661

2,451

1,192

0

0

0

0

32,838

Principal

17,580

18,617

19,644

20,701

21,859

23,068

30,707

0

0

0

0

152,175

374,987

374,987

374,987

374,987

374,987

374,987

381,367

349,468

349,468

349,468

349,468

4,029,163

Interest

12,873

12,067

11,039

10,072

9,015

7,886

6,682

5,433

4,021

2,574

1,018

82,681

Principal

13,261

14,067

15,095

16,062

17,119

18,248

19,452

20,701

22,113

23,560

25,116

204,794

Interest

9,835

8,639

7,466

8,146

6,701

5,169

3,545

1,824

0

0

0

51,325

Principal

22,745

23,940

25,114

24,084

25,529

27,060

28,684

28,581

0

0

0

205,737

58,714

58,714

58,714

58,364

58,364

58,364

58,364

56,539

26,134

26,134

26,134

544,537

211,909

3,343,032

200,000

250,000

250,000


Appendix 7 - External Loan Projects and Debt Servicing continued BORROW YEAR

CAPITAL PROJECT

2011/12

Develop Botanic Gardens & Zoo - 6.44% - 15 years

2012/13

2012/13

2012/13

2012/13

2012/13

Develop Botanic Gardens & Zoo - 5.42% - 10 years

Jubilee Park Amenities Building - 5.42% - 10 years

Higgins Avenue Rehabilitation (LIRS) - 5.42% - 10 years

Reinstate Road Failures (LIRS) - 5.42% - 10 years

Soccer Development City Wide Strategy (LIRS) - 5.42% - 10 years

Amount Borrowed

2016/17

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

TOTALS

97,581 Interest

5,149

4,827

4,416

4,029

3,606

3,154

2,673

2,173

1,608

1,030

407

33,072

Principal

5,304

5,627

6,038

6,425

6,848

7,299

7,781

8,280

8,845

9,424

10,046

81,918

Interest

7,939

6,902

5,875

4,818

3,661

2,451

1,192

0

0

0

0

32,838

Principal

17,580

18,617

19,644

20,701

21,859

23,068

30,707

0

0

0

0

152,175

35,973

35,973

35,973

35,973

35,973

35,973

42,352

10,454

10,454

10,454

10,454

300,003

Interest

11,909

10,353

8,813

7,228

5,491

3,677

1,788

0

0

0

0

49,258

Principal

26,370

27,926

29,466

31,051

32,788

34,601

46,061

0

0

0

0

228,262

38,279

38,279

38,279

38,279

38,279

38,279

47,848

0

0

0

0

277,520

Interest

10,917

9,490

8,078

6,625

5,033

3,371

1,639

0

0

0

0

45,153

Principal

24,172

25,599

27,011

28,463

30,056

31,718

42,222

0

0

0

0

209,241

35,089

35,089

35,089

35,089

35,089

35,089

43,861

0

0

0

0

254,393

Interest

23,381

20,326

17,302

14,190

10,780

7,220

3,510

0

0

0

0

96,709

Principal

51,773

54,828

57,852

60,963

64,373

67,934

90,433

0

0

0

0

448,155

75,154

75,154

75,154

75,154

75,154

75,154

93,942

0

0

0

0

544,865

Interest

7,145

6,212

5,288

4,337

3,294

2,206

1,073

0

0

0

0

29,555

Principal

15,822

16,755

17,680

18,631

19,673

20,761

27,636

0

0

0

0

136,957

200,000

300,000

275,000

589,000

180,000

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

43


Appendix 7 - External Loan Projects and Debt Servicing continued BORROW YEAR

CAPITAL PROJECT

2013/14

Soccer Development City Wide Strategy (LIRS) - 5.39% - 10 years

2014/15

2012/13

2013/14

2012/13

Soccer Development City Wide Strategy (LIRS) - 4.19% - 10 years

Implement Tarcutta Street Gasworks Remediation 5.42% - 10 years (transferred from RIFL)

Implement Tarcutta Street Gasworks Remediation 4.84% 5 years + 6% 5 years

New Amenities Building - Duke Kent Oval - 5.42% - 10 years

Amount Borrowed

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

TOTALS

473,500 Interest

20,596

18,345

15,973

13,576

10,809

8,033

5,117

2,021

0

0

0

94,469

Principal

40,956

43,207

45,579

47,976

50,743

53,519

56,435

59,531

0

0

0

397,946

Interest

13,337

12,023

10,684

9,279

7,767

6,246

4,577

2,898

1,145

0

0

67,956

Principal

30,950

32,263

33,602

35,008

36,520

38,041

39,710

41,389

43,142

0

0

330,625

128,806

128,806

128,806

128,806

128,806

128,806

134,548

105,839

44,287

0

0

1,057,509

Interest

30,169

26,227

22,325

18,310

13,910

9,316

4,528

0

0

0

0

124,786

Principal

66,803

70,745

74,647

78,662

83,063

87,657

116,687

0

0

0

0

578,265

Interest

73,354

64,437

55,682

60,755

49,977

38,553

26,443

13,607

0

0

0

382,807

Principal

169,640

178,557

187,312

179,627

190,405

201,829

213,939

213,169

0

0

0

1,534,479

339,966

339,966

339,966

337,355

337,355

337,355

361,598

226,776

0

0

0

2,620,336

873

759

646

530

403

270

131

0

0

0

0

3,612

1,934

2,048

2,161

2,277

2,404

2,537

3,378

0

0

0

0

16,739

360,155

760,000

1,864,610

22,000 Interest Principal

44

2016/17


Appendix 7 - External Loan Projects and Debt Servicing continued BORROW YEAR

CAPITAL PROJECT

2013/14

New Amenities Building - Duke Kent Oval - 4.84% 5 years + 6% 5 years

2012/13

2012/13

2017/18

2018/19

2013/14

Multi Purpose Stadium Facilities - 5.42% - 10 years

Multi Purpose Stadium Facilities - 5.42% - 10 years

Equex Multi Purpose Stadium Facility - 5% - 15 years

Bolton Park Multi Purpose Stadium Facility - 5% - 15 years

Oasis Energy Co-Generation Project - 4 years

Amount Borrowed

2016/17

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

TOTALS

31,680 Interest

1,246

1,095

946

1,032

849

655

449

231

0

0

0

6,503

Principal

2,882

3,033

3,182

3,051

3,234

3,428

3,634

3,621

0

0

0

26,066

6,935

6,935

6,935

6,890

6,890

6,890

7,592

3,852

0

0

0

52,920

Interest

2,421

2,105

1,792

1,470

1,116

748

363

0

0

0

0

10,016

Principal

5,362

5,678

5,991

6,314

6,667

7,036

9,366

0

0

0

0

46,413

Interest

3,970

3,451

2,938

2,409

1,830

1,226

596

0

0

0

0

16,419

Principal

8,790

9,309

9,822

10,350

10,929

11,534

15,354

0

0

0

0

76,087

Interest

0

0

166,401

158,690

150,593

142,091

133,164

123,791

113,949

103,615

92,764

1,185,056

Principal

0

0

154,228

161,940

170,036

178,538

187,465

196,838

206,680

217,014

227,865

1,700,606

Interest

0

0

0

210,597

200,837

190,590

179,830

168,532

156,669

144,213

131,135

1,382,404

Principal

0

0

0

195,191

204,950

215,198

225,958

237,256

249,119

261,575

274,653

1,863,899

20,543

20,543

341,172

746,960

746,960

746,960

752,096

726,417

726,417

726,417

726,417

6,280,902

234

0

0

0

0

0

0

0

0

0

0

234

18,782

0

0

0

0

0

0

0

0

0

0

18,782

19,016

0

0

0

0

0

0

0

0

0

0

19,016

61,000

100,000

3,328,021

4,211,940

200,912 Interest Principal

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

45


Appendix 7 - External Loan Projects and Debt Servicing continued BORROW YEAR

CAPITAL PROJECT

2013/14

Equestrian Audit Recommendations - 4.84% 5 years + 6% - 5 years

2013/14

RRL Headquarters - $12K per year for 10 years

Amount Borrowed

2013/14

2014/15

2013/14

2013/14

46

Implement Animal Shelter Expansion (LIRS) - 4.19% - 10 years

City Levee Project - 4.84% - 5 years + 6% - 5 years

Rehabilitation Lakeside Drive (LIRS) - 5.39% - 10 years

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

TOTALS

100,000 Interest

3,934

3,456

2,986

3,258

2,680

2,068

1,418

730

0

0

0

20,530

Principal

9,098

9,576

10,046

9,633

10,212

10,824

11,474

11,432

0

0

0

82,295

13,032

13,032

13,032

12,892

12,892

12,892

12,892

12,162

0

0

0

102,825

12,000

12,000

12,000

12,000

12,000

12,000

12,000

12,000

0

0

0

96,000

12,000

12,000

12,000

12,000

12,000

12,000

12,000

12,000

0

0

0

96,000

Interest

5,127

4,567

3,976

3,380

2,691

2,000

1,274

503

0

0

0

23,517

Principal

10,195

10,756

11,346

11,943

12,632

13,323

14,049

14,819

0

0

0

99,062

Interest

20,076

18,098

16,083

13,968

11,691

9,401

6,890

4,362

1,724

0

0

102,292

Principal

46,588

48,565

50,581

52,696

54,973

57,262

59,774

62,302

64,940

0

0

497,680

81,986

81,986

81,986

81,986

81,986

81,986

81,986

81,986

66,664

0

0

722,550

Interest

7,858

6,903

5,965

6,508

5,354

4,130

2,833

1,458

0

0

0

41,009

Principal

18,173

19,128

20,066

19,243

20,398

21,621

22,919

22,836

0

0

0

164,384

26,031

26,031

26,031

25,751

25,751

25,751

25,751

24,294

0

0

0

205,393

Interest

22,776

20,287

17,665

15,014

11,953

8,883

5,658

2,235

0

0

0

104,471

Principal

45,292

47,781

50,404

53,055

56,116

59,185

62,410

65,834

0

0

0

440,077

120,000 Principal

Implement Animal Shelter Expansion (LIRS) - 5.39% - 10 years

2016/17

117,870

542,130

199,750

523,630


Appendix 7 - External Loan Projects and Debt Servicing continued BORROW YEAR

CAPITAL PROJECT

2014/15

Rehabilitation Lakeside Drive (LIRS) - 4.19% - 10 years

2016/17

2017/18

2016/17

2021/22

2017/18

RIFL Stage 1 - 3.25% - 20 years

RIFL Stage 1 - 3.25% - 20 years

Lawn Cemetery Master Plan Works - 4% - 10 years

Lawn Cemetery Master Plan Works - 6% - 10 years

Footpath Construction Program - 4% - 10 years

Amount Borrowed

2016/17

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

TOTALS

112,370 Interest

4,161

3,751

3,334

2,895

2,423

1,949

1,428

904

357

0

0

21,203

Principal

9,656

10,066

10,484

10,923

11,394

11,869

12,390

12,914

13,460

0

0

103,157

81,886

81,886

81,886

81,886

81,886

81,886

81,886

81,886

13,818

0

0

668,907

Interest

0

50,047

48,232

46,357

44,422

42,423

40,360

38,229

36,029

33,758

31,413

411,270

Principal

0

55,867

57,682

59,557

61,493

63,491

65,555

67,685

69,885

72,156

74,501

647,871

Interest

0

0

94,769

91,331

87,781

84,116

80,332

76,424

72,390

68,225

63,924

719,293

Principal

0

0

105,788

109,227

112,776

116,442

120,226

124,133

128,168

132,333

136,634

1,085,728

0

105,914

306,472

306,472

306,472

306,472

306,472

306,472

306,472

306,472

306,472

2,864,162

Interest

0

7,687

7,046

6,381

5,688

4,968

4,219

3,440

2,630

1,787

911

44,757

Principal

0

16,006

16,646

17,312

18,004

18,724

19,473

20,252

21,062

21,905

21,870

191,254

Interest

0

0

0

0

0

0

45,000

41,586

37,967

34,131

30,065

188,749

Principal

0

0

0

0

0

0

56,901

60,315

63,934

67,770

71,836

320,756

0

23,692

23,692

23,692

23,692

23,692

125,593

125,593

125,593

125,593

124,682

745,516

Interest

0

0

40,000

36,668

33,203

29,600

25,852

21,955

17,901

13,686

9,302

228,167

Principal

0

0

83,291

86,623

90,087

93,691

97,439

101,336

105,390

109,605

113,989

881,451

0

0

123,291

123,291

123,291

123,291

123,291

123,291

123,291

123,291

123,291

1,109,619

1,539,922

2,915,980

192,165

750,000

1,000,000

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

47


Appendix 7 - External Loan Projects and Debt Servicing continued BORROW YEAR

CAPITAL PROJECT

2018/19

Construct Estella Community Centre - 5% - 10 years

2018/19

2018/19

Jubilee Park Synthetic Hockey Fields Replace - 5% - 10 years

Exhibition Centre Kooringal Road Exit - 5% - 10 years

TOTAL GENERAL DEBT SERVICING

Amount Borrowed

2016/17

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

TOTALS

100,000 Interest

0

0

0

5,000

4,602

4,185

3,747

3,287

2,803

2,296

1,763

27,684

Principal

0

0

0

7,950

8,348

8,765

9,204

9,664

10,147

10,654

11,187

75,920

0

0

0

12,950

12,950

12,950

12,950

12,950

12,950

12,950

12,950

103,604

Interest

0

0

0

11,250

10,356

9,416

8,430

7,395

6,308

5,166

3,968

62,289

Principal

0

0

0

17,889

18,783

19,722

20,708

21,744

22,831

23,972

25,171

170,820

0

0

0

29,139

29,139

29,139

29,139

29,139

29,139

29,139

29,139

233,108

Interest

0

0

0

88,758

81,701

74,292

66,512

58,343

49,765

40,759

31,303

491,432

Principal

0

0

0

141,133

148,190

155,599

163,379

171,548

180,126

189,132

198,588

1,347,695

0

0

0

229,891

229,891

229,891

229,891

229,891

229,891

229,891

229,891

1,839,128

Interest

568,426

572,094

813,668

1,074,309

975,237

871,382

806,862

690,667

586,156

503,021

418,461

7,880,284

Principal

997,342

1,083,584

1,466,081

1,879,782

1,978,854

2,082,709

2,334,842

2,004,626

1,654,706

1,613,073

1,696,722

18,792,322

1,565,769

1,655,678

2,279,749

2,954,091

2,954,091

2,954,091

3,141,704

2,695,294

2,240,862

2,116,094

2,115,183

26,672,606

Interest

191,487

173,457

154,800

136,257

113,620

90,565

65,868

39,269

11,208

0

0

976,531

Principal

245,818

263,848

282,505

301,048

323,685

346,740

371,437

398,036

316,770

0

0

2,849,887

437,305

437,305

437,305

437,305

437,305

437,305

437,305

437,305

327,979

0

0

3,826,418

225,000

1,775,157

28,203,222

Airport Masterplan Projects 2009/10

48

Airport Pavement Upgrade 6.94% - 10 years (refinanced in 2014/15)

3,133,340


Appendix 7 - External Loan Projects and Debt Servicing continued BORROW YEAR

CAPITAL PROJECT

2011/12

Develop Precinct 2A - 6.44% 15 years

2016/17

2017/18

2018/19

2025/26

Airport Masterplan - 4% - 10 years

Airport Masterplan - 4% - 10 years

Airport Masterplan - 5% - 10 years

Airport Masterplan - 7% - 10 years

TOTAL AIRPORT DEBT SERVICING

Amount Borrowed

2016/17

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

TOTALS

6,015,614 Interest

309,765

290,363

265,621

242,364

216,923

189,747

160,779

130,742

96,751

61,935

24,507

1,989,496

Principal

319,085

338,487

363,229

386,486

411,927

439,102

468,071

498,108

532,099

566,915

604,343

4,927,853

628,850

628,850

628,850

628,850

628,850

628,850

628,850

628,850

628,850

628,850

628,850

6,917,349

Interest

0

32,280

29,591

26,795

23,887

20,863

17,718

14,446

11,044

7,506

3,827

187,958

Principal

0

67,216

69,904

72,701

75,609

78,633

81,778

85,049

88,451

91,989

91,842

803,173

0

99,496

99,496

99,496

99,496

99,496

99,496

99,496

99,496

99,496

95,669

991,131

Interest

0

0

132,000

121,006

109,571

97,680

85,313

72,451

59,074

45,163

30,695

752,953

Principal

0

0

274,860

285,855

297,289

309,180

321,547

334,409

347,786

361,697

376,165

2,908,788

0

0

406,860

406,860

406,860

406,860

406,860

406,860

406,860

406,860

406,860

3,661,741

Interest

0

0

0

22,500

20,711

18,833

16,861

14,790

12,615

10,332

7,935

124,577

Principal

0

0

0

35,777

37,566

39,444

41,416

43,487

45,662

47,945

50,342

341,639

0

0

0

58,277

58,277

58,277

58,277

58,277

58,277

58,277

58,277

466,216

Interest

0

0

0

0

0

0

0

0

0

0

294,000

294,000

Principal

0

0

0

0

0

0

0

0

0

0

303,986

303,986

0

0

0

0

0

0

0

0

0

0

597,986

597,986

Interest

501,252

496,100

582,012

548,921

484,713

417,688

346,538

271,698

190,693

124,936

360,964

4,325,515

Principal

564,903

669,550

990,498

1,081,867

1,146,075

1,213,100

1,284,250

1,359,090

1,330,768

1,068,547

1,426,678

12,135,326

1,066,155

1,165,651

1,572,511

1,630,788

1,630,788

1,630,788

1,630,788

1,630,788

1,521,462

1,193,483

1,787,642

16,460,841

807,000

3,300,000

450,000

4,200,000

17,905,954

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

49


Appendix 7 - External Loan Projects and Debt Servicing continued BORROW YEAR

CAPITAL PROJECT

Amount Borrowed

2016/17

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

TOTALS

Stormwater Levy Projects 2011/12

Remediate Wollundry Lagoon 6.44% - 15 years

1,005,000 Interest

51,751

48,510

44,376

40,491

36,240

31,700

26,861

21,842

16,164

10,347

4,094

332,376

Principal

53,308

56,549

60,683

64,568

68,819

73,359

78,198

83,217

88,895

94,712

100,965

823,273

105,059

105,059

105,059

105,059

105,059

105,059

105,059

105,059

105,059

105,059

105,059

1,155,648

2,365,447

2,319,305

2,269,721

2,216,438

2,159,180

2,097,651

2,031,531

1,960,479

1,884,127

1,802,078

1,713,909

22,819,866

618,517

664,659

714,243

767,526

824,784

886,313

952,433

1,023,485

1,099,837

1,181,886

1,270,055

10,003,738

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

32,823,604

2,365,447

2,319,305

2,269,721

2,216,438

2,159,180

2,097,651

2,031,531

1,960,479

1,884,127

1,802,078

1,713,909

22,819,866

618,517

664,659

714,243

767,526

824,784

886,313

952,433

1,023,485

1,099,837

1,181,886

1,270,055

10,003,738

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

2,983,964

32,823,604

Interest

3,486,876

3,436,009

3,709,777

3,880,159

3,655,370

3,418,421

3,211,791

2,944,687

2,677,140

2,440,382

2,497,428

35,358,041

Principal

2,234,071

2,474,343

3,231,506

3,793,743

4,018,531

4,255,481

4,649,724

4,470,418

4,174,207

3,958,218

4,494,419

41,754,658

5,720,946

5,910,352

6,941,283

7,673,902

7,673,902

7,673,902

7,861,515

7,415,104

6,851,347

6,398,600

6,991,847

77,112,699

TOTAL STORMWATER LEVY DEBT SERVICING Sewer Fund Projects 2007/08

Sewer 2010 - 7.1% - 30 years

36,000,000 Interest Principal

TOTAL SEWER DEBT SERVICING Total Debt Servicing Costs TOTAL SEWER DEBT SERVICING

36,000,000 Interest Principal

TOTAL CONSOLIDATED DEBT SERVICING

50

83,114,176


Appendix 8a - One-Off Capital Projects 2017/18 - 2026/27 Ref

Project Title

Funding Source

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

Financial Sector 1

Northern Wagga (Estella/Boorooma) Suburban Playground

2

Estella Sportsground Land Acquisition & Development (Acquisition 17/18 S94* OS22, Development 18/19 - OS4)

1,500,000

3

Land Adjacent Estella Sportsground Acquisition (OS28)

S94*

1,500,000

4

Estella - Neighbourhood Open Space S94* Works

31,816

5

Upgrade Jubilee Park Clubhouse Ground Level Changeroom - S94 Plan - Lloyd Community Centre C2

S94*

6

Jubilee Park - Replace existing synthetic surfaces at the Jubilee Park Hockey Complex

Hockey Association Contribution $200,000 + Infrastructure Reserve $200,000 + Borrowings $225,000

7

Construction of Ashmont Neighbourhood Park OS7 - (Kokoda Park + Graham Park)

S94A*

8

Replace Softfall - Botanic Gardens Adventure Playground

GPR

9

Riverside - Continuation of Shared Path Network

GPR $52K + Pedestrian River Crossing Reserve $48K

10

Exhibition Centre - Kooringal Road Exit

Borrowings (GPR Future Years Loan Repayments)

S94*

Total Capital Works - Financial Sector

150,000 1,100,000

200,000

100,000

625,000

100,000 84,840 100,000

1,775,157 300,000

5,431,973

1,334,840

200,000

0

0

0

0

0

0

Community Sector 11

Narrung Street Wetlands Contribution Marrambidya Wetland Enhancements

30,000

12

Connecting - Exhibition Centre & Bolton Pk

79,200

Public Art Reserve

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

51


Appendix 8a - One-Off Capital Projects 2017/18 - 2026/27 continued Ref

Project Title

Disability Inclusion Access Plan 13 Implementation - Art Gallery and Museum Access Upgrades 14

Civic Theatre Auditorium & Foyer Refurbishment

Funding Source S94* Civic Building Recoupment S94* Civic Theatre Recoupment $642K + Grant Funding $45K

Total Capital Works - Community Sector

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

37,800

687,317 834,317

0

0

0

0

0

0

0

0

Commercial Operations Sector 15

Lawn Cemetery Master Plan Stage 2A Works

Borrowings (Cemetery Capital Reserve Future Years Loan Repayments)

16

Wagga Wagga Lawn Cemetery & Crematorium Office Refurbishment

Cemetery Capital Reserve

17

Wagga Wagga Lawn Cemetery & Crematorium Furnace Reline

Cemetery Capital Reserve

18

Sewer - Pump Station - SPS03 Simmons Street - New Assets

Sewer Reserve

19

Sewer - SPS04 Bolton Park - New Assets

Sewer Reserve

80,000

20

Sewer - Pump Station - SPS02 Forsyth Street - Renewals

Sewer Reserve

600,000

21

Sewer - Pump Station - SPS06 Shaw Sewer Reserve Street - Renewals

22

Sewer - Pump Station - SPS09 Cartwrights Hill - Renewals

Sewer Reserve

23

Sewer - Pump Station - SPS17 Cleardale - Renewals

Sewer Reserve

24

Sewer - Pump Station - SPS18 Industrial - Renewals

Sewer Reserve

Sewer - Pump Station - SPS22 25 Elizabeth Avenue, Forest Hill - New Assets

Sewer Reserve

1,032,585

Sewer - Pump Station - SPS23 Ashmont - New Assets

Sewer Reserve

100,000

26

52

750,000

500,000 100,000 420,000 550,000

280,000 250,000 300,000 300,000

1,237,543

822,870

0


Appendix 8a - One-Off Capital Projects 2017/18 - 2026/27 continued Ref

Project Title

Funding Source

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

27

Sewer - Pump Station - SPS24 Lakehaven West - New Assets

Sewer Reserve

28

Sewer - Pump Station - SPS29 Gobba - New Assets

Sewer Reserve

29

Sewer - Pump Station - SPS30 Bomen - New Assets

Sewer Reserve

30

Sewer - Pump Station - SPS31 Uranquinty - New Assets

Sewer Reserve

56,743

31

Sewer - Pump Station - SPS39 Copland Street - New Assets

Sewer Reserve

414,910

32

Sewer - Pump Station - SPS41 Glenfield East - New Assets

Sewer Reserve

33

Sewer - Pump Station - SPS49 Springvale - New Assets

Sewer Reserve

34

Sewer Treatment Works - Forest Hill Plant - New Assets

Sewer Reserve

35

Sewer - Pump Station - SPS31 Uranquinty - Renewals

Sewer Reserve

36

Sewer Treatment Works - Collingullie Villages - Renewals

Sewer Reserve

37

Sewer - Pump Station - SPS 08 Boorooma - Increase Pump Capacity

Sewer Reserve

76,689

Sewer - Pump Station - SPS 08 38 Boorooma - Emergency/Wet Weather Sewer Reserve Detention STG

254,414

Sewer - Pump Station - SPS01 + 39 SPS02 Sewer Rising Main Network Diversion 40

Sewer Reserve

2024/25

2025/26

2026/27

61,421 286,242 1,816,072

1,810,893

1,076,386 15,352

100,000

581,105

1,118,677 520,000 40,781

801,984

Sewer - Ashmont SPS, Rising Main & Sewer Reserve Gravity Main Upgrade

41 Install Sewer Network Extensions

2023/24

654,671

Sewer Reserve

1,224,096

42

Wollundry Lagoon Levee Bank and Pump Out from theatre

S94* Civic Building Recoupment

200,000

43

Upgrade Airconditioning - Civic Centre

S94* Civic Building Recoupment

500,000

500,000

250,000

250,000

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

53


Appendix 8a - One-Off Capital Projects 2017/18 - 2026/27 continued Ref

Project Title

Funding Source

2017/18

44

Civic Building Energy Efficiency Project - Civic Building Solar Panels

Sustainable Energy Reserve

45

Buildings - Civic Theatre - AirConditioning Upgrade

Civic Theatre Operating Reserve

46

Civic Centre Southern Lift Control Upgrade

GPR

102,000

47

Accessible Adult Changeroom Stage 1

GPR

171,993

48

Accessible Adult Changeroom Stage 2

GPR

2019/20

2020/21

6,331,730

51 New Footpaths

GPR $100K + Borrowings $1M

1,100,000

52 Eunony Bridge Replacement

Grant + GPR

2,330,493

Special Rate Variation (SRV) $6.22M + Grant $12.73M

4,418,675

4,639,609

4,871,590

5,115,169

19,157,753

8,418,823

6,527,460

8,500,734

Total Capital Works - Commercial Operations Sector

2023/24

3,152,684

1,167,005

2,237,347

Commercial Development Sector 54 GWMC - Road Rehabilitation

Solid Waste Reserve

GWMC - Purchase of Large 55 Cardboard Compactor

Solid Waste Reserve

250,000

56 GWMC - Additional Leachate Pond

Solid Waste Reserve

1,500,000

57

GWMC - Progressive Site Rehabilitation

300,000

Solid Waste Reserve

230,000

58 LMC - Layback Kerb to Cattle Load in LMC Reserve

16,995

59 LMC - Landscaping

70,000

54

LMC Reserve

2024/25

2025/26

2026/27

191,891

2017/18 - Borrowings $2.92M (GPR + S94A Riverina Intermodal Freight & Logistics 50 $500K - Future Years Hub Loan Repayments) + Sale of Land $3.42M

Upgrade Main City (1 in 100) + North Wagga (1 in 20) Levee Systems

2022/23

303,000

27,220

53

2021/22

125,000

GPR $13,610 + Grant $13,610

49 Lake Albert Hall Accessible Ramp

2018/19

0

500,000

0


Appendix 8a - One-Off Capital Projects 2017/18 - 2026/27 continued Ref

Project Title

Funding Source

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

60 LMC install new fan draft for receivals LMC Reserve

45,320

61 LMC CCTV & security (partial)

LMC Reserve

33,990

62 LMC new sheep drafts

LMC Reserve

63 LMC new cow draft and selling pens

LMC Reserve

64 LMC new sheep stacking pens

LMC Reserve

83,467

65 LMC new sheep delivery pens

LMC Reserve

2,274,496

LMC Light Vehicle Traffic Management

LMC Reserve

1,307,660

LMC Reserve

2,086,693

66

67 LMC new circulating road (partial)

69 Airport Acquisition

Borrowings (Airport Reserve - Future Years Loan Repayments)

1,300,000

70 Airport - Reseal roads/line marking

Airport Reserve

100,000

71 Airport - Taxiway C shoulders

Airport Reserve

55,000

72 Airport - Bays 1-3 concrete pads

Airport Reserve

45,000

Airport Reserve

100,000

74 Airport - Bay 6 reconstruct

Borrowings (Airport Reserve - Future Years Loan Repayments)

450,000

75 Airport - Terminal Refresh

Airport Reserve

Airport - Car park reseal (southern section)

76

Airport - Taxiways A, B, D, E, F enrichment

Airport Reserve

77

Airport - Car park system replacement

Airport Reserve

Airport - Runway 05/23 and Taxiway C overlay

Airport Reserve $2.8M + Borrowings $4.2M (Airport Reserve Future Years Loan Repayments)

78

2026/27

461,298

2,000,000

73

2025/26

41,734

Borrowings (Airport Airport - Redevelop terminal - Internal Reserve - Future Years Baggage Claim and Retail Section Loan Repayments)

68

2024/25

75,000 220,000 200,000

7,000,000

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

55


Appendix 8a - One-Off Capital Projects 2017/18 - 2026/27 continued Ref

Project Title

Funding Source

Electrical motors for the roller doors at 79 GPR the Depot workshop

2017/18

2018/19

2019/20

2020/21

Oasis Building Renewal Reserve

81 Oasis - Diving Board Replacements

Oasis Building Renewal Reserve

82 Oasis - Filter Sand for All Pools

Oasis Plant Reserve

Oasis - Chemical Controller Equipment (All Pools)

Oasis Plant Reserve

130,000

Oasis Plant Reserve

145,000 60,000

84 Oasis - Circulation pumps (All Pools) 85

Oasis - Chlorine & Acid pumps (All Pools)

Oasis Plant Reserve

86

Oasis - Pool Heating Systems (All Pools)

Oasis Plant Reserve

87 Oasis - 25m Pool Dive Starting Blocks

Oasis Building Renewal Reserve

2023/24

2024/25

2025/26

2026/27

111,100 30,300 195,000

200,000 17,853

Total Capital Works - Commercial Development Sector

20,642,370

6,156,500

5,654,890

5,700,169

75,000

3,039,261

3,931,087

200,000

7,000,000

0

TOTAL LTFP CAPITAL PROGRAM

25,827,328 14,675,796

8,092,600

9,035,734

3,227,684

4,206,266

6,168,434

200,000

7,500,000

0

* Timing of project is subject to receipt of sufficient Section 94, Section 94A and DSP funds

56

2022/23

35,000

80 Oasis Pool Joint Replacement

83

2021/22


Appendix 8b - Recurrent Capital Projects 2017/18 - 2026/27 Ref

Project Title

Funding Source

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

Financial Sector 1

2

3

4

5

6

Implement Sportsgrounds Lighting Program Anderson Oval (Mt Austin)

GPR $180,000 + Contributions $144,500

Implement Sportsgrounds Lighting Program - Frenchs Field (Mt Austin)

GPR $180,000 + Contributions $122,500

Implement Sportsgrounds Lighting Program - Harris Park (Mt Austin)

GPR $180,000 + Contributions $282,000

462,000

Implement Sportsgrounds Lighting Program - McPherson Oval (Nth Wagga)

GPR $180,000 + Contributions $177,000

357,000

Implement Sportsgrounds Lighting Program Estella

GPR $180,000 + Contributions $150,000

Implement Sportsgrounds Lighting Program Jack Misson Oval (Ashmont)

GPR $180,000 + Contributions $144,500

7

Renew Recreational GPR Assets

8

Renew Parks Facilities

9

Renew Playground Equipment

324,500

302,500

330,000

324,500

21,632

22,497

23,397

24,333

25,306

26,319

27,371

28,466

29,605

30,789

GPR

117,820

122,533

127,434

132,532

137,833

143,346

149,080

155,043

161,245

167,695

GPR

140,000

325,000

100,000

160,000

40,000

20,000

80,000

180,000

340,000

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

57


Appendix 8b - Recurrent Capital Projects 2017/18 - 2026/27 continued Ref 10 11

12

Project Title

Funding Source

Renew Recreational S94A $9,653 + GPR Facilities balance Replace Plant and Equipment

Plant Replacement Reserve $3,922,950 + Sale of Plant $1,262,650 (amounts vary each fin yr)

Corporate Hardware GPR Purchases Total Capital Works - Financial Sector

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

138,830

144,383

150,158

156,164

162,411

168,907

175,664

182,690

189,998

197,598

5,185,600

3,412,300

2,591,600

3,837,000

4,850,600

2,799,000

3,836,600

5,933,400

3,013,100

3,475,000

505,000

695,000

433,000

645,000

757,000

415,000

395,000

393,000

910,000

732,000

6,108,882

5,540,713

3,728,090

5,279,529

6,303,150

3,897,072

4,663,715

6,872,600

4,643,948

4,603,082

Community Sector 13

Upgrade of Backstage Equipment - Civic Theatre

GPR

10,816

11,249

11,699

12,167

12,653

13,159

13,686

14,233

14,802

15,394

14

Acquire pieces for the Australian Print Collection

GPR

8,571

8,874

9,189

9,517

9,857

10,212

10,580

10,963

11,362

11,776

15

Acquire pieces for the National Art Glass Collection

GPR

3,928

22,185

22,973

23,791

24,643

25,529

26,450

27,408

28,404

29,440

23,315

42,308

43,860

45,475

47,154

48,900

50,716

52,604

54,568

56,611

Total Capital Works - Community Sector Commercial Operations Sector 16

Upgrade Existing Bus Shelters

GPR

20,000

17

Implement Street Lighting Improvements Program - Roads and Traffic Facilities (as per schedule)

GPR

50,000

50,000

50,000

50,000

50,000

50,000

50,000

50,000

50,000

50,000

Capital renewal reseal program

GPR + Regional Roads Block Grant $295,873 (incrementing 3% each yr)

1,589,229

1,656,715

1,729,233

1,807,233

1,891,210

1,981,709

2,076,539

2,176,212

2,274,142

2,376,478

Conduct Urban Asphalt Program

GPR

754,971

786,313

818,440

851,852

886,599

922,737

960,320

999,406

1,040,041

1,082,297

18

19

58

20,000

20,000

20,000

20,000


Appendix 8b - Recurrent Capital Projects 2017/18 - 2026/27 continued Ref

Project Title

20

Funding Source

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

3,075,457

3,181,543

3,326,060

3,481,553

3,649,011

3,829,525

4,018,713

4,209,302

4,381,282

4,560,126

Pavement Rehabilitation Program

2017/18 - R2R Grant $2,465,958 + Regional Roads Block Grant $609,499, 2018/19 onwards - R2R Grant $841,526 (incrementing 3% each year) + Regional Roads Block Grant $627,784 (incrementing 3% each year) + GPR Balance

21

Replace Kerb and Gutter

GPR

436,705

455,215

474,038

493,614

513,973

535,147

557,167

580,067

603,870

628,622

22

Gravel Resheets

GPR

1,482,383

1,548,264

1,614,079

1,682,525

1,753,709

1,827,738

1,904,728

1,984,797

2,067,981

2,154,476

23

Renew and Replace GPR Culverts

527,914

551,650

575,261

599,816

625,353

651,911

679,531

708,256

738,094

769,119

24

Eliminate Sewer Joint Connections

Sewer Reserve

50,000

50,750

51,511

52,284

53,068

53,864

54,672

55,492

56,325

57,169

25

Implement renewal program for Gravity Sewer

Sewer Reserve

133,900

137,917

142,055

146,316

150,706

155,227

159,884

164,680

169,621

174,709

26

Implement Sewer Mains Rehabilitation Sewer Reserve Program

1,200,000

1,236,000

1,273,080

1,311,272

1,350,611

1,391,129

1,432,863

1,475,849

1,520,124

1,565,728

27

Replacement and Renewal of Sewer Plant

Sewer Reserve

50,750

51,511

52,284

53,068

53,864

54,672

55,492

56,325

57,169

58,027

28

Renew Community Amenities - Bolton Park

GPR

29

Renew Community Amenities Anderson Oval

GPR

30

Renew Community Amenities - Frenchs GPR Fields

202,590

214,928

208,668

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

59


Appendix 8b - Recurrent Capital Projects 2017/18 - 2026/27 continued Ref

Project Title

Funding Source

31

Renew Community Amenities - Kessler Park

GPR

32

Renew Community Amenities Ashmont Oval

GPR

33

Renew Community Amenities - Forest Hill Oval

GPR

34

Renew Community Amenities Uranquinty Sports Ground

GPR

35

Renew Community Amenities - Jubilee/ Connolly Park

GPR

36

Renew Community Amenities - Gissing Oval

GPR

37

Renew Community Amenities - Tarcutta GPR Public Convenience

38

Renew Community Amenities - Apex Park

2017/18

2018/19

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

221,375

228,016

234,856

241,901

249,158

256,633

GPR

256,633

Total Capital Works - Commercial Operations Sector

15,426,643

14,208,538

13,559,587

15,434,548

17,043,285

15,120,322

16,669,789

19,271,238

17,402,948

18,194,594

TOTAL LTFP CAPITAL PROGRAM

15,706,095

15,497,568

14,112,919

16,075,913

17,576,424

15,634,487

16,926,240

19,634,748

17,933,798

18,393,078

* Timing of project is subject to receipt of sufficient Section 94, Section 94A and DSP funds

60

2019/20


Appendix 8c - Capital Program Concepts List 2017/18 - 2026/27 Ref

Project Title

Funding Source

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

Financial Sector 1

Riverside - Continuation of Shared Path Network

GPR

Total Project Concepts Financial Sector

100,000 0

100,000

0

0

0

0

0

0

0

0

100,000

100,000

100,000

100,000

100,000

100,000

100,000

100,000

100,000

1,300,000

100,000

100,000

100,000

100,000

100,000

100,000

100,000

100,000

Community Sector

2

Construct Estella Community Centre

S94* $600,000 + GPR $199,643 + S94 (Old Plan) $121,838 + Reserve $178,519 + Borrowings $100,000 (GPR - Future Years Loan Repayments)

3

Public Art Projects - TBA

Public Art Reserve

Total Project Concepts - Community Sector

1,200,000

0

Commercial Operations Sector 4

Boorooma Street Slip Lane into Boorooma West

S94*

5

Glenfield Road Corridor – Works to improve traffic flow (RT16)

S94*

6

Glenfield Road/Pearson St - Red Hill Rd to Dobney Ave Widening S94* to 4 lanes (Full length-3 km)

100,000

7

Bakers Lane Widening + Intersection Upgrades Sturt Hwy S94* & Inglewood Rd)

50,000

8

Bourke Street and Bourkelands Drive Intersection Upgrade

S94*

107,252

9

Kooringal Road - Works to improve traffic flow (RT30)

S94*

100,000

10

Harris Road/Pine Gully Road Dual Lane Roundabout

S94*

1,211,564

11

Old Narrandera Road - Second Carriageway for 600m

S94A* $100,000 + S94* $737,428

297,000 3,117,550

100,000

1,294,272

341,945

1,079,768

637,428

100,000

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

61


Appendix 8c - Capital Program Concepts List 2017/18 - 2026/27 continued Ref 12

Project Title Old Narrandera Road/Olympic Highway Roundabout

13 Pine Gully Road - Bike Track

Funding Source S94A* $100,000 + S94* $577,886 S94*

2017/18

2018/19

577,886

30,000

96,510

Pine Gully Road - Second Carriageway for 1.2km

S94A* $100,000 + S94* $1,840,965

100,000

15

Pine Gully Road/Old Narrandera Road - Intersection Upgrade

S94*

100,000

16

Red Hill Rd – Widen to 4 lanes Plumpton Rd to Glenfield Plus widening at Dalman & Yentoo 2.7km

S94*

100,000

17

Red Hill Road and Hudson Drive – Intersection improvements

S94*

16,088

91,164

18

Supplementary Regional Roads Block Grant - project TBA

Block Grant -Supp

199,000

199,000

19

Regional Roads Repair Block Grant - project TBA

Repair Block Grant

400,000

20

Implement Pedestrian Access and Mobility Program (PAMP)

Grant $42,000 + GPR $42,000 Grant $30,000 + GPR $30,000

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

1,840,965 977,439

144,790

620,475

100,000

199,000

199,000

199,000

199,000

199,000

199,000

199,000

199,000

400,000

400,000

400,000

400,000

400,000

400,000

400,000

400,000

400,000

84,000

84,000

84,000

84,000

84,000

84,000

84,000

84,000

84,000

84,000

60,000

60,000

60,000

60,000

60,000

60,000

60,000

60,000

60,000

60,000

22

Renew Sewage Treatment Works Sewer Reserve - Tarcutta

100,000

23

Sewer - Pump Station - SPS15 Sewer Reserve Hammond Avenue - New Assets

401,016

24

Sewer - Pump Station - SPS01 Sheppard Street - Renewals

Sewer Reserve

25

Sewer - Pump Station - SPS15 Hammond Avenue - Renewals

Sewer Reserve

Sewer - Pump Station - SPS21 26 Smith Street Forest Hill Renewals

Sewer Reserve

300,000

27

Sewer - Pump Station - SPS26 Kyeamba - Renewals

Sewer Reserve

180,000

28

Sewer - Pump Station - SPS27 Tarcoola - Renewals

Sewer Reserve

170,000

62

2020/21

100,000

14

21 Implement Cycleways

2019/20

12,947

350,000 1,000,000


Appendix 8c - Capital Program Concepts List 2017/18 - 2026/27 continued Ref 29

Project Title Sewer - Gravity Network Extension - New Assets

Implement Stormwater Drainage Improvements - Jubilee Oval to 30 Red Hill Rd - Wagga West DSP Area

Funding Source Sewer Reserve

2017/18 100,000

2018/19

2020/21

797,803

Stormwater DSP * $265,580 + Civil Projects Reserve $24,000

289,580

Undertake Stormwater Drainage Stormwater DSP * $119,102 Upgrade - Contour Ridge (Lloyd) 31 + Stormwater Drainage approx 5 km - Wagga West DSP Reserve $9,600 Area

128,702

Undertake Stormwater Drainage Stormwater DSP * $248,129 32 Upgrade - Day, Higgins, Tarcutta + Stormwater Drainage St - Wagga West DSP Area Reserve $20,000

268,129

Improve Stormwater drainage - Kincaid St end to Flowerdale 33 pumping station - Wagga West DSP Area

2019/20

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

265,494

Stormwater DSP * $318,695 + Civil Projects $28,800

347,495

Stormwater DSP Project Allocation - TBA

Stormwater DSP*

500,000

500,000

500,000

500,000

500,000

500,000

500,000

35 Murray St Stormwater Project

Stormwater Levy

Civic Building Energy Efficiency 36 Project - Library Lights

S94* Civic Building Recoupment

29,200

Civic Building Energy Efficiency 37 Project - Historic Council Chambers Lights

S94* Civic Building Recoupment

88,809

Civic Building Energy Efficiency 38 Project - Art Gallery & Glass Gallery Lights

S94* Civic Building Recoupment

399,278

39 Bolton Park Accessible Toilet

GPR

136,209

40 Bolton Park Stadium Upgrade

Borrowings $4,211,940 + S94* $68,657 + Royal Lifesaving NSW Contribution $300,000

3,389,054

4,069,934

1,355,947

1,243,000

2,322,768

1,243,000

1,243,000

34

Total Project Concepts - Commercial Operations Sector

3,200,000

4,580,597 4,409,417 14,216,525

4,014,711

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

63


Appendix 8c - Capital Program Concepts List 2017/18 - 2026/27 continued Ref

Project Title

Funding Source

2017/18

2018/19

2019/20

2020/21

2021/22

2022/23

2023/24

2024/25

2025/26

2026/27

Commercial Development Sector GWMC - Construction of a 41 new Waste Cell (Design + Construction)

Solid Waste Reserve

42 GWMC - Constuct RRC

Solid Waste Reserve

150,000

4,242,000

500,000

GWMC - Asset Renewals 44 (Transfer Stations, Leachate systems)

Solid Waste Reserve

45 GWMC Solar Panels

Solid Waste Reserve

30,000

Solid Waste Reserve

40,000

Solid Waste Reserve

400,000

48 GWMC Organic Processing Plant Solid Waste Reserve

3,000,000

GWMC Gas Flare Extension Mini Station

47 GWMC Hook Truck & Bins

200,000

49 GWMC Asphalting

Solid Waste Reserve

125,000

50 GWMC Office Space

Solid Waste Reserve

50,000

51

GWMC Renewal of the Rural Transfer

Solid Waste Reserve

200,000

52

GWMC Leachate Solar Evaporator

Solid Waste Reserve

30,000

53

Airport - Implementation of the Masterplan

Airport Reserve

54

Oasis Initiatives from the Energy Audit Review

Oasis Plant Reserve

200,000

55 Oasis Splash Pad water feature

S94* - Oasis Recoupment

680,000

56 Oasis Water Slide

S94* - Oasis Recoupment

850,000

Total Project Concepts - Commercial Development Sector TOTAL LTFP PROJECT CONCEPTS

200,000

500,000

500,000

500,000

8,144,417 11,414,811

5,742,000

1,847,495

965,494

500,000

700,000

6,500,000

500,000

500,000

11,800,337 16,766,525

8,856,711

4,489,054

4,369,934

1,455,947

1,543,000

8,422,768

1,343,000

1,343,000

* Timing of project is subject to receipt of sufficient Section 94, Section 94A and DSP funds

64

6,000,000

1,785,920

43 GWMC - Weighbridge Relocation Solid Waste Reserve

46

200,000

300,000


Appendix 9 - Wagga Wagga Regional Airport Ten Year Financial Plan BUDGET 2017/18 Estimated Reserve Balance at start of the year

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

300,017

686,677

528,892

474,474

412,987

802,202

1,050,393

1,528,419

1,912,549

23,811

0

0

0

0

0

0

0

0

0

0

(4,224,702)

(4,534,878)

(4,645,748)

(4,759,610)

(4,876,574)

(4,996,739)

(5,120,208)

(5,247,088)

(5,376,643)

(5,488,321)

0

0

0

0

0

0

0

0

0

0

(237,883)

(243,810)

(249,887)

(255,420)

(261,785)

(268,308)

(274,994)

(281,846)

(283,996)

(278,808)

Grants & Contributions provided for Operating Purposes

0

0

0

0

0

0

0

0

0

0

Grants & Contributions provided for Capital Purposes

0

0

0

0

0

0

0

0

0

0

Revenue From Continuing Operations Rates & Annual Charges User Charges & Fees Interest & Investment Revenue Other Revenues

Revenue From Continuing Operations

(4,462,585) (4,778,687) (4,895,635) (5,015,030) (5,138,360) (5,265,048) (5,395,201) (5,528,933) (5,660,639) (5,767,129)

Expenses From Continuing Operations Employee Benefits & On-Costs

514,085

534,508

555,744

577,827

600,791

624,670

649,502

675,324

702,175

727,034

Borrowing Costs

496,100

582,012

548,921

484,713

417,688

346,538

271,698

190,693

124,936

360,964

Materials & Contracts

2,003,609

1,932,178

1,995,609

2,083,353

2,140,314

2,220,307

2,295,743

2,385,534

2,468,517

2,466,750

Depreciation & Amortisation

1,198,781

1,204,981

1,227,881

1,227,881

1,227,881

1,242,881

1,286,881

1,286,881

1,300,214

1,368,475

237,580

252,276

267,912

284,549

302,252

321,092

341,143

362,484

385,201

409,384

4,450,155

4,505,955

4,596,067

4,658,323

4,688,925

4,755,488

4,844,965

4,900,916

4,981,044

5,332,608

Net Operating (Profit)/Loss

(12,430)

(272,733)

(299,568)

(356,707)

(449,434)

(509,560)

(550,236)

(628,017)

(679,595)

(434,522)

Net Operating Result before Grants and Contributions provided for Capital Purposes

(12,430)

(272,733)

(299,568)

(356,707)

(449,434)

(509,560)

(550,236)

(628,017)

(679,595)

(434,522)

Capital Expenditure - Renewals

2,155,000

595,000

0

0

75,000

220,000

0

200,000

7,000,000

0

Capital Expenditure - New Projects

1,300,000

0

0

0

0

0

0

0

0

0

0

500,000

500,000

500,000

0

0

0

0

0

0

669,550

990,498

1,081,867

1,146,075

1,213,100

1,284,250

1,359,090

1,330,768

1,068,547

1,426,678

0

0

0

0

0

0

(4,200,000)

0

Other Expenses Expenses From Continuing Operations

Capital and Reserve Movements

Capital Expenditure - Project Concepts Loan Repayments New Loan Borrowings

(3,300,000)

(450,000)

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

65


Appendix 9 - Wagga Wagga Regional Airport Ten Year Financial Plan continued BUDGET 2017/18 Proceeds from Sale of intangible & tangible Assets

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

0

0

0

0

0

0

0

0

0

0

386,660

(157,785)

(54,418)

(61,487)

389,215

248,190

478,027

384,130

(1,888,738)

376,319

Total Capital and Reserve Movements

1,211,210

1,477,713

1,527,449

1,584,588

1,677,315

1,752,440

1,837,117

1,914,898

1,979,809

1,802,997

Net Result

1,198,781

1,204,980

1,227,880

1,227,881

1,227,880

1,242,880

1,286,880

1,286,880

1,300,214

1,368,475

Add back Depreciation Expense (non-cash)

1,198,781

1,204,981

1,227,881

1,227,881

1,227,881

1,242,881

1,286,881

1,286,881

1,300,214

1,368,475

0

(0)

(0)

0

(0)

(0)

(0)

(0)

(0)

(0)

686,677

528,892

474,474

412,987

802,202

1,050,393

1,528,419

1,912,549

23,811

400,130

Net Movements to/(from) Reserves

Cash Budget (Surplus)/Deficit Estimated Reserve Balance at end of the year

Appendix 10 - Livestock Marketing Centre Ten Year Financial Plan BUDGET 2017/18 Estimated Reserve Balance at start of the year

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

3,574,732

4,754,749

6,311,765

8,095,027

10,123,253

12,418,585

12,021,055

11,138,370

13,828,925

16,662,436

0

0

0

0

0

0

0

0

0

0

(5,137,171)

(5,493,261)

(5,875,158)

(6,284,783)

(6,724,203)

(6,978,893)

(7,243,593)

(7,518,702)

(7,804,632)

(7,804,632)

0

0

0

0

0

0

0

0

0

0

(40,986)

(42,535)

(41,648)

(40,724)

(42,360)

(44,062)

(45,832)

(47,674)

(49,589)

(50,422)

Grants & Contributions provided for Operating Purposes

0

0

0

0

0

0

0

0

0

0

Grants & Contributions provided for Capital Purposes

0

0

0

0

0

0

0

0

0

0

(5,178,157) (5,535,796) (5,916,806) (6,325,507)

(6,766,563)

(7,022,955)

(7,289,426)

(7,566,376)

(7,854,221)

(7,855,054)

Revenue From Continuing Operations Rates & Annual Charges User Charges & Fees Interest & Investment Revenue Other Revenues

Revenue From Continuing Operations Expenses From Continuing Operations Employee Benefits & On-Costs

990,547

1,030,020

1,071,070

1,113,760

1,158,155

1,204,324

1,252,337

1,302,269

1,354,195

1,407,348

0

0

0

0

0

0

0

0

0

0

Materials & Contracts

2,695,706

2,794,110

2,898,168

3,008,934

3,127,543

3,199,707

3,274,078

3,350,718

3,429,595

3,447,200

Depreciation & Amortisation

717,366

757,897

800,718

845,959

893,755

944,252

997,603

1,053,967

1,113,516

1,113,516

Borrowing Costs

66


Appendix 10 - Livestock Marketing Centre Ten Year Financial Plan continued BUDGET 2017/18 Other Expenses

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

145,581

154,650

164,306

174,587

185,534

197,192

209,609

222,833

236,920

251,887

4,549,200

4,736,677

4,934,262

5,143,240

5,364,987

5,545,476

5,733,627

5,929,787

6,134,226

6,219,951

Net Operating (Profit)/Loss

(628,957)

(799,119)

(982,544)

(1,182,268)

(1,401,576)

(1,477,479)

(1,555,799)

(1,636,588)

(1,719,995)

(1,635,104)

Net Operating Result before Grants and Contributions provided for Capital Purposes

(628,957)

(799,119)

(982,544) (1,182,268)

(1,401,576)

(1,477,479)

(1,555,799)

(1,636,588)

(1,719,995)

(1,635,104)

16,995

0

0

0

0

0

83,467

0

0

0

149,310

0

0

0

0

2,819,261

3,352,620

0

0

0

Capital Expenditure - Project Concepts

0

0

0

0

0

0

0

0

0

0

Loan Repayments

0

0

0

0

0

0

0

0

0

0

New Loan Borrowings

0

0

0

0

0

0

0

0

0

0

Proceeds from Sale of intangible & tangible Assets

0

0

0

0

0

0

0

0

0

0

Net Movements to/(from) Reserves

1,180,017

1,557,016

1,783,262

2,028,226

2,295,331

(397,530)

(882,685)

2,690,555

2,833,511

2,748,620

Total Capital and Reserve Movements

1,346,322

1,557,016

1,783,262

2,028,226

2,295,331

2,421,731

2,553,402

2,690,555

2,833,511

2,748,620

Net Result

717,366

757,897

800,718

845,959

893,755

944,252

997,603

1,053,967

1,113,516

1,113,516

Add back Depreciation Expense (non-cash)

717,366

757,897

800,718

845,959

893,755

944,252

997,603

1,053,967

1,113,516

1,113,516

0

(0)

(0)

(0)

(0)

(0)

(0)

(0)

(0)

(0)

4,754,749

6,311,765

8,095,027

10,123,253

12,418,585

12,021,055

11,138,370

13,828,925

16,662,436

19,411,056

Expenses From Continuing Operations

Capital and Reserve Movements Capital Expenditure - Renewals Capital Expenditure - New Projects

Cash Budget (Surplus)/Deficit Estimated Reserve Balance at end of the year

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

67


Appendix 11 - Sewerage Services Ten Year Financial Plan Estimated Reserve Balance at start of the year

BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

15,374,507

14,144,516

13,712,241

16,577,956

19,366,885

22,777,018

28,049,837

32,443,804

39,475,862

47,122,173

Revenue From Continuing Operations Rates & Annual Charges User Charges & Fees Interest & Investment Revenue Other Revenues Grants & Contributions provided for Operating Purposes Grants & Contributions provided for Capital Purposes Revenue From Continuing Operations

(12,851,872) (13,614,408) (14,422,311) (15,278,287) (15,732,961) (16,201,183) (16,683,358) (17,179,901) (17,691,242) (18,217,822) (4,963,046)

(5,205,594)

(5,460,263)

(5,727,659)

(5,868,377)

(6,012,623)

(6,160,486)

(6,312,056)

(6,466,636)

(6,625,080)

(283,698)

(366,077)

(390,145)

(478,668)

(580,366)

(619,209)

(695,701)

(811,038)

(970,370)

(1,128,327)

0

0

0

0

0

0

0

0

0

0

(160,185)

(169,796)

(179,984)

(190,783)

(196,506)

(202,401)

(208,473)

(214,728)

(221,169)

(227,804)

(1,289,000)

(1,305,000)

(1,319,000)

(1,301,000)

(1,315,000)

(1,330,000)

(1,349,000)

(1,349,000)

(1,349,000)

(1,349,000)

(19,547,801) (20,660,874) (21,771,702) (22,976,396) (23,693,209) (24,365,416) (25,097,018) (25,866,723) (26,698,418) (27,548,033)

Expenses From Continuing Operations Employee Benefits & On-Costs

2,092,252

2,175,130

2,261,317

2,350,947

2,444,156

2,541,087

2,641,890

2,746,718

2,855,052

2,967,719

Borrowing Costs

2,319,305

2,269,721

2,216,438

2,159,180

2,097,651

2,031,531

1,960,479

1,884,127

1,802,078

1,713,909

Materials & Contracts

9,337,918

9,168,656

9,506,442

9,591,493

9,984,036

10,104,316

10,472,579

10,649,085

10,666,747

10,725,039

Depreciation & Amortisation

5,837,167

6,166,967

6,515,401

6,883,521

7,272,440

7,683,333

8,117,441

8,576,076

9,060,625

9,060,625

477,352

504,095

532,463

562,559

594,494

628,386

664,360

702,552

743,105

786,170

20,063,994

20,284,569

21,032,062

21,547,699

22,392,777

22,988,652

23,856,750

24,558,558

25,127,607

25,253,462

516,193

(376,305)

(739,640)

(1,428,697)

(1,300,433)

(1,376,763)

(1,240,268)

(1,308,165)

(1,570,811)

(2,294,571)

1,805,193

928,695

579,360

(127,697)

14,567

(46,763)

108,732

40,835

(221,811)

(945,571)

Capital Expenditure - Renewals

1,434,650

1,852,867

1,798,930

2,467,612

1,649,030

2,254,892

2,522,911

1,752,346

1,803,239

1,855,633

Capital Expenditure - New Projects

3,850,641

2,610,634

822,870

2,230,893

2,361,903

567,005

1,417,347

0

0

0

Capital Expenditure - Project Concepts

601,016

1,797,803

1,000,000

0

265,494

12,947

0

0

0

0

Loan Repayments

664,659

714,243

767,526

824,784

886,313

952,433

1,023,485

1,099,837

1,181,886

1,270,055

Other Expenses Expenses From Continuing Operations Net Operating (Profit)/Loss Net Operating Result before Grants and Contributions provided for Capital Purposes Capital and Reserve Movements

68


Appendix 11 - Sewerage Services Ten Year Financial Plan continued BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

New Loan Borrowings

0

0

0

0

0

0

0

0

0

0

Proceeds from Sale of intangible & tangible Assets

0

0

0

0

0

0

0

0

0

0

(1,229,992)

(432,275)

2,865,716

2,788,929

3,410,133

5,272,819

4,393,966

7,032,058

7,646,311

8,229,507

Total Capital and Reserve Movements

5,320,974

6,543,272

7,255,041

8,312,218

8,572,872

9,060,096

9,357,709

9,884,241

10,631,436

11,355,196

Net Result

5,837,167

6,166,967

6,515,401

6,883,521

7,272,440

7,683,333

8,117,441

8,576,076

9,060,625

9,060,625

Add back Depreciation Expense (non-cash)

5,837,167

6,166,967

6,515,401

6,883,521

7,272,440

7,683,333

8,117,441

8,576,076

9,060,625

9,060,625

0

0

0

0

(0)

0

0

0

0

0

14,144,516

13,712,241

16,577,956

19,366,885

22,777,018

28,049,837

32,443,804

39,475,862

47,122,173

55,351,680

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

17,287,059

21,493,080

Net Movements to/(from) Reserves

Cash Budget (Surplus)/Deficit Estimated Reserve Balance at end of the year

Appendix 12 - Solid Waste Services Ten Year Financial Plan BUDGET 2017/18 Estimated Reserve Balance at start of the year

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

11,780,049

6,902,040

8,674,523

7,349,983

9,726,697

12,812,499

16,271,818

19,426,509

Rates & Annual Charges

(7,956,892)

(8,195,598)

(8,441,466)

(8,694,710)

(8,955,552)

(9,224,218)

(9,500,945)

(9,785,973) (10,079,552) (10,381,939)

User Charges & Fees

(3,823,429)

(3,965,872)

(4,113,710)

(4,267,151)

(4,426,409)

(4,591,707)

(4,763,096)

(4,941,359)

(5,048,212)

(5,159,340)

Interest & Investment Revenue

(77,882)

(88,390)

(101,569)

(116,048)

(132,715)

(131,294)

(147,564)

(169,532)

(191,663)

(222,862)

Other Revenues

(64,229)

(65,710)

(67,227)

(68,783)

(70,378)

(72,012)

(73,687)

(75,405)

(75,405)

(75,405)

(108,886)

(112,152)

(115,517)

(118,983)

(122,552)

(126,229)

(130,015)

(133,916)

(137,933)

(142,071)

0

0

0

0

0

0

0

0

0

0

Revenue From Continuing Operations

Grants & Contributions provided for Operating Purposes Grants & Contributions provided for Capital Purposes Revenue From Continuing Operations

(12,031,317) (12,427,722) (12,839,490) (13,265,675) (13,707,606) (14,145,460) (14,615,309) (15,106,184) (15,532,765) (15,981,616) WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

69


Appendix 12 - Solid Waste Services Ten Year Financial Plan continued BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

Expenses From Continuing Operations Employee Benefits & On-Costs

979,250

1,018,360

1,059,034

1,101,335

1,145,328

1,191,080

1,238,663

1,288,149

1,339,615

1,393,139

0

0

0

0

0

0

0

0

0

0

8,497,069

9,033,536

8,838,319

9,261,534

9,248,882

9,465,872

9,691,075

9,924,809

9,952,546

9,981,016

275,425

290,987

307,427

324,797

343,148

362,536

383,019

404,660

427,523

427,523

22,086

23,343

24,677

26,092

27,594

29,188

30,880

32,676

34,583

36,609

9,773,830

10,366,226

10,229,457

10,713,758

10,764,952

11,048,676

11,343,637

11,650,294

11,754,267

11,838,286

Net Operating (Profit)/Loss

(2,257,487)

(2,061,496)

(2,610,033)

(2,551,917)

(2,942,654)

(3,096,784)

(3,271,672)

(3,455,890)

(3,778,498)

(4,143,330)

Net Operating Result before Grants and Contributions provided for Capital Purposes

(2,257,487)

(2,061,496)

(2,610,033)

(2,551,917)

(2,942,654)

(3,096,784)

(3,271,672)

(3,455,890)

(3,778,498)

(4,143,330)

0

230,000

0

0

0

0

300,000

0

0

0

Capital Expenditure - New Projects

1,750,000

0

0

0

0

0

0

0

0

0

Capital Expenditure - Project Concepts

5,660,920

350,000

4,242,000

500,000

200,000

0

200,000

6,000,000

0

0

Loan Repayments

0

0

0

0

0

0

0

0

0

0

New Loan Borrowings

0

0

0

0

0

0

0

0

0

0

Proceeds from Sale of intangible & tangible Assets

0

0

0

0

0

0

0

0

0

0

(4,878,008)

1,772,483

(1,324,540)

2,376,714

3,085,802

3,459,320

3,154,691

(2,139,450)

4,206,021

4,570,853

2,532,912

2,352,483

2,917,460

2,876,714

3,285,802

3,459,320

3,654,691

3,860,550

4,206,021

4,570,853

Net Result

275,425

290,986

307,427

324,797

343,148

362,536

383,019

404,660

427,523

427,523

Add back Depreciation Expense (non-cash)

275,425

290,987

307,427

324,797

343,148

362,536

383,019

404,660

427,523

427,523

(0)

(0)

0

(0)

(0)

(0)

(0)

(0)

(0)

(0)

6,902,040

8,674,523

7,349,983

9,726,697

12,812,499

16,271,818

19,426,509

17,287,059

21,493,080

26,063,933

Borrowing Costs Materials & Contracts Depreciation & Amortisation Other Expenses Expenses From Continuing Operations

Capital and Reserve Movements Capital Expenditure - Renewals

Net Movements to/(from) Reserves Total Capital and Reserve Movements

Cash Budget (Surplus)/Deficit Estimated Reserve Balance at end of the year

70


Appendix 13 - Stormwater Levy Ten Year Financial Plan BUDGET 2017/18 Estimated Reserve Balance at start of the year

BUDGET 2018/19

2,601,864

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

3,189,069

583,775

583,775

583,775

583,775

583,775

583,775

583,775

583,775

(692,265)

(699,765)

(707,265)

(714,765)

(722,265)

(729,765)

(737,265)

(744,765)

(752,265)

(759,765)

User Charges & Fees

0

0

0

0

0

0

0

0

0

0

Interest & Investment Revenue

0

0

0

0

0

0

0

0

0

0

Other Revenues

0

0

0

0

0

0

0

0

0

0

Grants & Contributions provided for Operating Purposes

0

0

0

0

0

0

0

0

0

0

Grants & Contributions provided for Capital Purposes

0

0

0

0

0

0

0

0

0

0

(692,265)

(699,765)

(707,265)

(714,765)

(722,265)

(729,765)

(737,265)

(744,765)

(752,265)

(759,765)

0

0

0

0

0

0

0

0

0

0

48,510

44,376

40,491

36,240

31,700

26,861

21,842

16,164

10,347

4,094

Materials & Contracts

0

0

602,206

609,706

617,206

624,706

632,206

639,706

647,206

654,706

Depreciation & Amortisation

0

0

0

0

0

0

0

0

0

0

Other Expenses

0

0

0

0

0

0

0

0

0

0

48,510

44,376

642,696

645,946

648,906

651,566

654,048

655,869

657,553

658,800

Net Operating (Profit)/Loss

(643,755)

(655,389)

(64,568)

(68,819)

(73,359)

(78,198)

(83,217)

(88,895)

(94,712)

(100,965)

Net Operating Result before Grants and Contributions provided for Capital Purposes

(643,755)

(655,389)

(64,568)

(68,819)

(73,359)

(78,198)

(83,217)

(88,895)

(94,712)

(100,965)

Capital Expenditure - Renewals

0

0

0

0

0

0

0

0

0

0

Capital Expenditure - New Projects

0

0

0

0

0

0

0

0

0

0

Capital Expenditure - Project Concepts

0

3,200,000

0

0

0

0

0

0

0

0

56,549

60,683

64,568

68,819

73,359

78,198

83,217

88,895

94,712

100,965

Revenue From Continuing Operations Rates & Annual Charges

Revenue From Continuing Operations Expenses From Continuing Operations Employee Benefits & On-Costs Borrowing Costs

Expenses From Continuing Operations

Capital and Reserve Movements

Loan Repayments

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

71


Appendix 13 - Stormwater Levy Ten Year Financial Plan continued BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

New Loan Borrowings

0

0

0

0

0

0

0

0

0

0

Proceeds from Sale of intangible & tangible Assets

0

0

0

0

0

0

0

0

0

0

Net Movements to/(from) Reserves

587,206

(2,605,294)

0

0

0

0

0

0

0

0

Total Capital and Reserve Movements

643,755

655,389

64,568

68,819

73,359

78,198

83,217

88,895

94,712

100,965

Net Result

0

0

0

0

0

0

0

0

0

0

Add back Depreciation Expense (non-cash)

0

0

0

0

0

0

0

0

0

0

Cash Budget (Surplus)/Deficit

0

0

0

0

0

0

0

0

0

0

3,189,069

583,775

583,775

583,775

583,775

583,775

583,775

583,775

583,775

583,775

Estimated Reserve Balance at end of the year

Appendix 14 - Budgeted Income Statement by Function BUDGET 2017/18

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

Revenue From Continuing Operations Governance

(3,750)

0

0

0

0

0

0

0

0

0

Administration

(1,191,317)

(1,195,277)

(1,199,356)

(1,203,557)

(1,207,884)

(1,212,341)

(1,216,932)

(1,221,661)

(1,226,531)

(1,231,547)

Public Order & Safety

(1,326,157)

(1,363,313)

(1,401,622)

(1,441,117)

(1,481,839)

(1,523,826)

(1,567,116)

(1,611,753)

(1,649,388)

(1,688,153)

(195,160)

(201,951)

(209,006)

(216,337)

(223,086)

(231,784)

(239,947)

(248,418)

(256,314)

(264,525)

(15,810,327)

(16,350,338)

(16,957,144)

(17,588,558)

(14,579,733)

(15,029,206)

(15,510,806)

(16,013,572)

(16,450,937)

(16,910,671)

Community Services & Education

(1,838,416)

(1,654,410)

(1,671,159)

(1,688,701)

(1,707,075)

(1,726,322)

(1,746,487)

(1,767,614)

(1,788,899)

(1,811,202)

Housing & Community Amenities

(5,469,424)

(5,575,399)

(5,688,641)

(5,807,602)

(5,933,574)

(6,041,313)

(6,175,889)

(6,322,463)

(6,403,712)

(6,499,008)

(19,547,801)

(20,660,874)

(21,771,702)

(22,976,396)

(23,693,209)

(24,365,416)

(25,097,018)

(25,866,723)

(26,698,418)

(27,548,033)

Recreation & Culture

(3,796,932)

(4,715,650)

(3,971,552)

(4,099,163)

(4,205,115)

(4,302,362)

(4,266,439)

(4,379,772)

(4,480,144)

(4,584,852)

Mining, Manufacturing & Construction

(1,440,389)

(1,510,464)

(1,584,026)

(1,661,248)

(1,742,312)

(1,827,411)

(1,916,745)

(2,010,526)

(2,011,503)

(2,013,350)

Health Environment

Sewerage Services

72


Appendix 14 - Budgeted Income Statement by Function continued BUDGET 2017/18 Transport & Communication

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

(11,590,126)

(8,241,540)

(8,440,294)

(8,643,960)

(8,854,099)

(9,070,214)

(9,292,489)

(9,521,120)

(9,749,101)

(9,954,742)

(6,101,337)

(6,529,482)

(6,870,690)

(7,295,106)

(7,807,841)

(8,036,469)

(8,325,741)

(8,626,090)

(8,924,199)

(8,940,315)

Revenue From Continuing Operations

(68,311,135)

(67,998,700)

(69,765,194)

(72,621,746)

(71,435,768)

(73,366,661)

(75,355,609)

(77,589,712)

(79,639,146)

(81,446,397)

General Purpose Income

(54,481,195)

(55,957,876)

(57,664,476)

(59,275,550)

(59,386,072)

(60,585,744)

(62,375,416)

(64,172,678)

(66,097,321)

(68,352,237)

Economic Affairs

Total Revenue From Continuing Operations

(122,792,330) (123,956,576) (127,429,670) (131,897,296) (130,821,840) (133,952,405) (137,731,025) (141,762,390) (145,736,466) (149,798,634)

Expenses From Continuing Operations Governance

2,294,896

2,159,620

2,059,650

2,432,023

2,186,768

2,253,981

2,323,758

2,706,202

2,473,999

2,544,456

10,218,611

10,566,048

11,312,460

12,022,113

12,804,349

13,631,572

14,545,447

15,487,619

16,570,227

17,299,888

Public Order & Safety

2,882,882

2,944,268

3,023,375

3,109,364

3,189,986

3,277,715

3,368,667

3,467,387

3,548,798

3,634,634

Health

1,442,804

1,469,597

1,511,643

1,539,055

1,567,291

1,596,381

1,626,805

1,662,862

1,548,685

1,602,327

14,456,265

15,207,193

15,851,751

16,531,490

16,787,495

17,285,903

17,806,076

18,348,557

18,700,400

18,863,750

Community Services & Education

2,416,619

2,431,909

2,468,055

2,504,731

2,542,323

2,581,945

2,623,361

2,666,447

2,711,287

2,758,339

Housing & Community Amenities

6,110,231

6,121,074

6,384,609

6,598,182

6,855,536

7,178,991

7,487,510

7,750,044

8,087,348

8,377,396

Sewerage Services

20,063,994

20,284,569

21,032,062

21,547,699

22,392,777

22,988,652

23,856,750

24,558,558

25,127,607

25,253,462

Recreation & Culture

21,075,041

21,940,712

22,852,065

23,520,876

24,230,851

24,939,458

25,700,212

26,493,768

27,217,098

27,828,731

1,469,011

1,437,066

1,487,022

1,525,559

1,579,558

1,635,704

1,694,086

1,754,798

1,817,935

1,883,599

29,952,150

31,113,440

32,017,464

33,262,920

34,376,522

35,708,686

37,131,299

38,600,254

40,071,560

40,566,773

7,431,934

7,780,046

7,867,683

8,132,431

8,487,861

8,676,616

8,925,196

9,233,625

9,440,627

9,413,728

119,814,437

123,455,541

127,867,839

132,726,443

137,001,317

141,755,604

147,089,167

152,730,123

157,315,570

160,027,083

(2,977,893)

(501,035)

438,169

829,147

6,179,477

7,803,199

9,358,142

10,967,732

11,579,104

10,228,449

0

0

0

0

0

0

0

0

0

0

5,760,254

4,181,227

3,100,882

4,562,890

5,693,388

3,304,990

4,326,558

6,403,057

4,004,411

4,293,293

59,321

61,927

64,639

67,604

70,585

73,822

77,121

64,940

0

0

Administration

Environment

Mining, Manufacturing & Construction Transport & Communication Economic Affairs Expenses From Continuing Operations Net Operating (Profit)/Loss Capital and Reserve Movements Governance Administration Public Order & Safety

WAGGA WAGGA CITY COUNCIL LONG TERM FINANCIAL PLAN

73


Appendix 14 - Budgeted Income Statement by Function continued BUDGET 2017/18 Health

BUDGET 2018/19

BUDGET 2019/20

BUDGET 2020/21

BUDGET 2021/22

BUDGET 2022/23

BUDGET 2023/24

BUDGET 2024/25

BUDGET 2025/26

BUDGET 2026/27

249,302

261,959

258,290

273,468

289,486

330,626

213,169

0

0

0

7,487,499

3,840,683

4,306,568

568,819

273,359

78,198

583,217

6,088,895

94,712

100,965

Community Services & Education

0

0

0

0

0

0

0

0

0

0

Housing & Community Amenities

16,006

16,646

17,312

18,004

18,724

76,374

80,567

84,996

89,675

93,706

Sewerage Services

6,550,966

6,975,547

4,389,326

5,523,289

5,162,740

3,787,277

4,963,742

2,852,183

2,985,124

3,125,688

Recreation & Culture

2,854,049

1,593,334

1,706,201

1,941,763

1,891,193

1,978,008

1,817,369

1,681,548

1,873,805

1,613,501

0

0

0

0

0

0

0

0

0

0

32,608,534

30,076,601

19,743,971

20,289,126

15,850,115

13,312,085

13,418,444

15,058,051

21,482,800

14,792,209

222,172

3,163,471

1,268,784

374,269

179,933

3,005,042

3,627,906

198,053

204,489

211,135

New Loan Borrowings

(7,215,980)

(6,762,097)

0

0

(750,000)

0

0

0

(4,200,000)

0

Proceeds from Sale of intangible & tangible Assets

(4,678,401)

(1,354,100)

(792,182)

(835,808)

(1,383,000)

(739,100)

(977,700)

(1,396,850)

(1,148,900)

(1,250,650)

Net Movements to/(from) Reserves

(6,458,101)

(5,189,974)

3,871,625

6,859,747

9,213,627

12,036,694

10,077,627

8,178,336

15,991,568

19,816,753

Total Capital and Reserve Movements

37,455,621

36,865,224

37,935,415

39,643,170

36,510,151

37,244,017

38,208,019

39,213,208

41,377,684

42,796,600

Net Result after Depreciation

34,477,728

36,364,189

38,373,585

40,472,317

42,689,627

45,047,216

47,566,161

50,180,940

52,956,788

53,025,049

Add back Depreciation Expense (noncash)

34,477,729

36,364,189

38,373,584

40,472,317

42,689,627

45,047,216

47,566,161

50,180,940

52,956,788

53,025,049

(0)

0

0

0

0

0

0

0

0

0

Environment

Mining, Manufacturing & Construction Transport & Communication Economic Affairs

Cash Budget (Surplus)/Deficit

74


questions? comments? contact us. Wagga Wagga City Council PO Box 20 Cnr Baylis & Morrow Sts Wagga Wagga NSW Ph: 1300 292 442 Fax: (02) 6926 9199 Email: council@wagga.nsw.gov.au

Wagga Wagga City Council Long Term Financial Plan

Follow @WaggaCouncil on Twitter to get the news, events and emergency information straight from the source.

www.wagga.nsw.gov.au


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.