NEW! Integrated Financial Modeling—Enhancements to the Core Model

Delve deeper into your model’s assumptions by building a detailed depreciation schedule and robust tax schedule, as well as layering on a residual income and EVA analysis. For capital intensive businesses, understand why it is critical to derive a more precise depreciation schedule that flows off capital expenditures assumptions instead of percentage of revenue. Incorporate fundamental factors such as remaining useful life estimates and depreciation of existing net PPE and new CapEx based on weighted average life assumptions into the model. Build a detailed tax schedule incorporating NOLs (net operating losses), limitations on NOL usage (IRS Section 382) and differences between book and tax depreciation. Evaluate a residual income analysis (based on equity cost of capital) and an EVA analysis (based on total capital) instead of the traditional DCF valuation.

Prerequisite: Proficiency using Excel.
Note: Bring your PC laptop with Microsoft Excel installed and a CD-ROM drive. Mac applications may not be as effective.

Also Recommended: Advanced Financial Modeling—Core Model on April 14 is strongly suggested.