Financial Modeling Using Excel

Blair Cook, CPA, CA, MBA

Executive Finance Partner Inc.

  • CPA Canada
  • CMA
  • CPA
  • Tax Preparer
  • CFE

You need to register for the webinar to watch the video.

Click Here to Register

Before starting this self study program, please go through the instructional document.

Overview

  • Consolidated Model
    4 mins
  • Planning Summary
    13 mins
  • Templating Summary
    25 mins
  • Income Statement Summary
    39 mins
  • Non-Cash items to adjust
    58 mins
  • Advanced Modeling Summary
    83 mins

Course Description

A financial model is simply a tool that’s built in spreadsheet software such as MS Excel to forecast a business’ financial performance into the future.  The forecast is typically based on the company’s historical performance, assumptions about the future, and requires preparing an income statement, balance sheet, cash flow statement, and supporting schedules (known as a 3 statement model).

In this webinar, we are going 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. The webinar is going to concentrate on the preparation of a financial projection of the income statement, balance sheet and statement of cash flow. The webinar will use an approach that keeps model integrity and credibility top of mind throughout development.

Learning Objectives

  • To use a disciplined approach for using Excel to develop financial analysis.
  • To prepare financial projections of the income statement, balance sheet, and statement of cash flows.

Who Should Attend?

  • Accountant
  • Accounting Firm
  • Accounting Managers
  • Accounting Practice Owners
  • Certified Financial Planner
  • Cloud Accountants
  • CPA (Industry)
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • CPA in Business
  • Entrepreneurial Accountant
  • Entrepreneurial CPA
  • Finance Director
  • Finance Pros
  • Senior Accountant
  • Staff of Accounting Firm
  • Tax Accountant (Industry)
  • VP Accounts
  • VP Finance
  • Young CPA