FMVA

Overview

The Certification Program covers the most important skills required to become a world-class financial analyst, including finance, accounting, Excel, financial modeling, valuation, budgeting, forecasting, presentations, dashboards, and strategy.

Contact us form

Outcome

Identify key items on the financial statements and describe the interrelationship between all the components

Utilize the keyboard shortcuts to save time and be more efficient in Excel

Explain key concepts around capital investments, the capital-raising process, different forms of financing, and the optimal capital structure

Calculate the weighted-average cost of capital and construct a DCF model in Excel

Apply various forecasting techniques to develop a robust financial forecast

Details

Developed by: CFI - Corporate Finance Institute
Standard Total Hours: 72 Hrs
Language: English - Bilingual "English & Arabic"
Modalities: 
Next Rounds: 
Date Tenure Modality Venue
10 May 3 Months Face To Face Degla Plaza, Beacon Premises
19 Jul 3 months Face To Face Degla Plaza, Beacon Premises
Register Now

Outline

  • Excel Fundamentals
  • Accounting Fundamentals


  • Financial Analysis Fundamentals

  • Introduction to 3-Statement Modeling

  • Introduction to Business Valuation

  • Accounting Principles and Standards

  • Operational Modeling

  • DCF Valuation Modeling

  • Comparable Valuation Analysis

  • 3-Statement Modeling

  • Budgeting and Forecasting

  • FP&A Monthly Cash Flow Forecast Model

  • Scenario & Sensitivity Analysis in Excel

  • Dashboards & Data Visualization

  • PowerPoint & Pitchbooks


  • Mergers & Acquisitions (M&A) Modeling

  • M&A Accounting & Purchase Price Allocation

  • Startup / e-Commerce Financial Model & Valuation

  • Mining Financial Model & Valuation

  • Real Estate Financial Modeling

  • Real Estate Financial Modeling

  • Corporate & Business Strategy

  • Presentation of Financial Information

  • Advanced Excel Formulas & Functions

  • Excel VBA for Finance

  • Fundamentals of Data Analysis in Excel

  • Power BI Fundamentals

  • Power Query Fundamentals

  • Power BI Financial Statements

  • Modeling Risk with Monte Carlo Simulation

  • Regression Analysis - Fundamentals & Practical Applications

  • ESG Integration & Financial Analysis

  • FP&A Professional Excel Forecast Model Design

  • FP&A Professional Formatting & Revenue Forecasting

  • FP&A Professional Headcount Forecasting & Analysis

  • AI-Enhanced Financial Analysis

  • FP&A Professional Contractor Forecasting & Analysis

  • FP&A Professional Debt and Capex Forecasting & Analysis

  • Reading & Analyzing a Bank's Financial Statements

  • FP&A Professional Financial Statement Aggregation & Analysis

  • FP&A Professional Dashboard Visualizations & Analysis

  • The Amazon Case Study (New Edition)
  • Renewable Energy - Solar Financial Modeling

Read More

Who Should Attend

  • The F M V A program is an option for anyone that would like to develop and sharpen their technical professional skills
  • especially as they relate directly to modeling and presentation decks in corporate finance. This program is perfect for any Analyst level position.

Why Beacon

Quality

Beacon FinTrain prioritizes excellence in every service, ensuring top-notch, reliable, and consistent outcomes that meet and exceed client expectations.

Specialization

We focus on finance, offering expert knowledge and bespoke solutions that cater to the unique needs of finance professionals in the Middle East and Africa.

Punctuality

Time is money. We respect deadlines, delivering precise and timely results to help our clients stay ahead in the fast-paced financial world.

Guidance

Beacon FinTrain is a guiding light in finance, providing insightful advice and support to navigate the complexities of financial markets and regulations.

Integrity

We uphold the highest ethical standards, fostering trust and transparency in all our dealings to build lasting relationships with clients.

Flexibility

Adapting to the dynamic finance sector, we offer versatile services and solutions that align with the evolving needs of our clients.