jagomart
digital resources
picture1_Estimate Template Excel 40763 | 2021 22 Wa State Budget Bp2 Data Small Business Development Corp


 201x       Filetype XLSX       File size 0.02 MB       Source: www.ourstatebudget.wa.gov.au


File: Estimate Template Excel 40763 | 2021 22 Wa State Budget Bp2 Data Small Business Development Corp
sheet 1 aip asset investment program estimated estimated 2020 8209 21 2021 8209 22 2022 8209 23 2023 8209 24 2024 8209 25 total cost expenditure estimated budget forward forward ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: AIP
ASSET INVESTMENT PROGRAM







Estimated Estimated 2020‑21 2021‑22 2022‑23 2023‑24 2024‑25
Total Cost Expenditure Estimated Budget Forward Forward Forward

to 30‑6-21 Expenditure Estimate Estimate Estimate Estimate
$'000 $'000 $'000 $'000 $'000 $'000 $'000








WORKS IN PROGRESS






Furniture and Office Equipment Replacement 120 100 100 20 - - -
2020‑21 Program
COMPLETED WORKS






Furniture and Office Equipment Replacement






2018‑19 Program 120 120 55 - - - -
2019‑20 Program 120 120 120 - - - -
NEW WORKS






Furniture and Office Equipment Replacement






2021‑22 Program 120 - - 120 - - -
2022‑23 Program 120 - - - 120 - -
2023‑24 Program 120 - - - - 120 -
2024‑25 Program 120 - - - - - 120
Total Cost of Asset Investment Program 840 340 275 140 120 120 120
FUNDED BY






Capital Appropriation

60 60 60 60 60
Drawdowns from the Holding Account

60 60 60 60 60
Internal Funds and Balances

155 20 - - -
Total Funding

275 140 120 120 120









Sheet 2: IS
INCOME STATEMENT







2019‑20 2020‑21 2020‑21 2021‑22 2022‑23 2023‑24 2024‑25


Estimated Budget Forward Forward Forward
Actual Budget Actual Estimate Estimate Estimate Estimate
$'000 $'000 $'000 $'000 $'000 $'000 $'000
COST OF SERVICES






Expenses






Employee benefits (b) 7,046 7,798 7,642 8,121 7,754 7,739 7,842
Supplies and services 5,013 6,488 5,510 7,829 5,617 5,206 5,303
Accommodation 1,185 1,382 1,382 1,450 1,481 1,515 1,515
Depreciation and amortisation 137 153 153 153 153 153 153
Finance and interest costs 1 1 1 3 2 2 2
Other expenses 598 216 172 246 202 282 252
TOTAL COST OF SERVICES 13,980 16,038 14,860 17,802 15,209 14,897 15,067
Income






Sale of goods and services 366 292 292 292 292 292 292
Other revenue 44 30 30 30 30 30 30
Total Income 410 322 322 322 322 322 322
NET COST OF SERVICES (c) 13,570 15,716 14,538 17,480 14,887 14,575 14,745
INCOME FROM STATE GOVERNMENT






Service appropriations 13,881 15,325 15,222 16,744 14,676 14,399 14,569
Resources received free of charge 130 190 190 190 190 190 190
Royalties for Regions Fund:






Regional Community Services Fund - 180 180 - - - -
Other revenues 41 - - - - - -
TOTAL INCOME FROM STATE GOVERNMENT 14,052 15,695 15,592 16,934 14,866 14,589 14,759
SURPLUS/(DEFICIENCY) FOR THE 482 -21 1,054 -546 -21 14 14
PERIOD








(a) Full audited financial statements are published in the Corporation's Annual Report.






(b) The full time equivalents for 2019 20 Actual, 2020 21 Estimated Actual and 2021 22 Budget Estimate are 55, 60 and 64 respectively.






(c) Changes to Treasurer's instruction 1102: Statements of Comprehensive Income since the 2020 21 Budget have moved all revenue received from Government out of the calculation of Net Cost of Services and into Income from State Government. This may have increased the Net Cost of Services compared to previously published Budgets.







Sheet 3: SFP
STATEMENT OF FINANCIAL POSITION (a)







2019‑20 2020‑21 2020‑21 2021‑22 2022‑23 2023‑24 2024‑25


Estimated Budget Forward Forward Forward
Actual Budget Actual Estimate Estimate Estimate Estimate
$'000 $'000 $'000 $'000 $'000 $'000 $'000
CURRENT ASSETS






Cash assets 4,099 3,908 4,978 4,442 4,426 4,445 4,464
Restricted cash - - 25 - - - -
Holding account receivables 60 60 60 60 60 60 60
Receivables 230 230 230 230 230 230 230
Other 351 331 331 311 291 271 264
Total current assets 4,740 4,529 5,624 5,043 5,007 5,006 5,018
NON‑CURRENT ASSETS






Holding account receivables 829 937 937 1,045 1,153 1,261 1,369
Property, plant and equipment 138 339 319 342 309 276 223
Intangibles 57 12 12 12 12 12 32
Total non‑current assets 1,024 1,288 1,268 1,399 1,474 1,549 1,624
TOTAL ASSETS 5,764 5,817 6,892 6,442 6,481 6,555 6,642
CURRENT LIABILITIES






Employee provisions 1,515 1,515 1,515 1,515 1,515 1,515 1,515
Payables 41 41 41 41 41 41 41
Borrowings and leases 12 12 12 12 12 12 12
Other 334 334 334 334 334 334 334
Total current liabilities 1,902 1,902 1,902 1,902 1,902 1,902 1,902
NON‑CURRENT LIABILITIES






Employee provisions 320 320 320 320 320 320 320
Borrowings and leases 10 11 11 35 22 9 9
Total non‑current liabilities 330 331 331 355 342 329 329
TOTAL LIABILITIES 2,232 2,233 2,233 2,257 2,244 2,231 2,231
EQUITY






Contributed equity 1,552 1,625 1,625 1,697 1,770 1,843 1,916
Accumulated surplus/(deficit) 1,980 1,959 3,034 2,488 2,467 2,481 2,495
Total equity 3,532 3,584 4,659 4,185 4,237 4,324 4,411
TOTAL LIABILITIES AND EQUITY 5,764 5,817 6,892 6,442 6,481 6,555 6,642








(a) Full audited financial statements are published in the Corporation's Annual Report.







The words contained in this file might help you see if this file matches what you are looking for:

...Sheet aip asset investment program estimated total cost expenditure budget forward to estimate works in progress furniture and office equipment replacement completed new of funded by capital appropriation drawdowns from the holding account internal funds balances funding is income statement actual services expenses employee benefits b supplies accommodation depreciation amortisation finance interest costs other sale goods revenue net c state government service appropriations resources received free charge royalties for regions fund regional community revenues surplus deficiency period a full audited financial statements are published corporation s annual report time equivalents respectively changes treasurer instruction comprehensive since have moved all out calculation into this may increased compared previously budgets sfp position current assets cash restricted receivables non property plant intangibles liabilities provisions payables borrowings leases equity contributed accumulated...

no reviews yet
Please Login to review.