Transcript Enrolment/ESL presentation

Capital Analysis & Planning Template V4
Fall 2014
Capital Policy & Programs Branch/Financial Analysis and Accountability Branch
Ministry of Education
1
Purpose:
 Review Changes Implemented for V4
 Provide a Detailed Walk-Thru
 Changes to Approval To Proceed Process
 Review of Approval to Proceed Request Form
2
Capital Analysis and Planning Template (CAPT)
Purpose

Tracking system for capital projects

Monitor boards Unsupported Capital Spending and overall Capital
Surplus/Deficit position.

 Unsupported Capital Spending:
− TCA less DCC excluding land as per Schedule 5.3
 Capital Position (Surplus/Deficit):
− Unsupported Capital Spending less any revenue applied in the year
as per Table 4a on the CAPT.
Renewal/POD encumbrance

Committed Accumulated Surplus

Support Tool for Capital Discussions

Assessing financial implications at the Approval To Proceed stage

Determining OFA long-term financing eligibility.

RBP(Results Based Plan)- Ministry Forecasting
3
Improvements Implemented for V4

Simplified the ATP process for the boards

Improved functionality
4
CAPT V4 Changes – General
 Formatting
 Bilingual Worksheets
 Worksheet Name Changes
 FIN-FR - Capital Financial Position
 FIN-SR - School Renewal Schedule
 POD-S - Proceeds of Disposition - School Sites
 POD-A - Proceeds of Disposition - Admin Sites
 PRO-M - Master Capital Projects (Active + Completed) – READ ONLY
 PRO-A - Active Capital Projects
 DEB - Project Debenture Matrix
 OFA-1 - OFA Debenture Financing Request
 OFA-2 - OFA Debenture Financing Request
5
CAPT V4 Changes – Project Eligibility Worksheet

Project Eligibility Worksheet name changed:
 PRO-M (Project Master) – Listing of All Projects - Locked
 PRO-A (Project Active) – Listing of Projects that are not completed such that they meet
the following criteria:
 $ Value in either NPF or Amounts to be Constructed

Boards will only be required to enter data on PRO-A worksheet only

Added ATP Section for the following:
 1. ATP Date
 2. ATP Amount

Consolidated:
 GPL – Other (Col 10.2)
 $120M Capital Funding (10.3)

Ministry funding columns agrees to the GSN Regulations

FDK Allocation column now agrees to the GSN Regulation and also includes Year 1-4 First
Time Equipping and Year 5 estimated First Time Equipping
6
CAPT V4 Changes – Financial Position & Recovery/ POD

POD worksheets:
 Added lines to report break-down information of committed POD by
projects during 2013-14.

School Renewal Schedule: New
 Boards are required to complete this worksheet if a project is:
− Reported in unsupported capital spending and is funded by renewal

Financial Position & Recovery Worksheet name changed to
Capital Financial Position
 Added new Table 1c – capital activities post-Aug 31, 2014 by projects
 Automated Table 4a SF interest earned to date cell which agrees to Sch
5 line 2.8.1 balance
 Added new funding sources: SCI & 3rd party revenue
 Updated Table 5 School Renewal Encumbrance
7
FIN-FP: Capital Financial
Position Worksheet
Capital Financial Position Worksheet: Overview
Left-hand side
Unsupported Capital Spending
Right-hand side
Board’s Revenue Sources
Tab le 2:
Table 1:
Board Funded S pending on Capital Projects
Total
Board Funded S pending on Capital Projects - Balance at August 31, 2014
Sinking Fund Interest to be Earned
EFI S 13-14 FS Sch 5.3 Li ne 2.1.1 Col 7
5.000
Depreciable Assets Ex cluding Minor Tangible Capital Assets
EFI S 13-14 FS Sch 5.3 Li ne 2.1.2 Col . 7 + Li ne 2.2
Col . 7 excl udi ng mi nor TCA a mounts
7.200
Minor Tangible Capital Assets
EFI S 13-14 FS Sch 5.3 Li ne 2.1.2 Col . 7 + Li ne 2.2
Col . 7 mi nor TCA a mounts onl y
EFIS 13-14 FS Sch 5.3 Line 2.1.2 Col. 7 + Line 2.2
Col. 7 other than amts reported abov e
2.000
Other
0.000
Ministry to complete this S ection W hen receiving an Approval to Proceed:
Less: Recognition of DR related to Prior Eligible Capital Ex pense (In-Year Amount)
Less: Amortization (In-Year Amount)
Less: Disposals/Transfer to Financial Assets (In-Year Amount)
0.000
0.000
0.000
A
Add: Board Funded Spending Not Reported on the Project Eligibility Sheet
Total
Land:
Capital Deficit on Land (Non EDC) as at August 31, 2014
0.000
14.200
EFIS 13-14 FS Sch 5.6B Line 2.4 Col 2
Ministry to complete this S ection W hen receiving an Approval to Proceed:
Add: Capital Budget Shortfall Land
Less: Rev enue recognized re Unsupported Past Spending on Land
Total
0.000
0.000
0.000
0.000
Capital Activity Post August 31, 2014 (From Project Eligibility S heet)
"PRO-1A" worksheet Sum of Col 7.4 projects approv ed
pre 2014-15 only
Approv ed 2014-15 - Board Funded Spending on Capital Assets
"PRO-1A" worksheet Sum of Col 7.5 projects approv ed
in 2014-15 only
7.000
0.000
"PRO-1A" worksheet Sum of Col 7.5 projects
requested by board but Not y et approv ed
Requested - Board Funded Spending on Capital Assets
0.000
Total Board Funded S pending on Capital Assets
21.200
"PRO-1A" worksheet Sum of Col 7.5 projects planned
by board but Not y et requested
Planned - Board Funded Spending on Capital Assets
Table 1a: Board Funded S pending on Capital Projects: Depreciable Assets Excluding MTCA
($Millions)
Project Name:
Funding S ource
Project A
Accum. Surplus
Project B
Renewal / Réfection
Ministry
Adjustments
0.000
Balance at Aug
31, 2015
3.000
0.000
0.000
1.000
WSIB
0.300
0.000
0.000
0.300
School Renewal
0.000
0.000
0.000
0.000
Amounts Prev iously Included in Pupil Accommodation Debt Reserv e
0.000
0.000
0.000
0.000
Other Purposes: Operating
0.000
0.000
0.000
0.000
Committed Sinking F und Interest Earned
Committed Capital Projects
Other Purposes - Capital
To tal I n tern ally Ap p ro p riated
2.000
5.500
0.600
9.400
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
2.000
5.500
0.600
9.400
12.400
0.000
0.000
12.400
Total
Comments
4.500
2.700
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
7.200
Comments
Lease rev enue
Agreement with Corporate A
1.200
0.800
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
2.000
B
Total
Total
Funding S ource
School Renewal
POD
Accum. Surplus
Other rev enue (please ex plain)
S ub-total_Amounts to be constructed at Aug 31, 2014
Project name - Approved 2014-15 Board S pending
on Capital Assets
Funding S ource
Comments
Childcare funding by prov ider
0.500
5.000
1.000
0.500
0.000
0.000
0.000
7.000
T otal Accumulated Surplus Committed for Board Spending on Capital Projects
Less: Accumulated Surplus Committed for Capital Projects not Reported on T able 1
To tal Accu mu lated S u rp lu s Co mmit ted fo r Bo ard S p en d in g o n Cap it al Pro jects
Tab le 3a:
6.100
-0.600
5.500
Availab le Reso u rces - Pro ceed s o f Disp o sit io n - S ch o o l S it es
($Millions)
Current Balance as at Aug 31, 2014
Add: POD Realized to Date
3.000
0.000
3.000
C
Add: POD Pending Sale
Less: Ministry Approv ed Use of POD
Less: Anticipated F uture Use of POD
4.000
-5.000
0.000
Remain in g Pro ceed s o f Disp o sit io n
2.000
Availab le Reso u rces - Pro ceed s o f Disp o sit io n - Ad min S it es
($Millions)
Current Balance as at Aug 31, 2014
Add: POD Realized to Date
0.000
0.000
To tal Pro ceed s o f Disp o sit io n Availab le f o r Un su p p o rted Cap it al S p en d in g
Add: POD Pending Sale
Less: Ministry Approv ed Use of POD
Less: Anticipated F uture Use of POD
Remain in g Pro ceed s o f Disp o sit io n
0.000
0.000
0.000
0.000
0.000
Tab le 4a:
S u mmary - Cap it al S u rp lu s/( Deficit ) I n clu d in g Reven u e Realized t o Date
($Millions)
T otal Board F unded Spending on Capital Assets - T able 1
F unding Sources Applied:
Add: T otal Accumulated Surplus Committed for Capital Projects - T able 2
Add: T otal Proceeds of Disposition - School Sites - Realized to Date - T able 3a
Add: T otal Proceeds of Disposition - Admin Sites - Realized to Date - T able 3b
Add: School Renewal Grant ( In-Year Amount Applied - agree to "School Renewal Schedule" Cell D35)
Add: School Conditional Improv ement Grant ( 2014-15 In-Year Amount Applied)
Add: 3rd Party Rev enues Receiv ed ( Please Note in Comment Box Below)
Add: Other Rev enue Sources Receiv ed T o Date ( Please Note In Comment Box )
Add: Education Dev elopment Charges Rev enue r eceiv ed to date
Add: Sinking F und Interest Earned to Date
Add: Misc. Adjustments ( Please Note in Comment Box Below) - Rev ised
Less: Interest Ov er Life of Capital Deficit
To tal Cap it al S u rp lu s / ( Deficit ) I n clu d in g Reven u e Realized t o Date
Co mmen ts
Other r ev enue - Lease r ev enue from Municipality of Canada - $0.2M
Tab le 4b :
-21.200
5.500
3.000
0.000
1.100
0.000
0.000
0.200
0.000
2.000
0.000
0.000
-9.400
D
S u mmary - Cap it al S u rp lu s/( Deficit ) I n clu d in g F u tu re S o u rces t o b e Ap p lied
($Millions)
T otal Capital Surplus / ( Deficit) Including Rev enue Realized to Date ( F rom T able 4a)
F unding Sources Applied:
Add: T otal Proceeds of Disposition - School Sites - Pending Sale - T able 3a
Add: T otal Proceeds of Disposition - Admin Sites - Pending Sale - T able 3b
-9.400
4.000
0.000
Add: School Renewal Grant ( F uture Grant Encumbered - agree to "School Renewal Schedule" Cell E35)
2.100
Add: School Conditional Improv ement Grant ( F uture Grant Encumbered)
Add: 3rd Party F uture Rev enues to be Receiv ed ( Please Note in Comment Box Below)
Add: Other Rev enue Sources - (F uture Rev enue to be Receiv ed) ( Please Note in Comment Box )
Add: F uture Operating Sav ings ( Please Note in Comment Box Below)
Add: Education Dev elopment Charges Rev enue to be r eceiv ed
Add: F uture Interest on Sinking F unds
Add: Misc. Adjustments
To tal Cap it al S u rp lu s/( Deficit ) I n clu d in g F u tu re S o u rces t o b e Ap p lied
0.000
0.800
1.500
0.000
0.000
3.000
0.000
2.000
Co mmen ts
Comments
0.000
0.000
0.000
0.000
0.000
0.000
0.000
S ub-total_Approved 2014-15 Board S pending on Capital Assets
Funding S ource
To tal Accu mu lated S u rp lu s / ( Deficit ) Availab le f o r Co mp lian ce
Tab le 3b :
Total
Funding S ource
Other rev enue (please ex plain)
3rd party (please ex plain)
S ub-total_Requested Board S pending on Capital Assets
Total
Adjust to Latest
EF IS Submission
0.000
1.000
0.000
Total
Project name - Requested Board S pending on
Capital Assets
Balance at Aug
31, 2014
3.000
To tal Pro ceed s o f Disp o sit io n Availab le f o r Un su p p o rted Cap it al S p en d in g
Amounts to be Constructed At August 31, 2014 (Projects approv ed pre 2014-15 only )
Table 1c: Capital Activities Post-August 31, 2014
($Millions)
Project name - Amounts to be constructed at
August 31, 2014
Andrew Dav is High School
Gabe Sekaly Public School
Accu mu lated S u rp lu s / Deficit
Availab le f o r Co mp lian ce - To tal Un ap p ro p riated :
Depreciable Assets:
Table 1b: Minor Tangible Capital Assets
($Millions)
Project Name:
Computer software
Computer hardware
Availab le Reso u rces -
Availab le f o r Co mp lian ce - I n tern ally Ap p ro p riated :
Retirement Gratuities
($Millions)
($Millions)
Other r ev enue - Lease r ev enue from Municipality of Canada
Other r ev enue - childcare funding by prov ider - $0.5M
T hrid party - Agreement with Corporate A - $0.8M
- $ 1.0M
Tab le 5: S ch o o l Ren ewal Gran t En cu mb eran ce
($Millions)
School Renewal - Deferred Rev enue as Aug 31, 2014
2014-15 School Renewal Grant
0.000
Av ailable School Renewal grant for unsupported capital ex penditures
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
7.000
School Renewal Allocation to be transferred to DCC Schedule
Current y ear - 2014-15
S ch o o l Ren ewal Allo catio n t o b e t ran sferred t o DCC b al. at Au g 31, 2015
Comments
An n u al S ch o o l Ren ewal to b e t ran sferred t o DCC in n ext 5 years
2015-16
2016-17
2017-18
2018-19
2019-20
E
5.000
10.000
15.000
%
7%
$ millions
1.100
2.100
%
5%
2%
2%
2%
2%
$ millions
0.800
0.200
0.200
0.200
0.200
Section A: Table 1
Table 1: Board Funded S pending on Capital Projects
($Millions)
Total
Depreciable Assets:
Unsupported Capital S pending on Capital Projects - Balance at August 31, 2014
Sinking Fund Interest to be Earned
EFIS 13-14 FS Sch 5.3 Li ne 2.1.1 Col 7
5.000
Depreciable Assets Excluding Minor Tangible Capital Assets
EFIS 13-14 FS Sch 5.3 Li ne 2.1.2 Col . 7 + Li ne 2.2
Col . 7 excl udi ng mi nor TCA amounts
7.200
Minor Tangible Capital Assets
EFIS 13-14 FS Sch 5.3 Li ne 2.1.2 Col . 7 + Li ne 2.2
Col . 7 mi nor TCA amounts onl y
EFIS 13-14 FS Sch 5.3 Line 2.1.2 Col. 7 + Line 2.2
Col. 7 other than amts reported above
2.000
Other
0.000
Ministry will complete this S ection W hen Approval to Proceed submitted:
Less: Recognition of DR related to Prior Eligible Capital Expense (In-Year Amount)
Less: Amortization (In-Year Amount)
Less: Disposals/Transfer to Financial Assets (In-Year Amount)
Add: Board Funded Spending Not Reported on the Project Sheet
Total
Land:
Capital Deficit on Land (Non EDC) as at August 31, 2014
0.000
0.000
0.000
A
0.000
14.200
EFIS 13-14 FS Sch 5.6 Line 2.4 Col 2
Ministry will complete this S ection W hen Approval to Proceed submitted:
Add: Capital Budget Shortfall Land
Less: Revenue recognized re Unsupported Past Spending on Land
Total
0.000
0.000
0.000
0.000
Capital Activity Post August 31, 2014 (From PRO-A S heet)
Amounts to be Constructed At August 31, 2014 (Projects approved pre 2014-15 only)
"PRO-1A" worksheet Sum of Col 7.4 projects approved
pre 2014-15 only
7.000
Approved 2014-15 - Board Funded Spending on Capital Assets
"PRO-1A" worksheet Sum of Col 7.5 projects approved
in 2014-15 only
0.000
Requested - Board Funded Spending on Capital Assets
"PRO-1A" worksheet Sum of Col 7.5 projects
requested by board but Not yet approved
0.000
Total Board Funded S pending on Capital Assets
Planned - Board Funded Spending on Capital Assets
21.200
"PRO-1A" worksheet Sum of Col 7.5 projects planned
by board but Not yet requested
0.000
2013-14 FS EFIS: Schedule 5.3
Submission Version: Board Active Version
School Board Name: Ontario DSB
School Year: 2013-14
Cycle: Financial
Schedule 5.3 - Deferred Capital Contributions Continuity
Deferred Cap
Deferred Cap
Contributions - Contributions Deferred Cap Recognition of
Prior Years
Contributions - Def. Rev (Prior
Capital Grant
Additions
Eligible Cap Exp) adjustments
(Note 6)
(Note 7)
Col. 1
Col. 2
Col. 3
Col. 3.1
100,000,000
12,000,000
0
0
Deferred Cap
Contributions
Balance at
September 1
Deferred Cap Deferred Cap
Contributions - Contributions Deferred Cap
Subtotal before Disposals and Deferred Cap Contributions disposals and
Transfer to Contributions - Balance at
amortization Financial Assets Amortization
August 31
(Note 1)
Col. 4
Col. 5
Col. 6
Col. 7
112,000,000
0
-8,000,000
104,000,000
2.0
Tangible Capital Assets less land (from
2.1.1
Sinking Fund Interest to be Earned
5,100,000
0
0
5,100,000
0
-100,000
5,000,000
2.1.2
Other Unsupported Capital Spending
Pre-August 31, 2010
6,400,000
0
-200,000
0
6,200,000
0
-300,000
5,900,000
2.1.3
Unsupported Capital Spending PreAugust 31, 2010
11,500,000
0
-200,000
0
11,300,000
0
-400,000
10,900,000
2.2
Unsupported Capital Spending PostAugust 31, 2010 (Note 5)
8,400,000
0
0
0
8,400,000
-5,000,000
-100,000
3,300,000
2.3
Total Deferred Capital Contributions (Item
2.0 less item 2.1.3 and 2.2)
80,100,000
12,000,000
200,000
0
92,300,000
5,000,000
-7,500,000
89,800,000
2.4
Portion of Deferred Capital Contributions
related to Third Parties specified in Note 4
900,000
0
0
0
900,000
0
-80,000
820,000
2.5
Portion of Deferred Capital Contributions
not related to Third Parties specified in Note
4 (item 2.3 - item 2.4)
79,200,000
12,000,000
200,000
0
91,400,000
5,000,000
-7,420,000
88,980,000
3.0
Average remaining service life of
Unsupported Capital Spending (Note 2)
0
0
0
0
0
0
20.00
0
3.1
Adjusted Average remaining service life of
Unsupported Capital Spending (Note 3)
0
0
0
0
0
0
10.00
0
Line 2.1.1
=$5.0M, the
Sinking Fund
Interest to be
earned balance
should be
reported in the
CAPT Table 1 Cell
H14.
Line 2.1.2 =$5.9M
Line 2.2 =$3.3M
Total
$9.2M
Note: The total
$9.2M should be
reported in the
CAPT Table 1
Cells H15, 16 &
17.
Section A: Table 1
• Unsupported capital spending balances as Aug 31, 2014 including:
– sinking fund interest to be earned
– depreciable assets excl. minor TCA
– minor TCA
– others
Note: The total of the above unsupported capital spending = 2013-14 EFIS Schedule 5.3 Lines 2.1.1,
2.1.2 & 2.2 Col. 7
• Capital deficit on Land (Non-EDC) as Aug 31, 2014 = 2013-14 FS
EFIS, Schedule 5.6B, Line 2.4 Col. 2
• Capital activities post Aug 31, 2014
– Amounts to be constructed at Aug 31, 2014: pre-loaded from Active Project Worksheet
– Approved 2014-15: Ministry will update when ATP submitted
– Requested: Ministry will update when ATP submitted
Section B: Table 1a, 1b & 1c
Table 1a: Board F unded S pendin g o n Capital Projects: Depreciable Assets Exclu din g MTCA
($Millions)
Project Name:
Fundin g S ource
Project A
Accum. Surplus
Project B
Renewal / Réfection
Total
Comments
4.500
2.700
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
7.200
B
Total
Table 1b: Min or Tangib le Capital Assets
($Millions)
Project Name:
Computer software
Total
Fundin g S ource
mTCA
Comments
Fundin g S ource
School Renewal
POD
Accum. Surplus
3rd party (please ex plain)
Comments
2.000
0.000
0.000
0.000
0.000
2.000
Total
Table 1c: Capital Activities Post-August 31, 2014
($Millions)
Project n ame - Amounts to b e constructed at
August 31, 2014
Ontario High School
Richmond Public School
Total
S ub-total_Amounts to b e constructed at Aug 31, 2014
Project n ame - Approved 2014-15 Board S pendin g
on Capital Assets
Fundin g S ource
Childcare funding by prov ider
0.500
5.000
1.000
0.500
0.000
0.000
0.000
7.000
Comments
0.000
This section will be completed by Financial Analyst when processing an ATP request
S ub-total_Approved 2014-15 Board S pendin g o n Capital Assets
Project n ame - Requested Board S pendin g o n
Capital Assets
0.000
0.000
0.000
Fundin g S ource
Comments
This section will be completed by Financial Analyst when processing an ATP request
S ub-total_Requested Board S pendin g o n Capital Assets
Total
0.000
0.000
0.000
0.000
0.000
0.000
0.000
7.000
Section B: Table 1a, 1b & 1c
•
Table 1a – Boards to report depreciable assets requiring board’s funding by project.
–
•
Table 1b - Boards to report minor TCA projects requiring Board’s funding by project.
–
•
Example: In this demo, the board has $7.2M depreciable assets excl. minor TCA in Table 1 which
should be reported in Table 1a and indicate the corresponding funding sources for each project.
Example: In this demo, the board has $2.0M minor TCA in Table 1 which should be reported in Table
1b and indicate the corresponding funding sources for each project.
Table 1c (New) - Boards to report any capital activities post 2013-14YE by project.
Note: the balances in Table 1a, 1b & 1c should agree to the corresponding lines in Table 1
above.
•
New in CAPT v4
– Funding sources: added drop-down box
– Comment box
Section C: Tables 2, 3a & 3b
Table 2:
Available Resources -
Accumulated S urplus / Deficit
Balance at Aug
31, 2014
3.000
Adjust to Latest
EFIS Submission
0.000
Ministry
Adjustments
0.000
Balance at Aug
31, 2015
3.000
Available for Compliance - I nternally Appropriated:
Retirement Gratuities
1.000
0.000
0.000
1.000
WSIB
0.300
0.000
0.000
0.300
School Renewal
0.000
0.000
0.000
0.000
Amounts Prev iously Included in Pupil Accommodation Debt Reserv e
0.000
0.000
0.000
0.000
Other Purposes: Operating
0.000
0.000
0.000
0.000
Committed Sinking Fund Interest Earned
2.000
0.000
0.000
2.000
Committed Capital Projects
5.500
0.000
0.000
5.500
Other Purposes - Capital
Total I nternally Appropriated
0.600
9.400
0.000
0.000
0.000
0.000
0.600
9.400
12.400
0.000
0.000
12.400
($Millions)
Available for Compliance - Total Unappropriated:
Total Accumulated S urplus / (Deficit) Available for Compliance
Total Accumulated Surplus Committed for Board Spending on Capital Projects
Less: Accumulated Surplus Committed for Capital Projects not Reported on Table 1
Total Accumulated S urplus Committed for Board S pending on Capital Projects
Table 3a:
6.100
-0.600
5.500
Available Resources - Proceeds of Disposition- S chool S ites
($Millions)
Current Balance as at Aug 31, 2014
Add: POD Realized to Date
Total Proceeds of Disposition Available for Unsupported Capital S pending
Add: POD Pending Sale
Less: Ministry Approv ed Use of POD
5.000
0.000
C
5.000
4.000
-5.000
Less: Anticipated Future Use of POD
0.000
Remaining Proceeds of Disposition
4.000
Table 3b:
Available Resources - Proceeds of Disposition- Admin S ites
($Millions)
Current Balance as at Aug 31, 2014
Add: POD Realized to Date
0.000
0.000
Total Proceeds of Disposition Available for Unsupported Capital S pending
Add: POD Pending Sale
Less: Ministry Approv ed Use of POD
Less: Anticipated Future Use of POD
Remaining Proceeds of Disposition
0.000
0.000
0.000
0.000
0.000
Section C: Tables 2, 3a & 3b
•
Table 2 – No change in this table. Board to report the 2013-14 Accumulated
Surplus information.
– Mirror to the 2013-14 FS EFIS Schedule 5
Note: If a board has any committed Accumulated Surplus for future capital activities,
and the capital spending has not yet been incurred and reported in the CAPT Table
1; the board should deduct the Accumulated Surplus amount in the cell (N26).
•
Table 3a/3b – No change in these two tables. Proceeds of disposition
information is pre-loaded from the POD-S/A worksheets.
Section D: Table 4a & 4b
Table 4a: S ummary - Capital S urplus/(Deficit) I ncluding Revenue Realized to Date
($Millions)
Total Board Funded Spending on Capital Assets - Table 1
Funding Sources Applied:
Add: Total Accumulated Surplus Committed for Capital Projects - Table 2
Add: Total Proceeds of Disposition - School Sites - Realized to Date - Table 3a
Add: Total Proceeds of Disposition - Admin Sites - Realized to Date - Table 3b
Add: School Renewal Grant (In-Year Amount Applied - agree to "School Renewal Schedule" Cell D35)
Add: School Condition Improvement Grant
Add: 3rd Party Revenues Received (Please Note in Comment Box Below)
Add: Other Revenue Sources Received To Date (Please Note In Comment Box)
Add: Education Development Charges Revenue received to date
Add: Sinking Fund Interest Earned to Date
Add: Misc. Adjustments (Please Note in Comment Box Below) - Revised
Less: Interest Over Life of Capital Deficit
Total Capital S urplus / (Deficit) I ncluding Revenue Realized to Date
Comments
Other revenue - minor TCA allocation applied - $2.0M
Table 4b: S ummary - Capital S urplus/(Deficit) I ncluding Future S ources to be Applied
($Millions)
Total Capital Surplus / (Deficit) Including Revenue Realized to Date (From Table 4a)
Funding Sources Applied:
Add: Total Proceeds of Disposition - School Sites - Pending Sale - Table 3a
Add: Total Proceeds of Disposition - Admin Sites - Pending Sale - Table 3b
-21.200
5.500
5.000
0.000
1.100
0.000
0.000
2.000
0.000
2.000
0.000
0.000
-5.600
D
-5.600
4.000
0.000
Add: School Renewal Grant (Future Grant Encumbered - agree to "School Renewal Schedule" Cell E35)
2.100
Add: School Condition Improvement Grant (Future Grant Encumbered)
Add: 3rd Party Future Revenues to be Received (Please Note in Comment Box Below)
Add: Other Revenue Sources -(Future Revenue to be Received) (Please Note in Comment Box)
Add: Future Operating Savings (Please Note in Comment Box Below)
Add: Education Development Charges Revenue to be received
Add: Future Interest on Sinking Funds
Add: Misc. Adjustments
Total Capital S urplus/(Deficit) I ncluding Future S ources to be Applied
Comments
0.000
0.500
0.000
0.000
0.000
3.000
0.000
4.000
3rd revenue - childcare funding by provider - $0.5M
Section D: Table 4a & 4b
•
Table 4a – the most important table in this worksheet!!!
– The purpose of this table is to calculate the board’s capital surplus/(deficit)
position at the time of submission by summarizing Tables 1-3b
•
Table 4b – The purpose of this table is to calculate the board’s capital
surplus/(deficit) position after applying anticipated future revenue sources
•
New in the CAPT v4:
• Added two new funding sources in table 4a/4b: School Condition improvement &
3rd party revenue
• Automated the Sinking Fund interest earned to date cell, which is now linked to
Table 2 committed sinking fund interest line (EFIS Sch 5 line 2.8.1)
• Added comment box in each table
Section E: Table 5
Table 5: School Renewal Grant Encumberance
($Millions)
School Renewal - Deferred Revenue as Aug 31, 2014
2014-15 School Renewal Grant
Total Available School Renewal Grant
School Renewal Allocation to be transferred to DCC Schedule
Current year - 2014-15
E
5.000
10.000
15.000
%
7%
School Renewal Allocation to be transferred to DCC bal. at Aug 31, 2015
Annual School Renewal to be transferred to DCC in next 5 years
2015-16
2016-17
2017-18
2018-19
2019-20
$ millions
1.100
2.100
%
2%
2%
2%
2%
3%
$ millions
0.200
0.200
0.200
0.200
0.300
Section E: Table 5
• Table 5 – School renewal grant encumbrances. This
table is linked to the new School Renewal Schedule
worksheet to show the total available school renewal
grant and encumbrances amount & percentage in 201415 and next 5 years.
Examples
FIN-FP: Examples
Active Project Worksheet
Project Details / Détails du projet
School Name /
Nom de l'école
Description
SFIS / SIIS
Col. 1.1
Col. 1.2
Col. 1.3
Ministry ATP Status / Statut de la
Project Status / Statut du projet
demande d'approbation
Col. 1.4
Financing For Board Committed
Amounts Only / Financement des
Board Committed Funding
Col. 1.5
Project
Type
de projet
Col. 1.6
Opening Date /
POD / Produits
Date d'ouverture Renewal / Réfection
d'aliénation
(YYYY-YY)
Col. 1.7
AUGUST 31, 2014 TOTAL / TOTAL AU 31 AOÛT 2014
Col. 3.1
500,000
Col. 3.2
5,000,000
Accumulated
Surplus accumulé
EDC / RAS
Other / Autre
Total
To be Constructed /
À construire
Total
Col. 3.3
Col. 3.4
Col. 3.5
Col. 3.6 =
Col. 3.1 to Col. 3.5
Col. 7.4
Col. 7.5 =
Col. 7.2 to Col. 7.4
1,000,000
0
500,000
7,000,000
7,000,000
7,000,000
0
500,000
6,500,000
0
500,000
6,500,000
0
500,000
6,500,000
0
Available PAG Reserves to offset OFA Requests, As of August 31, 2013 / Réserves de IDÉ qui sont disponibles pour les demandes de financement après de l'OOF aux 31 août 2013
Available Ministry Funding (Includes Protected Ministry Funding & Savings from Ministry Funded Projects) / Financement du ministère disponible (Incluant les fonds assurés et les économies du Ministère)
MacDonald Public School
Ontario High School
Richmond Public School
New 550 PP Elementary
Addition 230 PP Secondary
New 600 PP Elementary
5555
6666
7777
ATP Pre 2014-15 / App. pré 2014-15 Under Construction / En construction
School / École
ATP Pre 2014-15 / App. pré 2014-15 Under Construction / En construction Permanent Addition / Ajout permanent
ATP Pre 2014-15 / App. pré 2014-15
Planned / Planification
School / École
2016-17
2016-17
2016-17
500,000
5,000,000
1,000,000
500,000
Capital Financial Position Worksheet
Table 1: Board Funded Spending on Capital Projects
Capital Activity Post August 31, 2014 (From Project Eligibility Sheet)
Amounts to be Constructed At August 31, 2014 (Projects approved pre 2014-15 only)
Table 1c: Capital Activities Post-August 31, 2014
($Millions)
Project name - Amounts to be constructed at
August 31, 2014
Ontario High School
Richmond Public School
Funding Source
School Renewal
POD
Accum. Surplus
3rd party (please explain)
Sub-total_Amounts to be constructed at Aug 31, 2014
"PRO-1A" worksheet Sum of Col 7.4 projects approved
pre 2014-15 only
7.000
Total
Comments
Childcare funding by provider
0.500
5.000
1.000
0.500
7.000
Example 1: Ontario High School
School Renewal Schedule Worksheet
School Renewal Transfer to DCC
Project Name
Total School Renewal to be
encumbered
Project B
Ontario High School
School Renewal Transfer to DCC in the next 10 years
Future School
Renewal Transfer to
DCC
Ministry ATP Status
2014-15 in-year applied
Balance as August 31,
2015
1.10
1.60
0.10
0.10
0.10
0.10
0.20
2015-16
2016-17
2017-18
2018-19
2019-20
Approved
2.70
Approved
0.50
-
0.50
0.10
0.10
0.10
0.10
0.10
3
1.10
7%
2.10
n/a
0.20
2%
0.20
2%
0.20
2%
0.20
2%
0.30
3%
Total Renewal Encumbered
Annual Renewal Encumbrance %
2020-21
2021-22
2022-23
2023-24
2024-25
0.20
0.20
0.20
0.20
0.20
0.20
2%
0.20
2%
0.20
2%
0.20
2%
0.20
2%
-
Capital Financial Position Worksheet
Table 4b: Summary - Capital Surplus/(Deficit) Including Future Sources to be Applied
Add: School Renewal Grant (Future Grant Encumbered - agree to "School Renewal Schedule" Cell E35)
• Ontario High School Project requires $500,000 Future School Renewal
Grant
• FIN-FP worksheet Table 4b Cell P83 – automatically pre-load the
amount from FIN-SR worksheet Cell E35
2.100
Example 2: Richmond Public School
Active Project Worksheet
Approval to Proceed (ATP) /
Approbation de procéder
Project Details / Détails du projet
School Name /
Nom de l'école
Description
SFIS / SIIS
Ministry ATP Status / Statut de la
demande d'approbation
Date
(YYMMDD)
Col. 1.1
Col. 1.2
Col. 1.3
Col. 1.4
Col. 2.1
7777
ATP Pre 2014-15 / App. pré 2014-15
140902
Richmond Public School
New 600 PP Elementary
Board Committed Funding
Amount / Montant Renewal / Réfection
Col. 2.2
11,000,000
Col. 3.1
POD / Produits Accumulated
d'aliénation Surplus accumulé
Col. 3.2
5,000,000
Col. 3.3
EDC / RAS
Other / Autre
Total
Col. 3.4
Col. 3.5
Col. 3.6 =
Col. 3.1 to Col. 3.5
1,000,000
500,000
6,500,000
0
o Richmond Public School requires total of $6.5M board funding:
•
POD = $ 5.0M
POD-S worksheet 2014-15 committed use of POD $5.0M and
amount will be transferred to FIN-FP worksheet Table 3a & Table 4a
•
Accum. Surplus = $ 1.0M
•
3rd Party Revenue (Future) = $ 0.5M
comment box
EFIS Sch 5.5 & 5 and Table 2 Committed Capital Projects
Table 4b and provide explanation in the
Common Issues – Year End

Common Issues:
 CAPT submitted with Red Error Messages
 Financial information does not agree to EFIS (ie. NPF column total in the
Project Active worksheet has to reconcile with Section 12 of EFIS –Line 12.37)

Year End Submission:
 Anticipated release of the CAPT V4 is late September and it is required
to be submitted to the Ministry by November 28th, 2014.
 As in previous years, this submission includes board’s request for longterm financing with the Ontario Financing Authority (OFA).
25
New - Process – Approval To Proceed (ATP)

Approval To Proceed Submission as of October 1, 2014
 When boards submit a request for approval to proceed to tender for a
project, they will no longer be required to submit the CAPT.
 Boards are now required to complete the Approval to Proceed (ATP)
Request Form.
− Will be posted on the FAAB website
− Boards to submit to Ministry Capital Analyst and Financial Analyst
 Once the ATP request is completed, your Capital Analyst will update the
CAPT and send an updated copy.
26
Assistance:

Training Manual for the CAPT will be posted on the FAAB website. It
includes detailed instructions for completing the CAPT

Capital Analysts and Financial Analysts are also available to assist
boards in completing the CAPT
(http://faab.edu.gov.on.ca/Contact_Us.htm)
For Questions Regarding…
Capital Financial Position
School Renewal
Proceeds of Disposition
Project Master – Project Active
Project Debenture Matrix
OFA Request Form (Part 1 & 2)
ATP Request Form
Contact…
Financial Analyst
Financial Analyst
Financial Analyst
Capital Analyst
Capital Analyst
Diamond Tsui
Capital Analyst
27