This site is in beta — data may be incomplete and features are still being added.
Council Meeting/Documents/Presentation: 2020 Consolidated Financial Statements
Presentation

Presentation: 2020 Consolidated Financial Statements

May 4, 2021Pages 53–7412 sections

A slide deck presenting financial ratios and high-level data from the 2020 financial statements.

1 CALL TO ORDER
Sustainability Ratios: Assets to Liabilities ratio of 9.23Unrestricted surplus: $4,765,769Equity in tangible capital assets: $126,235,265

Town of View Royal 2020 Consolidated Financial Statements

Page 53–74

Contents

  • Management’s responsibility for financial reporting
  • Consolidated Statements:
    • Financial Position
    • Operations
    • Net Financial Assets
    • Cash Flows
    • Notes
    • Segment Disclosures
    • Tangible Capital Assets
  • Independent Auditor’s Report
  • Audit Findings Report
Page 53–74

Who does what?

Management’s responsibility

  • To prepare compliant financial statements that are objective, consistent and have integrity

Mayor and Council’s responsibility

  • Make sure management does its job
  • Meet with management and auditors to review and discuss matters

Auditor’s responsibility

  • Conduct independent examination
  • Evaluate the systems of internal control
  • Express an opinion on the financial statements – do they fairly represent the actual position of the Town?
Page 53–74

Consolidated Statement of Financial Position

  • aka Balance Sheet
  • Statement A
  • Where are we at on December 31, 2020?
  • Net financial assets (debt)
  • Non-financial assets
  • Accumulated surplus
  • Note the NOTES!

Sustainability Ratios: Assets and Surplus

Bar charts showing Assets to Liabilities and Financial Assets to Liabilities from 2017 to 2020
Bar charts showing Assets to Liabilities and Financial Assets to Liabilities from 2017 to 2020
Bar chart showing Accumulated Surplus to Taxes from 2017 to 2020
Bar chart showing Accumulated Surplus to Taxes from 2017 to 2020

Town of View Royal Consolidated Statement of Financial Position

as at December 31, 2020

Statement A - Consolidated Statement of Financial Position
Statement A - Consolidated Statement of Financial Position
Financial assets 2020 2019
Cash and cash equivalents (Note 3) $30,255,883 $25,772,638
Property taxes receivable 167,906 117,513
Accounts receivable (Note 4) 1,005,666 1,811,500
Inventory held for sale 8,057 6,056
Total Financial assets 31,437,512 27,707,707
Liabilities
Accounts payable and accrued liabilities (Note 5) 4,372,172 4,200,315
Deposits 1,186,416 1,373,534
Deferred revenue (Note 6) 5,923,275 5,207,883
Prepaid property taxes 521,326 545,633
Long-term debt (Note 7) 5,419,897 5,811,314
Employee benefits and retirement obligations (Note 8) 257,358 228,528
Total Liabilities 17,680,444 17,367,207
Net financial assets 13,757,068 10,340,500
Non-financial assets
Tangible capital assets (Note 9) (Schedule 3) 131,577,469 132,271,761
Inventory of supplies 12,699 14,505
Prepaid expenses 101,391 294,240
Total Non-financial assets 131,691,559 132,580,506
Accumulated surplus (Note 10) $145,448,627 $142,921,006
Page 53–74

Consolidated Statement of Operations

  • aka: Income Statement
  • Statement B
  • What happened in 2020?
  • Revenue
  • Expense
  • Annual surplus (deficit)
  • Accumulated surplus = Statement A

Sustainability Ratios: Net Financial Assets

Bar charts showing Net Financial Assets to Taxes and Net Financial Assets to Total Annual Revenue from 2017 to 2020
Bar charts showing Net Financial Assets to Taxes and Net Financial Assets to Total Annual Revenue from 2017 to 2020

Town of View Royal Consolidated Statement of Operations

Year ended December 31, 2020

Statement B - Consolidated Statement of Operations
Statement B - Consolidated Statement of Operations
Revenue Financial plan (Note 18) 2020 2019
Taxes for municipal purposes (Note 13) $9,251,211 $9,219,894 $8,923,954
User charges 4,520,000 4,006,648 3,004,803
Investment income 110,000 622,943 513,478
Actuarial adjustments on debt - 93,107 77,529
Penalties and fines 60,000 54,567 63,804
Development charges earned 859,887 806,024 22,092
Contributions from developers and others - 37,500 365,016
Other revenue from own sources 321,019 399,362 439,805
Government grants and transfers (Notes 14, 15) 3,230,138 4,295,221 3,718,856
Total revenue 18,352,255 19,535,266 17,129,337
Expense
General government services 2,595,393 2,175,243 2,262,573
Protective services 4,840,917 4,397,459 4,290,102
Transportation services 4,971,193 4,664,180 4,719,454
Environmental health services 2,520,175 2,414,231 985,338
Development services 791,011 542,086 481,838
Recreation and cultural services 3,191,338 2,814,446 3,182,502
Total expense 18,910,027 17,007,645 15,921,807
Annual surplus (deficit) (557,772) 2,527,621 1,207,530
Accumulated surplus, beginning 142,921,006 142,921,006 141,713,476
Accumulated surplus, ending $142,363,234 $145,448,627 $142,921,006
Page 53–74

Consolidated Statement of Change in Net Financial Assets

  • aka Change in financial equity
  • Statement C
  • Takes the non-financial assets out of the annual surplus, so we have a better understanding of our net financial asset position

Town of View Royal Consolidated Statement of Change in Net Financial Assets

Year ended December 31, 2020

Statement C - Consolidated Statement of Change in Net Financial Assets
Statement C - Consolidated Statement of Change in Net Financial Assets
Financial plan (Note 18) 2020 2019
Annual surplus (deficit) $(557,772) $2,527,621 $1,207,530
Acquisition of tangible capital assets (3,828,631) (2,383,073) (2,293,741)
Contributed tangible capital assets - - (341,590)
Amortization of tangible capital assets 3,059,754 3,133,093 3,083,698
(Gain) loss on disposal and write-down of tangible capital assets - (82,152) 17,328
Proceeds on sale of tangible capital assets - 106,299 -
Change in proportionate share of West Shore Parks and Recreation Society - (79,875) (5,266)
Change in inventory of supplies - 1,806 (2,895)
Change in prepaid expenses - 192,849 (213,182)
Increase (decrease) in net financial assets (1,326,649) 3,416,568 1,451,882
Net financial assets, beginning 10,340,500 10,340,500 8,888,618
Net financial assets, ending $9,013,851 $13,757,068 $10,340,500
Page 53–74

Consolidated Statement of Cash Flows

  • Statement D
  • Where did the cash come from and how was it used?
  • Reports the change in cash and investments in the period, and how the Town financed its activities

Town of View Royal Consolidated Statement of Cash Flows

Year ended December 31, 2020

Statement D - Consolidated Statement of Cash Flows
Statement D - Consolidated Statement of Cash Flows
Cash provided by (used in) 2020 2019
Operating activities
Annual surplus $2,527,621 $1,207,530
Items not affecting operating activities:
Contributed tangible capital assets - (341,590)
Amortization of tangible capital assets 3,133,093 3,083,698
(Gain) loss on disposal and write-down of tangible capital assets (82,152) 17,328
Change in inventory of supplies 1,806 (2,895)
Change in prepaid expenses 192,849 (213,182)
Actuarial adjustment on debt (93,107) (77,529)
Change in proportionate share of West Shore Parks and Recreation Society (79,875) (5,266)
Decrease (increase) in non-cash financial assets:
Property taxes receivable (50,393) (17,654)
Accounts receivable 813,994 186,848
Inventory held for sale (2,001) 5,477
Increase (decrease) in liabilities:
Accounts payable and accrued liabilities 171,857 962,679
Deposits (187,118) (551,377)
Deferred revenue 715,392 366,649
Prepaid property taxes (24,307) 93,938
Employee benefits and retirement obligations 28,830 1,071
Net cash from operating activities 7,066,489 4,715,725
Capital activities
Acquisition of tangible capital assets (2,383,073) (2,293,741)
Proceeds on disposal of tangible capital assets 106,299 -
Net cash used in capital activities (2,276,774) (2,293,741)
Financing activities
Debt principal repaid (306,470) (306,470)
Net cash used in financing activities (306,470) (306,470)
Increase in cash and cash equivalents 4,483,245 2,115,514
Cash and cash equivalents, beginning 25,772,638 23,657,124
Cash and cash equivalents, ending $30,255,883 $25,772,638
Page 53–74

Notes to Consolidated Financial Statements

  • aka “Notes”
  • Context
  • Accounting policies
  • Details
  • Information
Page 1 of Notes to Consolidated Financial Statements covering sections 1a through 1d
Page 1 of Notes to Consolidated Financial Statements covering sections 1a through 1d

1. Significant accounting policies

a) Principles of consolidation The Town follows Canadian public sector accounting standards. The consolidated financial statements of the Town are prepared in accordance with the recommendations of the Public Sector Accounting Board (PSAB).

b) Reporting entity The consolidated financial statements reflect the combined assets, liabilities, accumulated surplus, revenue and expense of all of the Town's activities and funds. The consolidated financial statements also include the Town's proportionate share of the West Shore Parks and Recreation Society (West Shore). Interfund transactions and fund balances have been eliminated on consolidation.

c) Basis of accounting The Town follows the accrual method of accounting for revenue and expense. Revenue is normally recognized in the year in which it is earned and measurable. Expense is recognized as it is incurred and measurable as a result of receipt of goods or services and/or the creation of a legal obligation to pay. Expense paid in the current period and attributable to a future period is recorded as prepaid expense.

d) Property tax revenue Property tax revenue is recognized at the date property tax notices are issued, based on property assessment values issued by BC Assessment for the current year and tax rates established annually by bylaw. Assessments are subject to appeal and tax adjustments are recorded when the results of appeals are known.

Note 10. Accumulated surplus

Table for Note 10 detailing surplus and reserve funds for 2020 and 2019
Table for Note 10 detailing surplus and reserve funds for 2020 and 2019

Accumulated surplus consists of individual fund surplus and reserve funds as follows:

Surplus 2020 2019
Equity in tangible capital assets $126,235,265 $126,499,532
Appropriated surplus - casino revenue 4,881,520 3,727,980
Appropriated surplus - Community Works Fund 1,529,574 1,084,074
Appropriated surplus - other 379,132 374,632
Unrestricted accumulated surplus 4,765,769 4,443,138
137,791,260 136,129,356
Reserve funds
Capital Renewal 627,813 366,230
Capital Works and Land Acquisition 833,460 751,799
Fire Department Equipment 158,487 124,619
Future Operating Expenditures 975,283 918,209
Machinery and Equipment Depreciation 334,608 303,177
Parks and Open Space 499,916 449,444
Parks Improvements 276,049 192,548
Police Equipment, Property and Contract 416,209 410,486
Police Operation and Maintenance 1,822,501 1,305,412
Sewer System Capital 1,549,730 1,687,578
West Shore Parks and Recreation Society reserves 163,311 282,148
7,657,367 6,791,650
Total Accumulated surplus $145,448,627 $142,921,006
Page 53–74

Consolidated Schedules of Segment Disclosure by Service

  • aka Segmented Info
  • Schedules 1 and 2
  • Schedule 1 – current year (with budget)
  • Schedule 2 – prior year (with budget)
  • Describes R & E categories for each function shown on Statement B

Statement B functions:

  • General Government
  • Protective
  • Transportation
  • Environmental Health
  • Development
  • Recreation & Culture

Scheds 1 & 2 categories:

  • Labour & benefits
  • Goods & services
  • Amortization
  • Debt interest
  • WSPR change in share

Town of View Royal Consolidated Schedule of Segment Disclosure by Service

Year ended December 31, 2020 - Schedule 1

Schedule 1 - Consolidated Schedule of Segment Disclosure by Service for 2020
Schedule 1 - Consolidated Schedule of Segment Disclosure by Service for 2020
2020 Revenue 2020 Actual 2020 Budget (Note 18)
Taxation for municipal purposes $9,219,894 $9,251,211
User charges 4,006,648 4,520,000
Investment income 622,943 110,000
Actuarial adjustments on debt 93,107 -
Penalties and fines 54,567 60,000
Development charges earned 806,024 859,887
Contributions from developers and others 37,500 -
Other revenue from own sources 399,362 321,019
Government grants and transfers 4,295,221 3,230,138
Total revenue 19,535,266 18,352,255
2020 Expense
Labour and benefits 5,486,672 5,168,541
Goods and services 8,207,122 10,421,099
Amortization 3,133,093 3,059,754
Change in proportionate share of WSPR Society (79,875) -
Debt interest 260,633 260,633
Total expense 17,007,645 18,910,027
Surplus (deficit) $2,527,621 $(557,772)

Town of View Royal Consolidated Schedule of Segment Disclosure by Service

Year ended December 31, 2020 - Schedule 2 (Prior Year Comparisons)

Schedule 2 - Consolidated Schedule of Segment Disclosure by Service for 2019
Schedule 2 - Consolidated Schedule of Segment Disclosure by Service for 2019
2019 Revenue 2019 Actual 2019 Budget
Taxation for municipal purposes $8,923,954 $8,929,261
User charges 3,004,803 3,060,040
Investment income 513,478 110,000
Actuarial adjustments on debt 77,529 -
Penalties and fines 63,804 58,180
Development charges earned 22,092 -
Contributions from developers and others 365,016 20,000
Other revenue from own sources 439,805 338,743
Government grants and transfers 3,718,856 3,074,915
Total revenue 17,129,337 15,591,139
2019 Expense
Labour and benefits 5,511,399 4,438,829
Goods and services 7,071,343 9,250,250
Amortization 3,083,698 2,979,400
Change in proportionate share of WSPR Society (5,266) -
Debt interest 260,633 260,633
Total expense 15,921,807 16,929,112
Surplus (deficit) $1,207,530 $(1,337,973)
Page 53–74

Consolidated Schedule of Tangible Capital Assets

  • aka TCA Schedule
  • Schedule 3
  • Details for each category of TCA:
    • Historical costs
    • Additions and disposals in the year
    • Amortization
    • Net book value
  • Includes prior year comparatives

Town of View Royal Consolidated Schedule of Tangible Capital Assets

Year ended December 31, 2020

Schedule 3 - Consolidated Schedule of Tangible Capital Assets
Schedule 3 - Consolidated Schedule of Tangible Capital Assets
Asset Category 2020 Net book value 2019 Net book value
Land $49,852,783 $49,101,425
Land Improvements 3,038,568 3,068,190
Buildings 7,479,797 7,694,045
Vehicles, Machinery & Equipment 2,827,853 3,023,795
Roads 33,536,243 35,138,935
Drainage 17,424,106 17,681,704
Sewer 9,279,010 9,426,352
Work in Progress 1,582,135 728,517
West Shore 6,556,974 6,408,798
Total $131,577,469 $132,271,761
Page 53–74

Flexibility Ratios

Bar chart showing Public Debt Charges to Revenues from 2017 to 2020
Bar chart showing Public Debt Charges to Revenues from 2017 to 2020
Bar charts showing Tangible Capital Assets-NBV to Cost and Own Source Revenues to Taxes from 2017 to 2020
Bar charts showing Tangible Capital Assets-NBV to Cost and Own Source Revenues to Taxes from 2017 to 2020
Page 53–74

Vulnerability Ratios

Bar chart showing Government Transfers to Total Revenue from 2017 to 2020
Bar chart showing Government Transfers to Total Revenue from 2017 to 2020
Page 53–74

Document Images

(21)
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Document image
Extracted from: 2021 05 04 Council Agenda - Agenda - Pdf