Spreadsheet: 845826d1697165936-excel-wont-let-me-click-on-the-cell-i-want-test
Sheet: Summary (2)

Gateway Baptist Church
10 Year Model (2023 to 2032) |  |  |  | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2029 | 2029 | 2029 | 2029 | 2029 | 2029 | 2029 | 2029 | 2030 | 2030 | 2030 | 2030 | 2030 | 2030 | 2030 | 2030 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2032 | 2032 | 2032 | 2032 | 2032 | 2032 | 2032 | 2032
Capital Investment
 |  |  | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023
Capital Expenditure
Operational Maintenance
Operating expenses
 | Motor Vehicles
 |  | Motor [NAME] and Maintenance | 6000 | 0 | 0 | 0 | 0 | 0 | 0 |  | 5196.480609493334 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Property expenses
 | Property
 |  | Repairs & Maintenance - Projects | 2840.811216035648 | 199.8058930855356 | 1159.235828562591 | 6143.300912234939 | 199.8058930855356 | 857.1373104529848 | 99.9029465427678 |  | 0 | 1000 | 5000 | 23000 | 742.6986666666668 |  | 2000 | 1500
 |  | Capital reserve | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Repairs and Maintenance
 |  | Repairs and Maintenance - Computer | 106867 | 0 | 0 | 0 | 0 | 0 | 0 |  | 91681 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Repairs and Maintenance - Electrical Air Conditioning | 0 | 2000 | 2700 | 42765 | 0 | 2000 | 2500 |  | 0 | 2000 | 2730 | 35000 | 0 | 2000 | 2500 | 0
 |  | Repairs and [NAME] and General | 0 | 1000 | 5000 | 15000 | 0 | 1000 | 2500 |  | 500 | 1000 | 5000 | 17500 | 434.0925166933334 | 1000 | 2500 | 0
 |  | Repairs and Maintenance - Plumbing | 0 | 500 | 500 | 6000 | 0 | 250 | 800 |  | 0 | 500 | 500 | 6000 | 0 | 250 | 800 | 0
 |  | Repairs and Maintenance - Sound, Lighting, Audio Visual | 37500 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 |  |  | 0
Total operational capex
New Expenditure
 | Mackenzie
IK |  | A/con - Auditorium + Function Room
$ |  | - Sound Proofing |  |  |  |  |  |  |  |  |  |  |  | 500000
& |  | Mezzanine (+600 seats)
IK |  | Car Parking |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250000
IK |  | Roof Restoration |  |  |  |  |  |  |  |  |  |  |  | 100000
$ |  | Auditorium & Stage Upgrade
 | Refurbishment
 |  | Mackenzie
$ |  | Seating - Auditorium |  |  |  |  |  |  |  |  |  |  |  | 500000
IK |  | Audio/Visual |  |  |  |  |  |  |  |  |  |  |  | 1000000
$ |  | Chapel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
$ |  | Fire Services
$ |  | Cladding
IK |  | Electrical
& |  | Offices & Meeting Rooms
IK |  | Air Conditioners (east wing)
$ |  | Plumbing
$ |  | Painting
$ |  | Toilets
$ |  | Function Room/Meeting Room
IK |  | Gateway Online (Equip & infrastructure)
 | New Buildings
& |  | Building - Mackenzie Community Hub |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500000
& |  | Building - Mackenzie Office Renovation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
$ |  | Building - Ormeau LAND (Funding) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000 |  |  |  |  |  |  |  | 1000000
# |  | Building - Ormeau (Loan/Sale)
IK |  | Building - Ormeau |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6000000
IK |  | Building - Logan (Kids&Yth) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
IK |  | Building - Logan (Car Park) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300000
IK |  | Building - Logan (Auditorium) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
& |  | Building - City
$ |  | Building - Redlands - Land & Buildings |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500000
IK |  | Building - City
 | Vehicles
$ |  | Van |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ |  | Ute |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Reserve Funded
 | Major Repairs
$ |  | Building Repair - Mackenzie
$ |  | Building Repair - Ormeau
$ |  | Building Repair - Redlands
$ |  | Building Repair - Logan
$ |  | Building Repair - City
 | Routine Replacement |  |  |  |  |  |  |  |  |  | Includes 2023 and 2024
$ |  | Building Plant & Equipment - Central |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17085.22
$ |  | Building Plant & Equipment - Mackenzie |  |  |  | 60000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101868.65 |  |  |  |  |  |  |  | 442089.53 |  |  |  |  |  |  |  | 44300.41 |  |  |  |  |  |  |  | 161936.23 |  |  |  |  |  |  |  | 229934.74 |  |  |  |  |  |  |  | 449150.85
$ |  | Building Plant & Equipment - Ormeau |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4333.07 |  |  |  |  |  |  |  | 9170.21 |  |  |  |  |  |  |  | 94242.97 |  |  |  |  |  |  |  | 582.13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 508120.82 |  |  |  |  |  |  |  | 50429.25
$ |  | Building Plant & Equipment - Redlands |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9677.82 |  |  |  |  |  |  |  |  | 32935.44 |  |  |  |  |  |  |  | 284.09 |  |  |  |  |  |  |  | 120646.07 |  |  |  |  |  |  |  | 50160.2 |  |  |  |  |  |  |  | 3480.14 |  |  |  |  |  |  |  | 54469.64 |  |  |  |  |  |  |  | 20700.81 |  |  |  |  |  |  |  | 146940.05
$ |  | Building Plant & Equipment - Logan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27024.73 |  |  |  |  |  |  |  | 65024.22 |  |  |  |  |  |  |  | 7565.72 |  |  |  |  |  |  |  | 106707.75 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61151.67
$ |  | Building Plant & Equipment - City |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2070 |  |  |  |  |  |  |  | 48358.23 |  |  |  |  |  |  |  | 1828.46 |  |  |  |  |  |  |  | 2236.59 |  |  |  |  |  |  |  | 106975.56 |  |  |  |  |  |  |  | 3103.67 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12914.43
$ |  | Building Plant & Equipment / Growth (Contingency)
Total major projects
Total - operational and major projects
Sources of funding
& | [NAME] through debt finance
# | [NAME] from proceeds of sale of Ormeau Care Cente
IK | = Funded by donations in-kind
$ | = Funded by operating cash surpluses
 | Operational capex funded from cash flow
 | Total sources
 | Total requirement on operating cash