On Demand (eLearning)

Building a Financial Model in Excel

JUN 08 - Dec 31, 2019

Online

DATE

JUN 08 - DEC 31

2019

TIME

12:00 AM - 11:59 PM

WHO CAN ATTEND

All

PD HOURS

5.5 Hours

ETHICS HOURS

0 Hours

STATUS

Registration closed on

Dec 31, 2019

EVENT DESCRIPTION

This event has now passed, please click here to view all available upcoming events and courses

Financial modeling is the ultimate tool for financial analysts to forecast and assess the performance of a company. In this course, you will learn to build a financial model from scratch. You will create a model that allows you to see the likely results of a given set of variables in case such a situation occurs. The model will help you make better financial decisions for your organization and aid in budgeting for the future.

LEARNING OBJECTIVES:

build a three-statement financial model in Excel

  • forecast the income statement and balance sheet
  • create debt and financing sections including interest calculations and capital structure
  • link the cash flow statement to the model
  • set assumptions that drive the model
  • PRICING

    $318.00 Personal Passport

    $318.00 Organization Passport

    $318.00 Member

    $318.00 Student

    $318.00 Public

    Status: Registration closed on Dec 31, 2019

    LOCATION

    Online

    SPEAKER(S) BIO

    Tim Vipond is an entrepreneur, financial analyst and former investment banker. He has worked across a wide range of corporate finance, financial modelling and forecasting roles at CIBC World Markets and Goldcorp Inc. Tim is the CEO of the Corporate Finance Institute®. Lisa Dorian has designed and delivered courses for the financial services and corporate sectors in strategy and analysis to numerous organizations, including Bank of Montreal, Deutsche Bank, and ATB Financial. Lisa is a CPA and Managing Director of MDA Training Inc. Scott Powell has over 15 years of experience designing and delivering Wall Street training programs for many of the world’s large investment banks. His clients include Allied Irish Bank, Bank of America and Merrill Lynch. Scott specializes in financial modeling, business valuations, and asset management.

    SPECIAL INSTRUCTIONS

    This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.

    However, you will only have access to the course for 30 days after REGISTRATION closes.

    To access the course please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.