Skip to main content

WSD Financial Facts-Part 4

August 21, 2023

WSD Financial Facts.pdf

PART 1: INTRODUCTION
PART 2: REVENUES
PART 3: EXPENDITURES
PART 4: FINANCIAL POSITION (BALANCE SHEET)
    Consolidated Financial Position
    Consolidated Accumulated Surplus


Part 4 - Financial Position (Balance Sheet)

COMMENTARY ON FINANCIAL HEALTH

  • Tangible Net Capital Assets are increasing at WSD which is an indication that it is striving to acquire sufficient assets to replace those that have been consumed in service delivery; the vast majority of the additions to Tangible Net Capital Assets are funded through Net Debt.
  • Net Debt is increasing at WSD as a result of debentures issued by the Province of Manitoba; the principal and interest payments for these debentures is paid annually to WSD by the Province so it is therefore funded debt or flow-through debt. Net Debt is used to fund additions to Tangible Net Capital Assets and also used to fund large maintenance items i.e. it is being used partially to fund operations.
  • Current year revenues have exceeded operating expenses during the last six years.
  • The Ratio of Financial Assets to Liabilities, when excluding the effect of debentures, has averaged 116% over the last years which means that Financial Assets have minimally exceeded Liabilities. Therefore, WSD has been solvent over the last five years but is financially neutral i.e. neither strong nor weak but viable.
  • Total Accumulated Surplus has steadily increased over five years as has the ratio of Assets to Liabilities which is an indicator of financial strength. That said, Total Accumulated Surplus is comprised primarily in the equity in Tangible Net Capital Assets. The remainder is comprised of capital reserves, special purpose funds, designated surplus and undesignated surplus. 
  • Undesignated surplus is currently just over 1.90% of TDE at $8.79m. This means that the ability to absorb a major financial blow to WSD is rather limited. It translates to approximately one week of expenditures at current spend rates.

Consolidated Financial Position

June 30

2017

2018

2019

2020

2021

2022

Financial Assets







  Cash and Bank

-

-

-

8,148,117

8,282,940

0

  Investments/Accrued Inc

6,567,818

 6,552,782 

 4,346,271 

 5,897,836 

 5,798,722 

 5,292,525 

  Receivables

106,450,772

 111,518,037 

 113,979,019 

 118,524,532 

 123,820,803 

 144,885,794 


113,018,590

 118,070,819 

 118,325,290 

 132,570,485 

 137,902,465 

 150,178,319 

Liabilities







  Overdraft

25,273,649

 23,212,519 

 11,613,330 

 0 

 0 

 8,952,408 

  Payables/Accrued Liab

74,495,178

 74,993,162 

 77,393,178 

 98,667,843 

 109,160,881 

 77,539,948 

  Deferred Revenue

14,161,925

 14,977,661 

 14,674,741 

 14,874,242 

 11,298,400 

 3,102,788 

  Debentures d

116,774,329

 119,630,834 

 130,325,014 

 160,056,195 

 175,422,302 

 197,415,439 

  School Gen Funds Liab

2,963,223

 2,967,202 

 3,307,394 

 3,106,950 

 3,442,110 

 3,505,843 


233,668,304

 235,781,378 

 237,313,657 

 276,705,230 

 299,323,693 

 290,516,426 

Net Debt

-120,649,714

-117,710,559 

-118,988,367 

-144,134,745 

-161,421,228 

-140,338,107 

Non-Financial Assets







  Net Tang Cap Assets

200,059,732

 202,700,971 

 215,344,148 

 241,049,145 

 257,111,167 

 263,207,876 

  Inventories

1,008,109

 1,094,944 

 1,188,987 

 1,190,006 

 1,138,948 

 1,240,630 

  Prepaids

4,688,924

 4,094,626 

 590,626 

 694,028 

 902,640 

 861,835 


205,756,765

 207,890,541 

 217,123,761 

 242,933,179 

 259,152,755 

 265,310,341 

Accumulated Surplus

85,107,051

  90,179,982  

 98,135,394 

 98,798,434 

 97,731,527 

 124,972,234 

Net Debt excl. Debentures d

-3,875,385

 1,920,275  

 11,336,647 

 15,921,450 

 14,001,074 

 57,077,332 

d – Debentures are issued by the Province of Manitoba; as such, all principal and interest payments are paid to WSD by the Province. 
Therefore the figure shown above of net debt excluding debentures provides a more accurate picture of the financial health of WSD.

Consolidated Accumulated Surplus

June 30

2017

2018

2019

2020

2021

2022

Equity in Tang Cap Assets

72,059,194

 73,837,629 

 78,462,817 

 81,630,813 

86,284,679 

89,794,279 

Capital Reserve

1,399,898

 4,523,350 

 3,488,750 

 2,700,772 

 717,648 

 16,507,061 

School Generated Funds

-19,456

-64,404 

-134,219 

-122,165 

-337,756 

-257,154 

Other Spec Purpose funds

3,661,855

 3,684,347 

 3,648,704 

 3,612,409

 4,432,655

 4,038,332


77,101,491

 81,980,922 

 85,466,052 

 87,821,829 

 91,097,226 

110,082,518 

Op Fund Accum Surplus







  Designated Surplus







  Pilot Full Day Kinder

60,806

-

-

-

-

-

  Ment Health Strat Plan

14,521

 14,521 

 2,145 

 - 

 - 

 - 

  Musical instruments

8,216

-

-

-

848

-

  Employee Engagement

45,000

-

-

46,230

-

-

  Staff Restructuring

166,658

-

-

-

-

-

  Univ access playgrounds

100,000

 180,000 

 220,000 

 124,898 

 - 

 - 

  Data Analytics Artificial Intelligence

-

-

361,000

260,626

120,687

118,643

  Wireless Controllers (Support Maintenance)

-

-

185,000

52,496

52,496

52,496

  Financial HR System

-

-

2,621,317

2,621,317

2,621,317

2,797,362

  Lead Water Testing in Schools

-

-

256,803

92,000

3,286

-

  Department carryovers

217,176

 194,200 

 804,631 

 169,259 

 452,432 

 1,273,233 

  School carryovers

1,040,235

 955,969 

 1,299,767 

 1,622,565 

 2,068,701 

 1,916,708 

  Technology Evergreening, Backup Firewall

-

-

-

258,955

-

-

  Inclusion Support Technology Upgrades

-

-

-

72,553

-

-

  STEAM Program

-

-

-

15,899

-

-

  IC Science Lab Program

-

-

-

3,651

2,647

-

  Math Resources

-

-

-

5,279

-

-

  R.B. Russell Greenhouse Program

-

-

-

14,000

-

-

  Tec Voc Welding Program

-

-

-

61,407

-

-

  Transportation (Cameras)

-

-

-

153,835

68,453

68,453

  Waterford Springs - Library Books

-

-

-

160,000

3,473

-

  Waterford Springs - IT Equipment

-

-

-

94,331

2,596

-

  Waterford Springs - Release Time

-

-

-

10,000

-

-

  Mentorship Program

-

-

-

28,673

28,673

12,693

  Teacher Relocation Allowance

-

-

-

60,000

60,000

60,000

  Safety and Security

-

-

-

-

-

1,345,000

  Cafeteria Upgrade

-

-

-

-

-

500,000

  Ventilation Upgrade

-

-

-

-

-

450,000

  Car Park Safety Repairs

-

-

-

-

-

421,135


1,652,612

 1,344,690 

 5,750,663 

 5,927,974 

 5,641,470 

 9,015,723 

  Undesignated Surplus

8,896,075

 9,703,841 

 10,253,704 

 7,271,565 

 3,619,028 

 8,793,527 

  Non-vested sick leave

-2,543,127

-2,849,471 

-3,335,026 

-2,222,934 

-2,626,197 

-2,919,534 


8,005,560

 8,199,060 

 12,669,341 

 10,976,605 

 6,634,301 

 14,889,716 

Consolidated Accum Surplus*

85,107,051

  90,179,982  

 98,135,394 

 98,798,434 

 97,731,527 

124,972,234 

Undesig Surpl as a % of TDE

2.17%

2.31%

2.42%

1.67%

0.79%

1.97%


Financial Statement Elements

Financial Assets - are the financial resources an entity controls and can use to pay what it owes to others. These assets include cash, accounts receivable, investments, and assets that are convertible to cash or that generate cash so that the entity can pay its liabilities as they come due. Information about the liquidity of an entity’s financial assets is not presented on the Statement of Financial Position. (Liquidity means how quickly assets can be used to pay bills.) However, the notes to the financial statements include disclosures on the liquidity of an entity’s financial assets.

Liabilities - are existing financial obligations to outside parties at the date of the financial statements. They result from past transactions and events and will lead to the future sacrifice of economic benefits (e.g., financial assets). Common liabilities are accounts payable, debt, employee pension obligations, and unearned revenue. Users should also read the notes to the financial statements to better understand the nature of an entity’s liabilities and when liabilities are due.

Net debt - is a term unique to public sector financial reporting. It is the difference between an entity’s financial assets and liabilities at a point in time. This performance measure provides readers with important information regarding the entity’s requirement to generate future revenues to fund past services and transactions.

Non-financial assets - are assets that an entity will use up when providing future services to the public. These assets are not normally used by an entity to settle its liabilities with external parties. As a result, they are shown separately in the Statement of Financial Position. Often, the most significant group of assets within this category are tangible capital assets, like buildings or roads, which are acquired to provide services over many years. As entities deliver services, the estimated portion of the assets used is recorded as an expense in the Statement of Operations. The balance presented represents the remaining service potential of the non-financial assets. 

Consolidated Accumulated Surplus - When total assets exceed total liabilities, the entity is in an accumulated surplus position. An accumulated surplus position means that the entity has net positive resources that, subject to direction of the government or governing board, could be used to provide future services. However, when an entity is in an accumulated deficit position (total liabilities exceed total assets), the entity must fund past transactions and events from future revenues. An accumulated operating deficit position means the entity has borrowed to finance annual operating deficits.

Indicators of Sustainability

June 30

2017

2018

2019

2020

2021

2022

Assets to Liabilities

136.4%

138.3%

141.3%

135.7%

132.65%

143.02%

Financial Assets to Liabilities

48.4%

50.1%

49.9%

47.9%

46.07%

51.69%

Financial Assets to Liabilities excl. Debentures

96.7%

101.7%

110.6%

113.7%

111.30%

161.31%

Net Debt to Total Annual Revenue

29.1%

27.7%

27.5%

33.1%

35.52%

29.60%


Back to top