CFI - Corporate Finance Institute

Corporate Finance Institute (CFI) is the #1 rated online provider of finance and banking training, certifications, and productivity tools. We equip professionals with job-ready skills and practical resources to boost their performance and careers. Established in 2016, CFI is trusted by over 2 million individuals and thousands of organizations worldwide.

Course Overview

The FMVA Certification was designed to fill a gap in the market for financial analysts. 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.

For More Inquiries

Shady Gamal Zaki

Business Development Assistant Manager

 +966534175887

 s.gamal@beacon.com.eg

Shady Gamal Zaki

Business Development Assistant Manager

 +966534175887

 s.gamal@beacon.com.eg

Course 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

Course Outline

Step 1 :Prep Courses
  • Excel Fundamentals
  • Accounting Fundamentals
Step 2 :Core Courses
  • 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
Step 3 :Elective Courses
  • 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
Step 4 :Case Study Challenges (Optional)
  • The Amazon Case Study (New Edition)
  • Renewable Energy - Solar Financial Modeling

Who Should Attend

The FMVA 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.

FAQ

As soon as you complete the program! After completing the FMVA® program requirements (14 required & 3 elective courses) and passing the final exam, you can immediately request your digital FMVA® certificate to be emailed to you by submitting your completed program through your student dashboard.

Students are required to complete an online assessment (MCQ`s, Fill-in-the-Blanks, and Excel Questions) at the end of each course. You can take the exams at your own schedule and will need to earn at least 70% to pass the course and earn your certificate of course completion.

Share