Day 1 - Advanced Three Statement Modeling

Online Price:
$850.00 (You save $345.00)
New York
Start Date(s):

What To Bring

It is important that you bring a laptop (preferably a PC) with Microsoft Excel, Word and PowerPoint, and Adobe Reader installed.

Product Description

Day 1 (am) - Financial Modeling and Forecasting

Participants will learn how to build a three statement model using a detailed revenue forecast with price and volume drivers. A full debt schedule, including a cash sweep, is  incorporated  into the model. In addition to the main class case model, participants are given exercises to help them understand more complex modeling issues (e.g. detailed depreciation schedules and working capital items). Common errors are covered from balancing a non-balancing balance sheet to debugging a model that is non-intentionally circular.

Key topics:

  • Complex 3 statement models
  • Modeling a detailed revenue forecast
  • Modeling a cash sweep
  • modeling a detailed debt schedule include a cash sweep
  • Consolidating and re-applying knowledge of circularity, iteration and a toggle switch
  • Building cash flow statements from scratch
  • Troubleshooting techniques for cash flow statements
  • Finding errors and integrity checking

Day 1 (pm) - Integrity and Error Checking

In reality, more time is wasted trying to find out why your model does not balance than the time you took to build it in the first place. This program focuses on useful tips and tricks that can be used to interrogate the data in financial models and useful methods for finding errors quickly. It will also provide tips and tricks to reduce errors in the first place.

Key topics:

  • Understanding the keys to integrity and efficiency in modeling
    • The importance of matrix integrity
    • Building copyable formulas where possible
    • Sanity checking
    • Matrix integrity checking
    • Stress testing
  • Debugging models
  • Using Excel tools to help with integrity checking
  • Finding unidentified hard numbers quickly and easily
  • Using Excel’s “Jump tool” to trace through formulas with ease
  • Using Excel to show the formulas underlying output
  • Using Excel to find inconsistencies in the model
  • Using Excel’s auditing tool to trace formulas
  • Dealing with circular references
    • Finding unintentional circularities
    • Sorting out model “blow-ups” caused by iteration and circularities
    • Protecting the model from “blow-ups” using “circularity” switches
    • Using Excel’s circular reference toolbar
    • Circularity macros
  • Error diagnostics
  • Using a series of 16 models with one error in each, participants will go through the most time efficient process for error diagnosis
  • Participants will be given a full model with many errors and will use the “Balance Sheet check” method to quickly find the reasons why the balance sheet is not balancing

Find Similar Products by Category

Bookmark and Share

You Recently Viewed...

Premium SSL Certificate