BUDGET REVIEW 2 (BR2) FOR THE 2024/25 FINANCIAL YEAR · Attachment 4 - BR2 Budget Financial Statements 2024-25

Attachment 4
                                               2024/25 Budget Statements                                                                                                                                              STATEMENT OF CASHFLOWS
                                                                                                                                                                                                                           For the period ending 30 June
                                                                         Original
                                                         Actual                          BR1             BR2                                                                             Forecast
                                                                         Budget
                                                         2024            2025            2025            2025            2026            2027            2028            2029             2030            2031             2032            2033            2034
   Annual Result - Total Council
                                                         $,000           $,000           $,000           $,000           $,000           $,000           $,000           $,000            $,000           $,000            $,000           $,000           $,000
Cash Flows from Operating Activities
  Receipts from Customers                           $      123,206 $      121,393 $       121,305 $       127,953 $       126,425 $       131,406 $       136,002 $       140,380 $         144,498 $      148,583 $         152,822 $      157,054 $       161,536
  Payments to Suppliers and Employees              ($     116,690) ($    115,933) ($     117,261) ($     133,804) ($     122,312) ($     125,394) ($     128,983) ($     132,517) ($       135,872) ($    139,612) ($       143,346) ($    147,132) ($     151,090)
  Payments for land held as inventory               $          -    $         -    $          -    $          -    $          -    $          -    $          -    $          -    $            -    $         -    $            -    $         -    $          -
  Proceeds from sale of land held as inventory      $          -    $         -    $          -    $          -    $          -    $          -    $          -    $          -    $            -    $         -    $            -    $         -    $          -
  Dividend Received                                 $        3,726 $        4,100 $         4,100 $         4,100 $         4,100 $         4,100 $         4,100 $         4,100 $           4,100 $        4,100 $           4,100 $        4,100 $         4,100
  Interest Received                                 $        8,034 $        5,000 $         5,000 $         5,561 $         5,802 $         4,924 $         4,585 $         4,325 $           4,059 $        4,081 $           4,052 $        4,018 $         4,044
  Rental ncome                                      $        1,665 $        2,264 $         2,263 $         2,319 $         2,287 $         2,344 $         2,401 $         2,456 $           2,508 $        2,558 $           2,610 $        2,661 $         2,715
  Non-Capital Grants and Contributions              $        4,070 $        5,443 $         6,624 $         7,510 $         7,344 $         7,515 $         7,676 $         7,822 $           7,958 $        8,086 $           8,216 $        8,344 $         8,480
  Borrowing Costs                                  ($         187) ($        748) ($         748) ($         718) ($         682) ($         928) ($         883) ($         924) ($           972) ($        912) ($           852) ($        786) ($         719)
  Net Cash Flow from Operating Activities           $       23,824   $     21,519    $     21,283    $     12,921    $     22,963    $     23,966    $     24,897    $     25,642    $      26,280    $     26,884     $     27,602    $     28,260    $     29,066

Cash flows from Investing Activities
  Payments for property, plant and equipment       ($      69,757) ($     45,246) ($     134,136) ($     124,767) ($      56,518) ($      34,509) ($      33,139) ($      34,575) ($        28,908) ($     32,635) ($        33,756) ($     30,799) ($      32,905)
  Grants, subsidies, contributions and donations    $       35,447   $     15,725    $     94,182    $     98,564    $     16,575    $      7,464    $      6,482    $      6,792    $       4,732    $      4,732     $      4,774    $      4,794    $      3,982
  Proceeds from sale of property, plant and equpment $        140    $           -   $           -   $           -   $           -   $           -   $           -   $           -   $            -   $           -    $           -   $           -   $           -
  Other cash flows from investing activities        $         125    $           -   $           -   $           -   $           -   $           -   $           -   $           -   $            -   $           -    $           -   $           -   $           -

  Net Cash Flow from Investing Activities          ($      34,045) ($     29,521) ($      39,954) ($      26,203) ($      39,944) ($      27,045) ($      26,657) ($      27,783) ($        24,176) ($     27,903) ($        28,982) ($     26,005) ($      28,923)

Cash Flows from Financing Activities
  Proceeds from borrowings                          $        1,549 $        5,000 $         5,000 $           -    $        5,000 $           -    $        2,250 $         2,500 $             -    $         -    $            -    $         -    $          -
  Repayment of borrowings                          ($       1,709) ($      1,162) ($       1,162) ($       1,191) ($       1,227) ($       1,407) ($       1,450) ($       1,576) ($         1,713) ($      1,773) ($         1,832) ($      1,899) ($       1,934)
  Net Cash Flow from Financing Activities          ($         160)   $      3,838    $      3,838 ($       1,191)    $      3,773 ($       1,407)    $       800     $       924 ($          1,713) ($      1,773) ($         1,832) ($      1,899) ($       1,934)

Total Cash Flows
Net change in Cash and Cash Equivalent held        ($      10,381) ($      4,163) ($      14,832) ($      14,474) ($      13,208) ($       4,485) ($         960) ($       1,217)    $         390 ($       2,791) ($         3,212)   $       357 ($        1,790)
Opening Cash and Cash Equivalents                   $      116,507   $     88,900    $    104,994    $    106,126    $     91,652    $     78,444    $     73,959    $     72,999    $      71,782    $     72,173     $     69,381    $     66,169    $     66,526
Closing Cash and Cash Equivalents                   $      106,126   $     84,737    $     90,162    $     91,652    $     78,444    $     73,959    $     72,999    $     71,782    $      72,173    $     69,381     $     66,169    $     66,526    $     64,736

ed NOOSA Attachment 4 ge ro f 2024/25 Budget Statements STATEMENT OF CASHFLOWS ouncl For the period ending 30 June IReey sad SY BR2 Renee Budget : yA.) 2025 2025 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Annual Result - Total Council $,000 $,000 $,000 $,000 $,000 $,000 $,000 $,000 $,000 $,000 $,000 $,000 $,000 Cash Flows from Operating Activities Receipts from Customers $ 123,206 $ 121,393 $ 121,305 $ 127,953 $ 126,425 $ 131,406 $ 136,002 $ 140,380 $ 144,498 $ 148,583 $ 152,822 $ 157,054 $ 161,536 Payments to Suppliers and Employees ($ 116,690) ($ 115,933) ($ 117,261) ($ 133,804) ($ 122,312) ($ 125,394) ($ 128,983) ($ 132,517) ($ 135,872) ($ 139,612) ($ 143,346) ($ 147,132) ($ 151,090) Payments for land held as inventory $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Proceeds from sale of land held as inventory $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Dividend Received $ 3,726 §$ 4,100 $ 4,100 $ 4,100 $ 4,100 $ 4,100 $ 4,100 $ 4,100 $ 4,100 $ 4,100 $ 4,100 $ 4,100 $ 4,100 Interest Received $ 8,034 ¢ 5,000 $ 5,000 $ 5,561 $ 5,802 $ 4,924 $ 4,585 $ 4,325 $ 4,059 $ 4,081 $ 4,052 $ 4,018 $ 4,044 Rental ncome $ 1,665 $ 2,264 $ 2,263 $ 2,319 $ 2,287 $ 2,344 $ 2,401 $ 2,456 $ 2,508 $ 2,558 $ 2,610 $ 2,661 $ 2,715 Non-Capital Grants and Contributions $ 4,070 $ 5,443 $ 6,624 $ 7,510 $ 7,344 $ 7515 $ 7,676 $ 7,822 $ 7,958 $ 8,086 $ 8.216 $ 8,344 $ 8,480 Borrowing Costs ($ 187) ($ 748) ($ 748) ($ 718) ($ 682) ($ 928) ($ 883) ($ 924) ($ 972) ($ 912) ($ 852) ($ 786) ($ 719) Net Cash Flow from Operating Activities $ 23,824 $ 21,519 $ 21,283 $ 12,921 $ 22,963 $ 23,966 $ 24,897 $ 25,642 $ 26,280 $ 26,884 $ 27,602 $ 28,260 $ 29,066 Cash flows from Investing Activities Payments for property, plant and equipment ($ 69,757) ($ 45,246) ($ 134,136) ($ 124,767) ($ 56,518) ($ 34,509) ($ 33,139) ($ 34,575) ($ 28,908) ($ 32,635) ($ 33,756) ($ 30,799) ($ 32,905) Grants, subsidies, contributions and donations $ 35,447 $ 15,725 §$ 94,182 $ 98,564 $ 16,575 $ 7464 $ 6482 $ 6,792 $ 4,732 $ 4,732 $ 4,774 $ 4,794 $ 3,982 Proceeds from sale of property, plant and equpmen $ 140 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Other cash flows from investing activities $ 125 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Net Cash Flow from Investing Activities ($ 34,045) ($ 29,521) ($ 39,954) ($ 26,203) ($ 39,944) ($ 27,045) ($ 26,657) ($ 27,783) ($ 24,176) ($ 27,903) ($ 28,982) ($ 26,005) ($ 28,923) Cash Flows from Financing Activities Proceeds from borrowings $ 1,549 $ 5,000 $ 5,000 $ - $ 5,000 $ - $ 2,250 $ 2,500 $ - $ - $ - $ - $ - Repayment of borrowings ($ 1,709) ($ 1,162) ($ 1,162) ($ 1,191) ($ 1,227) ($ 1,407) ($ 1,450) ($ 1,576) ($ 1,713) ($ 1,773) ($ 1,832) ($ 1,899) ($ 1,934) Net Cash Flow from Financing Activities ($ 160) $ 3,838 $ 3,838 ($ 1,191) $ 3,773 ($ 1,407) $ 800 $ 924 ($ 1,713) ($ 1,773) ($ 1,832) ($ 1,899) ($ 1,934) Total Cash Flows Net change in Cash and Cash Equivalent held ($ 10,381) ($ 4,163) ($ 14,832) ($ 14,474) ($ 13,208) ($ 4,485) ($ 960) ($ 1,217) $ 390 ($ 2,791) ($ 3,212) $ 357 ($ 1,790) Opening Cash and Cash Equivalents $ 116,507 $ 88,900 $ 104,994 $ 106,126 $ 91,652 $ 78,444 $ 73,959 $ 72,999 $ 71,782 $ 72,173 $ 69,381 $ 66,169 $ 66,526 Closing Cash and Cash Equivalents $ 106,126 $ 84,737 $ 90,162 | $ 91,652 $ 78,444 $ 73,959 $ 72,999 $ 71,782 $ 72,173 $ 69,381 $ 66,169 $ 66,526 $ 64,736