Building A Financial Model In Excel - On-demand

Building A Financial Model In Excel - On-demand
CFI is a global provider of online financial training courses with a focus on practical applications. Most courses involve hands on Excel tutorials, which take participants beyond the theory to develop job-based skills. All participants are automatically issued certificates of completion after successfully finishing each course. The price of the course varies and are based on a function of a few criteria including, (1) their duration (CPD hours), (2) level of difficulty, and (3) demand for the topic.


EL19200041

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   
 • Learn how to apply a structured approach to financial modeling in Excel 
 • Understand the many hallmarks that make financial models robust
 • Use best practice techniques in planning your model structure
 • Learn how to forecast the income statement from operating revenues down to operating profit
MODULE 2 - FORECASTING INCOME STATEMENT AND BALANCE SHEET ITEM
 • Use different approaches to properly forecast operating assets
 • Learn how to forecast property, plant, equipment, and other operating assets
 • Learn how to forecast various components of working capital including accounts receivable, inventories, and accounts payable
MODULE 3 - DEBT AND FINANCING SCHEDULES 
 • Learn how to forecast debt financing and related interest costs
 • Learn how to forecast equity financing and dividends
 • Use Excel to solve circular references using both iterative and analytic approaches
MODULE 4 - BUILDING A FREE CASH FLOW FORECAST 
 • Understand the importance of incorporating error checks in your financial models
 • Learn how to derive a forecast cash flow statement based on a forecast income statement and balance sheet
 • Derive a free cash flow statement that can be used for equity valuation

1 Passport Day plus $100 fee - 4 hours
When
4/1/2019 - 3/31/2020
Where
On-line