2014-01-13 Deamalgamation Report Attachment

Page 18 of 95

SE] EL  td                 Proposed Allocation Method
                            Finance Branch to determine allocation based on physical location with assistance
                            from Other Departments as and when required

                            Unitywater shareholder loan - estimate of share of RAB as at 30 June 2010
 Intangibles — Computer     Principle 1 - Physical location when the software can be identified as solely servicing a
Software                    specific region
                            Principle 2 — Due to the nature of software licencing, the allocation will be determined
                            by the supplier of the license. The allocation will ensure that SCC receives all licenses
                            required to continue operating with NSC acquiring any additional license required.
                            Principle 3 — Where a service agreement is required for Noosa to access SCC software,
                            allocation will be 100% SCC

                            Working group required to identify and provide an agreed schedule of allocated
                            software that reconciles to the balance sheet as at 31 December 2013

 Trade and other payables   SCC to honour all outstanding payments to suppliers for work completed prior to the
                            1st of January 2014.

                            Closing cash balance as at the 31st of December to be adjusted as though all payments
                            have been made.

                            Total debt allocated made up of:
                            1) Opening debt balance of each Council as at 30 June 2012 determined by QTC
                            analysis.
                            2) plus new borrowings in proportion to the value of capital expenditure made by the
                            existing council in the new council and continuing council geographical area
                            3) less redemptions made by the existing council in proportion to the value of
                            borrowings held by the new council and continuing council
 Employee Provisions        Based on the calculated employee annual leave and long service leave provisions
                            attaching to transferring staff as at 31 December 2013.
 Other provisions           Landfill rehabilitation — based on the calculated landfill rehabilitation provision for the
                            Eumundi Road landfill as at 31 December 2013.

                            Quarries - based on the calculated quarry rehabilitation provision for the Ringtail quarry
                            as at 31 December 2013.

                            Other provisions - Allocated in accordance with the underlying transaction.
 Other assets and liabilities | Based on balance of other assets and liabilities as at 31 December 2013 allocated in
                            accordance with the underlying transaction.

 Timing of Actual Balance Sheet Allocation

 Page 3 of 9                                                                                               v5.0

                                                                                                    Page 18 of 95