Budgeted Income Statement Template Excel
Budgeted Income Statement Template Excel
Budgeted Income Statement Template Excel
FUNDS STATEMENT
Cash Flow from Operations #REF! #REF! #REF! #REF! #REF!
Net Outflow from Capital
Expenditure #REF! #REF! #REF! #REF! #REF!
Outflows
Recurrent - Operating #REF! #REF! #REF! #REF! #REF!
Non-Recurrent - Operating #REF! #REF! #REF! #REF! #REF!
Capital Expenditure #REF! 22,408 28,301 40,978 35,555
Total Outflows #REF! #REF! #REF! #REF! #REF!
Budget 2000/01 1
60% General Rate Revenue
Asset Turnover
Revenu
Assets
Turnove
r Ratio
Financial Leverage
Assets
Equity
Leverage Ratio
Recurrent Surplus
Recurrent
Revenue
Recurrent Surplus
%
Employee Costs
Rates excluding garbage
Salaries to Rates
Outstanding Loans
60% Total Rate Revenue
Current Assets to
Current Liabilities
Cash Position
Working Capital
Requirement
Capital Renewal
Renewal and upgrade
Upgrad
e
New Capital
Total Capital Expenditure
Depreciation
Asset Sales
Cap Inc / Devr Cont/Loans/Asset Sales
New Loans
Total Capital Funding
Internal Funding
Internal and external funding ex loans
Total Funding inc Loans
Base Program
Leisurelink
Bellarine Pool
Conference Centre
Vines Road Centre
Civic Accommodation
Libraries
Western Wedge
New Infrastructure
Infrastructure renewal
Councillor Priorities
Other
Capital Expenditure
Outstanding Loans
60% Total Rate Revenue
2007/08 2008/09 2009/10 2010/11 2011/12 2012/13 2013/14 2014/15 2015/16 2016/17 2017/18
58,753 62,901 66,046 69,348 72,816 76,457 80,279 84,293 88,087 92,050
6.58% 1.98% 4.20% 4.72% 4.93% 6.46% 6.84% 6.89% 6.95% 6.03%
5.09% 5.19% 1.58% 3.37% 3.79% 3.97% 5.21% 5.53% 5.58% 5.64% 4.90%
#REF! 0.78% 0.95% 1.10% 1.22% 1.19% #REF! #REF! #REF! #REF! #REF!
16,210 20,876 31,211 32,068 33,193 47,994 62,020 61,161 55,095 48,593 43,347
#REF! 299,411 320,859 331,989 343,563 355,988 #REF! #REF! #REF! #REF! #REF!
1,292,257 1,646,389 1,703,595 1,744,991 1,784,382 1,814,432 #REF! #REF! #REF! #REF! #REF!
#REF! 0.18 0.19 0.19 0.19 0.20 #REF! #REF! #REF! #REF! #REF!
1,325,923 1,712,238 1,765,963 1,812,421 1,854,231 1,884,306 #REF! #REF! #REF! #REF! #REF!
1,266,923 1,624,473 1,657,607 1,699,716 1,728,050 1,754,192 #REF! #REF! #REF! #REF! #REF!
1.05 1.05 1.07 1.07 1.07 1.07 #REF! #REF! #REF! #REF! #REF!
#REF! - 14,607 1,830 - 347 - 586 - 494 #REF! #REF! #REF! #REF! #REF!
#REF! 299,411 320,859 331,989 343,563 355,988 #REF! #REF! #REF! #REF! #REF!
#REF! -4.9% 0.6% -0.1% -0.2% -0.1% #REF! #REF! #REF! #REF! #REF!
#REF! 131,047 140,049 145,839 151,865 158,134 #REF! #REF! #REF! #REF! #REF!
#REF! 176,627 185,123 192,644 200,508 208,818 #REF! #REF! #REF! #REF! #REF!
#REF! 74% 76% 76% 76% 76% #REF! #REF! #REF! #REF! #REF!
21.06 26.24 36.03 32.67 32.79 34.36 45.07 42.07 38.33 31.09 24.13
#REF! 105.98 111.07 115.59 120.30 125.29 #REF! #REF! #REF! #REF! #REF!
0.83 1.40 1.14 1.23 1.20 1.19 #REF! #REF! #REF! #REF! #REF!
0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80
18,439 45,921 42,165 46,883 48,995 48,712 #REF! #REF! #REF! #REF! #REF!
20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000
18,044 18,524 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
38,102 29,615 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
20,058 11,091 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
39,813 38,973 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
77,915 68,588 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! 52,632 55,311 57,662 60,112 62,667 #REF! #REF! #REF! #REF! #REF!
7,207 2,289 3,435 2,113 2,153 2,194 2,153 2,194 2,236 2,279 2,323
11,125 32,307 43,488 36,066 38,336 27,047 32,006 19,047 19,089 15,132 15,176
9,625 - 27,200 21,100 23,330 12,000 17,000 4,000 4,000 - -
#REF! 87,228 129,434 116,941 123,931 103,908 #REF! #REF! #REF! #REF! #REF!
#REF! 54,921 58,746 59,775 62,265 64,861 #REF! #REF! #REF! #REF! #REF!
#REF! 87,228 102,234 95,841 100,601 91,908 #REF! #REF! #REF! #REF! #REF!
#REF! 87,228 129,434 116,941 123,931 103,908 #REF! #REF! #REF! #REF! #REF!
89,736 105,547 112,881 118,445 124,283 130,410 136,840 143,588 150,670 157,399 164,429
7.70% 8.46% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 4.50% 4.50%
3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
#REF! 131,047 140,049 145,839 151,865 158,134 #REF! #REF! #REF! #REF! #REF!
2007/2008 2008/2009 2009/2010 2010/2011 2011/2012 2012/2013 2013/2014 2014/2015 2015/2016 2016/2017 2017/2018
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
8,000 16,643 0 0 0 0 0 0 0 0 0
5,375 3,020 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
2,760 1,250 1000 4000 16,000 16,000 3,000 0 0 0 0
0 0 0 800 4,000 4,000 4,000 4,000 3,200 0 0
6,000 6,000 6,200 10,000 8,000 6,000 6,000 6,000 6,000 6,000 6,000
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,001
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
57,316 75,243 77,680 62,118 65,775 69,703 57,029 56,626 56,426 49,027 45,631
2003/04 2004/05 2005/06 2006/07 2007/08 2008/09 2009/10 2010/11 2011/12 2012/13 2013/14 2014/15 2015/16 2016/17 2017/18
15.86 12.49 15.91 21.06 26.24 36.03 32.67 32.79 34.36 45.07 42.07 38.33 31.09 24.13 ###
42.59 44.93 #REF! #REF! #REF! 105.98 111.07 115.59 120.30 125.29 #REF! #REF! #REF! #REF! #REF!
Summary - Projected Budget 2009-2010
Operating Cash Balance Loan Renewal
Surplus Opening Closing Balance Current Backlog
$000's $000's $000's $000's Ratio $000's
Projected Budget 2009-2010 - As per Resource Plan 2,165 23,588 32,630 36,509 1.16 6.47
Projected Budget 2009-2010 - Optional Parameters 1,830 23,588 42,165 36,033 0.92 8.30
60% rate
Target 1% Surplus 22,000 1.0 < $5m
revenue
2009-2010 2009-2010
Parameters Resource
Plan
Options
The Strategic Resource plan has been prepared from assumptions incorporated in 2011-2012
budget and other applicable assumptions to develop additional 3 years forecast.
The Plan can be assessed within the context of financial sustainability indicators whereby
satisfactory targets are set. Council monitors four main indicators which are as follows:
Liquidity - > 1
· Working capital ratio indicates short term viability issues with sufficient current assets to cover current liabilities.
A ratio of one or more means there is more cash and liquid assets than short term liabilities.
Renewal Gap
· The ratio of renewal and upgrade expenditure to depreciation compares replacement of existing assets to
depreciation. The percentage of renewal / upgrade capital expenditure is a long term indicator and averages
88% over the last 5 years. This trend indicates spending on existing assets is less than the depreciation rate.
· Municipal charge increases at 3% in line with CPI in the years following the budget year and garbage charge
increases at 4% in line with CPI in the years following the budget year dependent on environmental assurance
and new processing contracts.
· Other Fees and Charges including statutory charges to increase by CPI in the years following the budget.
· Salaries estimate include EBA increases, banding increases growth positions and service changes linked to
external funding sources.
· Materials and Plant & Vehicles expenditure has increased by CPI and General Works by CPI per year after the
budget year in addition to lump sum increments to incorporate growth.
· Interest Expense has increased according to the borrowing strategy. Council will borrow in line with expenditure
on nominated major projects as listed below.
· Depreciation has increased between 4.2% and 5.5% to cover new assets constructed and vested in Council.
· Provision for Corio Landfill will continue until 2013 when operations at the site will be completed and the site will
be rehabilitated.
· Asset Sales include sales reasonably expected to eventuate.
· Recognition of Infrastructure from Developers is projected at $15M p.a. for 2012-2013 through to 2014-2015.
3-9
2010-2011 Budget - City of Greater Geelong
Balance Sheet
· Debtors have increased $0.3M per year in line with increased rates collectables after 2011-2012.
· Creditors have increased $0.4M per year in line with increased cost of goods after 2011-2012.
· Employee Benefit Provisions have increased $1.0M per year.
Capital Expenditure
2011-2012 2012-2013 2013-2014 2014-2015
Major Initiatives $'000 $'000 $'000 $'000
Projects 48,943 45,340 45,731 53,726
Civic Accommodation 20,000 0 0 0
Geelong Library & Heritage Centre 0 1,500 10,000 8,500
Yarra St Pier 0 5,300 5,300 4,300
Armstrong Creek / Projects General 0 7,000 2,000 1,000
Geelong Ring Road Employment Precinct 3,024 4,667 600 600
Leopold Community Hub 500 8,000 7,200 0
Ocean Grove - Children & Family Centre 3,000 5,250 0 0
North Shore Family Hub 0 3,000 3,000 0
Ocean Grove Infrastructure Plan 1,500 4,500 0 0
Corio Landfill Rehabilitation 1,820 3,850 5,130 0
Plus Carry Over from previous year 24,000 17,000 19,000 18,000
Less Carry Over to next year (17,000) (19,000) (18,000) (17,000)
Capital Expenditure 85,787 86,407 79,961 69,126
Loans
Loans are tied to expenditure on specific projects
2011-2012 2012-2013 2013-2014 2014-2015
$'000 $'000 $'000 $'000
Civic Accommodation 20,000 0 0 0
Geelong Ring Road Employment Precinct 2,700 0 0 0
Ocean Grove Infrastructure Plan 1,000 1,000 0 0
Community Facilities 3,500 13,800 8,700 2,500
City Library 0 1,500 10,000 8,500
Armstrong Creek 0 2,000 500 1,000
Corio Landfill Rehabilitation 0 2,850 4,130 0
Total Loans 27,200 21,150 23,330 12,000
3-10
2010-2011 Budget - City of Greater Geelong
BUDGETED INCOME STATEMENT
4 Year Plan
Budget Projection Budget Plan Plan Plan
2015-2016 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020
$'000 $'000 $'000 $'000 $'000 $'000
RECURRENT INCOME
Rates and Charges 192,223 193,384 202,724 210,949 219,545 228,617
Government Grants 47,090 37,094 46,046 47,197 48,377 49,587
User Charges 50,562 48,891 52,544 53,858 55,204 56,584
Other Fees and Charges 10,939 11,481 11,398 11,683 11,975 12,274
Sundry Income 6,246 6,595 6,246 6,402 6,562 6,726
Interest Investments 1,601 1,966 1,901 1,900 1,900 2,200
RECURRENT EXPENDITURE
Employee Related
Salaries 130,543 129,049 137,766 143,488 149,443 155,639
Workcover 2,288 1,998 2,283 2,351 2,422 2,495
132,831 131,047 140,049 145,839 151,865 158,134
Goods and Services
General Works - Materials 8,209 8,375 7,922 8,120 8,323 8,531
General Works - Plant, Vehicle Costs 7,628 7,191 7,237 7,418 7,603 7,794
General Works - External Services 78,836 85,273 83,201 86,729 88,790 91,347
Administration 8,110 8,371 8,136 8,339 8,548 8,761
Interest Expense 3,487 2,916 3,652 4,321 4,604 4,600
Professional Services 5,951 7,953 4,253 4,359 4,468 4,580
Utilities 9,222 9,642 9,552 9,791 10,036 10,286
121,443 129,721 123,953 129,077 132,372 135,899
NON-RECURRENT INCOME
Capital Grants and Income 21,533 31,555 22,293 14,190 6,891 5,130
Developer Cash Contributions 3,010 3,010 5,980 7,740 10,940 11,290
Gain / (Loss) on Sale of Property 1,679 7,535 1,742 7,344 30 30
Recognition of Infrastructure 34,500 34,500 34,500 30,000 15,000 15,000
Total Non-Recurrent Income 60,722 76,600 64,515 59,274 32,861 31,450
NON-RECURRENT EXPENDITURE
Loss on Disposal of Infrastructure 5,290 5,290 5,290 3,000 3,000 3,500
Unfunded Superannuation 0 0 0 9,000 0 0
Disbursements 0 0 6,000 0 0 3,000
Total Non-Recurrent Expenditure 5,290 5,290 11,290 12,000 3,000 6,500
3-4
2016-2017 Budget - City of Greater Geelong
STANDARD CAPITAL WORK STATEMENT
4 Year Plan
2011-2012 Budget 2012-2013 Plan 2013-2014 Plan 2014-2015 Plan
TOTAL 78,714 8,780 69,934 88,407 29,456 58,951 78,961 15,385 63,576 68,126 12,959 55,167
Reconciliation
Design 7 7 0 0 0 0
Construction 66 66 0 0 0 0
Asset Sales Income 0 0 0 0 0
Plant Replacement Program (1,735) 1,735 (2,013) 2,013 (2,053) 2,053 (2,094) 2,094
Landfill Provision (1,820) 0 (1,820) 0 0 0
Carry over from Previous Year 24,000 0 24,000 17,000 0 17,000 19,000 0 19,000 18,000 0 18,000
Carry over to Next Year (17,000) 0 (17,000) (19,000) 0 (19,000) (18,000) 0 (18,000) (17,000) 0 (17,000)
TOTAL 5,253 (1,663) 6,915 (2,000) (2,013) 13 1,000 (2,053) 3,053 1,000 (2,094) 3,094
OPERATING STATEMENT TOTAL 83,967 7,118 76,849 86,407 27,443 58,964 79,961 13,332 66,629 69,126 10,865 58,261
3-4
2011-2012 Budget - City of Greater Geelong
STANDARD STATEMENT OF CASH FLOW
4 Year Plan
Budget Projection Budget Plan Plan Plan
2010-2011 2010-2011 2011-2012 2012-2013 2013-2014 2014-2015
$000's $000's $000's $000's $000's $000's
Cash Flows from Operating Activities
Receipts
General Rates 140,227 141,366 150,132 158,807 167,988 177,757
GST Recoveries on Operating Transactions 5,627 5,627 5,627 5,627 5,627 5,627
Payments
Employee Costs (93,810) (98,328) (101,302) (108,761) (114,535) (120,676)
General Works / Utilities / Disbursements (88,206) (102,242) (95,309) (95,606) (98,327) (101,729)
Net Cash Inflow from Operating Activities 45,563 36,396 47,824 48,628 50,696 52,689
Proceeds from Sale of Land and Buildings 2,850 529 1,700 100 100 100
Proceeds from Sale of Plant and Equipment 1,760 1,760 1,735 2,013 2,053 2,094
Income for Capital Expenditure 16,804 32,307 7,118 27,443 13,332 10,865
Net Cash Outflow from Investing Activities (43,507) (44,590) (73,784) (55,701) (63,326) (54,967)
Net Cash Inflow/(Outflow) from Financial Activities (4,525) (4,525) 22,204 11,791 14,742 1,995
Net Increase / (Decrease) in Cash Held (2,469) (12,719) (3,756) 4,718 2,112 (283)
Cash at the Beginning of the Financial Year 43,047 58,640 45,921 42,165 46,883 48,995
Cash at the end of the Financial Year 40,578 45,921 42,165 46,883 48,995 48,712
Net Cash (Deficit ) / Surplus 9,066 14,412 (11,551) (18,624) (31,254) (33,532)
3-5
2011-2012 Budget - City of Greater Geelong
STANDARD BALANCE SHEET
4 Year Plan
Budget Projection Budget Plan Plan Plan
2010-2011 2010-2011 2011-2012 2012-2013 2013-2014 2014-2015
*Year End 30 June Balances $000's $000's $000's $000's $000's $000's
Current Assets
Prepayments 82 82 86 90 90 90
Inventories 514 514 494 543 559 576
Current Liabilities
Non-Current Assets
Property, Plant & Equipment 1,601,626 1,646,389 1,703,595 1,744,991 1,784,382 1,814,432
Investments 7,387 8,694 8,694 8,694 8,694 8,694
Receivables 925 925 916 907 898 889
Non-Current Liabilities
Ratepayers Equity
3-6
2011-2012 Budget - City of Greater Geelong
Projection Budget Plan Plan Plan Plan Plan Plan Plan Plan Plan
Blue = input 2008/09 2009/10 2010/11 2011/12 2012/13 2013/14 2014/15 2015/16 2016/17 2017/18 2018/19
$000's $000's $000's $000's $000's $000's $000's $000's $000's $000's $000's COMMENTS
DETAILED OPERATING STATEMENT
RECURRENT INCOME
Growth % 2.4% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0%
Rate increase % 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 3.5% 3.5% 3.5%
Total % Increase 6.4% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 4.5% 4.5% 4.5%
Rates 97,922 104,835 110,077 115,581 121,360 127,428 133,799 140,489 146,811 153,417 160,321 Increase based on Rating Strategy
Interest On Rates 370 385 250 250 250 250 250 250 250 250 250
Supplementary 1,450 500 300 300 300 300 300 300 300 300 300
Garbage 16,757 17,601 18,305 19,037 19,799 20,591 21,414 22,271 23,162 24,088 25,052
Rates Waiver - 25 - 1 - 25 - 25 - 25 - 25 - 25 - 25 - 25 - 25 - 25
Municipal Charge 7,625 8,046 8,368 8,703 9,051 9,413 9,789 10,181 10,588 11,012 11,452
TOTAL RATES & CHARGES 124,099 131,366 137,275 143,845 150,734 157,956 165,527 173,466 181,086 189,042 197,350 Gross Rate & Charges Income
Grants 0.944% 0.944% 0.944%
Inflation 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Increase in line with inflation predictions
User Charges 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Increase in line with market prices & volume increases
Interest Income 6.50% 6.50% 6.50% Long term interest Forecast & Average Cash
Average Cash Balance 19,000 19,000 19,000 Est average cash balance
Plant & Equipment Disposals
Proceeds on Sale of Plant & Equipment (1,851) (2,039) (1,853) (1,735) (2,013) (2,053) (2,094) (2,136) (2,179) (2,223) (2,267)
WDV of Plant & Equipment 1,933 1,830 1,742 1,631 1,892 1,930 1,969 2,008 2,048 2,089 2,131
(Profit) / Loss on Sale 82 (209) (111) (104) (121) (123) (126) (128) (131) (133) (136)
RECURRENT EXPENDITURE
Salary Related Costs - EBA 4.4% 3.5% 3.5% 3.5% 4.5% 4.5% 4.5% 4.5% 4.5% 4.5%
Salary Related Costs - Banding 0.8% 0.8% 0.8% 0.8% 0.8% 0.8% 0.8% 0.8% 0.8% 0.8%
Salary Related Costs - Total 5.2% 4.3% 4.3% 4.3% 5.3% 5.3% 5.3% 5.3% 5.3% 5.3% Based on EBA
Materials 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Increase in line with inflation predictions
Plant, Equipment, Vehicle Costs 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Increase in line with inflation predictions
External Services 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Increase in line with inflation predictions
Administration 3.0% 4.0% 4.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Lower due to reduced level of borrowings & interest
Professional Services 3.0% 4.0% 4.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Increase in line with inflation predictions
Utilities 3.0% 4.0% 4.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Increase in line with inflation predictions
BALANCE SHEET
Receivables (Current) 98.0% 98.0% 98.0% 98.0% 98.0%
Collection Rate 99.1% 99.1% 99.1% 99.1% 99.1% 99.1% 99.1% 99.1% 99.1% 99.1% 99.1%
Current Rate Debtors Uncollected 881 944 991 1,040 1,092 1,147 1,204 1,264 1,321 1,381 1,443
Arrear Rate Debtors Uncollected 1,009 1,009 1,009 1,009 1,009 1,009 1,009 1,009 1,009 1,009 1,009
Total Rate Debtors 1,890 1,953 2,000 2,049 2,101 2,156 2,213 2,273 2,330 2,390 2,452
Other Debtors 3,900 3,822 3,746 3,671 3,597 Based on performance targets in Rate Manager KPI & SRC
Provision/Creditors
Ratio of Components to Expenditure :
Employee Entitlements to Salaries 8.5% 8.5% 8.5% 8.5% 8.5% 8.5% 8.5% 8.5% 8.5% 8.5% 8.5% Ratio based on last known actuals
Employee Entitlements Movement in line with ratio and last actual
Loan Interest to Total Loans 0.4% 0.4% 0.4% Ratio based on last known actuals
Accrued Loan Interest 113 156 141
Trade Creditors to Goods and Services 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 Ratio based on last known actuals
Trade Creditors 23,350 22,312 23,234 23,827 24,462 #REF! #REF! #REF! #REF! #REF! #REF! Movement in line with ratio and last actual
Unearned Income 544 561 577 595 613 631 650 669 689 710 731 Increase in line with inflation
Other Creditors 171 176 181 187 192 198 204 210 217 223 230 Increase in line with inflation
TOTAL CREDITORS 24,178 23,204 24,134 24,609 25,267 #REF! #REF! #REF! #REF! #REF! #REF!
Loans
Underlying Debt Balance of Based on Debt Management Strategy
Opening Balance 14,730 26,237 36,033 32,671 32,790 34,364 45,066 42,069 38,333 31,094 24,128 Based on Loan Schedules of existing loans
Proceeds 12,675 12,500 0 4,000 7,000 17,000 4,000 4,000 0 0 0
Repayments -1,168 -2,704 -3,362 -3,881 -5,426 -6,298 -6,998 -7,736 -7,239 -6,967 -6,906 -4,767
Repayments Market Square 0 0 0
Refinanced 0 0 0
Closing Balance 26,237 36,033 32,671 32,790 34,364 45,066 42,069 38,333 31,094 24,128 17,222 Assumes 1030 loan continues
Current 2,704 3,362 3,881 5,426 6,298 6,998 7,736 7,239 6,967 6,906 4,767 Next years payment
Non-Current 23,533 32,671 28,790 27,364 28,066 38,069 34,333 31,094 24,128 17,222 12,454
26,237 36,033 32,671 32,790 34,364 45,066 42,069 38,333 31,094 24,128 17,222
Provisions
Long Service Leave to Employee Costs 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5%
Long Service Leave 17,691 18,907 19,688 20,502 21,348 #REF! #REF! #REF! #REF! #REF! #REF!
Annual Leave 11,139 11,904 12,396 12,909 13,441 #REF! #REF! #REF! #REF! #REF! #REF!
Disclosed as - Current 7,500 7,800 8,000 8,200 8,500 8,800 9,100 9,400 9,700 10,000 10,300
Disclosed as - Non-Current 10,191 11,107 11,688 12,302 12,848 #REF! #REF! #REF! #REF! #REF! #REF!
Total Provisions - Current 18,639 19,704 20,396 21,109 21,941 #REF! #REF! #REF! #REF! #REF! #REF!
Total Provisions - Non-Current 10,191 11,107 11,688 12,302 12,848 #REF! #REF! #REF! #REF! #REF! #REF!
Depreciation (52,632) (55,311) (57,662) (60,112) (62,667) #REF! #REF! #REF! #REF! #REF! #REF!
Increase Provision from Expense
Revaluation 41,800
Closing WDV 1,363,626 1,457,664 1,485,308 1,488,000 1,491,904 #REF! #REF! #REF! #REF! #REF! #REF!
Accumulated Surplus
Budget 2000/01 1
10 Year Financial Plan
Assumptions
07/08 08/09 09/10 10/11 11/12 12/13 13/14 14/15 15/16 16/17 17/18
New loan funding
Civic Accomodation 2,760 0 0 13,000
Less Asset Sales -2,760
Library 0 4,000 4,000 4,000 4,000 4,000
Armstrong Creek 3,000
Over 20 years 0 0 0 0 4,000 7,000 17,000 4,000 4,000
Total New Loans 3,125 12,675 12,500 0 4,000 7,000 17,000 4,000 4,000 0
Assumptions
Income
Rates (Incudes growth approx 1%) 4.00% 3.00% 6.50% 6.50% 5.00% 5.50% 5.50% 5.00% 5.00% 5.00%
Garbage 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
Waste 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
Expenditure
Salary Related Costs 5.20% 5.00% 5.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00%
Materials 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00%
Plant, Equipment, Vehicle Costs 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00%
External Services 5.00% 4.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00%
Administration 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
Professional Services 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
Utilities 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
Total Expenditure 71,487 55,680 59,038 65,775 69,703 57,029 56,626 56,426 49,027 45,631 46,237
Plus Carry over from prior year 28,836 25,080 3,080 0 0 0 0 0 0 0 0
Less Carry Over to next year (25,080) (3,080) 0 0 0 0 0 0 0 0 0
Total Expenditure Incl carryover 75,243 77,680 62,118 65,775 69,703 57,029 56,626 56,426 49,027 45,631 46,237
Total Expenditure incl Landfill 77,583 78,680 64,118 70,535 69,703 57,029 56,626 56,426 49,027 45,631 46,237
Capital Income
Leisurelink & Bellarine Pool State Grant 1,350
Base Core Projects 4,295 3,586 3,586 3,586 3,586 3,586 3,586 3,586 3,586 3,586 3,586
Cycling Criterium 500
Courthouse Redevelopment 1,348 5,217
Geelong Marine Industry Precinct 150
Civic Accommodation
Vines Rd 1,060
Carryover 2,839
Waurn Ponds Library 3,000
New Projects 1,780 1,242
Future new projects 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Landfill Income 1,000 1,000 500
Leopold Community Hub (Library) 4,000 2,000
Total Capital Income 12,612 11,695 13,146 6,586 4,586 4,586 4,586 4,586 4,586 4,586 4,586
Developer Contributions
Untied contributions 1,920 1,100 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Leopold Community Hub Stage 1 (Library) 0 0
Mt Duneed / Armstrong Creek
Total Developer Contributions 1,920 1,100 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Plant & Equipment Sales 1,851 2,039 1,853 1,735 2,013 2,053 2,094 2,136 2,179 2,223 2,267
Inflows
Recurrent Income
Capital Grants Asset Sales
Total Inflows
Outflows
Recurrent Operating Expenditure
Non Recurrent Operating Expenditure
Capital Expenditure
Total Outflows
DEBT POSITION
Opening Net Debt
Net Cash Generated / (Applied)
Closing Net Debt
Loans
Westpac No.1
Westpac No.2
CBA No.1
Post Office and Gaol
New Loan
Total Expenditure incl Landfill 79,923 79,780 66,118 75,295 69,703 57,029 56,626 56,426 49,027 45,631 46,237
Capital Income
Leisurelink & Bellarine Pool State Grant 1,350
Base Core Projects 4,295 3,586 3,586 3,586 3,586 3,586 3,586 3,586 3,586 3,586 3,586
Cycling Criterium 500
Courthouse Redevelopment 1,348 5,217
Geelong Marine Industry Precinct 150
Civic Accommodation
Vines Rd 1,060
Carryover 2,839
Waurn Ponds Library 3,000
New Projects 1,780 1,242
Future new projects 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Landfill Income 1,000 1,000 500
Leopold Community Hub (Library) 4,000 2,000
Total Capital Income 12,612 11,695 13,146 6,586 4,586 4,586 4,586 4,586 4,586 4,586 4,586
Developer Contributions
Untied contributions 1,920 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Leopold Community Hub Stage 1 (Library) 0 0
Mt Duneed / Armstrong Creek
Total Developer Contributions 1,920 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Plant & Equipment Sales 1,851 2,039 1,853 1,735 2,013 2,053 2,094 2,136 2,179 2,223 2,267
Net Surplus from Operations #REF! #REF! #REF! #REF! #REF! 56,703 55,055
Written Down Value of Assets Sold 3,938 #REF! #REF! #REF! #REF! #REF! 7,418
Net Repayment of Borrowings (11,254) (3,371) 3,414 3,413 667 4,487 11,507
Net Cash Inflows (Outflows) #REF! #REF! #REF! #REF! #REF! #REF! #REF!
2.9.1
2005-2006 Budget - City of Greater Geelong