FLASH PROMO: Enrol into any course for ₦2000 (over 90% off). Promo offer is ending soon. x

Financial Modeling Using Excel: Masterclass

In this online course, you are going to learn how to financially model a business using Excel. Financial models underpin strategic and business planning, solicitations for financing, budgeting and forecasting, business valuations, cash budgeting, capital budgeting, and so many other corporate finance purposes. In this course, we are going to concentrate on the preparation of a financial projection of the income statement, balance sheet and statement of cash flow. We will use an approach that keeps model integrity and credibility top of mind throughout development.

  • 2000
  • 15000
  • Course Includes
  • 2 Hour Video Class
  • Downloadable eBook
  • Free Certificate of Completion
  • 1-Year Access

Enrol and get access to the full course.

What you will learn

  • Financial Modeling
  • Income Statement
  • Balance Sheet
  • Model Template
  • Projecting Cash Flows
  • Advanced Financial Modeling

Requirements

  • Anyone interested in finance, accounting, or related fields can take this course.

Description

In this online course, you are going to learn how to financially model a business using Excel. Financial models underpin strategic and business planning, solicitations for financing, budgeting and forecasting, business valuations, cash budgeting, capital budgeting, and so many other corporate finance purposes. In this course, we are going to concentrate on the preparation of a financial projection of the income statement, balance sheet and statement of cash flow. We will use an approach that keeps model integrity and credibility top of mind throughout development.

Course Content

Click on the tabs to view all the contents
Overview of the Course
preview 5min
Planning your Financial Model
10min
Setting up a Model Template
13min
Projecting the Income Statement
14min
Projecting the Balance Sheet
17min
Projecting Cash Flow
15min
Advanced Financial Modeling
14min
Top Excel featured for Financial Modellers
8min
Workbooks and Ebook Copy
21mb
How to Download your Certificate of Completion
preview 3min

Recent Courses

About the Instructor

About the Instructor

Blair is a many-time corporate director, CFO, educator, innovator, thought leader, presenter, and curiosity generalist. As an academic-practitioner, he’s a perpetual learner who observes and experiments with various financial and management theories in real world context. He shares stories of his successes, failures, and lessons learned to all those who share a passion for further developing their own financial leadership qualities. His focus is on defining and developing a career path for financial professionals aspiring to the Office of the CFO and the Board of Directors. Blair has worked extensively with CPA Canada in recent years to design, develop, and launch the professional certification program.

Jen is a dynamic, versatile financial professional with over 20 years of leadership experience. Jen brings to the classroom a broad skill set and experience in all key facets of an organization including operations management, strategic planning, business development, finance, accounting, investor relations, human resources, and project management. Jen has a passion for making finance more attainable, whether its working to articulate strategy in a financial context or bringing clarity to financial communication. Jen’s career epitomizes the diverse experiences and roles that CPAs play in industry – from financial to operational leadership.