Module 1: Foundations of Financial Modeling

·       Introduction to financial modeling and its importance

·       Principles of good spreadsheet design and best practices

·       Structuring financial models for clarity and flexibility

·       Using formulas and functions effectively

·       Error checking and auditing financial models

·       Practical session: Setting up a financial model template with best practice formatting.

Module 2: Building the Income Statement Model

·       Forecasting revenue using different methods (historical growth, market analysis)

·       Modeling cost of goods sold (COGS) and operating expenses

·       Incorporating depreciation and amortization

·       Calculating earnings before interest and taxes (EBIT)

·       Modeling interest expense and income taxes

·       Practical session: Building an income statement forecast using historical data.

Module 3: Building the Balance Sheet Model

·       Modeling current assets: cash, accounts receivable, inventory

·       Forecasting fixed assets and capital expenditures (CAPEX)

·       Modeling current liabilities: accounts payable, accrued expenses

·       Forecasting long-term debt and equity

·       Ensuring the balance sheet balances

·       Practical session: Developing a balance sheet forecast based on operational drivers.

Module 4: Building the Cash Flow Statement Model

·       Understanding the three sections of the cash flow statement (operating, investing, financing)

·       Using the indirect method to forecast cash flow from operations

·       Modeling cash flows related to capital expenditures and asset disposals

·       Forecasting cash flows related to debt and equity financing

·       Linking the cash flow statement to the income statement and balance sheet

·       Practical session: Creating a cash flow statement forecast linked to the income statement and balance sheet.

Module 5: Forecasting Techniques and Assumptions

·       Historical data analysis and trend extrapolation

·       Regression analysis for forecasting key variables

·       Driver-based forecasting: identifying and modeling key business drivers

·       Sensitivity of forecasts to underlying assumptions

·       Documenting assumptions clearly and transparently

·       Practical session: Applying driver-based forecasting to project revenue.

Module 6: Working Capital Modeling

·       Modeling accounts receivable and days sales outstanding (DSO)

·       Forecasting inventory and days inventory outstanding (DIO)

·       Modeling accounts payable and days payable outstanding (DPO)

·       Calculating the cash conversion cycle

·       Analyzing the impact of working capital on cash flow

·       Practical session: Building a working capital schedule and analyzing its impact on cash flow.

Module 7: Debt and Equity Modeling

·       Modeling different types of debt financing (term loans, revolving credit facilities)

·       Incorporating debt schedules and interest calculations

·       Modeling equity financing and share capital changes

·       Analyzing the impact of financing on the balance sheet and cash flow

·       Modeling debt covenants and their implications

·       Practical session: Building a debt schedule within a financial model.

Module 8: Introduction to Valuation Modeling (DCF)

·       Understanding the principles of discounted cash flow (DCF) valuation

·       Forecasting free cash flow to firm (FCFF) and free cash flow to equity (FCFE)

·       Determining the appropriate discount rate (WACC or cost of equity)

·       Calculating the terminal value

·       Discounting future cash flows to present value

·       Practical session: Building a basic DCF valuation model.

Module 9: Sensitivity and Scenario Analysis

·       Understanding the importance of sensitivity analysis

·       Identifying key model drivers and assumptions for sensitivity testing

·       Using "what-if" analysis to assess the impact of changes in assumptions

·       Developing different business scenarios (best case, base case, worst case)

·       Analyzing the robustness of the financial model under different scenarios

·       Practical session: Performing a sensitivity analysis on key assumptions in a financial model.

Module 10: Presenting Financial Model Outputs

·       Creating clear and concise summaries of model outputs

·       Developing charts and graphs to visualize key findings

·       Communicating key assumptions and sensitivities

·       Tailoring presentations to different audiences

·       Documenting the financial model and its methodology

·       Practical session: Presenting the outputs of a financial model.

Requirements:

·       Participants should be reasonably proficient in English.

·       Applicants must live up to Armstrong Global Institute 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@armstrongglobalinstitute.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 / +254725012095 / +254724452588

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: Armstrong Global Training & Development Center 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

This training course can also be customized for your institution upon request for a minimum of 5 participants. You can have it conducted at our Training Centre or at a convenient location. For further inquiries, please contact us on Tel: +254720272325 / +254725012095 / +254724452588 or Email training@armstrongglobalinstitute.com

Accommodation and Airport Transfer

Accommodation and Airport Transfer is arranged upon request and at extra cost. For reservations contact the Training Officer on Email: training@armstrongglobalinstitute.com or on Tel: +254720272325 / +254725012095 / +254724452588