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

Schedule 1.3 - Consolidated Statement of Change in Net Debt

The Consolidated Statement of Change in Net Debt reports the acquisition of tangible capital assets in the accounting period as well as other significant items (prepaid expenses and supplies inventories) that explain the difference between the annual surplus (deficit) (item 1) and the change in net debt in the period (item 7).

  • Item 1 (Annual Surplus (Deficit) for Consolidated Statement of Change in Net Debt): Loaded from Schedule 1.1, item 3.1.

Column 1 (2024-25)

Tangible Capital Asset Activity

Items 2.1 to 2 (Tangible Capital Asset Activity): These values are calculated from Schedules 3C (Tangible Capital Asset Continuity), 3E (Tangible Capital Asset Continuity - ARO), and 3F (Tangible Capital Asset Total Continuity).

  • Item 2.1 (Acquisition of tangible capital assets and Addition of TCA-ARO): Loaded as the negative of the value from Schedule 3F-1, column 4 total (TCA with ARO Additions).

  • Item 2.2 (Amortization of tangible capital assets): Loaded from Schedule 3F-2, column 14 total (TCA with ARO - Amortization Expense).

  • Item 2.3 (Loss (Gain) on sale of tangible capital assets): Calculated as the negative of Schedule 3C-3, total column 21 (Gain on Disposal) less total column 22 (Loss on Disposal), minus the gains allocated to deferred revenue (item 2.4.1).

  • Item 2.4 (Proceeds on sale of tangible capital assets): Loaded from Schedule 3C-3, total column 20 (Proceeds of Disposition).

  • Item 2.4.1 (Less: Gains on sale allocated to deferred revenue): Calculated as the negative of the sum of Schedule 3C-3 column 21 (Gain on Disposal) from the restricted asset categories (land, land improvements, and buildings from the lines for assets in service, permanently removed from service, and capital leased assets - items 1.1, 1.2, 1.3, 1.4, 3.1, 5.1, and 5.2).

  • Item 2.5 (Transfer to assets held for sale): Calculated as the negative of Schedule 3F-1, total column 9 (TCA with ARO - Transfer to Financial Assets) minus Schedule 3F-2, total column 18 (TCA with ARO Accumulated Amortization - Transfer to Financial Assets).

  • Item 2.6 (Write-downs of tangible capital assets): Calculated as Schedule 3C-2, total column 14 (TCA Accumulated Amortization - Write Downs) minus Schedule 3C-1, total column 7 (Cost - Write Downs).

  • Item 2.7 (Changes in Estimate of TCA-ARO): Calculated as the negative of Schedule 3E-1, total column 3 (ARO - Changes in the Estimate) minus Schedule 3E-2, total column 11 (ARO Accumulated Amortization - Changes in the Estimate).

  • Item 2.8 (Disposals of TCA-ARO): Calculated as the negative of Schedule 3E-1, total column 5 (ARO - Disposals) minus Schedule 3E-2, total column 13 (ARO Accumulated Amortization - Disposals).

Purchased Intangible Activity

Items 3.1 to 3 (Purchased Intangible Activity): Amounts in this section are loaded from Schedule 3G.

  • Item 3.1 (Acquisition of purchased intangibles): Loaded from Schedule 3G, negative of column 4 (PI Cost - Additions).

  • Item 3.2 (Amortization of purchased intangibles): Loaded from Schedule 3G, column 12 (PI Accumulated Amortization - Amortization Expense).

  • Item 3.3 (Loss (Gain) on sale of purchased intangibles): Calculated as the negative of Schedule 3G, column 20 (Gain on Disposal) + column 21 (Loss on Disposal).

  • Item 3.4 (Proceeds on sale of purchased intangibles): Loaded from Schedule 3G, column 19 (Proceeds of Disposition).

  • Item 3.5 (Transfer to assets held for sale - PI): Calculated as the negative Schedule 3G, column 7 (PI Cost - Transfer to Financial Assets) - column 15 (PI Accumulated Amortization - Transfer to Financial Assets).

  • Item 3.6 (Write-downs of purchased intangibles): Calculated as the negative of Schedule 3G, column 5 (PI Cost - Impairments) - column 13 (PI Accumulated Amortization - Impairments).

Other Non-Financial Asset Activity

Items 4.1 to 4 (Other Non-Financial Asset Activity): School boards are required for PSAB purposes to record the inflows and outflows of prepaid expenses and inventories of supplies. These lines consist of input cells.

  • Item 5 (Change in net financial assets (debt) excluding net remeasurement gains (losses)): Calculated as the sum of items 1 (Annual Surplus (Deficit) for Consolidated Statement of Change in Net Debt), 2 (Total tangible capital asset activity), 3 (Total purchased intangible activity), and 4 (Total other non-financial asset activity).
Net Remeasurement Gains (Losses)

Items 6.1 to 6 (Net Remeasurement Gains (Losses)): Amounts in this section are loaded from Schedule 1.4, Consolidated Statement of Remeasurement Gains and Losses.

  • Item 6.1 (Net Remeasurement Gain (Loss) - Foreign Exchange): Schedule 1.4, item 4.1 (Net Remeasurement Gains (Losses) - Foreign Exchange on Foreign Currency) + item 4.2 (Net Remeasurement Gains (Losses) - Foreign Exchange on Foreign Accounts Payable).

  • Item 6.2 (Net Remeasurement Gain (Loss) - Derivatives): Schedule 1.4, item 4.2 (Net Remeasurement Gains (Losses) - Derivatives).

  • Item 6.3 (Net Remeasurement Gain (Loss) - Portfolio Investments): Schedule 1.4, item 4.3 (Net Remeasurement Gains (Losses) - Portfolio Investments).

Other

  • Item 7 (Change in net financial assets (debt)): Calculated as the sum of item 5 (Change in net financial assets (debt) excluding net remeasurement gains (losses)) and item 6 (Total net remeasurement gains (losses)).

  • Item 8 (Net financial assets (net debt) at beginning of year): Loaded from item 9 (Net financial assets (debt) at end of year) in the 2023-24 column.

  • Item 9 (Net financial assets (debt) at end of year): Sum of items 7 (Change in net financial assets (net debt)) and 8 (Net financial assets (net debt) at beginning of year).

  • Item 10 (Reconciliation Target Category): This is loaded from Schedule 7, item 3 (Net Debt). The purpose of this line is to make it easier for school boards to note any differences in the net debt calculation between this schedule and the balance sheet, since they should be equal. There are error messages enforcing this for both columns (Error_SC1.3_1 and Error_SC1.3_2).

Column 2 (2023-24)

  • The prior year actual column is preloaded from the board-submitted prior year’s Financial Statements. These are blue cells that can be adjusted, if required.
Last updated on
Schedule 1.2Schedule 1.4