Advanced Financial Modelling and Corporate Valuation Training Course for Investment Analysts

Module 1: Financial Modeling Best Practices and Excel Mastery

ü  Designing a professional model structure and layout

ü  Color-coding conventions for inputs, formulas, and links

ü  Advanced Excel shortcuts for rapid modeling

ü  Essential functions: INDEX/MATCH, OFFSET, and CHOOSE

ü  Practical Session: Setting up a standardized model shell with proper formatting

Module 2: Building the 3-Statement Integrated Model

ü  Linking the Income Statement to the Balance Sheet

ü  Deriving the Cash Flow Statement from indirect methods

ü  Balancing the model using a "plug" or circularity logic

ü  Handling common modeling errors and circular references

ü  Practical Session: Completing the integration of a 3-statement model for a historical period

Module 3: Forecasting Operating Drivers and Capital Structure

ü  Top-down vs. bottom-up revenue forecasting

ü  Modeling fixed and variable operating costs

ü  Depreciation and Capex scheduling

ü  Debt and Interest schedules with cash sweeps

ü  Practical Session: Building a dynamic Capex and Depreciation schedule

Module 4: Discounted Cash Flow (DCF) Valuation

ü  Calculating Unlevered Free Cash Flow (UFCF)

ü  Estimating Terminal Value using Exit Multiple and Perpetuity Growth methods

ü  Discounting cash flows to find Enterprise Value

ü  Bridging Enterprise Value to Equity Value (Net Debt adjustments)

ü  Practical Session: Constructing a full DCF valuation for a selected case study

Module 5: Calculating the Cost of Capital (WACC)

ü  Determining the optimal capital structure

ü  Calculating the Cost of Equity using CAPM

ü  Estimating the Pre-tax and After-tax Cost of Debt

ü  Determining the Weighted Average Cost of Capital (WACC)

ü  Practical Session: Using Bloomberg/Market data to calculate a real-world WACC

Module 6: Comparable Company Analysis (Trading Comps)

ü  Selecting the right peer group for comparison

ü  Calculating and normalizing valuation multiples (P/E, EV/EBITDA, EV/Revenue)

ü  Spreading the "Comps" and interpreting the output

ü  Applying premiums and discounts

ü  Practical Session: Building a Trading Comps table for an industry sector

Module 7: Precedent Transaction Analysis (Transaction Comps)

ü  Identifying relevant historical M&A deals

ü  Calculating transaction multiples and control premiums

ü  Adjusting for deal synergy and market conditions

ü  Comparing results with Trading Comps and DCF

ü  Practical Session: Sourcing and spreading transaction multiples for a recent acquisition

Module 8: Sensitivity and Scenario Analysis

ü  Building Data Tables for one-variable and two-variable sensitivity

ü  Creating a Scenario Manager for "Base," "Upside," and "Downside" cases

ü  Using Goal Seek and Solver for financial optimization

ü  Visualizing sensitivity outputs with Football Field charts

ü  Practical Session: Creating a "Football Field" chart to summarize various valuation ranges

Module 9: M&A Modeling: Accretion and Dilution

ü  Fundamentals of M&A math and deal structuring

ü  Pro-forma balance sheet adjustments (Goodwill and Intangibles)

ü  Calculating the "Breakeven" PE ratio

ü  Analyzing the impact on Earnings Per Share (EPS)

ü  Practical Session: Building a basic M&A accretion/dilution model

Module 10: Model Auditing, Integrity, and Presentation

ü  Using "F5" and "Trace Precedents" for model auditing

ü  Implementing error-check tabs and balance alerts

ü  Executive summary design and data visualization

ü  Preparing the model for client or Board presentation

ü  Practical Session: Auditing a "broken" model to identify and fix structural errors

About Our Trainers

Our trainers are veteran investment professionals with extensive experience in Wall Street and regional investment banks. They hold prestigious certifications such as CFA and CPA and have collectively closed M&A transactions exceeding USD 5 Billion. They bring a practical, "in-the-trenches" perspective to modeling, focusing on what actually matters to decision-makers.

Quality Statement

Phoenix Training Center is committed to pedagogical excellence. Our financial modeling curriculum is updated quarterly to reflect current market trends and the latest versions of analytical software. We provide a rigorous, supportive environment that guarantees the transfer of elite technical skills to every participant.

Tailor-Made Courses

We understand that every organization has unique 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 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

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

ü  Discounts: Organizations sponsoring Four Participants will have the 5th attend Free

ü  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.

ü  Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.

ü  The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

ü  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:

ü  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.

ü  Invoice: We can send a bill directly to you or your company.

ü  Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

ü  Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

ü  Participants may cancel attendance 14 days or more prior to the training commencement date.

ü  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.

Accommodation and Airport Transfer

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