Purchase Course

Modeling & Projecting Financial Statements   

16

Estimated CPE
Tuition
$1,795.00
Course Number
18-IL-311-EE
Course Leader
Dan Gode
Hotel / Venue Details
View Details
16

Estimated CPE
Tuition
$1,795.00
Course Number
18-IL-311-EE
Course Leader
Dan Gode
Hotel / Venue Details
View Details

Special Discounts

Contact Executive Education for a $500 discount towards registration to both Optimizing Accounting & Finance with Advanced Excel and Modeling & Projecting Financial Statements.

Course Details

Weaving Business Forecasts into Spreadsheet-Based Financial Projections

Modeling financial statements is critical to financial planning and analysis, business development, valuation, and credit risk analysis. This two-day seminar helps accounting and finance professionals weave business and financial forecasts into spreadsheet-based projections of financial statements. It shows you how to break down models into manageable components and explains how the modeling sequence differs from the sequence in which accounting entries are made. It teaches best practices regarding how to integrate knowledge of business drivers, accounting, Excel, finance, and financial programming to produce “well engineered” models.

This seminar assumes that you are familiar with the topics covered in the Optimizing Accounting & Finance with Advanced Excel seminar that precedes this seminar.

Course Agenda

  • Overview: Six key business drivers – Size, growth, margins, asset intensity, business risk, and financial risk; Two major parts of a model – enterprise and financial
  • Best practices: Building models that reflect how management views a business, and are error free, understandable, and easy to update
  • Enterprise activities: Revenues, expenses, and related accruals and deferrals
    • Modeling revenues, receivables, and deferred revenues
    • Modeling expenses, payables, and prepaid costs
    • Modeling multi-period effects: Long-term receivables, deferred revenues, accrued expenses, and deferred expenses (PP&E, intangible assets) 
    • Modeling current and deferred taxes
    • Understanding and forecasting enterprise free cash flows
  • Financial activities: Financial assets, financial liabilities, and equity
    • Deriving funding needs, modeling liquidity, and leverage
    • Cost of capital and risk; Terminal growth and terminal value

Course Leader
Dan Gode, Co-founder, Almaris Consulting and Training

Keywords: Financial Statement Modeling, Financial Planning and Analysis (FP&A), Business Drivers, Projections, Modeling Revenues, Modeling Operating Expenses, Modeling Receivables, Modeling Deferred Revenues, Modeling Payables, Modeling Prepayments, Modeling Inventories, Modeling PP&E, Modeling Taxes, Unlevered Cash Flows, Free Cash Flows, EBITDA, Working Capital, Invested Capital, Efficient Modeling, Accounting

Other Details

Special Notice/Instruction: NASBA Delivery Method: Group Live
Prerequisites: You must bring a laptop with Excel 2010 or above to the seminar. We use Excel 365 in the seminar.
  • The following Excel topics covered in the Optimizing Accounting & Finance with Advanced Excel seminar:
    • Commonly used Excel shortcuts
    • Excel functions: IF, OFFSET, SUMPRODUCT, HLOOKUP, VLOOKUP, INDIRECT, MATCH, INDEX, NPV, XNPV, IRR, XIRR
    • Excel Data Tables (different from Pivot tables)
    • Excel Styles; Custom Formatting, Data Validation, Data Grouping
    • Iterations and circular references
    • Knowledge of Excel VBA is NOT required
  • Working knowledge of indirect cash flows, leases, taxes, and share-based compensation
Preparation: None
Level of Knowledge: Intermediate
Field of Study: Finance
Delivery Method: Seminar
New York, New York
11/21 - 11/22/2019

Weaving Business Forecasts into Spreadsheet-Based Financial Projections

Modeling financial statements is critical to financial planning and analysis, business development, valuation, and credit risk analysis. This two-day seminar helps accounting and finance professionals weave business and financial forecasts into spreadsheet-based projections of financial statements. It shows you how to break down models into manageable components and explains how the modeling sequence differs from the sequence in which accounting entries are made. It teaches best practices regarding how to integrate knowledge of business drivers, accounting, Excel, finance, and financial programming to produce “well engineered” models.

This seminar assumes that you are familiar with the topics covered in the Optimizing Accounting & Finance with Advanced Excel seminar that precedes this seminar.

Course Agenda

  • Overview: Six key business drivers – Size, growth, margins, asset intensity, business risk, and financial risk; Two major parts of a model – enterprise and financial
  • Best practices: Building models that reflect how management views a business, and are error free, understandable, and easy to update
  • Enterprise activities: Revenues, expenses, and related accruals and deferrals
    • Modeling revenues, receivables, and deferred revenues
    • Modeling expenses, payables, and prepaid costs
    • Modeling multi-period effects: Long-term receivables, deferred revenues, accrued expenses, and deferred expenses (PP&E, intangible assets) 
    • Modeling current and deferred taxes
    • Understanding and forecasting enterprise free cash flows
  • Financial activities: Financial assets, financial liabilities, and equity
    • Deriving funding needs, modeling liquidity, and leverage
    • Cost of capital and risk; Terminal growth and terminal value

Course Leader
Dan Gode, Co-founder, Almaris Consulting and Training

Keywords: Financial Statement Modeling, Financial Planning and Analysis (FP&A), Business Drivers, Projections, Modeling Revenues, Modeling Operating Expenses, Modeling Receivables, Modeling Deferred Revenues, Modeling Payables, Modeling Prepayments, Modeling Inventories, Modeling PP&E, Modeling Taxes, Unlevered Cash Flows, Free Cash Flows, EBITDA, Working Capital, Invested Capital, Efficient Modeling, Accounting

Special Notice/Instruction: NASBA Delivery Method: Group Live
Prerequisites: You must bring a laptop with Excel 2010 or above to the seminar. We use Excel 365 in the seminar.
  • The following Excel topics covered in the Optimizing Accounting & Finance with Advanced Excel seminar:
    • Commonly used Excel shortcuts
    • Excel functions: IF, OFFSET, SUMPRODUCT, HLOOKUP, VLOOKUP, INDIRECT, MATCH, INDEX, NPV, XNPV, IRR, XIRR
    • Excel Data Tables (different from Pivot tables)
    • Excel Styles; Custom Formatting, Data Validation, Data Grouping
    • Iterations and circular references
    • Knowledge of Excel VBA is NOT required
  • Working knowledge of indirect cash flows, leases, taxes, and share-based compensation
Preparation: None
Level of Knowledge: Intermediate
Field of Study: Finance
Delivery Method: Seminar

Seminar Brochure

Click to view, download, print
Locations / Dates


New York, New York
11/21 - 11/22/2019


Seminar Brochure

Click to view, download, print