Beacon Consulting EG Financial Model Fundamentals Beacon Consulting EG
Price: EGP 11,700

Course details

• Appreciate the difference between what makes a good Financial Model and a bad one.
• Follow a logical, structured and disciplined approach towards model building.
• Build a Financial Model (or significant parts of one) from A to Z.
• Gain a deeper understanding of project finance transactions, the types of models used and their typical structure.
• Learn how to translate key financial and commercial aspects into Excel.
• Understand better how to tailor the outputs of the model towards end users and interpret the results.
• Improve knowledge of Excel functionality.
• Learn ways to reduce the incidence of modeling errors.


Modelling basics and introduction to the valuations environment
• What financial models do and the risks associated with financial modeling
• Leading approaches to model building, the benefits they bring and the importance of formatting
• Introduction to the project finance environment, the key stakeholders involved and the different types of financial models used Structure

Model design
• The overall model development process and items to cover during the design phase
• Typical layout, structure and flow of a suitable financial model;
• Adopting a template approach to achieve consistency between model worksheets
• Using 'control accounts' as the key building blocks for the calculations of a model Inputs

Assumptions, sensitivities and scenario cases
• Alternative layouts for model inputs and scenarios also using range names and data validation.

Fixed Assets and depreciation
• Different ways of modeling capital expenditure relating to different asset classes, including project and capitalized costs
• Depreciation methodologies including a more streamlined method for straightline depreciation where multiple asset acquisitions take place across the model timeline

Operating Modelling
• Generating forecasts for revenues, operating and maintenance costs and working capital
• Calculating indexation factors based on different cash flow timing assumptions and converting real cash flows to nominal
• Overview of availability type transactions and what to consider when modeling associated payment streams

Debt and equity financing
• Modeling sources and uses of funds, calculating the funding requirement and different drawdown approaches to service funding needs
• Costs related to debt financing such as interest, commitment fees and arrangement fees
• Different debt repayment methods including annuity, straight-line, bullet, balloon and sculpted
• Modeling multiple tranches of debt according to their position in the cash waterfall hierarchy

Financial statements, other schedules and graphs
• The importance of integrated financial statements and how to set them up
• IRR and NPV calculations, using both project and equity cash flows, calculated from first principles and using Excel's in built functions
• Other key output measures such as lending and profitability ratios and industry KPIs, including tailoring these towards the end users
•Graphing tips Implementation and use

Using the model
• Creating dashboards, hyperlinks and contents pages for easier use and navigation around the model
• Interpreting the model's outputs and monitoring key transaction measures as well as other KPIs and covenants
• Performing stress testing on a model based on designated sensitivities and in-built scenario cases
• Identifying optimization objectives and running optimizing processes within a financial model

Model review and testing
• Identifying optimization objectives and running optimizing processes within a financial model
• Use of a checks sheet to automatically detect and quickly identify potential modeling errors

General house keeping
• Workbook protection, printing, version control and project management

Real life Simulation
Corporate finance application
• After creating a full complete and dedicate model, you will set to a committee from a Treasurer and Modeler who will act as bank side and you will need to debate and discuss with this committee to finance your model, this is best simulation grant your ability to apply in real life.
• Now you can create model from scratch, and engage with banks to finance your debt portion professionally.

About Beacon Consulting EG

The Treasury Hub !

Beacon Consulting EG is tailored Corporate Treasury consultancy and training service provider, we “Execlusivelly” Consulte, Train and Recruit for Corporate Treasury Function.
Instructors/Consultants are on a high level of professionalism and product manifestation where they are well trained to satisfy customers'​ needs throughout the course track as well as their extensive knowledge to retain customer base. See all Beacon Consulting EG courses

Enquire about this course

You may add more courses here,
your list will be saved.

Rate our content