Schools' Finance Branch 511-1181 Portage Avenue Winnipeg, Manitoba R3G 0T3
PEMBINA TRAILS SCHOOL DIVISION 181 HENLOW BAY WINNIPEG, MANITOBA R3Y 1M7
AUDITED FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION
June 30, 2007
PEMBINA TRAILS SCHOOL DIVISION MANAGEMENT REPORT
Management 's Responsibility for the Financial Statements The accompanying consolidated financial statements of Pembina Trails School Division are the responsibility of the Division management and have been prepared in compliance with legislation, and in accordance with generally accepted accounting principles established by the Public Sector Accounting Board of The Canadian Institute of Chartered Accountants. A summary of the significant accounting policies are described in Note 3 to the consolidated financial statements. The preparation of consolidated financial statements necessarily involves the use of estimates based on management's judgment, particularly when transactions affecting the current accounting period cannot be finalized with certainty until future periods. Division management maintains a system of internal controls designed to provide reasonable assurance that assets are safeguarded, transactions are properly authorized and recorded in compliance with legislative and regulatory requirements, and reliable financial information is available on a timely basis for preparation of the consolidated financial statements. These systems are monitored and evaluated by management. The Board of Trustees of the Division met with management and the external auditors to review the consolidated financial statements and discuss any significant financial reporting or internal control matters prior to their approval of the consolidated financial statements. The consolidated financial statements have been audited by Grant Thornton independent external auditors appointed by the Board. The accompanying Auditors' Report outlines their responsibilities, the scope of their examination and their opinion on the Division's consolidated financial statements.
October 25, 2007
Grant Thornton 8 Grant Tfrorn5,n LLP chartered Accountants Management Cor su tants
Auditors' Report To The Board of Trustees of Pembina Trails School Division
We have audited the consolidated statement of financial position of the Pembina Trails School Division as at June 30 , 2007, and the consolidated statements of revenues , expenses and accumulated surplus, change in net debt, and cash lows for the year then ended. These financial statements are the responsibility of the Division 's management , Our responsibility is to express an opinion on these financial statements based on our audit. We conducted our audit in accordance with Canadian generally accepted auditing standards. Those standards require that we plan and perform an audit to obtain reasonable assurance whether the financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. In our opinion, these financial statements present fairly, in all material respects, the financial position of the Division as at June 30, 2007 and the results of its operations and changes in its financial position for the year then ended in accordance with the generally accepted accounting principles as established by the Public Sector Accounting Board. Our audit was conducted for the purpose of forming an opinion on the consolidated financial statements taken as a whole. The current year's supplementary information included in the other statements, schedules and reports is presented for purposes of additional analysis. Such supplementary information has been subjected to the auditing procedures applied in the audit of the consolidated financial statements and, in our opinion, is fairly stated in all material respects in relation to the consolidated financial statements taken as a whole. Our examination did not include the budget figures and we do not express any opinion concerning them. The comparative figures, as described in Note 2, have not been restated and are presented in accordance with Financial Reporting and Accounting in Manitoba Education, the prescribed method of accounting that was followed prior to the implementation of generally accepted accounting principles as established by the Public Sector Accounting Board (PSAB).
Winnipeg, Canada October 10, 2007
Chartered Accountants
I hereby certify that the preceding report and the statements and reports referenced herein have been presented to the members of the Board of Trustees of Pembina Trails School Division,
Z46 9!5r a2 22a'7 Date
90L - Ore L, rnbard Place Wm,peg, Manitoba
R3B 0x3 T F E W
(2c4) 944-0460 (2O4 957-5442 Winnipeg@GmntThom€on,ca www .GrantTtwmhn.cs
Canadian Msmbe of Grant Thornton unemotional
Grant Thornton 8 Grant Thornton LLP Chartered Accettan€s Management Cc t tarts
Auditors ' Supplementary Report To The Board of Trustees Pembina Trails School Division In accordance with the provisions of Section 41(12) of the Public Schools Act we have made a study of those internal accounting control and administrative control procedures of Pembina Trails School Division ('The Division") that we considered relevant to the requirements of the Act and related regulations. Our study was made in accordance with Canadian generally accepted auditing standards, and accordingly included such tests and other procedures for the year ended June 30, 2007 as we considered necessary in the circumstances. The administration of the Division is responsible for establishing and maintaining a system of internal accounting control. The objectives of a system are to provide the administration with reasonable, but not absolute, assurance that transactions are executed in accordance with administration's authorization and recorded properly to permit the preparation of financial statements in accordance with a described basis of accounting, Because of inherent limitations in any system of internal accounting and administrative control, only reasonable assurance can be obtained with respect to the adequacy of such internal control procedures. Our study and evaluation was made solely for the purposes required by the provision of Section 41(12) of The Public Schools Act, and as such may not disclose all material weaknesses in the system. Accordingly, we do not express an opinion on the system of internal accounting control of the Division taken as a whole. We report that, during the year ended June 30, 2007 taken as a whole: a)
b) c)
in our opinion, an appropriate system of internal control existed and functioned effectively for reporting school division enrolment for the purpose of calculating provincial funding, according to the definitions and reporting requirements set out in sections 1.1 and 1.2 of the annual Enrolment Reporting Requirements document issued by the Schools' Finance Branch; in our opinion, appropriate controls exist and are in use for Type A school funds as outlined in the Policy on School Funds issued by the Schools' Finance Branch on November 15, 1993; in our opinion, there are no other significant matters, or irregularities or discrepancies in the administration of the school division's affairs that should be brought to the attention of the school board or the minister. However, we have issued our standard internal control letter to the Board under separate cover.
Further, as a result of our financial statement audit procedures and those procedures undertaken to allow us to report under Section 41(12) of the Public Schools Act, we report that, to the best of our knowledge and belief the funds of the school division have been paid and disbursed only under authority granted by The Public Schools Act or a property authorized by-law or resolution of the division made under the authority of The Public Schools Act.
Chartered Accountants
Winnipeg, Manitoba October 15, 2007
Date
Auditor
I hereby certify that the preceding report has been pre Pembina Trails School Division. Date 906 - One Lombard Mac* wimp og, Manitter,a
R38 0X3 T r E W
(204;944-0900 (204) 967-5d42 Y^nripag^GrantThmFto*; ca wowr.C4ani omiar.ea
Caratlran Member of Grant T amton EnternaticrW
TABLE OF CONTENTS 2006/2007 FINANCIAL STATEMENTS PAGE AUDITOR'S REPORT AUDITOR'S SUPPLEMENTARY REPORT
CONSOLIDATED STATEMENT OF FINANCIAL POSITION
1
STATEMENT OF REVENUE, EXPENSES AND ACCUMULATED SURPLUS
2
STATEMENT OF CHANGE IN NET DEBT
3
STATEMENT OF CASH FLOW
4
NOTES TO THE FINANCIAL STATEMENTS ANALYSIS OF CONSOLIDATED ACCUMULATED SURPLUS
5
OPERATING FUND SCHEDULE OF FINANCIAL POSITION
6
SCHEDULE OF REVENUE, EXPENSES AND ACCUMULATED SURPLUS
7
REVENUE DETAIL: PROVINCE OF MANITOBA
8-9
REVENUE DETAIL: NON-PROVINCIAL GOVERNMENT SOURCES
10
EXPENSE BY FUNCTION AND BY OBJECT
11
EXPENSE DETAIL - Function 100: Regular Instruction
12
- Function 200: Student Support Services
13
- Function 300: Adult Learning Centres
14
- Function 400: Community Education and Services
15
- Function 500: Divisional Administration
16
- Function 600: Instructional and Other Support Services
17
- Function 700: Transportation of Pupils
18
- Function 800: Operations and Maintenance
19
DETAIL OF TRANSFERS TO (FROM) CAPITAL FUND
20
CAPITAL FUND SCHEDULE OF FINANCIAL POSITION
21
SCHEDULE OF REVENUE, EXPENSES AND ACCUMULATED SURPLUS
22
SCHEDULE OF TANGIBLE CAPITAL ASSETS
23
SCHEDULE OF RESERVE ACCOUNTS
24
SPECIAL PURPOSE FUND SCHEDULE OF FINANCIAL POSITION
25
SCHEDULE OF REVENUE, EXPENSES AND ACCUMULATED SURPLUS
26
STUDENT ENROLMENTS (FRAME) AND TRANSPORTATION STATISTICS (unaudited)
27
FULL TIME EQUIVALENT PERSONNEL (unaudited)
28
CALCULATION OF ADMINISTRATION COSTS
29
CALCULATION OF ALLOWABLE EXPENSES (audited)
30 - 32
Pembina Trails School Division
20-Dec-07
CONSOLIDATED STATEMENT OF FINANCIAL POSITION as at June 30 2007
Notes
2006 (see Note 2)
Financial Assets Cash and Bank
7,598,274
1,207,232
-
49,325
2,357,723
1,574,759
237,823
177,570
- Municipal Government
30,218,279
30,504,695
- Other School Divisions
143,513
47,201
-
-
356,855
770,384
Accrued Investment Income
-
-
Other Investments
-
Short Term Investments Due from - Provincial Government - Federal Government 13
- First Nations Accounts Receivable
40,912,467
34,331,166
-
-
Accounts Payable
3,874,932
2,704,425
Accrued Liabilities
1,335,121
1,417,220
Liabilities 4
Overdraft
5
Employee Future Benefits
721,719
-
8
Accrued Interest Payable
666,684
-
Due to
489,504
463,423
5,678,689
5,223,948
- Municipal Government
33,017
37,186
- Other School Divisions
92,925
78,695
-
-
6,532,447
4,761,335
- Provincial Government - Federal Government
- First Nations 6
Deferred Revenue
8
Debenture Debt
21,011,290
22,196,712
9
Other Borrowings
14,936,889
13,384,475
7
School Generated Funds Liability
909,867
Net Debt
56,283,084
50,267,419
(15,370,617)
(15,936,253)
40,056,953
95,578,968
-
-
545,484
433,965
40,602,437
96,012,933
25,231,820
80,076,680
Non-Financial Assets 10
Net Tangible Capital Assets (TCA Schedule) Inventories Prepaid Expenses
11
Accumulated Surplus
1
Pembina Trails School Division
20-Dec-07
CONSOLIDATED STATEMENT OF REVENUE, EXPENSES AND ACCUMULATED SURPLUS For the Year Ended June 30 2007 Actual
Notes
2006 Actual (see Note 2)
Revenue Provincial Government Federal Government Municipal Government
- Property Tax - Other
Other School Divisions First Nations Private Organizations and Individuals Other Sources 3(f)
School Generated Funds
68,076,242
65,293,394
13,230
25,838
51,747,990
50,885,221
-
-
693,368
709,460
-
31,612
2,049,928
1,975,643
949,884
936,140
1,139,894
Other Special Purpose Funds
124,670,536
119,857,308
Regular Instruction
68,855,110
66,680,292
Student Support Services
22,071,209
19,231,547
-
-
567,894
510,682
Divisional Administration
3,834,296
3,483,149
Instructional and Other Support Services
5,177,542
7,350,885
Transportation of Pupils
1,604,201
1,550,604
11,564,704
11,228,402
- Interest
2,017,355
2,103,863
- Other
1,945,474
1,948,317
2,743,071
-
16,804
34,723
Expenses
Adult Learning Centres Community Education and Services
Operations and Maintenance Fiscal 3(d)
Amortization Other Capital Items
3(f)
School Generated Funds
1,167,048
Other Special Purpose Funds
12
121,564,708
114,122,464
Current Year Surplus (Deficit)
3,105,828
5,734,844
Opening Accumulated Surplus
80,076,680
74,341,836
Restatements:
Tangible Cap. Assets and Accum. Amort. Other than Tangible Cap. Assets
(57,086,147) (864,541)
0
Opening Accumulated Surplus, as restated
22,125,992
74,341,836
Closing Accumulated Surplus
25,231,820
80,076,680
2
Pembina Trails School Division
20-Dec-07
CONSOLIDATED STATEMENT OF CHANGE IN NET DEBT For the Year Ended June 30, 2007
Current Year Surplus (Deficit)
3,105,828
Amortization of Tangible Capital Assets
2,743,071
Acquisition of Tangible Capital Assets
(4,307,203)
(Gain) / Loss on Sale of Tangible Capital Assets
-
Proceeds on Sale of Tangible Capital Assets
(1,564,132)
Inventories (Increase)/Decrease
-
Prepaid Expenses (Increase)/Decrease
(111,519) (111,519)
(Increase)/Decrease in Net Debt
1,430,177
Net Debt at Beginning of Year
(15,936,253)
Restatements Other than Tangible Cap. Assets
(864,541)
Net Debt at Beginning of Year as Restated
(16,800,794)
Net Debt at End of Year
(15,370,617)
3
Pembina Trails School Division
20-Dec-07
CONSOLIDATED STATEMENT OF CASH FLOW For the Year Ended June 30, 2007
Operating Transactions Current Year Surplus/(Deficit)
3,105,828
Non-Cash Items Included in Current Year Surplus/(Deficit): Amortization of Tangible Capital Assets
2,743,071
(Gain)/Loss on Disposal of Tangible Capital Assets Employee Future Benefits Increase/(Decrease) Short Term Investments (Increase)/Decrease
721,719 49,325
Due from Other Organizations (Increase)/Decrease Accounts Receivable & Accrued Income (Increase)/Decrease Inventories and Prepaid Expenses - (Increase)/Decrease Due to Other Organizations Increase/(Decrease)
(653,113) 413,529 (111,519) 490,883
Accounts Payable & Accrued Liabilities Increase/(Decrease)
1,755,092
Deferred Revenue Increase/(Decrease)
1,771,112
School Generated Funds Liability Increase/(Decrease) Restatements Other than Tangible Cap. Assets
909,867 (864,541)
Cash Provided by Operating Transactions
10,331,253
Capital Transactions Acquisition of Tangible Capital Assets
(4,307,203)
Proceeds on Sale of Tangible Capital Assets
-
Cash (Applied to)/Provided by Capital Transactions
(4,307,203)
Investing Transactions Other Investments (Increase)/Decrease
-
Cash Provided by (Applied to) Investing Transactions
0
Financing Transactions Debenture Debt Increase/(Decrease)
(1,185,422)
Other Borrowings Increase/(Decrease)
1,552,414
Cash Provided by (Applied to) Financing Transactions
366,992
Cash and Bank / Overdraft (Increase)/Decrease
6,391,042
Cash and Bank (Overdraft) at Beginning of Year
1,207,232
Cash and Bank (Overdraft) at End of Year
7,598,274
4
PEMBINA TRAILS SCHOOL DIVISION NOTES TO CONSOLIDATED FINANCIAL STATEMENTS - JUNE 30, 2007
1. Nature of Organization and Economic Dependence The Pembina Trails School Division (Division) is a public body that provides education services to residents within its geographic location. The Division is funded by grants from the Province of Manitoba (Province) a n d by special levy on the property assessment included in the Division’s boundaries. The Division is exempt from income tax. The Division is economically dependent on the Province and on special levy for its revenue and capital financing requirements. Without these funding sources, the Division would not be able to continue its operations. 2. Comparative Figures and Conversion to PSAB Standards The Division has adopted generally accepted accounting principles as established by Public Sector Accounting Board (PSAB) during the 2006/07 fiscal year. The standards have been applied retroactively w i t h a cumulative adjustment to the opening accumulated surplus presented as a restatement on the Statement of Revenue, Expenses and Accumulated Surplus. The 2006 comparative figures have not been restated and are presented in accordance with FRAME, the prescribed method of accounting that the Division followed prior to the implementation of PSAB. The following changes have been implemented to comply with the PSAB standard: (i) Tangible capital assets were restated and amortized over their useful lives to reflect net book value. Amortization of tangible capital assets and gain or loss on disposal of capital assets is recorded in the Statement of Revenue, Expenses and Accumulated Surplus. Capital lease liability was established for the obligation associated with the leased capital assets. Deferred revenue was restated to include deferred revenue related to donated capital assets. (ii) The Operating Fund, Capital Fund and Special Purpose Fund are consolidated in the financial statements. InForm Net has been consolidated into the Operating Fund as a related entity. The Special Purpose Fund was created to include school generated funds controlled by the Division. (iii) The Employee Future Benefits Liability was established to account for the Division’s commitment to pay future benefits to its employees. (iv)Accrued Interest Payable was established to account for accrual of interest on Debenture Debt and Other Borrowings from the last payment date. An equal amount is set up as due from the Province to offset the accrued interest payable on debenture. 3. Significant Accounting Policies The consolidated financial statements have been prepared by management in accordance with Canadian generally accepted accounting principles established by PSAB of the Canadian Institute of Chartered Accountants (CICA). a) Reporting Entity and Consolidation The consolidated financial statements reflect the assets, liabilities, revenues and expenses of the operating fund, capital fund, and special purpose fund of the Division. The Division reporting entity includes school generated funds, and the Pembina Trails Education Support Fund, Pembina Trails Voices and InForm Net which are entities controlled by the Division. All inter-fund accounts and transactions are eliminated upon consolidation.
PEMBINA TRAILS SCHOOL DIVISION NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – JUNE 30, 2007
b) Basis of Accounting Revenues and expenses are reported on the accrual basis of accounting except when the accruals cannot be determined with a reasonable degree of certainty or when their estimation is impracticable. The accrual basis of accounting recognizes revenues as they are earned and measurable; expenses are recognized as they are incurred and measurable as a result of the receipt of goods or services and the creation of a legal obligation to pay. Expenses also include the amortization of tangible capital assets. c) Fund Accounting The fund method of accounting is employed by the Division to record financial transactions in separate funds as defined by Financial Reporting and Accounting in Manitoba Education (FRAME) in accordance with the purpose for which the funds have been created. The Operating Fund is maintained to record all the day to day operating revenues and expenses. The Capital Fund is used to account for the acquisition, amortization, disposal and financing of capital assets. The Special Purpose Fund is used to account for school generated funds controlled by the Division. d) Tangible Capital Assets Tangible capital assets are non-financial assets that are used by the Division to provide services to the public and have an economic life beyond one fiscal year. Tangible capital assets include land, buildings, buses, other vehicles, furniture and equipment, computers, capital leases, leasehold improvements, and assets under construction. To be classified as tangible capital assets, each asset other than land must individually meet the capitalization threshold for its class as prescribed by FRAME. Capitalization Threshold ($)
Estimated Useful Life (years)
Land Improvements
25,000
10
Buildings - brick, mortar and steel
25,000
40
Buildings - wood frame
25,000
25
School Buses
20,000
10
Vehicles
10,000
5
Equipment
5,000
5
Network Infrastructure
25,000
10
Computer Hardware, Servers & Peripherals
5,000
4
Computer Software
10,000
4
Furniture & Fixtures
5,000
10
Leasehold Improvements
25,000
Asset Description
Over term of lease
Grouping of assets is not permitted except for computer work stations. With the exception of land, donated capital assets and capital leases, all tangible capital assets, are recorded at historical cost, which includes purchase price, installation costs and other costs incurred to put the asset into service. Buildings are recorded at historical cost when known. For buildings acquired prior to June 30, 2005 where the actual cost was not known, the replacement value for insurance purposes as at June 30, 2005 was regressed to the date of acquisition using a regression index based on Southam and CanaData construction cost indices. Capital leases are recorded at the present value of the minimum lease payments excluding executory costs (e.g. insurance, maintenance costs, etc.). The discount 2
PEMBINA TRAILS SCHOOL DIVISION NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – JUNE 30, 2007
rate used to determine the present value of the lease payments is the lower of the Division’s rate for incremental borrowing or the interest rate implicit in the lease. Donated tangible capital assets are recorded at fair market value at the date of donation. Deferred revenue is recorded in an equivalent amount, for all donated assets except land. The deferred revenue will be recognized as revenue over the useful life of the related asset, on the same basis that the asset is amortized. All land acquired prior to June 30, 2006 has been valued by the Crown Lands and Property Agency. All tangible capital assets, except for land, capital leases, and assets under construction, are amortized on a straight-line basis over their estimated useful lives as prescribed by FRAME. Land is not amortized. Capital leases with lease terms that have a bargain purchase option or allow ownership to pass to the Division are amortized over the useful life of the asset class. All other capital leases are amortized over the lesser of the lease term and the useful life of the asset class. One-half of the annual amortization is charged in the year of acquisition and in the year of disposal if not fully amortized. Assets under construction are not amortized until the date of substantial completion. e) Employee Future Benefits The Province of Manitoba pays the employer portion of the Teachers’ Retirement Allowances Fund (TRAF), the pension plan for all certified teachers of the Division. The Division does not contribute to TRAF, and no costs relating to this plan are included in the Division’s financial statements. However, the Division provides retirement and other future benefits to its employees. These benefits include the MAST Pension Plan, Maternity Leave and Vacation Days. The Division adopted the following policies with respect to accounting for these employee future benefits: (i) Defined contribution plan – MAST Pension Plan Under this plan, specific fixed amounts are contributed by the Division each period for services rendered by the employees. No responsibility is assumed by the Division to make any further contribution: The employee future benefits liability is the difference between the contribution owing for the period and what has been paid; while the employee future benefits expense is the Division’s fixed contribution for the period. (ii) Defined employee future benefit plans – Maternity Leave For benefit obligations that are event driven (non-vesting maternity leave), the benefit costs are recognized and recorded only in the period when the event occurs. The employee future benefits liability is the total accrued benefit obligation; while the employee future benefit expense is the Division’s contribution for the period. (iii) Defined employee future benefit plans – Accumulated Vacation Days For benefit obligations that are vested and accumulate over the employees’ length of service (vacation days), the benefit costs are recognized and recorded as service is rendered by employees. The employee future benefits liability is the total accrued benefit obligation; while the employee future benefit expense is the Division’s contribution for the period. f) School Generated Funds School generated funds are moneys raised by the school, or under the auspices of the school, through extra curricular activities for the sole use of the school that the 3
PEMBINA TRAILS SCHOOL DIVISION NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – JUNE 30, 2007
principal of each school, subject to the rules of the school board, may raise, hold, administer and expend for the purposes of the school. Only revenue and expenses of school generated funds controlled by the Division are included in the Consolidated Statement of Revenue, Expenses and Accumulated Surplus. To be deemed as controlled, a school must have the unilateral authority to make the decisions as to when, how and on what the funds are to be spent. Period end cash balances of all school generated funds are included in the Consolidated Statement of Financial Position. The uncontrolled portion of this amount is reflected in the School Generated Funds Liability account. Examples of uncontrolled school generated funds are specific purpose student fees and fund raising, school meal programs, scholarship funds, and parent or student council funds. Revenues and expenses of uncontrolled school generated funds are not included in the consolidated financial statements. g) Capital Reserve Certain amounts, as approved by the Board of Trustees and the Public Schools Finance Board (PSFB), have been set aside in reserve accounts for future capital purposes. These Capital Reserve accounts are internally restricted funds that form part of the Accumulated Surplus presented in the Consolidated Statement of Financial Position. h) Use of Estimates The preparation o f financial statements in conformity with generally accepted accounting principles requires management to make estimates and assumptions that affect the reported amounts of assets a nd liabilities and the disclosure of contingent assets and liabilities at the date of the financial statements, and the reported amounts of revenues and expenses during the reporting period. i) Financial instruments There are no significant terms and conditions related to financial instruments (cash, accounts receivable, investments, bank indebtedness, accounts payable and longterm debt) that may affect the amount, timing and certainty of future cash flows. The Division is exposed to credit risk from the potential non-payment of accounts receivable. However, the majority of the receivables are from local, provincial and federal governments, and therefore, the credit risk is minimal. The carrying amounts of the financial instruments approximate their carrying values, unless otherwise noted. 4.
Overdraft
The Division has an authorized line of credit with Royal Bank of Canada of $30,000,000 by way of overdrafts and is repayable on demand at the Bank’s Prime Interest Rate minus 0.75%. Overdrafts are secured by a borrowing by-law document. 5. Employee Future Benefits The following employee future benefits are benefits earned by employees in the current period, but will not be paid out until future periods. Type of Plan MAST Pension Plan
Defined Contribution
Maternity Leave
Defined Benefit - Event Driven
Accumulated Vacation Days
Defined Benefit - Vesting
2007 $
12,479
$
709,240 721,719
4
PEMBINA TRAILS SCHOOL DIVISION NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – JUNE 30, 2007
6. Deferred Revenue The deferral method of accounting is used for revenues received that, pursuant to legislation, regulation or agreement, may only be used for specific purposes. These amounts are recognized as revenue in the fiscal year the related expenses are incurred or services performed. Included in the Addition/ Restatement column is an adjustment of $299,413 related to the restatement of opening accumulated surplus for donated capital assets. The following is a breakdown of the account balance: Additions/ Restatement
June 30, 2006 Education Property Tax Credit
$
International Student Program Fees
4,303,962
$
4,303,962
$
5,697,423
198,210
205,981
198,210
-
29,867
-
29,867
251,392
289,218
251,392
289,218
4,761,335
373,094 6,587,812
55,365 4,816,700
Donated Capital Assets $
5,697,423
June 30, 2007
205,981
Fibre Access Agreements Externally Funded Programs
$
Recognized
$
$
$
317,729 6,532,447
7. School Generated Funds Liability School Generated Funds Liability includes the non-controlled portion of school generated funds consolidated i n t h e cash and bank balances in the amount of $909,867. The following is a breakdown of the account balance: 2007 Student Fees - Activities, Clubs, Trips
$
346,492
Student - Fees, Yearbooks, Agendas
264,486
Specific Purpose Fund Raising
126,880
Breakfast and Lunch Programs
110,348
Scholarship Funds
54,508
Parent/ Student Council Funds, Other $
7,153 909,867
8. Debenture Debt The debenture debt of the Division is in the form of twenty-year debentures payable in twenty equal yearly installments of principal and interest and maturing at various dates from 2007 to 2027. Payment of principal and interest is funded entirely by grants from the Province of Manitoba. The debentures carry interest rates that range from 4.875% to 12.25%. Debenture interest expense payable as at June 30, 2007, is accrued and recorded in Accrued Interest Payable, and a grant in an amount equal to the interest accrued on provincially funded debentures is recorded in Due from the Provincial Government. The debenture principal and interest repayments i n the next five years are: Principal 2007/08
$
2,217,345
Interest $
1,581,016
Total $
3,798,361
2008/09
2,157,252
1,372,191
3,529,443
2009/10
2,037,102
1,173,164
3,210,266
2010/11
1,759,098
990,281
2,749,379
2011/12 $
1,510,698 9,681,495
$
842,872 5,959,524
$ $
2,353,570 15,641,019
9. Other Borrowings Other borrowings are debts other than overdrafts or debentures. borrowings include contractual obligations related to capital leases.
The following
2007 Vehicle Leases
169,816
Equipment Leases (Copiers) $
405,453 575,269
5
PEMBINA TRAILS SCHOOL DIVISION NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – JUNE 30, 2007
Capital lease loans on vehicles and equipment have interest rates ranging from 4.5% to 7.3% per annum, due between 2007 to 2011 all with annual payments of principal and interest. These loans are secured by the related assets. Principal and interest repayment of total Other Borrowings in the next five years are: Principal 2007/08
$
Interest
190,817
$
Total
19,252
$
210,069
2008/09
190,817
19,252
210,069
2009/10 2010/11
176,477 17,158
18,700 2,048
195,177 19,206
2011/12 $
575,269
$
59,252
$
634,521
10. Net Tangible Capital Assets The Schedule of Tangible Capital Assets (TCA), page 23 of the financial statements, provides a breakdown of cost, accumulated amortization and net book value by class. The breakdown between owned and leased assets is as follows:
Owned Tangible Capital Assets
Gross Amount
Accumulated Amortization
$
85,874,155
$
46,430,916
$
971,038 86,845,193
$
357,324 46,788,240
Leased Tangible Capital Assets
2007 Net Book Value $
39,443,239
$
613,714 40,056,953
11. Accumulated Surplus The consolidated accumulated surplus is comprised of the following: 2007 Operating Fund Designated Surplus
$
Undesignated Surplus
1,084,084 4,554,864
$
5,638,948
Pembina Trails Education Support Fund
$
142,933
Pembina Trails Voices
$
70,503
Related Entities
InForm Net
697 $
214,133
$
1,236,486
Capital Fund Reserve Accounts Equity in Tangible Capital Assets
17,745,721 $
18,982,207
$
396,532
Special Purpose Fund School Generated Funds Other Special Purpose Funds
Total Accumulated Surplus
$
396,532
$
25,231,820
Designated Surplus under the Operating Fund represents internally restricted amounts appropriated by the board or, in the case of school budget carryovers, by board policy. See page 5 of the financial statements for a breakdown o f the Designated Surplus. Related entities are entities that are controlled by the Division and consolidated into the Operating fund. Reserve Accounts under the Capital Fund represents internally restricted reserves for specific purposes approved by the Board of Trustees and PSFB. A Schedule of Capital Reserve Accounts is provided on page 24 of the financial statements. School Generated Funds are externally restricted moneys for school use. 6
PEMBINA TRAILS SCHOOL DIVISION NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – JUNE 30, 2007
12. Restatement of Opening Accumulated Surplus Restatement of Opening Accumulated Surplus is comprised of: 2007 Opening Accumulated Surplus
$
80,076,680
Operating Fund Consolidation of InForm Net
$
(21,558)
$
(967,256)
Capital Fund Capital Lease Liability Deferred Revenue for Donated Assets
(299,413)
Tangible Capital Assets
(13,040,978)
Accumulated Amortization
(44,045,169) $
(58,352,816)
Special Purpose Fund School Generated Funds Restatement of Opening Accumulated Surplus
$
423,686
$
22,125,992
Restatements o f the above accounts are prior period cumulative adjustments to the opening balance of the accumulated surplus (deficit) of the current period. These adjustments are the result of adopting PSAB standards. 13. Municipal Government – Property Tax and related Due from Municipal Government Education property tax or Special Levy is raised as the Division’s contribution to the cost of providing public education for resident students i n t h e Division. The Municipal Government-Property Tax shown on the consolidated revenue and expense is raised over the two calendar (tax) years; 40% from 2006 tax year and 60% from 2007 tax year. Below are the related revenue and receivable amounts: 2007
2006
Revenue - Municipal Government Property Tax
$
51,747,990
$
50,885,221
Receivable - Due from Municipal Government Property Tax
$
30,212,718
$
30,491,794
14. Interest Received and Paid The Division received interest during the year of $436,601 (previous year $331,919); interest paid during the year was $2,006,991 (previous year $2,098,045). 15. Contractual Obligations The Division has an agreement with King Transportation for student transportation services for a term of 5 years ending in June 2011. The specific costs for these services are approximately $353,000 for 2007/08. 16. Special Levy Raised for la Division scolaire franco-manitobaine In accordance with Section 190.1 of The Public Schools Act the Division is required to collect a special levy on behalf la Division scolaire franco-manitobaine. The special levy for 2007 was $423,488 (2006 - $ 268,870). These amounts are not included in the Division’s consolidated financial statements.
7
Pembina Trails School Division
ANALYSIS OF CONSOLIDATED ACCUMULATED SURPLUS as at June 30, 2007 Operating Fund Accumulated Surplus (Deficit)
5,853,081
Equity in Tangible Capital Assets
17,745,721
Capital Reserve Accounts
1,236,486
School Generated Funds
396,532
Other Special Purpose Funds
0
Consolidated Accumulated Surplus
25,231,820
Operating Fund Accumulated Surplus Comprised of: Designated Surplus * Board Motion No.
Description
Unexpended Amount
1-32-06
Florescent Lighting Retrofit Project
555,177
Policy
Carry Over of School Budgets
528,907
Total Designated Surplus
1,084,084
Undesignated Surplus (Deficit)
4,768,997
Total Operating Fund Accumulated Surplus (Deficit)
5,853,081
* Includes all Board-approved surplus designations by Board Motion or, in the case of school budget carryovers, by Board policy.
5
Pembina Trails School Division
20-Dec-07
OPERATING FUND SCHEDULE OF FINANCIAL POSITION as at June 30 2007
2006
5,079,984
1,013,191
-
-
1,691,039
1,574,759
237,823
177,570
- Municipal Government
30,218,279
30,504,695
- Other School Divisions
143,513
47,201
- First Nations
-
-
- Other Funds
-
815,110
356,855
336,362
Financial Assets Cash and Bank Short Term Investments Due from
- Provincial Government - Federal Government
Accounts Receivable Accrued Investment Income
37,727,493
34,468,888
Liabilities Overdraft
-
Accounts Payable
3,290,063
2,353,190
Accrued Liabilities
1,335,121
1,417,220
Employee Future Benefits
721,719
Accrued Interest Payable Due to
-
- Provincial Government
489,504
463,423
5,678,689
5,223,948
- Municipal Government
33,017
37,186
- Other School Divisions
92,925
78,695
- First Nations
-
-
- Capital Fund
202,520
-
Deferred Revenue
6,214,718
4,761,335
Other Borrowings
14,361,620
13,384,475
32,419,896
27,719,472
5,307,597
6,749,416
-
-
545,484
433,965
545,484
433,965
5,853,081
7,183,381
- Federal Government
Net Financial Assets (Net Debt) Non-Financial Assets Inventories Prepaid Expenses
Accumulated Surplus (Deficit)
6
Pembina Trails School Division
20-Dec-07
OPERATING FUND SCHEDULE OF REVENUE, EXPENSES AND ACCUMULATED SURPLUS For the Year Ended June 30 2007 Actual
2007 Budget
2006 Actual
63,873,563
60,841,692
61,193,474
13,230
12,600
25,838
51,747,990
54,047,506
50,885,221
-
-
-
693,368
778,000
709,460
-
16,000
31,612
2,049,928
1,731,600
1,975,643
810,764
290,000
917,822
119,188,843
117,717,398
115,739,070
Regular Instruction
68,855,110
71,015,936
66,680,292
Student Support Services
22,071,209
22,144,961
19,231,547
-
-
-
567,894
103,977
510,682
Divisional Administration
3,834,296
3,717,616
3,483,149
Instructional and Other Support Services
5,177,542
4,942,819
7,350,885
Transportation of Pupils
1,604,201
1,503,718
1,550,604
11,564,704
11,886,271
11,228,402
2,137,967
2,150,000
2,173,441
115,812,923
117,465,298
112,209,002
3,375,920
252,100
3,530,068
(4,684,661)
(630,100)
(2,600,217)
Revenue Provincial Government Federal Government Municipal Government - Property Tax - Other Other School Divisions First Nations Private Organizations and Individuals Other Sources
Expenses
Adult Learning Centres Community Education and Services
Operations and Maintenance Fiscal
Current Year Surplus (Deficit) Net Transfers from (to) Capital Fund Transfers from Special Purpose Funds
-
Net Current Year Surplus (Deficit)
(1,308,741)
Opening Accumulated Surplus (Deficit) Restatements:
7,183,381
Employee Future Benefits
(378,000)
929,851
6,253,530
-
Consolidation of InForm Net
(21,559)
-
Opening Accumulated Surplus (Deficit), as restated
7,161,822
6,253,530
Closing Accumulated Surplus (Deficit)
5,853,081
7,183,381
7
Pembina Trails School Division
20-Dec-07
OPERATING FUND - REVENUE DETAIL PROVINCE OF MANITOBA For the Year Ended June 30, 2007 Funding of Schools Program Base Support Instructional Support Sparsity Curricular Materials Information Technology Library Services Student Services Counselling and Guidance Professional Development Occupancy Categorical Support Transportation Board and Room Special Needs: Coordinator/Clinician Special Needs: Level II Special Needs: Level III Senior Years Technology Education English as an Additional Language Aboriginal Academic Achievement Heritage Language French Language Programs Small Schools Enrolment Change Support Northern Allowance Early Childhood Development Early Literacy Intervention Early Numeracy Experiential Learning Equalization Additional Equalization Amalgamated School Division Guarantee Adjustment for Days Closed Other Program Support School Buildings Support: "D" Projects Technology Education Equipment Replacement Technical Vocational Initiative - Equipment Upgrade Other Minor Capital Support Prior Year Support Finalization of Previous Year Support Curricular Materials School Buildings Support: "D" Projects Technology Education Equipment
23,845,241 702,834 511,152 1,175,650 3,957,028 937,270 485,594 4,908,120 687,179 894,516 2,936,910 2,458,827 172,068 439,400 195,400 5,481 530,844 274,302 80,596 366,300 61,440 41,430
36,522,889
9,144,693 2,462,088 -
309,470 76,400 57,974 -
443,844 48,573,514
8
Pembina Trails School Division
20-Dec-07
OPERATING FUND - REVENUE DETAIL PROVINCE OF MANITOBA (CONT'D) For the Year Ended June 30, 2007
Other Department of Education, Citizenship and Youth Non-Resident
-
Special Needs
160,471
Institutional Programs
-
Nursing Supports (URIS)
132,479
Evening School
-
Substitute Fees
17,280
General Support Grant
1,904,100
Education Property Tax Credit
12,850,096
Technical Vocational Initiative Demonstration Project
17,351
New Schools
-
Class Size Fund
-
Community Schools
-
Healthy Schools Initiative
3,786
Education for Sustainable Development
-
Other: Bus Ridership Program Development
7,500
Action Plan for Official Languages
29,500
Sustainable Development Initiative
23,100
Middle Years Assessment
10,205 15,155,868
Other Provincial Government Departments English as a Second Language (Adults)
-
Driver Training
-
Employment Programs
-
Adult Learning Centres
-
Other: Community Projects
144,181
144,181
Funding of Schools Program (previous page)
48,573,514
TOTAL PROVINCIAL GOVERNMENT REVENUE
63,873,563
9
Pembina Trails School Division
20-Dec-07
OPERATING FUND - REVENUE DETAIL NON-PROVINCIAL GOVERNMENT SOURCES For the Year Ended June 30, 2007 Federal Government Tuition Fees Transportation of Pupils French Language Monitor Other:
13,230 -
13,230 Municipal Government Special Requirement Less: Education Property Tax Credit Other:
64,598,086 (12,850,096)
Other School Divisions Transfer Fees Residual Fees Transportation of Pupils Other:
51,747,990 -
51,747,990
653,250 40,118 693,368
First Nations Tuition Fees Transportation of Pupils Other:
-
0 Private Organizations and Individuals Regular Tuition International Tuition Continuing Education Driver Education Other Tuition: Food Service Other: Staff Development Centre Pembina Trails Voices Parking Transportation Fees Building Rentals
33,300 1,249,177 1,084 7,011 287,334 154,001 100,566 217,455 2,049,928
Other Sources Interest Donations Other:
Field Trips Insurance Proceeds Community Projects Roblin Office Lease Pembina Trails Education Support Fund InForm Net Accounting Fees Optical Fibre Lease
436,323 127,065 15,741 87,552 81,273 56,044 2,500 4,266 810,764
TOTAL NON-PROVINCIAL GOVERNMENT REVENUE
10
55,315,280
Pembina Trails School Division
20-Dec-07
OPERATING FUND - EXPENSE BY FUNCTION AND BY OBJECT For the Year Ended June 30
OBJECT Salaries
100
200
300
400
500
600
Community
Instructional and Other
700
800
900
Student
Adult
Education
Operations
2007
Regular
Support
Learning
and
Divisional
Support
Transportation
and
Instruction
Services
Centres
Services
Administration
Services
of Pupils
Maintenance
Fiscal
2006
TOTALS
TOTALS
58,109,033
19,234,610
-
198,978
2,394,310
3,958,251
646,188
4,973,368
89,514,738
86,459,081
Employees Benefits and Allowances
3,101,672
1,792,322
-
13,105
240,819
281,669
94,885
737,129
6,261,601
6,310,242
Services
1,106,550
739,422
-
95,358
921,581
734,944
637,013
5,065,267
9,300,135
8,693,632
Supplies, Materials and Minor Equipment
4,786,852
213,424
-
260,453
277,161
202,678
226,115
788,940
6,755,623
6,697,013
192,493
192,493
225,124
-
0
-
Interest and Bank Charges Bad Debt Expense
(PAYROLL TAX)
Transfers
1,751,003
91,431
-
-
425
-
-
-
1,945,474
3,788,333
3,823,910
TOTALS
68,855,110
22,071,209
0
567,894
3,834,296
5,177,542
1,604,201
11,564,704
2,137,967
115,812,923
112,209,002
11
FUNCTION
Pembina Trails School Division
20-Dec-07
OPERATING FUND - EXPENSE DETAIL: FUNCTION 100 For the Year Ended June 30, 2007
CODE OBJECT \ PROGRAM 3XX SALARIES 320 Executive, Managerial and Supervisory 330 Instructional - Teaching 350 Instructional - Other 360 Technical, Specialized and Service 370 Secretarial, Clerical and Other 390 Information Technology Total Salaries 4XX EMPLOYEES BENEFITS AND ALLOWANCES 5-6XX SERVICES 510 Professional, Technical and Specialized 520 Communications 540 Travel and Meetings 560 Tuition 570 Printing and Binding 580 Insurance and Bond Premiums 590 Maintenance and Repair Services 610 Rentals 630 Advertising 640 Dues and Fees 650 Professional and Staff Development 680 Information Technology Services Total Services 7XX SUPPLIES, MATERIALS AND MINOR EQUIPMENT 710 Supplies 740 Curricular and Media Materials 760 Minor Equipment 780 Information Technology Equipment Total Supplies, Materials and Minor Equipment 96X-99 TRANSFERS 960 School Divisions 980 Organizations and Individuals Total Transfers
ADMINISTRATION
SINGLE TRACK SCHOOLS * 20 50 70 ENGLISH FRENCH LANGUAGE FRANÇAIS IMMERSION
80 DUAL TRACK SCHOOLS **
90 SENIOR YEARS TECHNOLOGY EDUCATION
4,648,713
78,216 2,378,618 202,589 7,308,136 536,372 184 287,197 9,557
33,162,890 304,455 113,046
5,091,018 16,759 24,703
11,333,854 113,162 23,106
407,997 33,988,388 1,701,671
42,368 5,174,848 267,115
167,539 11,637,661 596,514
21,606 38,782 51,126
3,324 6,841 6,819
14,404 13,670 26,451
6,459
198
1,113
28,949 109,368
4,033 16,770
27,146 47,073
88,614 4,087 111,424 460,415
10,716
0
0
TOTALS 4,648,713 49,587,762 434,376 239,071 2,378,618 820,493 58,109,033 3,101,672
0
39,518 346,490 93,953 0 7,770 1,498 60,128 173,356 8,183 142,029 7,663 225,962 1,106,550
476,664 212,342 196,135 172,229 1,057,370
0
2,050,595 712,402 1,293,877 729,978 4,786,852
80,494
201,233
937,969
80,494
201,233
937,969
1,751,003 0 1,751,003
TOTALS 8,614,312 39,541,142 0 6,051,721 * 90% or more of enrolment is in one of the following instructional programs: English Language, Français, French Immersion. ** includes multi-track schools.
13,709,966
937,969
68,855,110
1,498 145 8,183 1,799 54,541 363,104 19,393 384,621 2,686 406,700
1,372,762 432,896 582,817 470,886 2,859,361
0
17,142 65,843
42,699 1,777 42,855 217,188
0
181,776 67,164 130,304 84,177 463,421
531,307 0
531,307
0
12
10
REGULAR INSTRUCTION
Pembina Trails School Division
20-Dec-07
OPERATING FUND - EXPENSE DETAIL: FUNCTION 200 For the Year Ended June 30, 2007 20
STUDENT SUPPORT SERVICES CODE OBJECT \ PROGRAM 3XX SALARIES 320 Executive, Managerial and Supervisory 330 Instructional - Teaching 350 Instructional - Other 360 Technical, Specialized and Service 370 Secretarial, Clerical and Other 380 Clinician 390 Information Technology Total Salaries 4XX EMPLOYEES BENEFITS AND ALLOWANCES 5-6XX SERVICES 510 Professional, Technical and Specialized 520 Communications 540 Travel and Meetings 560 Tuition 570 Printing and Binding 590 Maintenance and Repair Services 610 Rentals 630 Advertising 640 Dues and Fees 650 Professional and Staff Development 680 Information Technology Services Total Services 7XX SUPPLIES, MATERIALS AND MINOR EQUIPMENT 710 Supplies 740 Curricular and Media Materials 760 Minor Equipment 780 Information Technology Equipment Total Supplies, Materials and Minor Equipment 96X-99 TRANSFERS 960 School Divisions 980 Organizations and Individuals Total Transfers TOTALS
ADMINISTRATION GIFTED /CO-ORDINATION EDUCATION *
30
40
50
60
70
CLINICAL AND RELATED SERVICES
SPECIAL PLACEMENT
REGULAR PLACEMENT
OTHER RESOURCE SERVICES
COUNSELLING AND GUIDANCE
206,626 484,754 801,356
314,042 6,605,783
4,466,997 2,064,313
2,326,767
1,813,812 92,490
1,286,110 132,565
6,919,825 942,871
6,531,310 490,472
2,326,767 106,586
235,965 10,050 22,865
43,481
1,848
60
119,465
208 212,222
50,843
5,018
150,160 1,813,812 356,786 27,338
0
1,454 6,978
16,107
5,638 1,014 1,837
9,097
0
272,584
272,018
61,180
5,078
7,170
39,470 17 33,862
4,817
9,956 844
73,349
4,817
132 2,714 39,280 75,162 117,288
7,170
0
10,800
119,465
0
61,545 3,575 73,142 75,162 213,424
91,431 0 400,391
0
91,431
91,431 0 91,431
0
0 2,252,235 1,786,941 8,041,164 7,037,660 * Does not include enrichment activities undertaken by the School Division.
206,626 7,592,560 9,471,452 0 150,160 1,813,812 0 19,234,610 1,792,322 400,819 11,504 85,912 212,222 3,704 0 0 5,638 17,786 1,837 0 739,422
3,704
665
TOTALS
2,552,818
22,071,209
13
10
Pembina Trails School Division
OPERATING FUND - EXPENSE DETAIL: FUNCTION 300
20-Dec-07
For the Year Ended June 30, 2007
CODE OBJECT \ PROGRAM 3XX SALARIES 320 Executive, Managerial and Supervisory 330 Instructional - Teaching 350 Instructional - Other 360 Technical, Specialized and Service 370 Secretarial, Clerical and Other 390 Information Technology Total Salaries 4XX EMPLOYEES BENEFITS AND ALLOWANCES 5-6XX SERVICES 510 Professional, Technical and Specialized 520 Communications 530 Utility Services 540 Travel and Meetings 560 Tuition 570 Printing and Binding 580 Insurance and Bond Premiums 590 Maintenance and Repair Services 610 Rentals 620 Property Taxes 630 Advertising 640 Dues and Fees 650 Professional and Staff Development 680 Information Technology Services Total Services 7XX SUPPLIES, MATERIALS AND MINOR EQUIPMENT 710 Supplies 740 Curricular and Media Materials 760 Minor Equipment 780 Information Technology Equipment Total Supplies, Materials and Minor Equipment 96X-99 TRANSFERS 960 School Divisions 980 Organizations and Individuals 999 Recharge Total Transfers TOTALS
10 ADMINISTRATION AND OTHER
20 INSTRUCTION
0
TOTALS
0
0 0 0 0 0 0 0 0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0 0 0 0 0
0
0
0 0 0 0
0
0
0
0
0
14
ADULT LEARNING CENTRES
Pembina Trails School Division
20-Dec-07
OPERATING FUND - EXPENSE DETAIL: FUNCTION 400 For the Year Ended June 30, 2007 20 ENGLISH AS AN ADDITIONAL LANGUAGE FOR ADULTS
CODE OBJECT \ PROGRAM 3XX SALARIES 320 Executive, Managerial and Supervisory 330 Instructional - Teaching 350 Instructional - Other 360 Technical, Specialized and Service 370 Secretarial, Clerical and Other 380 Clinician 390 Information Technology Total Salaries 4XX EMPLOYEES BENEFITS AND ALLOWANCES 5-6XX SERVICES 510 Professional, Technical and Specialized 520 Communications 540 Travel and Meetings 570 Printing and Binding 590 Maintenance and Repair Services 610 Rentals 630 Advertising 640 Dues and Fees 650 Professional and Staff Development 680 Information Technology Services Total Services 7XX SUPPLIES, MATERIALS AND MINOR EQUIPMENT 710 Supplies 740 Curricular and Media Materials 760 Minor Equipment 780 Information Technology Equipment Total Supplies, Materials and Minor Equipment 96X-99 TRANSFERS 980 Organizations and Individuals Total Transfers TOTALS
CONTINUING EDUCATION
30 COMMUNITY SERVICES AND RECREATION
40 PRE-KINDERGARTEN EDUCATION
108,760 4,155
18,665 34,637
32,761
0
0
145,676 8,987 55,347 1,280 23,823 361
53,302 4,118
293
7,852 5,682 720 0
0
95,065
293
237,604 5,348 15,550
1,951
TOTALS 127,425 4,155 34,637 32,761 0 0 0 198,978 13,105 55,347 1,280 24,116 361 0 7,852 0 5,682 720 0 95,358
0
0
258,502
1,951
239,555 5,348 15,550 0 260,453
0
0
0
0
0 0
0
0
508,230
59,664
567,894
15
10
COMMUNITY EDUCATION AND SERVICES
Pembina Trails School Division
20-Dec-07
OPERATING FUND - EXPENSE DETAIL: FUNCTION 500 For the Year Ended June 30, 2007 20 INSTRUCTIONAL MANAGEMENT & ADMINISTRATION
30 BUSINESS AND ADMINISTRATIVE SERVICES
CODE OBJECT \ PROGRAM 3XX SALARIES 310 Trustees Remuneration 320 Executive, Managerial and Supervisory 360 Technical, Specialized and Service 370 Secretarial, Clerical and Other 390 Information Technology Total Salaries 4XX EMPLOYEES BENEFITS AND ALLOWANCES 5-6XX SERVICES 510 Professional, Technical and Specialized 520 Communications 540 Travel and Meetings 570 Printing and Binding 580 Insurance and Bond Premiums 590 Maintenance and Repair Services 610 Rentals 630 Advertising 640 Dues and Fees 650 Professional and Staff Development 680 Information Technology Services Total Services 7XX SUPPLIES, MATERIALS AND MINOR EQUIPMENT 710 Supplies 740 Curricular and Media Materials 760 Minor Equipment 780 Information Technology Equipment Total Supplies, Materials and Minor Equipment 96X-99 TRANSFERS 960 School Divisions 980 Organizations and Individuals 999 Recharge Total Transfers
596,962 76,077 312,253
399,502
96,265
474,253
154,208 3,152
985,292 78,095
873,755 121,355
31,911 252,879 381,055 38,217
99,053 3,872 25,808
97,014 23,856 90,512 10,471
59,783 59,996 4,215
TOTALS
BOARD OF TRUSTEES
50 MANAGEMENT INFORMATION SERVICES
154,208
2,202 22,980
104,580 1,263 39,965 81,328 18,236
19,960 13,121 5,374
16,189 9,314
228,297
260,308
295,305
3,856 2,892
62,439 3,242 3,883
19,591 2,919 8,117
6,748
69,564
30,627
16,740 95,749 137,671 2,325 11,977 155,920 170,222
425
425
0
0
392,830
1,393,259
1,321,042
TOTALS 154,208 1,092,729 76,077 818,417 252,879 2,394,310 240,819 258,052 87,724 143,515 10,471 104,580 1,263 39,965 19,960 110,638 49,664 95,749 921,581 88,211 6,161 26,869 155,920 277,161 425 0 0 425
727,165
3,834,296
16
10
DIVISIONAL ADMINISTRATION
Pembina Trails School Division
OPERATING FUND - EXPENSE DETAIL: FUNCTION 600
20-Dec-07
For the Year Ended June 30, 2007
CODE OBJECT \ PROGRAM 3XX SALARIES 320 Executive, Managerial and Supervisory 330 Instructional - Teaching 350 Instructional - Other 360 Technical, Specialized and Service 370 Secretarial, Clerical and Other 390 Information Technology Total Salaries 4XX EMPLOYEES BENEFITS AND ALLOWANCES 5-6XX SERVICES 510 Professional, Technical and Specialized 520 Communications 540 Travel and Meetings 570 Printing and Binding 580 Insurance and Bond Premiums 590 Maintenance and Repair Services 610 Rentals 630 Advertising 640 Dues and Fees 650 Professional and Staff Development 680 Information Technology Services Total Services 7XX SUPPLIES, MATERIALS AND MINOR EQUIPMENT 710 Supplies 740 Curricular and Media Materials 760 Minor Equipment 780 Information Technology Equipment Total Supplies, Materials and Minor Equipment 96X-99 TRANSFERS 960 School Divisions 980 Organizations and Individuals Total Transfers TOTALS
05 CURRICULUM CONSULTING & DEVELOPMENT ADMINISTRATION
10
20
30
80
CURRICULUM CONSULTING & DEVELOPMENT
LIBRARY / MEDIA CENTRE
PROFESSIONAL AND STAFF DEVELOPMENT
OTHER
TOTALS
120,965 352,081
1,670,348 786,694 36,478
629,855
36,228 170,475
125,365 246,330 21,404
352,081 14,770
29,762 2,523,282 200,928
2,954 885 4,307
9,417
629,855 30,880
206,703 13,687
8,485 4,884
15,850
1,706
973
46,830 3,207 785
1,941
5,977
14,312
1,837
40,167 2,240
1,837
275,548
2,509 44,916
426,079
10,354 58,890 9,639 49,342 4,337 27,011 90,329
2,873,429
120,965 2,688,512 786,694 206,953 125,365 29,762 3,958,251 281,669 27,289 5,769 16,403 0 0 46,830 3,207 0 11,142 613,950 10,354 734,944
7,096 613,950
1,320
637,622
18,143
20,730 13,491
31,375
34,221
31,375
103,748 65,073 4,337 29,520 202,678
0 269,908
0 0 0 5,177,542
1,332,578
17
INSTRUCTIONAL AND OTHER SUPPORT SERVICES
Pembina Trails School Division
20-Dec-07
OPERATING FUND - EXPENSE DETAIL: FUNCTION 700 For the Year Ended June 30, 2007 20
ADMINISTRATION
REGULAR
70 ALLOWANCES IN LIEU OF TRANSPORTATION
CODE OBJECT \ PROGRAM 3XX SALARIES 320 Executive, Managerial and Supervisory 350 Instructional - Other 360 Technical, Specialized and Service 370 Secretarial, Clerical and Other 390 Information Technology Total Salaries 4XX EMPLOYEES BENEFITS AND ALLOWANCES 5-6XX SERVICES 510 Professional, Technical and Specialized 520 Communications 540 Travel and Meetings 550 Transportation of Pupils 580 Insurance and Bond Premiums 590 Maintenance and Repair Services 610 Rentals 630 Advertising 640 Dues and Fees 650 Professional and Staff Development 680 Information Technology Services Total Services 7XX SUPPLIES, MATERIALS AND MINOR EQUIPMENT 710 Supplies 740 Curricular and Media Materials 760 Minor Equipment 780 Information Technology Equipment Total Supplies, Materials and Minor Equipment 96X-99 TRANSFERS 960 School Divisions 980 Organizations and Individuals 999 Recharge Total Transfers TOTALS
80 BOARDING OF STUDENTS/ DORMITORIES
90 FIELD TRIPS AND OTHER
TOTALS
65,779 417,398
97,717
65,294 131,073 19,483
417,398 61,098
0
386 1,295 2,249
1,095 420,455 21,058 55,948
97,717 14,304 91 256 67,701 4,930 13,098
42,063
561 1,102
4,725
5,207
503,667
2,854
174,331
40,813
6,577
1,540
2,854
42,063
180,908
0
0
86,076
65,779 0 515,115 65,294 0 646,188 94,885 477 1,295 3,600 530,219 25,988 69,046 0 0 5,286 1,102 0 637,013
42,353
217,998 0 8,117 0 226,115
0
0
0
0
0
0 0 0 0
158,617
1,163,071
42,063
0
240,450
1,604,201
18
10
TRANSPORTATION OF PUPILS
Pembina Trails School Division
20-Dec-07
OPERATING FUND - EXPENSE DETAIL: FUNCTION 800 For the Year Ended June 30, 2007 20
ADMINISTRATION
SCHOOL BUILDINGS MAINTENANCE
OPERATIONS AND MAINTENANCE CODE OBJECT \ PROGRAM 3XX SALARIES 320 Executive, Managerial and Supervisory 360 Technical, Specialized and Service 370 Secretarial, Clerical and Other 390 Information Technology Total Salaries 4XX EMPLOYEES BENEFITS AND ALLOWANCES 5-6XX SERVICES 510 Professional, Technical and Specialized 520 Communications 530 Utility Services 540 Travel and Meetings 580 Insurance and Bond Premiums 590 Maintenance and Repair Services 610 Rentals 620 Property Taxes 630 Advertising 640 Dues and Fees 650 Professional and Staff Development 680 Information Technology Services Total Services 7XX SUPPLIES, MATERIALS AND MINOR EQUIPMENT 710 Supplies 740 Curricular and Media Materials 760 Minor Equipment 780 Information Technology Equipment Total Supplies, Materials and Minor Equipment 96X-99 TRANSFERS 999 Recharge TOTALS
50 SCHOOL BUILDINGS REPAIRS AND REPLACEMENTS
70
80
OTHER BUILDINGS
GROUNDS
484,162 4,344,110
37,764
21,706
37,764 5,357
21,706 1,851
3,443 6,546 106,386
156,377 226
9,305 58,374 182,818
398 153,521 1,634 1,559
366,872
313,715
85,626 569,788 82,247
4,344,110 647,674
15,131 7,685
62,570 978 2,327,225 4,534 130,831 521,408 82 65,635
16,692 583
0
1,226,446
1,254 1,637
1,989
42,982
3,115,252
8,337
681,950
5,890
16,468
250
64,862
1,997
9,186
8,587
746,812
7,887
25,654
1,226,446
0
TOTALS 484,162 4,403,580 85,626 0 4,973,368 737,129 237,521 15,435 2,433,611 21,226 140,534 1,960,332 1,716 250,012 0 1,254 3,626 0 5,065,267 712,645 0 76,295 0 788,940 0
703,604
8,853,848
1,226,446
417,880
362,926
11,564,704
19
10
Pembina Trails School Division
20-Dec-07
OPERATING FUND - DETAIL OF TRANSFERS TO (FROM) CAPITAL FUND For the Year Ended June 30, 2007
Transfers To Capital Fund Category "D" School Buildings
-
Bus Reserve
1,000,000
Bus Purchases
1,125,775
Other: Vehicle Additions
44,908
Land Improvements
85,613
Unsupported Capital Projects
1,577,723
Furniture and Fixtures
253,561
Equipment Additions
110,053
Computer Hardware Additions
262,620
Computer Software Additions
61,508
Lease Payments and Lease Interest
162,900
4,684,661
Less: Transfers From Capital Fund -
0 Net Transfers To (From) Capital Fund
4,684,661
20
Pembina Trails School Division
20-Dec-07
CAPITAL FUND SCHEDULE OF FINANCIAL POSITION as at June 30 2007
2006
Financial Assets Cash and Bank
1,211,891
194,041
-
49,325
666,684
-
- Federal Government
-
-
- Municipal Government
-
-
- First Nations
-
-
- Other Funds
202,520
-
Accounts Receivable
-
434,022
Accrued Investment Income
-
Short Term Investments Due from
- Provincial Government
2,081,095
677,388
-
-
Accounts Payable
584,869
351,235
Accrued Liabilities
-
-
Liabilities Overdraft
Accrued Interest Payable Due to
666,684
- Provincial Government
-
-
- Federal Government
-
-
- Municipal Government
-
-
- First Nations
-
-
- Operating Fund
-
815,110
Deferred Revenue
317,729
Debenture Debt
21,011,290
22,196,712
575,269
-
23,155,841
23,363,057
(21,074,746)
(22,685,669)
Net Tangible Capital Assets
40,056,953
95,578,968
Accumulated Surplus / Equity *
18,982,207
72,893,299
1,236,486
218,636
17,745,721
72,674,663
18,982,207
72,893,299
Other Borrowings
Net Debt Non-Financial Assets
* Comprised of: Reserve Accounts Equity in Tangible Capital Assets
21
Pembina Trails School Division
20-Dec-07
CAPITAL FUND SCHEDULE OF REVENUE, EXPENSES AND ACCUMULATED SURPLUS For the Year Ended June 30 2007
2006
Revenue Provincial Government Grants
1,244
256
- Principal
2,451,022
2,220,925
- Interest
1,750,413
1,878,739
Federal Government
-
-
Municipal Government
-
-
17,850
18,318
121,270
-
-
-
0
-
4,341,799
4,118,238
Debt Servicing
Other Sources: Investment Income Donations Insurance Proceeds -
EXPENSES Amortization
2,743,071
Debenture Debt Interest
1,750,413
1,878,739
Other Interest
74,449
-
Other Capital Items
16,804
Loss / (Gain) on Disposal of Capital Assets
Current Year Surplus / (Deficit)
34,723
4,584,737
1,913,462
(242,938)
Net Transfers from (to) Operating Fund
4,684,661
Transfers from Special Purpose Fund
2,204,776 2,600,217
-
Net Current Year Surplus (Deficit)
Opening Accumulated Surplus / Equity Restatements:
-
Tangible Capital Assets and Accum. Amortization Establish Lease Liability & Deferred Revenue
4,441,723
4,804,993
72,893,299
68,088,306
(57,086,147) (1,266,668)
Opening Accumulated Surplus / Equity as restated
14,540,484
68,088,306
Closing Accumulated Surplus / Equity
18,982,207
72,893,299
22
Pembina Trails School Division
20-Dec-07
SCHEDULE OF TANGIBLE CAPITAL ASSETS at June 30, 2007 Buildings and Leasehold Improvements School
School Buses
Non-School
Furniture / Fixtures & Equipment
Other Vehicles
Computer Hardware & Software *
Land
Land Improvements
Assets Under Construction
-
-
Totals
Tangible Capital Asset Cost Restatements Opening Cost restated
71,432,112 (5,161,060)
4,854,587 173,637
2,218,136 (299,913)
353,196
8,478,432
-
8,242,505
95,578,968
(164,643)
(4,273,610)
722,174
(5,467,337)
77,178
1,352,596
(13,040,978)
1,352,596
82,537,990
66,271,052
5,028,224
1,918,223
188,553
4,204,822
722,174
2,775,168
77,178
3,515,667
-
790,381
85,790
470,500
324,128
-
96,824
-
-
-
-
-
-
-
-
-
-
69,786,719
5,028,224
2,708,604
274,343
4,675,322
1,046,302
2,775,168
174,002
376,509
86,845,193
-
-
-
-
-
-
-
-
-
-
Restatements
40,503,093
2,212,209
462,990
113,665
471,256
249,850
-
32,106
-
44,045,169
Opening restated
40,503,093
2,212,209
462,990
113,665
471,256
249,850
-
32,106
-
44,045,169
1,610,899
117,964
228,222
43,942
516,195
213,290
-
12,559
-
-
-
-
-
-
-
-
-
-
Closing Accumulated Amortization
42,113,992
2,330,173
691,212
157,607
987,451
463,140
-
44,665
-
46,788,240
Net Tangible Capital Asset
27,672,727
2,698,051
2,017,392
116,736
3,687,871
583,162
2,775,168
129,337
376,509
40,056,953
-
-
-
-
-
-
-
Add: Additions during the year Less: Disposals and write downs Closing Cost
(976,087)
4,307,203
Accumulated Amortization Opening, as previously reported
Add: Current period Amortization Less: Accumulated Amortization on Disposals and Writedowns
Proceeds from Sale of Capital Assets
* Includes network infrastructure.
2,743,071
-
23
Opening Cost, as previously reported
Pembina Trails School Division
20-Dec-07
SCHEDULE OF CAPITAL RESERVE ACCOUNTS For the Year Ended June 30, 2007
Opening Balance, July 1, 2006 Additions: (Provide a description of each transaction) Transfer from Operating Fund Investment Income
Total Additions Withdrawals: (Provide a description of each transaction)
Total Withdrawals Closing Balance, June 30, 2007
Roblin Office Leasehold
Buses
Totals
58,521
160,115
-
1,000,000 11,882
5,968
1,011,882
5,968
-
-
-
-
-
1,070,403
166,083
-
-
-
-
218,636
-
1,000,000 17,850 1,017,850
-
-
-
-
-
1,236,486
-
24
Fund Name >
Pembina Trails School Division
20-Dec-07
SPECIAL PURPOSE FUND SCHEDULE OF FINANCIAL POSITION as at June 30 2007 Financial Assets Cash and Bank
1,306,399
Short Term Investments
-
Accrued Investment Income
-
Other Investments
1,306,399
Liabilities School Generated Funds Liability
909,867
Accounts Payable
-
Accrued Liabilities
-
Due to Other Funds
-
Deferred Revenue
909,867
Accumulated Surplus *
396,532
* Comprised of: School Generated Funds Accumulated Surplus Other Funds Accumulated Surplus
396,532 396,532
25
Pembina Trails School Division
20-Dec-07
SPECIAL PURPOSE FUND SCHEDULE OF REVENUE, EXPENSES AND ACCUMULATED SURPLUS For the Year Ended June 30 2007 Revenue School Generated Funds
1,139,894
Other Funds
1,139,894
Expenses School Generated Funds
1,167,048
Other Funds
1,167,048
Current Year Surplus (Deficit)
(27,154)
Transfers (to) Operating Fund
-
Transfers (to) Capital Fund
-
Net Current Year Surplus (Deficit)
(27,154)
Opening Accumulated Surplus Restatements:
-
School Generated Funds
423,686
Other Funds
-
Opening Accumulated Surplus as restated
423,686
Closing Accumulated Surplus
396,532
26
Pembina Trails School Division
20-Dec-07
STUDENT ENROLMENTS (FRAME) AND TRANSPORTATION STATISTICS (UNAUDITED)
ENROLMENTS BY PROGRAM
F.T.E. Enrolment September 30, 2006
REGULAR INSTRUCTION English Language - Single Track
8,129.0
Francais - Single Track
-
French Immersion - Single Track
1,305.5
Dual Track - English Language
2,325.5
- Francais
-
- French Immersion
752.5
- Other Bilingual
-
Senior Years Technology Education
3,078.0 -
TOTAL REGULAR INSTRUCTION
12,512.5
STUDENT SUPPORT SERVICES : Special Placement TOTAL NUMBER OF FULL TIME EQUIVALENT K - 12 STUDENTS
64.0 12,576.5
TRANSPORTATION OF PUPILS
TRANSPORTED STUDENTS
1,712
TOTAL KILOMETERS - LOG BOOK
535,802
TOTAL KILOMETERS - BUS ROUTES
384,940
LOADED KILOMETERS
257,640
27
Pembina Trails School Division
20-Dec-07
FULL TIME EQUIVALENT PERSONNEL (UNAUDITED) September 30, 2006
OBJECT \ FUNCTION
320 Executive, Managerial, & Supervisory
FUNCTION
FUNCTION
FUNCTION
FUNCTION
FUNCTION
FUNCTION
FUNCTION
100
200
300
400
500
600
700
800
49.38
2.00
723.75
104.67
350 Instructional - Other
20.03
397.46
360 Technical, Specialized And Service
12.67
370 Secretarial, Clerical And Other
69.69
330 Instructional - Teaching
380 Clinician 390 Information Technology TOTALS (excluding Trustees)
310 TRUSTEES
5.74
10.30
1.12 2.87
4.23
1.00
1.00
TOTALS 8.20
31.83
860.25
26.57
445.18
1.28
7.20
12.43
108.77
145.22
20.43
4.00
1.90
2.44
102.69
25.75
25.75
16.55 892.07
534.11
77.62
3.99
5.74
4.89
0.50
36.90
71.10
9
21.94 15.33
119.41
1,678.65
28
CODE
FUNCTION
Pembina Trails School Division: 2006/2007 Financial Statements
20-Dec-07
CALCULATION OF ADMINISTRATION COSTS AS A PERCENTAGE OF TOTAL EXPENSES
Administration Costs Divisional Administration, Function 500
3,834,296
Curriculum Consulting & Development Administration, Program 605
275,548
Transportation Administration, Program 710
158,617
Operations & Maintenance Administration, Program 810
703,604
Sub-total
4,972,065
Less: Liability Insurance Administration portion of self-funded expenses (see below)
92,127 496,718 * 4,383,220 (A)
Expense Base Total Operating Expenses Plus:
115,812,923
Transfers to Capital
4,684,661
Less: Adult Learning Centres, Function 300
0 120,497,584 (B)
Percentage (A) / (B)
3.6%
Self-Funded Expenses (fully offset by incremental revenues): International Student Programs Expenses (1) Instructional Administration (deducted above) Other:
249,126 496,718 *
School Renovation Funded through ISP
38,844 784,688
Associated Revenue
(2)
1,249,177
Self-Administered Pension Plans Expenses (1) Administration (deducted above)
- *
Other:
0
Associated Revenue
(2)
-
(1) Incremental costs of the program. (2) Tuition fees from international students or the pension plan administration fee.
29
Pembina Trails School Division : 2006/2007 Financial Statements
20-Dec-07
CALCULATION OF ALLOWABLE EXPENSES
100 Regular Instruction 210 - 260 Student Support Services 270 Counselling and Guidance 300 Adult Learning Centres 400 Community Education and Services 500 Administration 605 Curriculum Consulting Administration 610 Curriculum Consulting 620 Library / Media Centre 630 Professional and Staff Development 680 Other 700 Transportation of Pupils 800 Operations and Maintenance 900 Fiscal SUBTOTAL (ALLOCATED) UNALLOCATED REVENUE/FUNDING TOTAL
TOTAL EXPENSES 68,855,110 19,518,391 2,552,818 0 567,894 3,834,296 275,548 426,079 2,873,429 1,332,578 269,908 1,604,201 11,564,704 2,137,967
115,812,923
(1) To determine Allowable Expenses for Student Support Services.
795,010
9,397,198
385,870 57,974
545,853 14,754,196
1,976,929 0
1,154,038 52,184,313
443,844
15,300,049
1,976,929
53,338,351
ALLOWABLE EXPENSES 65,503,974 12,895,070 (1) 2,552,818 0 55,783 3,335,078 275,548 426,079 2,170,595 1,325,567 268,824 1,369,070 10,831,672
30
FUNCTION / PROGRAM
REDUCTIONS TO EXPENSES OTHER NON-PROVINCIAL SOURCES ADJUSTMENTS CATEGORICAL OTHER PROVINCIAL TUITION, TO AND BASE PROGRAM GOVERNMENT TRANSFER AND EXPENSES SUPPORT SUPPORT REVENUE RESIDUAL FEES OTHER < < < ( from Appendix A ) > > > < < < ( from Appendix B ) > > > 750,102 2,323,515 76,400 101,222 1,439,009 161,092 0 6,290,253 292,950 40,118 0 0 0 0 0 0 0 0 80,596 144,181 287,334 0 0 0 496,718 2,500 0 0 0 0 0 0 0 0 0 702,834 0 0 0 0 0 7,011 0 0 0 1,084 0 0 0 7,500 227,631 44,908 309,470 0 468,470
Pembina Trails School Division : 2006/2007 Financial Statements
20-Dec-07
CALCULATION OF ALLOWABLE EXPENSES (refer to "Allow Guide") Function/ Program
Capitalized Energy Mgmt. Systems Costs (add) (1), (2) Capitalized Section "D" School Bldgs. Costs (add) (1) Lease costs paid to other School Divisions (deduct) Transfers from Capital Fund (deduct) Leased Non-School Space (deduct) Transfers from Special Purpose Fund (deduct) Employee Future Benefits Restatement (add) Other Adjustments (specify Item and Function/Program) (2) Vehicle Additions Furniture and Fixtures Equipment Additions Computer Hardware Additions Computer Software Additions Lease Interest on Copiers, Postage Machines
Amount
800 800 800 800 800
CATEGORICAL AND BASE SUPPORT TO BE ALLOCATED:
0 0
800 100 100 100 100 100
44,908 253,561 154,469 267,620 61,508 12,944
Curricular Materials Information Technology Special Needs: Coordinator/Clinician (A) Maximum Support (B) Eligible Expenses (C) Less related revenues (D) Allowable Expenses (B) - (C)
ELIGIBLE SUPPORT 702,834 511,152
894,516 1,997,049 1,997,049
Eligible Support (lesser of A or D) Special Needs: Level II and III Senior Years Technology Education English as an Additional Language Aboriginal Academic Achievement Heritage Language French Language Small Schools (A) Maximum Support (B) Program Expenses Eligible Support (lesser of A or B) Early Childhood Development Early Literacy Intervention Early Numeracy Experiential Learning
894,516 5,395,737 172,068 439,400 195,400 5,481 530,844
0 80,596 366,300 61,440 41,430
Total amount to be allocated on page 23 (Allowable Expenses) Total Adjustments to Expenses
9,397,198
795,010
(1) Net of all related revenues. (2) For capitalized energy management systems costs and other capitalized items, lease and loan payments for eligible equipment may be included.
CALCULATION OF ALLOWABLE SECTION "D" EXPENSES: Program 850 School Building Repairs & Replacements PLUS: Capitalized Section "D" Expenses (net) Grounds LESS: Related revenue other than "D" Support
OTHER PROGRAM SUPPORT:
1,226,446 0
School Buildings Support: "D" Projects Technology Education Equipment & Technical Vocational Initiative Other Minor Capital Support Curricular Materials Prior Year Support Finalization of Previous Year's support
309,470 76,400 0 0 57,974
Allowable Section "D" Expenses < OR > Expenses to be used for calculating "D" Grant if different from above (cannot be more than amount on line C)
Amount carried forward to Allowable Expenses
443,844
Refer to page 2 of the Allowable Expenses Guide when completing this section.
(C)
1,226,446
(D)
31
ADJUSTMENTS TO EXPENSES: (enter deductions as negative amounts)
APPENDIX A
Pembina Trails School Division : 2006/2007 Financial Statements
20-Dec-07
CALCULATION OF ALLOWABLE EXPENSES
APPENDIX B
OTHER PROVINCIAL GOVERNMENT REVENUE: Allocated
Unallocated
Other Dept. of Education, Citizenship & Youth General Support Grant Education Property Tax Credit All other Other Provincial Government Departments
401,672 144,181
Total Revenue
545,853
Total
1,904,100 12,850,096
1,904,100 12,850,096 401,672 144,181
14,754,196
15,300,049
ALL REVENUES REPORTED ON THIS PAGE, EXCEPT THOSE SHADED, MUST BE DEDUCTED FROM TOTALEXPENSES ON PAGE 23 UNLESS THERE ARE SPECIAL CIRCUMSTANCES WHICH WOULD MAKEAN ALLOCATIONIMPRACTICALOR INAPPROPRIATE. IN THOSE LIMITEDCASES,REASONS FOR NOT ALLOCATINGMUST BE PROVIDED BELOW.
NON-PROVINCIAL SOURCES:
Total Revenue
Unallocated
0 13,230
Total 0 13,230
0
51,747,990
51,747,990 0
653,250 40,118 0
653,250 40,118 0
0 0
0 0
1,283,561 766,367
1,283,561 766,367 436,323
436,323 0 374,441
52,184,313
55,315,280
0 374,441 3,130,967
32
Allocated Federal Government Tuition Fees All other Municipal Government Net Special Requirement Other Other School Divisions Transfer Fees Residual Fees All other First Nations Tuition Fees All other Private Organizations and Individuals Tuition Fees Ancillary Services Other Sources Interest Donations Other
TOTAL FEES 1,976,929 (to agree with total tuition, transfer and residual fees on page 23)
TOTAL OTHER REVENUE (to agree with total other revenue on page 23)
53,338,351