Financial Modeling Using Excel

Blair Cook, CPA

Executive Finance Partner Inc.

  • CPA Canada
  • CMA
  • CPA
  • Tax Pros
  • 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?

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