AUDITED FINANCIAL STATEMENTS

Schools' Finance Branch 511-1181 Portage Avenue Winnipeg, Manitoba R3G 0T3 PEMBINA TRAILS SCHOOL DIVISION 181 HENLOW BAY WINNIPEG, MANITOBA R3Y 1M7 ...
Author: Dylan Stephens
0 downloads 2 Views 342KB Size
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 [email protected]€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

Suggest Documents