|
Tenders are invited for FAST Financial Modelling Training Overall objective: To equip a cross-functional cohort of AECF staff to build, read, review and adapt transparent, auditable financial models using the FAST Standard, and to apply those techniques to debt and project-finance type transactions. The specific objectives are to: Introduce a consistent organization-wide approach to model design and construction; Strengthen participants ability to integrate operating drivers, financial statements, debt and return calculations; Develop practical capability in construction financing, debt sizing and sculpting, covenant analysis and project-return optimization; Improve the speed and quality of peer review, due diligence and investment decision support; and Provide reusable course materials and post-course support that reinforce application after the live program. 4. Scope of Work and Training Program The service provider will design and deliver the program as one integrated learning pathway comprising the following stages. Stage 1 | pre-course preparation Purpose: Establish initial familiarity with FAST and reinforce the Excel and keyboard skills required for the live sessions. Delivery and duration: Approximately 2-3 hours of self-paced online learning, to be completed 2-3 days before the first live session. Excel configuration, navigation and productivity shortcuts; Core FAST design principles, calculation blocks, links and placeholders; Timing flags, basic model balances and model-construction drills; and Short readiness assessments to confirm that participants can progress. Stage 2 | Best Practice / Three-Statement Financial Modelling Purpose: Enable participants to build and review a fully integrated model using a structured case study and the FAST Standard. Delivery and duration: 12 hours of live online instruction, practical demonstrations, individual assignments and collective feedback. Model timing, 2D calculation blocks, price/volume revenue drivers and fixed/variable operating costs; Three-statement integration, opening balances, fixed assets, depreciation, capital expenditure and working capital; Share capital, dividends, senior debt repayment and interest; DCF valuation, NPV, equity IRR, scenarios and sensitivities; and Checks, tracking, input relocation and model finalization. Stage 3 | Project Finance Financial Modelling Purpose: Apply FAST techniques to a greenfield renewable-energy case study incorporating construction, non-recourse financing and optimization constraints. Delivery and duration: 12 hours of live online instruction, practical demonstrations, individual assignments and collective feedback. construction costs, sources and uses, financing fees and interest during construction; construction facilities, refinancing, circularities and transition from construction to operations; current-period, average and minimum DSCR calculations and debt-sculpted repayment profiles; equity returns across dual time periods, tariff and leverage optimization, and lender/equity constraints; and VBA/macros, shareholder loans and debt-service reserve accounts. Stage 4 | Post-course support Purpose: Reinforce learning and enable participants to revisit the material while applying the standard in live AECF work. Delivery and duration: Access to the providers online learning environment following completion of the live program, including but not limited to: Recordings of the live online sessions; Pre-recorded versions of the foundational/ three statement and relevant project finance courses; End-of-course and fully built solution models; Course-completion certificates; and Access to technical support forums for course-related questions. 5. Delivery methodology and schedule Live delivery. The trainer will build models live while participants observe, ask questions, and practice through structured assignments. Daily structure. Each training day will comprise three two-hour sessions, proposed for 9:00-11:00, 12:00-14:00 and 15:30-17:30 East Africa Time. Applied assignments. Participants will complete two assignments between the days live sessions. Common errors and alternative approaches will be reviewed collectively at the start of the next session. Dates. The four live training days will be agreed with AECF and may be scheduled consecutively or on mutually agreed dates that protect participation and business continuity. Language and platform. The program will be delivered in English through Zoom or another platform agreed with AECF. Tender Link : https://www.aecfafrica.org/about-us/opportunities/
|
