Financial Modeling in Excel

This intensive one-day workshop develops financial modeling skills through the hands-on construction of an interactive financial model. Using a real company as a case study, the lectures will direct participants to blend accounting, corporate finance and Excel skills to create a dynamic, three-statement financial model. The completed product has five years of projections, three years of historical data and supporting schedules including working capital, debt, equity, depreciation and amortization. Other advanced topics include understanding and controlling circularity errors, troubleshooting, sensitivity analysis and discounted cash flow valuations.