Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Authentication
digital resources
216x Filetype XLSX File size 0.73 MB Source: assets.publishing.service.gov.uk
Sheet 1: Monthly Report
| Templatesco Ltd | ||||||||
| Monthly report (construction) | ||||||||
| December 2018 | ||||||||
| Completed by: | ||||||||
| Signature: | ||||||||
| Approved by: | ||||||||
| Signature: | ||||||||
| Issue date: | ||||||||
| HNIP Application Reference Number: | ||||||||
| PROJECT DASHBOARD | ||||||||
| Phone | ||||||||
| Project name | ||||||||
| Project type | ||||||||
| Location | ||||||||
| Shareholders / sponsor | ||||||||
| Debt providers | ||||||||
| Principal contractor | ||||||||
| Technical advisor | ||||||||
| Legal advisor | ||||||||
| O&M provider | ||||||||
| ESCO directors | ||||||||
| Main project contact name | ||||||||
| Other category 1 | ||||||||
| Other category 2 | ||||||||
| Other category 3 | ||||||||
| • Where a contact name is given for any of the above items, please ensure that a telephone number and | ||||||||
| email address are also provided | ||||||||
| EXECUTIVE SUMMARY | ||||||||
| For a construction project, to include a summary of progress since the last report, detailing (c. 1 page): • Health, safety and environment • Milestones achieved during period • Update on project timetable • Update on project costs • Summary of any relevant technical issues • Update on funding, actual cash flows and forecast cash flows |
||||||||
| HEALTH, SAFETY AND ENVIRONMENT | ||||||||
| RIDDORs in period | ||||||||
| Accidents in period | ||||||||
| Near misses in period | ||||||||
| Commentary on RIDDORs, accidents, near misses during the period, as well as other HSE related matters (safety culture and overall approach to HSE at the project, environmental issues, HSE audits, director site walk-rounds etc.) | ||||||||
| KPIs (EXAMPLE - CAN BE TAILORED AS RELEVANT) | ||||||||
| As at 31 December 2018 | Latest estimate | Original estimate | ||||||
| Construction start date (date) | ||||||||
| Milestone 1 completion (date) | ||||||||
| Milestone 2 completion (date) | ||||||||
| Milestone 3 completion (date) | ||||||||
| Milestone 4 completion (date) | ||||||||
| Estimated completion date (date) | ||||||||
| Total project capex forecast (£'000) | ||||||||
| Forecast project IRR (%) | ||||||||
| Project gearing (Debt / EV) (%) | ||||||||
| Next HNIP drawdown date (date) | ||||||||
| Funding source 1 - total (£'000) | ||||||||
| Funding source 1 - drawn (£'000) | ||||||||
| Funding source 2 - total (£'000) | ||||||||
| Funding source 2 - drawn (£'000) | ||||||||
| • All changes in KPIs from the previous reporting must be explained as part of the reporting text | ||||||||
| • If possible, add in some sort of graphical representation illustrating project progress to | ||||||||
| date / planned progress to achieve commercialisation and the start of construction | ||||||||
| • Please note that all dates in the above table must be in the format dd/mm/yyy | ||||||||
| CONSTRUCTION UPDATE | ||||||||
| Expand on the executive summary giving a c.2 page + update of construction progress including any relevant technical issues. To include full milestone information, including value of each milestone – expands on the above table which contains the more high-level summary. Also includes a summary of key risks and opportunities around project delivery. | ||||||||
| FINANCIAL UPDATE | ||||||||
| Detailed commentary of financial performance to date (c.2-3 pages including tables), short- and medium-term cash flow forecast – to include monthly rolling cash flow statement with a detailed granular summary of income and expenditure. Commentary on funding requirements, proposed drawdowns etc, including drawdown and maturity profile of loans etc. To include a “sources and uses” for funding as per commercial modelling which has been carried out. | ||||||||
| COMMERCIAL UPDATE | ||||||||
| To discuss any commercial / customer / contractual points e.g. if Templatesco is actively seeking new commercial opportunities re expanding its connections under management or if there are any disputes / contractual issues not relating to the construction. (c. 1 page) | ||||||||
| GOVERNANCE | ||||||||
| Summary of any relevant corporate or governance matters which stakeholders which investors / financing providers should be aware of. This section should also include a matrix of commercial relationships for the scheme (c. 0.5 pages) | ||||||||
| OTHER | ||||||||
| Any other material items not covered elsewhere in the report (c. 0.5 pages) | ||||||||
| APPENDICES (to include risk matrix and CP matrix as per attached templates, as well as any additional relevant detail, e.g. copies of relevant correspondence, reports from subcontractors, copies of internal approvals for the scheme etc.) | ||||||||
| Templatesco Ltd | ||||||||||||||
| Risk matrix | ||||||||||||||
| December 2018 | ||||||||||||||
| PRE-MITIGATION | POST-MITIGATION | |||||||||||||
| Number | Risk name | Risk type | Details* | Date identified | Update from previous report (if relevant) | Date updated | Risk Probability (1-5) | Risk Impact (1-5) | Risk Score (PxI) | Actions to mitigate | Risk Probability (1-5) | Risk Impact (1-5) | Risk Score (PxI) | Open/Closed |
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| 0 | 0 | |||||||||||||
| *Fixed once the risk has initially been identified and described - updates to be provided in column F as part of subsequent reports to allow for tracking of risks by the monitoring and reporting team | ||||||||||||||
| Templatesco Ltd | ||||||
| Matrix of Conditions Precedent to Funding Drawdown | ||||||
| December 2018 | ||||||
| Number | CP name | CP details | Completed (Y/N) | Evidence submitted (Y/N) | Current status (if still open) | Estimated completion date |
no reviews yet
Please Login to review.
