Professional Masterclass in Applied Financial Modelling & Forecasting

Course Outline

Module 1: Foundations of Financial Modelling

ü  Introduction to financial modeling and its applications

ü  Best practices for model design and structure

ü  Excel functionalities for efficient modelling (shortcuts, functions)

ü  Data collection and input sheet creation

ü  Practical Session: Building a basic one-year forecast model

Module 2: Building Integrated Financial Statements

ü  Linking the Income Statement, Balance Sheet, and Cash Flow Statement

ü  The "circularity" issue and how to resolve it

ü  Depreciation and amortization schedules

ü  Working capital and its impact on the model

ü  Practical Session: Constructing a three-statement financial model template

Module 3: Forecasting Techniques and Revenue Projections

ü  Top-down vs. bottom-up forecasting

ü  Key drivers and assumptions for revenue forecasting

ü  Growth rate analysis and historical trend projection

ü  Introduction to statistical forecasting methods

ü  Practical Session: Forecasting a company's revenue and COGS using historical data

Module 4: Operating and Capital Expenditure Modelling

ü  Forecasting operating expenses (SG&A)

ü  Building a detailed capital expenditure schedule

ü  Modelling depreciation and asset disposals

ü  Understanding the impact of capex on cash flow

ü  Practical Session: Creating a detailed capex and depreciation schedule within the model

Module 5: The Financial Statement Forecast Model

ü  Integrating all components to create a complete forecast model

ü  Calculating key financial ratios and performance metrics

ü  Stress testing the model with different assumptions

ü  Presenting forecast results in a clear and concise manner

ü  Practical Session: Finalizing the complete three-statement forecast model

Module 6: Valuation Methodologies

ü  Introduction to discounted cash flow (DCF) analysis

ü  Calculating the Weighted Average Cost of Capital (WACC)

ü  Performing comparable company analysis

ü  Introduction to Leveraged Buyout (LBO) modelling

ü  Practical Session: Performing a basic DCF valuation

Module 7: Scenario and Sensitivity Analysis

ü  Using Excel's Scenario Manager and Data Tables

ü  What-if analysis to test different outcomes

ü  Building dynamic dashboards for sensitivity analysis

ü  Interpreting and communicating the results of sensitivity analysis

ü  Practical Session: Building a sensitivity table for key assumptions

Module 8: Advanced Modelling Topics

ü  Debt and financing schedules

ü  Revolver and cash sweep mechanics

ü  Equity waterfall and distribution models

ü  Mergers and acquisitions (M&A) modelling overview

ü  Practical Session: Adding a debt and repayment schedule to the model

Module 9: Budgeting, Planning and Strategic Forecasting

ü  The role of financial models in corporate planning

ü  Linking operational plans to financial forecasts

ü  Creating rolling forecasts and budget variance analysis

ü  Using models for capital allocation decisions

ü  Practical Session: Creating a basic operational budget within the model

Module 10: Model Audit, Review, and Best Practices

ü  Auditing a model for errors and inconsistencies

ü  Best practices for documentation and commenting

ü  Model maintenance and version control

ü  Common mistakes to avoid in financial modelling

ü  Practical Session: Peer review and audit of a completed financial model

About Our Trainers

Our financial training lecturers are highly experienced professionals with backgrounds in investment banking, corporate finance, and big-four accounting firms. They have built and used complex financial models for multi-billion dollar transactions and strategic decisions. Their deep industry knowledge, coupled with a passion for teaching, ensures that participants receive practical and actionable insights. Our Financial Training Blog also features articles from our experts, providing continuous learning opportunities.

Quality Statement

Phoenix Training Center is committed to delivering a premier Financial Training Course that offers exceptional value. We maintain the highest standards of quality by providing up-to-date, relevant content and expert instructors. Our rigorous curriculum is designed to ensure every participant gains a profound and practical understanding of financial modelling and forecasting.

Admission Criteria

ü  Participants should be reasonably proficient in English. 

ü  Applicants must live up to Phoenix Center for Policy, Research and Training admission criteria.

Terms and Conditions

1. Discounts: Organizations sponsoring Four Participants will have the 5th attend Free
2. What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.
3. Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.
4. The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.
5. Approval of Course: Our Programs are NITA Approved. Participating organizations can therefore claim reimbursement on fees paid in accordance with NITA Rules.

Booking for Training

Simply send an email to the Training Officer on training@phoenixtrainingcenter.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training.

Or call us on +254720272325 / +254737296202

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

1. Groups of 5 People and Above – Cheque Payments to: Phoenix Center for Policy, Research and Training Limited should be paid in advance, 5 days to the training.
2. Invoice: We can send a bill directly to you or your company.
3. Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

1. Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.
2. Participants may cancel attendance 14 days or more prior to the training commencement date.
3. No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Tailor-Made Courses

We understand that every organization has unique ESG challenges and opportunities as well as unique training needs. Phoenix Training Center offers tailor-made courses designed to address specific requirements and challenges faced by your team or organization. Whether you need a customized curriculum, a specific duration, or on-site delivery, we can adapt our expertise to provide a training solution that perfectly aligns with your objectives. We can customize this ESG Risk Management Course to focus on your industry, specific risk profile, or internal stakeholder dynamics. Contact us to discuss how we can create a bespoke training program that maximizes value and impact for your team. For further inquiries, please contact us on Tel: +254720272325 / +254737296202 or Email training@phoenixtrainingcenter.com

Accommodation and Airport Pick-up

For physical training attendees, we can assist with recommendations for accommodation near the training venue. Airport pick-up services can also be arranged upon request to ensure a smooth arrival. Please inform us of your travel details in advance if you require these services. For reservations contact the Training Officer on Email: training@phoenixtrainingcenter.com or on Tel: +254720272325 / +254737296202