Modeling & Projecting Financial Statements

KPMG Executive Education

What are the topics?

KPMG Executive Education

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

About the course

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. This course focuses on breaking down models into manageable components and explains how the modeling sequence differs from the sequence in which accounting entries are made. Best practices regarding how to integrate knowledge of business drivers, accounting, Excel, finance, and financial programming to produce “well engineered” models are also covered.

This seminar assumes that you are familiar with the following topics which are covered in the Optimizing Accounting & Finance with Advanced Excel:

  • 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

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

Experts

Dan Gode

Dan is the founder of Almaris Consulting and Training. He brings in 25 years of extensive experience in consulting and training in accounting, financial statement analysis, business drivers, modeling. valuation, and credit risk analysis. He has worked with over numerous corporations, investment b...

Videos and materials

Modeling & Projecting Financial Statements at KPMG Executive Education

This course has no confirmed dates in the future. Subscribe to be notified when it is offered.


Something went wrong. We're trying to fix this error.

Thank you

Someone from the Coursalytics team will be in touch with you soon.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.