Quotations are hereby invited for the drafting of an independent report of the long-term financial plan for the ten (10) year period up until 30 June 2035. Specifications: 1. The previous 3 year’s historical information (2021/2022; 2022/2023; 2023/2024) (Statement of Financial Performance) to provide for a basis to reflect on the financial performance of the Municipality in the past and to plot future financial trends, 2. The Statement of Financial Position and the Cashflow statement are also required for a 10 year period. Three years MTREF and 7 years forecasting based on assumptions. The budget assumptions must be clearly documented in the report, 3. The latest approved 3 year’s MTREF operating budget (2024/2025, 2025/2026, 2026/2027), to provide for a basis to project the financial performance of the Municipality for the next 3 years. The format must be the same as the historical Income Statement aforementioned, 4. Also include the information of the Mid-Year Adjustment Budget for 2024/2025, 5. Appropriate corresponding summary tables (as prescribed by National Treasury) must be provided for the capital budget per Municipal Standard classification, 6. The LTFP must provide forecasting for the next 7 years, therefore 10 years in total if the MTREF period is added, 7. The following ratios must be provided for (Use the formulas as per Stellenbosch Municipality policies or if not included in the policies the formulas in the MFMA circular 71): 7.1. Current ratio, 7.2. Debtors collection ratio, 7.3. Employee cost ratio, 7.4. Cash generated from operations as % of own Revenue, 7.5. Cost coverage, 7.6. Debt to Revenue, 7.7. Gearing ratio, 7.8. Water distribution losses, 7.9. Electricity distribution losses, 7.10. Outstanding services debtors as % of total annual service revenue, and 7.11. Revenue growth, 7.12. Each input for these ratios must be linked to the model and data set or provide for separate easy input by municipal officials, 7.13. These ratios must be provided for the previous 3 years (historical), the next 3 years (as per latest MTREF), plus 7 years thereafter to complete the 10-year planning period, 8. Detailed explanation for variances on the above specified variances must be provided in the report, 9. In addition to the ratio, a list of financial indicators must be developed and presented in a “dashboard” format. These dashboard items will be provided by the municipality, 10. Sensitivity analysis of external funding calculations to indicate the impact on the financial position and future rates and tariffs of future borrowings within the policy framework of Council must be provided, 11. The municipality will provide the capital projects as encapsulated in the Capital Expenditure Framework, including the prioritization of capital projects for a 10-year planning period. The affordability envelope must be determined for the capital projects based on a funding mix. Assumptions and forecasts must be clearly documented, 12. The municipality has various ring-fenced reserves and provisions. The assessment must provide for the funding envelope of this for a 10-year planning period, 13. Link all information to the workings and assumptions that are being used, 14. The service provider must include the impact of all major current economic influencers such as load shedding, Eskom price increases, looming worldwide recessions, inflation indicators etc within the updating of the LTFP, 15. The report should include appropriate graphs, tables and figures, 16. Provision for a Net Present Value (NPV) calculator. (Offerte №120276123it)