EFIS Instructions
2024-25
2024-25 Financial Statements
Schedules
Schedule 1.2

Schedule 1.2 - Consolidated Statement of Cash Flow

The Consolidated Statement of Cash Flow shows how a school board generated and used cash and cash equivalents in the accounting period, divided into separate categories for operating, capital, investing, and financing transactions, and calculates the change in cash and cash equivalents in the period. It also shows the cash and cash equivalents at the beginning and end of the accounting period. The presentation of the form conforms to Public Sector Accounting Board (PSAB) section PS 1201.

This schedule aligns sources of cash to the proper cash categories, which include:

  • Separating the changes in accounts receivable and deferred revenues into operating and capital, where those capital-related changes are under financing transactions.

  • Breaking down the changes in deferred capital contributions (DCC) into its components, where the DCC revenues are classified as non-cash items and the additions/(disposal) from DCC are classified as financing transactions.

Column 1 (2024-25)

Operating Transactions

  • Item 1 (Annual surplus (deficit) for Consolidated Statement of Cash Flow): Loaded from Schedule 1.1, item 3.1.

  • Item 2.1 (Amortization, write downs, (gain) loss on disposal of TCA and transfers to AHFS): Calculated as:

    • Schedule 10, column 12 (Amortization and Write Downs and Net Loss on Disposal - TCA), item 90 (Total Expenses Category), minus

    • Schedule 3C-3 total gain on disposal minus gain on disposal for restricted assets (i.e., related to land, land improvements, buildings (40 years and other), buildings permanently removed from service, and capital leased land and buildings), plus

    • Schedule 3D total loss on disposal (column 9) and in-year additions (column 3).

  • Item 2.2 (Amortization, impairments and transfer to AHFS on PI): Calculated as the total purchased intangibles amortization, impairments, and net book value of transfers to financial assets (Schedule 3G, item 2.0, - col. 7 + col. 15 - col. 5 + col. 12 + col. 13).

  • Item 2.3 (Amortization on TCA-ARO): Loaded from Schedule 3E-2, column 12 (ARO Accumulated Amortization - Amortization Expense) total.

  • Item 2.4 (Increase (Decrease) of ARO Liabilities excluding settlements): Calculated as the difference in value between the current year and prior year ARO liability balance on Schedule 7, item 2.10, minus the total ARO abatements from Schedule 5.7, column 8.

  • Item 2.5 (Decrease (Increase) of TCA-ARO asset excluding amortization on TCA-ARO): Calculated as the negative of the change in net book value of TCA-ARO assets (-1 x Schedule 3E-3, column 17 minus column 18) minus TCA-ARO amortization (Schedule 3E-2, column 12).

  • Item 2.6 (Deferred capital contributions revenue): Loaded from Schedule 5.3, item 2.3 (Total Deferred Capital Contributions), column 6 (Amortization).

  • Item 2.7 (Deferred Gain on Disposal of Restricted Assets): Calculated as the negative of the gain on disposal from Schedule 3C-3 for all restricted assets (i.e., related to land, land improvements, buildings (40 years and other), buildings permanently removed from service, and capital leased land and buildings).

  • Item 2.8 (Decrease (Increase) in other investments (operating)): Calculated as the negative of the change in value from the current year to the prior year of the amount on Schedule 7, item 1.3.1 (FP - Other Investments (Operating)).

  • Item 2.9 (Redemption (Acquisition) of derivatives): Calculated as the negative of the change in value from the current year to the prior year of the two rows on Schedule 7 related to derivatives (items 1.5 and 2.9), plus Schedule 1.4, item 4.3 (Net Remeasurement Gains (Losses) - Derivatives).

  • Item 2.10 (Decrease (Increase) in accounts receivable - other): Calculated as the negative of the change in value from the current year to the prior year of the amounts on the following rows on Schedule 7:

    • Item 1.4.1 (FP - Accounts Receivable - Municipalities)
    • Item 1.4.2 (FP - Accounts Receivable - School Boards)
    • Item 1.4.3 (FP - Accounts Receivable - Government of Ontario)
    • Item 1.4.5 (FP - Accounts Receivable - Government of Canada)
    • Item 1.4.6 (FP - Accounts Receivable - First Nation)
    • Item 1.4.8 (FP - Accounts Receivable - Other)

  • Item 2.11 (Decrease (Increase) in accounts receivable - Delayed Grant Payment): Calculated as the negative of the change in value from the current year to the prior year of the amount on Schedule 7, item 1.4.7 (FP - Accounts Receivable - Delayed Grant Payment).

  • Item 2.12 (Decrease (Increase) in other financial assets): Calculated as the negative of the change in value from the current year to the prior year of the amount on Schedule 7, item 1.7 (FP - Financial Assets - Other).

  • Item 2.13 (Decrease (Increase) in assets held for sale): Calculated as the negative of the change in value from the current year to the prior year of the amounts on the following rows on Schedule 7:

    • Item 1.6.1 (FP - Assets Held for Sale - TCA)
    • Item 1.6.2 (FP - Assets Held for Sale - Purchased Intangibles)

  • Item 2.14 (Increase (Decrease) in Accounts payable & Accrued liabilities): Calculated as the change in value from the current year to the prior year of the amount on Schedule 1, item 2.2 (FP - Accounts Payable and Accrued Liabilities) plus Schedule 1.4, item 4.2 (Net Remeasurement Gains (Losses) - Foreign Exchange on Foreign Accounts Payable).

  • Items 2.15 (Increase (Decrease) in Other liabilities): Calculated as the change in value from the current year to the prior year of the amount on Schedule 7, item 2.3 (FP - Liabilities - Other).

  • Item 2.16 (Increase (Decrease) in deferred revenues - operating): Calculated as Schedule 5.1, item 5 (Deferred Revenue Operating), column 7 (closing balance) minus column 1 (opening balance).

  • Item 2.17 (Increase (Decrease) employee benefits payable): Calculated as the change in value from the current year to the prior year of the amount on Schedule 7, item 2.7 (FP - Employee Benefits Payable).

  • Item 2.18 (Decrease (Increase) in prepaid expenses): Calculated as the negative of the change in value from the current year to the prior year of the amount on Schedule 7, item 4.1 (FP - Prepaid Expenses).

  • Item 2.19 (Decrease (Increase) in inventories of supplies): Calculated as the negative of the change in value from the current year to the prior year of the amount on Schedule 7, item 4.2 (FP - Inventories of Supplies).

  • Item 2.20 (Net additions to purchased intangibles): Calculated as Schedule 3G, item 2.0, the negative of (column 4 + column 6 - column 14).

  • Item 2.21 (Settlement of Asset Retirement Liability through abatement): Loaded as the total ARO liability abatements from Schedule 5.7, item 16, column 8.

  • Item 2 is the sum of items 1 to 2.21.

Capital Transactions

  • Item 3.1 (Proceeds on sale of tangible capital assets): Loaded from Schedule 3C-3, item 6 (Total Tangible Capital Assets), column 20 (Proceeds of Disposition).

  • Item 3.2 (Cash used to acquire tangible capital assets): Loaded as the negative of the total additions from Schedule 3C-1, item 6 (Total Tangible Capital Assets), column 4 (Cost - Additions and Betterments).

  • Item 3 is the sum of items 3.1 and 3.2.

Investing Transactions

  • Item 4.1 (Decrease (Increase) in portfolio investments measured at amortized cost): Calculated as the negative of the change in value from the current year to the prior year of the amount on Schedule 7, item 1.2.1 (FP - Portfolio Investments measured at amortized cost).

  • Item 4.2 (Redemption (Acquisition) of portfolio investments measured at fair value): Calculated as the negative of the change in value from the current year to the prior year of the amount on Schedule 7, item 1.2.2 (FP - Portfolio Investments measured at fair value) plus the amount on Schedule 1.4, item 4.4 (Net Remeasurement Gains (Losses) - Portfolio Investments).

  • Item 4.3 (Decrease (Increase) in other investments (investing)): Calculated as the negative of the change in value from the current year to the prior year of the amount on Schedule 7, item 1.3.2 (FP - Other Investments (Investing)).

  • Item 4 is the sum of items 4.1 to 4.3.

Financing Transactions

  • Item 5.1 (Long term liabilities issued): Loaded from Schedule 5A, item 2 (Unsupported Permanently Financed Capital Debts), column 3 (Capital Leases and Debenture Issue).

  • Item 5.2 (Increase (Decrease) in temporary borrowing): Calculated as the change in value from the current year to the prior year of the amount on Schedule 7, item 2.1 (FP - Temporary Borrowing).

  • Item 5.3 (Debt repaid and sinking fund contributions): Calculated as the total retirement of capital debt and sinking funds from Schedule 5A, columns 2 (Capital Debts - Permanent Debt Retirement) and 9 (Sinking Fund Assets - Retirement), minus columns 4 (Principal Payments), 6 (Sinking Fund Contributions), and 10 (Sinking Fund Assets - Interest Earned).

  • Item 5.4 (Long Term Financing - Other principal repayment): Loaded from Schedule 5.8-1, item 2.0, column 6 (Principal Payments).

  • Item 5.5 (Decrease (Increase) in accounts receivable - Gov of Ontario - Approved capital): Calculated as the negative of the change in value from the current year to the prior year of the amount on Schedule 7, item 1.4.4 (FP - Accounts Receivable - Government of Ontario - Approved Capital).

  • Item 5.6 (Additions to (disposals from) deferred capital contributions): Calculated as the sum of amounts from Schedule 5.3, item 2.3 (Total Deferred Capital Contributions), columns 2 (Additions), 3 (Prior Eligible Cap Exp), 3.1 (Prior Years Capital Grant adjustments), and 5 (Disposals and Transfer to Financial Assets).

  • Item 5.7 (Increase (Decrease) in deferred revenues - Capital): Calculated as Schedule 5.1, item 14 (Deferred Revenue Capital), column 7 (closing balance) minus column 1 (opening balance).

  • Item 5 is the sum of items 5.1 to 5.7.

Other
  • Item 6 (Net Remeasurement Gains (Losses) - Foreign Exchange on Foreign Currency): Loaded from Schedule 1.4, item 4.1 (Net Remeasurement Gains (Losses) - Foreign Exchange on Foreign Currency). This value is added to the change in cash and cash equivalents in the year (item 7) and the opening cash and cash equivalents (item 8) to calculate the closing balance of cash and cash equivalents (item 9).

Column 2 (2023-24)

  • Item 1 (Annual surplus (deficit) for Consolidated Statement of Cash Flow): Loaded from Schedule 1.1, item 3.1.
  • The remaining cells in the prior year column are preloaded based on the prior year’s board-submitted Financial Statements. These are blue cells that can be adjusted, if required.

Relationship to other schedules:

All amounts on this schedule are calculated from:

Last updated on
Schedule 1.1Schedule 1.3