220 likes | 306 Views
Department of Finance and Services. Basic Financial Capacity Assessment Template. [Contracting party] January 2013 ABN [xxx xxx xxx]. Recommendations and Conclusions. Executive Summary. Recommendations:
E N D
Department of Finance and Services Basic Financial Capacity Assessment Template • [Contracting party] • January 2013 • ABN [xxx xxx xxx]
Recommendations and Conclusions Executive Summary • Recommendations: • [Contractor] Pty Ltd to be [accepted/rejected] for the proposed tender, with tender value limited to $[X]m dependent on the department assessment criteria (AND major factors influencing the recommendation).
Contract summary & assessment criteria • Financial Assessment Matrix • The criteria for report level selection is based on both the contract size and the annual revenue of the contractor shown above. • The proposed contract value totals $[X]. The proposed contractor had revenues in FY12 of $[X]m. Therefore a “Medium Assessment” has been undertaken. • Note: Any other work with the department currently being tendered for needs to be considered in aggregate. Contract Summary Unless the review is performed shortly following year end, the annual financial statement may not be an accurate reflection of the current financial position of the contractor. The DFS criteria should be applied to the most recent month end balance sheet available which in some cases will be sourced from recent management accounts as opposed to annual financial statements. NB - the reviewer will need to consider any significant adjustments necessary most notably classification of related party receivables between long term and short term, which can significantly impact the working capital criteria. • The following rule should be followed by the financial assessor: • If the most recent year-end financial accounts are < 6 months old, the revenue from these accounts should be compared to the thresholds of the financial assessment matrix. • If the most recent year-end financial accounts are > 6 months old, the revenue recorded in the current year to date should be annualised and compared to the thresholds of the financial assessment matrix. (e.g. if 7 months of revenue data is available, this can be annualised by multiplying by 12/7). DFS Assessment Criteria
[The executive summary is to be used to summarise key findings and risks identified in the main body, and to assign risk weightings for each category. Commentary should be of sufficient detail to justify the risk weighting assigned. On completion we would expect it to be no more than 5 slides in length] • Understanding the contractor’s ownership and structure Executive Summary Risk Definitions: Low Risk Medium Risk High Risk
Understanding the contractor’s ownership and structure Executive Summary Risk Definitions: Low Risk Medium Risk High Risk
Understanding the contractor’s business Executive Summary Risk Definitions: Low Risk Medium Risk High Risk
Understanding the contractor’s business Executive Summary Risk Definitions: Low Risk Medium Risk High Risk
Understanding the contractor’s financial capacity Executive Summary Risk Definitions: Low Risk Medium Risk High Risk
Understanding the contractor’s financial capacity Executive Summary Risk Definitions: Low Risk Medium Risk High Risk
Understanding the contractor’s ownership and structure Ownership and Structure • Float (if applicable) • [ ] family trusts and other holding structures • [ ] Institutional shareholders XX% XX% XX% [Contractor] Group Holdings Pty Ltd X% X% X% XX [Contractor] Pty Ltd XX Pty Ltd X% X% X% [Cross Guarantee $Xm] XX Services Pty Ltd XX XX • Update group structure as applicable • Note any guarantees, charges or other relevant security between group entities and related parties and the magnitude of any such security.
Understanding the contractor’s ownership and structure • Management Structure (if relevant) Ownership and Structure [Executive Director] [Sales Manager] [Finance Manager] [Marketing Manager] [HR Manager] [Financial Accountant] [Management Accountant]
Understanding the contractor’s ownership and structure Ownership and Structure • Factors to consider: • Is the Directors / Management’s experience and expertise sufficient to demonstrate capability to undertake the proposed contract? • Have the directors previously been involved in businesses which have entered financial difficulty and/or financial insolvency proceedings? • If so, is there any evidence of behaviour or management practices related to that situation which would be regarded as unsatisfactory? Unsatisfactory practices could include: • failure to have addressed financial difficulties before those issues became terminal • taking on high risk strategies and projects without appropriate capability and financial resources • financial misconduct or breach of directors’ duties.
Performance and Profitability • Profit & Loss Financial Capacity • Performance history • Commentary should be around profitability and trajectory aimed at identifying; • Trend of revenue (growing or contracting) • How movements have translated to profitability through: • Margin trends (improved or deteriorated) • Overhead movements (increased/decreased) on an absolute basis and as a proportion of revenue. • Factors to consider: • Interpretation of movements as to whether favourable or unfavourable in nature. • Explanation of the causes or key drivers of significant movements identified. • e.g.- Deteriorating margins could be indicative of issues with project management or execution and therefore evidence of increased risk to successful execution of the proposed contract. • Example wording: • ABC has been profitable for the last three years. • Revenue has grown from $[X] in FY10 to $[X] in FY12 ([X]% on an annual basis). • Gross margins fell from X% to X% owing to tightening tendering conditions • NPAT increased from $[X] in FY10 to $[X] in FY12. Source: 1) FYXX & FYXX: Audited accounts 2) FYXX: Management accounts (unaudited) [Note: Where recent full year data is not available, financial information presented to include YTD results.]
Work on hand & pipeline • Performance and Profitability The contractors business • Current work on hand • This section aims to identify projects on hand (being undertaken) by a bidder, their current status, and the extent of secured work remaining. Factors to consider: • How significant is the level of secured work going forward? (e.g. compare to annual turnover). • A small proportion demonstrates limited secured work and potentially higher risk. • Conversely, a company with a disproportionately large number of projects in progress may not have the capacity to take on additional projects. • Have any issues (e.g. delays or costs over runs) been experienced on jobs in hand? • What was the nature of those issues and how have they been resolved / mitigated going forwards? • Pipeline [if available] Factors to consider: • Opportunities identified in the pipeline may include a ‘probability of success’ – consider the historical win rate vs. forecast run rate. • A small pipeline value in relation to annual turnover (after applying the historical win rate), may indicate a shortfall in future work. • Does the pipeline contain opportunities of the size and nature that are within the contractors proven capabilities? • Is there an appropriate basis for inclusion of each opportunity in the pipeline? • Customer concentration • This section aims to identify any apparent over reliance on a limited number of customers and any mitigating factors. Factors to consider: • Identify the key customers from which revenue is generated and comment on the concentration. • A high percentage of revenue generated from only a handful of customers suggests possible overreliance. • If apparent overreliance is identified, consider the financial position of those customers relied upon. Risk will be increased if they are experiencing financial difficulty. • If a pipeline is available, comment on the extent to which concentration is expected to increase or decrease going forwards.
Cash Flow & Liquidity • Financial position Financial Capacity • Factors to consider: • Interpretation of movements as to whether favourable or unfavourable in nature. • Explanation of the causes or key drivers of significant movements identified. • Relativity of measures e.g. comparison of debtor/creditor days to the contractors general terms or industry parameters and note whether acceptable. • Any unusual movements between periods that might reflect; • liquidity pressure, • issues with collection on a project that may relate to performance or customer liquidity, • unsustainable creditor stretch. • Level of debt (consider financing ratio’s above vs. industry averages and whether appear excessive ) and the source of debt (i.e. external lender or related party loans?). • Financial position and Liquidity • Commentary should be around net asset position, working capital and cash, and their associated trajectories, aimed at identifying; • Any actual or near balance sheet insolvency issues • The level of cash available and the level of debt • Trends in key working capital ratios including: • Current ratio (improved or deteriorated) • Debtor days, WIP/Inventory Days and Creditor days (improved or deteriorated) • NWC as a proportion of sales (increased or decreased) • Note any material related party receivables / payables / loans. Source: 1) FYXX & FYXX: Audited accounts 2) FYXX: Management accounts (unaudited)
Cash Flow & Liquidity • Cash flow Financial Capacity • Cash flow • Commentary should be around cash generation and trajectory aimed at identifying; • Is the business generating cash from operating activities? • What’s the trend (increasing or decreasing)? • Were there any significant borrowings or repayments in the period? • How much CAPEX was made in the period? • The level of net cash flow and resultant headroom vs. facilities available. • Factors to consider: • Was operating cash flow generated predominantly earnings driven (sustainable) or working capital movement driven (non-sustainable)? • How much cash has been extracted as dividends by the businesses owners? Is the amount appropriate and sustainable? For example dividends that exceed say 75% of profit may result in the business being undercapitalised. • Was the level of CAPEX one-off in nature or is it recurring? Is CAPEX sufficient to maintain the asset base of the business (Comparison to Depreciation expense)? • Interpretation of other movements as to whether favourable or unfavourable in nature. Source: 1) FYXX & FYXX: Audited accounts 2) FYXX: Management accounts (unaudited) • Debtors and Creditor Ageing • This section aims to identify potential debtor recoverability issues and any potential stretch in creditors. • Factors to consider: • Comparison of the ageing of debtors / creditors to contractual terms (credit offered to customers and credit received). • Creditor balances aged beyond normal trading terms may indicate liquidity pressure or unsustainable credit stretch, whilst aged debtors may indicate recoverability issues. • Example wording: • With the exception of $[ ]k receivable from [debtor], all debtors are less than 60 days old and are therefore within an acceptable range of 45 day credit terms. • Creditors ageing is within an acceptable range of average terms of 30 to 45 days with the majority of balances aged less than 60 days.
Financing facilities • Facilities schedule as at [Date] Financial Capacity • This section aims to identify the funding facilities and headroom currently available to the contractor and any scope for additional or alternative funding should it be required. • Available facilities and funds • Factors to consider: • Do facilities expire during the life of the contract and are they expected to be extended on similar or better terms? • Do facilities include covenants and are they currently and forecast to be in compliance with those covenants and other terms? • Do they have sufficient headroom (available cash and extent of undrawn overdraft to fund the business forecast or absorb a shock or reasonable variance from forecast? • If the contracting entity required access to additional debt financing this requires an assessment of: • the status of the contractor’s relationship with its financier and willingness to provide additional finance • existence of offers of finance from new financiers • whether the business gearing levels are within reasonably acceptable levels indicating capacity to borrow further funds. • If financial support is required from shareholders, key considerations are: • The capacity (ability & willingness) of current or new shareholders to contribute additional equity which will be a function of their own financial capacity and view on price and risk.
Profitability • Example visual representation of profitability & performance Financial Capacity [Charts populated for illustrative purposes only] Include explanatory comments key observations Include explanatory comments key observations Include explanatory comments key observations Include explanatory comments key observations
Glossary Glossary
Glossary Glossary
Glossary Glossary
Glossary Glossary