Financial Modeling & Valuation Professional Certification (FMVA)

Financial Modeling & Valuation Professional Certification
Prepare participants to become job-ready Financial Modeling & Valuation Analysts capable of building professional financial models, performing business valuation, and supporting investment decisions.

Course Topics:

🔹 Module 1: 
( Excel for Finance Learning Outcomes )

( Master financial Excel functions )

( Build dynamic models )

( Automate financial reports )

Topics:

• Advanced formulas (INDEX, MATCH, XLOOKUP)
• Financial functions (NPV, IRR, PMT)
• Pivot Tables
• Data validation
• Scenario analysis
• Dashboard basics

Practical:

• Build automated financial dashboard.

🔹 Module 2: Accounting fundamental and financial Analysis Fundamental Learning Outcomes:

• Read and analyze financial statements
• Understand financial linkages

Topics:

• Income Statement
• Balance Sheet
• Cash Flow Statement
• Working Capital
• Depreciation
• Accrual vs Cash
• Financial ratios

Practical:

• Financial statement analysis case study.

🔹 Module 3 : Financial Modeling – 3 Statement Model 

• Learning Outcomes:
  (Build integrated financial models from scratch

Topics:

• Revenue forecasting
• Expense modeling
• Debt & interest schedule
• Depreciation modeling
• Working capital modeling
• Linking 3 financial statements
• Sensitivity analysis

Practical:

• Build a full 3-statement model in Excel.

🔹 Module 4: Business Valuation 1 

• Understand company capital structure
• Evaluate investment decisions

Topics:

• Time value of money
• Cost of capital (WACC)
• CAPM
• Capital budgeting
• Risk & return
• Dividend policy

Practical:

• Capital budgeting case (NPV & IRR project evaluation).

🔹 Module 5: Business Valuation 2
Learning Outcomes:

• Perform professional valuation

Topics:

• DCF valuation
• Terminal value methods
• Comparable company analysis
• Precedent transactions
• Sensitivity & scenario valuation
• Valuation report writing

Practical:

• Full DCF valuation model.

🔹 Module 6: Advanced Modeling (Optional / Advanced Track )
Choose 1–2:

• M&A Modeling
• LBO Modeling
• Startup valuation
• Real Estate Financial Modeling
• Power BI for Finance

🔹 Module 7: Capstone Project 
Final Project:
Participants will:

• Receive a real company case
• Build full financial model
• Perform valuation

High Focus Information

Strong Competitive Edge

✔ Not theory-based
✔ Real investment-grade modeling
✔ Capstone simulates banking environment
✔ Builds tangible portfolio
✔ Strong CV differentiation
✔ Faster ROI compared to long academic certifications

Key Details:

Date: 30 Apr - 30 Jul 2026

Venue: Andalusia Maadi Hospital / Hybrid

Fees: 9000 EGP