Financial Modeling in Excel

This one-day seminar, conducted by Training The Street, explores best practices and efficient techniques for building finance-related spreadsheets.

The lectures will use a real company as a case study and 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.

The course is best suited for students with exposure to basic accounting and corporate finance concepts. It stresses efficiency in using Excel and awareness of common pitfalls when developing financial models.