Login

If you are a CPA Alberta member, or have a CPA Alberta account, please login with your account information.

If you are a non-member and do not already have an account, please create an account.

Forgot your account number or password?

Need help registering for a seminar? See our How to Register instructions.

  1.  
  2.  

Centennial 2010
  • Location:
 

BUILDING A FINANCIAL MODEL IN EXCEL


Level:
Competency: Corporate Finance
Seminar Code: 01602
Format: Recorded Webinar 4 Hours
CPD Hours: 4
Availability: Spaces available


Register before Mar 24, 2018 and pay the early fee!
Date: Saturday, Mar 31, 2018
Time: 12:00 AM
Location:

,
Meeting Room:
Fee Options: Tickets Required: 8 ticket(s)
Fee Required: N/A - Early Member
N/A - Early Non-Member
$250.00 - Regular Member
$250.00 - Regular Non-Member
Seminar Description: Available now! Please ignore its "Date and time" noted in the cart item listing. Session expires 3 months after purchase.

This four part series guides you through how to apply a structured approach to financial modeling in Excel.
It covers the many hallmarks that make financial models robust; demonstrates best practice techniques in planning model structure; and explains how to forecast the income statement from operating revenues down to operating profit.
MODULE 1 - A STRUCTURED APPROACH TO FINANCIAL MODELING
1. Learn how to apply a structured approach to financial modeling in Excel.
2. Understand the many hallmarks that make financial models robust.
3. Use best practice techniques in planning your model structure.
4. Learn how to forecast the income statement from operating revenues down to operating profit.
MODULE 2 - FORECASTING INCOME STATEMENT AND BALANCE SHEET ITEMS
1. Use different approaches to properly forecast operating assets.
2. Learn how to forecast property, plant, equipment, and other operating assets.
3. Learn how to forecast various components of working capital including accounts receivable, inventories, and accounts payable.
MODULE 3 - DEBT AND FINANCING SCHEDULES
1. Learn how to forecast debt financing and related interest costs.
2. Learn how to forecast equity financing and dividends.
3. Use Excel to solve circular references using both iterative and analytic approaches.
MODULE 4 - BUILDING A FREE CASH FLOW FORECAST
1. Understand the importance of incorporating error checks in your financial models.
2. Learn how to derive a forecast cash flow statement based on a forecast income statement and balance sheet.
3. Derive a free cash flow statement that can be used for equity valuation.
Seminar Outline:
Pre-requisite:
Who Will Benefit:
Seminar Leader(s):
Special Notes: Login credentials for this recorded webinar will be sent by e-mail within 2 to 5 business days after registration.
Additional Offerings:
Can't make it to this session? See the other offerings of this seminar.

Terms and Conditions