Fundamentals of Financial Modelling and Forecasting

Fundamentals of Financial Modelling and Forecasting Program

FFMF

Unlock Financial Insights with Robust Modeling Techniques

The Fundamentals of Financial Modeling and Forecasting Program course provides essential skills to build accurate and reliable financial models. Participants will learn best practices in Excel, data management, financial statement modeling, and forecasting techniques to support strategic decision-making.

Ideal for finance professionals, business owners, and aspiring analysts, this course emphasizes practical applications and real-world scenarios. By the end, participants will be equipped to create robust models for budgeting, investment analysis, and business planning

By attending this program, you will:

  • Understand the foundational conceptsof financial modeling and forecasting, including their definitions, importance, and applications in decision-making.
  • Apply best practices in building financial models, ensuring accuracy, consistency, transparency, and proper documentation of assumptions.
  • Develop robust financial models using Excel, leveraging efficient workbook organization, naming conventions, and advanced tools like tables and pivot tables.
  • Construct and analyze core financial statements (income statement, balance sheet, and cash flow statement) through detailed projections and sensitivity analyses.
  • Master advanced Excel functions and formulas, including financial, logical, and lookup functions, to enhance the accuracy and functionality of financial models.

What they say about FMFF Program

"FFMF is an excellent program for anyone aiming to excel as a finance analyst. It provides advanced tools, practical insights, and a strong foundation in financial strategy and performance analysis to support professional growth and development."

Richelle B. Padilla
Catalyst Bpx
FP&A analyst


"This training gave me new tools that I can apply in my work, particularly Excel functions such as What-If Analysis, Developer Tools, shortcuts, sensitivity analysis, and creating financial models that are easy to understand. It also refreshed my knowledge of accounting concepts relevant to budgeting. I only wish there were more sessions to cover additional principles. My sincere thanks to Sir Baguipo and the rest of the hosts for the informative and well-prepared sessions."

Sy, Nikka L.
Budget and Planning Specialist
Tanduay Distillers, Inc.


"The final session was very insightful, and I was glad I could easily follow the discussion without feeling left behind. The topics on discounted cash flow projections, especially XIRR, XNPV, and terminal value, were completely new to me. While I was already familiar with intrinsic value and market value from my undergraduate studies, this training gave me a much deeper and clearer understanding of these concepts. I’m truly grateful for this session and the entire six-day training. Thank you, Sir Elson!"

Tungcab, Jeremae D.
Finance and Strategic Clerk
Perpetual Help Community Cooperative